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 u0_.id AS id_0, u0_.company_name AS company_name_1, u0_.first_name AS first_name_2, u0_.last_name AS last_name_3, u0_.city AS city_4, COUNT(o1_.id) AS sclr_5 FROM users u0_ LEFT JOIN orders o1_ ON (o1_.customer_id = u0_.id) WHERE u0_.roles LIKE ? GROUP BY u0_.id HAVING sclr_5 > 0 ORDER BY sclr_5 DESC LIMIT 6

[
  "%ROLE_CUSTOMER%"
]

SELECT
  u0_.id AS id_0,
  u0_.company_name AS company_name_1,
  u0_.first_name AS first_name_2,
  u0_.last_name AS last_name_3,
  u0_.city AS city_4,
  COUNT(o1_.id) AS sclr_5
FROM
  users u0_
  LEFT JOIN orders o1_ ON (o1_.customer_id = u0_.id)
WHERE
  u0_.roles LIKE ?
GROUP BY
  u0_.id
HAVING
  sclr_5 > 0
ORDER BY
  sclr_5 DESC
LIMIT
  6

SELECT u0_.id AS id_0, u0_.company_name AS company_name_1, u0_.first_name AS first_name_2, u0_.last_name AS last_name_3, u0_.city AS city_4, COUNT(o1_.id) AS sclr_5 FROM users u0_ LEFT JOIN orders o1_ ON (o1_.customer_id = u0_.id) WHERE u0_.roles LIKE '%ROLE_CUSTOMER%' GROUP BY u0_.id HAVING sclr_5 > 0 ORDER BY sclr_5 DESC LIMIT 6;