GET https://iav.drsfd.ma/soutenance

Query Metrics

20 Database Queries
4 Different statements
4.25 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.49 ms
(35.05%)
9
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliation AS affiliation_3, t0.status AS status_4, t0.soutenance_id AS soutenance_id_5 FROM membres_jury t0 WHERE t0.soutenance_id = ?
Parameters:
[
  27
]
1.10 ms
(25.77%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.status AS status_4, t0.info_message AS info_message_5, t0.photo AS photo_6, t0.coordinateur_saisie AS coordinateur_saisie_7, t0.coordinator_id AS coordinator_id_8, t9.id AS id_10, t9.name AS name_11, t9.date AS date_12, t9.titre AS titre_13, t9.lieu AS lieu_14, t9.created_at AS created_at_15, t9.slug AS slug_16, t9.status AS status_17, t9.affiche AS affiche_18, t9.resume AS resume_19, t9.heure AS heure_20, t9.domaine_id AS domaine_id_21, t9.unite_recherche_id AS unite_recherche_id_22, t9.created_by_id AS created_by_id_23 FROM domaine t0 LEFT JOIN soutenance t9 ON t9.domaine_id = t0.id WHERE t0.id = ?
Parameters:
[
  16
]
0.96 ms
(22.66%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.nature AS nature_4, t0.etablissement AS etablissement_5, t0.status AS status_6, t0.coordinateur_saisie AS coordinateur_saisie_7, t0.coordinateur_id AS coordinateur_id_8, t0.domaine_id AS domaine_id_9 FROM unite_recherche t0 WHERE t0.id = ?
Parameters:
[
  21
]
0.70 ms
(16.52%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.date AS date_2, s0_.titre AS titre_3, s0_.lieu AS lieu_4, s0_.created_at AS created_at_5, s0_.slug AS slug_6, s0_.status AS status_7, s0_.affiche AS affiche_8, s0_.resume AS resume_9, s0_.heure AS heure_10, s0_.domaine_id AS domaine_id_11, s0_.unite_recherche_id AS unite_recherche_id_12, s0_.created_by_id AS created_by_id_13 FROM soutenance s0_ ORDER BY s0_.date DESC
Parameters:
[]

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\Soutenance
  • If association App\Entity\Soutenance#domaine is many-to-one, then the inversed side App\Entity\Domaine#soutenance has to be one-to-many.
App\Entity\Domaine No errors.
App\Entity\UniteRecherche
  • The association App\Entity\UniteRecherche#Coordinateur refers to the inverse side field App\Entity\Professeur#uniteRecherches which does not exist.
App\Entity\User No errors.
App\Entity\MembresJury No errors.
App\Entity\Professeur No errors.
App\Entity\ExternThese No errors.
App\Entity\ComiteThese No errors.
App\Entity\InternThese No errors.
App\Entity\InscriptionDoctorant No errors.