Query Metrics
20
Database Queries
4
Different statements
4.25 ms
Query time
2
Invalid entities
Grouped Statements
| 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 |
|
| App\Entity\Domaine | No errors. |
| App\Entity\UniteRecherche |
|
| 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. |