Symfony Profiler

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 = 6;

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,
  o1_.id AS id_6,
  o1_.date AS date_7,
  o1_.heure_debut AS heure_debut_8,
  o1_.heure_fin AS heure_fin_9,
  o1_.is_annuler AS is_annuler_10,
  o1_.motifs_annuler AS motifs_annuler_11,
  o1_.commentaire AS commentaire_12,
  o1_.created_at AS created_at_13,
  o1_.updated_at AS updated_at_14,
  o1_.reference_groupe AS reference_groupe_15,
  o1_.id_groupe AS id_groupe_16,
  o1_.niveau AS niveau_17,
  c2_.id AS id_18,
  c2_.label AS label_19,
  c2_.created_at AS created_at_20,
  c2_.updated_at AS updated_at_21,
  c2_.is_active AS is_active_22,
  l3_.id AS id_23,
  l3_.label AS label_24,
  l3_.siege_address AS siege_address_25,
  l3_.cours_address AS cours_address_26,
  l3_.contact AS contact_27,
  l3_.is_lee AS is_lee_28,
  l3_.created_at AS created_at_29,
  l3_.updated_at AS updated_at_30,
  p4_.id AS id_31,
  p4_.first_name AS first_name_32,
  p4_.last_name AS last_name_33,
  p4_.is_archived AS is_archived_34,
  p4_.created_at AS created_at_35,
  p4_.updated_at AS updated_at_36,
  p0_.offre_id AS offre_id_37,
  p0_.formateur_polyvalent_id AS formateur_polyvalent_id_38,
  p0_.created_by_id AS created_by_id_39,
  p0_.updated_by_id AS updated_by_id_40,
  o1_.created_by_id AS created_by_id_41,
  o1_.updated_by_id AS updated_by_id_42,
  o1_.centre_alpha_id AS centre_alpha_id_43,
  o1_.formateur_titulaire_id AS formateur_titulaire_id_44,
  o1_.lieu_id AS lieu_id_45,
  o1_.motif_remplacement_id AS motif_remplacement_id_46,
  c2_.created_by_id AS created_by_id_47,
  c2_.updated_by_id AS updated_by_id_48,
  l3_.created_by_id AS created_by_id_49,
  l3_.updated_by_id AS updated_by_id_50,
  p4_.genre_id AS genre_id_51,
  p4_.fonction_id AS fonction_id_52,
  p4_.created_by_id AS created_by_id_53,
  p4_.updated_by_id AS updated_by_id_54
FROM
  postuler_offre p0_
  INNER JOIN offre o1_ ON p0_.offre_id = o1_.id
  INNER JOIN centre_alpha c2_ ON o1_.centre_alpha_id = c2_.id
  LEFT JOIN lieu_formation l3_ ON o1_.lieu_id = l3_.id
  LEFT JOIN personnel p4_ ON p0_.formateur_polyvalent_id = p4_.id
WHERE
  (
    o1_.date BETWEEN ?
    AND ?
  )
  AND p0_.formateur_polyvalent_id IN (?, ?, ?, ?, ?, ?, ?)
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, o1_.id AS id_6, o1_.date AS date_7, o1_.heure_debut AS heure_debut_8, o1_.heure_fin AS heure_fin_9, o1_.is_annuler AS is_annuler_10, o1_.motifs_annuler AS motifs_annuler_11, o1_.commentaire AS commentaire_12, o1_.created_at AS created_at_13, o1_.updated_at AS updated_at_14, o1_.reference_groupe AS reference_groupe_15, o1_.id_groupe AS id_groupe_16, o1_.niveau AS niveau_17, c2_.id AS id_18, c2_.label AS label_19, c2_.created_at AS created_at_20, c2_.updated_at AS updated_at_21, c2_.is_active AS is_active_22, l3_.id AS id_23, l3_.label AS label_24, l3_.siege_address AS siege_address_25, l3_.cours_address AS cours_address_26, l3_.contact AS contact_27, l3_.is_lee AS is_lee_28, l3_.created_at AS created_at_29, l3_.updated_at AS updated_at_30, p4_.id AS id_31, p4_.first_name AS first_name_32, p4_.last_name AS last_name_33, p4_.is_archived AS is_archived_34, p4_.created_at AS created_at_35, p4_.updated_at AS updated_at_36, p0_.offre_id AS offre_id_37, p0_.formateur_polyvalent_id AS formateur_polyvalent_id_38, p0_.created_by_id AS created_by_id_39, p0_.updated_by_id AS updated_by_id_40, o1_.created_by_id AS created_by_id_41, o1_.updated_by_id AS updated_by_id_42, o1_.centre_alpha_id AS centre_alpha_id_43, o1_.formateur_titulaire_id AS formateur_titulaire_id_44, o1_.lieu_id AS lieu_id_45, o1_.motif_remplacement_id AS motif_remplacement_id_46, c2_.created_by_id AS created_by_id_47, c2_.updated_by_id AS updated_by_id_48, l3_.created_by_id AS created_by_id_49, l3_.updated_by_id AS updated_by_id_50, p4_.genre_id AS genre_id_51, p4_.fonction_id AS fonction_id_52, p4_.created_by_id AS created_by_id_53, p4_.updated_by_id AS updated_by_id_54 FROM postuler_offre p0_ INNER JOIN offre o1_ ON p0_.offre_id = o1_.id INNER JOIN centre_alpha c2_ ON o1_.centre_alpha_id = c2_.id LEFT JOIN lieu_formation l3_ ON o1_.lieu_id = l3_.id LEFT JOIN personnel p4_ ON p0_.formateur_polyvalent_id = p4_.id WHERE (o1_.date BETWEEN '2025-09-01 00:00:00' AND '2026-08-31 23:59:59') AND p0_.formateur_polyvalent_id IN (69, 9, 16, 76, 48, 79, 75) ORDER BY o1_.date DESC, o1_.heure_debut DESC;

SELECT
  p0_.id AS id_0,
  p0_.first_name AS first_name_1,
  p0_.last_name AS last_name_2,
  p0_.is_archived AS is_archived_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.genre_id AS genre_id_6,
  p0_.fonction_id AS fonction_id_7,
  p0_.created_by_id AS created_by_id_8,
  p0_.updated_by_id AS updated_by_id_9
FROM
  personnel p0_
  INNER JOIN fonction f1_ ON p0_.fonction_id = f1_.id
WHERE
  f1_.label LIKE ?
  AND (
    (
      p0_.is_archived = 0
      OR p0_.is_archived IS NULL
    )
  )
ORDER BY
  p0_.last_name ASC,
  p0_.first_name ASC

SELECT p0_.id AS id_0, p0_.first_name AS first_name_1, p0_.last_name AS last_name_2, p0_.is_archived AS is_archived_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.genre_id AS genre_id_6, p0_.fonction_id AS fonction_id_7, p0_.created_by_id AS created_by_id_8, p0_.updated_by_id AS updated_by_id_9 FROM personnel p0_ INNER JOIN fonction f1_ ON p0_.fonction_id = f1_.id WHERE f1_.label LIKE '%polyvalent%' AND ((p0_.is_archived = 0 OR p0_.is_archived IS NULL)) ORDER BY p0_.last_name ASC, p0_.first_name ASC;

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.personnel_id = ?

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.personnel_id = 69;

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.id = ?

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.id = 5;

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 = 5;

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 = 3;