Query Metrics
181
Database Queries
4
Different statements
30.98 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
28.65 ms (92.49%) |
174 |
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:
[
65
]
|
|
1.07 ms (3.45%) |
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 FROM soutenance t0 WHERE t0.domaine_id = ?
Parameters:
[
1
]
|
|
0.78 ms (2.52%) |
1 |
SELECT p0_.id AS id_0, p0_.grade AS grade_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.origin_institute AS origin_institute_4, p0_.is_intern AS is_intern_5, p0_.correspond_email AS correspond_email_6, p0_.departement_id AS departement_id_7, p0_.user_id AS user_id_8 FROM professeur p0_ INNER JOIN user u1_ ON p0_.user_id = u1_.id WHERE u1_.status <> 3
Parameters:
[] |
|
0.48 ms (1.55%) |
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_
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\UniteRecherche |
|
| App\Entity\Professeur | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\Soutenance |
|
| 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\Doctorant |
|
| 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 |
|