Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.content AS content_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  e1_.id AS id_6,
  e1_.name AS name_7,
  e1_.slug AS slug_8,
  e1_.section AS section_9,
  m2_.id AS id_10,
  m2_.path AS path_11,
  m2_.alt AS alt_12,
  m2_.updated_at AS updated_at_13,
  p0_.image_id AS image_id_14,
  p0_.category_id AS category_id_15,
  m2_.gallery_id AS gallery_id_16,
  m2_.group_page_id AS group_page_id_17,
  m2_.merch_id AS merch_id_18,
  m2_.event_id AS event_id_19,
  m2_.post_id AS post_id_20
FROM
  post p0_
  LEFT JOIN event_category e1_ ON p0_.category_id = e1_.id
  LEFT JOIN media m2_ ON p0_.image_id = m2_.id
WHERE
  (
    e1_.slug IS NULL
    OR e1_.slug <> ?
    OR p0_.created_at <= ?
  )
ORDER BY
  p0_.created_at DESC,
  p0_.id DESC
LIMIT
  6

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, e1_.id AS id_6, e1_.name AS name_7, e1_.slug AS slug_8, e1_.section AS section_9, m2_.id AS id_10, m2_.path AS path_11, m2_.alt AS alt_12, m2_.updated_at AS updated_at_13, p0_.image_id AS image_id_14, p0_.category_id AS category_id_15, m2_.gallery_id AS gallery_id_16, m2_.group_page_id AS group_page_id_17, m2_.merch_id AS merch_id_18, m2_.event_id AS event_id_19, m2_.post_id AS post_id_20 FROM post p0_ LEFT JOIN event_category e1_ ON p0_.category_id = e1_.id LEFT JOIN media m2_ ON p0_.image_id = m2_.id WHERE (e1_.slug IS NULL OR e1_.slug <> 'communique' OR p0_.created_at <= '2026-08-14 19:52:20') ORDER BY p0_.created_at DESC, p0_.id DESC LIMIT 6;

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.date AS date_2,
  e0_.description AS description_3,
  e0_.opponent AS opponent_4,
  e0_.match_location AS match_location_5,
  e0_.season AS season_6,
  e0_.journee AS journee_7,
  m1_.id AS id_8,
  m1_.path AS path_9,
  m1_.alt AS alt_10,
  m1_.updated_at AS updated_at_11,
  e2_.id AS id_12,
  e2_.name AS name_13,
  e2_.slug AS slug_14,
  e2_.section AS section_15,
  e0_.category_id AS category_id_16,
  e0_.image_id AS image_id_17,
  m1_.gallery_id AS gallery_id_18,
  m1_.group_page_id AS group_page_id_19,
  m1_.merch_id AS merch_id_20,
  m1_.event_id AS event_id_21,
  m1_.post_id AS post_id_22
FROM
  event e0_
  LEFT JOIN media m1_ ON e0_.image_id = m1_.id
  LEFT JOIN event_category e2_ ON e0_.category_id = e2_.id
WHERE
  e2_.section IN (?, ?)
ORDER BY
  e0_.date DESC
LIMIT
  6

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.description AS description_3, e0_.opponent AS opponent_4, e0_.match_location AS match_location_5, e0_.season AS season_6, e0_.journee AS journee_7, m1_.id AS id_8, m1_.path AS path_9, m1_.alt AS alt_10, m1_.updated_at AS updated_at_11, e2_.id AS id_12, e2_.name AS name_13, e2_.slug AS slug_14, e2_.section AS section_15, e0_.category_id AS category_id_16, e0_.image_id AS image_id_17, m1_.gallery_id AS gallery_id_18, m1_.group_page_id AS group_page_id_19, m1_.merch_id AS merch_id_20, m1_.event_id AS event_id_21, m1_.post_id AS post_id_22 FROM event e0_ LEFT JOIN media m1_ ON e0_.image_id = m1_.id LEFT JOIN event_category e2_ ON e0_.category_id = e2_.id WHERE e2_.section IN ('photos_de_match', 'evenements') ORDER BY e0_.date DESC LIMIT 6;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.opponent AS opponent_2,
  t0_.match_date AS match_date_3,
  t0_.guest_availability_date AS guest_availability_date_4,
  t0_.member_availability_date AS member_availability_date_5,
  t0_.match_location AS match_location_6,
  t0_.venue AS venue_7,
  t0_.billetweb_url AS billetweb_url_8,
  t0_.price AS price_9,
  t0_.description AS description_10,
  t0_.stock AS stock_11,
  t1_.id AS id_12,
  t1_.name AS name_13,
  t1_.slug AS slug_14,
  t0_.image_id AS image_id_15,
  t0_.category_id AS category_id_16
