90.01 ms
(36.23%)
|
6 |
SELECT p0_.type AS type_0, p0_.warranty_years AS warranty_years_1, p0_.new AS new_2, p0_.id AS id_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, s1_.sku AS sku_6, s1_.quantity AS quantity_7, s1_.quantity_unit AS quantity_unit_8, s1_.ean_code AS ean_code_9, s1_.availability AS availability_10, s1_.`condition` AS condition_11, s1_.importable AS importable_12, s1_.tax_transferable AS tax_transferable_13, s1_.sale_count AS sale_count_14, s1_.disabled_at AS disabled_at_15, s1_.id AS id_16, s1_.created_at AS created_at_17, s1_.updated_at AS updated_at_18, s1_.enabled AS enabled_19, v2_.id AS id_20, v2_.position AS position_21, v2_.created_at AS created_at_22, v2_.updated_at AS updated_at_23, s3_.amount AS amount_24, s3_.tax_amount AS tax_amount_25, s3_.previous_amount AS previous_amount_26, s3_.previous_tax_amount AS previous_tax_amount_27, s3_.id AS id_28, s3_.created_at AS created_at_29, s3_.updated_at AS updated_at_30, t4_.rate AS rate_31, t4_.`precision` AS precision_32, t4_.id AS id_33, p5_.title AS title_34, p5_.h1 AS h1_35, p5_.perex AS perex_36, p5_.description AS description_37, p5_.text AS text_38, p5_.meta_title AS meta_title_39, p5_.meta_description AS meta_description_40, p5_.meta_keywords AS meta_keywords_41, p5_.slug AS slug_42, p5_.locale AS locale_43, p5_.id AS id_44, i6_.name AS name_45, i6_.original_name AS original_name_46, i6_.mime_type AS mime_type_47, i6_.size AS size_48, i6_.width AS width_49, i6_.height AS height_50, i6_.id AS id_51, i6_.created_at AS created_at_52, i6_.updated_at AS updated_at_53, i7_.title AS title_54, i7_.keywords AS keywords_55, i7_.locale AS locale_56, i7_.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, s1_.group_id AS group_id_63, v2_.principal_image_id AS principal_image_id_64, v2_.product_id AS product_id_65, v2_.stock_id AS stock_id_66, s3_.stock_id AS stock_id_67, s3_.store_id AS store_id_68, s3_.user_id AS user_id_69, s3_.tax_rate_id AS tax_rate_id_70, s3_.previous_tax_rate_id AS previous_tax_rate_id_71, t4_.store_id AS store_id_72, p5_.translatable_id AS translatable_id_73, i7_.translatable_id AS translatable_id_74 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 AND (p8_.category_id = ?) WHERE s1_.enabled = 1 GROUP BY s1_.id ORDER BY p8_.position ASC LIMIT 12
Parameters: [
3
"de_AT"
"de"
"de_AT"
"de"
144
]
SELECT
p0_.type AS type_0,
p0_.warranty_years AS warranty_years_1,
p0_.new AS new_2,
p0_.id AS id_3,
p0_.created_at AS created_at_4,
p0_.updated_at AS updated_at_5,
s1_.sku AS sku_6,
s1_.quantity AS quantity_7,
s1_.quantity_unit AS quantity_unit_8,
s1_.ean_code AS ean_code_9,
s1_.availability AS availability_10,
s1_.`condition` AS condition_11,
s1_.importable AS importable_12,
s1_.tax_transferable AS tax_transferable_13,
s1_.sale_count AS sale_count_14,
s1_.disabled_at AS disabled_at_15,
s1_.id AS id_16,
s1_.created_at AS created_at_17,
s1_.updated_at AS updated_at_18,
s1_.enabled AS enabled_19,
v2_.id AS id_20,
v2_.position AS position_21,
v2_.created_at AS created_at_22,
v2_.updated_at AS updated_at_23,
s3_.amount AS amount_24,
s3_.tax_amount AS tax_amount_25,
s3_.previous_amount AS previous_amount_26,
s3_.previous_tax_amount AS previous_tax_amount_27,
s3_.id AS id_28,
s3_.created_at AS created_at_29,
s3_.updated_at AS updated_at_30,
t4_.rate AS rate_31,
t4_.`precision` AS precision_32,
t4_.id AS id_33,
p5_.title AS title_34,
p5_.h1 AS h1_35,
p5_.perex AS perex_36,
p5_.description AS description_37,
p5_.text AS text_38,
p5_.meta_title AS meta_title_39,
p5_.meta_description AS meta_description_40,
p5_.meta_keywords AS meta_keywords_41,
p5_.slug AS slug_42,
p5_.locale AS locale_43,
p5_.id AS id_44,
i6_.name AS name_45,
i6_.original_name AS original_name_46,
i6_.mime_type AS mime_type_47,
i6_.size AS size_48,
i6_.width AS width_49,
i6_.height AS height_50,
i6_.id AS id_51,
i6_.created_at AS created_at_52,
i6_.updated_at AS updated_at_53,
i7_.title AS title_54,
i7_.keywords AS keywords_55,
i7_.locale AS locale_56,
i7_.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,
s1_.group_id AS group_id_63,
v2_.principal_image_id AS principal_image_id_64,
v2_.product_id AS product_id_65,
v2_.stock_id AS stock_id_66,
s3_.stock_id AS stock_id_67,
s3_.store_id AS store_id_68,
s3_.user_id AS user_id_69,
s3_.tax_rate_id AS tax_rate_id_70,
s3_.previous_tax_rate_id AS previous_tax_rate_id_71,
t4_.store_id AS store_id_72,
p5_.translatable_id AS translatable_id_73,
i7_.translatable_id AS translatable_id_74
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
AND (p8_.category_id = ?)
WHERE
s1_.enabled = 1
GROUP BY
s1_.id
ORDER BY
p8_.position ASC
LIMIT
12
SELECT p0_.type AS type_0, p0_.warranty_years AS warranty_years_1, p0_.new AS new_2, p0_.id AS id_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, s1_.sku AS sku_6, s1_.quantity AS quantity_7, s1_.quantity_unit AS quantity_unit_8, s1_.ean_code AS ean_code_9, s1_.availability AS availability_10, s1_.`condition` AS condition_11, s1_.importable AS importable_12, s1_.tax_transferable AS tax_transferable_13, s1_.sale_count AS sale_count_14, s1_.disabled_at AS disabled_at_15, s1_.id AS id_16, s1_.created_at AS created_at_17, s1_.updated_at AS updated_at_18, s1_.enabled AS enabled_19, v2_.id AS id_20, v2_.position AS position_21, v2_.created_at AS created_at_22, v2_.updated_at AS updated_at_23, s3_.amount AS amount_24, s3_.tax_amount AS tax_amount_25, s3_.previous_amount AS previous_amount_26, s3_.previous_tax_amount AS previous_tax_amount_27, s3_.id AS id_28, s3_.created_at AS created_at_29, s3_.updated_at AS updated_at_30, t4_.rate AS rate_31, t4_.`precision` AS precision_32, t4_.id AS id_33, p5_.title AS title_34, p5_.h1 AS h1_35, p5_.perex AS perex_36, p5_.description AS description_37, p5_.text AS text_38, p5_.meta_title AS meta_title_39, p5_.meta_description AS meta_description_40, p5_.meta_keywords AS meta_keywords_41, p5_.slug AS slug_42, p5_.locale AS locale_43, p5_.id AS id_44, i6_.name AS name_45, i6_.original_name AS original_name_46, i6_.mime_type AS mime_type_47, i6_.size AS size_48, i6_.width AS width_49, i6_.height AS height_50, i6_.id AS id_51, i6_.created_at AS created_at_52, i6_.updated_at AS updated_at_53, i7_.title AS title_54, i7_.keywords AS keywords_55, i7_.locale AS locale_56, i7_.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, s1_.group_id AS group_id_63, v2_.principal_image_id AS principal_image_id_64, v2_.product_id AS product_id_65, v2_.stock_id AS stock_id_66, s3_.stock_id AS stock_id_67, s3_.store_id AS store_id_68, s3_.user_id AS user_id_69, s3_.tax_rate_id AS tax_rate_id_70, s3_.previous_tax_rate_id AS previous_tax_rate_id_71, t4_.store_id AS store_id_72, p5_.translatable_id AS translatable_id_73, i7_.translatable_id AS translatable_id_74 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 = 3) 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 ('de_AT', 'de')) 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 ('de_AT', 'de')) INNER JOIN product_category p8_ ON p0_.id = p8_.product_id AND (p8_.category_id = 144) WHERE s1_.enabled = 1 GROUP BY s1_.id ORDER BY p8_.position ASC LIMIT 12;
|
40.96 ms
(16.49%)
|
65 |
SELECT t0.value AS value_1, t0.on_listing AS on_listing_2, t0.configurable AS configurable_3, t0.id AS id_4, t0.position AS position_5, t0.product_id AS product_id_6, t0.attribute_id AS attribute_id_7, t0.attribute_option_id AS attribute_option_id_8, t0.principal_image_id AS principal_image_id_9 FROM product_attribute t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
SELECT t0.value AS value_1, t0.on_listing AS on_listing_2, t0.configurable AS configurable_3, t0.id AS id_4, t0.position AS position_5, t0.product_id AS product_id_6, t0.attribute_id AS attribute_id_7, t0.attribute_option_id AS attribute_option_id_8, t0.principal_image_id AS principal_image_id_9 FROM product_attribute t0 WHERE t0.product_id = 3894 ORDER BY t0.position ASC;
|
34.38 ms
(13.84%)
|
65 |
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
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 = 3894 ORDER BY t0.position ASC;
|
17.55 ms
(7.06%)
|
37 |
SELECT t0.sku AS sku_1, t0.quantity AS quantity_2, t0.quantity_unit AS quantity_unit_3, t0.ean_code AS ean_code_4, t0.availability AS availability_5, t0.`condition` AS condition_6, t0.importable AS importable_7, t0.tax_transferable AS tax_transferable_8, t0.sale_count AS sale_count_9, t0.disabled_at AS disabled_at_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.enabled AS enabled_14, t0.group_id AS group_id_15, t16.type AS type_17, t16.warranty_years AS warranty_years_18, t16.new AS new_19, t16.id AS id_20, t16.created_at AS created_at_21, t16.updated_at AS updated_at_22, t16.principal_category_id AS principal_category_id_23, t16.principal_image_id AS principal_image_id_24, t16.manufacturer_id AS manufacturer_id_25, t16.product_class_id AS product_class_id_26, t16.stock_id AS stock_id_27, t28.id AS id_29, t28.position AS position_30, t28.created_at AS created_at_31, t28.updated_at AS updated_at_32, t28.principal_image_id AS principal_image_id_33, t28.product_id AS product_id_34, t28.stock_id AS stock_id_35 FROM stock t0 LEFT JOIN product t16 ON t16.stock_id = t0.id LEFT JOIN variant t28 ON t28.stock_id = t0.id WHERE t0.id = ?
SELECT t0.sku AS sku_1, t0.quantity AS quantity_2, t0.quantity_unit AS quantity_unit_3, t0.ean_code AS ean_code_4, t0.availability AS availability_5, t0.`condition` AS condition_6, t0.importable AS importable_7, t0.tax_transferable AS tax_transferable_8, t0.sale_count AS sale_count_9, t0.disabled_at AS disabled_at_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.enabled AS enabled_14, t0.group_id AS group_id_15, t16.type AS type_17, t16.warranty_years AS warranty_years_18, t16.new AS new_19, t16.id AS id_20, t16.created_at AS created_at_21, t16.updated_at AS updated_at_22, t16.principal_category_id AS principal_category_id_23, t16.principal_image_id AS principal_image_id_24, t16.manufacturer_id AS manufacturer_id_25, t16.product_class_id AS product_class_id_26, t16.stock_id AS stock_id_27, t28.id AS id_29, t28.position AS position_30, t28.created_at AS created_at_31, t28.updated_at AS updated_at_32, t28.principal_image_id AS principal_image_id_33, t28.product_id AS product_id_34, t28.stock_id AS stock_id_35 FROM stock t0 LEFT JOIN product t16 ON t16.stock_id = t0.id LEFT JOIN variant t28 ON t28.stock_id = t0.id WHERE t0.id = 5086;
|
14.27 ms
(5.75%)
|
37 |
SELECT t0.amount AS amount_1, t0.tax_amount AS tax_amount_2, t0.previous_amount AS previous_amount_3, t0.previous_tax_amount AS previous_tax_amount_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.stock_id AS stock_id_8, t0.store_id AS store_id_9, t0.user_id AS user_id_10, t0.tax_rate_id AS tax_rate_id_11, t0.previous_tax_rate_id AS previous_tax_rate_id_12 FROM stock_price t0 WHERE t0.stock_id = ?
SELECT t0.amount AS amount_1, t0.tax_amount AS tax_amount_2, t0.previous_amount AS previous_amount_3, t0.previous_tax_amount AS previous_tax_amount_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.stock_id AS stock_id_8, t0.store_id AS store_id_9, t0.user_id AS user_id_10, t0.tax_rate_id AS tax_rate_id_11, t0.previous_tax_rate_id AS previous_tax_rate_id_12 FROM stock_price t0 WHERE t0.stock_id = 5086;
|
10.56 ms
(4.25%)
|
24 |
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 = ?
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 = 5166;
|
9.91 ms
(3.99%)
|
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_de 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: [
"de_AT"
"de"
"de_AT"
"de"
]
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_de 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
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_de 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 ('de_AT', 'de')) 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 ('de_AT', 'de')) ORDER BY m0_.lft ASC;
|
9.47 ms
(3.81%)
|
25 |
SELECT t0.quantity AS quantity_1, t0.position AS position_2, t0.parent_id AS parent_id_3, t0.item_id AS item_id_4 FROM product_set t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
SELECT t0.quantity AS quantity_1, t0.position AS position_2, t0.parent_id AS parent_id_3, t0.item_id AS item_id_4 FROM product_set t0 WHERE t0.parent_id = 5149 ORDER BY t0.position ASC;
|
4.95 ms
(1.99%)
|
13 |
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.id AS id_5, t0.translatable_id AS translatable_id_6 FROM attribute_option_translation t0 WHERE t0.translatable_id = ?
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.id AS id_5, t0.translatable_id AS translatable_id_6 FROM attribute_option_translation t0 WHERE t0.translatable_id = 21;
|
4.60 ms
(1.85%)
|
13 |
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.attribute_id AS attribute_id_5, t0.principal_image_id AS principal_image_id_6 FROM attribute_option t0 WHERE t0.id = ?
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.attribute_id AS attribute_id_5, t0.principal_image_id AS principal_image_id_6 FROM attribute_option t0 WHERE t0.id = 21;
|
3.38 ms
(1.36%)
|
9 |
SELECT t0.title AS title_1, t0.description AS description_2, t0.unit AS unit_3, t0.locale AS locale_4, t0.id AS id_5, t0.translatable_id AS translatable_id_6 FROM attribute_translation t0 WHERE t0.translatable_id = ?
SELECT t0.title AS title_1, t0.description AS description_2, t0.unit AS unit_3, t0.locale AS locale_4, t0.id AS id_5, t0.translatable_id AS translatable_id_6 FROM attribute_translation t0 WHERE t0.translatable_id = 32;
|
3.24 ms
(1.30%)
|
9 |
SELECT t0.alias AS alias_1, t0.class AS class_2, t0.icon AS icon_3, t0.on_detail AS on_detail_4, t0.on_listing AS on_listing_5, t0.expanded AS expanded_6, t0.id AS id_7, t0.position AS position_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.group_id AS group_id_11 FROM attribute t0 WHERE t0.id = ?
SELECT t0.alias AS alias_1, t0.class AS class_2, t0.icon AS icon_3, t0.on_detail AS on_detail_4, t0.on_listing AS on_listing_5, t0.expanded AS expanded_6, t0.id AS id_7, t0.position AS position_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.group_id AS group_id_11 FROM attribute t0 WHERE t0.id = 32;
|
2.19 ms
(0.88%)
|
6 |
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 = ?
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 = 5;
|
0.91 ms
(0.37%)
|
1 |
SELECT s0_.alias AS alias_0, s0_.title AS title_1, s0_.description AS description_2, s0_.id AS id_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s1_.name AS name_6, s1_.email AS email_7, s1_.url AS url_8, s1_.country AS country_9, s1_.locale AS locale_10, s1_.currency AS currency_11, s1_.order_base_number AS order_base_number_12, s1_.order_email AS order_email_13, s1_.id AS id_14, s1_.created_at AS created_at_15, s1_.updated_at AS updated_at_16, s2_.url AS url_17, s2_.mobile AS mobile_18, s2_.position AS position_19, s2_.enabled AS enabled_20, i3_.name AS name_21, i3_.original_name AS original_name_22, i3_.mime_type AS mime_type_23, i3_.size AS size_24, i3_.width AS width_25, i3_.height AS height_26, i3_.id AS id_27, i3_.created_at AS created_at_28, i3_.updated_at AS updated_at_29, i4_.title AS title_30, i4_.keywords AS keywords_31, i4_.locale AS locale_32, i4_.id AS id_33, s0_.store_id AS store_id_34, s2_.slider_id AS slider_id_35, s2_.image_id AS image_id_36, i4_.translatable_id AS translatable_id_37 FROM slider s0_ INNER JOIN store s1_ ON s0_.store_id = s1_.id LEFT JOIN slider_image s2_ ON s0_.id = s2_.slider_id LEFT JOIN image i3_ ON s2_.image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN (?, ?)) WHERE s0_.store_id = ? AND s0_.alias = ? AND s2_.enabled = 1 ORDER BY s2_.position ASC
Parameters: [
"de_AT"
"de"
3
"main"
]
SELECT s0_.alias AS alias_0, s0_.title AS title_1, s0_.description AS description_2, s0_.id AS id_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s1_.name AS name_6, s1_.email AS email_7, s1_.url AS url_8, s1_.country AS country_9, s1_.locale AS locale_10, s1_.currency AS currency_11, s1_.order_base_number AS order_base_number_12, s1_.order_email AS order_email_13, s1_.id AS id_14, s1_.created_at AS created_at_15, s1_.updated_at AS updated_at_16, s2_.url AS url_17, s2_.mobile AS mobile_18, s2_.position AS position_19, s2_.enabled AS enabled_20, i3_.name AS name_21, i3_.original_name AS original_name_22, i3_.mime_type AS mime_type_23, i3_.size AS size_24, i3_.width AS width_25, i3_.height AS height_26, i3_.id AS id_27, i3_.created_at AS created_at_28, i3_.updated_at AS updated_at_29, i4_.title AS title_30, i4_.keywords AS keywords_31, i4_.locale AS locale_32, i4_.id AS id_33, s0_.store_id AS store_id_34, s2_.slider_id AS slider_id_35, s2_.image_id AS image_id_36, i4_.translatable_id AS translatable_id_37 FROM slider s0_ INNER JOIN store s1_ ON s0_.store_id = s1_.id LEFT JOIN slider_image s2_ ON s0_.id = s2_.slider_id LEFT JOIN image i3_ ON s2_.image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN ('de_AT', 'de')) WHERE s0_.store_id = 3 AND s0_.alias = 'main' AND s2_.enabled = 1 ORDER BY s2_.position ASC;
|
0.69 ms
(0.28%)
|
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
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;
|
0.54 ms
(0.22%)
|
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 = ?
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 = 3649;
|
0.46 ms
(0.18%)
|
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 = ?
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 = 4827;
|
0.39 ms
(0.16%)
|
1 |
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.store_id = ? ORDER BY t0.id ASC
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.store_id = 3 ORDER BY t0.id ASC;
|