Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.description AS description_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.published AS published_10,
  t0.sort_index AS sort_index_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.banner_id AS banner_id_14
FROM
  product_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.slug = 'external_audio_boxes' LIMIT 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '351' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  MAX(p0_.price_gross_amount) AS sclr_0
FROM
  products p0_
  INNER JOIN products_categories p1_ ON (p0_.id = p1_.product_id)
WHERE
  (
    p1_.category_id = ?
    AND p0_.published = ?
    AND p0_.status NOT IN (?, ?)
  )
  AND p0_.discr IN ('product', 'product_kit')

SELECT MAX(p0_.price_gross_amount) AS sclr_0 FROM products p0_ INNER JOIN products_categories p1_ ON (p0_.id = p1_.product_id) WHERE (p1_.category_id = 351 AND p0_.published = 1 AND p0_.status NOT IN ('view', 'no_view')) AND p0_.discr IN ('product', 'product_kit');

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.name AS name_1,
      p0_.slug AS slug_2,
      p0_.summary AS summary_3,
      p0_.status AS status_4,
      p0_.price_gross_amount AS price_gross_amount_5,
      p0_.price_gross_currency AS price_gross_currency_6,
      p0_.price_with_discount_amount AS price_with_discount_amount_7,
      p0_.price_with_discount_currency AS price_with_discount_currency_8,
      p0_.warehouse_stock_quantity AS warehouse_stock_quantity_9,
      p0_.availability AS availability_10,
      p0_.mfr_code AS mfr_code_11,
      p0_.blk_code AS blk_code_12,
      p0_.offer AS offer_13,
      p0_.cash_back AS cash_back_14,
      p1_.id AS id_15,
      p1_.name AS name_16,
      a2_.name AS name_17,
      a2_.path AS path_18,
      p3_.id AS id_19,
      p3_.name AS name_20,
      p3_.slug AS slug_21,
      a4_.name AS name_22,
      a4_.path AS path_23,
      p5_.slug AS slug_24,
      GROUP_CONCAT(DISTINCT p6_.website) AS sclr_25,
      GROUP_CONCAT(
        DISTINCT CONCAT(p7_.lvl, ':', p7_.name)
        ORDER BY
          p7_.lft ASC SEPARATOR '||'
      ) AS sclr_26
    FROM
      products p0_
      INNER JOIN product_manufacturer p3_ ON (p0_.manufacturer_id = p3_.id)
      INNER JOIN app_file a4_ ON (p3_.logo_id = a4_.id)
      AND a4_.discr IN ('manufacturer_logo')
      INNER JOIN products_categories p8_ ON (
        p0_.id = p8_.product_id
        AND p8_.main = 1
      )
      INNER JOIN product_category p5_ ON (p8_.category_id = p5_.id)
      INNER JOIN products_categories p9_ ON (p0_.id = p9_.product_id)
      INNER JOIN product_category p7_ ON (p9_.category_id = p7_.id)
      INNER JOIN product_type p1_ ON (p0_.type_id = p1_.id)
      LEFT JOIN app_file a2_ ON (p0_.main_image_id = a2_.id)
      AND a2_.discr IN (
        'article_image', 'product_image',
        'product_category_banner', 'manufacturer_logo',
        'product_reference_pdf', 'product_reference_image',
        'slider_image'
      )
      LEFT JOIN product_extra_website p6_ ON p0_.id = p6_.product_id
    WHERE
      (
        p9_.category_id = ?
        AND p0_.published = ?
        AND p0_.status NOT IN (?, ?)
      )
      AND p0_.discr IN ('product', 'product_kit')
    GROUP BY
      p0_.id
    ORDER BY
      p0_.name ASC
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.summary AS summary_3, p0_.status AS status_4, p0_.price_gross_amount AS price_gross_amount_5, p0_.price_gross_currency AS price_gross_currency_6, p0_.price_with_discount_amount AS price_with_discount_amount_7, p0_.price_with_discount_currency AS price_with_discount_currency_8, p0_.warehouse_stock_quantity AS warehouse_stock_quantity_9, p0_.availability AS availability_10, p0_.mfr_code AS mfr_code_11, p0_.blk_code AS blk_code_12, p0_.offer AS offer_13, p0_.cash_back AS cash_back_14, p1_.id AS id_15, p1_.name AS name_16, a2_.name AS name_17, a2_.path AS path_18, p3_.id AS id_19, p3_.name AS name_20, p3_.slug AS slug_21, a4_.name AS name_22, a4_.path AS path_23, p5_.slug AS slug_24, GROUP_CONCAT(DISTINCT p6_.website) AS sclr_25, GROUP_CONCAT(DISTINCT CONCAT(p7_.lvl, ':', p7_.name)  ORDER BY p7_.lft ASC SEPARATOR '||') AS sclr_26 FROM products p0_ INNER JOIN product_manufacturer p3_ ON (p0_.manufacturer_id = p3_.id) INNER JOIN app_file a4_ ON (p3_.logo_id = a4_.id) AND a4_.discr IN ('manufacturer_logo') INNER JOIN products_categories p8_ ON (p0_.id = p8_.product_id AND p8_.main = 1) INNER JOIN product_category p5_ ON (p8_.category_id = p5_.id) INNER JOIN products_categories p9_ ON (p0_.id = p9_.product_id) INNER JOIN product_category p7_ ON (p9_.category_id = p7_.id) INNER JOIN product_type p1_ ON (p0_.type_id = p1_.id) LEFT JOIN app_file a2_ ON (p0_.main_image_id = a2_.id) AND a2_.discr IN ('article_image', 'product_image', 'product_category_banner', 'manufacturer_logo', 'product_reference_pdf', 'product_reference_image', 'slider_image') LEFT JOIN product_extra_website p6_ ON p0_.id = p6_.product_id WHERE (p9_.category_id = 351 AND p0_.published = 1 AND p0_.status NOT IN ('view', 'no_view')) AND p0_.discr IN ('product', 'product_kit') GROUP BY p0_.id ORDER BY p0_.name ASC) dctrn_table;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.summary AS summary_3,
  p0_.status AS status_4,
  p0_.price_gross_amount AS price_gross_amount_5,
  p0_.price_gross_currency AS price_gross_currency_6,
  p0_.price_with_discount_amount AS price_with_discount_amount_7,
  p0_.price_with_discount_currency AS price_with_discount_currency_8,
  p0_.warehouse_stock_quantity AS warehouse_stock_quantity_9,
  p0_.availability AS availability_10,
  p0_.mfr_code AS mfr_code_11,
  p0_.blk_code AS blk_code_12,
  p0_.offer AS offer_13,
  p0_.cash_back AS cash_back_14,
  p1_.id AS id_15,
  p1_.name AS name_16,
  a2_.name AS name_17,
  a2_.path AS path_18,
  p3_.id AS id_19,
  p3_.name AS name_20,
  p3_.slug AS slug_21,
  a4_.name AS name_22,
  a4_.path AS path_23,
  p5_.slug AS slug_24,
  GROUP_CONCAT(DISTINCT p6_.website) AS sclr_25,
  GROUP_CONCAT(
    DISTINCT CONCAT(p7_.lvl, ':', p7_.name)
    ORDER BY
      p7_.lft ASC SEPARATOR '||'
  ) AS sclr_26
