Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.slug AS slug_4, t0.de_nom AS de_nom_5, t0.main_cities AS main_cities_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.region_id AS region_id_9 FROM department t0 WHERE t0.code = ? LIMIT 1

[
  "58"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.slug AS slug_4,
  t0.de_nom AS de_nom_5,
  t0.main_cities AS main_cities_6,
  t0.lat AS lat_7,
  t0.lng AS lng_8,
  t0.region_id AS region_id_9
FROM
  department t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.slug AS slug_4, t0.de_nom AS de_nom_5, t0.main_cities AS main_cities_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.region_id AS region_id_9 FROM department t0 WHERE t0.code = '58' LIMIT 1;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.legacy_department AS legacy_department_3, c0_.latitude AS latitude_4, c0_.longitude AS longitude_5, c0_.website AS website_6, c0_.departement_id AS departement_id_7 FROM city c0_ WHERE c0_.departement_id = ? AND ((LOWER(c0_.slug) = ?) OR (LOWER(c0_.name) = ?)) LIMIT 1

[
  58
  "chateau-chinon"
  "chateau-chinon"
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.legacy_department AS legacy_department_3,
  c0_.latitude AS latitude_4,
  c0_.longitude AS longitude_5,
  c0_.website AS website_6,
  c0_.departement_id AS departement_id_7
FROM
  city c0_
WHERE
  c0_.departement_id = ?
  AND (
    (
      LOWER(c0_.slug) = ?
    )
    OR (
      LOWER(c0_.name) = ?
    )
  )
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.legacy_department AS legacy_department_3, c0_.latitude AS latitude_4, c0_.longitude AS longitude_5, c0_.website AS website_6, c0_.departement_id AS departement_id_7 FROM city c0_ WHERE c0_.departement_id = 58 AND ((LOWER(c0_.slug) = 'chateau-chinon') OR (LOWER(c0_.name) = 'chateau-chinon')) LIMIT 1;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.legacy_department AS legacy_department_3, c0_.latitude AS latitude_4, c0_.longitude AS longitude_5, c0_.website AS website_6, c0_.departement_id AS departement_id_7 FROM city c0_ WHERE c0_.departement_id = ? AND LOWER(c0_.slug) LIKE ? LIMIT 1

[
  58
  "%chateau-chinon%"
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.legacy_department AS legacy_department_3,
  c0_.latitude AS latitude_4,
  c0_.longitude AS longitude_5,
  c0_.website AS website_6,
  c0_.departement_id AS departement_id_7
FROM
  city c0_
WHERE
  c0_.departement_id = ?
  AND LOWER(c0_.slug) LIKE ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.legacy_department AS legacy_department_3, c0_.latitude AS latitude_4, c0_.longitude AS longitude_5, c0_.website AS website_6, c0_.departement_id AS departement_id_7 FROM city c0_ WHERE c0_.departement_id = 58 AND LOWER(c0_.slug) LIKE '%chateau-chinon%' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.description_de AS description_de_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_es AS description_es_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9 FROM region_unofficial t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.description_de AS description_de_4,
  t0.description_fr AS description_fr_5,
  t0.description_en AS description_en_6,
  t0.description_es AS description_es_7,
  t0.image_name AS image_name_8,
  t0.updated_at AS updated_at_9
FROM
  region_unofficial t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.description_de AS description_de_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_es AS description_es_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9 FROM region_unofficial t0;

SELECT t0.id AS id_1, t0.weekday AS weekday_2, t0.time_from AS time_from_3, t0.time_to AS time_to_4, t0.note_periode AS note_periode_5, t0.note_hour AS note_hour_6, t0.link AS link_7, t0.link_available AS link_available_8, t0.legacy_city AS legacy_city_9, t0.legacy_adress AS legacy_adress_10, t0.description AS description_11, t0.periode_on AS periode_on_12, t0.slug_city AS slug_city_13, t0.location_id AS location_id_14, t0.legacy_dpt_id AS legacy_dpt_id_15, t0.city_id AS city_id_16 FROM market t0 WHERE t0.city_id = ?

[
  22800
]

SELECT
  t0.id AS id_1,
  t0.weekday AS weekday_2,
  t0.time_from AS time_from_3,
  t0.time_to AS time_to_4,
  t0.note_periode AS note_periode_5,
  t0.note_hour AS note_hour_6,
  t0.link AS link_7,
  t0.link_available AS link_available_8,
  t0.legacy_city AS legacy_city_9,
  t0.legacy_adress AS legacy_adress_10,
  t0.description AS description_11,
  t0.periode_on AS periode_on_12,
  t0.slug_city AS slug_city_13,
  t0.location_id AS location_id_14,
  t0.legacy_dpt_id AS legacy_dpt_id_15,
  t0.city_id AS city_id_16
FROM
  market t0
WHERE
  t0.city_id = ?

SELECT t0.id AS id_1, t0.weekday AS weekday_2, t0.time_from AS time_from_3, t0.time_to AS time_to_4, t0.note_periode AS note_periode_5, t0.note_hour AS note_hour_6, t0.link AS link_7, t0.link_available AS link_available_8, t0.legacy_city AS legacy_city_9, t0.legacy_adress AS legacy_adress_10, t0.description AS description_11, t0.periode_on AS periode_on_12, t0.slug_city AS slug_city_13, t0.location_id AS location_id_14, t0.legacy_dpt_id AS legacy_dpt_id_15, t0.city_id AS city_id_16 FROM market t0 WHERE t0.city_id = 22800;

SELECT m0_.id AS id_0, m0_.weekday AS weekday_1, m0_.time_from AS time_from_2, m0_.time_to AS time_to_3, m0_.note_periode AS note_periode_4, m0_.note_hour AS note_hour_5, m0_.link AS link_6, m0_.link_available AS link_available_7, m0_.legacy_city AS legacy_city_8, m0_.legacy_adress AS legacy_adress_9, m0_.description AS description_10, m0_.periode_on AS periode_on_11, m0_.slug_city AS slug_city_12, m0_.location_id AS location_id_13, m0_.legacy_dpt_id AS legacy_dpt_id_14, m0_.city_id AS city_id_15 FROM market m0_ WHERE m0_.legacy_dpt_id = ? AND m0_.slug_city LIKE ?

[
  58
  "%chateau-chinon%"
]

SELECT
  m0_.id AS id_0,
  m0_.weekday AS weekday_1,
  m0_.time_from AS time_from_2,
  m0_.time_to AS time_to_3,
  m0_.note_periode AS note_periode_4,
  m0_.note_hour AS note_hour_5,
  m0_.link AS link_6,
  m0_.link_available AS link_available_7,
  m0_.legacy_city AS legacy_city_8,
  m0_.legacy_adress AS legacy_adress_9,
  m0_.description AS description_10,
  m0_.periode_on AS periode_on_11,
  m0_.slug_city AS slug_city_12,
  m0_.location_id AS location_id_13,
  m0_.legacy_dpt_id AS legacy_dpt_id_14,
  m0_.city_id AS city_id_15
FROM
  market m0_
WHERE
  m0_.legacy_dpt_id = ?
  AND m0_.slug_city LIKE ?

SELECT m0_.id AS id_0, m0_.weekday AS weekday_1, m0_.time_from AS time_from_2, m0_.time_to AS time_to_3, m0_.note_periode AS note_periode_4, m0_.note_hour AS note_hour_5, m0_.link AS link_6, m0_.link_available AS link_available_7, m0_.legacy_city AS legacy_city_8, m0_.legacy_adress AS legacy_adress_9, m0_.description AS description_10, m0_.periode_on AS periode_on_11, m0_.slug_city AS slug_city_12, m0_.location_id AS location_id_13, m0_.legacy_dpt_id AS legacy_dpt_id_14, m0_.city_id AS city_id_15 FROM market m0_ WHERE m0_.legacy_dpt_id = 58 AND m0_.slug_city LIKE '%chateau-chinon%';

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM region t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM region t0 WHERE t0.id = 2;