Symfony Profiler

[
  "route" => "agenda"
  "route_parameters" => [
    "_route" => "agenda"
    "_controller" => "App\Controller\Nordinfo\MainController::agenda"
  ]
  "request_uri" => "https://nordinfo.spontaneit.fr/agenda"
  "method" => "GET"
]

[
  "firewall_name" => "secured_area"
  "authenticators" => 1
]

[
  "firewall_name" => "secured_area"
  "authenticator" => "App\Security\FormAuthenticator"
]

[
  "firewall_name" => "secured_area"
  "authenticator" => "App\Security\FormAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "co30669-006.dbaas.ovh.net"
    "port" => 35773
    "user" => "nordinfo"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "nordinfo"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.libelle AS libelle_3, t0.kind AS kind_4, t0.type_api AS type_api_5, t0.url AS url_6 FROM menu_libelle t0 WHERE t0.ordre = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT m0_.libelle AS libelle_0, m0_.url AS url_1 FROM menu_libelle m0_ WHERE m0_.ordre <> 0 ORDER BY m0_.ordre ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.lien_acceo AS lien_acceo_3, t0.telephone AS telephone_4, t0.telephone_url AS telephone_url_5, t0.reseaux_sociaux AS reseaux_sociaux_6 FROM footer t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.kind AS kind_1, t0_.display_name AS display_name_2 FROM topic t0_ ORDER BY t0_.display_name ASC"
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.display_name AS display_name_1, t0_.ordre AS ordre_2 FROM territory t0_ WHERE t0_.kind = ? ORDER BY t0_.display_name ASC"
  "params" => [
    1 => "item"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.illustrationfil_name AS illustrationfil_name_1, p0_.illustrationdetail_name AS illustrationdetail_name_2, p0_.document_name1 AS document_name1_3, p0_.document_name2 AS document_name2_4, p0_.document_name3 AS document_name3_5, p0_.image_url AS image_url_6, p0_.thumb_url AS thumb_url_7, p0_.title AS title_8, p0_.short_description AS short_description_9, p0_.content_duration AS content_duration_10, p0_.restriction AS restriction_11, p0_.state AS state_12, p0_.suggested_by AS suggested_by_13, p0_.published_at AS published_at_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.link1 AS link1_17, p0_.url1 AS url1_18, p0_.link2 AS link2_19, p0_.url2 AS url2_20, p0_.link3 AS link3_21, p0_.url3 AS url3_22, p0_.date_debut AS date_debut_23, p0_.date_fin AS date_fin_24, p0_.commentaires AS commentaires_25, p0_.subtitle AS subtitle_26, p0_.chapo AS chapo_27, p0_.horaires AS horaires_28, p0_.tarifs AS tarifs_29, p0_.lieu AS lieu_30, p0_.ville AS ville_31, p0_.credits AS credits_32, p0_.content AS content_33, p0_.defaut_fil AS defaut_fil_34, p0_.epingle1 AS epingle1_35, p0_.epingle2 AS epingle2_36, p0_.organized_by AS organized_by_37, p0_.bool_date_maj AS bool_date_maj_38, p0_.updated_date_display AS updated_date_display_39, p0_.slug AS slug_40, p0_.date_dernier_statut AS date_dernier_statut_41, p0_.duree AS duree_42, p0_.bool_actu AS bool_actu_43, p0_.grand_format AS grand_format_44, p0_.like_count AS like_count_45, p0_.comment_count AS comment_count_46, p0_.in_use AS in_use_47, p0_.edit_date AS edit_date_48, p0_.organisation4 AS organisation4_49, p0_.affichage_type_map AS affichage_type_map_50, p0_.affichage_type_map2 AS affichage_type_map2_51, p0_.affichage_type_map3 AS affichage_type_map3_52, p0_.musee_name AS musee_name_53, p0_.musee_id AS musee_id_54, p0_.order_folder AS order_folder_55, p0_.order_tag AS order_tag_56, p0_.openagenda_id AS openagenda_id_57, p0_.archive AS archive_58, p0_.date_update AS date_update_59, p0_.json AS json_60, p0_.openagenda_lieu AS openagenda_lieu_61, p0_.openagenda_name AS openagenda_name_62, p0_.markdown_description AS markdown_description_63, p0_.musee_type AS musee_type_64, p0_.page_dossiers AS page_dossiers_65, p1_.id AS id_66, p1_.type AS type_67, p1_.display_name AS display_name_68, p2_.id AS id_69, p2_.name AS name_70, p3_.id AS id_71, p3_.designation AS designation_72, p3_.code_hexa AS code_hexa_73, c4_.id AS id_74, c4_.designation AS designation_75, c4_.code_hexa AS code_hexa_76, c4_.code_hexa_dark AS code_hexa_dark_77, c5_.id AS id_78, c5_.designation AS designation_79, c5_.code_hexa AS code_hexa_80, c5_.code_hexa_dark AS code_hexa_dark_81, p6_.id AS id_82, p6_.illustrationfil_name AS illustrationfil_name_83, p6_.illustrationdetail_name AS illustrationdetail_name_84, p6_.document_name1 AS document_name1_85, p6_.document_name2 AS document_name2_86, p6_.document_name3 AS document_name3_87, p6_.image_url AS image_url_88, p6_.thumb_url AS thumb_url_89, p6_.title AS title_90, p6_.short_description AS short_description_91, p6_.content_duration AS content_duration_92, p6_.restriction AS restriction_93, p6_.state AS state_94, p6_.suggested_by AS suggested_by_95, p6_.published_at AS published_at_96, p6_.created_at AS created_at_97, p6_.updated_at AS updated_at_98, p6_.link1 AS link1_99, p6_.url1 AS url1_100, p6_.link2 AS link2_101, p6_.url2 AS url2_102, p6_.link3 AS link3_103, p6_.url3 AS url3_104, p6_.date_debut AS date_debut_105, p6_.date_fin AS date_fin_106, p6_.commentaires AS commentaires_107, p6_.subtitle AS subtitle_108, p6_.chapo AS chapo_109, p6_.horaires AS horaires_110, p6_.tarifs AS tarifs_111, p6_.lieu AS lieu_112, p6_.ville AS ville_113, p6_.credits AS credits_114, p6_.content AS content_115, p6_.defaut_fil AS defaut_fil_116, p6_.epingle1 AS epingle1_117, p6_.epingle2 AS epingle2_118, p6_.organized_by AS organized_by_119, p6_.bool_date_maj AS bool_date_maj_120, p6_.updated_date_display AS updated_date_display_121, p6_.slug AS slug_122, p6_.date_dernier_statut AS date_dernier_statut_123, p6_.duree AS duree_124, p6_.bool_actu AS bool_actu_125, p6_.grand_format AS grand_format_126, p6_.like_count AS like_count_127, p6_.comment_count AS comment_count_128, p6_.in_use AS in_use_129, p6_.edit_date AS edit_date_130, p6_.organisation4 AS organisation4_131, p6_.affichage_type_map AS affichage_type_map_132, p6_.affichage_type_map2 AS affichage_type_map2_133, p6_.affichage_type_map3 AS affichage_type_map3_134, p6_.musee_name AS musee_name_135, p6_.musee_id AS musee_id_136, p6_.order_folder AS order_folder_137, p6_.order_tag AS order_tag_138, p6_.openagenda_id AS openagenda_id_139, p6_.archive AS archive_140, p6_.date_update AS date_update_141, p6_.json AS json_142, p6_.openagenda_lieu AS openagenda_lieu_143, p6_.openagenda_name AS openagenda_name_144, p6_.markdown_description AS markdown_description_145, p6_.musee_type AS musee_type_146, p6_.page_dossiers AS page_dossiers_147, p7_.id AS id_148, p7_.illustrationfil_name AS illustrationfil_name_149, p7_.illustrationdetail_name AS illustrationdetail_name_150, p7_.document_name1 AS document_name1_151, p7_.document_name2 AS document_name2_152, p7_.document_name3 AS document_name3_153, p7_.image_url AS image_url_154, p7_.thumb_url AS thumb_url_155, p7_.title AS title_156, p7_.short_description AS short_description_157, p7_.content_duration AS content_duration_158, p7_.restriction AS restriction_159, p7_.state AS state_160, p7_.suggested_by AS suggested_by_161, p7_.published_at AS published_at_162, p7_.created_at AS created_at_163, p7_.updated_at AS updated_at_164, p7_.link1 AS link1_165, p7_.url1 AS url1_166, p7_.link2 AS link2_167, p7_.url2 AS url2_168, p7_.link3 AS link3_169, p7_.url3 AS url3_170, p7_.date_debut AS date_debut_171, p7_.date_fin AS date_fin_172, p7_.commentaires AS commentaires_173, p7_.subtitle AS subtitle_174, p7_.chapo AS chapo_175, p7_.horaires AS horaires_176, p7_.tarifs AS tarifs_177, p7_.lieu AS lieu_178, p7_.ville AS ville_179, p7_.credits AS credits_180, p7_.content AS content_181, p7_.defaut_fil AS defaut_fil_182, p7_.epingle1 AS epingle1_183, p7_.epingle2 AS epingle2_184, p7_.organized_by AS organized_by_185, p7_.bool_date_maj AS bool_date_maj_186, p7_.updated_date_display AS updated_date_display_187, p7_.slug AS slug_188, p7_.date_dernier_statut AS date_dernier_statut_189, p7_.duree AS duree_190, p7_.bool_actu AS bool_actu_191, p7_.grand_format AS grand_format_192, p7_.like_count AS like_count_193, p7_.comment_count AS comment_count_194, p7_.in_use AS in_use_195, p7_.edit_date AS edit_date_196, p7_.organisation4 AS organisation4_197, p7_.affichage_type_map AS affichage_type_map_198, p7_.affichage_type_map2 AS affichage_type_map2_199, p7_.affichage_type_map3 AS affichage_type_map3_200, p7_.musee_name AS musee_name_201, p7_.musee_id AS musee_id_202, p7_.order_folder AS order_folder_203, p7_.order_tag AS order_tag_204, p7_.openagenda_id AS openagenda_id_205, p7_.archive AS archive_206, p7_.date_update AS date_update_207, p7_.json AS json_208, p7_.openagenda_lieu AS openagenda_lieu_209, p7_.openagenda_name AS openagenda_name_210, p7_.markdown_description AS markdown_description_211, p7_.musee_type AS musee_type_212, p7_.page_dossiers AS page_dossiers_213, p8_.id AS id_214, p8_.illustrationfil_name AS illustrationfil_name_215, p8_.illustrationdetail_name AS illustrationdetail_name_216, p8_.document_name1 AS document_name1_217, p8_.document_name2 AS document_name2_218, p8_.document_name3 AS document_name3_219, p8_.image_url AS image_url_220, p8_.thumb_url AS thumb_url_221, p8_.title AS title_222, p8_.short_description AS short_description_223, p8_.content_duration AS content_duration_224, p8_.restriction AS restriction_225, p8_.state AS state_226, p8_.suggested_by AS suggested_by_227, p8_.published_at AS published_at_228, p8_.created_at AS created_at_229, p8_.updated_at AS updated_at_230, p8_.link1 AS link1_231, p8_.url1 AS url1_232, p8_.link2 AS link2_233, p8_.url2 AS url2_234, p8_.link3 AS link3_235, p8_.url3 AS url3_236, p8_.date_debut AS date_debut_237, p8_.date_fin AS date_fin_238, p8_.commentaires AS commentaires_239, p8_.subtitle AS subtitle_240, p8_.chapo AS chapo_241, p8_.horaires AS horaires_242, p8_.tarifs AS tarifs_243, p8_.lieu AS lieu_244, p8_.ville AS ville_245, p8_.credits AS credits_246, p8_.content AS content_247, p8_.defaut_fil AS defaut_fil_248, p8_.epingle1 AS epingle1_249, p8_.epingle2 AS epingle2_250, p8_.organized_by AS organized_by_251, p8_.bool_date_maj AS bool_date_maj_252, p8_.updated_date_display AS updated_date_display_253, p8_.slug AS slug_254, p8_.date_dernier_statut AS date_dernier_statut_255, p8_.duree AS duree_256, p8_.bool_actu AS bool_actu_257, p8_.grand_format AS grand_format_258, p8_.like_count AS like_count_259, p8_.comment_count AS comment_count_260, p8_.in_use AS in_use_261, p8_.edit_date AS edit_date_262, p8_.organisation4 AS organisation4_263, p8_.affichage_type_map AS affichage_type_map_264, p8_.affichage_type_map2 AS affichage_type_map2_265, p8_.affichage_type_map3 AS affichage_type_map3_266, p8_.musee_name AS musee_name_267, p8_.musee_id AS musee_id_268, p8_.order_folder AS order_folder_269, p8_.order_tag AS order_tag_270, p8_.openagenda_id AS openagenda_id_271, p8_.archive AS archive_272, p8_.date_update AS date_update_273, p8_.json AS json_274, p8_.openagenda_lieu AS openagenda_lieu_275, p8_.openagenda_name AS openagenda_name_276, p8_.markdown_description AS markdown_description_277, p8_.musee_type AS musee_type_278, p8_.page_dossiers AS page_dossiers_279, l9_.id AS id_280, l9_.name AS name_281, l9_.adresse AS adresse_282, l9_.codepostal AS codepostal_283, l9_.ville AS ville_284, l9_.latitude AS latitude_285, l9_.longitude AS longitude_286, l9_.openagenda_id AS openagenda_id_287 FROM post p0_ INNER JOIN post_type p1_ ON p0_.type_id = p1_.id LEFT JOIN post_territory p11_ ON p0_.id = p11_.post_id LEFT JOIN territory t10_ ON t10_.id = p11_.territory_id LEFT JOIN post_fil p13_ ON p0_.id = p13_.post_id LEFT JOIN fil f12_ ON f12_.id = p13_.fil_id LEFT JOIN post_target_public p15_ ON p0_.id = p15_.post_id LEFT JOIN target_public t14_ ON t14_.id = p15_.target_public_id LEFT JOIN placement_image p2_ ON p0_.position_image_id = p2_.id LEFT JOIN palette_couleur p3_ ON p0_.palettecouleur_id = p3_.id LEFT JOIN couleur_de_post c4_ ON p0_.couleur_id = c4_.id LEFT JOIN couleur_de_post c5_ ON p0_.couleur_texte_id = c5_.id LEFT JOIN post p6_ ON p0_.related_post1_id = p6_.id LEFT JOIN post p7_ ON p0_.related_post2_id = p7_.id LEFT JOIN post p8_ ON p0_.related_post3_id = p8_.id LEFT JOIN lieu l9_ ON p0_.lieu_new_id = l9_.id INNER JOIN statut s16_ ON p0_.status_id = s16_.id WHERE p0_.type_id IN (?, ?, ?, ?) AND (t14_.id IS NULL OR t14_.id = ?) AND ((STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') < ? AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y') > ?) OR (STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') > ? AND STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') < ?) OR (STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') >= ?) OR p0_.type_id <> ?) AND s16_.id = 5 AND (f12_.id IS NULL OR f12_.kind = ?) ORDER BY p0_.epingle1 DESC, p0_.epingle2 DESC, CASE WHEN STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') >= CURRENT_DATE THEN 0 ELSE 1 END ASC, CASE WHEN STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') >= CURRENT_DATE THEN UNIX_TIMESTAMP(STR_TO_DATE(p0_.date_debut, '%d/%m/%Y')) ELSE -UNIX_TIMESTAMP(STR_TO_DATE(p0_.date_debut, '%d/%m/%Y')) END ASC LIMIT 50"
  "params" => [
    1 => 3
    2 => 6
    3 => 7
    4 => 9
    5 => 1
    6 => "2025-12-06 03:10:00"
    7 => "2025-12-06 03:10:00"
    8 => "2025-12-06 03:10:00"
    9 => "2025-12-08 03:10:00"
    10 => "2025-12-06 03:10:00"
    11 => 3
    12 => "agenda"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 1
    12 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1 FROM target_public t0_ LEFT JOIN post_target_public p2_ ON t0_.id = p2_.target_public_id LEFT JOIN post p1_ ON p1_.id = p2_.post_id WHERE p1_.id = ?"
  "params" => [
    1 => 9174
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.texte AS texte_1, p0_.count AS count_2, p0_.valide AS valide_3 FROM post_reponses p0_ LEFT JOIN post_post_reponses p2_ ON p0_.id = p2_.post_reponses_id LEFT JOIN post p1_ ON p1_.id = p2_.post_id WHERE p1_.id = ?"
  "params" => [
    1 => 9174
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1 FROM target_public t0_ LEFT JOIN post_target_public p2_ ON t0_.id = p2_.target_public_id LEFT JOIN post p1_ ON p1_.id = p2_.post_id WHERE p1_.id = ?"
  "params" => [
    1 => 8136
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1 FROM target_public t0_ LEFT JOIN post_target_public p2_ ON t0_.id = p2_.target_public_id LEFT JOIN post p1_ ON p1_.id = p2_.post_id WHERE p1_.id = ?"
  "params" => [
    1 => 8135
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.texte AS texte_1, p0_.count AS count_2, p0_.valide AS valide_3 FROM post_reponses p0_ LEFT JOIN post_post_reponses p2_ ON p0_.id = p2_.post_reponses_id LEFT JOIN post p1_ ON p1_.id = p2_.post_id WHERE p1_.id = ?"
  "params" => [
    1 => 8135
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1 FROM target_public t0_ LEFT JOIN post_target_public p2_ ON t0_.id = p2_.target_public_id LEFT JOIN post p1_ ON p1_.id = p2_.post_id WHERE p1_.id = ?"
  "params" => [
    1 => 7954
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1 FROM target_public t0_ LEFT JOIN post_target_public p2_ ON t0_.id = p2_.target_public_id LEFT JOIN post p1_ ON p1_.id = p2_.post_id WHERE p1_.id = ?"
  "params" => [
    1 => 7038
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1 FROM target_public t0_ LEFT JOIN post_target_public p2_ ON t0_.id = p2_.target_public_id LEFT JOIN post p1_ ON p1_.id = p2_.post_id WHERE p1_.id = ?"
  "params" => [
    1 => 6729
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1 FROM target_public t0_ LEFT JOIN post_target_public p2_ ON t0_.id = p2_.target_public_id LEFT JOIN post p1_ ON p1_.id = p2_.post_id WHERE p1_.id = ?"
  "params" => [
    1 => 6730
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1 FROM target_public t0_ LEFT JOIN post_target_public p2_ ON t0_.id = p2_.target_public_id LEFT JOIN post p1_ ON p1_.id = p2_.post_id WHERE p1_.id = ?"
  "params" => [
    1 => 7369
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ LEFT JOIN post_territory p2_ ON p0_.id = p2_.post_id LEFT JOIN territory t1_ ON t1_.id = p2_.territory_id LEFT JOIN post_fil p4_ ON p0_.id = p4_.post_id LEFT JOIN fil f3_ ON f3_.id = p4_.fil_id LEFT JOIN post_target_public p6_ ON p0_.id = p6_.post_id LEFT JOIN target_public t5_ ON t5_.id = p6_.target_public_id INNER JOIN statut s7_ ON p0_.status_id = s7_.id WHERE p0_.type_id IN (?, ?, ?, ?) AND (t5_.id IS NULL OR t5_.id = ?) AND ((STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') < ? AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') > ?) OR (STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') > ? AND STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') < ?) OR (STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') > ?) OR p0_.type_id <> ?) AND s7_.id = 5 AND (f3_.id IS NULL OR f3_.kind = ?) AND (p0_.page_dossiers = ? OR p0_.page_dossiers IS NULL) ORDER BY p0_.epingle1 DESC, p0_.epingle2 DESC, CASE WHEN STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') >= CURRENT_DATE THEN 0 ELSE 1 END ASC, CASE WHEN STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') >= CURRENT_DATE THEN UNIX_TIMESTAMP(STR_TO_DATE(p0_.date_debut, '%d/%m/%Y')) ELSE -UNIX_TIMESTAMP(STR_TO_DATE(p0_.date_debut, '%d/%m/%Y')) END ASC LIMIT 300"
  "params" => [
    1 => 3
    2 => 6
    3 => 7
    4 => 9
    5 => 1
    6 => "2025-12-06 03:10:00"
    7 => "2025-12-06 03:10:00"
    8 => "2025-12-06 03:10:00"
    9 => "2025-12-08 03:10:00"
    10 => "2025-12-06 03:10:00"
    11 => 3
    12 => "agenda"
    13 => 0
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 1
    12 => 2
    13 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.active AS active_3, t0.couleur AS couleur_4, t0.contenu AS contenu_5, t0.visible_nordinfo AS visible_nordinfo_6, t0.visible_lenord AS visible_lenord_7, t0.visible_services AS visible_services_8, t0.visible_section_politiques AS visible_section_politiques_9, t0.visible_section_institution AS visible_section_institution_10, t0.visible_section_services AS visible_section_services_11, t0.visible_accueil_lenord AS visible_accueil_lenord_12, t0.visible_accueil_services AS visible_accueil_services_13, t0.visible_espace_documentaire AS visible_espace_documentaire_14, t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15, t0.visible_pages_legales_services AS visible_pages_legales_services_16, t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17, t0.visible_glossaire_lenord AS visible_glossaire_lenord_18, t0.visible_glossaire_services AS visible_glossaire_services_19, t0.visible_mesinfos AS visible_mesinfos_20, t0.visible_a_la_une AS visible_a_la_une_21, t0.visible_agenda AS visible_agenda_22, t0.visible_videos AS visible_videos_23, t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24, t0.visible_cartographie AS visible_cartographie_25, t0.color_id AS color_id_26 FROM epingle t0 WHERE t0.active = ? AND t0.visible_nordinfo = ?"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 5
    2 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.active AS active_3, t0.couleur AS couleur_4, t0.contenu AS contenu_5, t0.visible_nordinfo AS visible_nordinfo_6, t0.visible_lenord AS visible_lenord_7, t0.visible_services AS visible_services_8, t0.visible_section_politiques AS visible_section_politiques_9, t0.visible_section_institution AS visible_section_institution_10, t0.visible_section_services AS visible_section_services_11, t0.visible_accueil_lenord AS visible_accueil_lenord_12, t0.visible_accueil_services AS visible_accueil_services_13, t0.visible_espace_documentaire AS visible_espace_documentaire_14, t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15, t0.visible_pages_legales_services AS visible_pages_legales_services_16, t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17, t0.visible_glossaire_lenord AS visible_glossaire_lenord_18, t0.visible_glossaire_services AS visible_glossaire_services_19, t0.visible_mesinfos AS visible_mesinfos_20, t0.visible_a_la_une AS visible_a_la_une_21, t0.visible_agenda AS visible_agenda_22, t0.visible_videos AS visible_videos_23, t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24, t0.visible_cartographie AS visible_cartographie_25, t0.color_id AS color_id_26 FROM epingle t0 WHERE t0.active = ? AND t0.visible_agenda = ?"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 5
    2 => 5
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.url AS url_2, f0_.fichier_name AS fichier_name_3, f0_.ordre_lenord AS ordre_lenord_4, f0_.ordre_services AS ordre_services_5, f0_.date_update AS date_update_6, f0_.ordre_info AS ordre_info_7 FROM footer_sites f0_ WHERE f0_.ordre_info IS NOT NULL ORDER BY f0_.ordre_info ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.libelle AS libelle_3, t0.kind AS kind_4, t0.type_api AS type_api_5, t0.url AS url_6 FROM menu_libelle t0 WHERE t0.ordre = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT m0_.libelle AS libelle_0, m0_.url AS url_1 FROM menu_libelle m0_ WHERE m0_.ordre <> 0 ORDER BY m0_.ordre ASC"
]