Query Metrics
47
Database Queries
23
Different statements
47.86 ms
Query time
0
Invalid entities
1651
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
12.19 ms (25.47%) |
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" ] |
||||||||||||||||||||||||||||
|
7.37 ms (15.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_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" 175 4221 ] |
||||||||||||||||||||||||||||
|
5.64 ms (11.78%) |
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:
[
2745
]
|
||||||||||||||||||||||||||||
|
5.32 ms (11.11%) |
12 |
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.stock_id = ?
Parameters:
[
9083
]
|
||||||||||||||||||||||||||||
|
2.48 ms (5.19%) |
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" 4221 4221 ] |
||||||||||||||||||||||||||||
|
1.49 ms (3.10%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
1.43 ms (2.98%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
1.05 ms (2.20%) |
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:
[ "frico-fhdn15-flexibilna-hadica" "sk" ] |
||||||||||||||||||||||||||||
|
1.03 ms (2.15%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
0.93 ms (1.93%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
0.88 ms (1.85%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
0.88 ms (1.84%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
0.82 ms (1.71%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
0.79 ms (1.64%) |
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:
[] |
||||||||||||||||||||||||||||
|
0.79 ms (1.64%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
0.75 ms (1.57%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
0.74 ms (1.56%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
0.71 ms (1.49%) |
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
]
|
||||||||||||||||||||||||||||
|
0.68 ms (1.42%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
0.64 ms (1.34%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
0.50 ms (1.05%) |
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:
[
4221
]
|
||||||||||||||||||||||||||||
|
0.40 ms (0.83%) |
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:
[
5700
]
|
||||||||||||||||||||||||||||
|
0.35 ms (0.74%) |
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:
[
17
]
|
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 | 322 |
| App\Entity\CategoryTranslation | 321 |
| App\Entity\Image | 250 |
| App\Entity\ImageTranslation | 245 |
| App\Entity\Stock | 25 |
| App\Entity\StockPrice | 16 |
| App\Entity\Product | 13 |
| App\Entity\ProductTranslation | 13 |
| App\Entity\Variant | 12 |
| App\Entity\Store | 6 |
| App\Entity\TaxRate | 5 |
| App\Entity\Manufacturer | 3 |
| App\User\Entity\User | 3 |
| App\Entity\Slug | 1 |
| App\Entity\StockGroup | 1 |
| App\Entity\ProductCategory | 1 |
| App\Entity\ProductImage | 1 |