Symfony Profiler

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

Query Metrics

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.icon AS icon_3, i0_.category AS category_4, i0_.is_active AS is_active_5, COUNT(u1_.id) AS sclr_6 FROM interest i0_ LEFT JOIN user_interests u2_ ON i0_.id = u2_.interest_id LEFT JOIN `user` u1_ ON u1_.id = u2_.user_id WHERE i0_.is_active = ? AND u1_.is_active = ? GROUP BY i0_.id ORDER BY sclr_6 DESC, i0_.name ASC LIMIT 8

[
  1
  1
]

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.description AS description_2,
  i0_.icon AS icon_3,
  i0_.category AS category_4,
  i0_.is_active AS is_active_5,
  COUNT(u1_.id) AS sclr_6
FROM
  interest i0_
  LEFT JOIN user_interests u2_ ON i0_.id = u2_.interest_id
  LEFT JOIN `user` u1_ ON u1_.id = u2_.user_id
WHERE
  i0_.is_active = ?
  AND u1_.is_active = ?
GROUP BY
  i0_.id
ORDER BY
  sclr_6 DESC,
  i0_.name ASC
LIMIT
  8

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.icon AS icon_3, i0_.category AS category_4, i0_.is_active AS is_active_5, COUNT(u1_.id) AS sclr_6 FROM interest i0_ LEFT JOIN user_interests u2_ ON i0_.id = u2_.interest_id LEFT JOIN `user` u1_ ON u1_.id = u2_.user_id WHERE i0_.is_active = 1 AND u1_.is_active = 1 GROUP BY i0_.id ORDER BY sclr_6 DESC, i0_.name ASC LIMIT 8;