GET https://sandbox.dobraklima.sk/soler-palau-afr-rovento-220-nahradny-filter-f7

Response
200 OK
IP
216.73.216.127
Profiled on
Token
e9c009

Query Metrics

35 Database Queries
22 Different statements
45.80 ms Query time
0 Invalid entities
1610 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
16.72 ms
(36.51%) 		1 
SELECT m0_.alias AS alias_0, m0_.lft AS lft_1, m0_.rgt AS rgt_2, m0_.lvl AS lvl_3, m0_.root AS root_4, m0_.id AS id_5, c1_.main_template AS main_template_6, c1_.product_template AS product_template_7, c1_.filterable AS filterable_8, c1_.id AS id_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c2_.slug AS slug_12, c2_.title AS title_13, c2_.h1 AS h1_14, c2_.perex AS perex_15, c2_.description AS description_16, c2_.meta_title AS meta_title_17, c2_.meta_description AS meta_description_18, c2_.meta_keywords AS meta_keywords_19, c2_.locale AS locale_20, c2_.id AS id_21, i3_.name AS name_22, i3_.original_name AS original_name_23, i3_.mime_type AS mime_type_24, i3_.size AS size_25, i3_.width AS width_26, i3_.height AS height_27, i3_.id AS id_28, i3_.created_at AS created_at_29, i3_.updated_at AS updated_at_30, i4_.title AS title_31, i4_.keywords AS keywords_32, i4_.locale AS locale_33, i4_.id AS id_34, m0_.category_id AS category_id_35, m0_.parent_id AS parent_id_36, c1_.principal_image_id AS principal_image_id_37, c2_.translatable_id AS translatable_id_38, i4_.translatable_id AS translatable_id_39 FROM menu_sk m0_ LEFT JOIN category c1_ ON m0_.category_id = c1_.id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale IN (?)) LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN (?)) ORDER BY m0_.lft ASC
Parameters: 
[
  "sk"
  "sk"
]
View formatted query    View runnable query    Explain query    View query backtrace
6.34 ms
(13.84%) 		12 
SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.principal_image_id AS principal_image_id_5, t0.product_id AS product_id_6, t0.stock_id AS stock_id_7, t8.sku AS sku_9, t8.quantity AS quantity_10, t8.quantity_unit AS quantity_unit_11, t8.ean_code AS ean_code_12, t8.availability AS availability_13, t8.`condition` AS condition_14, t8.importable AS importable_15, t8.tax_transferable AS tax_transferable_16, t8.sale_count AS sale_count_17, t8.disabled_at AS disabled_at_18, t8.id AS id_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.enabled AS enabled_22, t8.group_id AS group_id_23 FROM variant t0 LEFT JOIN stock t8 ON t0.stock_id = t8.id WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters: 
[
  2622
]
View formatted query    View runnable query    Explain query    View query backtrace
5.02 ms
(10.96%) 		1 
SELECT RAND() AS sclr_0, p0_.type AS type_1, p0_.warranty_years AS warranty_years_2, p0_.new AS new_3, p0_.id AS id_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, s1_.sku AS sku_7, s1_.quantity AS quantity_8, s1_.quantity_unit AS quantity_unit_9, s1_.ean_code AS ean_code_10, s1_.availability AS availability_11, s1_.`condition` AS condition_12, s1_.importable AS importable_13, s1_.tax_transferable AS tax_transferable_14, s1_.sale_count AS sale_count_15, s1_.disabled_at AS disabled_at_16, s1_.id AS id_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s1_.enabled AS enabled_20, v2_.id AS id_21, v2_.position AS position_22, v2_.created_at AS created_at_23, v2_.updated_at AS updated_at_24, s3_.amount AS amount_25, s3_.tax_amount AS tax_amount_26, s3_.previous_amount AS previous_amount_27, s3_.previous_tax_amount AS previous_tax_amount_28, s3_.id AS id_29, s3_.created_at AS created_at_30, s3_.updated_at AS updated_at_31, t4_.rate AS rate_32, t4_.`precision` AS precision_33, t4_.id AS id_34, p5_.title AS title_35, p5_.h1 AS h1_36, p5_.perex AS perex_37, p5_.description AS description_38, p5_.text AS text_39, p5_.meta_title AS meta_title_40, p5_.meta_description AS meta_description_41, p5_.meta_keywords AS meta_keywords_42, p5_.slug AS slug_43, p5_.locale AS locale_44, p5_.id AS id_45, i6_.name AS name_46, i6_.original_name AS original_name_47, i6_.mime_type AS mime_type_48, i6_.size AS size_49, i6_.width AS width_50, i6_.height AS height_51, i6_.id AS id_52, i6_.created_at AS created_at_53, i6_.updated_at AS updated_at_54, i7_.title AS title_55, i7_.keywords AS keywords_56, i7_.locale AS locale_57, i7_.id AS id_58, p0_.principal_category_id AS principal_category_id_59, p0_.principal_image_id AS principal_image_id_60, p0_.manufacturer_id AS manufacturer_id_61, p0_.product_class_id AS product_class_id_62, p0_.stock_id AS stock_id_63, s1_.group_id AS group_id_64, v2_.principal_image_id AS principal_image_id_65, v2_.product_id AS product_id_66, v2_.stock_id AS stock_id_67, s3_.stock_id AS stock_id_68, s3_.store_id AS store_id_69, s3_.user_id AS user_id_70, s3_.tax_rate_id AS tax_rate_id_71, s3_.previous_tax_rate_id AS previous_tax_rate_id_72, t4_.store_id AS store_id_73, p5_.translatable_id AS translatable_id_74, i7_.translatable_id AS translatable_id_75 FROM product p0_ INNER JOIN stock s1_ ON p0_.stock_id = s1_.id LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id AND (s3_.store_id = ?) INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id AND (p5_.locale IN (?)) LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id AND (i7_.locale IN (?)) INNER JOIN product_category p8_ ON p0_.id = p8_.product_id INNER JOIN category c9_ ON p8_.category_id = c9_.id INNER JOIN recommended_category_category r11_ ON c9_.id = r11_.category_id INNER JOIN category c10_ ON c10_.id = r11_.recommended_id AND (c10_.id IN (?)) WHERE s1_.enabled = 1 AND p0_.id NOT IN (?) GROUP BY s1_.id ORDER BY sclr_0 ASC LIMIT 12
Parameters: 
[
  1
  "sk"
  "sk"
  183
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
2.47 ms
(5.40%) 		1 
SELECT RAND() AS sclr_0, p0_.type AS type_1, p0_.warranty_years AS warranty_years_2, p0_.new AS new_3, p0_.id AS id_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, s1_.sku AS sku_7, s1_.quantity AS quantity_8, s1_.quantity_unit AS quantity_unit_9, s1_.ean_code AS ean_code_10, s1_.availability AS availability_11, s1_.`condition` AS condition_12, s1_.importable AS importable_13, s1_.tax_transferable AS tax_transferable_14, s1_.sale_count AS sale_count_15, s1_.disabled_at AS disabled_at_16, s1_.id AS id_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s1_.enabled AS enabled_20, v2_.id AS id_21, v2_.position AS position_22, v2_.created_at AS created_at_23, v2_.updated_at AS updated_at_24, s3_.amount AS amount_25, s3_.tax_amount AS tax_amount_26, s3_.previous_amount AS previous_amount_27, s3_.previous_tax_amount AS previous_tax_amount_28, s3_.id AS id_29, s3_.created_at AS created_at_30, s3_.updated_at AS updated_at_31, t4_.rate AS rate_32, t4_.`precision` AS precision_33, t4_.id AS id_34, p5_.title AS title_35, p5_.h1 AS h1_36, p5_.perex AS perex_37, p5_.description AS description_38, p5_.text AS text_39, p5_.meta_title AS meta_title_40, p5_.meta_description AS meta_description_41, p5_.meta_keywords AS meta_keywords_42, p5_.slug AS slug_43, p5_.locale AS locale_44, p5_.id AS id_45, i6_.name AS name_46, i6_.original_name AS original_name_47, i6_.mime_type AS mime_type_48, i6_.size AS size_49, i6_.width AS width_50, i6_.height AS height_51, i6_.id AS id_52, i6_.created_at AS created_at_53, i6_.updated_at AS updated_at_54, i7_.title AS title_55, i7_.keywords AS keywords_56, i7_.locale AS locale_57, i7_.id AS id_58, p0_.principal_category_id AS principal_category_id_59, p0_.principal_image_id AS principal_image_id_60, p0_.manufacturer_id AS manufacturer_id_61, p0_.product_class_id AS product_class_id_62, p0_.stock_id AS stock_id_63, s1_.group_id AS group_id_64, v2_.principal_image_id AS principal_image_id_65, v2_.product_id AS product_id_66, v2_.stock_id AS stock_id_67, s3_.stock_id AS stock_id_68, s3_.store_id AS store_id_69, s3_.user_id AS user_id_70, s3_.tax_rate_id AS tax_rate_id_71, s3_.previous_tax_rate_id AS previous_tax_rate_id_72, t4_.store_id AS store_id_73, p5_.translatable_id AS translatable_id_74, i7_.translatable_id AS translatable_id_75 FROM product p0_ INNER JOIN stock s1_ ON p0_.stock_id = s1_.id LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id AND (s3_.store_id = ?) INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id AND (p5_.locale IN (?)) LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id AND (i7_.locale IN (?)) INNER JOIN product_category p8_ ON p0_.id = p8_.product_id INNER JOIN category c9_ ON p8_.category_id = c9_.id INNER JOIN recommended_product_category r11_ ON c9_.id = r11_.category_id INNER JOIN product p10_ ON p10_.id = r11_.product_id AND (p10_.id IN (?)) WHERE s1_.enabled = 1 AND p0_.id NOT IN (?) GROUP BY s1_.id ORDER BY sclr_0 ASC LIMIT 12
Parameters: 
[
  1
  "sk"
  "sk"
  2628
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
1.53 ms
(3.34%) 		1 
SELECT p0_.id AS id_0, p1_.`group` AS group_1, p1_.position AS position_2, p2_.type AS type_3, p2_.warranty_years AS warranty_years_4, p2_.new AS new_5, p2_.id AS id_6, p2_.created_at AS created_at_7, p2_.updated_at AS updated_at_8, p3_.title AS title_9, p3_.h1 AS h1_10, p3_.perex AS perex_11, p3_.description AS description_12, p3_.text AS text_13, p3_.meta_title AS meta_title_14, p3_.meta_description AS meta_description_15, p3_.meta_keywords AS meta_keywords_16, p3_.slug AS slug_17, p3_.locale AS locale_18, p3_.id AS id_19, s4_.sku AS sku_20, s4_.quantity AS quantity_21, s4_.quantity_unit AS quantity_unit_22, s4_.ean_code AS ean_code_23, s4_.availability AS availability_24, s4_.`condition` AS condition_25, s4_.importable AS importable_26, s4_.tax_transferable AS tax_transferable_27, s4_.sale_count AS sale_count_28, s4_.disabled_at AS disabled_at_29, s4_.id AS id_30, s4_.created_at AS created_at_31, s4_.updated_at AS updated_at_32, s4_.enabled AS enabled_33, v5_.id AS id_34, v5_.position AS position_35, v5_.created_at AS created_at_36, v5_.updated_at AS updated_at_37, s6_.amount AS amount_38, s6_.tax_amount AS tax_amount_39, s6_.previous_amount AS previous_amount_40, s6_.previous_tax_amount AS previous_tax_amount_41, s6_.id AS id_42, s6_.created_at AS created_at_43, s6_.updated_at AS updated_at_44, p0_.principal_category_id AS principal_category_id_45, p0_.principal_image_id AS principal_image_id_46, p0_.manufacturer_id AS manufacturer_id_47, p0_.product_class_id AS product_class_id_48, p0_.stock_id AS stock_id_49, p1_.parent_id AS parent_id_50, p1_.item_id AS item_id_51, p2_.principal_category_id AS principal_category_id_52, p2_.principal_image_id AS principal_image_id_53, p2_.manufacturer_id AS manufacturer_id_54, p2_.product_class_id AS product_class_id_55, p2_.stock_id AS stock_id_56, p3_.translatable_id AS translatable_id_57, s4_.group_id AS group_id_58, v5_.principal_image_id AS principal_image_id_59, v5_.product_id AS product_id_60, v5_.stock_id AS stock_id_61, s6_.stock_id AS stock_id_62, s6_.store_id AS store_id_63, s6_.user_id AS user_id_64, s6_.tax_rate_id AS tax_rate_id_65, s6_.previous_tax_rate_id AS previous_tax_rate_id_66 FROM product p0_ LEFT JOIN product_accessory p1_ ON p0_.id = p1_.parent_id LEFT JOIN product p2_ ON p1_.item_id = p2_.id LEFT JOIN product_translation p3_ ON p2_.id = p3_.translatable_id LEFT JOIN stock s4_ ON p2_.stock_id = s4_.id LEFT JOIN variant v5_ ON s4_.id = v5_.stock_id LEFT JOIN stock_price s6_ ON s4_.id = s6_.stock_id WHERE p0_.id = ? ORDER BY p1_.position ASC
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
1.25 ms
(2.73%) 		1 
SELECT p0_.id AS id_0, p1_.title AS title_1, p1_.h1 AS h1_2, p1_.perex AS perex_3, p1_.description AS description_4, p1_.text AS text_5, p1_.meta_title AS meta_title_6, p1_.meta_description AS meta_description_7, p1_.meta_keywords AS meta_keywords_8, p1_.slug AS slug_9, p1_.locale AS locale_10, p1_.id AS id_11, m2_.name AS name_12, m2_.slug AS slug_13, m2_.displayable AS displayable_14, m2_.id AS id_15, m2_.created_at AS created_at_16, m2_.updated_at AS updated_at_17, s3_.sku AS sku_18, s3_.quantity AS quantity_19, s3_.quantity_unit AS quantity_unit_20, s3_.ean_code AS ean_code_21, s3_.availability AS availability_22, s3_.`condition` AS condition_23, s3_.importable AS importable_24, s3_.tax_transferable AS tax_transferable_25, s3_.sale_count AS sale_count_26, s3_.disabled_at AS disabled_at_27, s3_.id AS id_28, s3_.created_at AS created_at_29, s3_.updated_at AS updated_at_30, s3_.enabled AS enabled_31, v4_.id AS id_32, v4_.position AS position_33, v4_.created_at AS created_at_34, v4_.updated_at AS updated_at_35, s5_.amount AS amount_36, s5_.tax_amount AS tax_amount_37, s5_.previous_amount AS previous_amount_38, s5_.previous_tax_amount AS previous_tax_amount_39, s5_.id AS id_40, s5_.created_at AS created_at_41, s5_.updated_at AS updated_at_42, p6_.id AS id_43, p6_.position AS position_44, p6_.created_at AS created_at_45, p6_.updated_at AS updated_at_46, p6_.enabled AS enabled_47, p7_.slug AS slug_48, p7_.title AS title_49, p7_.h1 AS h1_50, p7_.perex AS perex_51, p7_.description AS description_52, p7_.meta_title AS meta_title_53, p7_.meta_description AS meta_description_54, p7_.meta_keywords AS meta_keywords_55, p7_.locale AS locale_56, p7_.id AS id_57, p0_.principal_category_id AS principal_category_id_58, p0_.principal_image_id AS principal_image_id_59, p0_.manufacturer_id AS manufacturer_id_60, p0_.product_class_id AS product_class_id_61, p0_.stock_id AS stock_id_62, p1_.translatable_id AS translatable_id_63, m2_.principal_image_id AS principal_image_id_64, s3_.group_id AS group_id_65, v4_.principal_image_id AS principal_image_id_66, v4_.product_id AS product_id_67, v4_.stock_id AS stock_id_68, s5_.stock_id AS stock_id_69, s5_.store_id AS store_id_70, s5_.user_id AS user_id_71, s5_.tax_rate_id AS tax_rate_id_72, s5_.previous_tax_rate_id AS previous_tax_rate_id_73, p6_.principal_category_id AS principal_category_id_74, p6_.principal_image_id AS principal_image_id_75, p6_.manufacturer_id AS manufacturer_id_76, p6_.parent_id AS parent_id_77, p7_.translatable_id AS translatable_id_78 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN manufacturer m2_ ON p0_.manufacturer_id = m2_.id LEFT JOIN stock s3_ ON p0_.stock_id = s3_.id LEFT JOIN variant v4_ ON s3_.id = v4_.stock_id LEFT JOIN stock_price s5_ ON s3_.id = s5_.stock_id LEFT JOIN product_class p6_ ON p0_.product_class_id = p6_.id LEFT JOIN product_class_translation p7_ ON p6_.id = p7_.translatable_id WHERE p0_.id = ?
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
1.09 ms
(2.39%) 		1 
SELECT p0_.id AS id_0, v1_.id AS id_1, v1_.position AS position_2, v1_.created_at AS created_at_3, v1_.updated_at AS updated_at_4, s2_.sku AS sku_5, s2_.quantity AS quantity_6, s2_.quantity_unit AS quantity_unit_7, s2_.ean_code AS ean_code_8, s2_.availability AS availability_9, s2_.`condition` AS condition_10, s2_.importable AS importable_11, s2_.tax_transferable AS tax_transferable_12, s2_.sale_count AS sale_count_13, s2_.disabled_at AS disabled_at_14, s2_.id AS id_15, s2_.created_at AS created_at_16, s2_.updated_at AS updated_at_17, s2_.enabled AS enabled_18, p3_.type AS type_19, p3_.warranty_years AS warranty_years_20, p3_.new AS new_21, p3_.id AS id_22, p3_.created_at AS created_at_23, p3_.updated_at AS updated_at_24, s4_.amount AS amount_25, s4_.tax_amount AS tax_amount_26, s4_.previous_amount AS previous_amount_27, s4_.previous_tax_amount AS previous_tax_amount_28, s4_.id AS id_29, s4_.created_at AS created_at_30, s4_.updated_at AS updated_at_31, v5_.position AS position_32, a6_.id AS id_33, a6_.position AS position_34, a6_.created_at AS created_at_35, a6_.updated_at AS updated_at_36, a7_.title AS title_37, a7_.description AS description_38, a7_.slug AS slug_39, a7_.locale AS locale_40, a7_.id AS id_41, p0_.principal_category_id AS principal_category_id_42, p0_.principal_image_id AS principal_image_id_43, p0_.manufacturer_id AS manufacturer_id_44, p0_.product_class_id AS product_class_id_45, p0_.stock_id AS stock_id_46, v1_.principal_image_id AS principal_image_id_47, v1_.product_id AS product_id_48, v1_.stock_id AS stock_id_49, s2_.group_id AS group_id_50, p3_.principal_category_id AS principal_category_id_51, p3_.principal_image_id AS principal_image_id_52, p3_.manufacturer_id AS manufacturer_id_53, p3_.product_class_id AS product_class_id_54, p3_.stock_id AS stock_id_55, s4_.stock_id AS stock_id_56, s4_.store_id AS store_id_57, s4_.user_id AS user_id_58, s4_.tax_rate_id AS tax_rate_id_59, s4_.previous_tax_rate_id AS previous_tax_rate_id_60, v5_.variant_id AS variant_id_61, v5_.attribute_option_id AS attribute_option_id_62, a6_.attribute_id AS attribute_id_63, a6_.principal_image_id AS principal_image_id_64, a7_.translatable_id AS translatable_id_65 FROM product p0_ LEFT JOIN variant v1_ ON p0_.id = v1_.product_id LEFT JOIN stock s2_ ON v1_.stock_id = s2_.id LEFT JOIN product p3_ ON s2_.id = p3_.stock_id LEFT JOIN stock_price s4_ ON s2_.id = s4_.stock_id LEFT JOIN variant_attribute v5_ ON v1_.id = v5_.variant_id LEFT JOIN attribute_option a6_ ON v5_.attribute_option_id = a6_.id LEFT JOIN attribute_option_translation a7_ ON a6_.id = a7_.translatable_id WHERE p0_.id = ? ORDER BY v1_.position ASC, v5_.position ASC
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
1.02 ms
(2.24%) 		2 
SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.slug = ? AND s0_.locale IN (?)
Parameters: 
[
  "soler-palau-afr-rovento-220-nahradny-filter-f7"
  "sk"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.98 ms
(2.13%) 		1 
SELECT p0_.id AS id_0, p1_.value AS value_1, p1_.on_listing AS on_listing_2, p1_.configurable AS configurable_3, p1_.id AS id_4, p1_.position AS position_5, a2_.alias AS alias_6, a2_.class AS class_7, a2_.icon AS icon_8, a2_.on_detail AS on_detail_9, a2_.on_listing AS on_listing_10, a2_.expanded AS expanded_11, a2_.id AS id_12, a2_.position AS position_13, a2_.created_at AS created_at_14, a2_.updated_at AS updated_at_15, a3_.title AS title_16, a3_.description AS description_17, a3_.unit AS unit_18, a3_.locale AS locale_19, a3_.id AS id_20, a4_.class AS class_21, a4_.id AS id_22, a4_.position AS position_23, a4_.created_at AS created_at_24, a4_.updated_at AS updated_at_25, a5_.title AS title_26, a5_.description AS description_27, a5_.locale AS locale_28, a5_.id AS id_29, p0_.principal_category_id AS principal_category_id_30, p0_.principal_image_id AS principal_image_id_31, p0_.manufacturer_id AS manufacturer_id_32, p0_.product_class_id AS product_class_id_33, p0_.stock_id AS stock_id_34, p1_.product_id AS product_id_35, p1_.attribute_id AS attribute_id_36, p1_.attribute_option_id AS attribute_option_id_37, p1_.principal_image_id AS principal_image_id_38, a2_.group_id AS group_id_39, a3_.translatable_id AS translatable_id_40, a4_.parent_id AS parent_id_41, a5_.translatable_id AS translatable_id_42 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN attribute a2_ ON p1_.attribute_id = a2_.id LEFT JOIN attribute_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN attribute_group a4_ ON a2_.group_id = a4_.id LEFT JOIN attribute_group_translation a5_ ON a4_.id = a5_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
0.91 ms
(1.98%) 		1 
SELECT s0_.name AS name_0, s0_.email AS email_1, s0_.url AS url_2, s0_.country AS country_3, s0_.locale AS locale_4, s0_.currency AS currency_5, s0_.order_base_number AS order_base_number_6, s0_.order_email AS order_email_7, s0_.id AS id_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM store s0_ ORDER BY s0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.90 ms
(1.96%) 		1 
SELECT p0_.id AS id_0, p1_.value AS value_1, p1_.on_listing AS on_listing_2, p1_.configurable AS configurable_3, p1_.id AS id_4, p1_.position AS position_5, a2_.id AS id_6, a2_.position AS position_7, a2_.created_at AS created_at_8, a2_.updated_at AS updated_at_9, a3_.title AS title_10, a3_.description AS description_11, a3_.slug AS slug_12, a3_.locale AS locale_13, a3_.id AS id_14, i4_.name AS name_15, i4_.original_name AS original_name_16, i4_.mime_type AS mime_type_17, i4_.size AS size_18, i4_.width AS width_19, i4_.height AS height_20, i4_.id AS id_21, i4_.created_at AS created_at_22, i4_.updated_at AS updated_at_23, i5_.title AS title_24, i5_.keywords AS keywords_25, i5_.locale AS locale_26, i5_.id AS id_27, p0_.principal_category_id AS principal_category_id_28, p0_.principal_image_id AS principal_image_id_29, p0_.manufacturer_id AS manufacturer_id_30, p0_.product_class_id AS product_class_id_31, p0_.stock_id AS stock_id_32, p1_.product_id AS product_id_33, p1_.attribute_id AS attribute_id_34, p1_.attribute_option_id AS attribute_option_id_35, p1_.principal_image_id AS principal_image_id_36, a2_.attribute_id AS attribute_id_37, a2_.principal_image_id AS principal_image_id_38, a3_.translatable_id AS translatable_id_39, i5_.translatable_id AS translatable_id_40 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN attribute_option a2_ ON p1_.attribute_option_id = a2_.id LEFT JOIN attribute_option_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN image i4_ ON a2_.principal_image_id = i4_.id LEFT JOIN image_translation i5_ ON i4_.id = i5_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
0.88 ms
(1.91%) 		1 
SELECT p0_.id AS id_0, p1_.position AS position_1, a2_.class AS class_2, a2_.icon AS icon_3, a2_.id AS id_4, a2_.position AS position_5, a2_.created_at AS created_at_6, a2_.updated_at AS updated_at_7, a3_.title AS title_8, a3_.description AS description_9, a3_.locale AS locale_10, a3_.id AS id_11, a4_.class AS class_12, a4_.id AS id_13, a4_.position AS position_14, a4_.created_at AS created_at_15, a4_.updated_at AS updated_at_16, a5_.title AS title_17, a5_.description AS description_18, a5_.locale AS locale_19, a5_.id AS id_20, p0_.principal_category_id AS principal_category_id_21, p0_.principal_image_id AS principal_image_id_22, p0_.manufacturer_id AS manufacturer_id_23, p0_.product_class_id AS product_class_id_24, p0_.stock_id AS stock_id_25, p1_.product_id AS product_id_26, p1_.advantage_id AS advantage_id_27, a2_.group_id AS group_id_28, a3_.translatable_id AS translatable_id_29, a4_.parent_id AS parent_id_30, a5_.translatable_id AS translatable_id_31 FROM product p0_ LEFT JOIN product_advantage p1_ ON p0_.id = p1_.product_id LEFT JOIN advantage a2_ ON p1_.advantage_id = a2_.id LEFT JOIN advantage_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN advantage_group a4_ ON a2_.group_id = a4_.id LEFT JOIN advantage_group_translation a5_ ON a4_.id = a5_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
0.85 ms
(1.87%) 		1 
SELECT p0_.id AS id_0, p1_.value AS value_1, p1_.on_listing AS on_listing_2, p1_.configurable AS configurable_3, p1_.id AS id_4, p1_.position AS position_5, p2_.amount AS amount_6, p2_.tax_amount AS tax_amount_7, p2_.previous_amount AS previous_amount_8, p2_.previous_tax_amount AS previous_tax_amount_9, p2_.id AS id_10, p2_.created_at AS created_at_11, p2_.updated_at AS updated_at_12, i3_.name AS name_13, i3_.original_name AS original_name_14, i3_.mime_type AS mime_type_15, i3_.size AS size_16, i3_.width AS width_17, i3_.height AS height_18, i3_.id AS id_19, i3_.created_at AS created_at_20, i3_.updated_at AS updated_at_21, i4_.title AS title_22, i4_.keywords AS keywords_23, i4_.locale AS locale_24, i4_.id AS id_25, p0_.principal_category_id AS principal_category_id_26, p0_.principal_image_id AS principal_image_id_27, p0_.manufacturer_id AS manufacturer_id_28, p0_.product_class_id AS product_class_id_29, p0_.stock_id AS stock_id_30, p1_.product_id AS product_id_31, p1_.attribute_id AS attribute_id_32, p1_.attribute_option_id AS attribute_option_id_33, p1_.principal_image_id AS principal_image_id_34, p2_.product_attribute_id AS product_attribute_id_35, p2_.store_id AS store_id_36, p2_.user_id AS user_id_37, p2_.tax_rate_id AS tax_rate_id_38, p2_.previous_tax_rate_id AS previous_tax_rate_id_39, i4_.translatable_id AS translatable_id_40 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_attribute_price p2_ ON p1_.id = p2_.product_attribute_id LEFT JOIN image i3_ ON p1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
0.77 ms
(1.68%) 		1 
SELECT p0_.id AS id_0, p1_.position AS position_1, d2_.name AS name_2, d2_.original_name AS original_name_3, d2_.mime_type AS mime_type_4, d2_.size AS size_5, d2_.id AS id_6, d2_.created_at AS created_at_7, d2_.updated_at AS updated_at_8, d3_.title AS title_9, d3_.description AS description_10, d3_.keywords AS keywords_11, d3_.locale AS locale_12, d3_.id AS id_13, p0_.principal_category_id AS principal_category_id_14, p0_.principal_image_id AS principal_image_id_15, p0_.manufacturer_id AS manufacturer_id_16, p0_.product_class_id AS product_class_id_17, p0_.stock_id AS stock_id_18, p1_.product_id AS product_id_19, p1_.document_id AS document_id_20, d3_.translatable_id AS translatable_id_21 FROM product p0_ LEFT JOIN product_document p1_ ON p0_.id = p1_.product_id LEFT JOIN document d2_ ON p1_.document_id = d2_.id LEFT JOIN document_translation d3_ ON d2_.id = d3_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
0.77 ms
(1.68%) 		1 
SELECT p0_.id AS id_0, p1_.position AS position_1, i2_.name AS name_2, i2_.original_name AS original_name_3, i2_.mime_type AS mime_type_4, i2_.size AS size_5, i2_.width AS width_6, i2_.height AS height_7, i2_.id AS id_8, i2_.created_at AS created_at_9, i2_.updated_at AS updated_at_10, i3_.title AS title_11, i3_.keywords AS keywords_12, i3_.locale AS locale_13, i3_.id AS id_14, p0_.principal_category_id AS principal_category_id_15, p0_.principal_image_id AS principal_image_id_16, p0_.manufacturer_id AS manufacturer_id_17, p0_.product_class_id AS product_class_id_18, p0_.stock_id AS stock_id_19, p1_.product_id AS product_id_20, p1_.image_id AS image_id_21, i3_.translatable_id AS translatable_id_22 FROM product p0_ LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id LEFT JOIN image i2_ ON p1_.image_id = i2_.id LEFT JOIN image_translation i3_ ON i2_.id = i3_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
0.74 ms
(1.62%) 		1 
SELECT p0_.id AS id_0, p1_.position AS position_1, c2_.main_template AS main_template_2, c2_.product_template AS product_template_3, c2_.filterable AS filterable_4, c2_.id AS id_5, c2_.created_at AS created_at_6, c2_.updated_at AS updated_at_7, c3_.slug AS slug_8, c3_.title AS title_9, c3_.h1 AS h1_10, c3_.perex AS perex_11, c3_.description AS description_12, c3_.meta_title AS meta_title_13, c3_.meta_description AS meta_description_14, c3_.meta_keywords AS meta_keywords_15, c3_.locale AS locale_16, c3_.id AS id_17, p0_.principal_category_id AS principal_category_id_18, p0_.principal_image_id AS principal_image_id_19, p0_.manufacturer_id AS manufacturer_id_20, p0_.product_class_id AS product_class_id_21, p0_.stock_id AS stock_id_22, p1_.category_id AS category_id_23, p1_.product_id AS product_id_24, c2_.principal_image_id AS principal_image_id_25, c3_.translatable_id AS translatable_id_26 FROM product p0_ LEFT JOIN product_category p1_ ON p0_.id = p1_.product_id LEFT JOIN category c2_ ON p1_.category_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id WHERE p0_.id = ?
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(1.51%) 		2 
SELECT t0.rate AS rate_1, t0.`precision` AS precision_2, t0.id AS id_3, t0.store_id AS store_id_4 FROM tax_rate t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
0.66 ms
(1.45%) 		1 
SELECT p0_.id AS id_0, c1_.main_template AS main_template_1, c1_.product_template AS product_template_2, c1_.filterable AS filterable_3, c1_.id AS id_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, c2_.slug AS slug_7, c2_.title AS title_8, c2_.h1 AS h1_9, c2_.perex AS perex_10, c2_.description AS description_11, c2_.meta_title AS meta_title_12, c2_.meta_description AS meta_description_13, c2_.meta_keywords AS meta_keywords_14, c2_.locale AS locale_15, c2_.id AS id_16, p0_.principal_category_id AS principal_category_id_17, p0_.principal_image_id AS principal_image_id_18, p0_.manufacturer_id AS manufacturer_id_19, p0_.product_class_id AS product_class_id_20, p0_.stock_id AS stock_id_21, c1_.principal_image_id AS principal_image_id_22, c2_.translatable_id AS translatable_id_23 FROM product p0_ LEFT JOIN recommended_product_category r3_ ON p0_.id = r3_.product_id LEFT JOIN category c1_ ON c1_.id = r3_.category_id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id WHERE p0_.id = ?
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(1.26%) 		1 
SELECT p0_.id AS id_0, v1_.provider AS provider_1, v1_.id AS id_2, v1_.created_at AS created_at_3, v1_.updated_at AS updated_at_4, v2_.url AS url_5, v2_.title AS title_6, v2_.embed_code AS embed_code_7, v2_.locale AS locale_8, v2_.id AS id_9, p0_.principal_category_id AS principal_category_id_10, p0_.principal_image_id AS principal_image_id_11, p0_.manufacturer_id AS manufacturer_id_12, p0_.product_class_id AS product_class_id_13, p0_.stock_id AS stock_id_14, v2_.translatable_id AS translatable_id_15 FROM product p0_ LEFT JOIN product_video p3_ ON p0_.id = p3_.product_id LEFT JOIN video v1_ ON v1_.id = p3_.video_id LEFT JOIN video_translation v2_ ON v1_.id = v2_.translatable_id WHERE p0_.id = ?
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.25%) 		1 
SELECT t0.type AS type_1, t0.warranty_years AS warranty_years_2, t0.new AS new_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_category_id AS principal_category_id_7, t0.principal_image_id AS principal_image_id_8, t0.manufacturer_id AS manufacturer_id_9, t0.product_class_id AS product_class_id_10, t0.stock_id AS stock_id_11, t12.sku AS sku_13, t12.quantity AS quantity_14, t12.quantity_unit AS quantity_unit_15, t12.ean_code AS ean_code_16, t12.availability AS availability_17, t12.`condition` AS condition_18, t12.importable AS importable_19, t12.tax_transferable AS tax_transferable_20, t12.sale_count AS sale_count_21, t12.disabled_at AS disabled_at_22, t12.id AS id_23, t12.created_at AS created_at_24, t12.updated_at AS updated_at_25, t12.enabled AS enabled_26, t12.group_id AS group_id_27 FROM product t0 LEFT JOIN stock t12 ON t0.stock_id = t12.id WHERE t0.id = ?
Parameters: 
[
  2628
]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(1.21%) 		1 
SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.principal_image_id AS principal_image_id_5, t0.product_id AS product_id_6, t0.stock_id AS stock_id_7, t8.sku AS sku_9, t8.quantity AS quantity_10, t8.quantity_unit AS quantity_unit_11, t8.ean_code AS ean_code_12, t8.availability AS availability_13, t8.`condition` AS condition_14, t8.importable AS importable_15, t8.tax_transferable AS tax_transferable_16, t8.sale_count AS sale_count_17, t8.disabled_at AS disabled_at_18, t8.id AS id_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.enabled AS enabled_22, t8.group_id AS group_id_23 FROM variant t0 LEFT JOIN stock t8 ON t0.stock_id = t8.id WHERE t0.stock_id = ?
Parameters: 
[
  3516
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(1.09%) 		1 
SELECT t0.code AS code_1, t0.title AS title_2, t0.description AS description_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM stock_group t0 WHERE t0.id = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query    View query backtrace

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\MenuSk 413
App\Entity\Category 320
App\Entity\CategoryTranslation 320
App\Entity\Image 242
App\Entity\ImageTranslation 242
App\Entity\StockPrice 16
App\Entity\Product 13
App\Entity\Stock 13
App\Entity\ProductTranslation 13
App\Entity\Store 6
App\Entity\TaxRate 5
App\Entity\ProductImage 2
App\Entity\Slug 1
App\Entity\Manufacturer 1
App\Entity\StockGroup 1
App\User\Entity\User 1
App\Entity\ProductCategory 1

Entities Mapping

Class Mapping errors
App\Entity\Store No errors.
App\Entity\TaxRate No errors.
App\Entity\Slug No errors.
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\Image No errors.
App\Entity\Manufacturer No errors.
App\Entity\ProductClass No errors.
App\Entity\Stock No errors.
App\Entity\StockGroup No errors.
App\Entity\ProductAccessory No errors.
App\Entity\ProductAdvantage No errors.
App\Entity\ProductAttribute No errors.
App\Entity\ProductCategory No errors.
App\Entity\ProductDocument No errors.
App\Entity\ProductImage No errors.
App\Entity\Variant No errors.
App\Entity\Video No errors.
App\Entity\ProductTranslation No errors.
App\Entity\StockPrice No errors.
App\Entity\StockPriceHistory No errors.
App\Entity\ProductSet No errors.
App\Entity\TaxTransferRule No errors.
App\Entity\StockUpdateLog No errors.
App\Entity\ProductClassTranslation No errors.
App\User\Entity\User No errors.
MsgPhp\User\Credential\EmailPassword No errors.
App\Entity\Advantage No errors.
App\Entity\AdvantageTranslation No errors.
App\Entity\AdvantageGroup No errors.
App\Entity\AdvantageGroupTranslation No errors.
App\Entity\Attribute No errors.
App\Entity\AttributeTranslation No errors.
App\Entity\AttributeGroup No errors.
App\Entity\AttributeGroupTranslation No errors.
App\Entity\AttributeOption No errors.
App\Entity\ProductAttributePrice No errors.
App\Entity\ImageTranslation No errors.
App\Entity\AttributeOptionTranslation No errors.
App\Entity\VariantAttribute No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\CategoryDocument No errors.
App\Entity\CategoryImage No errors.
App\Search\Entity\CategoryFilter No errors.
App\Entity\Document No errors.
App\Entity\DocumentTranslation No errors.
App\Entity\ProductClassImage No errors.
App\Entity\ReferenceImage No errors.
App\Entity\SliderImage No errors.
App\Entity\VariantImage No errors.
App\Entity\Reference No errors.
App\Entity\VideoTranslation No errors.
App\Entity\Menu No errors.
App\Entity\MenuSk No errors.
App\Entity\ProductAttributePriceHistory No errors.
App\Entity\Customer No errors.
App\User\Entity\UserRole No errors.
App\Search\Entity\Filter No errors.
App\Entity\Slider No errors.
App\Entity\ReferenceTranslation No errors.