Symfony Profiler

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  echeance_mensuelle e0_
WHERE
  e0_.deleted_at IS NULL
  AND e0_.statut = ?
  AND (
    (e0_.annee < ?)
    OR (
      e0_.annee = ?
      AND e0_.mois < ?
    )
  )

SELECT COUNT(e0_.id) AS sclr_0 FROM echeance_mensuelle e0_ WHERE e0_.deleted_at IS NULL AND e0_.statut = 'non_paye' AND ((e0_.annee < 2026) OR (e0_.annee = 2026 AND e0_.mois < 5));

SELECT
  g0_.id AS id_0,
  g0_.nom AS nom_1,
  COUNT(DISTINCT s1_.id) AS sclr_2,
  SUM(
    CASE WHEN l2_.statut = 'present' THEN
      1
    ELSE
      0
    END
  ) AS sclr_3,
  COUNT(l2_.id) AS sclr_4
FROM
  session_pointage s1_
  LEFT JOIN groupe g0_ ON s1_.groupe_id = g0_.id
  LEFT JOIN ligne_presence l2_ ON s1_.id = l2_.session_pointage_id
WHERE
  s1_.deleted_at IS NULL
  AND s1_.date_pointage >= ?
GROUP BY
  g0_.id
ORDER BY
  g0_.nom ASC

SELECT g0_.id AS id_0, g0_.nom AS nom_1, COUNT(DISTINCT s1_.id) AS sclr_2, SUM(CASE WHEN l2_.statut = 'present' THEN 1 ELSE 0 END) AS sclr_3, COUNT(l2_.id) AS sclr_4 FROM session_pointage s1_ LEFT JOIN groupe g0_ ON s1_.groupe_id = g0_.id LEFT JOIN ligne_presence l2_ ON s1_.id = l2_.session_pointage_id WHERE s1_.deleted_at IS NULL AND s1_.date_pointage >= '2026-04-26' GROUP BY g0_.id ORDER BY g0_.nom ASC;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  ligne_presence l0_
  LEFT JOIN session_pointage s1_ ON l0_.session_pointage_id = s1_.id
WHERE
  l0_.eleve_id = ?
  AND s1_.date_pointage >= ?
  AND s1_.date_pointage <= ?
  AND s1_.deleted_at IS NULL

SELECT COUNT(l0_.id) AS sclr_0 FROM ligne_presence l0_ LEFT JOIN session_pointage s1_ ON l0_.session_pointage_id = s1_.id WHERE l0_.eleve_id = 59 AND s1_.date_pointage >= '2026-04-16' AND s1_.date_pointage <= '2026-05-16' AND s1_.deleted_at IS NULL;

SELECT
  l0_.id AS id_0,
  l0_.statut AS statut_1,
  l0_.observation AS observation_2,
  l0_.ancienne_valeur AS ancienne_valeur_3,
  l0_.date_correction AS date_correction_4,
  l0_.created_at AS created_at_5,
  l0_.updated_at AS updated_at_6,
  l0_.session_pointage_id AS session_pointage_id_7,
  l0_.eleve_id AS eleve_id_8,
  l0_.agent_correcteur_id AS agent_correcteur_id_9
FROM
  ligne_presence l0_
  LEFT JOIN session_pointage s1_ ON l0_.session_pointage_id = s1_.id
  LEFT JOIN eleve e2_ ON l0_.eleve_id = e2_.id
WHERE
  l0_.statut IN (?, ?)
  AND s1_.date_pointage >= ?
  AND s1_.date_pointage <= ?
  AND s1_.deleted_at IS NULL
  AND e2_.deleted_at IS NULL
ORDER BY
  s1_.date_pointage ASC

SELECT l0_.id AS id_0, l0_.statut AS statut_1, l0_.observation AS observation_2, l0_.ancienne_valeur AS ancienne_valeur_3, l0_.date_correction AS date_correction_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.session_pointage_id AS session_pointage_id_7, l0_.eleve_id AS eleve_id_8, l0_.agent_correcteur_id AS agent_correcteur_id_9 FROM ligne_presence l0_ LEFT JOIN session_pointage s1_ ON l0_.session_pointage_id = s1_.id LEFT JOIN eleve e2_ ON l0_.eleve_id = e2_.id WHERE l0_.statut IN ('absent', 'excuse') AND s1_.date_pointage >= '2026-04-16' AND s1_.date_pointage <= '2026-05-16' AND s1_.deleted_at IS NULL AND e2_.deleted_at IS NULL ORDER BY s1_.date_pointage ASC;

