https://pmc.immo-diffusion.eu/api/pmc?cp=78740&ville_slug=evecquemont

Query Metrics

2 Database Queries
2 Different statements
897.74 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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:
[]

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.