Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 223
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 3
• Debug
• Emails
• Notifications
• Configuration

Query Metrics

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.open_date AS open_date_2, r0_.close_date AS close_date_3, r0_.audition AS audition_4, r0_.audition_date AS audition_date_5, r0_.audition_date_fin AS audition_date_fin_6, r0_.convocation_date AS convocation_date_7, r0_.response_date AS response_date_8, r0_.id_interne AS id_interne_9, r0_.id_externe AS id_externe_10, r0_.categorie AS categorie_11, r0_.description AS description_12, r0_.information AS information_13, r0_.comments AS comments_14, r0_.usernotaccess AS usernotaccess_15, r0_.is_spontane AS is_spontane_16, r0_.archive AS archive_17, r0_.pdf AS pdf_18, r0_.poste_actuel AS poste_actuel_19, r0_.motivation AS motivation_20, r0_.typepopulation_id AS typepopulation_id_21, r0_.fiche_id AS fiche_id_22, r0_.annexe_id AS annexe_id_23, r0_.poste_statut_id AS poste_statut_id_24 FROM rec_poste r0_ LEFT JOIN rec_type_population r1_ ON r0_.typepopulation_id = r1_.id LEFT JOIN rec_cat_population r2_ ON r1_.catpopulation_id = r2_.id WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.archive = false AND r2_.id = ? ORDER BY r2_.name ASC, r1_.name ASC, r0_.title ASC

[
  "2025-04-02 11:16:45"
  0
  2
]

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.open_date AS open_date_2,
  r0_.close_date AS close_date_3,
  r0_.audition AS audition_4,
  r0_.audition_date AS audition_date_5,
  r0_.audition_date_fin AS audition_date_fin_6,
  r0_.convocation_date AS convocation_date_7,
  r0_.response_date AS response_date_8,
  r0_.id_interne AS id_interne_9,
  r0_.id_externe AS id_externe_10,
  r0_.categorie AS categorie_11,
  r0_.description AS description_12,
  r0_.information AS information_13,
  r0_.comments AS comments_14,
  r0_.usernotaccess AS usernotaccess_15,
  r0_.is_spontane AS is_spontane_16,
  r0_.archive AS archive_17,
  r0_.pdf AS pdf_18,
  r0_.poste_actuel AS poste_actuel_19,
  r0_.motivation AS motivation_20,
  r0_.typepopulation_id AS typepopulation_id_21,
  r0_.fiche_id AS fiche_id_22,
  r0_.annexe_id AS annexe_id_23,
  r0_.poste_statut_id AS poste_statut_id_24
FROM
  rec_poste r0_
  LEFT JOIN rec_type_population r1_ ON r0_.typepopulation_id = r1_.id
  LEFT JOIN rec_cat_population r2_ ON r1_.catpopulation_id = r2_.id
WHERE
  (
    ? BETWEEN r0_.open_date
    AND r0_.close_date
  )
  AND r0_.is_spontane = ?
  AND r1_.archive = false
  AND r2_.id = ?
ORDER BY
  r2_.name ASC,
  r1_.name ASC,
  r0_.title ASC

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.open_date AS open_date_2, r0_.close_date AS close_date_3, r0_.audition AS audition_4, r0_.audition_date AS audition_date_5, r0_.audition_date_fin AS audition_date_fin_6, r0_.convocation_date AS convocation_date_7, r0_.response_date AS response_date_8, r0_.id_interne AS id_interne_9, r0_.id_externe AS id_externe_10, r0_.categorie AS categorie_11, r0_.description AS description_12, r0_.information AS information_13, r0_.comments AS comments_14, r0_.usernotaccess AS usernotaccess_15, r0_.is_spontane AS is_spontane_16, r0_.archive AS archive_17, r0_.pdf AS pdf_18, r0_.poste_actuel AS poste_actuel_19, r0_.motivation AS motivation_20, r0_.typepopulation_id AS typepopulation_id_21, r0_.fiche_id AS fiche_id_22, r0_.annexe_id AS annexe_id_23, r0_.poste_statut_id AS poste_statut_id_24 FROM rec_poste r0_ LEFT JOIN rec_type_population r1_ ON r0_.typepopulation_id = r1_.id LEFT JOIN rec_cat_population r2_ ON r1_.catpopulation_id = r2_.id WHERE ('2025-04-02 11:16:45' BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = 0 AND r1_.archive = false AND r2_.id = 2 ORDER BY r2_.name ASC, r1_.name ASC, r0_.title ASC;

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.name AS name_3, t0.archive AS archive_4 FROM rec_cat_population t0 WHERE t0.archive = ? ORDER BY t0.name ASC

[
  0
]

SELECT
  t0.id AS id_1,
  t0.identifiant AS identifiant_2,
  t0.name AS name_3,
  t0.archive AS archive_4
FROM
  rec_cat_population t0
WHERE
  t0.archive = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.name AS name_3, t0.archive AS archive_4 FROM rec_cat_population t0 WHERE t0.archive = 0 ORDER BY t0.name ASC;

SELECT t0.id AS id_1, t0.slogan AS slogan_2, t0.abstract AS abstract_3 FROM rec_parameters t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.slogan AS slogan_2,
  t0.abstract AS abstract_3
FROM
  rec_parameters t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slogan AS slogan_2, t0.abstract AS abstract_3 FROM rec_parameters t0 WHERE t0.id = 1;