Symfony Profiler

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;

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 (?, ?)

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 = 'midea-breezeless' AND s0_.locale IN ('de_AT', 'de');

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.enabled AS enabled_5,
  t0.principal_category_id AS principal_category_id_6,
  t0.principal_image_id AS principal_image_id_7,
  t0.manufacturer_id AS manufacturer_id_8,
  t0.parent_id AS parent_id_9
FROM
  product_class 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.enabled AS enabled_5, t0.principal_category_id AS principal_category_id_6, t0.principal_image_id AS principal_image_id_7, t0.manufacturer_id AS manufacturer_id_8, t0.parent_id AS parent_id_9 FROM product_class t0 WHERE t0.id = 80;

SELECT
  t0.main_template AS main_template_1,
  t0.product_template AS product_template_2,
  t0.filterable AS filterable_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.principal_image_id AS principal_image_id_7
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.main_template AS main_template_1, t0.product_template AS product_template_2, t0.filterable AS filterable_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_image_id AS principal_image_id_7 FROM category t0 WHERE t0.id = 483;

SELECT
  t0.position AS position_1,
  t0.category_id AS category_id_2,
  t0.filter_id AS filter_id_3,
  t4.type AS type_5,
  t4.widget AS widget_6,
  t4.min_value AS min_value_7,
  t4.max_value AS max_value_8,
  t4.id AS id_9,
  t4.created_at AS created_at_10,
  t4.updated_at AS updated_at_11,
  t4.attribute_id AS attribute_id_12
FROM
  category_filter t0
  INNER JOIN filter t4 ON t0.filter_id = t4.id
WHERE
  t0.category_id = ?
ORDER BY
  t0.position ASC

SELECT t0.position AS position_1, t0.category_id AS category_id_2, t0.filter_id AS filter_id_3, t4.type AS type_5, t4.widget AS widget_6, t4.min_value AS min_value_7, t4.max_value AS max_value_8, t4.id AS id_9, t4.created_at AS created_at_10, t4.updated_at AS updated_at_11, t4.attribute_id AS attribute_id_12 FROM category_filter t0 INNER JOIN filter t4 ON t0.filter_id = t4.id WHERE t0.category_id = 483 ORDER BY t0.position ASC;

SELECT
  m0_.name AS name_0,
  m0_.slug AS slug_1,
  m0_.displayable AS displayable_2,
  m0_.id AS id_3,
  m0_.created_at AS created_at_4,
  m0_.updated_at AS updated_at_5,
  m0_.principal_image_id AS principal_image_id_6
FROM
  manufacturer m0_
  LEFT JOIN product p1_ ON m0_.id = p1_.manufacturer_id
  INNER JOIN stock s2_ ON p1_.stock_id = s2_.id
  INNER JOIN product_category p3_ ON p1_.id = p3_.product_id
  AND (p3_.category_id = ?)
WHERE
  s2_.enabled = 1
GROUP BY
  m0_.id
ORDER BY
  m0_.id ASC

SELECT m0_.name AS name_0, m0_.slug AS slug_1, m0_.displayable AS displayable_2, m0_.id AS id_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.principal_image_id AS principal_image_id_6 FROM manufacturer m0_ LEFT JOIN product p1_ ON m0_.id = p1_.manufacturer_id INNER JOIN stock s2_ ON p1_.stock_id = s2_.id INNER JOIN product_category p3_ ON p1_.id = p3_.product_id AND (p3_.category_id = 483) WHERE s2_.enabled = 1 GROUP BY m0_.id ORDER BY m0_.id ASC;

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,
  p2_.id AS id_15,
  p2_.position AS position_16,
  p2_.created_at AS created_at_17,
  p2_.updated_at AS updated_at_18,
  p2_.enabled AS enabled_19,
  p3_.slug AS slug_20,
  p3_.title AS title_21,
  p3_.h1 AS h1_22,
  p3_.perex AS perex_23,
  p3_.description AS description_24,
  p3_.meta_title AS meta_title_25,
  p3_.meta_description AS meta_description_26,
  p3_.meta_keywords AS meta_keywords_27,
  p3_.locale AS locale_28,
  p3_.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_.parent_id AS parent_id_33,
  p1_.translatable_id AS translatable_id_34,
  p2_.principal_category_id AS principal_category_id_35,
  p2_.principal_image_id AS principal_image_id_36,
  p2_.manufacturer_id AS manufacturer_id_37,
  p2_.parent_id AS parent_id_38,
  p3_.translatable_id AS translatable_id_39
