Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.name_home AS name_home_5,
  t0.category_id AS category_id_6,
  t7.id AS id_8,
  t7.type AS type_9,
  t7.position AS position_10,
  t7.is_public AS is_public_11,
  t7.is_enable AS is_enable_12,
  t7.bg_color AS bg_color_13,
  t7.text_color AS text_color_14,
  t7.deleted_at AS deleted_at_15,
  t7.created_at AS created_at_16,
  t7.updated_at AS updated_at_17,
  t7.parent_id AS parent_id_18,
  t7.draft_id AS draft_id_19,
  t0.language_id AS language_id_20
FROM
  category_lang t0
  INNER JOIN category t7 ON t0.category_id = t7.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.name_home AS name_home_5, t0.category_id AS category_id_6, t7.id AS id_8, t7.type AS type_9, t7.position AS position_10, t7.is_public AS is_public_11, t7.is_enable AS is_enable_12, t7.bg_color AS bg_color_13, t7.text_color AS text_color_14, t7.deleted_at AS deleted_at_15, t7.created_at AS created_at_16, t7.updated_at AS updated_at_17, t7.parent_id AS parent_id_18, t7.draft_id AS draft_id_19, t0.language_id AS language_id_20 FROM category_lang t0 INNER JOIN category t7 ON t0.category_id = t7.id WHERE t0.slug = 'foire-aux-questions' 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
  c0_.id AS id_0,
  c0_.is_enable AS is_enable_1,
  c0_.is_public AS is_public_2,
  c0_.type AS type_3,
  c1_.name AS name_4,
  c1_.name_home AS name_home_5,
  c1_.slug AS slug_6,
  c1_.description AS description_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.deleted_at AS deleted_at_10
FROM
  category c0_
  LEFT JOIN category_lang c1_ ON c0_.id = c1_.category_id
  AND (c1_.language_id = ?)
WHERE
  c0_.deleted_at IS NULL
  AND c0_.is_enable = ?
  AND c1_.slug LIKE ?
  AND c0_.is_public = 1
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.is_enable AS is_enable_1, c0_.is_public AS is_public_2, c0_.type AS type_3, c1_.name AS name_4, c1_.name_home AS name_home_5, c1_.slug AS slug_6, c1_.description AS description_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.deleted_at AS deleted_at_10 FROM category c0_ LEFT JOIN category_lang c1_ ON c0_.id = c1_.category_id AND (c1_.language_id = 3) WHERE c0_.deleted_at IS NULL AND c0_.is_enable = 1 AND c1_.slug LIKE 'foire-aux-questions' AND c0_.is_public = 1 ORDER BY c0_.id DESC;

SELECT
  p0_.id AS id_0,
  p1_.is_enable AS is_enable_1,
  p0_.is_public AS is_public_2,
  p1_.name AS name_3,
  p1_.slug AS slug_4,
  p1_.presentation AS presentation_5,
  p1_.description AS description_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p1_.publication_at AS publication_at_9,
  p0_.deleted_at AS deleted_at_10,
  c2_.slug AS slug_11,
  c2_.name AS name_12,
  c2_.name_home AS name_home_13,
  c3_.id AS id_14,
  c3_.is_enable AS is_enable_15,
  c4_.name AS name_16,
  c5_.is_enable AS is_enable_17,
  c5_.is_public AS is_public_18,
  c5_.id AS id_19,
  c6_.type AS type_20,
  c4_.slug AS slug_21,
  c4_.name_home AS name_home_22,
  c6_.is_enable AS is_enable_23,
  p7_.id AS id_24
FROM
  page p0_
  LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id
  AND (p1_.language_id = ?)
  LEFT JOIN category c5_ ON p0_.category_id = c5_.id
  LEFT JOIN category_lang c4_ ON c5_.id = c4_.category_id
  AND (c4_.language_id = ?)
  LEFT JOIN category c6_ ON c4_.category_id = c6_.id
  LEFT JOIN category c3_ ON c6_.parent_id = c3_.id
  LEFT JOIN category_lang c2_ ON c3_.id = c2_.category_id
  AND (c2_.language_id = ?)
  LEFT JOIN page p7_ ON p0_.draft_id = p7_.id
  LEFT JOIN pages_profils p8_ ON p0_.id = p8_.page_id
WHERE
  c3_.deleted_at IS NULL
  AND c5_.deleted_at IS NULL
  AND p0_.deleted_at IS NULL
  AND p1_.is_enable = ?
  AND (
    p0_.category_id IN (?)
    OR c5_.parent_id IN (?)
  )
  AND c6_.is_enable = ?
  AND p0_.is_public = 1
  AND c5_.is_public = 1
  AND p1_.publication_at <= ?
  AND c5_.is_enable = ?
  AND c3_.is_enable = ?
  AND (
    p8_.profile IN (?)
    OR p8_.id IS NULL
  )
