Query Metrics
7
Database Queries
5
Different statements
962.47 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 18.76 ms |
SELECT v0_.id AS id_0, v0_.code_insee AS code_insee_1, v0_.nom_postal AS nom_postal_2, v0_.code_postal AS code_postal_3, v0_.libelle_acheminement AS libelle_acheminement_4, v0_.ancienne_commune_lieu_dit AS ancienne_commune_lieu_dit_5, v0_.latitude AS latitude_6, v0_.longitude AS longitude_7, v0_.code AS code_8, v0_.article AS article_9, v0_.nom AS nom_10, v0_.nom_complet AS nom_complet_11, v0_.slug AS slug_12, v0_.slug_complet AS slug_complet_13, v0_.slug_ancienne_commune_lieu_dit AS slug_ancienne_commune_lieu_dit_14, v0_.calcul AS calcul_15, v0_.evolution AS evolution_16, v0_.ratio AS ratio_17, v0_.ratio_min AS ratio_min_18, v0_.ratio_max AS ratio_max_19, v0_.insee AS insee_20, v0_.chart AS chart_21, v0_.departement_id AS departement_id_22 FROM ville v0_ WHERE v0_.code_postal = ? AND (v0_.slug = ? OR v0_.slug_complet = ? OR v0_.slug_ancienne_commune_lieu_dit = ?) LIMIT 1
Parameters:
[ "78740" "evecquemont" "evecquemont" "evecquemont" ] |
2 | 878.99 ms |
SELECT v0_.id AS id_0, v0_.code_insee AS code_insee_1, v0_.nom_postal AS nom_postal_2, v0_.code_postal AS code_postal_3, v0_.libelle_acheminement AS libelle_acheminement_4, v0_.ancienne_commune_lieu_dit AS ancienne_commune_lieu_dit_5, v0_.latitude AS latitude_6, v0_.longitude AS longitude_7, v0_.code AS code_8, v0_.article AS article_9, v0_.nom AS nom_10, v0_.nom_complet AS nom_complet_11, v0_.slug AS slug_12, v0_.slug_complet AS slug_complet_13, v0_.slug_ancienne_commune_lieu_dit AS slug_ancienne_commune_lieu_dit_14, v0_.calcul AS calcul_15, v0_.evolution AS evolution_16, v0_.ratio AS ratio_17, v0_.ratio_min AS ratio_min_18, v0_.ratio_max AS ratio_max_19, v0_.insee AS insee_20, v0_.chart AS chart_21, v0_.departement_id AS departement_id_22 FROM ville v0_
Parameters:
[] |
3 | 16.18 ms |
SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type != 'VIEW'
Parameters:
[] |
4 | 10.57 ms |
SELECT nspname FROM pg_namespace WHERE nspname !~ '^pg_.*' AND nspname != 'information_schema'
Parameters:
[] |
5 | 10.48 ms |
SHOW search_path
Parameters:
[] |
6 | 13.16 ms |
SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type != 'VIEW'
Parameters:
[] |
7 | 14.33 ms |
SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type != 'VIEW'
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\Ville | No errors. |
App\Entity\Departement | No errors. |
App\Entity\Region | No errors. |
App\Entity\Pmc | No errors. |
App\Entity\PmcDepartement | No errors. |