Symfony Profiler

Query Metrics

61 Database Queries

13 Different statements

1130.78 ms Query time

0 Invalid entities

42 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.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 t0.id AS id_1, t0.shipping_value AS shipping_value_2, t0.shipping AS shipping_3, t0.comment AS comment_4, t0.transaction_code AS transaction_code_5, t0.payment_link AS payment_link_6, t0.payment_gateway AS payment_gateway_7, t0.order_value AS order_value_8, t0.cep AS cep_9, t0.address AS address_10, t0.address_number AS address_number_11, t0.address_complement AS address_complement_12, t0.session AS session_13, t0.ip AS ip_14, t0.browser AS browser_15, t0.cpf AS cpf_16, t0.phone AS phone_17, t0.installments AS installments_18, t0.installment_value AS installment_value_19, t0.city AS city_20, t0.state AS state_21, t0.status AS status_22, t0.purchase_date AS purchase_date_23, t0.name AS name_24, t0.district AS district_25, t0.purchase_code AS purchase_code_26, t0.recipient_name AS recipient_name_27, t0.extra_info AS extra_info_28, t0.billing_cep AS billing_cep_29, t0.billing_address AS billing_address_30, t0.billing_address_number AS billing_address_number_31, t0.billing_address_complement AS billing_address_complement_32, t0.billing_district AS billing_district_33, t0.billing_city AS billing_city_34, t0.billing_state AS billing_state_35, t0.invoice AS invoice_36, t0.invoice_image_kit_id AS invoice_image_kit_id_37, t0.payment_method AS payment_method_38, t0.tracking_code AS tracking_code_39, t0.store_id AS store_id_40, t0.buyer_id AS buyer_id_41 FROM purchase t0 WHERE t0.session = ? ORDER BY t0.id DESC LIMIT 1
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.product_name AS product_name_4, t0.product_variation_id AS product_variation_id_5, t0.purchase_id AS purchase_id_6 FROM purchase_product t0 WHERE t0.purchase_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.id = ?
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 t0.id AS id_1, t0.shipping_value AS shipping_value_2, t0.shipping AS shipping_3, t0.comment AS comment_4, t0.transaction_code AS transaction_code_5, t0.payment_link AS payment_link_6, t0.payment_gateway AS payment_gateway_7, t0.order_value AS order_value_8, t0.cep AS cep_9, t0.address AS address_10, t0.address_number AS address_number_11, t0.address_complement AS address_complement_12, t0.session AS session_13, t0.ip AS ip_14, t0.browser AS browser_15, t0.cpf AS cpf_16, t0.phone AS phone_17, t0.installments AS installments_18, t0.installment_value AS installment_value_19, t0.city AS city_20, t0.state AS state_21, t0.status AS status_22, t0.purchase_date AS purchase_date_23, t0.name AS name_24, t0.district AS district_25, t0.purchase_code AS purchase_code_26, t0.recipient_name AS recipient_name_27, t0.extra_info AS extra_info_28, t0.billing_cep AS billing_cep_29, t0.billing_address AS billing_address_30, t0.billing_address_number AS billing_address_number_31, t0.billing_address_complement AS billing_address_complement_32, t0.billing_district AS billing_district_33, t0.billing_city AS billing_city_34, t0.billing_state AS billing_state_35, t0.invoice AS invoice_36, t0.invoice_image_kit_id AS invoice_image_kit_id_37, t0.payment_method AS payment_method_38, t0.tracking_code AS tracking_code_39, t0.store_id AS store_id_40, t0.buyer_id AS buyer_id_41 FROM purchase t0 WHERE t0.session = ? LIMIT 1
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	2.07 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	13.59 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	3.38 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	4.09 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	15.70 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	6.47 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	7.08 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	29.80 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	29.93 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	0.81 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	1.41 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.59 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	1.33 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	1.57 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	9.48 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	6.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;
17	5.01 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	2.83 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	10.59 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	7.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.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	11.20 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;
22	7.50 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;
23	11.46 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;
24	7.91 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;
25	7.46 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;
26	3.43 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;
27	7.26 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;
28	3.72 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;
29	5.40 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;
30	13.50 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;
31	4.80 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;
32	0.68 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;
33	1.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: [`"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;
34	2.70 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;
35	9.78 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;
36	2.64 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;
37	5.50 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;
38	10.20 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;
39	10.23 ms	SELECT t0.id AS id_1, t0.shipping_value AS shipping_value_2, t0.shipping AS shipping_3, t0.comment AS comment_4, t0.transaction_code AS transaction_code_5, t0.payment_link AS payment_link_6, t0.payment_gateway AS payment_gateway_7, t0.order_value AS order_value_8, t0.cep AS cep_9, t0.address AS address_10, t0.address_number AS address_number_11, t0.address_complement AS address_complement_12, t0.session AS session_13, t0.ip AS ip_14, t0.browser AS browser_15, t0.cpf AS cpf_16, t0.phone AS phone_17, t0.installments AS installments_18, t0.installment_value AS installment_value_19, t0.city AS city_20, t0.state AS state_21, t0.status AS status_22, t0.purchase_date AS purchase_date_23, t0.name AS name_24, t0.district AS district_25, t0.purchase_code AS purchase_code_26, t0.recipient_name AS recipient_name_27, t0.extra_info AS extra_info_28, t0.billing_cep AS billing_cep_29, t0.billing_address AS billing_address_30, t0.billing_address_number AS billing_address_number_31, t0.billing_address_complement AS billing_address_complement_32, t0.billing_district AS billing_district_33, t0.billing_city AS billing_city_34, t0.billing_state AS billing_state_35, t0.invoice AS invoice_36, t0.invoice_image_kit_id AS invoice_image_kit_id_37, t0.payment_method AS payment_method_38, t0.tracking_code AS tracking_code_39, t0.store_id AS store_id_40, t0.buyer_id AS buyer_id_41 FROM purchase t0 WHERE t0.session = ? ORDER BY t0.id DESC LIMIT 1 Parameters: [`"6966ee90e9cc61768353424"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.shipping_value AS shipping_value_2, t0.shipping AS shipping_3, t0.comment AS comment_4, t0.transaction_code AS transaction_code_5, t0.payment_link AS payment_link_6, t0.payment_gateway AS payment_gateway_7, t0.order_value AS order_value_8, t0.cep AS cep_9, t0.address AS address_10, t0.address_number AS address_number_11, t0.address_complement AS address_complement_12, t0.session AS session_13, t0.ip AS ip_14, t0.browser AS browser_15, t0.cpf AS cpf_16, t0.phone AS phone_17, t0.installments AS installments_18, t0.installment_value AS installment_value_19, t0.city AS city_20, t0.state AS state_21, t0.status AS status_22, t0.purchase_date AS purchase_date_23, t0.name AS name_24, t0.district AS district_25, t0.purchase_code AS purchase_code_26, t0.recipient_name AS recipient_name_27, t0.extra_info AS extra_info_28, t0.billing_cep AS billing_cep_29, t0.billing_address AS billing_address_30, t0.billing_address_number AS billing_address_number_31, t0.billing_address_complement AS billing_address_complement_32, t0.billing_district AS billing_district_33, t0.billing_city AS billing_city_34, t0.billing_state AS billing_state_35, t0.invoice AS invoice_36, t0.invoice_image_kit_id AS invoice_image_kit_id_37, t0.payment_method AS payment_method_38, t0.tracking_code AS tracking_code_39, t0.store_id AS store_id_40, t0.buyer_id AS buyer_id_41 FROM purchase t0 WHERE t0.session = ? ORDER BY t0.id DESC LIMIT 1 SELECT t0.id AS id_1, t0.shipping_value AS shipping_value_2, t0.shipping AS shipping_3, t0.comment AS comment_4, t0.transaction_code AS transaction_code_5, t0.payment_link AS payment_link_6, t0.payment_gateway AS payment_gateway_7, t0.order_value AS order_value_8, t0.cep AS cep_9, t0.address AS address_10, t0.address_number AS address_number_11, t0.address_complement AS address_complement_12, t0.session AS session_13, t0.ip AS ip_14, t0.browser AS browser_15, t0.cpf AS cpf_16, t0.phone AS phone_17, t0.installments AS installments_18, t0.installment_value AS installment_value_19, t0.city AS city_20, t0.state AS state_21, t0.status AS status_22, t0.purchase_date AS purchase_date_23, t0.name AS name_24, t0.district AS district_25, t0.purchase_code AS purchase_code_26, t0.recipient_name AS recipient_name_27, t0.extra_info AS extra_info_28, t0.billing_cep AS billing_cep_29, t0.billing_address AS billing_address_30, t0.billing_address_number AS billing_address_number_31, t0.billing_address_complement AS billing_address_complement_32, t0.billing_district AS billing_district_33, t0.billing_city AS billing_city_34, t0.billing_state AS billing_state_35, t0.invoice AS invoice_36, t0.invoice_image_kit_id AS invoice_image_kit_id_37, t0.payment_method AS payment_method_38, t0.tracking_code AS tracking_code_39, t0.store_id AS store_id_40, t0.buyer_id AS buyer_id_41 FROM purchase t0 WHERE t0.session = '6966ee90e9cc61768353424' ORDER BY t0.id DESC LIMIT 1;
40	35.10 ms	SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.product_name AS product_name_4, t0.product_variation_id AS product_variation_id_5, t0.purchase_id AS purchase_id_6 FROM purchase_product t0 WHERE t0.purchase_id = ? Parameters: [`30095`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.product_name AS product_name_4, t0.product_variation_id AS product_variation_id_5, t0.purchase_id AS purchase_id_6 FROM purchase_product t0 WHERE t0.purchase_id = ? SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.product_name AS product_name_4, t0.product_variation_id AS product_variation_id_5, t0.purchase_id AS purchase_id_6 FROM purchase_product t0 WHERE t0.purchase_id = 30095;
41	15.05 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.id = ? Parameters: [`648`] 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.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.id = 648;
42	31.31 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;
43	22.62 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;
44	7.57 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;
45	8.47 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;
46	7.00 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;
47	7.04 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;
48	15.71 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;
49	27.33 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;
50	5.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_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;
51	5.53 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;
52	8.56 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;
53	3.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_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;
54	8.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: [`"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;
55	15.12 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;
56	16.47 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;
57	6.43 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;
58	12.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_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;
59	7.29 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;
60	575.15 ms	SELECT t0.id AS id_1, t0.shipping_value AS shipping_value_2, t0.shipping AS shipping_3, t0.comment AS comment_4, t0.transaction_code AS transaction_code_5, t0.payment_link AS payment_link_6, t0.payment_gateway AS payment_gateway_7, t0.order_value AS order_value_8, t0.cep AS cep_9, t0.address AS address_10, t0.address_number AS address_number_11, t0.address_complement AS address_complement_12, t0.session AS session_13, t0.ip AS ip_14, t0.browser AS browser_15, t0.cpf AS cpf_16, t0.phone AS phone_17, t0.installments AS installments_18, t0.installment_value AS installment_value_19, t0.city AS city_20, t0.state AS state_21, t0.status AS status_22, t0.purchase_date AS purchase_date_23, t0.name AS name_24, t0.district AS district_25, t0.purchase_code AS purchase_code_26, t0.recipient_name AS recipient_name_27, t0.extra_info AS extra_info_28, t0.billing_cep AS billing_cep_29, t0.billing_address AS billing_address_30, t0.billing_address_number AS billing_address_number_31, t0.billing_address_complement AS billing_address_complement_32, t0.billing_district AS billing_district_33, t0.billing_city AS billing_city_34, t0.billing_state AS billing_state_35, t0.invoice AS invoice_36, t0.invoice_image_kit_id AS invoice_image_kit_id_37, t0.payment_method AS payment_method_38, t0.tracking_code AS tracking_code_39, t0.store_id AS store_id_40, t0.buyer_id AS buyer_id_41 FROM purchase t0 WHERE t0.session = ? LIMIT 1 Parameters: [`"6966ee90e9cc61768353424"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.shipping_value AS shipping_value_2, t0.shipping AS shipping_3, t0.comment AS comment_4, t0.transaction_code AS transaction_code_5, t0.payment_link AS payment_link_6, t0.payment_gateway AS payment_gateway_7, t0.order_value AS order_value_8, t0.cep AS cep_9, t0.address AS address_10, t0.address_number AS address_number_11, t0.address_complement AS address_complement_12, t0.session AS session_13, t0.ip AS ip_14, t0.browser AS browser_15, t0.cpf AS cpf_16, t0.phone AS phone_17, t0.installments AS installments_18, t0.installment_value AS installment_value_19, t0.city AS city_20, t0.state AS state_21, t0.status AS status_22, t0.purchase_date AS purchase_date_23, t0.name AS name_24, t0.district AS district_25, t0.purchase_code AS purchase_code_26, t0.recipient_name AS recipient_name_27, t0.extra_info AS extra_info_28, t0.billing_cep AS billing_cep_29, t0.billing_address AS billing_address_30, t0.billing_address_number AS billing_address_number_31, t0.billing_address_complement AS billing_address_complement_32, t0.billing_district AS billing_district_33, t0.billing_city AS billing_city_34, t0.billing_state AS billing_state_35, t0.invoice AS invoice_36, t0.invoice_image_kit_id AS invoice_image_kit_id_37, t0.payment_method AS payment_method_38, t0.tracking_code AS tracking_code_39, t0.store_id AS store_id_40, t0.buyer_id AS buyer_id_41 FROM purchase t0 WHERE t0.session = ? LIMIT 1 SELECT t0.id AS id_1, t0.shipping_value AS shipping_value_2, t0.shipping AS shipping_3, t0.comment AS comment_4, t0.transaction_code AS transaction_code_5, t0.payment_link AS payment_link_6, t0.payment_gateway AS payment_gateway_7, t0.order_value AS order_value_8, t0.cep AS cep_9, t0.address AS address_10, t0.address_number AS address_number_11, t0.address_complement AS address_complement_12, t0.session AS session_13, t0.ip AS ip_14, t0.browser AS browser_15, t0.cpf AS cpf_16, t0.phone AS phone_17, t0.installments AS installments_18, t0.installment_value AS installment_value_19, t0.city AS city_20, t0.state AS state_21, t0.status AS status_22, t0.purchase_date AS purchase_date_23, t0.name AS name_24, t0.district AS district_25, t0.purchase_code AS purchase_code_26, t0.recipient_name AS recipient_name_27, t0.extra_info AS extra_info_28, t0.billing_cep AS billing_cep_29, t0.billing_address AS billing_address_30, t0.billing_address_number AS billing_address_number_31, t0.billing_address_complement AS billing_address_complement_32, t0.billing_district AS billing_district_33, t0.billing_city AS billing_city_34, t0.billing_state AS billing_state_35, t0.invoice AS invoice_36, t0.invoice_image_kit_id AS invoice_image_kit_id_37, t0.payment_method AS payment_method_38, t0.tracking_code AS tracking_code_39, t0.store_id AS store_id_40, t0.buyer_id AS buyer_id_41 FROM purchase t0 WHERE t0.session = '6966ee90e9cc61768353424' LIMIT 1;
61	4.34 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	14
App\Entity\Configuration	11
App\Entity\Banner	7
App\Entity\Category	2
App\Entity\Page	2
App\Entity\Store	1
App\Entity\Plan	1
App\Entity\Brand	1
App\Entity\Purchase	1
App\Entity\PurchaseProduct	1
App\Entity\ProductVariation	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.
App\Entity\PurchaseLog	No errors.

Symfony Profiler

GET https://loja.porkao.com.br/carrinho

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping