Symfony Profiler

Query Metrics

65 Database Queries

18 Different statements

133.91 ms Query time

0 Invalid entities

70 Managed entities

Queries


SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.cep AS cep_4, t0.creation_time AS creation_time_5, t0.description AS description_6, t0.status AS status_7, t0.logo AS logo_8, t0.favicon AS favicon_9, t0.shipping AS shipping_10, t0.payment_gateway AS payment_gateway_11, t0.free_shipping AS free_shipping_12, t0.phone AS phone_13, t0.address_full AS address_full_14, t0.public_email AS public_email_15, t0.cnpj AS cnpj_16, t0.ie AS ie_17, t0.color_one AS color_one_18, t0.w_frete_token AS w_frete_token_19, t0.plan_id AS plan_id_20 FROM store t0 WHERE t0.url = ? LIMIT 1
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ?
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ?
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ?
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ?
SELECT t0.id AS id_1, t0.product_limit AS product_limit_2, t0.sale_fee AS sale_fee_3, t0.price_monthly AS price_monthly_4, t0.title AS title_5, t0.integrations AS integrations_6 FROM plan t0 WHERE t0.id = ?
SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ INNER JOIN product_variation p1_ WHERE p1_.product_id = p0_.id AND p0_.store_id = ? AND p1_.stock > 0 AND p0_.status = ? GROUP BY p0_.id LIMIT 25
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.bottom_menu AS bottom_menu_3, b0_.store_id AS store_id_4 FROM brand b0_ WHERE b0_.bottom_menu = 1 AND b0_.store_id = ? ORDER BY b0_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.store_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.free_shipping AS free_shipping_3, t0.slug AS slug_4, t0.status AS status_5, t0.gtin AS gtin_6, t0.description AS description_7, t0.weight AS weight_8, t0.height AS height_9, t0.width AS width_10, t0.depth AS depth_11, t0.sku AS sku_12, t0.store_id AS store_id_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.cep AS cep_4, t0.creation_time AS creation_time_5, t0.description AS description_6, t0.status AS status_7, t0.logo AS logo_8, t0.favicon AS favicon_9, t0.shipping AS shipping_10, t0.payment_gateway AS payment_gateway_11, t0.free_shipping AS free_shipping_12, t0.phone AS phone_13, t0.address_full AS address_full_14, t0.public_email AS public_email_15, t0.cnpj AS cnpj_16, t0.ie AS ie_17, t0.color_one AS color_one_18, t0.w_frete_token AS w_frete_token_19, t0.plan_id AS plan_id_20 FROM store t0 WHERE t0.url = ? LIMIT 1
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ?
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ?
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ?
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ?
SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ INNER JOIN product_variation p1_ WHERE p1_.product_id = p0_.id AND p0_.store_id = ? AND p1_.stock > 0 AND p0_.status = ? GROUP BY p0_.id LIMIT 25
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.bottom_menu AS bottom_menu_3, b0_.store_id AS store_id_4 FROM brand b0_ WHERE b0_.bottom_menu = 1 AND b0_.store_id = ? ORDER BY b0_.name ASC
SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.featured AS featured_4, t0.store_id AS store_id_5 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.featured AS featured_4, t0.store_id AS store_id_5 FROM category t0 WHERE t0.store_id = ? AND t0.name = ? LIMIT 1
SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.category_id AS category_id_4 FROM sub_category t0 WHERE t0.category_id = ?
SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ WHERE p0_.store_id = ? AND p0_.status = ? AND (p0_.category_id = ? OR p0_.sub_category_id IN (NULL)) LIMIT 40
SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.product_variation_id AS product_variation_id_4, t0.attribute_id AS attribute_id_5 FROM product_attribute t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.page_body AS page_body_4, t0.store_id AS store_id_5 FROM page t0 WHERE t0.store_id = ?