ORDER BY
  c5_.position ASC

SELECT p0_.id AS id_0, p1_.is_enable AS is_enable_1, p0_.is_public AS is_public_2, p1_.name AS name_3, p1_.slug AS slug_4, p1_.presentation AS presentation_5, p1_.description AS description_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p1_.publication_at AS publication_at_9, p0_.deleted_at AS deleted_at_10, c2_.slug AS slug_11, c2_.name AS name_12, c2_.name_home AS name_home_13, c3_.id AS id_14, c3_.is_enable AS is_enable_15, c4_.name AS name_16, c5_.is_enable AS is_enable_17, c5_.is_public AS is_public_18, c5_.id AS id_19, c6_.type AS type_20, c4_.slug AS slug_21, c4_.name_home AS name_home_22, c6_.is_enable AS is_enable_23, p7_.id AS id_24 FROM page p0_ LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id AND (p1_.language_id = 3) LEFT JOIN category c5_ ON p0_.category_id = c5_.id LEFT JOIN category_lang c4_ ON c5_.id = c4_.category_id AND (c4_.language_id = 3) LEFT JOIN category c6_ ON c4_.category_id = c6_.id LEFT JOIN category c3_ ON c6_.parent_id = c3_.id LEFT JOIN category_lang c2_ ON c3_.id = c2_.category_id AND (c2_.language_id = 3) LEFT JOIN page p7_ ON p0_.draft_id = p7_.id LEFT JOIN pages_profils p8_ ON p0_.id = p8_.page_id WHERE c3_.deleted_at IS NULL AND c5_.deleted_at IS NULL AND p0_.deleted_at IS NULL AND p1_.is_enable = 1 AND (p0_.category_id IN (1) OR c5_.parent_id IN (1)) AND c6_.is_enable = 1 AND p0_.is_public = 1 AND c5_.is_public = 1 AND p1_.publication_at <= '2024-11-25 19:41:36' AND c5_.is_enable = 1 AND c3_.is_enable = 1 AND (p8_.profile IN (1) OR p8_.id IS NULL) ORDER BY c5_.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.is_enable AS is_enable_1,
  c0_.is_public AS is_public_2,
  c0_.type AS type_3,
  c1_.name AS name_4,
  c1_.name_home AS name_home_5,
  c1_.slug AS slug_6,
  c1_.description AS description_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.deleted_at AS deleted_at_10
FROM
  category c0_
  LEFT JOIN category_lang c1_ ON c0_.id = c1_.category_id
  AND (c1_.language_id = ?)
WHERE
  c0_.deleted_at IS NULL
  AND c0_.id = ?
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.is_enable AS is_enable_1, c0_.is_public AS is_public_2, c0_.type AS type_3, c1_.name AS name_4, c1_.name_home AS name_home_5, c1_.slug AS slug_6, c1_.description AS description_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.deleted_at AS deleted_at_10 FROM category c0_ LEFT JOIN category_lang c1_ ON c0_.id = c1_.category_id AND (c1_.language_id = 3) WHERE c0_.deleted_at IS NULL AND c0_.id = 1 ORDER BY c0_.id DESC;

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_category_show' LIMIT 1;

SELECT
  b0_.id AS id_0,
  b1_.name AS name_1,
  b1_.slug AS slug_2,
  b2_.id AS id_3,
  b3_.name AS name_4
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,
  b0_.position ASC,
  b1_.name ASC

SELECT b0_.id AS id_0, b1_.name AS name_1, b1_.slug AS slug_2, b2_.id AS id_3, b3_.name AS name_4 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 <= '2024-11-25 19:41:36' AND b0_.is_public = 1 ORDER BY b2_.id ASC, b0_.position ASC, b1_.name ASC;

SELECT
  m0_.id AS id_0,
  m0_.position AS position_1,
  m0_.is_enable AS is_enable_2,
  l1_.id AS id_3,
  m0_.title AS title_4,
  p2_.slug AS slug_5,
  m0_.page_statique AS page_statique_6,
  m0_.type AS type_7,
  c3_.slug AS slug_8,
  p4_.id AS id_9
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
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.is_enable AS is_enable_2, l1_.id AS id_3, m0_.title AS title_4, p2_.slug AS slug_5, m0_.page_statique AS page_statique_6, m0_.type AS type_7, c3_.slug AS slug_8, p4_.id AS id_9 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 m0_.position ASC;