Query Metrics
50
Database Queries
12
Different statements
21.86 ms
Query time
4
Invalid entities
111
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.15 ms (23.54%) |
23 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.icon AS icon_5, t0.display_order AS display_order_6, t0.is_menu_node AS is_menu_node_7, t0.menu_route AS menu_route_8, t0.display_in_navbar AS display_in_navbar_9, t0.display_in_sidebar AS display_in_sidebar_10, t0.menu_level AS menu_level_11, t0.menu_color AS menu_color_12, t0.parent_id AS parent_id_13 FROM permission_category t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters:
[
33
]
|
|
2.70 ms (12.36%) |
1 |
SELECT COUNT(l0_.id) AS sclr_0 FROM ligne_activite l0_ LEFT JOIN activite a1_ ON l0_.activite_id = a1_.id LEFT JOIN intervention i2_ ON a1_.intervention_id = i2_.id WHERE l0_.date_planifier IS NOT NULL AND l0_.date_seance IS NOT NULL AND l0_.date_planifier <> l0_.date_seance AND (l0_.commentaire IS NULL OR l0_.commentaire = ?) AND i2_.annee = ?
Parameters:
[
""
2026
]
|
|
2.45 ms (11.19%) |
1 |
SELECT l0_.id AS id_0, l0_.date_seance AS date_seance_1, l0_.titre AS titre_2, l0_.lieu AS lieu_3, l0_.equipe_facilitation AS equipe_facilitation_4, l0_.facilitateur1 AS facilitateur1_5, l0_.facilitateur2 AS facilitateur2_6, l0_.facilitateur3 AS facilitateur3_7, l0_.total_participants AS total_participants_8, l0_.age_moins15 AS age_moins15_9, l0_.age15a24 AS age15a24_10, l0_.age25a34 AS age25a34_11, l0_.age35a49 AS age35a49_12, l0_.age50_plus AS age50_plus_13, l0_.alphabetises AS alphabetises_14, l0_.non_alphabetises AS non_alphabetises_15, l0_.membres_association AS membres_association_16, l0_.activite1_libelle AS activite1_libelle_17, l0_.activite1_realise AS activite1_realise_18, l0_.activite2_libelle AS activite2_libelle_19, l0_.activite2_realise AS activite2_realise_20, l0_.activite3_libelle AS activite3_libelle_21, l0_.activite3_realise AS activite3_realise_22, l0_.activite4_libelle AS activite4_libelle_23, l0_.activite4_realise AS activite4_realise_24, l0_.activite5_libelle AS activite5_libelle_25, l0_.activite5_realise AS activite5_realise_26, l0_.activite6_libelle AS activite6_libelle_27, l0_.activite6_realise AS activite6_realise_28, l0_.activite7_libelle AS activite7_libelle_29, l0_.activite7_realise AS activite7_realise_30, l0_.gripp_aff1_rouge AS gripp_aff1_rouge_31, l0_.gripp_aff1_jaune AS gripp_aff1_jaune_32, l0_.gripp_aff1_vert AS gripp_aff1_vert_33, l0_.gripp_aff2_rouge AS gripp_aff2_rouge_34, l0_.gripp_aff2_jaune AS gripp_aff2_jaune_35, l0_.gripp_aff2_vert AS gripp_aff2_vert_36, l0_.gripp_aff3_rouge AS gripp_aff3_rouge_37, l0_.gripp_aff3_jaune AS gripp_aff3_jaune_38, l0_.gripp_aff3_vert AS gripp_aff3_vert_39, l0_.gripp_aff4_rouge AS gripp_aff4_rouge_40, l0_.gripp_aff4_jaune AS gripp_aff4_jaune_41, l0_.gripp_aff4_vert AS gripp_aff4_vert_42, l0_.gripp_aff5_rouge AS gripp_aff5_rouge_43, l0_.gripp_aff5_jaune AS gripp_aff5_jaune_44, l0_.gripp_aff5_vert AS gripp_aff5_vert_45, l0_.gripp_aff6_rouge AS gripp_aff6_rouge_46, l0_.gripp_aff6_jaune AS gripp_aff6_jaune_47, l0_.gripp_aff6_vert AS gripp_aff6_vert_48, l0_.gripp_aff7_rouge AS gripp_aff7_rouge_49, l0_.gripp_aff7_jaune AS gripp_aff7_jaune_50, l0_.gripp_aff7_vert AS gripp_aff7_vert_51, l0_.gripp_aff8_rouge AS gripp_aff8_rouge_52, l0_.gripp_aff8_jaune AS gripp_aff8_jaune_53, l0_.gripp_aff8_vert AS gripp_aff8_vert_54, l0_.gripp_aff9_rouge AS gripp_aff9_rouge_55, l0_.gripp_aff9_jaune AS gripp_aff9_jaune_56, l0_.gripp_aff9_vert AS gripp_aff9_vert_57, l0_.gripp_aff10_rouge AS gripp_aff10_rouge_58, l0_.gripp_aff10_jaune AS gripp_aff10_jaune_59, l0_.gripp_aff10_vert AS gripp_aff10_vert_60, l0_.action1 AS action1_61, l0_.action2 AS action2_62, l0_.action3 AS action3_63, l0_.representant1_prenom AS representant1_prenom_64, l0_.representant1_nom AS representant1_nom_65, l0_.representant2_prenom AS representant2_prenom_66, l0_.representant2_nom AS representant2_nom_67, l0_.barometre_exprimer AS barometre_exprimer_68, l0_.barometre_ecoute AS barometre_ecoute_69, l0_.barometre_action_claire AS barometre_action_claire_70, l0_.observations AS observations_71, l0_.deja_participe AS deja_participe_72, l0_.documents_joints AS documents_joints_73, l0_.date_planifier AS date_planifier_74, l0_.commentaire AS commentaire_75, l0_.doc1_name AS doc1_name_76, l0_.doc1_path AS doc1_path_77, l0_.doc2_name AS doc2_name_78, l0_.doc2_path AS doc2_path_79, l0_.doc3_name AS doc3_name_80, l0_.doc3_path AS doc3_path_81, l0_.doc4_name AS doc4_name_82, l0_.doc4_path AS doc4_path_83, l0_.doc5_name AS doc5_name_84, l0_.doc5_path AS doc5_path_85, l0_.doc6_name AS doc6_name_86, l0_.doc6_path AS doc6_path_87, l0_.doc7_name AS doc7_name_88, l0_.doc7_path AS doc7_path_89, l0_.doc8_name AS doc8_name_90, l0_.doc8_path AS doc8_path_91, l0_.doc9_name AS doc9_name_92, l0_.doc9_path AS doc9_path_93, l0_.doc10_name AS doc10_name_94, l0_.doc10_path AS doc10_path_95, l0_.date_creation AS date_creation_96, l0_.date_modification AS date_modification_97, l0_.is_sync AS is_sync_98, l0_.synced_planif AS synced_planif_99, l0_.synced_full AS synced_full_100, l0_.nbr_femme AS nbr_femme_101, l0_.nbr_homme AS nbr_homme_102, l0_.statut_validation AS statut_validation_103, l0_.commentaire_validation AS commentaire_validation_104, l0_.date_validation AS date_validation_105, l0_.deleted_at AS deleted_at_106, a1_.id AS id_107, a1_.numero AS numero_108, a1_.annee AS annee_109, a1_.titre AS titre_110, a1_.description AS description_111, a1_.cible_quantitative AS cible_quantitative_112, a1_.compteur_realise AS compteur_realise_113, a1_.date_debut_prevue AS date_debut_prevue_114, a1_.date_fin_prevue AS date_fin_prevue_115, a1_.assignation_acteur_ids AS assignation_acteur_ids_116, a1_.statut AS statut_117, a1_.priorite AS priorite_118, a1_.localisation AS localisation_119, a1_.coordonnees_gps AS coordonnees_gps_120, a1_.resultat AS resultat_121, a1_.partenaires AS partenaires_122, a1_.target AS target_123, a1_.indicateur AS indicateur_124, a1_.created_at AS created_at_125, a1_.updated_at AS updated_at_126, i2_.id AS id_127, i2_.annee AS annee_128, i2_.numero AS numero_129, i2_.libelle AS libelle_130, i2_.description_detaillee AS description_detaillee_131, i2_.objectif_principal AS objectif_principal_132, i2_.niveau_intervention AS niveau_intervention_133, i2_.date_debut AS date_debut_134, i2_.date_fin AS date_fin_135, i2_.statut AS statut_136, i2_.created_at AS created_at_137, i2_.updated_at AS updated_at_138, l0_.poste_sante_id AS poste_sante_id_139, l0_.type_dialogue_id AS type_dialogue_id_140, l0_.groupe_id AS groupe_id_141, l0_.district_sanitaire_id AS district_sanitaire_id_142, l0_.activite_id AS activite_id_143, l0_.cree_par_id AS cree_par_id_144, l0_.valide_par_id AS valide_par_id_145, a1_.intervention_id AS intervention_id_146, a1_.niveau_id AS niveau_id_147, a1_.type_activite_id AS type_activite_id_148, a1_.cree_par_id AS cree_par_id_149, a1_.structure_responsable_id AS structure_responsable_id_150, a1_.activite_parente_id AS activite_parente_id_151, i2_.type_activite_id AS type_activite_id_152, i2_.responsable_id AS responsable_id_153 FROM ligne_activite l0_ LEFT JOIN activite a1_ ON l0_.activite_id = a1_.id LEFT JOIN intervention i2_ ON a1_.intervention_id = i2_.id WHERE l0_.date_planifier IS NOT NULL AND l0_.date_seance IS NOT NULL AND l0_.date_planifier <> l0_.date_seance AND (l0_.commentaire IS NULL OR l0_.commentaire = ?) AND i2_.annee = ? ORDER BY l0_.date_seance DESC LIMIT 10
Parameters:
[
""
2026
]
|
|
2.19 ms (10.03%) |
10 |
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.updated_at AS updated_at_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
"019f698d-722a-70a0-bb7a-612c4feba0f8"
]
|
|
2.09 ms (9.56%) |
2 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.position AS position_6, t0.avatar AS avatar_7, t0.is_enabled AS is_enabled_8, t0.acces_donnees AS acces_donnees_9, t0.derniere_connexion AS derniere_connexion_10, t0.tentatives_connexion AS tentatives_connexion_11, t0.compte_verrouille AS compte_verrouille_12, t0.preferences_interface AS preferences_interface_13, t0.structure_id AS structure_id_14 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
16
]
|
|
1.98 ms (9.08%) |
1 |
SELECT t0.id AS id_1, t0.date_seance AS date_seance_2, t0.titre AS titre_3, t0.lieu AS lieu_4, t0.equipe_facilitation AS equipe_facilitation_5, t0.facilitateur1 AS facilitateur1_6, t0.facilitateur2 AS facilitateur2_7, t0.facilitateur3 AS facilitateur3_8, t0.total_participants AS total_participants_9, t0.age_moins15 AS age_moins15_10, t0.age15a24 AS age15a24_11, t0.age25a34 AS age25a34_12, t0.age35a49 AS age35a49_13, t0.age50_plus AS age50_plus_14, t0.alphabetises AS alphabetises_15, t0.non_alphabetises AS non_alphabetises_16, t0.membres_association AS membres_association_17, t0.activite1_libelle AS activite1_libelle_18, t0.activite1_realise AS activite1_realise_19, t0.activite2_libelle AS activite2_libelle_20, t0.activite2_realise AS activite2_realise_21, t0.activite3_libelle AS activite3_libelle_22, t0.activite3_realise AS activite3_realise_23, t0.activite4_libelle AS activite4_libelle_24, t0.activite4_realise AS activite4_realise_25, t0.activite5_libelle AS activite5_libelle_26, t0.activite5_realise AS activite5_realise_27, t0.activite6_libelle AS activite6_libelle_28, t0.activite6_realise AS activite6_realise_29, t0.activite7_libelle AS activite7_libelle_30, t0.activite7_realise AS activite7_realise_31, t0.gripp_aff1_rouge AS gripp_aff1_rouge_32, t0.gripp_aff1_jaune AS gripp_aff1_jaune_33, t0.gripp_aff1_vert AS gripp_aff1_vert_34, t0.gripp_aff2_rouge AS gripp_aff2_rouge_35, t0.gripp_aff2_jaune AS gripp_aff2_jaune_36, t0.gripp_aff2_vert AS gripp_aff2_vert_37, t0.gripp_aff3_rouge AS gripp_aff3_rouge_38, t0.gripp_aff3_jaune AS gripp_aff3_jaune_39, t0.gripp_aff3_vert AS gripp_aff3_vert_40, t0.gripp_aff4_rouge AS gripp_aff4_rouge_41, t0.gripp_aff4_jaune AS gripp_aff4_jaune_42, t0.gripp_aff4_vert AS gripp_aff4_vert_43, t0.gripp_aff5_rouge AS gripp_aff5_rouge_44, t0.gripp_aff5_jaune AS gripp_aff5_jaune_45, t0.gripp_aff5_vert AS gripp_aff5_vert_46, t0.gripp_aff6_rouge AS gripp_aff6_rouge_47, t0.gripp_aff6_jaune AS gripp_aff6_jaune_48, t0.gripp_aff6_vert AS gripp_aff6_vert_49, t0.gripp_aff7_rouge AS gripp_aff7_rouge_50, t0.gripp_aff7_jaune AS gripp_aff7_jaune_51, t0.gripp_aff7_vert AS gripp_aff7_vert_52, t0.gripp_aff8_rouge AS gripp_aff8_rouge_53, t0.gripp_aff8_jaune AS gripp_aff8_jaune_54, t0.gripp_aff8_vert AS gripp_aff8_vert_55, t0.gripp_aff9_rouge AS gripp_aff9_rouge_56, t0.gripp_aff9_jaune AS gripp_aff9_jaune_57, t0.gripp_aff9_vert AS gripp_aff9_vert_58, t0.gripp_aff10_rouge AS gripp_aff10_rouge_59, t0.gripp_aff10_jaune AS gripp_aff10_jaune_60, t0.gripp_aff10_vert AS gripp_aff10_vert_61, t0.action1 AS action1_62, t0.action2 AS action2_63, t0.action3 AS action3_64, t0.representant1_prenom AS representant1_prenom_65, t0.representant1_nom AS representant1_nom_66, t0.representant2_prenom AS representant2_prenom_67, t0.representant2_nom AS representant2_nom_68, t0.barometre_exprimer AS barometre_exprimer_69, t0.barometre_ecoute AS barometre_ecoute_70, t0.barometre_action_claire AS barometre_action_claire_71, t0.observations AS observations_72, t0.deja_participe AS deja_participe_73, t0.documents_joints AS documents_joints_74, t0.date_planifier AS date_planifier_75, t0.commentaire AS commentaire_76, t0.doc1_name AS doc1_name_77, t0.doc1_path AS doc1_path_78, t0.doc2_name AS doc2_name_79, t0.doc2_path AS doc2_path_80, t0.doc3_name AS doc3_name_81, t0.doc3_path AS doc3_path_82, t0.doc4_name AS doc4_name_83, t0.doc4_path AS doc4_path_84, t0.doc5_name AS doc5_name_85, t0.doc5_path AS doc5_path_86, t0.doc6_name AS doc6_name_87, t0.doc6_path AS doc6_path_88, t0.doc7_name AS doc7_name_89, t0.doc7_path AS doc7_path_90, t0.doc8_name AS doc8_name_91, t0.doc8_path AS doc8_path_92, t0.doc9_name AS doc9_name_93, t0.doc9_path AS doc9_path_94, t0.doc10_name AS doc10_name_95, t0.doc10_path AS doc10_path_96, t0.date_creation AS date_creation_97, t0.date_modification AS date_modification_98, t0.is_sync AS is_sync_99, t0.synced_planif AS synced_planif_100, t0.synced_full AS synced_full_101, t0.nbr_femme AS nbr_femme_102, t0.nbr_homme AS nbr_homme_103, t0.statut_validation AS statut_validation_104, t0.commentaire_validation AS commentaire_validation_105, t0.date_validation AS date_validation_106, t0.deleted_at AS deleted_at_107, t0.poste_sante_id AS poste_sante_id_108, t0.type_dialogue_id AS type_dialogue_id_109, t0.groupe_id AS groupe_id_110, t0.district_sanitaire_id AS district_sanitaire_id_111, t0.activite_id AS activite_id_112, t0.cree_par_id AS cree_par_id_113, t0.valide_par_id AS valide_par_id_114 FROM ligne_activite t0 WHERE t0.id = ?
Parameters:
[
"2128"
]
|
|
1.80 ms (8.22%) |
6 |
SELECT t0.id AS id_1, t0.janvier AS janvier_2, t0.fevrier AS fevrier_3, t0.mars AS mars_4, t0.avril AS avril_5, t0.mai AS mai_6, t0.juin AS juin_7, t0.juillet AS juillet_8, t0.aout AS aout_9, t0.septembre AS septembre_10, t0.octobre AS octobre_11, t0.novembre AS novembre_12, t0.decembre AS decembre_13, t0.date_premier_mois AS date_premier_mois_14, t0.date_dernier_mois AS date_dernier_mois_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.activite_id AS activite_id_18 FROM activite_calendrier t0 WHERE t0.activite_id = ?
Parameters:
[
427
]
|
|
1.62 ms (7.40%) |
2 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.icon AS icon_5, t0.display_order AS display_order_6, t0.is_menu_node AS is_menu_node_7, t0.menu_route AS menu_route_8, t0.display_in_navbar AS display_in_navbar_9, t0.display_in_sidebar AS display_in_sidebar_10, t0.menu_level AS menu_level_11, t0.menu_color AS menu_color_12, t0.parent_id AS parent_id_13 FROM permission_category t0 WHERE t0.is_menu_node = ? AND t0.menu_level = ? AND t0.parent_id IS NULL AND t0.display_in_navbar = ? ORDER BY t0.display_order ASC
Parameters:
[ 1 0 1 ] |
|
0.97 ms (4.43%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.media_id AS media_id_3, t0.activite_ligne_id AS activite_ligne_id_4 FROM ligne_document t0 WHERE t0.activite_ligne_id = ?
Parameters:
[
2128
]
|
|
0.32 ms (1.48%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.district_sanitaire_id AS district_sanitaire_id_3 FROM poste_sante t0 WHERE t0.id = ?
Parameters:
[
9
]
|
|
0.31 ms (1.40%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM groupe t0 WHERE t0.id = ?
Parameters:
[
9
]
|
|
0.28 ms (1.30%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type_dialogue t0 WHERE t0.id = ?
Parameters:
[
5
]
|
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\PermissionCategory | 42 |
| App\Entity\ActiviteLigne | 11 |
| App\Entity\LigneDocument | 10 |
| App\Entity\MediaObject | 10 |
| App\Entity\User | 7 |
| App\Entity\PosteSante | 7 |
| App\Entity\Activite | 6 |
| App\Entity\ActiviteCalendrier | 6 |
| App\Entity\Groupe | 3 |
| App\Entity\Structure | 2 |
| App\Entity\TypeDialogue | 2 |
| App\Entity\DistrictSanitaire | 2 |
| App\Entity\Intervention | 2 |
| App\Entity\TypeActivite | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\Activite |
|
| App\Entity\Role | No errors. |
| App\Entity\ActiviteLigne | No errors. |
| App\Entity\PosteSante | No errors. |
| App\Entity\TypeDialogue | No errors. |
| App\Entity\Groupe | No errors. |
| App\Entity\DistrictSanitaire | No errors. |
| App\Entity\LigneDocument | No errors. |
| App\Entity\HistoriqueValidation | No errors. |
| App\Entity\PermissionCategory | No errors. |
| App\Entity\Permission | No errors. |
| App\Entity\Intervention | No errors. |
| App\Entity\RefNiveau | No errors. |
| App\Entity\TypeActivite |
|
| App\Entity\ActiviteReunionFormation |
|
| App\Entity\ActiviteSensibilisation |
|
| App\Entity\ActiviteSupervision | No errors. |
| App\Entity\ActiviteOutil | No errors. |
| App\Entity\ActiviteDocumentTechnique | No errors. |
| App\Entity\ActiviteSuivi | No errors. |
| App\Entity\ActiviteEnquete | No errors. |
| App\Entity\ActiviteInterviewFg | No errors. |
| App\Entity\ActiviteCartographieMenages | No errors. |
| App\Entity\ActiviteCartographiePersonnes | No errors. |
| App\Entity\ActiviteRecrutement | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\ValidationActivite | No errors. |
| App\Entity\CommentaireActivite | No errors. |
| App\Entity\PresenceActivite | No errors. |
| App\Entity\AssignationActivite | No errors. |
| App\Entity\ActiviteCalendrier | No errors. |
| App\Entity\MediaObject | No errors. |