Symfony Profiler

SELECT
  b0_.id AS id_0,
  b1_.name AS name_1,
  b1_.slug AS slug_2,
  b0_.external_link AS external_link_3,
  b0_.position AS position_4,
  b2_.id AS id_5,
  b3_.name AS name_6,
  b3_.description AS description_7,
  m4_.file AS file_8,
  m4_.path AS path_9,
  (
    CASE WHEN b0_.position IS NULL THEN 1 ELSE 0 END
  ) AS sclr_10
FROM
  brand b0_
  LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id
  AND (b1_.language_id = ?)
  LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id
  LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id
  AND (b3_.language_id = ?)
  LEFT JOIN media m4_ ON (
    m4_.origin = ?
    AND b0_.id = m4_.id_origin
    AND m4_.type = ?
    AND (
      m4_.language_id = ?
      OR m4_.language_id IS NULL
    )
  )
WHERE
  b0_.deleted_at IS NULL
  AND b0_.is_enable = ?
  AND b0_.publication_at <= ?
  AND b0_.is_public = 1
ORDER BY
  b2_.id ASC,
  sclr_10 ASC,
  b0_.position ASC,
  b1_.name ASC

SELECT b0_.id AS id_0, b1_.name AS name_1, b1_.slug AS slug_2, b0_.external_link AS external_link_3, b0_.position AS position_4, b2_.id AS id_5, b3_.name AS name_6, b3_.description AS description_7, m4_.file AS file_8, m4_.path AS path_9, (CASE WHEN b0_.position IS NULL THEN 1 ELSE 0 END) AS sclr_10 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = 3) LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id AND (b3_.language_id = 3) LEFT JOIN media m4_ ON (m4_.origin = 'App\\Entity\\Brand\\Brand' AND b0_.id = m4_.id_origin AND m4_.type = 'TYPE_VIGNETTE' AND (m4_.language_id = 3 OR m4_.language_id IS NULL)) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = 1 AND b0_.publication_at <= '2025-01-18 02:59:55' AND b0_.is_public = 1 ORDER BY b2_.id ASC, sclr_10 ASC, b0_.position ASC, b1_.name ASC;

SELECT
  b0_.id AS id_0,
  b1_.name AS name_1,
  b1_.slug AS slug_2,
  b0_.external_link AS external_link_3,
  b0_.position AS position_4,
  b2_.id AS id_5,
  b3_.name AS name_6,
  (
    CASE WHEN b0_.position IS NULL THEN 1 ELSE 0 END
  ) AS sclr_7
FROM
  brand b0_
  LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id
  AND (b1_.language_id = ?)
  LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id
  LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id
  AND (b3_.language_id = ?)
WHERE
  b0_.deleted_at IS NULL
  AND b0_.is_enable = ?
  AND b0_.publication_at <= ?
  AND b0_.is_public = 1
ORDER BY
  b2_.id ASC,
  sclr_7 ASC,
  b0_.position ASC,
  b1_.name ASC

SELECT b0_.id AS id_0, b1_.name AS name_1, b1_.slug AS slug_2, b0_.external_link AS external_link_3, b0_.position AS position_4, b2_.id AS id_5, b3_.name AS name_6, (CASE WHEN b0_.position IS NULL THEN 1 ELSE 0 END) AS sclr_7 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = 3) LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id AND (b3_.language_id = 3) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = 1 AND b0_.publication_at <= '2025-01-18 02:59:55' AND b0_.is_public = 1 ORDER BY b2_.id ASC, sclr_7 ASC, b0_.position ASC, b1_.name ASC;

SELECT
  m0_.id AS id_0,
  m0_.is_enable AS is_enable_1,
  l1_.id AS id_2,
  m0_.title AS title_3,
  p2_.slug AS slug_4,
  m0_.page_statique AS page_statique_5,
  m0_.type AS type_6,
  c3_.slug AS slug_7,
  p4_.id AS id_8,
  m0_.position AS position_9,
  CASE WHEN m0_.position IS NULL THEN 1 ELSE 0 END AS sclr_10
