Query Metrics
7
Database Queries
7
Different statements
5.77 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.90 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.96 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-sur-la-dotation-a-lehpad-de-sainghin-en-weppes"
]
|
| 3 | 0.91 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:
[
22
]
|
| 4 | 0.68 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:
[
22
]
|
| 5 | 0.88 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:
[ 22 1 ] |
| 6 | 0.81 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.63 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:
[
22
]
|
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. |