Symfony Profiler

Query Metrics

97 Database Queries

14 Different statements

42.45 ms Query time

4 Invalid entities

261 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.98 ms
(37.64%)

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:

[
  426
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 426;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 438)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 206)
12	App\Controller\ActiviteLigneController->index (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

6.97 ms
(16.42%)

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, s3_.id AS id_139, s3_.libelle AS libelle_140, s3_.code AS code_141, s3_.description AS description_142, u4_.id AS id_143, u4_.email AS email_144, u4_.roles AS roles_145, u4_.password AS password_146, u4_.full_name AS full_name_147, u4_.position AS position_148, u4_.avatar AS avatar_149, u4_.is_enabled AS is_enabled_150, u4_.acces_donnees AS acces_donnees_151, u4_.derniere_connexion AS derniere_connexion_152, u4_.tentatives_connexion AS tentatives_connexion_153, u4_.compte_verrouille AS compte_verrouille_154, u4_.preferences_interface AS preferences_interface_155, p5_.id AS id_156, p5_.nom AS nom_157, d6_.id AS id_158, d6_.nom AS nom_159, t7_.id AS id_160, t7_.libelle AS libelle_161, g8_.id AS id_162, g8_.nom AS nom_163, g8_.description AS description_164, l0_.poste_sante_id AS poste_sante_id_165, l0_.type_dialogue_id AS type_dialogue_id_166, l0_.groupe_id AS groupe_id_167, l0_.district_sanitaire_id AS district_sanitaire_id_168, l0_.activite_id AS activite_id_169, l0_.cree_par_id AS cree_par_id_170, l0_.valide_par_id AS valide_par_id_171, a1_.intervention_id AS intervention_id_172, a1_.niveau_id AS niveau_id_173, a1_.type_activite_id AS type_activite_id_174, a1_.cree_par_id AS cree_par_id_175, a1_.structure_responsable_id AS structure_responsable_id_176, a1_.activite_parente_id AS activite_parente_id_177, i2_.type_activite_id AS type_activite_id_178, i2_.responsable_id AS responsable_id_179, s3_.type_structure_id AS type_structure_id_180, u4_.structure_id AS structure_id_181, p5_.district_sanitaire_id AS district_sanitaire_id_182 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 structure s3_ ON a1_.structure_responsable_id = s3_.id LEFT JOIN "user" u4_ ON l0_.cree_par_id = u4_.id LEFT JOIN poste_sante p5_ ON l0_.poste_sante_id = p5_.id LEFT JOIN district_sanitaire d6_ ON p5_.district_sanitaire_id = d6_.id LEFT JOIN type_dialogue t7_ ON l0_.type_dialogue_id = t7_.id LEFT JOIN groupe g8_ ON l0_.groupe_id = g8_.id WHERE l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY l0_.date_creation DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

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,
  s3_.id AS id_139,
  s3_.libelle AS libelle_140,
  s3_.code AS code_141,
  s3_.description AS description_142,
  u4_.id AS id_143,
  u4_.email AS email_144,
  u4_.roles AS roles_145,
  u4_.password AS password_146,
  u4_.full_name AS full_name_147,
  u4_.position AS position_148,
  u4_.avatar AS avatar_149,
  u4_.is_enabled AS is_enabled_150,
  u4_.acces_donnees AS acces_donnees_151,
  u4_.derniere_connexion AS derniere_connexion_152,
  u4_.tentatives_connexion AS tentatives_connexion_153,
  u4_.compte_verrouille AS compte_verrouille_154,
  u4_.preferences_interface AS preferences_interface_155,
  p5_.id AS id_156,
  p5_.nom AS nom_157,
  d6_.id AS id_158,
  d6_.nom AS nom_159,
  t7_.id AS id_160,
  t7_.libelle AS libelle_161,
  g8_.id AS id_162,
  g8_.nom AS nom_163,
  g8_.description AS description_164,
  l0_.poste_sante_id AS poste_sante_id_165,
  l0_.type_dialogue_id AS type_dialogue_id_166,
  l0_.groupe_id AS groupe_id_167,
  l0_.district_sanitaire_id AS district_sanitaire_id_168,
  l0_.activite_id AS activite_id_169,
  l0_.cree_par_id AS cree_par_id_170,
  l0_.valide_par_id AS valide_par_id_171,
  a1_.intervention_id AS intervention_id_172,
  a1_.niveau_id AS niveau_id_173,
  a1_.type_activite_id AS type_activite_id_174,
  a1_.cree_par_id AS cree_par_id_175,
  a1_.structure_responsable_id AS structure_responsable_id_176,
  a1_.activite_parente_id AS activite_parente_id_177,
  i2_.type_activite_id AS type_activite_id_178,
  i2_.responsable_id AS responsable_id_179,
  s3_.type_structure_id AS type_structure_id_180,
  u4_.structure_id AS structure_id_181,
  p5_.district_sanitaire_id AS district_sanitaire_id_182
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 structure s3_ ON a1_.structure_responsable_id = s3_.id
  LEFT JOIN "user" u4_ ON l0_.cree_par_id = u4_.id
  LEFT JOIN poste_sante p5_ ON l0_.poste_sante_id = p5_.id
  LEFT JOIN district_sanitaire d6_ ON p5_.district_sanitaire_id = d6_.id
  LEFT JOIN type_dialogue t7_ ON l0_.type_dialogue_id = t7_.id
  LEFT JOIN groupe g8_ ON l0_.groupe_id = g8_.id
WHERE
  l0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  l0_.date_creation DESC

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, s3_.id AS id_139, s3_.libelle AS libelle_140, s3_.code AS code_141, s3_.description AS description_142, u4_.id AS id_143, u4_.email AS email_144, u4_.roles AS roles_145, u4_.password AS password_146, u4_.full_name AS full_name_147, u4_.position AS position_148, u4_.avatar AS avatar_149, u4_.is_enabled AS is_enabled_150, u4_.acces_donnees AS acces_donnees_151, u4_.derniere_connexion AS derniere_connexion_152, u4_.tentatives_connexion AS tentatives_connexion_153, u4_.compte_verrouille AS compte_verrouille_154, u4_.preferences_interface AS preferences_interface_155, p5_.id AS id_156, p5_.nom AS nom_157, d6_.id AS id_158, d6_.nom AS nom_159, t7_.id AS id_160, t7_.libelle AS libelle_161, g8_.id AS id_162, g8_.nom AS nom_163, g8_.description AS description_164, l0_.poste_sante_id AS poste_sante_id_165, l0_.type_dialogue_id AS type_dialogue_id_166, l0_.groupe_id AS groupe_id_167, l0_.district_sanitaire_id AS district_sanitaire_id_168, l0_.activite_id AS activite_id_169, l0_.cree_par_id AS cree_par_id_170, l0_.valide_par_id AS valide_par_id_171, a1_.intervention_id AS intervention_id_172, a1_.niveau_id AS niveau_id_173, a1_.type_activite_id AS type_activite_id_174, a1_.cree_par_id AS cree_par_id_175, a1_.structure_responsable_id AS structure_responsable_id_176, a1_.activite_parente_id AS activite_parente_id_177, i2_.type_activite_id AS type_activite_id_178, i2_.responsable_id AS responsable_id_179, s3_.type_structure_id AS type_structure_id_180, u4_.structure_id AS structure_id_181, p5_.district_sanitaire_id AS district_sanitaire_id_182 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 structure s3_ ON a1_.structure_responsable_id = s3_.id LEFT JOIN "user" u4_ ON l0_.cree_par_id = u4_.id LEFT JOIN poste_sante p5_ ON l0_.poste_sante_id = p5_.id LEFT JOIN district_sanitaire d6_ ON p5_.district_sanitaire_id = d6_.id LEFT JOIN type_dialogue t7_ ON l0_.type_dialogue_id = t7_.id LEFT JOIN groupe g8_ ON l0_.groupe_id = g8_.id WHERE l0_.id IN (2212, 2120, 2125, 2200, 2121, 2122, 2123, 2124, 2128, 2126, 2127, 1918, 1914, 1916, 1917, 1846) ORDER BY l0_.date_creation DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 206)
7	App\Controller\ActiviteLigneController->index (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

5.59 ms
(13.16%)

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

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

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 = 33 ORDER BY t0.display_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 183)
8	App\Service\PermissionService->buildMenuChildren (line 165)
9	App\Service\PermissionService->getAccessibleMenuTree (line 45)
10	App\Twig\MenuExtension->getNavbarMenu (line 125)
11	__TwigTemplate_e07a7813008665b97188115be41162f3->doDisplay (line 388)
12	Twig\Template->yield (line 167)
13	__TwigTemplate_20cd53630d687aed440ebb7ebccdf557->doDisplay (line 388)
14	Twig\Template->yield (line 58)
15	__TwigTemplate_cbbddf03d800c37459e008e028ad2189->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 334)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
24	App\Controller\ActiviteLigneController->index (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

4.54 ms
(10.70%)

SELECT COUNT(DISTINCT 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 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 type_dialogue t5_ ON l0_.type_dialogue_id = t5_.id LEFT JOIN groupe g6_ ON l0_.groupe_id = g6_.id WHERE (l0_.synced_planif = 1 OR l0_.synced_full = 1) AND l0_.deleted_at IS NULL AND i2_.annee = ? AND p3_.id = ?

Parameters:

[
  2026
  "9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT 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
  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 type_dialogue t5_ ON l0_.type_dialogue_id = t5_.id
  LEFT JOIN groupe g6_ ON l0_.groupe_id = g6_.id
WHERE
  (
    l0_.synced_planif = 1
    OR l0_.synced_full = 1
  )
  AND l0_.deleted_at IS NULL
  AND i2_.annee = ?
  AND p3_.id = ?

SELECT COUNT(DISTINCT 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 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 type_dialogue t5_ ON l0_.type_dialogue_id = t5_.id LEFT JOIN groupe g6_ ON l0_.groupe_id = g6_.id WHERE (l0_.synced_planif = 1 OR l0_.synced_full = 1) AND l0_.deleted_at IS NULL AND i2_.annee = 2026 AND p3_.id = '9';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 178)
8	App\Controller\ActiviteLigneController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.47 ms
(5.82%)

SELECT DISTINCT l0_.id AS id_0, l0_.date_creation AS date_creation_1 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 structure s3_ ON a1_.structure_responsable_id = s3_.id LEFT JOIN "user" u4_ ON l0_.cree_par_id = u4_.id LEFT JOIN poste_sante p5_ ON l0_.poste_sante_id = p5_.id LEFT JOIN district_sanitaire d6_ ON p5_.district_sanitaire_id = d6_.id LEFT JOIN type_dialogue t7_ ON l0_.type_dialogue_id = t7_.id LEFT JOIN groupe g8_ ON l0_.groupe_id = g8_.id WHERE (l0_.synced_planif = 1 OR l0_.synced_full = 1 OR l0_.date_seance IS NOT NULL) AND l0_.deleted_at IS NULL AND ((i2_.annee = ? OR l0_.activite_id IS NULL)) AND p5_.id = ? ORDER BY l0_.date_creation DESC LIMIT 20

Parameters:

[
  2026
  "9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT l0_.id AS id_0,
  l0_.date_creation AS date_creation_1
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 structure s3_ ON a1_.structure_responsable_id = s3_.id
  LEFT JOIN "user" u4_ ON l0_.cree_par_id = u4_.id
  LEFT JOIN poste_sante p5_ ON l0_.poste_sante_id = p5_.id
  LEFT JOIN district_sanitaire d6_ ON p5_.district_sanitaire_id = d6_.id
  LEFT JOIN type_dialogue t7_ ON l0_.type_dialogue_id = t7_.id
  LEFT JOIN groupe g8_ ON l0_.groupe_id = g8_.id
WHERE
  (
    l0_.synced_planif = 1
    OR l0_.synced_full = 1
    OR l0_.date_seance IS NOT NULL
  )
  AND l0_.deleted_at IS NULL
  AND (
    (
      i2_.annee = ?
      OR l0_.activite_id IS NULL
    )
  )
  AND p5_.id = ?
ORDER BY
  l0_.date_creation DESC
LIMIT
  20

SELECT DISTINCT l0_.id AS id_0, l0_.date_creation AS date_creation_1 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 structure s3_ ON a1_.structure_responsable_id = s3_.id LEFT JOIN "user" u4_ ON l0_.cree_par_id = u4_.id LEFT JOIN poste_sante p5_ ON l0_.poste_sante_id = p5_.id LEFT JOIN district_sanitaire d6_ ON p5_.district_sanitaire_id = d6_.id LEFT JOIN type_dialogue t7_ ON l0_.type_dialogue_id = t7_.id LEFT JOIN groupe g8_ ON l0_.groupe_id = g8_.id WHERE (l0_.synced_planif = 1 OR l0_.synced_full = 1 OR l0_.date_seance IS NOT NULL) AND l0_.deleted_at IS NULL AND ((i2_.annee = 2026 OR l0_.activite_id IS NULL)) AND p5_.id = '9' ORDER BY l0_.date_creation DESC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 185)
7	App\Controller\ActiviteLigneController->index (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.83 ms
(4.31%)

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

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

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 = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

1.69 ms
(3.99%)

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

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

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 = 2026 ORDER BY l0_.date_seance DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 681)
7	App\Repository\ActiviteLigneRepository->findTopFichesEnRetardSansRaison (line 35)
8	App\Twig\NotificationExtension->getTopFichesRetardSansRaison (line 205)
9	__TwigTemplate_e07a7813008665b97188115be41162f3->doDisplay (line 388)
10	Twig\Template->yield (line 167)
11	__TwigTemplate_20cd53630d687aed440ebb7ebccdf557->doDisplay (line 388)
12	Twig\Template->yield (line 58)
13	__TwigTemplate_cbbddf03d800c37459e008e028ad2189->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 334)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
22	App\Controller\ActiviteLigneController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.90 ms
(2.13%)

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

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

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 = 2026;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 630)
8	App\Repository\ActiviteLigneRepository->countFichesEnRetardSansRaison (line 29)
9	App\Twig\NotificationExtension->countFichesRetardSansRaison (line 202)
10	__TwigTemplate_e07a7813008665b97188115be41162f3->doDisplay (line 388)
11	Twig\Template->yield (line 167)
12	__TwigTemplate_20cd53630d687aed440ebb7ebccdf557->doDisplay (line 388)
13	Twig\Template->yield (line 58)
14	__TwigTemplate_cbbddf03d800c37459e008e028ad2189->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
23	App\Controller\ActiviteLigneController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.89 ms
(2.09%)

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:

View formatted query View runnable query Explain query View query backtrace

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

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 = 1 AND t0.menu_level = 0 AND t0.parent_id IS NULL AND t0.display_in_navbar = 1 ORDER BY t0.display_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 155)
5	App\Service\PermissionService->getAccessibleMenuTree (line 45)
6	App\Twig\MenuExtension->getNavbarMenu (line 125)
7	__TwigTemplate_e07a7813008665b97188115be41162f3->doDisplay (line 388)
8	Twig\Template->yield (line 167)
9	__TwigTemplate_20cd53630d687aed440ebb7ebccdf557->doDisplay (line 388)
10	Twig\Template->yield (line 58)
11	__TwigTemplate_cbbddf03d800c37459e008e028ad2189->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 334)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
20	App\Controller\ActiviteLigneController->index (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.79 ms
(1.85%)

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_ WHERE a0_.annee = ? ORDER BY a0_.numero ASC

Parameters:

[
  2026
]

View formatted query View runnable query Explain query View query backtrace

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_
WHERE
  a0_.annee = ?
ORDER BY
  a0_.numero ASC

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_ WHERE a0_.annee = 2026 ORDER BY a0_.numero ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 808)
7	App\Repository\ActiviteRepository->findByYear (line 213)
8	App\Controller\ActiviteLigneController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.21 ms
(0.49%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.district_sanitaire_id AS district_sanitaire_id_3 FROM poste_sante t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.district_sanitaire_id AS district_sanitaire_id_3
FROM
  poste_sante t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.district_sanitaire_id AS district_sanitaire_id_3 FROM poste_sante t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 63)
