Query Metrics
12
Database Queries
8
Different statements
6.17 ms
Query time
0
Invalid entities
42
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.32 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_active AS is_active_7, t0.permissions AS permissions_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_verified AS is_verified_11, t0.region_id AS region_id_12, t0.entity_id AS entity_id_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
103
]
|
||||||||||||||||||||||||||||||||||
| 2 | 0.56 ms |
SELECT t0.id AS id_1, t0.session_hash AS session_hash_2, t0.statut AS statut_3, t0.created_at AS created_at_4, t0.last_activity_at AS last_activity_at_5, t0.closed_at AS closed_at_6, t0.ip AS ip_7, t0.user_agent AS user_agent_8, t0.user_id AS user_id_9, t0.closed_by_id AS closed_by_id_10 FROM user_session t0 WHERE t0.session_hash = ? LIMIT 1
Parameters:
[
"679094d6f8eb43b1d18a04222015ec9d95c2fe92518f1b6d6f4917803166cc41"
]
|
||||||||||||||||||||||||||||||||||
| 3 | 0.24 ms |
SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.modifie_le AS modifie_le_4, t0.modifie_par_id AS modifie_par_id_5 FROM parametre t0
Parameters:
[] |
||||||||||||||||||||||||||||||||||
| 4 | 0.61 ms |
UPDATE user_session SET last_activity_at = ? WHERE id = ?
Parameters:
[ "2026-11-09 13:33:24" 439 ] |
||||||||||||||||||||||||||||||||||
| 5 | 0.28 ms |
SELECT r0_.role AS role_0, r0_.menu_cle AS menu_cle_1 FROM role_menu r0_
Parameters:
[] |
||||||||||||||||||||||||||||||||||
| 6 | 0.44 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.statut AS statut_4, t0.im AS im_5, t0.cin AS cin_6, t0.date_naissance AS date_naissance_7, t0.lieu_delivrance AS lieu_delivrance_8, t0.infos AS infos_9, t0.corps AS corps_10, t0.num_decision AS num_decision_11, t0.ref_dossier AS ref_dossier_12, t0.date_reception_dossier AS date_reception_dossier_13, t0.lieu_naissance AS lieu_naissance_14, t0.date_cin AS date_cin_15, t0.sexe AS sexe_16, t0.situation_matrimoniale AS situation_matrimoniale_17, t0.poste AS poste_18, t0.categorie_emploi AS categorie_emploi_19, t0.categorie AS categorie_20, t0.date_diplome AS date_diplome_21, t0.ecole_universite AS ecole_universite_22, t0.date_equivalence AS date_equivalence_23, t0.numero_casier AS numero_casier_24, t0.date_casier AS date_casier_25, t0.adresse AS adresse_26, t0.email AS email_27, t0.telephone AS telephone_28, t0.grade AS grade_29, t0.date_entree AS date_entree_30, t0.anciennete AS anciennete_31, t0.type_matiere AS type_matiere_32, t0.volume_horaire AS volume_horaire_33, t0.competences AS competences_34, t0.matieres AS matieres_35, t0.experience AS experience_36, t0.proximite AS proximite_37, t0.fichier_name AS fichier_name_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.note_anciennete AS note_anciennete_41, t0.note_specialite AS note_specialite_42, t0.note_volume_horaire AS note_volume_horaire_43, t0.note_diplome AS note_diplome_44, t0.note_age AS note_age_45, t0.note_experience AS note_experience_46, t0.note_proximite AS note_proximite_47, t0.note_total AS note_total_48, t0.is_recrute AS is_recrute_49, t0.statut_recrutement AS statut_recrutement_50, t0.indice AS indice_51, t0.recrute_le AS recrute_le_52, t0.rang AS rang_53, t0.region_id AS region_id_54, t0.etablissement_id AS etablissement_id_55, t0.diplome_id AS diplome_id_56, t0.specialite_id AS specialite_id_57, t0.secteur_id AS secteur_id_58, t0.region_residence_id AS region_residence_id_59, t0.district_id AS district_id_60, t0.commune_id AS commune_id_61, t0.fokontany_id AS fokontany_id_62, t0.recrutement_id AS recrutement_id_63, t0.created_by_id AS created_by_id_64, t0.updated_by_id AS updated_by_id_65, t0.import_execution_id AS import_execution_id_66 FROM personne t0 WHERE t0.id = ?
Parameters:
[
"9566"
]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.47 ms |
SELECT e0_.id AS id_0, e0_.annee AS annee_1, e0_.jour AS jour_2, e0_.heure_debut AS heure_debut_3, e0_.heure_fin AS heure_fin_4, e0_.module AS module_5, e0_.groupe AS groupe_6, e0_.salle AS salle_7, e0_.observation AS observation_8, e0_.created_at AS created_at_9, e0_.personne_id AS personne_id_10, e0_.created_by_id AS created_by_id_11 FROM emploi_du_temps e0_ WHERE e0_.personne_id = ? AND e0_.annee = ?
Parameters:
[ 9566 2026 ]
|
||||||||||||||||||||||||||||||||||
| 8 | 0.70 ms |
SELECT e0_.id AS id_0, e0_.annee AS annee_1, e0_.jour AS jour_2, e0_.heure_debut AS heure_debut_3, e0_.heure_fin AS heure_fin_4, e0_.module AS module_5, e0_.groupe AS groupe_6, e0_.salle AS salle_7, e0_.observation AS observation_8, e0_.created_at AS created_at_9, e0_.personne_id AS personne_id_10, e0_.created_by_id AS created_by_id_11 FROM emploi_du_temps e0_ INNER JOIN personne p1_ ON e0_.personne_id = p1_.id WHERE p1_.etablissement_id = ? AND e0_.annee = ? AND e0_.jour = ? AND p1_.id <> ?
Parameters:
[ 55 2026 "lundi" 9566 ]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.69 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.statut AS statut_4, t0.im AS im_5, t0.cin AS cin_6, t0.date_naissance AS date_naissance_7, t0.lieu_delivrance AS lieu_delivrance_8, t0.infos AS infos_9, t0.corps AS corps_10, t0.num_decision AS num_decision_11, t0.ref_dossier AS ref_dossier_12, t0.date_reception_dossier AS date_reception_dossier_13, t0.lieu_naissance AS lieu_naissance_14, t0.date_cin AS date_cin_15, t0.sexe AS sexe_16, t0.situation_matrimoniale AS situation_matrimoniale_17, t0.poste AS poste_18, t0.categorie_emploi AS categorie_emploi_19, t0.categorie AS categorie_20, t0.date_diplome AS date_diplome_21, t0.ecole_universite AS ecole_universite_22, t0.date_equivalence AS date_equivalence_23, t0.numero_casier AS numero_casier_24, t0.date_casier AS date_casier_25, t0.adresse AS adresse_26, t0.email AS email_27, t0.telephone AS telephone_28, t0.grade AS grade_29, t0.date_entree AS date_entree_30, t0.anciennete AS anciennete_31, t0.type_matiere AS type_matiere_32, t0.volume_horaire AS volume_horaire_33, t0.competences AS competences_34, t0.matieres AS matieres_35, t0.experience AS experience_36, t0.proximite AS proximite_37, t0.fichier_name AS fichier_name_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.note_anciennete AS note_anciennete_41, t0.note_specialite AS note_specialite_42, t0.note_volume_horaire AS note_volume_horaire_43, t0.note_diplome AS note_diplome_44, t0.note_age AS note_age_45, t0.note_experience AS note_experience_46, t0.note_proximite AS note_proximite_47, t0.note_total AS note_total_48, t0.is_recrute AS is_recrute_49, t0.statut_recrutement AS statut_recrutement_50, t0.indice AS indice_51, t0.recrute_le AS recrute_le_52, t0.rang AS rang_53, t0.region_id AS region_id_54, t0.etablissement_id AS etablissement_id_55, t0.diplome_id AS diplome_id_56, t0.specialite_id AS specialite_id_57, t0.secteur_id AS secteur_id_58, t0.region_residence_id AS region_residence_id_59, t0.district_id AS district_id_60, t0.commune_id AS commune_id_61, t0.fokontany_id AS fokontany_id_62, t0.recrutement_id AS recrutement_id_63, t0.created_by_id AS created_by_id_64, t0.updated_by_id AS updated_by_id_65, t0.import_execution_id AS import_execution_id_66 FROM personne t0 WHERE t0.id = ?
Parameters:
[
150
]
|
||||||||||||||||||||||||||||||||||
| 10 | 0.61 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.statut AS statut_4, t0.im AS im_5, t0.cin AS cin_6, t0.date_naissance AS date_naissance_7, t0.lieu_delivrance AS lieu_delivrance_8, t0.infos AS infos_9, t0.corps AS corps_10, t0.num_decision AS num_decision_11, t0.ref_dossier AS ref_dossier_12, t0.date_reception_dossier AS date_reception_dossier_13, t0.lieu_naissance AS lieu_naissance_14, t0.date_cin AS date_cin_15, t0.sexe AS sexe_16, t0.situation_matrimoniale AS situation_matrimoniale_17, t0.poste AS poste_18, t0.categorie_emploi AS categorie_emploi_19, t0.categorie AS categorie_20, t0.date_diplome AS date_diplome_21, t0.ecole_universite AS ecole_universite_22, t0.date_equivalence AS date_equivalence_23, t0.numero_casier AS numero_casier_24, t0.date_casier AS date_casier_25, t0.adresse AS adresse_26, t0.email AS email_27, t0.telephone AS telephone_28, t0.grade AS grade_29, t0.date_entree AS date_entree_30, t0.anciennete AS anciennete_31, t0.type_matiere AS type_matiere_32, t0.volume_horaire AS volume_horaire_33, t0.competences AS competences_34, t0.matieres AS matieres_35, t0.experience AS experience_36, t0.proximite AS proximite_37, t0.fichier_name AS fichier_name_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.note_anciennete AS note_anciennete_41, t0.note_specialite AS note_specialite_42, t0.note_volume_horaire AS note_volume_horaire_43, t0.note_diplome AS note_diplome_44, t0.note_age AS note_age_45, t0.note_experience AS note_experience_46, t0.note_proximite AS note_proximite_47, t0.note_total AS note_total_48, t0.is_recrute AS is_recrute_49, t0.statut_recrutement AS statut_recrutement_50, t0.indice AS indice_51, t0.recrute_le AS recrute_le_52, t0.rang AS rang_53, t0.region_id AS region_id_54, t0.etablissement_id AS etablissement_id_55, t0.diplome_id AS diplome_id_56, t0.specialite_id AS specialite_id_57, t0.secteur_id AS secteur_id_58, t0.region_residence_id AS region_residence_id_59, t0.district_id AS district_id_60, t0.commune_id AS commune_id_61, t0.fokontany_id AS fokontany_id_62, t0.recrutement_id AS recrutement_id_63, t0.created_by_id AS created_by_id_64, t0.updated_by_id AS updated_by_id_65, t0.import_execution_id AS import_execution_id_66 FROM personne t0 WHERE t0.id = ?
Parameters:
[
9516
]
|
||||||||||||||||||||||||||||||||||
| 11 | 0.65 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.statut AS statut_4, t0.im AS im_5, t0.cin AS cin_6, t0.date_naissance AS date_naissance_7, t0.lieu_delivrance AS lieu_delivrance_8, t0.infos AS infos_9, t0.corps AS corps_10, t0.num_decision AS num_decision_11, t0.ref_dossier AS ref_dossier_12, t0.date_reception_dossier AS date_reception_dossier_13, t0.lieu_naissance AS lieu_naissance_14, t0.date_cin AS date_cin_15, t0.sexe AS sexe_16, t0.situation_matrimoniale AS situation_matrimoniale_17, t0.poste AS poste_18, t0.categorie_emploi AS categorie_emploi_19, t0.categorie AS categorie_20, t0.date_diplome AS date_diplome_21, t0.ecole_universite AS ecole_universite_22, t0.date_equivalence AS date_equivalence_23, t0.numero_casier AS numero_casier_24, t0.date_casier AS date_casier_25, t0.adresse AS adresse_26, t0.email AS email_27, t0.telephone AS telephone_28, t0.grade AS grade_29, t0.date_entree AS date_entree_30, t0.anciennete AS anciennete_31, t0.type_matiere AS type_matiere_32, t0.volume_horaire AS volume_horaire_33, t0.competences AS competences_34, t0.matieres AS matieres_35, t0.experience AS experience_36, t0.proximite AS proximite_37, t0.fichier_name AS fichier_name_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.note_anciennete AS note_anciennete_41, t0.note_specialite AS note_specialite_42, t0.note_volume_horaire AS note_volume_horaire_43, t0.note_diplome AS note_diplome_44, t0.note_age AS note_age_45, t0.note_experience AS note_experience_46, t0.note_proximite AS note_proximite_47, t0.note_total AS note_total_48, t0.is_recrute AS is_recrute_49, t0.statut_recrutement AS statut_recrutement_50, t0.indice AS indice_51, t0.recrute_le AS recrute_le_52, t0.rang AS rang_53, t0.region_id AS region_id_54, t0.etablissement_id AS etablissement_id_55, t0.diplome_id AS diplome_id_56, t0.specialite_id AS specialite_id_57, t0.secteur_id AS secteur_id_58, t0.region_residence_id AS region_residence_id_59, t0.district_id AS district_id_60, t0.commune_id AS commune_id_61, t0.fokontany_id AS fokontany_id_62, t0.recrutement_id AS recrutement_id_63, t0.created_by_id AS created_by_id_64, t0.updated_by_id AS updated_by_id_65, t0.import_execution_id AS import_execution_id_66 FROM personne t0 WHERE t0.id = ?
Parameters:
[
9565
]
|
||||||||||||||||||||||||||||||||||
| 12 | 0.62 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.statut AS statut_4, t0.im AS im_5, t0.cin AS cin_6, t0.date_naissance AS date_naissance_7, t0.lieu_delivrance AS lieu_delivrance_8, t0.infos AS infos_9, t0.corps AS corps_10, t0.num_decision AS num_decision_11, t0.ref_dossier AS ref_dossier_12, t0.date_reception_dossier AS date_reception_dossier_13, t0.lieu_naissance AS lieu_naissance_14, t0.date_cin AS date_cin_15, t0.sexe AS sexe_16, t0.situation_matrimoniale AS situation_matrimoniale_17, t0.poste AS poste_18, t0.categorie_emploi AS categorie_emploi_19, t0.categorie AS categorie_20, t0.date_diplome AS date_diplome_21, t0.ecole_universite AS ecole_universite_22, t0.date_equivalence AS date_equivalence_23, t0.numero_casier AS numero_casier_24, t0.date_casier AS date_casier_25, t0.adresse AS adresse_26, t0.email AS email_27, t0.telephone AS telephone_28, t0.grade AS grade_29, t0.date_entree AS date_entree_30, t0.anciennete AS anciennete_31, t0.type_matiere AS type_matiere_32, t0.volume_horaire AS volume_horaire_33, t0.competences AS competences_34, t0.matieres AS matieres_35, t0.experience AS experience_36, t0.proximite AS proximite_37, t0.fichier_name AS fichier_name_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.note_anciennete AS note_anciennete_41, t0.note_specialite AS note_specialite_42, t0.note_volume_horaire AS note_volume_horaire_43, t0.note_diplome AS note_diplome_44, t0.note_age AS note_age_45, t0.note_experience AS note_experience_46, t0.note_proximite AS note_proximite_47, t0.note_total AS note_total_48, t0.is_recrute AS is_recrute_49, t0.statut_recrutement AS statut_recrutement_50, t0.indice AS indice_51, t0.recrute_le AS recrute_le_52, t0.rang AS rang_53, t0.region_id AS region_id_54, t0.etablissement_id AS etablissement_id_55, t0.diplome_id AS diplome_id_56, t0.specialite_id AS specialite_id_57, t0.secteur_id AS secteur_id_58, t0.region_residence_id AS region_residence_id_59, t0.district_id AS district_id_60, t0.commune_id AS commune_id_61, t0.fokontany_id AS fokontany_id_62, t0.recrutement_id AS recrutement_id_63, t0.created_by_id AS created_by_id_64, t0.updated_by_id AS updated_by_id_65, t0.import_execution_id AS import_execution_id_66 FROM personne t0 WHERE t0.id = ?
Parameters:
[
9569
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\CreneauEmploiDuTemps | 15 |
| App\Entity\Personne | 8 |
| App\Entity\Diplome | 4 |
| App\Entity\Secteur | 3 |
| App\Entity\Fokontany | 3 |
| App\Entity\PosteBudgetaire | 2 |
| App\Entity\User | 1 |
| App\Entity\StructureAdministrative | 1 |
| App\Entity\UserSession | 1 |
| App\Entity\Etablissement | 1 |
| App\Entity\Region | 1 |
| App\Entity\District | 1 |
| App\Entity\Commune | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\StructureAdministrative | No errors. |
| App\Entity\Etablissement | No errors. |
| App\Entity\UserSession | No errors. |
| App\Entity\Parametre | No errors. |
| App\Entity\RoleMenu | No errors. |
| App\Entity\Personne | No errors. |
| App\Entity\Diplome | No errors. |
| App\Entity\Specialite | No errors. |
| App\Entity\Secteur | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\District | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\Fokontany | No errors. |
| App\Entity\PosteBudgetaire | No errors. |
| App\Entity\ImportExecution | No errors. |
| App\Entity\CreneauEmploiDuTemps | No errors. |