FROM
  ticket t0_
  LEFT JOIN ticket_category t1_ ON t0_.category_id = t1_.id
WHERE
  t0_.match_date > ?
  AND (
    (
      t0_.guest_availability_date IS NULL
      OR t0_.guest_availability_date <= ?
    )
  )
ORDER BY
  t0_.match_date ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.opponent AS opponent_2, t0_.match_date AS match_date_3, t0_.guest_availability_date AS guest_availability_date_4, t0_.member_availability_date AS member_availability_date_5, t0_.match_location AS match_location_6, t0_.venue AS venue_7, t0_.billetweb_url AS billetweb_url_8, t0_.price AS price_9, t0_.description AS description_10, t0_.stock AS stock_11, t1_.id AS id_12, t1_.name AS name_13, t1_.slug AS slug_14, t0_.image_id AS image_id_15, t0_.category_id AS category_id_16 FROM ticket t0_ LEFT JOIN ticket_category t1_ ON t0_.category_id = t1_.id WHERE t0_.match_date > '2026-08-14 19:52:20' AND ((t0_.guest_availability_date IS NULL OR t0_.guest_availability_date <= '2026-08-14 19:52:20')) ORDER BY t0_.match_date ASC;

SELECT
  g0_.id AS id_0,
  g0_.title AS title_1,
  g0_.description AS description_2,
  m1_.id AS id_3,
  m1_.path AS path_4,
  m1_.alt AS alt_5,
  m1_.updated_at AS updated_at_6,
  m1_.gallery_id AS gallery_id_7,
  m1_.group_page_id AS group_page_id_8,
  m1_.merch_id AS merch_id_9,
  m1_.event_id AS event_id_10,
  m1_.post_id AS post_id_11
FROM
  gallery g0_
  LEFT JOIN media m1_ ON g0_.id = m1_.gallery_id
ORDER BY
  g0_.id DESC
LIMIT
  3

SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.description AS description_2, m1_.id AS id_3, m1_.path AS path_4, m1_.alt AS alt_5, m1_.updated_at AS updated_at_6, m1_.gallery_id AS gallery_id_7, m1_.group_page_id AS group_page_id_8, m1_.merch_id AS merch_id_9, m1_.event_id AS event_id_10, m1_.post_id AS post_id_11 FROM gallery g0_ LEFT JOIN media m1_ ON g0_.id = m1_.gallery_id ORDER BY g0_.id DESC LIMIT 3;

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.price AS price_2,
  m0_.member_price AS member_price_3,
  m0_.audience AS audience_4,
  m0_.public_until AS public_until_5,
  m0_.description AS description_6,
  m0_.display_in_gadget_history AS display_in_gadget_history_7,
  m1_.id AS id_8,
  m1_.path AS path_9,
  m1_.alt AS alt_10,
  m1_.updated_at AS updated_at_11,
  m2_.id AS id_12,
  m2_.name AS name_13,
  m2_.slug AS slug_14,
  m0_.image_id AS image_id_15,
  m0_.category_id AS category_id_16,
  m1_.gallery_id AS gallery_id_17,
  m1_.group_page_id AS group_page_id_18,
  m1_.merch_id AS merch_id_19,
  m1_.event_id AS event_id_20,
  m1_.post_id AS post_id_21
FROM
  merch m0_
  LEFT JOIN media m1_ ON m0_.image_id = m1_.id
  LEFT JOIN merch_category m2_ ON m0_.category_id = m2_.id
WHERE
  m0_.audience = ?
  AND (
    (
      m0_.public_until IS NULL
      OR m0_.public_until >= ?
    )
  )