6	App\Service\RefDataService->getPosteSantes (line 219)
7	App\Controller\ActiviteLigneController->index (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.20 ms
(0.48%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type_dialogue t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  type_dialogue t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type_dialogue t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 98)
6	App\Service\RefDataService->getTypesDialogue (line 220)
7	App\Controller\ActiviteLigneController->index (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.20 ms
(0.46%)

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM district_sanitaire t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  district_sanitaire t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM district_sanitaire t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 58)
6	App\Service\RefDataService->getDistricts (line 218)
7	App\Controller\ActiviteLigneController->index (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.19 ms
(0.45%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM groupe t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3
FROM
  groupe t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM groupe t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 103)
6	App\Service\RefDataService->getGroupes (line 221)
7	App\Controller\ActiviteLigneController->index (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 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\Activite	61
App\Entity\ActiviteCalendrier	61
App\Entity\PermissionCategory	42
App\Entity\PosteSante	32
App\Entity\ActiviteLigne	25
App\Entity\Intervention	19
App\Entity\User	9
App\Entity\Groupe	5
App\Entity\Structure	2
App\Entity\DistrictSanitaire	2
App\Entity\TypeDialogue	2
App\Entity\TypeActivite	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\ActiviteLigne	No errors.
App\Entity\Intervention	No errors.
App\Entity\PosteSante	No errors.
App\Entity\DistrictSanitaire	No errors.
App\Entity\TypeDialogue	No errors.
App\Entity\Groupe	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\TypeStructure	No errors.
App\Entity\LigneDocument	No errors.
App\Entity\HistoriqueValidation	No errors.
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\AssignationActivite	No errors.
App\Entity\ActiviteCalendrier	No errors.
App\Entity\PermissionCategory	No errors.
App\Entity\Permission	No errors.

Symfony Profiler

GET http://pisa.chaiprod.com/admin/activite-lignes/?district=&groupe_cible=&periode_mois=&poste_sante=9&search=&synced_planif=&type_dialogue=

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping