Symfony Profiler

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

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,
  c1_.id AS id_12,
  c1_.label AS label_13,
  c1_.created_at AS created_at_14,
  c1_.updated_at AS updated_at_15,
  c1_.is_active AS is_active_16,
  p2_.id AS id_17,
  p2_.first_name AS first_name_18,
  p2_.last_name AS last_name_19,
  p2_.is_archived AS is_archived_20,
  p2_.created_at AS created_at_21,
  p2_.updated_at AS updated_at_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,
  m4_.id AS id_31,
  m4_.label AS label_32,
  m4_.created_at AS created_at_33,
  m4_.updated_at AS updated_at_34,
  p5_.id AS id_35,
  p5_.commentaire AS commentaire_36,
  p5_.is_annuler AS is_annuler_37,
  p5_.raison_annulation AS raison_annulation_38,
  p5_.created_at AS created_at_39,
  p5_.updated_at AS updated_at_40,
  p6_.id AS id_41,
  p6_.first_name AS first_name_42,
  p6_.last_name AS last_name_43,
  p6_.is_archived AS is_archived_44,
  p6_.created_at AS created_at_45,
  p6_.updated_at AS updated_at_46,
  o0_.created_by_id AS created_by_id_47,
  o0_.updated_by_id AS updated_by_id_48,
  o0_.centre_alpha_id AS centre_alpha_id_49,
  o0_.formateur_titulaire_id AS formateur_titulaire_id_50,
  o0_.lieu_id AS lieu_id_51,
  o0_.motif_remplacement_id AS motif_remplacement_id_52,
  c1_.created_by_id AS created_by_id_53,
  c1_.updated_by_id AS updated_by_id_54,
  p2_.genre_id AS genre_id_55,
  p2_.fonction_id AS fonction_id_56,
  p2_.created_by_id AS created_by_id_57,
  p2_.updated_by_id AS updated_by_id_58,
  l3_.created_by_id AS created_by_id_59,
  l3_.updated_by_id AS updated_by_id_60,
  m4_.created_by_id AS created_by_id_61,
  m4_.updated_by_id AS updated_by_id_62,
  p5_.offre_id AS offre_id_63,
  p5_.formateur_polyvalent_id AS formateur_polyvalent_id_64,
  p5_.created_by_id AS created_by_id_65,
  p5_.updated_by_id AS updated_by_id_66,
  p6_.genre_id AS genre_id_67,
  p6_.fonction_id AS fonction_id_68,
  p6_.created_by_id AS created_by_id_69,
  p6_.updated_by_id AS updated_by_id_70
FROM
  offre o0_
  LEFT JOIN centre_alpha c1_ ON o0_.centre_alpha_id = c1_.id
  LEFT JOIN personnel p2_ ON o0_.formateur_titulaire_id = p2_.id
  LEFT JOIN lieu_formation l3_ ON o0_.lieu_id = l3_.id
  LEFT JOIN motif_absence m4_ ON o0_.motif_remplacement_id = m4_.id
  LEFT JOIN postuler_offre p5_ ON o0_.id = p5_.offre_id
  LEFT JOIN personnel p6_ ON p5_.formateur_polyvalent_id = p6_.id
