Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.presentation AS presentation_4,
  t0.presentation_public AS presentation_public_5,
  t0.description AS description_6,
  t0.description_public AS description_public_7,
  t0.language_id AS language_id_8,
  t0.brand_id AS brand_id_9
FROM
  brand_lang t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.presentation AS presentation_4, t0.presentation_public AS presentation_public_5, t0.description AS description_6, t0.description_public AS description_public_7, t0.language_id AS language_id_8, t0.brand_id AS brand_id_9 FROM brand_lang t0 WHERE t0.slug = 'marque-publique-inactive' 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
  t0.id AS id_1,
  t0.position AS position_2,
  t0.is_public AS is_public_3,
  t0.is_enable AS is_enable_4,
  t0.is_show_in_mosaic AS is_show_in_mosaic_5,
  t0.publication_at AS publication_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.brand_type_id AS brand_type_id_10,
  t0.draft_id AS draft_id_11
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_public AS is_public_3, t0.is_enable AS is_enable_4, t0.is_show_in_mosaic AS is_show_in_mosaic_5, t0.publication_at AS publication_at_6, t0.deleted_at AS deleted_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.brand_type_id AS brand_type_id_10, t0.draft_id AS draft_id_11 FROM brand t0 WHERE t0.id = 10;

SELECT
  m0_.id AS id_0,
  m0_.origin AS origin_1,
  m0_.id_origin AS id_origin_2,
  m0_.type AS type_3,
  m0_.type_file AS type_file_4,
  m0_.file AS file_5,
  m0_.title AS title_6,
  m0_.path AS path_7,
  m0_.extension AS extension_8,
  m0_.size AS size_9,
  m0_.deleted_at AS deleted_at_10,
  m0_.created_at AS created_at_11,
  m0_.updated_at AS updated_at_12,
  m0_.language_id AS language_id_13
FROM
  media m0_
WHERE
  m0_.origin = ?
  AND m0_.id_origin = ?
  AND m0_.deleted_at IS NULL
  AND (
    m0_.language_id = ?
    OR m0_.language_id IS NULL
  )
ORDER BY
  m0_.id DESC

SELECT m0_.id AS id_0, m0_.origin AS origin_1, m0_.id_origin AS id_origin_2, m0_.type AS type_3, m0_.type_file AS type_file_4, m0_.file AS file_5, m0_.title AS title_6, m0_.path AS path_7, m0_.extension AS extension_8, m0_.size AS size_9, m0_.deleted_at AS deleted_at_10, m0_.created_at AS created_at_11, m0_.updated_at AS updated_at_12, m0_.language_id AS language_id_13 FROM media m0_ WHERE m0_.origin = 'App\\Entity\\Brand\\Brand' AND m0_.id_origin = 10 AND m0_.deleted_at IS NULL AND (m0_.language_id = 3 OR m0_.language_id IS NULL) ORDER BY m0_.id DESC;

SELECT
  b0_.id AS id_0,
  b0_.is_public AS is_public_1,
  b0_.is_connected AS is_connected_2,
  b0_.brand_id AS brand_id_3,
  b0_.file_id AS file_id_4
FROM
  brand_attachment b0_
  LEFT JOIN media m1_ ON b0_.file_id = m1_.id
WHERE
  m1_.deleted_at IS NULL
  AND b0_.brand_id = ?
  AND (
    m1_.language_id = ?
    OR m1_.language_id IS NULL
  )
  AND b0_.is_public = 1

SELECT b0_.id AS id_0, b0_.is_public AS is_public_1, b0_.is_connected AS is_connected_2, b0_.brand_id AS brand_id_3, b0_.file_id AS file_id_4 FROM brand_attachment b0_ LEFT JOIN media m1_ ON b0_.file_id = m1_.id WHERE m1_.deleted_at IS NULL AND b0_.brand_id = 10 AND (m1_.language_id = 3 OR m1_.language_id IS NULL) AND b0_.is_public = 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 = ?
  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 = 10 AND t0.route = 'app_front_brand_index' LIMIT 1;

SELECT
  b0_.language_id AS sclr_0,
  b0_.slug AS slug_1
FROM
  brand_lang b1_
  LEFT JOIN brand b2_ ON b1_.brand_id = b2_.id
  LEFT JOIN brand_lang b0_ ON b2_.id = b0_.brand_id
WHERE
  b1_.slug = ?

SELECT b0_.language_id AS sclr_0, b0_.slug AS slug_1 FROM brand_lang b1_ LEFT JOIN brand b2_ ON b1_.brand_id = b2_.id LEFT JOIN brand_lang b0_ ON b2_.id = b0_.brand_id WHERE b1_.slug = 'marque-publique-inactive';

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 17:48:27' AND b0_.is_public = 1 ORDER BY b2_.id ASC, b0_.position ASC, b1_.name ASC;

SELECT
  t0.id AS id_1,
  t0.origin AS origin_2,
  t0.id_origin AS id_origin_3,
  t0.is_connected AS is_connected_4,
  t0.is_public AS is_public_5,
  t0.type AS type_6,
  t0.is_show_title AS is_show_title_7,
  t0.is_slideshow AS is_slideshow_8,
  t0.position AS position_9,
  t0.name AS name_10,
  t0.legende AS legende_11,
  t0.is_generic AS is_generic_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.language_id AS language_id_15,
  t0.parent_id AS parent_id_16,
  t17.id AS id_18,
  t17.origin AS origin_19,
  t17.id_origin AS id_origin_20,
  t17.is_connected AS is_connected_21,
  t17.is_public AS is_public_22,
  t17.type AS type_23,
  t17.is_show_title AS is_show_title_24,
  t17.is_slideshow AS is_slideshow_25,
  t17.position AS position_26,
  t17.name AS name_27,
  t17.legende AS legende_28,
  t17.is_generic AS is_generic_29,
  t17.created_at AS created_at_30,
  t17.updated_at AS updated_at_31,
  t17.language_id AS language_id_32,
  t17.parent_id AS parent_id_33
FROM
  bloc t0
  LEFT JOIN bloc t17 ON t0.parent_id = t17.id
WHERE
  t0.origin = ?
  AND t0.id_origin = ?
  AND t0.language_id = ?
  AND t0.is_public = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.id_origin AS id_origin_3, t0.is_connected AS is_connected_4, t0.is_public AS is_public_5, t0.type AS type_6, t0.is_show_title AS is_show_title_7, t0.is_slideshow AS is_slideshow_8, t0.position AS position_9, t0.name AS name_10, t0.legende AS legende_11, t0.is_generic AS is_generic_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.language_id AS language_id_15, t0.parent_id AS parent_id_16, t17.id AS id_18, t17.origin AS origin_19, t17.id_origin AS id_origin_20, t17.is_connected AS is_connected_21, t17.is_public AS is_public_22, t17.type AS type_23, t17.is_show_title AS is_show_title_24, t17.is_slideshow AS is_slideshow_25, t17.position AS position_26, t17.name AS name_27, t17.legende AS legende_28, t17.is_generic AS is_generic_29, t17.created_at AS created_at_30, t17.updated_at AS updated_at_31, t17.language_id AS language_id_32, t17.parent_id AS parent_id_33 FROM bloc t0 LEFT JOIN bloc t17 ON t0.parent_id = t17.id WHERE t0.origin = 'App\\Entity\\Brand\\Brand' AND t0.id_origin = 10 AND t0.language_id = 3 AND t0.is_public = 1 ORDER BY t0.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 = ?)
  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;