13.19 ms (50.03%)
|
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;
|
1.26 ms (4.77%)
|
1 |
SELECT p0_.id AS id_0, p0_.position AS position_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.enabled AS enabled_4, p1_.slug AS slug_5, p1_.title AS title_6, p1_.h1 AS h1_7, p1_.perex AS perex_8, p1_.description AS description_9, p1_.meta_title AS meta_title_10, p1_.meta_description AS meta_description_11, p1_.meta_keywords AS meta_keywords_12, p1_.locale AS locale_13, p1_.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_.parent_id AS parent_id_18, p1_.translatable_id AS translatable_id_19 FROM product_class p0_ LEFT JOIN product_class_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale IN (?, ?)) WHERE p0_.principal_category_id = ? AND p0_.enabled = 1 ORDER BY p0_.parent_id ASC, p0_.position ASC LIMIT 25
Parameters: [
"de_AT"
"de"
16
]
SELECT p0_.id AS id_0, p0_.position AS position_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.enabled AS enabled_4, p1_.slug AS slug_5, p1_.title AS title_6, p1_.h1 AS h1_7, p1_.perex AS perex_8, p1_.description AS description_9, p1_.meta_title AS meta_title_10, p1_.meta_description AS meta_description_11, p1_.meta_keywords AS meta_keywords_12, p1_.locale AS locale_13, p1_.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_.parent_id AS parent_id_18, p1_.translatable_id AS translatable_id_19 FROM product_class p0_ LEFT JOIN product_class_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale IN ('de_AT', 'de')) WHERE p0_.principal_category_id = 16 AND p0_.enabled = 1 ORDER BY p0_.parent_id ASC, p0_.position ASC LIMIT 25;
|
0.75 ms (2.86%)
|
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;
|