SELECT
  e0_.annee AS annee_0,
  e0_.mois AS mois_1,
  SUM(e0_.montant_du) AS sclr_2,
  SUM(
    CASE WHEN e0_.montant_paye IS NOT NULL THEN
      e0_.montant_paye
    ELSE
      0
    END
  ) AS sclr_3,
  COUNT(e0_.id) AS sclr_4,
  SUM(
    CASE WHEN e0_.statut = ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_5,
  SUM(
    CASE WHEN e0_.statut = ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_6,
  SUM(
    CASE WHEN e0_.statut = ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_7
FROM
  echeance_mensuelle e0_
WHERE
  e0_.deleted_at IS NULL
  AND e0_.annee = ?
  AND e0_.mois = ?
GROUP BY
  e0_.annee,
  e0_.mois
ORDER BY
  e0_.mois ASC

SELECT e0_.annee AS annee_0, e0_.mois AS mois_1, SUM(e0_.montant_du) AS sclr_2, SUM(CASE WHEN e0_.montant_paye IS NOT NULL THEN e0_.montant_paye ELSE 0 END) AS sclr_3, COUNT(e0_.id) AS sclr_4, SUM(CASE WHEN e0_.statut = 'non_paye' THEN 1 ELSE 0 END) AS sclr_5, SUM(CASE WHEN e0_.statut = 'paye' THEN 1 ELSE 0 END) AS sclr_6, SUM(CASE WHEN e0_.statut = 'exonere' THEN 1 ELSE 0 END) AS sclr_7 FROM echeance_mensuelle e0_ WHERE e0_.deleted_at IS NULL AND e0_.annee = 2026 AND e0_.mois = 5 GROUP BY e0_.annee, e0_.mois ORDER BY e0_.mois ASC;

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
  c0_.nom AS nom_0,
  COUNT(i1_.id) AS sclr_1
FROM
  inscription i1_
  LEFT JOIN concours c0_ ON i1_.concours_id = c0_.id
WHERE
  i1_.deleted_at IS NULL
  AND i1_.statut = ?
GROUP BY
  c0_.id
ORDER BY
  sclr_1 DESC

SELECT c0_.nom AS nom_0, COUNT(i1_.id) AS sclr_1 FROM inscription i1_ LEFT JOIN concours c0_ ON i1_.concours_id = c0_.id WHERE i1_.deleted_at IS NULL AND i1_.statut = 'ACTIVE' GROUP BY c0_.id ORDER BY sclr_1 DESC;

SELECT
  t0.id AS id_1,
  t0.date_pointage AS date_pointage_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.groupe_id AS groupe_id_6,
  t0.concours_id AS concours_id_7,
  t0.agent_saisie_id AS agent_saisie_id_8
FROM
  session_pointage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_pointage AS date_pointage_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.groupe_id AS groupe_id_6, t0.concours_id AS concours_id_7, t0.agent_saisie_id AS agent_saisie_id_8 FROM session_pointage t0 WHERE t0.id = 2;

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
  g0_.nom AS nom_0,
  COUNT(i1_.id) AS sclr_1
FROM
  groupe g0_
  LEFT JOIN inscription i1_ ON g0_.id = i1_.groupe_id
  AND (
    i1_.statut = 'ACTIVE'
    AND i1_.deleted_at IS NULL
  )
WHERE
  g0_.active = 1
  AND g0_.deleted_at IS NULL
GROUP BY
  g0_.id
ORDER BY
  sclr_1 DESC

SELECT g0_.nom AS nom_0, COUNT(i1_.id) AS sclr_1 FROM groupe g0_ LEFT JOIN inscription i1_ ON g0_.id = i1_.groupe_id AND (i1_.statut = 'ACTIVE' AND i1_.deleted_at IS NULL) WHERE g0_.active = 1 AND g0_.deleted_at IS NULL GROUP BY g0_.id ORDER BY sclr_1 DESC;

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
  g0_.id AS id_0,
  g0_.nom AS nom_1,
  g0_.description AS description_2,
  g0_.code AS code_3,
  g0_.effectif_max AS effectif_max_4,
  g0_.active AS active_5,
  g0_.salle AS salle_6,
  g0_.created_at AS created_at_7,
  g0_.updated_at AS updated_at_8,
  g0_.deleted_at AS deleted_at_9,
  g0_.referent_id AS referent_id_10,
  g0_.classe_id AS classe_id_11
FROM
  groupe g0_
  LEFT JOIN inscription i1_ ON g0_.id = i1_.groupe_id
  AND (
    i1_.statut = 'ACTIVE'
    AND i1_.deleted_at IS NULL
  )
WHERE
  g0_.active = 1
  AND g0_.deleted_at IS NULL
  AND g0_.effectif_max IS NOT NULL
  AND g0_.effectif_max > 0
GROUP BY
  g0_.id
HAVING
  COUNT(i1_.id) > g0_.effectif_max

SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.description AS description_2, g0_.code AS code_3, g0_.effectif_max AS effectif_max_4, g0_.active AS active_5, g0_.salle AS salle_6, g0_.created_at AS created_at_7, g0_.updated_at AS updated_at_8, g0_.deleted_at AS deleted_at_9, g0_.referent_id AS referent_id_10, g0_.classe_id AS classe_id_11 FROM groupe g0_ LEFT JOIN inscription i1_ ON g0_.id = i1_.groupe_id AND (i1_.statut = 'ACTIVE' AND i1_.deleted_at IS NULL) WHERE g0_.active = 1 AND g0_.deleted_at IS NULL AND g0_.effectif_max IS NOT NULL AND g0_.effectif_max > 0 GROUP BY g0_.id HAVING COUNT(i1_.id) > g0_.effectif_max;

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
  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
  COUNT(*)
FROM
  eleve t0
WHERE
  t0.deleted_at IS NULL

SELECT COUNT(*) FROM eleve t0 WHERE t0.deleted_at IS NULL;

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

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

SELECT
  SUM(e0_.montant_paye) AS sclr_0
FROM
  echeance_mensuelle e0_
WHERE
  e0_.deleted_at IS NULL
  AND e0_.annee = ?
  AND e0_.mois = ?
  AND e0_.statut IN (?, ?)

SELECT SUM(e0_.montant_paye) AS sclr_0 FROM echeance_mensuelle e0_ WHERE e0_.deleted_at IS NULL AND e0_.annee = 2026 AND e0_.mois = 5 AND e0_.statut IN ('paye', 'partiellement_paye');

SELECT
  SUM(p0_.montant_paye) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.deleted_at IS NULL
  AND (
    p0_.date_paiement BETWEEN ?
    AND ?
  )
  AND p0_.statut IN (?, ?)

SELECT SUM(p0_.montant_paye) AS sclr_0 FROM paiement p0_ WHERE p0_.deleted_at IS NULL AND (p0_.date_paiement BETWEEN '2026-05-01 00:00:00' AND '2026-05-31 23:59:59') AND p0_.statut IN ('paye', 'partiellement_paye');

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  inscription i0_
WHERE
  i0_.deleted_at IS NULL
  AND i0_.exonere = 1

SELECT COUNT(i0_.id) AS sclr_0 FROM inscription i0_ WHERE i0_.deleted_at IS NULL AND i0_.exonere = 1;

SELECT
  g0_.id AS id_0,
  g0_.nom AS nom_1,
  g0_.description AS description_2,
  g0_.code AS code_3,
  g0_.effectif_max AS effectif_max_4,
  g0_.active AS active_5,
  g0_.salle AS salle_6,
  g0_.created_at AS created_at_7,
  g0_.updated_at AS updated_at_8,
  g0_.deleted_at AS deleted_at_9,
  g0_.referent_id AS referent_id_10,
  g0_.classe_id AS classe_id_11
FROM
  groupe g0_
WHERE
  g0_.active = 1
  AND g0_.deleted_at IS NULL
ORDER BY
  g0_.nom ASC

SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.description AS description_2, g0_.code AS code_3, g0_.effectif_max AS effectif_max_4, g0_.active AS active_5, g0_.salle AS salle_6, g0_.created_at AS created_at_7, g0_.updated_at AS updated_at_8, g0_.deleted_at AS deleted_at_9, g0_.referent_id AS referent_id_10, g0_.classe_id AS classe_id_11 FROM groupe g0_ WHERE g0_.active = 1 AND g0_.deleted_at IS NULL ORDER BY g0_.nom ASC;

SELECT
  SUM(c0_.montant_du) AS sclr_0
FROM
  charge_professorale c0_
WHERE
  c0_.mois = ?
  AND c0_.annee = ?
  AND c0_.deleted_at IS NULL

SELECT SUM(c0_.montant_du) AS sclr_0 FROM charge_professorale c0_ WHERE c0_.mois = 5 AND c0_.annee = 2026 AND c0_.deleted_at IS NULL;