FROM
  product_class p0_
  LEFT JOIN product_class_translation p1_ ON p0_.id = p1_.translatable_id
  AND (
    p1_.locale IN (?, ?)
  )
  LEFT JOIN product_class p2_ ON p0_.parent_id = p2_.id
  LEFT JOIN product_class_translation p3_ ON p2_.id = p3_.translatable_id
  AND (
    p3_.locale IN (?, ?)
  )
  LEFT JOIN product p4_ ON p0_.id = p4_.product_class_id
  INNER JOIN stock s5_ ON p4_.stock_id = s5_.id
  INNER JOIN product_category p6_ ON p4_.id = p6_.product_id
  AND (p6_.category_id = ?)
WHERE
  s5_.enabled = 1
  AND p0_.enabled = 1
GROUP BY
  p0_.id
ORDER BY
  p0_.parent_id ASC,
  p0_.manufacturer_id ASC,
  p0_.parent_id ASC,
  p0_.position ASC

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, p2_.id AS id_15, p2_.position AS position_16, p2_.created_at AS created_at_17, p2_.updated_at AS updated_at_18, p2_.enabled AS enabled_19, p3_.slug AS slug_20, p3_.title AS title_21, p3_.h1 AS h1_22, p3_.perex AS perex_23, p3_.description AS description_24, p3_.meta_title AS meta_title_25, p3_.meta_description AS meta_description_26, p3_.meta_keywords AS meta_keywords_27, p3_.locale AS locale_28, p3_.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_.parent_id AS parent_id_33, p1_.translatable_id AS translatable_id_34, p2_.principal_category_id AS principal_category_id_35, p2_.principal_image_id AS principal_image_id_36, p2_.manufacturer_id AS manufacturer_id_37, p2_.parent_id AS parent_id_38, p3_.translatable_id AS translatable_id_39 FROM product_class p0_ LEFT JOIN product_class_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale IN ('de_AT', 'de')) LEFT JOIN product_class p2_ ON p0_.parent_id = p2_.id LEFT JOIN product_class_translation p3_ ON p2_.id = p3_.translatable_id AND (p3_.locale IN ('de_AT', 'de')) LEFT JOIN product p4_ ON p0_.id = p4_.product_class_id INNER JOIN stock s5_ ON p4_.stock_id = s5_.id INNER JOIN product_category p6_ ON p4_.id = p6_.product_id AND (p6_.category_id = 483) WHERE s5_.enabled = 1 AND p0_.enabled = 1 GROUP BY p0_.id ORDER BY p0_.parent_id ASC, p0_.manufacturer_id ASC, p0_.parent_id ASC, p0_.position ASC;

SELECT
  a0_.alias AS alias_0,
  a0_.class AS class_1,
  a0_.icon AS icon_2,
  a0_.on_detail AS on_detail_3,
  a0_.on_listing AS on_listing_4,
  a0_.expanded AS expanded_5,
  a0_.id AS id_6,
  a0_.position AS position_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a1_.title AS title_10,
  a1_.description AS description_11,
  a1_.unit AS unit_12,
  a1_.locale AS locale_13,
  a1_.id AS id_14,
  f2_.type AS type_15,
  f2_.widget AS widget_16,
  f2_.min_value AS min_value_17,
  f2_.max_value AS max_value_18,
  f2_.id AS id_19,
  f2_.created_at AS created_at_20,
  f2_.updated_at AS updated_at_21,
  a3_.id AS id_22,
  a3_.position AS position_23,
  a3_.created_at AS created_at_24,
  a3_.updated_at AS updated_at_25,
  a4_.title AS title_26,
  a4_.description AS description_27,
  a4_.slug AS slug_28,
  a4_.locale AS locale_29,
  a4_.id AS id_30,
  i5_.name AS name_31,
  i5_.original_name AS original_name_32,
  i5_.mime_type AS mime_type_33,
  i5_.size AS size_34,
  i5_.width AS width_35,
  i5_.height AS height_36,
  i5_.id AS id_37,
  i5_.created_at AS created_at_38,
  i5_.updated_at AS updated_at_39,
  i6_.title AS title_40,
  i6_.keywords AS keywords_41,
  i6_.locale AS locale_42,
  i6_.id AS id_43,
  a0_.group_id AS group_id_44,
  a1_.translatable_id AS translatable_id_45,
  f2_.attribute_id AS attribute_id_46,
  a3_.attribute_id AS attribute_id_47,
  a3_.principal_image_id AS principal_image_id_48,
  a4_.translatable_id AS translatable_id_49,
  i6_.translatable_id AS translatable_id_50