#▲	Time	Info
1	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.cep AS cep_4, t0.creation_time AS creation_time_5, t0.description AS description_6, t0.status AS status_7, t0.logo AS logo_8, t0.favicon AS favicon_9, t0.shipping AS shipping_10, t0.payment_gateway AS payment_gateway_11, t0.free_shipping AS free_shipping_12, t0.phone AS phone_13, t0.address_full AS address_full_14, t0.public_email AS public_email_15, t0.cnpj AS cnpj_16, t0.ie AS ie_17, t0.color_one AS color_one_18, t0.w_frete_token AS w_frete_token_19, t0.plan_id AS plan_id_20 FROM store t0 WHERE t0.url = ? LIMIT 1 Parameters: [`"loja.porkao.com.br"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.cep AS cep_4, t0.creation_time AS creation_time_5, t0.description AS description_6, t0.status AS status_7, t0.logo AS logo_8, t0.favicon AS favicon_9, t0.shipping AS shipping_10, t0.payment_gateway AS payment_gateway_11, t0.free_shipping AS free_shipping_12, t0.phone AS phone_13, t0.address_full AS address_full_14, t0.public_email AS public_email_15, t0.cnpj AS cnpj_16, t0.ie AS ie_17, t0.color_one AS color_one_18, t0.w_frete_token AS w_frete_token_19, t0.plan_id AS plan_id_20 FROM store t0 WHERE t0.url = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.cep AS cep_4, t0.creation_time AS creation_time_5, t0.description AS description_6, t0.status AS status_7, t0.logo AS logo_8, t0.favicon AS favicon_9, t0.shipping AS shipping_10, t0.payment_gateway AS payment_gateway_11, t0.free_shipping AS free_shipping_12, t0.phone AS phone_13, t0.address_full AS address_full_14, t0.public_email AS public_email_15, t0.cnpj AS cnpj_16, t0.ie AS ie_17, t0.color_one AS color_one_18, t0.w_frete_token AS w_frete_token_19, t0.plan_id AS plan_id_20 FROM store t0 WHERE t0.url = 'loja.porkao.com.br' LIMIT 1;
2	0.51 ms	SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? Parameters: [`2 2`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = 2 AND b0_.store_id = 2;
3	0.32 ms	SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? Parameters: [`3 2`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = 3 AND b0_.store_id = 2;
4	0.33 ms	SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? Parameters: [`4 2`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = 4 AND b0_.store_id = 2;
5	0.26 ms	SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? Parameters: [`1 2`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = 1 AND b0_.store_id = 2;
6	0.22 ms	SELECT t0.id AS id_1, t0.product_limit AS product_limit_2, t0.sale_fee AS sale_fee_3, t0.price_monthly AS price_monthly_4, t0.title AS title_5, t0.integrations AS integrations_6 FROM plan t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.product_limit AS product_limit_2, t0.sale_fee AS sale_fee_3, t0.price_monthly AS price_monthly_4, t0.title AS title_5, t0.integrations AS integrations_6 FROM plan t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.product_limit AS product_limit_2, t0.sale_fee AS sale_fee_3, t0.price_monthly AS price_monthly_4, t0.title AS title_5, t0.integrations AS integrations_6 FROM plan t0 WHERE t0.id = 1;
7	0.21 ms	SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49 Parameters: [`1 2`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49 SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = 1 AND p0_.store_id = 2 LIMIT 1 OFFSET 49;
8	0.50 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ INNER JOIN product_variation p1_ WHERE p1_.product_id = p0_.id AND p0_.store_id = ? AND p1_.stock > 0 AND p0_.status = ? GROUP BY p0_.id LIMIT 25 Parameters: [`2 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ INNER JOIN product_variation p1_ WHERE p1_.product_id = p0_.id AND p0_.store_id = ? AND p1_.stock > 0 AND p0_.status = ? GROUP BY p0_.id LIMIT 25 SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ INNER JOIN product_variation p1_ WHERE p1_.product_id = p0_.id AND p0_.store_id = 2 AND p1_.stock > 0 AND p0_.status = 1 GROUP BY p0_.id LIMIT 25;
9	0.37 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"google_analytics" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'google_analytics' AND t0.store_id = 2 LIMIT 1;
10	3.28 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_description" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_description' AND t0.store_id = 2 LIMIT 1;
11	0.32 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_title" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_title' AND t0.store_id = 2 LIMIT 1;
12	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_script_head" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_script_head' AND t0.store_id = 2 LIMIT 1;
13	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_script_body" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_script_body' AND t0.store_id = 2 LIMIT 1;
14	0.20 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"sale_notice_email" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'sale_notice_email' AND t0.store_id = 2 LIMIT 1;
15	0.20 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_script_head_purchase_success" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_script_head_purchase_success' AND t0.store_id = 2 LIMIT 1;
16	0.22 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"google_ads" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'google_ads' AND t0.store_id = 2 LIMIT 1;
17	0.21 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_script_head_tag_manager" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_script_head_tag_manager' AND t0.store_id = 2 LIMIT 1;
18	0.17 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_script_body_tag_manager" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_script_body_tag_manager' AND t0.store_id = 2 LIMIT 1;
19	0.35 ms	SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.bottom_menu AS bottom_menu_3, b0_.store_id AS store_id_4 FROM brand b0_ WHERE b0_.bottom_menu = 1 AND b0_.store_id = ? ORDER BY b0_.name ASC Parameters: [`2`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.bottom_menu AS bottom_menu_3, b0_.store_id AS store_id_4 FROM brand b0_ WHERE b0_.bottom_menu = 1 AND b0_.store_id = ? ORDER BY b0_.name ASC SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.bottom_menu AS bottom_menu_3, b0_.store_id AS store_id_4 FROM brand b0_ WHERE b0_.bottom_menu = 1 AND b0_.store_id = 2 ORDER BY b0_.name ASC;
20	0.29 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.store_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.store_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.store_id = 2;
21	49.14 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.free_shipping AS free_shipping_3, t0.slug AS slug_4, t0.status AS status_5, t0.gtin AS gtin_6, t0.description AS description_7, t0.weight AS weight_8, t0.height AS height_9, t0.width AS width_10, t0.depth AS depth_11, t0.sku AS sku_12, t0.store_id AS store_id_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"Pururuca-Semi-Pronta"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.free_shipping AS free_shipping_3, t0.slug AS slug_4, t0.status AS status_5, t0.gtin AS gtin_6, t0.description AS description_7, t0.weight AS weight_8, t0.height AS height_9, t0.width AS width_10, t0.depth AS depth_11, t0.sku AS sku_12, t0.store_id AS store_id_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.free_shipping AS free_shipping_3, t0.slug AS slug_4, t0.status AS status_5, t0.gtin AS gtin_6, t0.description AS description_7, t0.weight AS weight_8, t0.height AS height_9, t0.width AS width_10, t0.depth AS depth_11, t0.sku AS sku_12, t0.store_id AS store_id_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15, t0.brand_id AS brand_id_16 FROM product t0 WHERE t0.slug = 'Pururuca-Semi-Pronta' LIMIT 1;
22	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.cep AS cep_4, t0.creation_time AS creation_time_5, t0.description AS description_6, t0.status AS status_7, t0.logo AS logo_8, t0.favicon AS favicon_9, t0.shipping AS shipping_10, t0.payment_gateway AS payment_gateway_11, t0.free_shipping AS free_shipping_12, t0.phone AS phone_13, t0.address_full AS address_full_14, t0.public_email AS public_email_15, t0.cnpj AS cnpj_16, t0.ie AS ie_17, t0.color_one AS color_one_18, t0.w_frete_token AS w_frete_token_19, t0.plan_id AS plan_id_20 FROM store t0 WHERE t0.url = ? LIMIT 1 Parameters: [`"loja.porkao.com.br"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.cep AS cep_4, t0.creation_time AS creation_time_5, t0.description AS description_6, t0.status AS status_7, t0.logo AS logo_8, t0.favicon AS favicon_9, t0.shipping AS shipping_10, t0.payment_gateway AS payment_gateway_11, t0.free_shipping AS free_shipping_12, t0.phone AS phone_13, t0.address_full AS address_full_14, t0.public_email AS public_email_15, t0.cnpj AS cnpj_16, t0.ie AS ie_17, t0.color_one AS color_one_18, t0.w_frete_token AS w_frete_token_19, t0.plan_id AS plan_id_20 FROM store t0 WHERE t0.url = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.cep AS cep_4, t0.creation_time AS creation_time_5, t0.description AS description_6, t0.status AS status_7, t0.logo AS logo_8, t0.favicon AS favicon_9, t0.shipping AS shipping_10, t0.payment_gateway AS payment_gateway_11, t0.free_shipping AS free_shipping_12, t0.phone AS phone_13, t0.address_full AS address_full_14, t0.public_email AS public_email_15, t0.cnpj AS cnpj_16, t0.ie AS ie_17, t0.color_one AS color_one_18, t0.w_frete_token AS w_frete_token_19, t0.plan_id AS plan_id_20 FROM store t0 WHERE t0.url = 'loja.porkao.com.br' LIMIT 1;
23	0.22 ms	SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? Parameters: [`2 2`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = 2 AND b0_.store_id = 2;
24	0.23 ms	SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? Parameters: [`3 2`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = 3 AND b0_.store_id = 2;
25	0.37 ms	SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? Parameters: [`4 2`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = 4 AND b0_.store_id = 2;
26	0.39 ms	SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? Parameters: [`1 2`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ? SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = 1 AND b0_.store_id = 2;
27	0.22 ms	SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49 Parameters: [`1 2`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49 SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = 1 AND p0_.store_id = 2 LIMIT 1 OFFSET 49;
28	0.28 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ INNER JOIN product_variation p1_ WHERE p1_.product_id = p0_.id AND p0_.store_id = ? AND p1_.stock > 0 AND p0_.status = ? GROUP BY p0_.id LIMIT 25 Parameters: [`2 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ INNER JOIN product_variation p1_ WHERE p1_.product_id = p0_.id AND p0_.store_id = ? AND p1_.stock > 0 AND p0_.status = ? GROUP BY p0_.id LIMIT 25 SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ INNER JOIN product_variation p1_ WHERE p1_.product_id = p0_.id AND p0_.store_id = 2 AND p1_.stock > 0 AND p0_.status = 1 GROUP BY p0_.id LIMIT 25;
29	5.46 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"google_analytics" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'google_analytics' AND t0.store_id = 2 LIMIT 1;
30	0.29 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_description" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_description' AND t0.store_id = 2 LIMIT 1;
31	3.36 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_title" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_title' AND t0.store_id = 2 LIMIT 1;
32	0.30 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_script_head" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_script_head' AND t0.store_id = 2 LIMIT 1;
33	0.16 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_script_body" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_script_body' AND t0.store_id = 2 LIMIT 1;
34	0.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"sale_notice_email" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'sale_notice_email' AND t0.store_id = 2 LIMIT 1;
35	0.21 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_script_head_purchase_success" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_script_head_purchase_success' AND t0.store_id = 2 LIMIT 1;
36	0.13 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"google_ads" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'google_ads' AND t0.store_id = 2 LIMIT 1;
37	0.13 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_script_head_tag_manager" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_script_head_tag_manager' AND t0.store_id = 2 LIMIT 1;
38	0.18 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 Parameters: [`"seo_script_body_tag_manager" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = 'seo_script_body_tag_manager' AND t0.store_id = 2 LIMIT 1;
39	0.23 ms	SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.bottom_menu AS bottom_menu_3, b0_.store_id AS store_id_4 FROM brand b0_ WHERE b0_.bottom_menu = 1 AND b0_.store_id = ? ORDER BY b0_.name ASC Parameters: [`2`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.bottom_menu AS bottom_menu_3, b0_.store_id AS store_id_4 FROM brand b0_ WHERE b0_.bottom_menu = 1 AND b0_.store_id = ? ORDER BY b0_.name ASC SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.bottom_menu AS bottom_menu_3, b0_.store_id AS store_id_4 FROM brand b0_ WHERE b0_.bottom_menu = 1 AND b0_.store_id = 2 ORDER BY b0_.name ASC;
40	0.67 ms	SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49 Parameters: [`1 2`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49 SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = 1 AND p0_.store_id = 2 LIMIT 1 OFFSET 49;
41	7.79 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.featured AS featured_4, t0.store_id AS store_id_5 FROM category t0 WHERE t0.id = ? Parameters: [`32`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.featured AS featured_4, t0.store_id AS store_id_5 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.featured AS featured_4, t0.store_id AS store_id_5 FROM category t0 WHERE t0.id = 32;
42	0.36 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.featured AS featured_4, t0.store_id AS store_id_5 FROM category t0 WHERE t0.store_id = ? AND t0.name = ? LIMIT 1 Parameters: [`2 "Semi-pronta"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.featured AS featured_4, t0.store_id AS store_id_5 FROM category t0 WHERE t0.store_id = ? AND t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.featured AS featured_4, t0.store_id AS store_id_5 FROM category t0 WHERE t0.store_id = 2 AND t0.name = 'Semi-pronta' LIMIT 1;
43	0.28 ms	SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49 Parameters: [`1 2`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 49 SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = 1 AND p0_.store_id = 2 LIMIT 1 OFFSET 49;
44	0.17 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.category_id AS category_id_4 FROM sub_category t0 WHERE t0.category_id = ? Parameters: [`32`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.category_id AS category_id_4 FROM sub_category t0 WHERE t0.category_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.category_id AS category_id_4 FROM sub_category t0 WHERE t0.category_id = 32;
45	0.83 ms	SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ WHERE p0_.store_id = ? AND p0_.status = ? AND (p0_.category_id = ? OR p0_.sub_category_id IN (NULL)) LIMIT 40 Parameters: [`2 1 32`] View formatted query View runnable query Explain query SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ WHERE p0_.store_id = ? AND p0_.status = ? AND ( p0_.category_id = ? OR p0_.sub_category_id IN (NULL) ) LIMIT 40 SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ WHERE p0_.store_id = 2 AND p0_.status = 1 AND (p0_.category_id = 32 OR p0_.sub_category_id IN (NULL)) LIMIT 40;
46	12.50 ms	SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? Parameters: [`437`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = 437;
47	4.71 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? Parameters: [`437`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = 437;
48	4.91 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? Parameters: [`450`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = 450;
49	1.85 ms	SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? Parameters: [`450`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = 450;
50	0.49 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? Parameters: [`451`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = 451;
51	4.30 ms	SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? Parameters: [`451`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = 451;
52	0.32 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? Parameters: [`452`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = 452;
53	0.20 ms	SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? Parameters: [`452`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = 452;
54	0.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? Parameters: [`453`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = 453;
55	1.90 ms	SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? Parameters: [`453`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = 453;
56	4.00 ms	SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.product_variation_id AS product_variation_id_4, t0.attribute_id AS attribute_id_5 FROM product_attribute t0 WHERE t0.product_id = ? Parameters: [`437`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.product_variation_id AS product_variation_id_4, t0.attribute_id AS attribute_id_5 FROM product_attribute t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.product_variation_id AS product_variation_id_4, t0.attribute_id AS attribute_id_5 FROM product_attribute t0 WHERE t0.product_id = 437;
57	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = 17;
58	5.21 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ? Parameters: [`15`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = 15;
59	0.38 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ? Parameters: [`35`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = 35;
60	1.46 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ? Parameters: [`34`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.store_id AS store_id_3 FROM attribute t0 WHERE t0.id = 34;
61	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? Parameters: [`455`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = 455;
62	0.55 ms	SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? Parameters: [`455`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = 455;
63	3.62 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? Parameters: [`456`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.product_id = 456;
64	0.30 ms	SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? Parameters: [`456`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.path AS path_2, t0.highlight AS highlight_3, t0.image_kit_id AS image_kit_id_4, t0.product_id AS product_id_5 FROM product_images t0 WHERE t0.product_id = 456;
65	5.45 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.page_body AS page_body_4, t0.store_id AS store_id_5 FROM page t0 WHERE t0.store_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.page_body AS page_body_4, t0.store_id AS store_id_5 FROM page t0 WHERE t0.store_id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.page_body AS page_body_4, t0.store_id AS store_id_5 FROM page t0 WHERE t0.store_id = 2;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Product	15
App\Entity\ProductImages	14
App\Entity\Configuration	11
App\Entity\ProductVariation	8
App\Entity\Banner	7
App\Entity\ProductAttribute	4
App\Entity\Attribute	4
App\Entity\Category	2
App\Entity\Page	2
App\Entity\Store	1
App\Entity\Plan	1
App\Entity\Brand	1

Entities Mapping

Class	Mapping errors
App\Entity\Store	No errors.
App\Entity\Plan	No errors.
App\Entity\User	No errors.
App\Entity\Product	No errors.
App\Entity\Purchase	No errors.
App\Entity\Configuration	No errors.
App\Entity\StorePayment	No errors.
App\Entity\Attribute	No errors.
App\Entity\Category	No errors.
App\Entity\Banner	No errors.
App\Entity\Brand	No errors.
App\Entity\Page	No errors.
App\Entity\StoreFaq	No errors.
App\Entity\NewsLetter	No errors.
App\Entity\ExceptionLog	No errors.
App\Entity\StoreStatusLog	No errors.
App\Entity\Notification	No errors.
App\Entity\ProductVariation	No errors.
App\Entity\SubCategory	No errors.
App\Entity\ProductAttribute	No errors.
App\Entity\ProductImages	No errors.
App\Entity\PurchaseProduct	No errors.

Symfony Profiler

GET https://loja.porkao.com.br/produto/Pururuca-Semi-Pronta

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping