Query Metrics
19
Database Queries
5
Different statements
14.24 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.92 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.00 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.titre AS titre_3, t0.meta_titre AS meta_titre_4, t0.meta_description AS meta_description_5, t0.date_updated AS date_updated_6, t0.content AS content_7, t0.actif AS actif_8, t0.credits AS credits_9, t0.document_name1 AS document_name1_10, t0.document_name2 AS document_name2_11, t0.document_name3 AS document_name3_12, t0.link1 AS link1_13, t0.url1 AS url1_14, t0.link2 AS link2_15, t0.url2 AS url2_16, t0.link3 AS link3_17, t0.url3 AS url3_18, t0.ordre AS ordre_19, t0.nordinfo AS nordinfo_20, t0.lenord AS lenord_21, t0.alias_url AS alias_url_22, t0.url_icone AS url_icone_23, t0.sommaire_affiche AS sommaire_affiche_24, t0.contact1_id AS contact1_id_25, t0.contact2_id AS contact2_id_26, t0.contact3_id AS contact3_id_27, t0.organisation1_id AS organisation1_id_28, t0.organisation2_id AS organisation2_id_29, t0.organisation3_id AS organisation3_id_30, t0.related_post1_id AS related_post1_id_31, t0.related_post2_id AS related_post2_id_32, t0.related_post3_id AS related_post3_id_33, t0.nordinfo_rss_id AS nordinfo_rss_id_34 FROM pages t0 WHERE t0.alias_url = ? AND t0.actif = ? AND t0.lenord = ? LIMIT 1
Parameters:
[ "les-vice-presidents" 1 1 ] |
| 3 | 0.89 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
105
]
|
| 4 | 0.60 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
144
]
|
| 5 | 0.54 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
124
]
|
| 6 | 0.52 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
152
]
|
| 7 | 0.55 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
149
]
|
| 8 | 0.56 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
136
]
|
| 9 | 0.50 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
161
]
|
| 10 | 0.55 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
86
]
|
| 11 | 0.56 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
95
]
|
| 12 | 0.63 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
126
]
|
| 13 | 0.59 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
141
]
|
| 14 | 0.55 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
135
]
|
| 15 | 0.55 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
88
]
|
| 16 | 0.59 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
148
]
|
| 17 | 2.73 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.id = ?
Parameters:
[
127
]
|
| 18 | 0.64 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 ] |
| 19 | 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 INNER JOIN epingle_pages ON t0.id = epingle_pages.epingle_id WHERE epingle_pages.pages_id = ?
Parameters:
[
10
]
|
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\Pages | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Organization | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\RssArticle | No errors. |
| App\Entity\Epingle | No errors. |
| App\Entity\Territory | No errors. |
| App\Entity\Cantons | No errors. |
| App\Entity\TypeContact | No errors. |
| App\Entity\Citation | No errors. |
| App\Entity\PolitiqueDepartementale | No errors. |
| App\Entity\PageSatellite | No errors. |
| App\Entity\EpingleColor | No errors. |