Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• 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

[
  "07"
]

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 = '07' 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

[
  7
  "lalevade-d-ardeche"
  "lalevade-d-ardeche"
]

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 = 7 AND ((LOWER(c0_.slug) = 'lalevade-d-ardeche') OR (LOWER(c0_.name) = 'lalevade-d-ardeche')) 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

[
  7
  "%lalevade-d-ardeche%"
]

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 = 7 AND LOWER(c0_.slug) LIKE '%lalevade-d-ardeche%' LIMIT 1;

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 ?

[
  7
  "%lalevade-d-ardeche%"
]

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 = 7 AND m0_.slug_city LIKE '%lalevade-d-ardeche%';

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;