GET https://recrutement-preprod.univ-avignon.fr/poste/CAND_SPONT

Response
200 OK
IP
18.217.207.112
Profiled on
Token
8ff102

Query Metrics

9 Database Queries
6 Different statements
71.63 ms Query time
7 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 11.06 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
2 2.60 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: 
[
  1
]
View formatted query    View runnable query    Explain query
3 10.81 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: 
[
  "2025-04-03 11:12:05"
  0
  2
]
View formatted query    View runnable query    Explain query
4 3.04 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: 
[
  "2025-04-03 11:12:05"
  0
  1
]
View formatted query    View runnable query    Explain query
5 2.29 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: 
[
  "2025-04-03 11:12:05"
  0
  5
]
View formatted query    View runnable query    Explain query
6 2.28 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: 
[
  "2025-04-03 11:12:05"
  0
  6
]
View formatted query    View runnable query    Explain query
7 2.81 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: 
[
  "CAND_SPONT"
]
View formatted query    View runnable query    Explain query
8 35.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: 
[
  2
]
View formatted query    View runnable query    Explain query
9 1.69 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: 
[
  1
]
View formatted query    View runnable query    Explain query

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\RecParameters 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.