Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.description AS description_2,
  e0_.creation_date AS creation_date_3,
  e0_.url AS url_4,
  e0_.slug AS slug_5,
  e0_.last_update AS last_update_6,
  e0_.visible AS visible_7,
  e0_.date_debut AS date_debut_8,
  e0_.date_fin AS date_fin_9,
  e0_.uuid_tmp AS uuid_tmp_10,
  e0_.image AS image_11,
  e0_.location_fallback AS location_fallback_12,
  e0_.organizers_fallback AS organizers_fallback_13,
  e0_.image_name AS image_name_14,
  e0_.image_size AS image_size_15,
  e0_.updated_at AS updated_at_16,
  e0_.price AS price_17,
  e0_.exclude_from_agenda AS exclude_from_agenda_18,
  e0_.horaires_du_lieu AS horaires_du_lieu_19,
  e1_.id AS id_20,
  e1_.name AS name_21,
  e1_.slug AS slug_22,
  e0_.scrapper_event_id AS scrapper_event_id_23,
  e0_.created_by_id AS created_by_id_24,
  e0_.festival_id AS festival_id_25
FROM
  event e0_
  LEFT JOIN event_event_category e2_ ON e0_.id = e2_.event_id
  LEFT JOIN event_category e1_ ON e1_.id = e2_.event_category_id
WHERE
  e0_.date_debut <= ?
  AND (
    (
      e0_.date_fin IS NULL
      AND e0_.date_debut >= ?
      AND e0_.date_debut < ?
    )
    OR (
      e0_.date_fin IS NOT NULL
      AND e0_.date_debut <= ?
      AND e0_.date_fin >= ?
    )
  )
  AND e0_.visible = true
  AND (
    (
      e0_.exclude_from_agenda = false
      OR e0_.exclude_from_agenda IS NULL
    )
  )
  AND (
    e0_.horaires_du_lieu = false
    OR EXISTS (
      SELECT
        1 AS sclr_26
      FROM
        event_place_link e3_
        INNER JOIN place p4_ ON e3_.place_id = p4_.id
        INNER JOIN horaires h5_ ON p4_.id = h5_.place_id
      WHERE
        e3_.event_id = e0_.id
        AND e3_.role = ?
        AND h5_.jour = ?
        AND (
          h5_.ferme = false
          OR h5_.ferme IS NULL
        )
    )
  )
ORDER BY
  e0_.date_debut ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.creation_date AS creation_date_3, e0_.url AS url_4, e0_.slug AS slug_5, e0_.last_update AS last_update_6, e0_.visible AS visible_7, e0_.date_debut AS date_debut_8, e0_.date_fin AS date_fin_9, e0_.uuid_tmp AS uuid_tmp_10, e0_.image AS image_11, e0_.location_fallback AS location_fallback_12, e0_.organizers_fallback AS organizers_fallback_13, e0_.image_name AS image_name_14, e0_.image_size AS image_size_15, e0_.updated_at AS updated_at_16, e0_.price AS price_17, e0_.exclude_from_agenda AS exclude_from_agenda_18, e0_.horaires_du_lieu AS horaires_du_lieu_19, e1_.id AS id_20, e1_.name AS name_21, e1_.slug AS slug_22, e0_.scrapper_event_id AS scrapper_event_id_23, e0_.created_by_id AS created_by_id_24, e0_.festival_id AS festival_id_25 FROM event e0_ LEFT JOIN event_event_category e2_ ON e0_.id = e2_.event_id LEFT JOIN event_category e1_ ON e1_.id = e2_.event_category_id WHERE e0_.date_debut <= '2026-06-21 00:00:00' AND ((e0_.date_fin IS NULL AND e0_.date_debut >= '2026-06-20 00:00:00' AND e0_.date_debut < '2026-06-21 00:00:00') OR (e0_.date_fin IS NOT NULL AND e0_.date_debut <= '2026-06-21 00:00:00' AND e0_.date_fin >= '2026-06-20 00:00:00')) AND e0_.visible = true AND ((e0_.exclude_from_agenda = false OR e0_.exclude_from_agenda IS NULL)) AND (e0_.horaires_du_lieu = false OR EXISTS (SELECT 1 AS sclr_26 FROM event_place_link e3_ INNER JOIN place p4_ ON e3_.place_id = p4_.id INNER JOIN horaires h5_ ON p4_.id = h5_.place_id WHERE e3_.event_id = e0_.id AND e3_.role = 'host' AND h5_.jour = 7 AND (h5_.ferme = false OR h5_.ferme IS NULL))) ORDER BY e0_.date_debut ASC;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.event_id AS event_id_3,
  t0.place_id AS place_id_4
