Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.region_id AS region_id_8 FROM cities t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_active AS is_active_4,
  t0.sort_order AS sort_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.region_id AS region_id_8 FROM cities t0;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.is_active AS is_active_3, c0_.sort_order AS sort_order_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, r1_.id AS id_7, r1_.name AS name_8, r1_.code AS code_9, r1_.created_at AS created_at_10, r1_.updated_at AS updated_at_11, c2_.id AS id_12, c2_.name AS name_13, c2_.code AS code_14, c2_.is_active AS is_active_15, c2_.sort_order AS sort_order_16, c2_.phone_code AS phone_code_17, c2_.phone_mask AS phone_mask_18, c2_.currency_code AS currency_code_19, c2_.timezone AS timezone_20, c2_.created_at AS created_at_21, c2_.updated_at AS updated_at_22, c0_.region_id AS region_id_23, r1_.country_id AS country_id_24 FROM cities c0_ INNER JOIN regions r1_ ON c0_.region_id = r1_.id INNER JOIN countries c2_ ON r1_.country_id = c2_.id WHERE c0_.is_active = ? AND c2_.is_active = ? ORDER BY c0_.sort_order ASC, c0_.name ASC

[
  1
  1
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.is_active AS is_active_3,
  c0_.sort_order AS sort_order_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  r1_.id AS id_7,
  r1_.name AS name_8,
  r1_.code AS code_9,
  r1_.created_at AS created_at_10,
  r1_.updated_at AS updated_at_11,
  c2_.id AS id_12,
  c2_.name AS name_13,
  c2_.code AS code_14,
  c2_.is_active AS is_active_15,
  c2_.sort_order AS sort_order_16,
  c2_.phone_code AS phone_code_17,
  c2_.phone_mask AS phone_mask_18,
  c2_.currency_code AS currency_code_19,
  c2_.timezone AS timezone_20,
  c2_.created_at AS created_at_21,
  c2_.updated_at AS updated_at_22,
  c0_.region_id AS region_id_23,
  r1_.country_id AS country_id_24
FROM
  cities c0_
  INNER JOIN regions r1_ ON c0_.region_id = r1_.id
  INNER JOIN countries c2_ ON r1_.country_id = c2_.id
WHERE
  c0_.is_active = ?
  AND c2_.is_active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.is_active AS is_active_3, c0_.sort_order AS sort_order_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, r1_.id AS id_7, r1_.name AS name_8, r1_.code AS code_9, r1_.created_at AS created_at_10, r1_.updated_at AS updated_at_11, c2_.id AS id_12, c2_.name AS name_13, c2_.code AS code_14, c2_.is_active AS is_active_15, c2_.sort_order AS sort_order_16, c2_.phone_code AS phone_code_17, c2_.phone_mask AS phone_mask_18, c2_.currency_code AS currency_code_19, c2_.timezone AS timezone_20, c2_.created_at AS created_at_21, c2_.updated_at AS updated_at_22, c0_.region_id AS region_id_23, r1_.country_id AS country_id_24 FROM cities c0_ INNER JOIN regions r1_ ON c0_.region_id = r1_.id INNER JOIN countries c2_ ON r1_.country_id = c2_.id WHERE c0_.is_active = 1 AND c2_.is_active = 1 ORDER BY c0_.sort_order ASC, c0_.name ASC;