Symfony Profiler

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

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 = '95560' AND (v0_.slug = 'montsoult' OR v0_.slug_complet = 'montsoult' OR v0_.slug_ancienne_commune_lieu_dit = 'montsoult') LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.year AS year_2,
  p0_.min_prix AS min_prix_3,
  p0_.prix AS prix_4,
  p0_.max_prix AS max_prix_5,
  p0_.nb_mutation AS nb_mutation_6,
  p0_.moyenne AS moyenne_7,
  p0_.moyenne_median AS moyenne_median_8,
  p0_.location AS location_9,
  p0_.pondere AS pondere_10,
  p0_.url_chart AS url_chart_11,
  p0_.discr AS discr_12,
  p1_.ville_id AS ville_id_13
FROM
  pmc_ville p1_
  INNER JOIN pmc p0_ ON p1_.id = p0_.id
  LEFT JOIN ville v2_ ON p1_.ville_id = v2_.id
WHERE
  p1_.ville_id = ?
ORDER BY
  p0_.year DESC

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.year AS year_2, p0_.min_prix AS min_prix_3, p0_.prix AS prix_4, p0_.max_prix AS max_prix_5, p0_.nb_mutation AS nb_mutation_6, p0_.moyenne AS moyenne_7, p0_.moyenne_median AS moyenne_median_8, p0_.location AS location_9, p0_.pondere AS pondere_10, p0_.url_chart AS url_chart_11, p0_.discr AS discr_12, p1_.ville_id AS ville_id_13 FROM pmc_ville p1_ INNER JOIN pmc p0_ ON p1_.id = p0_.id LEFT JOIN ville v2_ ON p1_.ville_id = v2_.id WHERE p1_.ville_id = 38657 ORDER BY p0_.year DESC;