WHERE
  o0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
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, c1_.id AS id_12, c1_.label AS label_13, c1_.created_at AS created_at_14, c1_.updated_at AS updated_at_15, c1_.is_active AS is_active_16, p2_.id AS id_17, p2_.first_name AS first_name_18, p2_.last_name AS last_name_19, p2_.is_archived AS is_archived_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_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, m4_.id AS id_31, m4_.label AS label_32, m4_.created_at AS created_at_33, m4_.updated_at AS updated_at_34, p5_.id AS id_35, p5_.commentaire AS commentaire_36, p5_.is_annuler AS is_annuler_37, p5_.raison_annulation AS raison_annulation_38, p5_.created_at AS created_at_39, p5_.updated_at AS updated_at_40, p6_.id AS id_41, p6_.first_name AS first_name_42, p6_.last_name AS last_name_43, p6_.is_archived AS is_archived_44, p6_.created_at AS created_at_45, p6_.updated_at AS updated_at_46, o0_.created_by_id AS created_by_id_47, o0_.updated_by_id AS updated_by_id_48, o0_.centre_alpha_id AS centre_alpha_id_49, o0_.formateur_titulaire_id AS formateur_titulaire_id_50, o0_.lieu_id AS lieu_id_51, o0_.motif_remplacement_id AS motif_remplacement_id_52, c1_.created_by_id AS created_by_id_53, c1_.updated_by_id AS updated_by_id_54, p2_.genre_id AS genre_id_55, p2_.fonction_id AS fonction_id_56, p2_.created_by_id AS created_by_id_57, p2_.updated_by_id AS updated_by_id_58, l3_.created_by_id AS created_by_id_59, l3_.updated_by_id AS updated_by_id_60, m4_.created_by_id AS created_by_id_61, m4_.updated_by_id AS updated_by_id_62, p5_.offre_id AS offre_id_63, p5_.formateur_polyvalent_id AS formateur_polyvalent_id_64, p5_.created_by_id AS created_by_id_65, p5_.updated_by_id AS updated_by_id_66, p6_.genre_id AS genre_id_67, p6_.fonction_id AS fonction_id_68, p6_.created_by_id AS created_by_id_69, p6_.updated_by_id AS updated_by_id_70 FROM offre o0_ LEFT JOIN centre_alpha c1_ ON o0_.centre_alpha_id = c1_.id LEFT JOIN personnel p2_ ON o0_.formateur_titulaire_id = p2_.id LEFT JOIN lieu_formation l3_ ON o0_.lieu_id = l3_.id LEFT JOIN motif_absence m4_ ON o0_.motif_remplacement_id = m4_.id LEFT JOIN postuler_offre p5_ ON o0_.id = p5_.offre_id LEFT JOIN personnel p6_ ON p5_.formateur_polyvalent_id = p6_.id WHERE o0_.id IN (325, 326, 295, 296, 297, 301, 298, 154, 302, 299, 303, 300, 304, 117, 153, 305) ORDER BY o0_.date ASC, o0_.heure_debut 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.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 = 4;

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
  o0_.id AS id_0
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
LIMIT
  20

SELECT o0_.id AS id_0 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' AND '2026-08-31') AND p1_.id IS NULL ORDER BY o0_.date ASC, o0_.heure_debut ASC LIMIT 20;

SELECT
  COUNT(o0_.id) AS sclr_0
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

SELECT COUNT(o0_.id) AS sclr_0 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' AND '2026-08-31') AND p1_.id IS NULL;

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.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;

SELECT
  DISTINCT o0_.niveau AS niveau_0
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
  AND o0_.niveau IS NOT NULL
  AND o0_.niveau <> ''
ORDER BY
  o0_.niveau ASC

SELECT DISTINCT o0_.niveau AS niveau_0 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' AND '2026-08-31') AND p1_.id IS NULL AND o0_.niveau IS NOT NULL AND o0_.niveau <> '' ORDER BY o0_.niveau ASC;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.first_name AS first_name_1,
  p0_.last_name AS last_name_2
FROM
  offre o1_
  INNER JOIN personnel p0_ ON o1_.formateur_titulaire_id = p0_.id
  LEFT JOIN postuler_offre p2_ ON o1_.id = p2_.offre_id
  AND (
    p2_.is_annuler = 0
    OR p2_.is_annuler IS NULL
  )
WHERE
  (
    (
      o1_.is_annuler IS NULL
      OR o1_.is_annuler = 0
    )
  )
  AND o1_.date >= ?
  AND (
    o1_.date BETWEEN ?
    AND ?
  )
  AND p2_.id IS NULL
ORDER BY
  p0_.last_name ASC,
  p0_.first_name ASC

SELECT DISTINCT p0_.id AS id_0, p0_.first_name AS first_name_1, p0_.last_name AS last_name_2 FROM offre o1_ INNER JOIN personnel p0_ ON o1_.formateur_titulaire_id = p0_.id LEFT JOIN postuler_offre p2_ ON o1_.id = p2_.offre_id AND (p2_.is_annuler = 0 OR p2_.is_annuler IS NULL) WHERE ((o1_.is_annuler IS NULL OR o1_.is_annuler = 0)) AND o1_.date >= '2026-04-12 00:00:00' AND (o1_.date BETWEEN '2025-09-01' AND '2026-08-31') AND p2_.id IS NULL ORDER BY p0_.last_name ASC, p0_.first_name ASC;

SELECT
  DISTINCT o0_.id_groupe AS id_groupe_0
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_.id_groupe ASC

SELECT DISTINCT o0_.id_groupe AS id_groupe_0 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' AND '2026-08-31') AND p1_.id IS NULL ORDER BY o0_.id_groupe ASC;