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_

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_;

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'

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';

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

SELECT
  nspname
FROM
  pg_namespace
WHERE
  nspname ! ~ '^pg_.*'
  AND nspname != 'information_schema'

SELECT nspname FROM pg_namespace WHERE nspname !~ '^pg_.*' AND nspname != 'information_schema';

SHOW search_path

SHOW search_path;