Symfony Profiler

Query Metrics

28 Database Queries

4 Different statements

45.86 ms Query time

11 Invalid entities

Queries


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 r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name 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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name 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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC
SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name 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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name 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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?
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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC
SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name ASC
SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name 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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC
SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ?

#▲	Time	Info
1	9.05 ms	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 Parameters: [`0`] View formatted query View runnable query Explain query 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;
2	4.99 ms	SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name ASC Parameters: [`2`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name ASC SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = 2 AND r0_.archive = false ORDER BY r0_.name ASC;
3	5.89 ms	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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC Parameters: [`"2025-04-26 10:21:20" 0 1`] View formatted query View runnable query Explain query 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 WHERE ( ? BETWEEN r0_.open_date AND r0_.close_date ) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name 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 WHERE ('2025-04-26 10:21:20' BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = 0 AND r1_.id = 1 ORDER BY r1_.name ASC;
4	2.35 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`797`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 797;
5	1.13 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`801`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 801;
6	0.89 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`803`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 803;
7	1.05 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`802`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 802;
8	2.27 ms	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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC Parameters: [`"2025-04-26 10:21:21" 0 12`] View formatted query View runnable query Explain query 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 WHERE ( ? BETWEEN r0_.open_date AND r0_.close_date ) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name 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 WHERE ('2025-04-26 10:21:21' BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = 0 AND r1_.id = 12 ORDER BY r1_.name ASC;
9	1.84 ms	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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC Parameters: [`"2025-04-26 10:21:21" 0 6`] View formatted query View runnable query Explain query 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 WHERE ( ? BETWEEN r0_.open_date AND r0_.close_date ) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name 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 WHERE ('2025-04-26 10:21:21' BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = 0 AND r1_.id = 6 ORDER BY r1_.name ASC;
10	1.21 ms	SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name ASC SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = 1 AND r0_.archive = false ORDER BY r0_.name ASC;
11	1.65 ms	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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC Parameters: [`"2025-04-26 10:21:21" 0 4`] View formatted query View runnable query Explain query 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 WHERE ( ? BETWEEN r0_.open_date AND r0_.close_date ) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name 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 WHERE ('2025-04-26 10:21:21' BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = 0 AND r1_.id = 4 ORDER BY r1_.name ASC;
12	1.68 ms	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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC Parameters: [`"2025-04-26 10:21:21" 0 11`] View formatted query View runnable query Explain query 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 WHERE ( ? BETWEEN r0_.open_date AND r0_.close_date ) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name 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 WHERE ('2025-04-26 10:21:21' BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = 0 AND r1_.id = 11 ORDER BY r1_.name ASC;
13	0.77 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`780`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 780;
14	0.67 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`782`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 782;
15	0.65 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`783`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 783;
16	0.58 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`779`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 779;
17	0.63 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`786`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 786;
18	0.62 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`781`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 781;
19	0.63 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`778`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 778;
20	0.66 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`788`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 788;
21	0.56 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`784`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 784;
22	0.55 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`785`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 785;
23	0.60 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`787`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 787;
24	1.45 ms	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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC Parameters: [`"2025-04-26 10:21:21" 0 10`] View formatted query View runnable query Explain query 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 WHERE ( ? BETWEEN r0_.open_date AND r0_.close_date ) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name 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 WHERE ('2025-04-26 10:21:21' BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = 0 AND r1_.id = 10 ORDER BY r1_.name ASC;
25	0.64 ms	SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name ASC Parameters: [`5`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name ASC SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = 5 AND r0_.archive = false ORDER BY r0_.name ASC;
26	0.65 ms	SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name ASC Parameters: [`6`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = ? AND r0_.archive = false ORDER BY r0_.name ASC SELECT r0_.id AS id_0, r0_.identifiant AS identifiant_1, r0_.name AS name_2, r0_.mail AS mail_3, r0_.signature_mail AS signature_mail_4, r0_.private AS private_5, r0_.pdf AS pdf_6, r0_.uids AS uids_7, r0_.archive AS archive_8, r0_.catpopulation_id AS catpopulation_id_9 FROM rec_type_population r0_ LEFT JOIN rec_cat_population r1_ ON r0_.catpopulation_id = r1_.id WHERE r1_.id = 6 AND r0_.archive = false ORDER BY r0_.name ASC;
27	1.55 ms	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 WHERE (? BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name ASC Parameters: [`"2025-04-26 10:21:21" 0 16`] View formatted query View runnable query Explain query 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 WHERE ( ? BETWEEN r0_.open_date AND r0_.close_date ) AND r0_.is_spontane = ? AND r1_.id = ? ORDER BY r1_.name 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 WHERE ('2025-04-26 10:21:21' BETWEEN r0_.open_date AND r0_.close_date) AND r0_.is_spontane = 0 AND r1_.id = 16 ORDER BY r1_.name ASC;
28	0.65 ms	SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? Parameters: [`800`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = ? SELECT t0.id AS id_1, t0.presidentid AS presidentid_2, t0.vicepresidentid AS vicepresidentid_3, t0.send_date AS send_date_4, t0.close_date AS close_date_5, t0.avis AS avis_6, t0.poste_id AS poste_id_7 FROM rec_commission t0 WHERE t0.poste_id = 800;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\RecCategoryPopulation	No errors.
App\Entity\RecTypePopulation	No errors.
App\Entity\RecPoste	The mappings App\Entity\RecPoste#documents and App\Entity\RecDocumentPoste#poste are inconsistent with each other. The mappings App\Entity\RecPoste#emails and App\Entity\RecEmail#poste are inconsistent with each other. The field App\Entity\RecPoste#commission is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RecCommission#poste does not contain the required 'inversedBy="commission"' attribute. The association App\Entity\RecPoste#posteStatut refers to the inverse side field App\Entity\RecPosteStatut#poste which does not exist.
App\Entity\RecDocument	The association App\Entity\RecDocument#candidature refers to the inverse side field App\Entity\RecCandidature#document which does not exist.
App\Entity\RecPosteStatut	The association App\Entity\RecPosteStatut#postes refers to the owning side field App\Entity\RecPoste#poste which does not exist.
App\Entity\RecCandidature	The association App\Entity\RecCandidature#candidatureStatut refers to the inverse side field App\Entity\RecCandidatureStatut#candidature which does not exist. The association App\Entity\RecCandidature#candidatureSuivie refers to the inverse side field App\Entity\RecCandidatureSuivie#candidature which does not exist. The association App\Entity\RecCandidature#candidatureAudition refers to the inverse side field App\Entity\RecCandidatureAudition#candidature which does not exist. The association App\Entity\RecCandidature#candidatureSituation refers to the inverse side field App\Entity\RecCandidatureSituation#candidature which does not exist. The association App\Entity\RecCandidature#candidatureOrigine refers to the inverse side field App\Entity\RecCandidatureOrigine#candidature which does not exist. The mappings App\Entity\RecCandidature#documents and App\Entity\RecDocument#candidature are inconsistent with each other. The mappings App\Entity\RecCandidature#rapports and App\Entity\RecRapport#candidature are inconsistent with each other. The field App\Entity\RecCandidature#avisMembre is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RecAvisMembre#candidature does not contain the required 'inversedBy="avisMembre"' attribute. The association App\Entity\RecCandidature#secteur refers to the inverse side field App\Entity\RecSecteur#candidature which does not exist.
App\Entity\RecDocumentPoste	The association App\Entity\RecDocumentPoste#poste refers to the inverse side field App\Entity\RecPoste#document which does not exist.
App\Entity\RecEmail	The association App\Entity\RecEmail#poste refers to the inverse side field App\Entity\RecPoste#email which does not exist. The mappings App\Entity\RecEmail#pj and App\Entity\RecPieceJointe#emails are inconsistent with each other.
App\Entity\RecCommission	The mappings App\Entity\RecCommission#documents and App\Entity\RecDocumentCommission#commission are inconsistent with each other. The mappings App\Entity\RecCommission#sousCommissions and App\Entity\RecSousCommission#commission are inconsistent with each other.
App\Entity\RecMembre	The field App\Entity\RecMembre#avisMembre is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RecAvisMembre#candidature does not contain the required 'inversedBy="avisMembre"' attribute.
App\Entity\RecDocumentCommission	The association App\Entity\RecDocumentCommission#commission refers to the inverse side field App\Entity\RecCommission#document which does not exist. The association App\Entity\RecDocumentCommission#sousCommission refers to the inverse side field App\Entity\RecSousCommission#document which does not exist.
App\Entity\RecMembreLog	The mappings App\Entity\RecMembreLog#sousCommission and App\Entity\RecSousCommission#membreLog are inconsistent with each other.
App\Entity\RecSousCommission	The association App\Entity\RecSousCommission#commission refers to the inverse side field App\Entity\RecCommission#commission which does not exist. The association App\Entity\RecSousCommission#membreLog refers to the owning side field App\Entity\RecMembreLog#souscommission which does not exist.

Symfony Profiler

GET https://recrutement-preprod.univ-avignon.fr/postes

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping