Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 124
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Workflow
• VichUploader
• Blocks 0
• Configuration

Query Metrics

SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.postal_code AS postal_code_2, c0_.insee_code AS insee_code_3, c0_.latitude AS latitude_4, c0_.longitude AS longitude_5, c0_.slug AS slug_6, d1_.id AS id_7, d1_.label AS label_8, d1_.code AS code_9, d1_.slug AS slug_10, r2_.id AS id_11, r2_.label AS label_12, r2_.slug AS slug_13, c0_.department_id AS department_id_14, c0_.community_id AS community_id_15, c0_.funding_status_id AS funding_status_id_16, d1_.region_id AS region_id_17 FROM city c0_ INNER JOIN department d1_ ON c0_.department_id = d1_.id INNER JOIN region r2_ ON d1_.region_id = r2_.id WHERE c0_.postal_code LIKE ? AND r2_.id = ? ORDER BY c0_.label ASC

[
  "35700%"
  16
]

SELECT
  c0_.id AS id_0,
  c0_.label AS label_1,
  c0_.postal_code AS postal_code_2,
  c0_.insee_code AS insee_code_3,
  c0_.latitude AS latitude_4,
  c0_.longitude AS longitude_5,
  c0_.slug AS slug_6,
  d1_.id AS id_7,
  d1_.label AS label_8,
  d1_.code AS code_9,
  d1_.slug AS slug_10,
  r2_.id AS id_11,
  r2_.label AS label_12,
  r2_.slug AS slug_13,
  c0_.department_id AS department_id_14,
  c0_.community_id AS community_id_15,
  c0_.funding_status_id AS funding_status_id_16,
  d1_.region_id AS region_id_17
FROM
  city c0_
  INNER JOIN department d1_ ON c0_.department_id = d1_.id
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
WHERE
  c0_.postal_code LIKE ?
  AND r2_.id = ?
ORDER BY
  c0_.label ASC

SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.postal_code AS postal_code_2, c0_.insee_code AS insee_code_3, c0_.latitude AS latitude_4, c0_.longitude AS longitude_5, c0_.slug AS slug_6, d1_.id AS id_7, d1_.label AS label_8, d1_.code AS code_9, d1_.slug AS slug_10, r2_.id AS id_11, r2_.label AS label_12, r2_.slug AS slug_13, c0_.department_id AS department_id_14, c0_.community_id AS community_id_15, c0_.funding_status_id AS funding_status_id_16, d1_.region_id AS region_id_17 FROM city c0_ INNER JOIN department d1_ ON c0_.department_id = d1_.id INNER JOIN region r2_ ON d1_.region_id = r2_.id WHERE c0_.postal_code LIKE '35700%' AND r2_.id = 16 ORDER BY c0_.label ASC;