ORDER BY
  m0_.id DESC

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.price AS price_2, m0_.member_price AS member_price_3, m0_.audience AS audience_4, m0_.public_until AS public_until_5, m0_.description AS description_6, m0_.display_in_gadget_history AS display_in_gadget_history_7, m1_.id AS id_8, m1_.path AS path_9, m1_.alt AS alt_10, m1_.updated_at AS updated_at_11, m2_.id AS id_12, m2_.name AS name_13, m2_.slug AS slug_14, m0_.image_id AS image_id_15, m0_.category_id AS category_id_16, m1_.gallery_id AS gallery_id_17, m1_.group_page_id AS group_page_id_18, m1_.merch_id AS merch_id_19, m1_.event_id AS event_id_20, m1_.post_id AS post_id_21 FROM merch m0_ LEFT JOIN media m1_ ON m0_.image_id = m1_.id LEFT JOIN merch_category m2_ ON m0_.category_id = m2_.id WHERE m0_.audience = 'public' AND ((m0_.public_until IS NULL OR m0_.public_until >= '2026-08-14 19:52:20')) ORDER BY m0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.production_label AS production_label_4,
  t0.visible AS visible_5,
  t0.position AS position_6,
  t0.created_at AS created_at_7,
  t0.image_id AS image_id_8,
  t0.source_merch_id AS source_merch_id_9
FROM
  gadget t0
WHERE
  t0.source_merch_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.production_label AS production_label_4, t0.visible AS visible_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.image_id AS image_id_8, t0.source_merch_id AS source_merch_id_9 FROM gadget t0 WHERE t0.source_merch_id = 4;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.production_label AS production_label_4,
  t0.visible AS visible_5,
  t0.position AS position_6,
  t0.created_at AS created_at_7,
  t0.image_id AS image_id_8,
  t0.source_merch_id AS source_merch_id_9
FROM
  gadget t0
WHERE
  t0.source_merch_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.production_label AS production_label_4, t0.visible AS visible_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.image_id AS image_id_8, t0.source_merch_id AS source_merch_id_9 FROM gadget t0 WHERE t0.source_merch_id = 2;

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.description AS description_2,
  g0_.histoire_text AS histoire_text_3,
  g0_.mentalite_text AS mentalite_text_4,
  g0_.fonctionnement_text AS fonctionnement_text_5,
  g0_.rejoindre_text AS rejoindre_text_6,
  g0_.se_carter_text AS se_carter_text_7,
  m1_.id AS id_8,
  m1_.path AS path_9,
  m1_.alt AS alt_10,
  m1_.updated_at AS updated_at_11,
  m2_.id AS id_12,
  m2_.path AS path_13,
  m2_.alt AS alt_14,
  m2_.updated_at AS updated_at_15,
  g0_.logo_id AS logo_id_16,
  g0_.banner_id AS banner_id_17,
  m1_.gallery_id AS gallery_id_18,
  m1_.group_page_id AS group_page_id_19,
  m1_.merch_id AS merch_id_20,
  m1_.event_id AS event_id_21,
  m1_.post_id AS post_id_22,
  m2_.gallery_id AS gallery_id_23,
  m2_.group_page_id AS group_page_id_24,
  m2_.merch_id AS merch_id_25,
  m2_.event_id AS event_id_26,
  m2_.post_id AS post_id_27
FROM
  group_page g0_
  LEFT JOIN media m1_ ON g0_.logo_id = m1_.id
  LEFT JOIN media m2_ ON g0_.banner_id = m2_.id
LIMIT
  1

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.histoire_text AS histoire_text_3, g0_.mentalite_text AS mentalite_text_4, g0_.fonctionnement_text AS fonctionnement_text_5, g0_.rejoindre_text AS rejoindre_text_6, g0_.se_carter_text AS se_carter_text_7, m1_.id AS id_8, m1_.path AS path_9, m1_.alt AS alt_10, m1_.updated_at AS updated_at_11, m2_.id AS id_12, m2_.path AS path_13, m2_.alt AS alt_14, m2_.updated_at AS updated_at_15, g0_.logo_id AS logo_id_16, g0_.banner_id AS banner_id_17, m1_.gallery_id AS gallery_id_18, m1_.group_page_id AS group_page_id_19, m1_.merch_id AS merch_id_20, m1_.event_id AS event_id_21, m1_.post_id AS post_id_22, m2_.gallery_id AS gallery_id_23, m2_.group_page_id AS group_page_id_24, m2_.merch_id AS merch_id_25, m2_.event_id AS event_id_26, m2_.post_id AS post_id_27 FROM group_page g0_ LEFT JOIN media m1_ ON g0_.logo_id = m1_.id LEFT JOIN media m2_ ON g0_.banner_id = m2_.id LIMIT 1;

