Query Metrics
6
Database Queries
6
Different statements
7.97 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.95 ms (49.54%) |
1 |
SELECT t0.id AS id_1, t0.canton AS canton_2, t0.territoire AS territoire_3, t0.communes AS communes_4, t0.multipoints AS multipoints_5, t0.territory_id AS territory_id_6 FROM cantons t0
Parameters:
[] |
1.11 ms (13.92%) |
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_nordinfo = ?
Parameters:
[ 1 1 ] |
0.98 ms (12.25%) |
1 |
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_.type = ? AND c0_.active = ? ORDER BY c0_.last_name ASC
Parameters:
[ "admin" 1 ] |
0.72 ms (9.02%) |
1 |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.libelle AS libelle_3, t0.kind AS kind_4, t0.type_api AS type_api_5, t0.url AS url_6 FROM menu_libelle t0 WHERE t0.ordre = ?
Parameters:
[
0
]
|
0.63 ms (7.94%) |
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
]
|
0.58 ms (7.33%) |
1 |
SELECT m0_.libelle AS libelle_0, m0_.url AS url_1 FROM menu_libelle m0_ WHERE m0_.ordre <> 0 ORDER BY m0_.ordre ASC
Parameters:
[] |
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\MenuLibelle | No errors. |
App\Entity\Footer | No errors. |
App\Entity\Cantons | No errors. |
App\Entity\Territory | No errors. |
App\Entity\Contact | No errors. |
App\Entity\TypeContact | No errors. |
App\Entity\Post | No errors. |
App\Entity\Pages | No errors. |
App\Entity\Citation | No errors. |
App\Entity\PolitiqueDepartementale | No errors. |
App\Entity\PageSatellite | No errors. |
App\Entity\Epingle | No errors. |
App\Entity\EpingleColor | No errors. |