FROM
  products p0_
  INNER JOIN product_manufacturer p3_ ON (p0_.manufacturer_id = p3_.id)
  INNER JOIN app_file a4_ ON (p3_.logo_id = a4_.id)
  AND a4_.discr IN ('manufacturer_logo')
  INNER JOIN products_categories p8_ ON (
    p0_.id = p8_.product_id
    AND p8_.main = 1
  )
  INNER JOIN product_category p5_ ON (p8_.category_id = p5_.id)
  INNER JOIN products_categories p9_ ON (p0_.id = p9_.product_id)
  INNER JOIN product_category p7_ ON (p9_.category_id = p7_.id)
  INNER JOIN product_type p1_ ON (p0_.type_id = p1_.id)
  LEFT JOIN app_file a2_ ON (p0_.main_image_id = a2_.id)
  AND a2_.discr IN (
    'article_image', 'product_image',
    'product_category_banner', 'manufacturer_logo',
    'product_reference_pdf', 'product_reference_image',
    'slider_image'
  )
  LEFT JOIN product_extra_website p6_ ON p0_.id = p6_.product_id
WHERE
  (
    p9_.category_id = ?
    AND p0_.published = ?
    AND p0_.status NOT IN (?, ?)
  )
  AND p0_.discr IN ('product', 'product_kit')
