Query Metrics
8
Database Queries
8
Different statements
7.29 ms
Query time
0
Invalid entities
Queries
| #▲ | 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Footer | No errors. |
| App\Entity\PageAccueilService | No errors. |
| App\Entity\RssArticle | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Statut | No errors. |
| App\Entity\ServiceGrandProfil | No errors. |
| App\Entity\ServiceSousProfil | No errors. |
| App\Entity\ServiceTheme | No errors. |
| App\Entity\PolitiqueDepartementale | No errors. |
| App\Entity\Epingle | No errors. |
| App\Entity\ServiceFeedback | No errors. |
| App\Entity\PageSatellite | No errors. |
| App\Entity\ServiceFocusPub | No errors. |
| App\Entity\FooterSites | No errors. |
| App\Entity\EpingleColor | No errors. |