GET https://recrutement-preprod.univ-avignon.fr/poste/LRU_67-68_2025

Query Metrics

24 Database Queries
6 Different statements
53.25 ms Query time
11 Invalid entities

Group similar statements

# Time Info
1 7.76 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 of 0
[ 0 ]
2 2.39 ms
SELECT t0.id AS id_1, t0.slogan AS slogan_2, t0.abstract AS abstract_3 FROM rec_parameters t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 1 ]
3 10.93 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 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
Parameters:
0 of 0
[ "2025-04-26 10:48:49" 0 2 ]
4 2.59 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:
0 of 0
[ 803 ]
5 1.16 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:
0 of 0
[ 797 ]
6 1.39 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:
0 of 0
[ 802 ]
7 1.09 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:
0 of 0
[ 801 ]
8 3.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 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
Parameters:
0 of 0
[ "2025-04-26 10:48:49" 0 1 ]
9 1.21 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:
0 of 0
[ 778 ]
10 1.61 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:
0 of 0
[ 779 ]
11 1.22 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:
0 of 0
[ 780 ]
12 1.29 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:
0 of 0
[ 781 ]
13 1.25 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:
0 of 0
[ 785 ]
14 1.10 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:
0 of 0
[ 784 ]
15 1.03 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:
0 of 0
[ 783 ]
16 1.24 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:
0 of 0
[ 782 ]
17 1.01 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:
0 of 0
[ 787 ]
18 0.95 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:
0 of 0
[ 786 ]
19 0.94 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:
0 of 0
[ 788 ]
20 2.59 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 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
Parameters:
0 of 0
[ "2025-04-26 10:48:49" 0 5 ]
21 2.92 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 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
Parameters:
0 of 0
[ "2025-04-26 10:48:49" 0 6 ]
22 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:
0 of 0
[ 800 ]
23 2.31 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_ WHERE r0_.id_interne = ?
Parameters:
0 of 0
[ "LRU_67-68_2025" ]
24 0.76 ms
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.name AS name_3, t0.mail AS mail_4, t0.signature_mail AS signature_mail_5, t0.private AS private_6, t0.pdf AS pdf_7, t0.uids AS uids_8, t0.archive AS archive_9, t0.catpopulation_id AS catpopulation_id_10 FROM rec_type_population t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 11 ]