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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 5.69 ms
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:
[]
2 0.43 ms
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
]
3 0.19 ms
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
]
4 0.43 ms
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
]
5 0.22 ms
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:
[
  1
]
6 0.17 ms
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:
[
  1
]
7 0.20 ms
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:
[
  26
]
8 0.17 ms
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:
[
  23
]
9 0.17 ms
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:
[
  28
]
10 0.24 ms
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:
[
  2
]
11 0.17 ms
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:
[
  15
]
12 0.17 ms
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:
[
  25
]
13 0.18 ms
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:
[
  24
]
14 0.19 ms
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:
[
  23
]
15 0.23 ms
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:
[
  13
]
16 0.16 ms
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:
[
  14
]
17 0.33 ms
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:
[
  19
]
18 0.18 ms
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:
[
  20
]
19 0.16 ms
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:
[
  11
]
20 0.17 ms
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:
[
  18
]

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.