Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• Doctrine
• Debug
• Emails
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.adresse AS adresse_4, t0.date_ouverture AS date_ouverture_5, t0.date_fermeture AS date_fermeture_6, t0.jours_non_disponibles AS jours_non_disponibles_7 FROM site t0 WHERE t0.id = ?

[
  "1"
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.adresse AS adresse_4,
  t0.date_ouverture AS date_ouverture_5,
  t0.date_fermeture AS date_fermeture_6,
  t0.jours_non_disponibles AS jours_non_disponibles_7
FROM
  site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.adresse AS adresse_4, t0.date_ouverture AS date_ouverture_5, t0.date_fermeture AS date_fermeture_6, t0.jours_non_disponibles AS jours_non_disponibles_7 FROM site t0 WHERE t0.id = '1';

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.reduction AS reduction_3 FROM ville t0 WHERE t0.id = ?

[
  "2"
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.reduction AS reduction_3
FROM
  ville t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.reduction AS reduction_3 FROM ville t0 WHERE t0.id = '2';

SELECT t0.id AS id_1, t0.date AS date_2, t0.site_id AS site_id_3 FROM jour_indisponible t0 WHERE t0.date = ? AND t0.site_id = ? LIMIT 1

[
  "2025-06-28"
  1
]

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.site_id AS site_id_3
FROM
  jour_indisponible t0
WHERE
  t0.date = ?
  AND t0.site_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date AS date_2, t0.site_id AS site_id_3 FROM jour_indisponible t0 WHERE t0.date = '2025-06-28' AND t0.site_id = 1 LIMIT 1;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.value AS value_3 FROM config t0 WHERE t0.nom = ? LIMIT 1

[
  "Nombre max de personne par tranche horaire"
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.value AS value_3
FROM
  config t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.value AS value_3 FROM config t0 WHERE t0.nom = 'Nombre max de personne par tranche horaire' LIMIT 1;

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = ? AND i0_.date = ? AND ((i0_.heure_debut <= ? AND i0_.heure_fin > ?) OR (i0_.heure_debut >= ? AND i0_.heure_debut < ?))

[
  "1"
  "2025-06-28 00:00:00"
  10
  10
  10
  12
]

SELECT
  (
    sum(i0_.nb_adultes) + sum(i0_.nb_enfants)
  ) AS sclr_0
FROM
  inscrit i0_
WHERE
  i0_.site_id = ?
  AND i0_.date = ?
  AND (
    (
      i0_.heure_debut <= ?
      AND i0_.heure_fin > ?
    )
    OR (
      i0_.heure_debut >= ?
      AND i0_.heure_debut < ?
    )
  )

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = '1' AND i0_.date = '2025-06-28 00:00:00' AND ((i0_.heure_debut <= 10 AND i0_.heure_fin > 10) OR (i0_.heure_debut >= 10 AND i0_.heure_debut < 12));

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = ? AND i0_.date = ? AND ((i0_.heure_debut <= ? AND i0_.heure_fin > ?) OR (i0_.heure_debut >= ? AND i0_.heure_debut < ?))

[
  "1"
  "2025-06-28 00:00:00"
  11
  11
  11
  13
]

SELECT
  (
    sum(i0_.nb_adultes) + sum(i0_.nb_enfants)
  ) AS sclr_0
FROM
  inscrit i0_
WHERE
  i0_.site_id = ?
  AND i0_.date = ?
  AND (
    (
      i0_.heure_debut <= ?
      AND i0_.heure_fin > ?
    )
    OR (
      i0_.heure_debut >= ?
      AND i0_.heure_debut < ?
    )
  )

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = '1' AND i0_.date = '2025-06-28 00:00:00' AND ((i0_.heure_debut <= 11 AND i0_.heure_fin > 11) OR (i0_.heure_debut >= 11 AND i0_.heure_debut < 13));

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = ? AND i0_.date = ? AND ((i0_.heure_debut <= ? AND i0_.heure_fin > ?) OR (i0_.heure_debut >= ? AND i0_.heure_debut < ?))

[
  "1"
  "2025-06-28 00:00:00"
  12
  12
  12
  14
]

SELECT
  (
    sum(i0_.nb_adultes) + sum(i0_.nb_enfants)
  ) AS sclr_0
FROM
  inscrit i0_
WHERE
  i0_.site_id = ?
  AND i0_.date = ?
  AND (
    (
      i0_.heure_debut <= ?
      AND i0_.heure_fin > ?
    )
    OR (
      i0_.heure_debut >= ?
      AND i0_.heure_debut < ?
    )
  )

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = '1' AND i0_.date = '2025-06-28 00:00:00' AND ((i0_.heure_debut <= 12 AND i0_.heure_fin > 12) OR (i0_.heure_debut >= 12 AND i0_.heure_debut < 14));

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = ? AND i0_.date = ? AND ((i0_.heure_debut <= ? AND i0_.heure_fin > ?) OR (i0_.heure_debut >= ? AND i0_.heure_debut < ?))

[
  "1"
  "2025-06-28 00:00:00"
  13
  13
  13
  15
]

SELECT
  (
    sum(i0_.nb_adultes) + sum(i0_.nb_enfants)
  ) AS sclr_0
FROM
  inscrit i0_
WHERE
  i0_.site_id = ?
  AND i0_.date = ?
  AND (
    (
      i0_.heure_debut <= ?
      AND i0_.heure_fin > ?
    )
    OR (
      i0_.heure_debut >= ?
      AND i0_.heure_debut < ?
    )
  )

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = '1' AND i0_.date = '2025-06-28 00:00:00' AND ((i0_.heure_debut <= 13 AND i0_.heure_fin > 13) OR (i0_.heure_debut >= 13 AND i0_.heure_debut < 15));

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = ? AND i0_.date = ? AND ((i0_.heure_debut <= ? AND i0_.heure_fin > ?) OR (i0_.heure_debut >= ? AND i0_.heure_debut < ?))

[
  "1"
  "2025-06-28 00:00:00"
  14
  14
  14
  16
]

SELECT
  (
    sum(i0_.nb_adultes) + sum(i0_.nb_enfants)
  ) AS sclr_0
FROM
  inscrit i0_
WHERE
  i0_.site_id = ?
  AND i0_.date = ?
  AND (
    (
      i0_.heure_debut <= ?
      AND i0_.heure_fin > ?
    )
    OR (
      i0_.heure_debut >= ?
      AND i0_.heure_debut < ?
    )
  )

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = '1' AND i0_.date = '2025-06-28 00:00:00' AND ((i0_.heure_debut <= 14 AND i0_.heure_fin > 14) OR (i0_.heure_debut >= 14 AND i0_.heure_debut < 16));

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = ? AND i0_.date = ? AND ((i0_.heure_debut <= ? AND i0_.heure_fin > ?) OR (i0_.heure_debut >= ? AND i0_.heure_debut < ?))

[
  "1"
  "2025-06-28 00:00:00"
  15
  15
  15
  17
]

SELECT
  (
    sum(i0_.nb_adultes) + sum(i0_.nb_enfants)
  ) AS sclr_0
FROM
  inscrit i0_
WHERE
  i0_.site_id = ?
  AND i0_.date = ?
  AND (
    (
      i0_.heure_debut <= ?
      AND i0_.heure_fin > ?
    )
    OR (
      i0_.heure_debut >= ?
      AND i0_.heure_debut < ?
    )
  )

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = '1' AND i0_.date = '2025-06-28 00:00:00' AND ((i0_.heure_debut <= 15 AND i0_.heure_fin > 15) OR (i0_.heure_debut >= 15 AND i0_.heure_debut < 17));

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = ? AND i0_.date = ? AND ((i0_.heure_debut <= ? AND i0_.heure_fin > ?) OR (i0_.heure_debut >= ? AND i0_.heure_debut < ?))

[
  "1"
  "2025-06-28 00:00:00"
  16
  16
  16
  19
]

SELECT
  (
    sum(i0_.nb_adultes) + sum(i0_.nb_enfants)
  ) AS sclr_0
FROM
  inscrit i0_
WHERE
  i0_.site_id = ?
  AND i0_.date = ?
  AND (
    (
      i0_.heure_debut <= ?
      AND i0_.heure_fin > ?
    )
    OR (
      i0_.heure_debut >= ?
      AND i0_.heure_debut < ?
    )
  )

SELECT (sum(i0_.nb_adultes) + sum(i0_.nb_enfants)) AS sclr_0 FROM inscrit i0_ WHERE i0_.site_id = '1' AND i0_.date = '2025-06-28 00:00:00' AND ((i0_.heure_debut <= 16 AND i0_.heure_fin > 16) OR (i0_.heure_debut >= 16 AND i0_.heure_debut < 19));

SELECT a0_.id AS id_0, a0_.date_expiration AS date_expiration_1, a0_.message AS message_2, a0_.icon AS icon_3 FROM alerte a0_ WHERE a0_.date_expiration > ? OR a0_.date_expiration IS NULL ORDER BY a0_.id DESC

[
  "2025-06-22 19:41:06"
]

SELECT
  a0_.id AS id_0,
  a0_.date_expiration AS date_expiration_1,
  a0_.message AS message_2,
  a0_.icon AS icon_3
FROM
  alerte a0_
WHERE
  a0_.date_expiration > ?
  OR a0_.date_expiration IS NULL
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.date_expiration AS date_expiration_1, a0_.message AS message_2, a0_.icon AS icon_3 FROM alerte a0_ WHERE a0_.date_expiration > '2025-06-22 19:41:06' OR a0_.date_expiration IS NULL ORDER BY a0_.id DESC;