Query Metrics
34
Database Queries
6
Different statements
17.44 ms
Query time
4
Invalid entities
89
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.49 ms (31.48%) |
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
]
|
|
3.65 ms (20.94%) |
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
]
|
|
3.08 ms (17.67%) |
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.10 ms (12.06%) |
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.83 ms (10.49%) |
1 |
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.28 ms (7.36%) |
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 ] |
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 | 10 |
| App\Entity\User | 7 |
| App\Entity\PosteSante | 7 |
| App\Entity\Activite | 6 |
| App\Entity\ActiviteCalendrier | 6 |
| App\Entity\Groupe | 3 |
| App\Entity\TypeDialogue | 2 |
| App\Entity\DistrictSanitaire | 2 |
| App\Entity\Intervention | 2 |
| App\Entity\Structure | 1 |
| 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\PermissionCategory | No errors. |
| App\Entity\Permission | No errors. |
| App\Entity\ActiviteLigne | No errors. |
| App\Entity\Intervention | No errors. |
| App\Entity\PosteSante | No errors. |
| App\Entity\TypeDialogue | No errors. |
| App\Entity\Groupe | No errors. |
| App\Entity\DistrictSanitaire | No errors. |
| App\Entity\RefNiveau | No errors. |
| App\Entity\TypeActivite |
|
| App\Entity\LigneDocument | No errors. |
| App\Entity\HistoriqueValidation | No errors. |
| 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. |