GROUP BY
  p0_.id
ORDER BY
  p0_.name ASC
LIMIT
  15

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.summary AS summary_3, p0_.status AS status_4, p0_.price_gross_amount AS price_gross_amount_5, p0_.price_gross_currency AS price_gross_currency_6, p0_.price_with_discount_amount AS price_with_discount_amount_7, p0_.price_with_discount_currency AS price_with_discount_currency_8, p0_.warehouse_stock_quantity AS warehouse_stock_quantity_9, p0_.availability AS availability_10, p0_.mfr_code AS mfr_code_11, p0_.blk_code AS blk_code_12, p0_.offer AS offer_13, p0_.cash_back AS cash_back_14, p1_.id AS id_15, p1_.name AS name_16, a2_.name AS name_17, a2_.path AS path_18, p3_.id AS id_19, p3_.name AS name_20, p3_.slug AS slug_21, a4_.name AS name_22, a4_.path AS path_23, p5_.slug AS slug_24, GROUP_CONCAT(DISTINCT p6_.website) AS sclr_25, GROUP_CONCAT(DISTINCT CONCAT(p7_.lvl, ':', p7_.name)  ORDER BY p7_.lft ASC SEPARATOR '||') AS sclr_26 FROM products p0_ INNER JOIN product_manufacturer p3_ ON (p0_.manufacturer_id = p3_.id) INNER JOIN app_file a4_ ON (p3_.logo_id = a4_.id) AND a4_.discr IN ('manufacturer_logo') INNER JOIN products_categories p8_ ON (p0_.id = p8_.product_id AND p8_.main = 1) INNER JOIN product_category p5_ ON (p8_.category_id = p5_.id) INNER JOIN products_categories p9_ ON (p0_.id = p9_.product_id) INNER JOIN product_category p7_ ON (p9_.category_id = p7_.id) INNER JOIN product_type p1_ ON (p0_.type_id = p1_.id) LEFT JOIN app_file a2_ ON (p0_.main_image_id = a2_.id) AND a2_.discr IN ('article_image', 'product_image', 'product_category_banner', 'manufacturer_logo', 'product_reference_pdf', 'product_reference_image', 'slider_image') LEFT JOIN product_extra_website p6_ ON p0_.id = p6_.product_id WHERE (p9_.category_id = 351 AND p0_.published = 1 AND p0_.status NOT IN ('view', 'no_view')) AND p0_.discr IN ('product', 'product_kit') GROUP BY p0_.id ORDER BY p0_.name ASC LIMIT 15;

SELECT
  p0_.name AS name_0,
  a1_.name AS name_1,
  a1_.id AS id_2,
  a1_.sort_index AS sort_index_3,
  a1_.filter_type AS filter_type_4,
  a2_.value AS value_5,
  a2_.id AS id_6,
  a2_.sort_index AS sort_index_7,
  p3_.text_value AS text_value_8,
  COUNT(DISTINCT p4_.id) AS sclr_9
