Query Metrics
21
Database Queries
5
Different statements
5.78 ms
Query time
4
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.79 ms |
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:
[] |
| 2 | 0.54 ms |
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:
[
16
]
|
| 3 | 0.26 ms |
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:
[
14
]
|
| 4 | 0.18 ms |
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:
[
13
]
|
| 5 | 0.17 ms |
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:
[
2
]
|
| 6 | 0.20 ms |
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
]
|
| 7 | 0.38 ms |
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
]
|
| 8 | 0.83 ms |
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
]
|
| 9 | 0.45 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.domaine_id = ?
Parameters:
[
16
]
|
| 10 | 0.15 ms |
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:
[
88
]
|
| 11 | 0.21 ms |
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:
[
163
]
|
| 12 | 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.domaine_id = ?
Parameters:
[
14
]
|
| 13 | 0.14 ms |
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:
[
121
]
|
| 14 | 0.20 ms |
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:
[
259
]
|
| 15 | 0.15 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.domaine_id = ?
Parameters:
[
13
]
|
| 16 | 0.14 ms |
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:
[
69
]
|
| 17 | 0.19 ms |
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:
[
144
]
|
| 18 | 0.15 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.domaine_id = ?
Parameters:
[
2
]
|
| 19 | 0.14 ms |
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:
[
24
]
|
| 20 | 0.19 ms |
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:
[
91
]
|
| 21 | 0.15 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.domaine_id = ?
Parameters:
[
1
]
|
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\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\Departement | 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 |
|