Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

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, o0_.created_by_id AS created_by_id_35, o0_.updated_by_id AS updated_by_id_36, o0_.centre_alpha_id AS centre_alpha_id_37, o0_.formateur_titulaire_id AS formateur_titulaire_id_38, o0_.lieu_id AS lieu_id_39, o0_.motif_remplacement_id AS motif_remplacement_id_40, c1_.created_by_id AS created_by_id_41, c1_.updated_by_id AS updated_by_id_42, p2_.genre_id AS genre_id_43, p2_.fonction_id AS fonction_id_44, p2_.created_by_id AS created_by_id_45, p2_.updated_by_id AS updated_by_id_46, l3_.created_by_id AS created_by_id_47, l3_.updated_by_id AS updated_by_id_48, m4_.created_by_id AS created_by_id_49, m4_.updated_by_id AS updated_by_id_50 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 WHERE o0_.created_at >= ? AND o0_.created_at < ? AND ((o0_.is_annuler IS NULL OR o0_.is_annuler = 0)) ORDER BY o0_.date ASC, o0_.heure_debut ASC

[
  "2026-06-19 00:00:00"
  "2026-06-20 00:00:00"
]

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,
  o0_.created_by_id AS created_by_id_35,
  o0_.updated_by_id AS updated_by_id_36,
  o0_.centre_alpha_id AS centre_alpha_id_37,
  o0_.formateur_titulaire_id AS formateur_titulaire_id_38,
  o0_.lieu_id AS lieu_id_39,
  o0_.motif_remplacement_id AS motif_remplacement_id_40,
  c1_.created_by_id AS created_by_id_41,
  c1_.updated_by_id AS updated_by_id_42,
  p2_.genre_id AS genre_id_43,
  p2_.fonction_id AS fonction_id_44,
  p2_.created_by_id AS created_by_id_45,
  p2_.updated_by_id AS updated_by_id_46,
  l3_.created_by_id AS created_by_id_47,
  l3_.updated_by_id AS updated_by_id_48,
  m4_.created_by_id AS created_by_id_49,
  m4_.updated_by_id AS updated_by_id_50
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
WHERE
  o0_.created_at >= ?
  AND o0_.created_at < ?
  AND (
    (
      o0_.is_annuler IS NULL
      OR o0_.is_annuler = 0
    )
  )
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, o0_.created_by_id AS created_by_id_35, o0_.updated_by_id AS updated_by_id_36, o0_.centre_alpha_id AS centre_alpha_id_37, o0_.formateur_titulaire_id AS formateur_titulaire_id_38, o0_.lieu_id AS lieu_id_39, o0_.motif_remplacement_id AS motif_remplacement_id_40, c1_.created_by_id AS created_by_id_41, c1_.updated_by_id AS updated_by_id_42, p2_.genre_id AS genre_id_43, p2_.fonction_id AS fonction_id_44, p2_.created_by_id AS created_by_id_45, p2_.updated_by_id AS updated_by_id_46, l3_.created_by_id AS created_by_id_47, l3_.updated_by_id AS updated_by_id_48, m4_.created_by_id AS created_by_id_49, m4_.updated_by_id AS updated_by_id_50 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 WHERE o0_.created_at >= '2026-06-19 00:00:00' AND o0_.created_at < '2026-06-20 00:00:00' AND ((o0_.is_annuler IS NULL OR o0_.is_annuler = 0)) ORDER BY o0_.date ASC, o0_.heure_debut ASC;