https://lenord.spontaneit.fr/espace-documentaire/arrete-dv2024m0014-16-mai-2024

Query Metrics

7 Database Queries
7 Different statements
5.51 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.93 ms
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 = ?
Parameters:
[
  1
]
2 0.99 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.fichier_name AS fichier_name_4, t0.content AS content_5, t0.date_publication AS date_publication_6, t0.format_file AS format_file_7, t0.poids AS poids_8, t0.date_update AS date_update_9, t0.fichier_name2 AS fichier_name2_10, t0.fichier_name3 AS fichier_name3_11, t0.fichier_name4 AS fichier_name4_12, t0.url_fichier_ext AS url_fichier_ext_13, t0.alias_url AS alias_url_14, t0.description_accessibilite AS description_accessibilite_15, t0.libelle_fichier1 AS libelle_fichier1_16, t0.libelle_fichier2 AS libelle_fichier2_17, t0.libelle_fichier3 AS libelle_fichier3_18, t0.libelle_fichier4 AS libelle_fichier4_19, t0.fichier_name5 AS fichier_name5_20, t0.fichier_name6 AS fichier_name6_21, t0.libelle_fichier5 AS libelle_fichier5_22, t0.libelle_fichier6 AS libelle_fichier6_23, t0.poids2 AS poids2_24, t0.poids3 AS poids3_25, t0.poids4 AS poids4_26, t0.poids5 AS poids5_27, t0.poids6 AS poids6_28, t0.format_file2 AS format_file2_29, t0.format_file3 AS format_file3_30, t0.format_file4 AS format_file4_31, t0.format_file5 AS format_file5_32, t0.format_file6 AS format_file6_33, t0.annexe_url AS annexe_url_34, t0.import AS import_35, t0.statut_id AS statut_id_36 FROM document t0 WHERE t0.alias_url = ? LIMIT 1
Parameters:
[
  "arrete-dv2024m0014-16-mai-2024"
]
3 0.80 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.fichier_name AS fichier_name_4, t0.content AS content_5, t0.date_publication AS date_publication_6, t0.format_file AS format_file_7, t0.poids AS poids_8, t0.date_update AS date_update_9, t0.fichier_name2 AS fichier_name2_10, t0.fichier_name3 AS fichier_name3_11, t0.fichier_name4 AS fichier_name4_12, t0.url_fichier_ext AS url_fichier_ext_13, t0.alias_url AS alias_url_14, t0.description_accessibilite AS description_accessibilite_15, t0.libelle_fichier1 AS libelle_fichier1_16, t0.libelle_fichier2 AS libelle_fichier2_17, t0.libelle_fichier3 AS libelle_fichier3_18, t0.libelle_fichier4 AS libelle_fichier4_19, t0.fichier_name5 AS fichier_name5_20, t0.fichier_name6 AS fichier_name6_21, t0.libelle_fichier5 AS libelle_fichier5_22, t0.libelle_fichier6 AS libelle_fichier6_23, t0.poids2 AS poids2_24, t0.poids3 AS poids3_25, t0.poids4 AS poids4_26, t0.poids5 AS poids5_27, t0.poids6 AS poids6_28, t0.format_file2 AS format_file2_29, t0.format_file3 AS format_file3_30, t0.format_file4 AS format_file4_31, t0.format_file5 AS format_file5_32, t0.format_file6 AS format_file6_33, t0.annexe_url AS annexe_url_34, t0.import AS import_35, t0.statut_id AS statut_id_36 FROM document t0 INNER JOIN document_document ON t0.id = document_document.document_target WHERE document_document.document_source = ?
Parameters:
[
  460
]
4 0.58 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.name_ged AS name_ged_3 FROM type_document t0 INNER JOIN document_type_document ON t0.id = document_type_document.type_document_id WHERE document_type_document.document_id = ?
Parameters:
[
  460
]
5 0.86 ms
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_ INNER JOIN document_type_document d2_ ON d0_.id = d2_.document_id INNER JOIN type_document t1_ ON t1_.id = d2_.type_document_id WHERE d0_.id <> ? AND t1_.id = ? LIMIT 3
Parameters:
[
  460
  1
]
6 0.72 ms
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 = ?
Parameters:
[
  1
  1
]
7 0.62 ms
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 INNER JOIN epingle_document ON t0.id = epingle_document.epingle_id WHERE epingle_document.document_id = ?
Parameters:
[
  460
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Footer No errors.
App\Entity\Document No errors.
App\Entity\Statut No errors.
App\Entity\TypeDocument No errors.
App\Entity\PolitiqueDepartementale No errors.
App\Entity\Epingle No errors.
App\Entity\PageSatellite No errors.
App\Entity\EpingleColor No errors.