FROM
  menu m0_
  LEFT JOIN page p4_ ON m0_.page_id = p4_.id
  LEFT JOIN page_lang p2_ ON p4_.id = p2_.page_id
  AND (p2_.language_id = ?)
  LEFT JOIN category c5_ ON m0_.category_id = c5_.id
  LEFT JOIN category_lang c3_ ON c5_.id = c3_.category_id
  AND (c3_.language_id = ?)
  LEFT JOIN language l1_ ON m0_.language_id = l1_.id
WHERE
  m0_.deleted_at IS NULL
  AND l1_.id = ?
  AND m0_.is_enable = ?
ORDER BY
  sclr_10 ASC,
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.is_enable AS is_enable_1, l1_.id AS id_2, m0_.title AS title_3, p2_.slug AS slug_4, m0_.page_statique AS page_statique_5, m0_.type AS type_6, c3_.slug AS slug_7, p4_.id AS id_8, m0_.position AS position_9, CASE WHEN m0_.position IS NULL THEN 1 ELSE 0 END AS sclr_10 FROM menu m0_ LEFT JOIN page p4_ ON m0_.page_id = p4_.id LEFT JOIN page_lang p2_ ON p4_.id = p2_.page_id AND (p2_.language_id = 3) LEFT JOIN category c5_ ON m0_.category_id = c5_.id LEFT JOIN category_lang c3_ ON c5_.id = c3_.category_id AND (c3_.language_id = 3) LEFT JOIN language l1_ ON m0_.language_id = l1_.id WHERE m0_.deleted_at IS NULL AND l1_.id = 3 AND m0_.is_enable = '1' ORDER BY sclr_10 ASC, m0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.route AS route_3,
  t0.parameter AS parameter_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6,
  t0.no_index AS no_index_7,
  t0.language_id AS language_id_8
FROM
  seo t0
WHERE
  t0.language_id = ?
  AND t0.parameter = ?
  AND t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.route AS route_3, t0.parameter AS parameter_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.no_index AS no_index_7, t0.language_id AS language_id_8 FROM seo t0 WHERE t0.language_id = 3 AND t0.parameter = '1' AND t0.route = 'app_page_show' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_enable AS is_enable_4,
  t0.is_default AS is_default_5
FROM
  language t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_enable AS is_enable_4, t0.is_default AS is_default_5 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.presentation AS presentation_3,
  p0_.description AS description_4,
  p0_.is_enable AS is_enable_5,
  p0_.publication_at AS publication_at_6,
  p0_.is_show_front_connect AS is_show_front_connect_7,
  p0_.language_id AS language_id_8,
  p0_.page_id AS page_id_9
FROM
  page_lang p0_
WHERE
  p0_.language_id = ?
  AND p0_.page_id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.presentation AS presentation_3, p0_.description AS description_4, p0_.is_enable AS is_enable_5, p0_.publication_at AS publication_at_6, p0_.is_show_front_connect AS is_show_front_connect_7, p0_.language_id AS language_id_8, p0_.page_id AS page_id_9 FROM page_lang p0_ WHERE p0_.language_id = 3 AND p0_.page_id = '1';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.thumbnail AS thumbnail_4,
  t0.deleted_at AS deleted_at_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  home_banner t0
WHERE
  t0.deleted_at IS NULL
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.thumbnail AS thumbnail_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM home_banner t0 WHERE t0.deleted_at IS NULL ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_public AS is_public_2,
  t0.deleted_at AS deleted_at_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.category_id AS category_id_6,
  t0.draft_id AS draft_id_7
FROM
  page t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.is_public AS is_public_2, t0.deleted_at AS deleted_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.category_id AS category_id_6, t0.draft_id AS draft_id_7 FROM page t0 WHERE t0.id IN (1);