Symfony Profiler

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

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

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.name_ged AS name_ged_3
FROM
  type_document t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.name_ged AS name_ged_3 FROM type_document t0;

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  document d0_
WHERE
  d0_.statut_id = 5
  AND (
    d0_.titre LIKE ?
    OR d0_.description LIKE ?
  )
  AND EXISTS (
    SELECT
      1
    FROM
      document_type_document d1_
    WHERE
      d1_.document_id = d0_.id
      AND d1_.type_document_id IN (?)
  )

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.statut_id = 5 AND (d0_.titre LIKE '%%' OR d0_.description LIKE '%%') AND EXISTS (SELECT 1 FROM document_type_document d1_ WHERE d1_.document_id = d0_.id AND d1_.type_document_id IN ('2'));

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.date_publication AS date_publication_1
FROM
  document d0_
WHERE
  d0_.statut_id = 5
  AND (
    d0_.titre LIKE ?
    OR d0_.description LIKE ?
  )
  AND EXISTS (
    SELECT
      1
    FROM
      document_type_document d1_
    WHERE
      d1_.document_id = d0_.id
      AND d1_.type_document_id IN (?)
  )
ORDER BY
  d0_.date_publication DESC
LIMIT
  24

SELECT DISTINCT d0_.id AS id_0, d0_.date_publication AS date_publication_1 FROM document d0_ WHERE d0_.statut_id = 5 AND (d0_.titre LIKE '%%' OR d0_.description LIKE '%%') AND EXISTS (SELECT 1 FROM document_type_document d1_ WHERE d1_.document_id = d0_.id AND d1_.type_document_id IN ('2')) ORDER BY d0_.date_publication DESC LIMIT 24;

SELECT
  d0_.id AS id_0,
  d0_.titre AS titre_1,
  d0_.description AS description_2,
  d0_.fichier_name AS fichier_name_3,
  d0_.content AS content_4,
  d0_.date_publication AS date_publication_5,
  d0_.format_file AS format_file_6,
  d0_.poids AS poids_7,
  d0_.date_update AS date_update_8,
  d0_.fichier_name2 AS fichier_name2_9,
  d0_.fichier_name3 AS fichier_name3_10,
  d0_.fichier_name4 AS fichier_name4_11,
  d0_.url_fichier_ext AS url_fichier_ext_12,
  d0_.alias_url AS alias_url_13,
  d0_.description_accessibilite AS description_accessibilite_14,
  d0_.libelle_fichier1 AS libelle_fichier1_15,
  d0_.libelle_fichier2 AS libelle_fichier2_16,
  d0_.libelle_fichier3 AS libelle_fichier3_17,
  d0_.libelle_fichier4 AS libelle_fichier4_18,
  d0_.fichier_name5 AS fichier_name5_19,
  d0_.fichier_name6 AS fichier_name6_20,
  d0_.libelle_fichier5 AS libelle_fichier5_21,
  d0_.libelle_fichier6 AS libelle_fichier6_22,
  d0_.poids2 AS poids2_23,
  d0_.poids3 AS poids3_24,
  d0_.poids4 AS poids4_25,
  d0_.poids5 AS poids5_26,
  d0_.poids6 AS poids6_27,
  d0_.format_file2 AS format_file2_28,
  d0_.format_file3 AS format_file3_29,
  d0_.format_file4 AS format_file4_30,
  d0_.format_file5 AS format_file5_31,
  d0_.format_file6 AS format_file6_32,
  d0_.annexe_url AS annexe_url_33,
  d0_.import AS import_34,
  d0_.statut_id AS statut_id_35
FROM
  document d0_
WHERE
  d0_.statut_id = 5
  AND (
    d0_.titre LIKE ?
    OR d0_.description LIKE ?
  )
  AND EXISTS (
    SELECT
      1
    FROM
      document_type_document d1_
    WHERE
      d1_.document_id = d0_.id
      AND d1_.type_document_id IN (?)
  )
  AND d0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  d0_.date_publication DESC

SELECT d0_.id AS id_0, d0_.titre AS titre_1, d0_.description AS description_2, d0_.fichier_name AS fichier_name_3, d0_.content AS content_4, d0_.date_publication AS date_publication_5, d0_.format_file AS format_file_6, d0_.poids AS poids_7, d0_.date_update AS date_update_8, d0_.fichier_name2 AS fichier_name2_9, d0_.fichier_name3 AS fichier_name3_10, d0_.fichier_name4 AS fichier_name4_11, d0_.url_fichier_ext AS url_fichier_ext_12, d0_.alias_url AS alias_url_13, d0_.description_accessibilite AS description_accessibilite_14, d0_.libelle_fichier1 AS libelle_fichier1_15, d0_.libelle_fichier2 AS libelle_fichier2_16, d0_.libelle_fichier3 AS libelle_fichier3_17, d0_.libelle_fichier4 AS libelle_fichier4_18, d0_.fichier_name5 AS fichier_name5_19, d0_.fichier_name6 AS fichier_name6_20, d0_.libelle_fichier5 AS libelle_fichier5_21, d0_.libelle_fichier6 AS libelle_fichier6_22, d0_.poids2 AS poids2_23, d0_.poids3 AS poids3_24, d0_.poids4 AS poids4_25, d0_.poids5 AS poids5_26, d0_.poids6 AS poids6_27, d0_.format_file2 AS format_file2_28, d0_.format_file3 AS format_file3_29, d0_.format_file4 AS format_file4_30, d0_.format_file5 AS format_file5_31, d0_.format_file6 AS format_file6_32, d0_.annexe_url AS annexe_url_33, d0_.import AS import_34, d0_.statut_id AS statut_id_35 FROM document d0_ WHERE d0_.statut_id = 5 AND (d0_.titre LIKE '%%' OR d0_.description LIKE '%%') AND EXISTS (SELECT 1 FROM document_type_document d1_ WHERE d1_.document_id = d0_.id AND d1_.type_document_id IN ('2')) AND d0_.id IN (546, 528, 516, 459, 458, 455, 453, 445, 444, 443, 442, 441, 437, 436, 434, 428, 426, 425, 424, 423, 422, 421, 420, 419) ORDER BY d0_.date_publication DESC;

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_lenord IS NOT NULL
ORDER BY
  f0_.ordre_lenord ASC

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_lenord IS NOT NULL ORDER BY f0_.ordre_lenord ASC;

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

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 = 1 AND t0.visible_lenord = 1;

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

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 = 1 AND t0.visible_espace_documentaire = 1;