Symfony Profiler

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

[
  "01%"
  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 '01%' AND r2_.id = 16 ORDER BY c0_.label ASC;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = ? AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer')

[
  7398
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.last_login AS last_login_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.phone_number AS phone_number_8,
  t0.address AS address_9,
  t0.enabled AS enabled_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.city_id AS city_id_13,
  t0.discr,
  t0.unavailability_start_date AS unavailability_start_date_14,
  t0.unavailability_end_date AS unavailability_end_date_15,
  t0.is_validated AS is_validated_16,
  t0.company_name AS company_name_17,
  t0.company_prices AS company_prices_18,
  t0.comment AS comment_19,
  t0.viewer_category_id AS viewer_category_id_20
FROM
  user t0
WHERE
  t0.id = ?
  AND t0.discr IN (
    'administrator', 'advisor', 'sector_manager',
    'declarant', 'exterminator', 'supervisor',
    'viewer'
  )

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.city_id AS city_id_13, t0.discr, t0.unavailability_start_date AS unavailability_start_date_14, t0.unavailability_end_date AS unavailability_end_date_15, t0.is_validated AS is_validated_16, t0.company_name AS company_name_17, t0.company_prices AS company_prices_18, t0.comment AS comment_19, t0.viewer_category_id AS viewer_category_id_20 FROM user t0 WHERE t0.id = 7398 AND t0.discr IN ('administrator', 'advisor', 'sector_manager', 'declarant', 'exterminator', 'supervisor', 'viewer');