FROM
  product_attribute_value p3_
  INNER JOIN products p4_ ON p3_.product_id = p4_.id
  AND p4_.discr IN ('product', 'product_kit')
  INNER JOIN product_type p0_ ON p4_.type_id = p0_.id
  INNER JOIN attribute a1_ ON p3_.attribute_id = a1_.id
  LEFT JOIN attribute_value a2_ ON p3_.attribute_value_id = a2_.id
  INNER JOIN products_categories p5_ ON p4_.id = p5_.product_id
WHERE
  p5_.category_id = ?
  AND a1_.filter = 1
  AND p4_.published = ?
  AND p4_.status NOT IN (?, ?)
GROUP BY
  p0_.name,
  a1_.name,
  a1_.id,
  a1_.sort_index,
  a1_.filter_type,
  a2_.value,
  a2_.id,
  a2_.sort_index,
  p3_.text_value

SELECT p0_.name AS name_0, a1_.name AS name_1, a1_.id AS id_2, a1_.sort_index AS sort_index_3, a1_.filter_type AS filter_type_4, a2_.value AS value_5, a2_.id AS id_6, a2_.sort_index AS sort_index_7, p3_.text_value AS text_value_8, COUNT(DISTINCT p4_.id) AS sclr_9 FROM product_attribute_value p3_ INNER JOIN products p4_ ON p3_.product_id = p4_.id AND p4_.discr IN ('product', 'product_kit') INNER JOIN product_type p0_ ON p4_.type_id = p0_.id INNER JOIN attribute a1_ ON p3_.attribute_id = a1_.id LEFT JOIN attribute_value a2_ ON p3_.attribute_value_id = a2_.id INNER JOIN products_categories p5_ ON p4_.id = p5_.product_id WHERE p5_.category_id = 351 AND a1_.filter = 1 AND p4_.published = 1 AND p4_.status NOT IN ('view', 'no_view') GROUP BY p0_.name, a1_.name, a1_.id, a1_.sort_index, a1_.filter_type, a2_.value, a2_.id, a2_.sort_index, p3_.text_value;

SELECT
  p0_.name AS name_0,
  a1_.name AS name_1,
  a1_.id AS id_2,
  a1_.sort_index AS sort_index_3,
  a1_.filter_type AS filter_type_4,
  a2_.value AS value_5,
  a2_.id AS id_6,
  a2_.sort_index AS sort_index_7,
  p3_.text_value AS text_value_8,
  COUNT(DISTINCT p4_.id) AS sclr_9
FROM
  product_attribute_value p3_
  INNER JOIN products p4_ ON p3_.product_id = p4_.id
  AND p4_.discr IN ('product', 'product_kit')
  INNER JOIN product_type p0_ ON p4_.type_id = p0_.id
  INNER JOIN attribute a1_ ON p3_.attribute_id = a1_.id
  LEFT JOIN attribute_value a2_ ON p3_.attribute_value_id = a2_.id
  INNER JOIN products_categories p5_ ON p4_.id = p5_.product_id
WHERE
  p5_.category_id = ?
  AND a1_.filter = 1
  AND p4_.published = ?
  AND p4_.status NOT IN (?, ?)
GROUP BY
  p0_.name,
  a1_.name,
  a1_.id,
  a1_.sort_index,
  a1_.filter_type,
  a2_.value,
  a2_.id,
  a2_.sort_index,
  p3_.text_value

SELECT p0_.name AS name_0, a1_.name AS name_1, a1_.id AS id_2, a1_.sort_index AS sort_index_3, a1_.filter_type AS filter_type_4, a2_.value AS value_5, a2_.id AS id_6, a2_.sort_index AS sort_index_7, p3_.text_value AS text_value_8, COUNT(DISTINCT p4_.id) AS sclr_9 FROM product_attribute_value p3_ INNER JOIN products p4_ ON p3_.product_id = p4_.id AND p4_.discr IN ('product', 'product_kit') INNER JOIN product_type p0_ ON p4_.type_id = p0_.id INNER JOIN attribute a1_ ON p3_.attribute_id = a1_.id LEFT JOIN attribute_value a2_ ON p3_.attribute_value_id = a2_.id INNER JOIN products_categories p5_ ON p4_.id = p5_.product_id WHERE p5_.category_id = 351 AND a1_.filter = 1 AND p4_.published = 1 AND p4_.status NOT IN ('view', 'no_view') GROUP BY p0_.name, a1_.name, a1_.id, a1_.sort_index, a1_.filter_type, a2_.value, a2_.id, a2_.sort_index, p3_.text_value;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2
FROM
  products p1_
  INNER JOIN product_manufacturer p0_ ON p1_.manufacturer_id = p0_.id
  INNER JOIN products_categories p2_ ON p1_.id = p2_.product_id
