Symfony Profiler

Query Metrics

15 Database Queries

5 Different statements

3.78 ms Query time

4 Invalid entities

Queries


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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?

#▲	Time	Info
1	0.52 ms	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: [`"16"`] View formatted query View runnable query Explain query 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 = ? 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 = '16';
2	0.23 ms	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: [`20`] View formatted query View runnable query Explain query 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 = ? 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 = 20;
3	0.25 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`] View formatted query View runnable query Explain query 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 = ? 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 = 17;
4	0.44 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`] View formatted query View runnable query Explain query 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 = ? 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 = 83;
5	0.25 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`] View formatted query View runnable query Explain query 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 = ? 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 = 16;
6	0.18 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: [`84`] View formatted query View runnable query Explain query 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 = ? 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 = 84;
7	0.28 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: [`159`] View formatted query View runnable query Explain query 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 = ? 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 = 159;
8	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: [`8`] View formatted query View runnable query Explain query 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 = ? 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 = 8;
9	0.25 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: [`72`] View formatted query View runnable query Explain query 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 = ? 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 = 72;
10	0.17 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: [`7`] View formatted query View runnable query Explain query 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 = ? 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 = 7;
11	0.25 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: [`71`] View formatted query View runnable query Explain query 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 = ? 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 = 71;
12	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: [`146`] View formatted query View runnable query Explain query 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 = ? 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 = 146;
13	0.26 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: [`397`] View formatted query View runnable query Explain query 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 = ? 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 = 397;
14	0.16 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: [`89`] View formatted query View runnable query Explain query 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 = ? 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 = 89;
15	0.23 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: [`166`] View formatted query View runnable query Explain query 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 = ? 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 = 166;

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\Soutenance	If association App\Entity\Soutenance#domaine is many-to-one, then the inversed side App\Entity\Domaine#soutenance has to be one-to-many.
App\Entity\UniteRecherche	The association App\Entity\UniteRecherche#Coordinateur refers to the inverse side field App\Entity\Professeur#uniteRecherches which does not exist.
App\Entity\User	No errors.
App\Entity\DepotDossier	No errors.
App\Entity\ExternThese	No errors.
App\Entity\ComiteThese	No errors.
App\Entity\InternThese	No errors.
App\Entity\InscriptionDoctorant	No errors.
App\Entity\MembresJury	No errors.
App\Entity\Doctorant	The mappings App\Entity\Doctorant#rapporteurs and App\Entity\Rapporteurs#doctorant are inconsistent with each other.
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	The mappings App\Entity\ReinscriptionDoctorant#revuesDoctorants and App\Entity\RevuesDoctorant#reinscriptionDoctorant are inconsistent with each other.

Symfony Profiler

GET https://dev.drsfd.ma/unitesRecherches_details/16

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping