Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.heure_debut AS heure_debut_3,
  t0.heure_fin AS heure_fin_4,
  t0.is_annuler AS is_annuler_5,
  t0.motifs_annuler AS motifs_annuler_6,
  t0.commentaire AS commentaire_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.reference_groupe AS reference_groupe_10,
  t0.id_groupe AS id_groupe_11,
  t0.niveau AS niveau_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14,
  t0.centre_alpha_id AS centre_alpha_id_15,
  t0.formateur_titulaire_id AS formateur_titulaire_id_16,
  t0.lieu_id AS lieu_id_17,
  t0.motif_remplacement_id AS motif_remplacement_id_18
FROM
  offre t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.heure_debut AS heure_debut_3, t0.heure_fin AS heure_fin_4, t0.is_annuler AS is_annuler_5, t0.motifs_annuler AS motifs_annuler_6, t0.commentaire AS commentaire_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.reference_groupe AS reference_groupe_10, t0.id_groupe AS id_groupe_11, t0.niveau AS niveau_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.centre_alpha_id AS centre_alpha_id_15, t0.formateur_titulaire_id AS formateur_titulaire_id_16, t0.lieu_id AS lieu_id_17, t0.motif_remplacement_id AS motif_remplacement_id_18 FROM offre t0 WHERE t0.id = 291;

SELECT
  o0_.id AS id_0,
  o0_.date AS date_1,
  o0_.heure_debut AS heure_debut_2,
  o0_.heure_fin AS heure_fin_3,
  o0_.is_annuler AS is_annuler_4,
  o0_.motifs_annuler AS motifs_annuler_5,
  o0_.commentaire AS commentaire_6,
  o0_.created_at AS created_at_7,
  o0_.updated_at AS updated_at_8,
  o0_.reference_groupe AS reference_groupe_9,
  o0_.id_groupe AS id_groupe_10,
  o0_.niveau AS niveau_11,
  o0_.created_by_id AS created_by_id_12,
  o0_.updated_by_id AS updated_by_id_13,
  o0_.centre_alpha_id AS centre_alpha_id_14,
  o0_.formateur_titulaire_id AS formateur_titulaire_id_15,
  o0_.lieu_id AS lieu_id_16,
  o0_.motif_remplacement_id AS motif_remplacement_id_17
FROM
  offre o0_
  LEFT JOIN postuler_offre p1_ ON o0_.id = p1_.offre_id
  AND (
    p1_.is_annuler = 0
    OR p1_.is_annuler IS NULL
  )
WHERE
  (
    (
      o0_.is_annuler IS NULL
      OR o0_.is_annuler = 0
    )
  )
  AND o0_.date >= ?
  AND (
    o0_.date BETWEEN ?
    AND ?
  )
  AND p1_.id IS NULL
ORDER BY
  o0_.date ASC,
  o0_.heure_debut ASC

SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.heure_debut AS heure_debut_2, o0_.heure_fin AS heure_fin_3, o0_.is_annuler AS is_annuler_4, o0_.motifs_annuler AS motifs_annuler_5, o0_.commentaire AS commentaire_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.reference_groupe AS reference_groupe_9, o0_.id_groupe AS id_groupe_10, o0_.niveau AS niveau_11, o0_.created_by_id AS created_by_id_12, o0_.updated_by_id AS updated_by_id_13, o0_.centre_alpha_id AS centre_alpha_id_14, o0_.formateur_titulaire_id AS formateur_titulaire_id_15, o0_.lieu_id AS lieu_id_16, o0_.motif_remplacement_id AS motif_remplacement_id_17 FROM offre o0_ LEFT JOIN postuler_offre p1_ ON o0_.id = p1_.offre_id AND (p1_.is_annuler = 0 OR p1_.is_annuler IS NULL) WHERE ((o0_.is_annuler IS NULL OR o0_.is_annuler = 0)) AND o0_.date >= '2026-04-12 00:00:00' AND (o0_.date BETWEEN '2025-09-01 00:00:00' AND '2026-08-31 23:59:59') AND p1_.id IS NULL ORDER BY o0_.date ASC, o0_.heure_debut ASC;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.is_archived AS is_archived_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.genre_id AS genre_id_7,
  t0.fonction_id AS fonction_id_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t11.id AS id_12,
  t11.email AS email_13,
  t11.gsm AS gsm_14,
  t11.roles AS roles_15,
  t11.password AS password_16,
  t11.heures_decimal AS heures_decimal_17,
  t11.created_at AS created_at_18,
  t11.updated_at AS updated_at_19,
  t11.is_active AS is_active_20,
  t11.personnel_id AS personnel_id_21
