Query Metrics
21
Database Queries
5
Different statements
3.23 ms
Query time
6
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.08 ms (33.46%) |
5 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.cin AS cin_7, t0.tel AS tel_8, t0.birthday AS birthday_9, t0.status AS status_10, t0.photo AS photo_11, t0.cin_path AS cin_path_12, t13.id AS id_14, t13.grade AS grade_15, t13.created_at AS created_at_16, t13.updated_at AS updated_at_17, t13.origin_institute AS origin_institute_18, t13.is_intern AS is_intern_19, t13.correspond_email AS correspond_email_20, t13.departement_id AS departement_id_21, t13.user_id AS user_id_22, t23.id AS id_24, t23.code_iav AS code_iav_25, t23.titre_these AS titre_these_26, t23.created_at AS created_at_27, t23.updated_at AS updated_at_28, t23.lieu_naissance AS lieu_naissance_29, t23.sexe AS sexe_30, t23.nationalite AS nationalite_31, t23.code_carte_sejour AS code_carte_sejour_32, t23.cne AS cne_33, t23.adresse AS adresse_34, t23.status AS status_35, t23.email_recommandation AS email_recommandation_36, t23.other_phd AS other_phd_37, t23.other_institution AS other_institution_38, t23.annee_inscription AS annee_inscription_39, t23.institution AS institution_40, t23.other_annee AS other_annee_41, t23.cv_path AS cv_path_42, t23.is_update AS is_update_43, t23.deactivated_at AS deactivated_at_44, t23.encadrant_id AS encadrant_id_45, t23.user_id AS user_id_46, t23.domaine_id AS domaine_id_47, t23.unite_recherche_id AS unite_recherche_id_48, t23.deactivated_by_id AS deactivated_by_id_49 FROM user t0 LEFT JOIN professeur t13 ON t13.user_id = t0.id LEFT JOIN doctorant t23 ON t23.user_id = t0.id WHERE t0.id = ?
Parameters:
[
83
]
|
|
0.75 ms (23.25%) |
5 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.titre AS titre_4, t0.lieu AS lieu_5, t0.created_at AS created_at_6, t0.slug AS slug_7, t0.status AS status_8, t0.affiche AS affiche_9, t0.resume AS resume_10, t0.heure AS heure_11, t0.domaine_id AS domaine_id_12, t0.unite_recherche_id AS unite_recherche_id_13, t0.created_by_id AS created_by_id_14, t15.id AS id_16, t15.status AS status_17, t15.created_at AS created_at_18, t15.updated_at AS updated_at_19, t15.year AS year_20, t15.is_update AS is_update_21, t15.avis_prof AS avis_prof_22, t15.doctotant_id AS doctotant_id_23, t15.soutenance_id AS soutenance_id_24, t0.depot_dossier_id AS depot_dossier_id_25 FROM soutenance t0 LEFT JOIN depot_dossier t15 ON t15.soutenance_id = t0.id WHERE t0.domaine_id = ?
Parameters:
[
16
]
|
|
0.54 ms (16.64%) |
5 |
SELECT t0.id AS id_1, t0.grade AS grade_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.origin_institute AS origin_institute_5, t0.is_intern AS is_intern_6, t0.correspond_email AS correspond_email_7, t0.departement_id AS departement_id_8, t0.user_id AS user_id_9 FROM professeur t0 WHERE t0.id = ?
Parameters:
[
17
]
|
|
0.47 ms (14.72%) |
5 |
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.domaine_id = ?
Parameters:
[
16
]
|
|
0.39 ms (11.93%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.abbreviation AS abbreviation_2, d0_.status AS status_3, d0_.info_message AS info_message_4, d0_.photo AS photo_5, d0_.coordinateur_saisie AS coordinateur_saisie_6, d0_.coordinator_id AS coordinator_id_7 FROM domaine d0_ WHERE d0_.status <> 9 ORDER BY d0_.id 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\Domaine | No errors. |
| App\Entity\Professeur | No errors. |
| App\Entity\UniteRecherche |
|
| App\Entity\Soutenance |
|
| App\Entity\User | No errors. |
| App\Entity\DepotDossier | No errors. |
| App\Entity\Doctorant |
|
| App\Entity\MembresJury | No errors. |
| App\Entity\ExternThese | No errors. |
| App\Entity\ComiteThese | No errors. |
| App\Entity\InternThese | No errors. |
| App\Entity\InscriptionDoctorant | No errors. |
| 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\Departement | No errors. |
| App\Entity\ActivityReport | No errors. |
| App\Entity\Conference | No errors. |
| App\Entity\Revues | No errors. |
| App\Entity\Ouvrage | No errors. |
| App\Entity\CoursM | No errors. |
| App\Entity\Stage | No errors. |
| App\Entity\Tfe | No errors. |
| App\Entity\AutreActivities | No errors. |
| App\Entity\ProjetRecherche | No errors. |
| App\Entity\Manifestations | No errors. |
| App\Entity\Formation | No errors. |
| App\Entity\Mission | No errors. |
| App\Entity\Expertise | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Brevet | No errors. |
| App\Entity\Calendar | No errors. |
| App\Entity\Entretient | No errors. |
| App\Entity\HistoriqueDoctorantEncadrants | No errors. |
| App\Entity\Evenements | No errors. |
| App\Entity\ReinscriptionDoctorant |
|