Redirect 302 redirect from POST @app_login (153b9c)

GET http://pisa.chaiprod.com/accueil

Response
200 OK
IP
172.18.0.1
Profiled on
Token
736ffb

Query Metrics

77 Database Queries
25 Different statements
37.78 ms Query time
4 Invalid entities
162 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
5.54 ms
(14.66%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
4.63 ms
(12.25%) 		17 
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: 
[
  411
]
View formatted query    View runnable query    Explain query    View query backtrace
3.87 ms
(10.25%) 		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, l0_.poste_sante_id AS poste_sante_id_107, l0_.type_dialogue_id AS type_dialogue_id_108, l0_.groupe_id AS groupe_id_109, l0_.district_sanitaire_id AS district_sanitaire_id_110, l0_.activite_id AS activite_id_111, l0_.cree_par_id AS cree_par_id_112, l0_.valide_par_id AS valide_par_id_113 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 i2_.annee = ? ORDER BY l0_.date_creation DESC LIMIT 8
Parameters: 
[
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
2.10 ms
(5.56%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
1.95 ms
(5.15%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
1.73 ms
(4.57%) 		4 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.annee AS annee_3, t0.titre AS titre_4, t0.description AS description_5, t0.cible_quantitative AS cible_quantitative_6, t0.compteur_realise AS compteur_realise_7, t0.date_debut_prevue AS date_debut_prevue_8, t0.date_fin_prevue AS date_fin_prevue_9, t0.assignation_acteur_ids AS assignation_acteur_ids_10, t0.statut AS statut_11, t0.priorite AS priorite_12, t0.localisation AS localisation_13, t0.coordonnees_gps AS coordonnees_gps_14, t0.resultat AS resultat_15, t0.partenaires AS partenaires_16, t0.target AS target_17, t0.indicateur AS indicateur_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.intervention_id AS intervention_id_21, t0.niveau_id AS niveau_id_22, t0.type_activite_id AS type_activite_id_23, t0.cree_par_id AS cree_par_id_24, t0.structure_responsable_id AS structure_responsable_id_25, t0.activite_parente_id AS activite_parente_id_26, t27.id AS id_28, t27.janvier AS janvier_29, t27.fevrier AS fevrier_30, t27.mars AS mars_31, t27.avril AS avril_32, t27.mai AS mai_33, t27.juin AS juin_34, t27.juillet AS juillet_35, t27.aout AS aout_36, t27.septembre AS septembre_37, t27.octobre AS octobre_38, t27.novembre AS novembre_39, t27.decembre AS decembre_40, t27.date_premier_mois AS date_premier_mois_41, t27.date_dernier_mois AS date_dernier_mois_42, t27.created_at AS created_at_43, t27.updated_at AS updated_at_44, t27.activite_id AS activite_id_45 FROM activite t0 LEFT JOIN activite_calendrier t27 ON t27.activite_id = t0.id WHERE t0.id = ?
Parameters: 
[
  428
]
View formatted query    View runnable query    Explain query    View query backtrace
1.66 ms
(4.38%) 		1 
SELECT COUNT(l0_.id) AS sclr_0, SUM(CASE WHEN l0_.statut_validation IN ('soumise', 'corrigee') THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN l0_.statut_validation = 'validee' THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN l0_.statut_validation = 'rejetee' THEN 1 ELSE 0 END) AS sclr_3 FROM ligne_activite l0_ LEFT JOIN activite a1_ ON l0_.activite_id = a1_.id LEFT JOIN intervention i2_ ON a1_.intervention_id = i2_.id LEFT JOIN poste_sante p3_ ON l0_.poste_sante_id = p3_.id LEFT JOIN district_sanitaire d4_ ON p3_.district_sanitaire_id = d4_.id LEFT JOIN groupe g5_ ON l0_.groupe_id = g5_.id WHERE i2_.annee = ? AND ((l0_.synced_planif = 1 OR l0_.synced_full = 1))
Parameters: 
[
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
1.46 ms
(3.85%) 		6 
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.numero AS numero_3, t0.libelle AS libelle_4, t0.description_detaillee AS description_detaillee_5, t0.objectif_principal AS objectif_principal_6, t0.niveau_intervention AS niveau_intervention_7, t0.date_debut AS date_debut_8, t0.date_fin AS date_fin_9, t0.statut AS statut_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.type_activite_id AS type_activite_id_13, t0.responsable_id AS responsable_id_14 FROM intervention t0 WHERE t0.id = ?
Parameters: 
[
  133
]
View formatted query    View runnable query    Explain query    View query backtrace
1.38 ms
(3.64%) 		1 
SELECT a0_.id AS id_0, a0_.numero AS numero_1, a0_.annee AS annee_2, a0_.titre AS titre_3, a0_.description AS description_4, a0_.cible_quantitative AS cible_quantitative_5, a0_.compteur_realise AS compteur_realise_6, a0_.date_debut_prevue AS date_debut_prevue_7, a0_.date_fin_prevue AS date_fin_prevue_8, a0_.assignation_acteur_ids AS assignation_acteur_ids_9, a0_.statut AS statut_10, a0_.priorite AS priorite_11, a0_.localisation AS localisation_12, a0_.coordonnees_gps AS coordonnees_gps_13, a0_.resultat AS resultat_14, a0_.partenaires AS partenaires_15, a0_.target AS target_16, a0_.indicateur AS indicateur_17, a0_.created_at AS created_at_18, a0_.updated_at AS updated_at_19, a0_.intervention_id AS intervention_id_20, a0_.niveau_id AS niveau_id_21, a0_.type_activite_id AS type_activite_id_22, a0_.cree_par_id AS cree_par_id_23, a0_.structure_responsable_id AS structure_responsable_id_24, a0_.activite_parente_id AS activite_parente_id_25 FROM activite a0_ LEFT JOIN intervention i1_ ON a0_.intervention_id = i1_.id WHERE i1_.annee = ? ORDER BY a0_.updated_at DESC LIMIT 8
Parameters: 
[
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
1.23 ms
(3.25%) 		3 
SELECT COUNT(a0_.id) AS sclr_0 FROM activite a0_ WHERE a0_.annee = ? AND a0_.statut = ?
Parameters: 
[
  2026
  "en_cours"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.16 ms
(3.08%) 		1 
SELECT c0_.id AS id_0, c0_.commentaire AS commentaire_1, c0_.type AS type_2, c0_.statut AS statut_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.full_name AS full_name_10, u1_.position AS position_11, u1_.avatar AS avatar_12, u1_.is_enabled AS is_enabled_13, u1_.acces_donnees AS acces_donnees_14, u1_.derniere_connexion AS derniere_connexion_15, u1_.tentatives_connexion AS tentatives_connexion_16, u1_.compte_verrouille AS compte_verrouille_17, u1_.preferences_interface AS preferences_interface_18, a2_.id AS id_19, a2_.numero AS numero_20, a2_.annee AS annee_21, a2_.titre AS titre_22, a2_.description AS description_23, a2_.cible_quantitative AS cible_quantitative_24, a2_.compteur_realise AS compteur_realise_25, a2_.date_debut_prevue AS date_debut_prevue_26, a2_.date_fin_prevue AS date_fin_prevue_27, a2_.assignation_acteur_ids AS assignation_acteur_ids_28, a2_.statut AS statut_29, a2_.priorite AS priorite_30, a2_.localisation AS localisation_31, a2_.coordonnees_gps AS coordonnees_gps_32, a2_.resultat AS resultat_33, a2_.partenaires AS partenaires_34, a2_.target AS target_35, a2_.indicateur AS indicateur_36, a2_.created_at AS created_at_37, a2_.updated_at AS updated_at_38, c0_.activite_id AS activite_id_39, c0_.auteur_id AS auteur_id_40, c0_.parent_commentaire_id AS parent_commentaire_id_41, u1_.structure_id AS structure_id_42, a2_.intervention_id AS intervention_id_43, a2_.niveau_id AS niveau_id_44, a2_.type_activite_id AS type_activite_id_45, a2_.cree_par_id AS cree_par_id_46, a2_.structure_responsable_id AS structure_responsable_id_47, a2_.activite_parente_id AS activite_parente_id_48 FROM commentaire_activite c0_ LEFT JOIN "user" u1_ ON c0_.auteur_id = u1_.id LEFT JOIN activite a2_ ON c0_.activite_id = a2_.id LEFT JOIN intervention i3_ ON a2_.intervention_id = i3_.id WHERE c0_.statut = ? AND i3_.annee = ? ORDER BY c0_.created_at DESC LIMIT 1
Parameters: 
[
  "actif"
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
1.02 ms
(2.69%) 		1 
SELECT COUNT(*) FROM intervention t0 WHERE t0.annee = ?
Parameters: 
[
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
1.00 ms
(2.65%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
0.96 ms
(2.54%) 		1 
SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.date_fin AS date_fin_2, a0_.raison_delai AS raison_delai_3, a0_.nb_total_participants AS nb_total_participants_4, a0_.nb_femmes AS nb_femmes_5, a0_.nb_hommes AS nb_hommes_6, a0_.nb_formateurs AS nb_formateurs_7, a0_.nb_acteurs_formes AS nb_acteurs_formes_8, a0_.autres_structures AS autres_structures_9, a0_.titre AS titre_10, a0_.description AS description_11, a0_.is_sync AS is_sync_12, a0_.synced_planif AS synced_planif_13, a0_.synced_full AS synced_full_14, a0_.statut_validation AS statut_validation_15, a0_.commentaire_validation AS commentaire_validation_16, a0_.date_validation AS date_validation_17, a0_.activite_id AS activite_id_18, a0_.niveau_id AS niveau_id_19, a0_.type_activite_id AS type_activite_id_20, a0_.cree_par_id AS cree_par_id_21, a0_.valide_par_id AS valide_par_id_22 FROM activite_reunion_formation a0_ LEFT JOIN activite a1_ ON a0_.activite_id = a1_.id LEFT JOIN intervention i2_ ON a1_.intervention_id = i2_.id WHERE i2_.annee = ? ORDER BY a0_.date_debut DESC LIMIT 3
Parameters: 
[
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
0.96 ms
(2.53%) 		1 
SELECT COUNT(a0_.id) AS sclr_0 FROM activite a0_ WHERE a0_.annee = ?
Parameters: 
[
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
0.85 ms
(2.25%) 		1 
SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.date_fin AS date_fin_2, a0_.raison_delai AS raison_delai_3, a0_.commentaires AS commentaires_4, a0_.titre AS titre_5, a0_.description AS description_6, a0_.is_sync AS is_sync_7, a0_.statut_validation AS statut_validation_8, a0_.commentaire_validation AS commentaire_validation_9, a0_.date_validation AS date_validation_10, a0_.activite_id AS activite_id_11, a0_.enquete_type_id AS enquete_type_id_12, a0_.district_intervention_id AS district_intervention_id_13, a0_.district_comparaison_id AS district_comparaison_id_14, a0_.statut_id AS statut_id_15, a0_.cree_par_id AS cree_par_id_16, a0_.valide_par_id AS valide_par_id_17 FROM activite_enquete a0_ LEFT JOIN activite a1_ ON a0_.activite_id = a1_.id LEFT JOIN intervention i2_ ON a1_.intervention_id = i2_.id WHERE i2_.annee = ? ORDER BY a0_.date_debut DESC LIMIT 3
Parameters: 
[
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
0.85 ms
(2.24%) 		1 
SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.date_fin AS date_fin_2, a0_.raison_delai AS raison_delai_3, a0_.nb_total_participants AS nb_total_participants_4, a0_.nb_femmes AS nb_femmes_5, a0_.nb_hommes AS nb_hommes_6, a0_.titre AS titre_7, a0_.description AS description_8, a0_.is_sync AS is_sync_9, a0_.synced_planif AS synced_planif_10, a0_.synced_full AS synced_full_11, a0_.statut_validation AS statut_validation_12, a0_.commentaire_validation AS commentaire_validation_13, a0_.date_validation AS date_validation_14, a0_.activite_id AS activite_id_15, a0_.niveau_id AS niveau_id_16, a0_.type_sensibilisation_id AS type_sensibilisation_id_17, a0_.cree_par_id AS cree_par_id_18, a0_.valide_par_id AS valide_par_id_19 FROM activite_sensibilisation a0_ LEFT JOIN activite a1_ ON a0_.activite_id = a1_.id LEFT JOIN intervention i2_ ON a1_.intervention_id = i2_.id WHERE i2_.annee = ? ORDER BY a0_.date_debut DESC LIMIT 3
Parameters: 
[
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
0.83 ms
(2.20%) 		4 
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: 
[
  30
]
View formatted query    View runnable query    Explain query    View query backtrace
0.81 ms
(2.14%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
0.77 ms
(2.05%) 		1 
SELECT a0_.id AS id_0, a0_.numero AS numero_1, a0_.annee AS annee_2, a0_.titre AS titre_3, a0_.description AS description_4, a0_.cible_quantitative AS cible_quantitative_5, a0_.compteur_realise AS compteur_realise_6, a0_.date_debut_prevue AS date_debut_prevue_7, a0_.date_fin_prevue AS date_fin_prevue_8, a0_.assignation_acteur_ids AS assignation_acteur_ids_9, a0_.statut AS statut_10, a0_.priorite AS priorite_11, a0_.localisation AS localisation_12, a0_.coordonnees_gps AS coordonnees_gps_13, a0_.resultat AS resultat_14, a0_.partenaires AS partenaires_15, a0_.target AS target_16, a0_.indicateur AS indicateur_17, a0_.created_at AS created_at_18, a0_.updated_at AS updated_at_19, a0_.intervention_id AS intervention_id_20, a0_.niveau_id AS niveau_id_21, a0_.type_activite_id AS type_activite_id_22, a0_.cree_par_id AS cree_par_id_23, a0_.structure_responsable_id AS structure_responsable_id_24, a0_.activite_parente_id AS activite_parente_id_25 FROM activite a0_ LEFT JOIN intervention i1_ ON a0_.intervention_id = i1_.id WHERE a0_.date_fin_prevue < ? AND a0_.statut NOT IN (?, ?) AND i1_.annee = ? ORDER BY a0_.date_fin_prevue ASC LIMIT 3
Parameters: 
[
  "2026-07-27 10:59:18"
  "complete"
  "validee"
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
0.77 ms
(2.05%) 		1 
SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.date_fin AS date_fin_2, a0_.raison_delai AS raison_delai_3, a0_.nb_prestataires AS nb_prestataires_4, a0_.nb_femmes AS nb_femmes_5, a0_.nb_hommes AS nb_hommes_6, a0_.nb_jeunes AS nb_jeunes_7, a0_.nb_acteurs_communautaires AS nb_acteurs_communautaires_8, a0_.nb_ocb AS nb_ocb_9, a0_.nb_interviews_realises AS nb_interviews_realises_10, a0_.titre AS titre_11, a0_.description AS description_12, a0_.is_sync AS is_sync_13, a0_.statut_validation AS statut_validation_14, a0_.commentaire_validation AS commentaire_validation_15, a0_.date_validation AS date_validation_16, a0_.activite_id AS activite_id_17, a0_.district_id AS district_id_18, a0_.cree_par_id AS cree_par_id_19, a0_.valide_par_id AS valide_par_id_20 FROM activite_interview_fg a0_ LEFT JOIN activite a1_ ON a0_.activite_id = a1_.id LEFT JOIN intervention i2_ ON a1_.intervention_id = i2_.id WHERE i2_.annee = ? ORDER BY a0_.date_debut DESC LIMIT 3
Parameters: 
[
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(1.93%) 		1 
SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.date_fin AS date_fin_2, a0_.raison_delai AS raison_delai_3, a0_.nb_realise AS nb_realise_4, a0_.titre AS titre_5, a0_.description AS description_6, a0_.is_sync AS is_sync_7, a0_.statut_validation AS statut_validation_8, a0_.commentaire_validation AS commentaire_validation_9, a0_.date_validation AS date_validation_10, a0_.activite_id AS activite_id_11, a0_.approche_suivi_id AS approche_suivi_id_12, a0_.cree_par_id AS cree_par_id_13, a0_.valide_par_id AS valide_par_id_14 FROM activite_suivi a0_ LEFT JOIN activite a1_ ON a0_.activite_id = a1_.id LEFT JOIN intervention i2_ ON a1_.intervention_id = i2_.id WHERE i2_.annee = ? ORDER BY a0_.date_debut DESC LIMIT 3
Parameters: 
[
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(1.87%) 		1 
SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.date_fin AS date_fin_2, a0_.raison_delai AS raison_delai_3, a0_.nb_superviseurs AS nb_superviseurs_4, a0_.observations AS observations_5, a0_.titre AS titre_6, a0_.description AS description_7, a0_.is_sync AS is_sync_8, a0_.statut_validation AS statut_validation_9, a0_.commentaire_validation AS commentaire_validation_10, a0_.date_validation AS date_validation_11, a0_.activite_id AS activite_id_12, a0_.cree_par_id AS cree_par_id_13, a0_.valide_par_id AS valide_par_id_14 FROM activite_supervision a0_ LEFT JOIN activite a1_ ON a0_.activite_id = a1_.id LEFT JOIN intervention i2_ ON a1_.intervention_id = i2_.id WHERE i2_.annee = ? ORDER BY a0_.date_debut DESC LIMIT 3
Parameters: 
[
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(1.36%) 		1 
SELECT a0_.id AS id_0, a0_.numero AS numero_1, a0_.annee AS annee_2, a0_.titre AS titre_3, a0_.description AS description_4, a0_.cible_quantitative AS cible_quantitative_5, a0_.compteur_realise AS compteur_realise_6, a0_.date_debut_prevue AS date_debut_prevue_7, a0_.date_fin_prevue AS date_fin_prevue_8, a0_.assignation_acteur_ids AS assignation_acteur_ids_9, a0_.statut AS statut_10, a0_.priorite AS priorite_11, a0_.localisation AS localisation_12, a0_.coordonnees_gps AS coordonnees_gps_13, a0_.resultat AS resultat_14, a0_.partenaires AS partenaires_15, a0_.target AS target_16, a0_.indicateur AS indicateur_17, a0_.created_at AS created_at_18, a0_.updated_at AS updated_at_19, a0_.intervention_id AS intervention_id_20, a0_.niveau_id AS niveau_id_21, a0_.type_activite_id AS type_activite_id_22, a0_.cree_par_id AS cree_par_id_23, a0_.structure_responsable_id AS structure_responsable_id_24, a0_.activite_parente_id AS activite_parente_id_25 FROM activite a0_ LEFT JOIN intervention i1_ ON a0_.intervention_id = i1_.id WHERE a0_.statut = ? AND i1_.annee = ? ORDER BY a0_.updated_at DESC LIMIT 3
Parameters: 
[
  "complete"
  2026
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.85%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type_dialogue t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Activite 21
App\Entity\ActiviteCalendrier 21
App\Entity\ActiviteLigne 18
App\Entity\Intervention 12
App\Entity\User 11
App\Entity\PosteSante 9
App\Entity\Groupe 4
App\Entity\ActiviteReunionFormation 3
App\Entity\RefNiveau 3
App\Entity\ActiviteSensibilisation 3
App\Entity\DistrictSanitaire 2
App\Entity\TypeDialogue 2
App\Entity\RefTypeActivite 2
App\Entity\RefTypeSensibilisation 2
App\Entity\Structure 1
App\Entity\TypeActivite 1
App\Entity\ActiviteSuivi 1
App\Entity\RefApprocheSuivi 1
App\Entity\ActiviteEnquete 1
App\Entity\RefEnqueteType 1
App\Entity\RefDistrictComp 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Structure No errors.
App\Entity\Activite
  • The field App\Entity\Activite#activiteOutils is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ActiviteOutil#activite does not contain the required 'inversedBy="activiteOutils"' attribute.
  • The field App\Entity\Activite#activiteDocumentTechniques is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ActiviteDocumentTechnique#activite does not contain the required 'inversedBy="activiteDocumentTechniques"' attribute.
  • The field App\Entity\Activite#activiteSuivis is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ActiviteSuivi#activite does not contain the required 'inversedBy="activiteSuivis"' attribute.
  • The field App\Entity\Activite#activiteEnquetes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ActiviteEnquete#activite does not contain the required 'inversedBy="activiteEnquetes"' attribute.
  • The field App\Entity\Activite#activiteInterviewsFg is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ActiviteInterviewFg#activite does not contain the required 'inversedBy="activiteInterviewsFg"' attribute.
  • The field App\Entity\Activite#calendrier is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ActiviteCalendrier#activite does not contain the required 'inversedBy="calendrier"' attribute.
App\Entity\Role No errors.
App\Entity\Intervention No errors.
App\Entity\RefNiveau No errors.
App\Entity\TypeActivite
  • The field App\Entity\TypeActivite#interventions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Intervention#typeActivite does not contain the required 'inversedBy="interventions"' attribute.
  • The field App\Entity\TypeActivite#activites is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Activite#typeActivite does not contain the required 'inversedBy="activites"' attribute.
App\Entity\ActiviteReunionFormation
  • The association App\Entity\ActiviteReunionFormation#districts refers to the inverse side field App\Entity\DistrictSanitaire#activiteReunionFormations which does not exist.
  • The association App\Entity\ActiviteReunionFormation#posteSantes refers to the inverse side field App\Entity\PosteSante#activiteReunionFormations which does not exist.
App\Entity\ActiviteSensibilisation
  • The association App\Entity\ActiviteSensibilisation#districts refers to the inverse side field App\Entity\DistrictSanitaire#activiteSensibilisations which does not exist.
  • The association App\Entity\ActiviteSensibilisation#posteSantes refers to the inverse side field App\Entity\PosteSante#activiteSensibilisations which does not exist.
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\ActiviteLigne No errors.
App\Entity\AssignationActivite No errors.
App\Entity\ActiviteCalendrier 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\RefTypeActivite No errors.
App\Entity\RefTypeStructure No errors.
App\Entity\ActiviteReunionFormationPointDiscute No errors.
App\Entity\RefFonction No errors.
App\Entity\RefTypeSensibilisation No errors.
App\Entity\ActiviteSensibilisationThematique No errors.
App\Entity\RefCible No errors.
App\Entity\RefApprocheSuivi No errors.
App\Entity\RefEnqueteType No errors.
App\Entity\RefDistrictComp No errors.
App\Entity\RefStatut No errors.
App\Entity\PermissionCategory No errors.
App\Entity\Permission No errors.