Query Metrics
6
Database Queries
6
Different statements
6.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.27 ms (19.03%) |
1 |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.picture AS picture_4, t0.short_description AS short_description_5, t0.long_description AS long_description_6, t0.display_address AS display_address_7, t0.email AS email_8, t0.phone AS phone_9, t0.acceo AS acceo_10, t0.link_1 AS link_1_11, t0.link_2 AS link_2_12, t0.rue AS rue_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.lat AS lat_16, t0.lng AS lng_17, t0.type AS type_18, t0.slug AS slug_19, t0.date_update AS date_update_20, t0.active AS active_21, t0.civilite AS civilite_22, t0.territory_id AS territory_id_23, t0.canton_id AS canton_id_24, t0.type_contact_id AS type_contact_id_25 FROM contact t0 INNER JOIN politique_departementale_contact ON t0.id = politique_departementale_contact.contact_id WHERE politique_departementale_contact.politique_departementale_id = ?
Parameters:
[
5
]
|
|
1.25 ms (18.67%) |
1 |
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
]
|
|
1.18 ms (17.65%) |
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_lenord = ?
Parameters:
[ 1 1 ] |
|
1.12 ms (16.80%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.pictogramme AS pictogramme_3, t0.alias_url AS alias_url_4, t0.sommaire_affiche AS sommaire_affiche_5, t0.date_update AS date_update_6, t0.content AS content_7, t0.ordre AS ordre_8, t0.chapo AS chapo_9, t0.nordinfo_rss_id AS nordinfo_rss_id_10, t0.statut_id AS statut_id_11 FROM politique_departementale t0 WHERE t0.alias_url = ? LIMIT 1
Parameters:
[
"education-colleges-"
]
|
|
1.01 ms (15.15%) |
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_section_politiques = ?
Parameters:
[ 1 1 ] |
|
0.85 ms (12.71%) |
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 INNER JOIN epingle_politique_departementale ON t0.id = epingle_politique_departementale.epingle_id WHERE epingle_politique_departementale.politique_departementale_id = ?
Parameters:
[
5
]
|
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\PolitiqueDepartementale | No errors. |
| App\Entity\RssArticle | No errors. |
| App\Entity\Statut | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Epingle | No errors. |
| App\Entity\EpingleColor | No errors. |
| App\Entity\Territory | No errors. |
| App\Entity\Cantons | No errors. |
| App\Entity\TypeContact | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\Pages | No errors. |
| App\Entity\Citation | No errors. |
| App\Entity\PageSatellite | No errors. |