https://recrutement-preprod.univ-avignon.fr/poste/SSE_medecin_2024

Query Metrics

3 Database Queries
3 Different statements
5.06 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 2.28 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 = ?
Parameters:
[
  0
]
2 0.97 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
]
3 1.82 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_.convocation_date AS convocation_date_6, r0_.response_date AS response_date_7, r0_.id_interne AS id_interne_8, r0_.id_externe AS id_externe_9, r0_.description AS description_10, r0_.information AS information_11, r0_.comments AS comments_12, r0_.usernotaccess AS usernotaccess_13, r0_.is_spontane AS is_spontane_14, r0_.archive AS archive_15, r0_.pdf AS pdf_16, r0_.typepopulation_id AS typepopulation_id_17, r0_.fiche_id AS fiche_id_18, r0_.annexe_id AS annexe_id_19 FROM rec_poste r0_ WHERE r0_.id_interne = ?
Parameters:
[
  "SSE_medecin_2024"
]

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\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.
App\Entity\RecTypePopulation No errors.
App\Entity\RecDocument
  • The association App\Entity\RecDocument#candidature refers to the inverse side field App\Entity\RecCandidature#document which does not exist.