https://serviceslenord.spontaneit.fr/

Query Metrics

8 Database Queries
8 Different statements
7.29 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.04 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 1.03 ms
SELECT t0.id AS id_1, t0.presentation AS presentation_2, t0.url_rss_nordinfo_id AS url_rss_nordinfo_id_3 FROM page_accueil_service t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.96 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image_name AS image_name_3, t0.image_url AS image_url_4, t0.chapo AS chapo_5, t0.url AS url_6, t0.content AS content_7, t0.nombre_visite AS nombre_visite_8, t0.avis_positif AS avis_positif_9, t0.avis_negatif AS avis_negatif_10, t0.date_update AS date_update_11, t0.alias_url AS alias_url_12, t0.order_service AS order_service_13, t0.view_count AS view_count_14, t0.statut_id AS statut_id_15 FROM service t0 INNER JOIN page_accueil_service_service ON t0.id = page_accueil_service_service.service_id WHERE page_accueil_service_service.page_accueil_service_id = ?
Parameters:
[
  1
]
4 1.09 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image_name AS image_name_3, t0.image_url AS image_url_4, t0.chapo AS chapo_5, t0.url AS url_6, t0.content AS content_7, t0.nombre_visite AS nombre_visite_8, t0.avis_positif AS avis_positif_9, t0.avis_negatif AS avis_negatif_10, t0.date_update AS date_update_11, t0.alias_url AS alias_url_12, t0.order_service AS order_service_13, t0.view_count AS view_count_14, t0.statut_id AS statut_id_15 FROM service t0 WHERE t0.statut_id = ? ORDER BY t0.view_count DESC LIMIT 9
Parameters:
[
  5
]
5 0.81 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.alias_url AS alias_url_3, t0.grandprofil_id AS grandprofil_id_4 FROM service_sous_profil t0
Parameters:
[]
6 0.88 ms
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_services IS NOT NULL ORDER BY f0_.ordre_services ASC
Parameters:
[]
7 0.77 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_services = ?
Parameters:
[
  1
  1
]
8 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_accueil_services = ?
Parameters:
[
  1
  1
]

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.