WHERE
  (
    p2_.category_id = ?
    AND p1_.published = ?
    AND p1_.status NOT IN (?, ?)
  )
  AND p1_.discr IN ('product', 'product_kit')
ORDER BY
  p0_.name ASC

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2 FROM products p1_ INNER JOIN product_manufacturer p0_ ON p1_.manufacturer_id = p0_.id INNER JOIN products_categories p2_ ON p1_.id = p2_.product_id WHERE (p2_.category_id = 351 AND p1_.published = 1 AND p1_.status NOT IN ('view', 'no_view')) AND p1_.discr IN ('product', 'product_kit') ORDER BY p0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.user_id AS user_id_5
FROM
  cart t0
WHERE
  t0.session_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM cart t0 WHERE t0.session_id = 'cart_69d758a7d38183.15655278' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.website AS website_5,
  t0.page_name AS page_name_6,
  t0.slug AS slug_7,
  t0.url AS url_8,
  t0.internal_url_data AS internal_url_data_9,
  t0.description AS description_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.published AS published_14,
  t0.sort_index AS sort_index_15,
  t0.tree_root AS tree_root_16,
  t0.parent_id AS parent_id_17
FROM
  menu t0
WHERE
  t0.lvl = ?
  AND t0.website = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.lvl = 0 AND t0.website = 'blk.gr' ORDER BY t0.id ASC LIMIT 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Menu';

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.website AS website_5,
  t0.page_name AS page_name_6,
  t0.slug AS slug_7,
  t0.url AS url_8,
  t0.internal_url_data AS internal_url_data_9,
  t0.description AS description_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.published AS published_14,
  t0.sort_index AS sort_index_15,
  t0.tree_root AS tree_root_16,
  t0.parent_id AS parent_id_17
FROM
  menu t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = 1 ORDER BY t0.lft ASC;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '2' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Menu';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '12' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Menu';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '6' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Menu';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '13' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Menu';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '14' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Menu';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '8' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Menu';

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.website AS website_5,
  t0.page_name AS page_name_6,
  t0.slug AS slug_7,
  t0.url AS url_8,
  t0.internal_url_data AS internal_url_data_9,
  t0.description AS description_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.published AS published_14,
  t0.sort_index AS sort_index_15,
  t0.tree_root AS tree_root_16,
  t0.parent_id AS parent_id_17
FROM
  menu t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = 2 ORDER BY t0.lft ASC;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Menu';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '4' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Menu';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '9' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Menu';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '10' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Menu';

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.website AS website_5,
  t0.page_name AS page_name_6,
  t0.slug AS slug_7,
  t0.url AS url_8,
  t0.internal_url_data AS internal_url_data_9,
  t0.description AS description_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.published AS published_14,
  t0.sort_index AS sort_index_15,
  t0.tree_root AS tree_root_16,
  t0.parent_id AS parent_id_17
FROM
  menu t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = 3 ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.website AS website_5,
  t0.page_name AS page_name_6,
  t0.slug AS slug_7,
  t0.url AS url_8,
  t0.internal_url_data AS internal_url_data_9,
  t0.description AS description_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.published AS published_14,
  t0.sort_index AS sort_index_15,
  t0.tree_root AS tree_root_16,
  t0.parent_id AS parent_id_17
FROM
  menu t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = 4 ORDER BY t0.lft ASC;