FROM
  attribute a0_
  LEFT JOIN attribute_translation a1_ ON a0_.id = a1_.translatable_id
  AND (
    a1_.locale IN (?, ?)
  )
  INNER JOIN filter f2_ ON a0_.id = f2_.attribute_id
  INNER JOIN category_filter c7_ ON f2_.id = c7_.filter_id
  AND (c7_.category_id = ?)
  INNER JOIN product_attribute p8_ FORCE INDEX (unique_attribute) ON a0_.id = p8_.attribute_id
  LEFT JOIN product p9_ ON p8_.product_id = p9_.id
  INNER JOIN stock s10_ ON p9_.stock_id = s10_.id
  INNER JOIN product_category p11_ ON p9_.id = p11_.product_id
  AND (p11_.category_id = ?)
  LEFT JOIN attribute_option a3_ ON a0_.id = a3_.attribute_id
  LEFT JOIN attribute_option_translation a4_ ON a3_.id = a4_.translatable_id
  AND (
    a4_.locale IN (?, ?)
  )
  LEFT JOIN image i5_ ON a3_.principal_image_id = i5_.id
  LEFT JOIN image_translation i6_ ON i5_.id = i6_.translatable_id
  AND (
    i6_.locale IN (?, ?)
  )
WHERE
  s10_.enabled = 1
  AND (
    p8_.attribute_option_id IS NULL
    OR p8_.attribute_option_id = a3_.id
  )
GROUP BY
  a0_.id,
  a3_.id
ORDER BY
  a0_.group_id ASC,
  a0_.position ASC,
  a3_.position ASC

SELECT a0_.alias AS alias_0, a0_.class AS class_1, a0_.icon AS icon_2, a0_.on_detail AS on_detail_3, a0_.on_listing AS on_listing_4, a0_.expanded AS expanded_5, a0_.id AS id_6, a0_.position AS position_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a1_.title AS title_10, a1_.description AS description_11, a1_.unit AS unit_12, a1_.locale AS locale_13, a1_.id AS id_14, f2_.type AS type_15, f2_.widget AS widget_16, f2_.min_value AS min_value_17, f2_.max_value AS max_value_18, f2_.id AS id_19, f2_.created_at AS created_at_20, f2_.updated_at AS updated_at_21, a3_.id AS id_22, a3_.position AS position_23, a3_.created_at AS created_at_24, a3_.updated_at AS updated_at_25, a4_.title AS title_26, a4_.description AS description_27, a4_.slug AS slug_28, a4_.locale AS locale_29, a4_.id AS id_30, i5_.name AS name_31, i5_.original_name AS original_name_32, i5_.mime_type AS mime_type_33, i5_.size AS size_34, i5_.width AS width_35, i5_.height AS height_36, i5_.id AS id_37, i5_.created_at AS created_at_38, i5_.updated_at AS updated_at_39, i6_.title AS title_40, i6_.keywords AS keywords_41, i6_.locale AS locale_42, i6_.id AS id_43, a0_.group_id AS group_id_44, a1_.translatable_id AS translatable_id_45, f2_.attribute_id AS attribute_id_46, a3_.attribute_id AS attribute_id_47, a3_.principal_image_id AS principal_image_id_48, a4_.translatable_id AS translatable_id_49, i6_.translatable_id AS translatable_id_50 FROM attribute a0_ LEFT JOIN attribute_translation a1_ ON a0_.id = a1_.translatable_id AND (a1_.locale IN ('de_AT', 'de')) INNER JOIN filter f2_ ON a0_.id = f2_.attribute_id INNER JOIN category_filter c7_ ON f2_.id = c7_.filter_id AND (c7_.category_id = 483) INNER JOIN product_attribute p8_ FORCE INDEX (unique_attribute) ON a0_.id = p8_.attribute_id LEFT JOIN product p9_ ON p8_.product_id = p9_.id INNER JOIN stock s10_ ON p9_.stock_id = s10_.id INNER JOIN product_category p11_ ON p9_.id = p11_.product_id AND (p11_.category_id = 483) LEFT JOIN attribute_option a3_ ON a0_.id = a3_.attribute_id LEFT JOIN attribute_option_translation a4_ ON a3_.id = a4_.translatable_id AND (a4_.locale IN ('de_AT', 'de')) LEFT JOIN image i5_ ON a3_.principal_image_id = i5_.id LEFT JOIN image_translation i6_ ON i5_.id = i6_.translatable_id AND (i6_.locale IN ('de_AT', 'de')) WHERE s10_.enabled = 1 AND (p8_.attribute_option_id IS NULL OR p8_.attribute_option_id = a3_.id) GROUP BY a0_.id, a3_.id ORDER BY a0_.group_id ASC, a0_.position ASC, a3_.position ASC;

