Query Metrics
31
Database Queries
5
Different statements
4.05 ms
Query time
5
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.40 ms (34.46%) |
10 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliation AS affiliation_3, t0.status AS status_4, t0.email AS email_5, t0.soutenance_id AS soutenance_id_6 FROM membres_jury t0 WHERE t0.soutenance_id = ?
Parameters:
[
29
]
|
|
0.89 ms (21.89%) |
10 |
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.year AS year_5, t0.is_update AS is_update_6, t0.avis_prof AS avis_prof_7, t0.doctotant_id AS doctotant_id_8, t0.soutenance_id AS soutenance_id_9 FROM depot_dossier t0 WHERE t0.soutenance_id = ?
Parameters:
[
29
]
|
|
0.66 ms (16.41%) |
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, t9.depot_dossier_id AS depot_dossier_id_24 FROM domaine t0 LEFT JOIN soutenance t9 ON t9.domaine_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.60 ms (14.91%) |
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:
[
1
]
|
|
0.50 ms (12.32%) |
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, s0_.depot_dossier_id AS depot_dossier_id_14 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 |
|
| App\Entity\Domaine | No errors. |
| App\Entity\UniteRecherche |
|
| App\Entity\User | No errors. |
| App\Entity\DepotDossier | No errors. |
| App\Entity\MembresJury | No errors. |
| App\Entity\Doctorant |
|
| App\Entity\EnseigCommuns | No errors. |
| App\Entity\EnseigSpecifique | No errors. |
| App\Entity\InitPedagoUni | No errors. |
| App\Entity\StageDoctorant | No errors. |
| App\Entity\PartJourneeSeminaire | No errors. |
| App\Entity\AutreActiviteesGlobales | No errors. |
| App\Entity\RevuesDoctorant |
|
| App\Entity\BrevetDoctorant | No errors. |
| App\Entity\ConferenceDoctorant | No errors. |
| App\Entity\OuvrageDoctorant | No errors. |
| App\Entity\TheseDoc | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\SeminaireRedactionScientifique | No errors. |
| App\Entity\Rapporteurs |
|
| 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. |