SELECT
  g0_.id AS id_0,
  g0_.title AS title_1,
  g0_.description AS description_2,
  g0_.production_label AS production_label_3,
  g0_.visible AS visible_4,
  g0_.position AS position_5,
  g0_.created_at AS created_at_6,
  m1_.id AS id_7,
  m1_.path AS path_8,
  m1_.alt AS alt_9,
  m1_.updated_at AS updated_at_10,
  g0_.image_id AS image_id_11,
  g0_.source_merch_id AS source_merch_id_12,
  m1_.gallery_id AS gallery_id_13,
  m1_.group_page_id AS group_page_id_14,
  m1_.merch_id AS merch_id_15,
  m1_.event_id AS event_id_16,
  m1_.post_id AS post_id_17
FROM
  gadget g0_
  LEFT JOIN media m1_ ON g0_.image_id = m1_.id
WHERE
  g0_.visible = ?
ORDER BY
  g0_.position ASC,
  g0_.created_at DESC
LIMIT
  4

SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.description AS description_2, g0_.production_label AS production_label_3, g0_.visible AS visible_4, g0_.position AS position_5, g0_.created_at AS created_at_6, m1_.id AS id_7, m1_.path AS path_8, m1_.alt AS alt_9, m1_.updated_at AS updated_at_10, g0_.image_id AS image_id_11, g0_.source_merch_id AS source_merch_id_12, m1_.gallery_id AS gallery_id_13, m1_.group_page_id AS group_page_id_14, m1_.merch_id AS merch_id_15, m1_.event_id AS event_id_16, m1_.post_id AS post_id_17 FROM gadget g0_ LEFT JOIN media m1_ ON g0_.image_id = m1_.id WHERE g0_.visible = 1 ORDER BY g0_.position ASC, g0_.created_at DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.section AS section_4
FROM
  event_category t0
WHERE
  t0.section = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.section AS section_4 FROM event_category t0 WHERE t0.section = 'medias' ORDER BY t0.name ASC;

SELECT
  DISTINCT e0_.season AS season_0
FROM
  event e0_
  INNER JOIN event_category e1_ ON e0_.category_id = e1_.id
WHERE
  e1_.section = ?
  AND e0_.season IS NOT NULL
  AND e0_.season <> ''
ORDER BY
  e0_.season DESC

SELECT DISTINCT e0_.season AS season_0 FROM event e0_ INNER JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e1_.section = 'photos_de_match' AND e0_.season IS NOT NULL AND e0_.season <> '' ORDER BY e0_.season DESC;

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.hero_title AS hero_title_3,
  t0.hero_subtitle AS hero_subtitle_4,
  t0.chants_subtitle AS chants_subtitle_5,
  t0.chants_title AS chants_title_6,
  t0.background_image_id AS background_image_id_7
FROM
  site_config t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.hero_title AS hero_title_3, t0.hero_subtitle AS hero_subtitle_4, t0.chants_subtitle AS chants_subtitle_5, t0.chants_title AS chants_title_6, t0.background_image_id AS background_image_id_7 FROM site_config t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.alt AS alt_3,
  t0.updated_at AS updated_at_4,
  t0.gallery_id AS gallery_id_5,
  t0.group_page_id AS group_page_id_6,
  t0.merch_id AS merch_id_7,
  t0.event_id AS event_id_8,
  t0.post_id AS post_id_9
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.gallery_id AS gallery_id_5, t0.group_page_id AS group_page_id_6, t0.merch_id AS merch_id_7, t0.event_id AS event_id_8, t0.post_id AS post_id_9 FROM media t0 WHERE t0.id = 63;