SELECT
  MAX(s0_.amount) AS sclr_0,
  p1_.type AS type_1,
  p1_.warranty_years AS warranty_years_2,
  p1_.new AS new_3,
  p1_.id AS id_4,
  p1_.created_at AS created_at_5,
  p1_.updated_at AS updated_at_6,
  s2_.sku AS sku_7,
  s2_.quantity AS quantity_8,
  s2_.quantity_unit AS quantity_unit_9,
  s2_.ean_code AS ean_code_10,
  s2_.availability AS availability_11,
  s2_.`condition` AS condition_12,
  s2_.importable AS importable_13,
  s2_.tax_transferable AS tax_transferable_14,
  s2_.sale_count AS sale_count_15,
  s2_.disabled_at AS disabled_at_16,
  s2_.id AS id_17,
  s2_.created_at AS created_at_18,
  s2_.updated_at AS updated_at_19,
  s2_.enabled AS enabled_20,
  s0_.amount AS amount_21,
  s0_.tax_amount AS tax_amount_22,
  s0_.previous_amount AS previous_amount_23,
  s0_.previous_tax_amount AS previous_tax_amount_24,
  s0_.id AS id_25,
  s0_.created_at AS created_at_26,
  s0_.updated_at AS updated_at_27,
  t3_.rate AS rate_28,
  t3_.`precision` AS precision_29,
  t3_.id AS id_30,
  p1_.principal_category_id AS principal_category_id_31,
  p1_.principal_image_id AS principal_image_id_32,
  p1_.manufacturer_id AS manufacturer_id_33,
  p1_.product_class_id AS product_class_id_34,
  p1_.stock_id AS stock_id_35,
  s2_.group_id AS group_id_36,
  s0_.stock_id AS stock_id_37,
  s0_.store_id AS store_id_38,
  s0_.user_id AS user_id_39,
  s0_.tax_rate_id AS tax_rate_id_40,
  s0_.previous_tax_rate_id AS previous_tax_rate_id_41,
  t3_.store_id AS store_id_42
FROM
  product p1_
  INNER JOIN stock s2_ ON p1_.stock_id = s2_.id
  INNER JOIN stock_price s0_ ON s2_.id = s0_.stock_id
  AND (s0_.store_id = ?)
  INNER JOIN tax_rate t3_ ON s0_.tax_rate_id = t3_.id
  LEFT JOIN product_category p4_ ON p1_.id = p4_.product_id
WHERE
  p4_.category_id = ?
  AND s2_.enabled = 1
GROUP BY
  s0_.stock_id
ORDER BY
  sclr_0 DESC
LIMIT
  1

SELECT MAX(s0_.amount) AS sclr_0, p1_.type AS type_1, p1_.warranty_years AS warranty_years_2, p1_.new AS new_3, p1_.id AS id_4, p1_.created_at AS created_at_5, p1_.updated_at AS updated_at_6, s2_.sku AS sku_7, s2_.quantity AS quantity_8, s2_.quantity_unit AS quantity_unit_9, s2_.ean_code AS ean_code_10, s2_.availability AS availability_11, s2_.`condition` AS condition_12, s2_.importable AS importable_13, s2_.tax_transferable AS tax_transferable_14, s2_.sale_count AS sale_count_15, s2_.disabled_at AS disabled_at_16, s2_.id AS id_17, s2_.created_at AS created_at_18, s2_.updated_at AS updated_at_19, s2_.enabled AS enabled_20, s0_.amount AS amount_21, s0_.tax_amount AS tax_amount_22, s0_.previous_amount AS previous_amount_23, s0_.previous_tax_amount AS previous_tax_amount_24, s0_.id AS id_25, s0_.created_at AS created_at_26, s0_.updated_at AS updated_at_27, t3_.rate AS rate_28, t3_.`precision` AS precision_29, t3_.id AS id_30, p1_.principal_category_id AS principal_category_id_31, p1_.principal_image_id AS principal_image_id_32, p1_.manufacturer_id AS manufacturer_id_33, p1_.product_class_id AS product_class_id_34, p1_.stock_id AS stock_id_35, s2_.group_id AS group_id_36, s0_.stock_id AS stock_id_37, s0_.store_id AS store_id_38, s0_.user_id AS user_id_39, s0_.tax_rate_id AS tax_rate_id_40, s0_.previous_tax_rate_id AS previous_tax_rate_id_41, t3_.store_id AS store_id_42 FROM product p1_ INNER JOIN stock s2_ ON p1_.stock_id = s2_.id INNER JOIN stock_price s0_ ON s2_.id = s0_.stock_id AND (s0_.store_id = 3) INNER JOIN tax_rate t3_ ON s0_.tax_rate_id = t3_.id LEFT JOIN product_category p4_ ON p1_.id = p4_.product_id WHERE p4_.category_id = 483 AND s2_.enabled = 1 GROUP BY s0_.stock_id ORDER BY sclr_0 DESC LIMIT 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 = 10420;

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