FROM
  personnel t0
  LEFT JOIN user t11 ON t11.personnel_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.gsm AS gsm_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.heures_decimal AS heures_decimal_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.is_active AS is_active_9,
  t0.personnel_id AS personnel_id_10
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.email = 'faddoul.elghazi@lire-et-ecrire.be' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.siege_address AS siege_address_3,
  t0.cours_address AS cours_address_4,
  t0.contact AS contact_5,
  t0.is_lee AS is_lee_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10
FROM
  lieu_formation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.siege_address AS siege_address_3, t0.cours_address AS cours_address_4, t0.contact AS contact_5, t0.is_lee AS is_lee_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM lieu_formation t0 WHERE t0.id = 14;

SELECT
  p0_.id AS id_0,
  p0_.commentaire AS commentaire_1,
  p0_.is_annuler AS is_annuler_2,
  p0_.raison_annulation AS raison_annulation_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.offre_id AS offre_id_6,
  p0_.formateur_polyvalent_id AS formateur_polyvalent_id_7,
  p0_.created_by_id AS created_by_id_8,
  p0_.updated_by_id AS updated_by_id_9
FROM
  postuler_offre p0_
  INNER JOIN offre o1_ ON p0_.offre_id = o1_.id
WHERE
  p0_.formateur_polyvalent_id = ?
  AND (
    o1_.date BETWEEN ?
    AND ?
  )
ORDER BY
  o1_.date DESC,
  o1_.heure_debut DESC

SELECT p0_.id AS id_0, p0_.commentaire AS commentaire_1, p0_.is_annuler AS is_annuler_2, p0_.raison_annulation AS raison_annulation_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.offre_id AS offre_id_6, p0_.formateur_polyvalent_id AS formateur_polyvalent_id_7, p0_.created_by_id AS created_by_id_8, p0_.updated_by_id AS updated_by_id_9 FROM postuler_offre p0_ INNER JOIN offre o1_ ON p0_.offre_id = o1_.id WHERE p0_.formateur_polyvalent_id = 16 AND (o1_.date BETWEEN '2025-09-01 00:00:00' AND '2026-08-31 23:59:59') ORDER BY o1_.date DESC, o1_.heure_debut DESC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.is_active AS is_active_5,
  t0.created_by_id AS created_by_id_6,
  t0.updated_by_id AS updated_by_id_7
FROM
  centre_alpha t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_active AS is_active_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM centre_alpha t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.is_coordo AS is_coordo_2,
  t0.user_id AS user_id_3,
  t0.centre_id AS centre_id_4
FROM
  user_centre_autorisation t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.is_coordo AS is_coordo_2, t0.user_id AS user_id_3, t0.centre_id AS centre_id_4 FROM user_centre_autorisation t0 WHERE t0.user_id = 4;

SELECT
  p0_.id AS id_0,
  p0_.commentaire AS commentaire_1,
  p0_.is_annuler AS is_annuler_2,
  p0_.raison_annulation AS raison_annulation_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.offre_id AS offre_id_6,
  p0_.formateur_polyvalent_id AS formateur_polyvalent_id_7,
  p0_.created_by_id AS created_by_id_8,
  p0_.updated_by_id AS updated_by_id_9
FROM
  postuler_offre p0_
  INNER JOIN offre o1_ ON p0_.offre_id = o1_.id
WHERE
  p0_.formateur_polyvalent_id = ?
  AND (
    o1_.date BETWEEN ?
    AND ?
  )
  AND (
    (
      o1_.is_annuler IS NULL
      OR o1_.is_annuler = 0
    )
  )
ORDER BY
  o1_.date DESC,
  o1_.heure_debut DESC

SELECT p0_.id AS id_0, p0_.commentaire AS commentaire_1, p0_.is_annuler AS is_annuler_2, p0_.raison_annulation AS raison_annulation_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.offre_id AS offre_id_6, p0_.formateur_polyvalent_id AS formateur_polyvalent_id_7, p0_.created_by_id AS created_by_id_8, p0_.updated_by_id AS updated_by_id_9 FROM postuler_offre p0_ INNER JOIN offre o1_ ON p0_.offre_id = o1_.id WHERE p0_.formateur_polyvalent_id = 16 AND (o1_.date BETWEEN '2025-09-01 00:00:00' AND '2026-08-31 23:59:59') AND ((o1_.is_annuler IS NULL OR o1_.is_annuler = 0)) ORDER BY o1_.date DESC, o1_.heure_debut DESC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.created_by_id AS created_by_id_5,
  t0.updated_by_id AS updated_by_id_6
FROM
  fonction t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6 FROM fonction t0 WHERE t0.id = 2;