FROM
  event_place_link t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.event_id AS event_id_3, t0.place_id AS place_id_4 FROM event_place_link t0 WHERE t0.event_id = 312;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.event_id AS event_id_3,
  t0.place_id AS place_id_4
FROM
  event_place_link t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.event_id AS event_id_3, t0.place_id AS place_id_4 FROM event_place_link t0 WHERE t0.event_id = 1646;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.event_id AS event_id_3,
  t0.place_id AS place_id_4
FROM
  event_place_link t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.event_id AS event_id_3, t0.place_id AS place_id_4 FROM event_place_link t0 WHERE t0.event_id = 313;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.event_id AS event_id_3,
  t0.place_id AS place_id_4
FROM
  event_place_link t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.event_id AS event_id_3, t0.place_id AS place_id_4 FROM event_place_link t0 WHERE t0.event_id = 1661;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.event_id AS event_id_3,
  t0.place_id AS place_id_4
FROM
  event_place_link t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.event_id AS event_id_3, t0.place_id AS place_id_4 FROM event_place_link t0 WHERE t0.event_id = 1667;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.event_id AS event_id_3,
  t0.place_id AS place_id_4
FROM
  event_place_link t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.event_id AS event_id_3, t0.place_id AS place_id_4 FROM event_place_link t0 WHERE t0.event_id = 13;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.event_id AS event_id_3,
  t0.place_id AS place_id_4
FROM
  event_place_link t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.event_id AS event_id_3, t0.place_id AS place_id_4 FROM event_place_link t0 WHERE t0.event_id = 1481;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  event_category t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM event_category t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.adresse AS adresse_3,
  t0.slug AS slug_4,
  t0.ville AS ville_5,
  t0.codepostal AS codepostal_6,
  t0.description AS description_7,
  t0.telephone AS telephone_8,
  t0.email AS email_9,
  t0.url AS url_10,
  t0.proprietaire_id AS proprietaire_id_11
FROM
  place t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.adresse AS adresse_3, t0.slug AS slug_4, t0.ville AS ville_5, t0.codepostal AS codepostal_6, t0.description AS description_7, t0.telephone AS telephone_8, t0.email AS email_9, t0.url AS url_10, t0.proprietaire_id AS proprietaire_id_11 FROM place t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.adresse AS adresse_3,
  t0.slug AS slug_4,
  t0.ville AS ville_5,
  t0.codepostal AS codepostal_6,
  t0.description AS description_7,
  t0.telephone AS telephone_8,
  t0.email AS email_9,
  t0.url AS url_10,
  t0.proprietaire_id AS proprietaire_id_11
FROM
  place t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.adresse AS adresse_3, t0.slug AS slug_4, t0.ville AS ville_5, t0.codepostal AS codepostal_6, t0.description AS description_7, t0.telephone AS telephone_8, t0.email AS email_9, t0.url AS url_10, t0.proprietaire_id AS proprietaire_id_11 FROM place t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.adresse AS adresse_3,
  t0.slug AS slug_4,
  t0.ville AS ville_5,
  t0.codepostal AS codepostal_6,
  t0.description AS description_7,
  t0.telephone AS telephone_8,
  t0.email AS email_9,
  t0.url AS url_10,
  t0.proprietaire_id AS proprietaire_id_11
FROM
  place t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.adresse AS adresse_3, t0.slug AS slug_4, t0.ville AS ville_5, t0.codepostal AS codepostal_6, t0.description AS description_7, t0.telephone AS telephone_8, t0.email AS email_9, t0.url AS url_10, t0.proprietaire_id AS proprietaire_id_11 FROM place t0 WHERE t0.id = 5;