Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.enabled AS enabled_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.phone AS phone_8,
  t0.last_login_at AS last_login_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM `user` t0 WHERE t0.id = 6;

SELECT
  s0_.id AS id_0,
  s0_.date_pointage AS date_pointage_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.deleted_at AS deleted_at_4,
  s0_.groupe_id AS groupe_id_5,
  s0_.concours_id AS concours_id_6,
  s0_.agent_saisie_id AS agent_saisie_id_7
FROM
  session_pointage s0_
  LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id
  LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id
  LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id
  LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id
WHERE
  s0_.deleted_at IS NULL
GROUP BY
  s0_.id
ORDER BY
  s0_.date_pointage DESC,
  g1_.nom ASC

SELECT s0_.id AS id_0, s0_.date_pointage AS date_pointage_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.groupe_id AS groupe_id_5, s0_.concours_id AS concours_id_6, s0_.agent_saisie_id AS agent_saisie_id_7 FROM session_pointage s0_ LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id WHERE s0_.deleted_at IS NULL GROUP BY s0_.id ORDER BY s0_.date_pointage DESC, g1_.nom ASC;

SELECT
  COUNT(*)
FROM
  observation_suivi t0
WHERE
  t0.statut = ?
  AND t0.deleted_at IS NULL

SELECT COUNT(*) FROM observation_suivi t0 WHERE t0.statut = 'ouvert' AND t0.deleted_at IS NULL;

SELECT
  COUNT(*)
FROM
  observation_suivi t0
WHERE
  t0.statut = ?
  AND t0.deleted_at IS NULL

SELECT COUNT(*) FROM observation_suivi t0 WHERE t0.statut = 'en_cours' AND t0.deleted_at IS NULL;

SELECT
  s0_.id AS id_0,
  s0_.date_pointage AS date_pointage_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.deleted_at AS deleted_at_4,
  s0_.groupe_id AS groupe_id_5,
  s0_.concours_id AS concours_id_6,
  s0_.agent_saisie_id AS agent_saisie_id_7
FROM
  session_pointage s0_
  LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id
  LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id
  LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id
  LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id
WHERE
  s0_.deleted_at IS NULL
  AND s0_.date_pointage >= ?
  AND s0_.date_pointage <= ?
GROUP BY
  s0_.id
ORDER BY
  s0_.date_pointage DESC,
  g1_.nom ASC

SELECT s0_.id AS id_0, s0_.date_pointage AS date_pointage_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.groupe_id AS groupe_id_5, s0_.concours_id AS concours_id_6, s0_.agent_saisie_id AS agent_saisie_id_7 FROM session_pointage s0_ LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id WHERE s0_.deleted_at IS NULL AND s0_.date_pointage >= '2026-05-01' AND s0_.date_pointage <= '2026-05-31' GROUP BY s0_.id ORDER BY s0_.date_pointage DESC, g1_.nom ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.code AS code_4,
  t0.effectif_max AS effectif_max_5,
  t0.active AS active_6,
  t0.salle AS salle_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.referent_id AS referent_id_11,
  t0.classe_id AS classe_id_12
FROM
  groupe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.code AS code_4, t0.effectif_max AS effectif_max_5, t0.active AS active_6, t0.salle AS salle_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.referent_id AS referent_id_11, t0.classe_id AS classe_id_12 FROM groupe t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.statut AS statut_2,
  t0.observation AS observation_3,
  t0.ancienne_valeur AS ancienne_valeur_4,
  t0.date_correction AS date_correction_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.session_pointage_id AS session_pointage_id_8,
  t0.eleve_id AS eleve_id_9,
  t0.agent_correcteur_id AS agent_correcteur_id_10
FROM
  ligne_presence t0
WHERE
  t0.session_pointage_id = ?

SELECT t0.id AS id_1, t0.statut AS statut_2, t0.observation AS observation_3, t0.ancienne_valeur AS ancienne_valeur_4, t0.date_correction AS date_correction_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.session_pointage_id AS session_pointage_id_8, t0.eleve_id AS eleve_id_9, t0.agent_correcteur_id AS agent_correcteur_id_10 FROM ligne_presence t0 WHERE t0.session_pointage_id = 3;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.code AS code_4,
  t0.effectif_max AS effectif_max_5,
  t0.active AS active_6,
  t0.salle AS salle_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.referent_id AS referent_id_11,
  t0.classe_id AS classe_id_12
FROM
  groupe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.code AS code_4, t0.effectif_max AS effectif_max_5, t0.active AS active_6, t0.salle AS salle_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.referent_id AS referent_id_11, t0.classe_id AS classe_id_12 FROM groupe t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.statut AS statut_2,
  t0.observation AS observation_3,
  t0.ancienne_valeur AS ancienne_valeur_4,
  t0.date_correction AS date_correction_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.session_pointage_id AS session_pointage_id_8,
  t0.eleve_id AS eleve_id_9,
  t0.agent_correcteur_id AS agent_correcteur_id_10
FROM
  ligne_presence t0
WHERE
  t0.session_pointage_id = ?

SELECT t0.id AS id_1, t0.statut AS statut_2, t0.observation AS observation_3, t0.ancienne_valeur AS ancienne_valeur_4, t0.date_correction AS date_correction_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.session_pointage_id AS session_pointage_id_8, t0.eleve_id AS eleve_id_9, t0.agent_correcteur_id AS agent_correcteur_id_10 FROM ligne_presence t0 WHERE t0.session_pointage_id = 2;