GET http://pisa.chaiprod.com/admin/activite-lignes/2128/view

Query Metrics

50 Database Queries
12 Different statements
21.86 ms Query time
4 Invalid entities
111 Managed entities

Queries

Group similar statements

# Time Info
1 1.83 ms
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
]
2 1.98 ms
SELECT t0.id AS id_1, t0.date_seance AS date_seance_2, t0.titre AS titre_3, t0.lieu AS lieu_4, t0.equipe_facilitation AS equipe_facilitation_5, t0.facilitateur1 AS facilitateur1_6, t0.facilitateur2 AS facilitateur2_7, t0.facilitateur3 AS facilitateur3_8, t0.total_participants AS total_participants_9, t0.age_moins15 AS age_moins15_10, t0.age15a24 AS age15a24_11, t0.age25a34 AS age25a34_12, t0.age35a49 AS age35a49_13, t0.age50_plus AS age50_plus_14, t0.alphabetises AS alphabetises_15, t0.non_alphabetises AS non_alphabetises_16, t0.membres_association AS membres_association_17, t0.activite1_libelle AS activite1_libelle_18, t0.activite1_realise AS activite1_realise_19, t0.activite2_libelle AS activite2_libelle_20, t0.activite2_realise AS activite2_realise_21, t0.activite3_libelle AS activite3_libelle_22, t0.activite3_realise AS activite3_realise_23, t0.activite4_libelle AS activite4_libelle_24, t0.activite4_realise AS activite4_realise_25, t0.activite5_libelle AS activite5_libelle_26, t0.activite5_realise AS activite5_realise_27, t0.activite6_libelle AS activite6_libelle_28, t0.activite6_realise AS activite6_realise_29, t0.activite7_libelle AS activite7_libelle_30, t0.activite7_realise AS activite7_realise_31, t0.gripp_aff1_rouge AS gripp_aff1_rouge_32, t0.gripp_aff1_jaune AS gripp_aff1_jaune_33, t0.gripp_aff1_vert AS gripp_aff1_vert_34, t0.gripp_aff2_rouge AS gripp_aff2_rouge_35, t0.gripp_aff2_jaune AS gripp_aff2_jaune_36, t0.gripp_aff2_vert AS gripp_aff2_vert_37, t0.gripp_aff3_rouge AS gripp_aff3_rouge_38, t0.gripp_aff3_jaune AS gripp_aff3_jaune_39, t0.gripp_aff3_vert AS gripp_aff3_vert_40, t0.gripp_aff4_rouge AS gripp_aff4_rouge_41, t0.gripp_aff4_jaune AS gripp_aff4_jaune_42, t0.gripp_aff4_vert AS gripp_aff4_vert_43, t0.gripp_aff5_rouge AS gripp_aff5_rouge_44, t0.gripp_aff5_jaune AS gripp_aff5_jaune_45, t0.gripp_aff5_vert AS gripp_aff5_vert_46, t0.gripp_aff6_rouge AS gripp_aff6_rouge_47, t0.gripp_aff6_jaune AS gripp_aff6_jaune_48, t0.gripp_aff6_vert AS gripp_aff6_vert_49, t0.gripp_aff7_rouge AS gripp_aff7_rouge_50, t0.gripp_aff7_jaune AS gripp_aff7_jaune_51, t0.gripp_aff7_vert AS gripp_aff7_vert_52, t0.gripp_aff8_rouge AS gripp_aff8_rouge_53, t0.gripp_aff8_jaune AS gripp_aff8_jaune_54, t0.gripp_aff8_vert AS gripp_aff8_vert_55, t0.gripp_aff9_rouge AS gripp_aff9_rouge_56, t0.gripp_aff9_jaune AS gripp_aff9_jaune_57, t0.gripp_aff9_vert AS gripp_aff9_vert_58, t0.gripp_aff10_rouge AS gripp_aff10_rouge_59, t0.gripp_aff10_jaune AS gripp_aff10_jaune_60, t0.gripp_aff10_vert AS gripp_aff10_vert_61, t0.action1 AS action1_62, t0.action2 AS action2_63, t0.action3 AS action3_64, t0.representant1_prenom AS representant1_prenom_65, t0.representant1_nom AS representant1_nom_66, t0.representant2_prenom AS representant2_prenom_67, t0.representant2_nom AS representant2_nom_68, t0.barometre_exprimer AS barometre_exprimer_69, t0.barometre_ecoute AS barometre_ecoute_70, t0.barometre_action_claire AS barometre_action_claire_71, t0.observations AS observations_72, t0.deja_participe AS deja_participe_73, t0.documents_joints AS documents_joints_74, t0.date_planifier AS date_planifier_75, t0.commentaire AS commentaire_76, t0.doc1_name AS doc1_name_77, t0.doc1_path AS doc1_path_78, t0.doc2_name AS doc2_name_79, t0.doc2_path AS doc2_path_80, t0.doc3_name AS doc3_name_81, t0.doc3_path AS doc3_path_82, t0.doc4_name AS doc4_name_83, t0.doc4_path AS doc4_path_84, t0.doc5_name AS doc5_name_85, t0.doc5_path AS doc5_path_86, t0.doc6_name AS doc6_name_87, t0.doc6_path AS doc6_path_88, t0.doc7_name AS doc7_name_89, t0.doc7_path AS doc7_path_90, t0.doc8_name AS doc8_name_91, t0.doc8_path AS doc8_path_92, t0.doc9_name AS doc9_name_93, t0.doc9_path AS doc9_path_94, t0.doc10_name AS doc10_name_95, t0.doc10_path AS doc10_path_96, t0.date_creation AS date_creation_97, t0.date_modification AS date_modification_98, t0.is_sync AS is_sync_99, t0.synced_planif AS synced_planif_100, t0.synced_full AS synced_full_101, t0.nbr_femme AS nbr_femme_102, t0.nbr_homme AS nbr_homme_103, t0.statut_validation AS statut_validation_104, t0.commentaire_validation AS commentaire_validation_105, t0.date_validation AS date_validation_106, t0.deleted_at AS deleted_at_107, t0.poste_sante_id AS poste_sante_id_108, t0.type_dialogue_id AS type_dialogue_id_109, t0.groupe_id AS groupe_id_110, t0.district_sanitaire_id AS district_sanitaire_id_111, t0.activite_id AS activite_id_112, t0.cree_par_id AS cree_par_id_113, t0.valide_par_id AS valide_par_id_114 FROM ligne_activite t0 WHERE t0.id = ?
Parameters:
[
  "2128"
]
3 1.33 ms
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
]
4 0.26 ms
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
]
5 0.24 ms
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:
[
  1
]
6 0.22 ms
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:
[
  2
]
7 0.21 ms
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:
[
  3
]
8 0.22 ms
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:
[
  4
]
9 0.23 ms
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:
[
  5
]
10 0.22 ms
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:
[
  6
]
11 0.21 ms
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:
[
  7
]
12 0.24 ms
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:
[
  35
]
13 0.27 ms
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:
[
  8
]
14 0.22 ms
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:
[
  21
]
15 0.21 ms
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:
[
  22
]
16 0.22 ms
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:
[
  23
]
17 0.21 ms
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:
[
  27
]
18 0.21 ms
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:
[
  24
]
19 0.21 ms
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:
[
  25
]
20 0.22 ms
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:
[
  26
]
21 0.21 ms
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:
[
  31
]
22 0.22 ms
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:
[
  30
]
23 0.22 ms
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:
[
  29
]
24 0.21 ms
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:
[
  28
]
25 0.23 ms
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:
[
  32
]
26 0.22 ms
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:
[
  37
]
27 2.70 ms
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
]
28 2.45 ms
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
]
29 0.53 ms
SELECT t0.id AS id_1, t0.janvier AS janvier_2, t0.fevrier AS fevrier_3, t0.mars AS mars_4, t0.avril AS avril_5, t0.mai AS mai_6, t0.juin AS juin_7, t0.juillet AS juillet_8, t0.aout AS aout_9, t0.septembre AS septembre_10, t0.octobre AS octobre_11, t0.novembre AS novembre_12, t0.decembre AS decembre_13, t0.date_premier_mois AS date_premier_mois_14, t0.date_dernier_mois AS date_dernier_mois_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.activite_id AS activite_id_18 FROM activite_calendrier t0 WHERE t0.activite_id = ?
Parameters:
[
  427
]
30 0.26 ms
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:
[
  424
]
31 0.26 ms
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:
[
  417
]
32 0.26 ms
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:
[
  422
]
33 0.24 ms
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:
[
  416
]
34 0.25 ms
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
]
35 0.28 ms
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
]
36 0.26 ms
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:
[
  26
]
37 0.32 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.district_sanitaire_id AS district_sanitaire_id_3 FROM poste_sante t0 WHERE t0.id = ?
Parameters:
[
  9
]
38 0.28 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type_dialogue t0 WHERE t0.id = ?
Parameters:
[
  5
]
39 0.31 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM groupe t0 WHERE t0.id = ?
Parameters:
[
  9
]
40 0.97 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.media_id AS media_id_3, t0.activite_ligne_id AS activite_ligne_id_4 FROM ligne_document t0 WHERE t0.activite_ligne_id = ?
Parameters:
[
  2128
]
41 0.44 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.updated_at AS updated_at_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
  "019f698d-722a-70a0-bb7a-612c4feba0f8"
]
42 0.20 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.updated_at AS updated_at_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
  "019f698d-746e-78f5-9ca4-5e182f7a7df9"
]
43 0.19 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.updated_at AS updated_at_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
  "019f698d-7743-7a05-ac9a-63a994e6195c"
]
44 0.19 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.updated_at AS updated_at_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
  "019f698d-795b-7b6e-8efb-1392a92b04ee"
]
45 0.19 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.updated_at AS updated_at_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
  "019f698d-7cdb-79ee-b350-587cd2f44f18"
]
46 0.19 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.updated_at AS updated_at_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
  "019f698d-7ffb-7134-8bcf-2fa6790d2f33"
]
47 0.20 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.updated_at AS updated_at_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
  "019f698d-8308-7d11-b4d4-0eca75039eb4"
]
48 0.19 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.updated_at AS updated_at_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
  "019f698d-8629-78b8-a5aa-3e7e89d98b1c"
]
49 0.20 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.updated_at AS updated_at_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
  "019f698d-875f-7b35-8068-ab600d735ef2"
]
50 0.21 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.updated_at AS updated_at_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
  "019f698d-886a-75be-9d36-fd14faeb051d"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\PermissionCategory 42
App\Entity\ActiviteLigne 11
App\Entity\LigneDocument 10
App\Entity\MediaObject 10
App\Entity\User 7
App\Entity\PosteSante 7
App\Entity\Activite 6
App\Entity\ActiviteCalendrier 6
App\Entity\Groupe 3
App\Entity\Structure 2
App\Entity\TypeDialogue 2
App\Entity\DistrictSanitaire 2
App\Entity\Intervention 2
App\Entity\TypeActivite 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Structure No errors.
App\Entity\Activite
  • 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\PosteSante No errors.
App\Entity\TypeDialogue No errors.
App\Entity\Groupe No errors.
App\Entity\DistrictSanitaire No errors.
App\Entity\LigneDocument No errors.
App\Entity\HistoriqueValidation No errors.
App\Entity\PermissionCategory No errors.
App\Entity\Permission No errors.
App\Entity\Intervention No errors.
App\Entity\RefNiveau No errors.
App\Entity\TypeActivite
  • 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\AssignationActivite No errors.
App\Entity\ActiviteCalendrier No errors.
App\Entity\MediaObject No errors.