Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Emails
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.roadmap_item_id AS roadmap_item_id_3, t0.user_id AS user_id_4 FROM roadmap_votes t0 WHERE t0.roadmap_item_id = ?

[
  "019ae3ff-f0b7-7c41-9393-d0670d3ecb33"
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.roadmap_item_id AS roadmap_item_id_3,
  t0.user_id AS user_id_4
FROM
  roadmap_votes t0
WHERE
  t0.roadmap_item_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.roadmap_item_id AS roadmap_item_id_3, t0.user_id AS user_id_4 FROM roadmap_votes t0 WHERE t0.roadmap_item_id = '019ae3ff-f0b7-7c41-9393-d0670d3ecb33';

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.description AS description_2, r0_.status AS status_3, r0_.category AS category_4, r0_.is_user_submitted AS is_user_submitted_5, r0_.is_approved AS is_approved_6, r0_.approved_at AS approved_at_7, r0_.target_version AS target_version_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, COUNT(r1_.id) AS sclr_11, r0_.submitted_by_id AS submitted_by_id_12 FROM roadmap_items r0_ LEFT JOIN roadmap_votes r1_ ON r0_.id = r1_.roadmap_item_id WHERE r0_.is_approved = ? GROUP BY r0_.id ORDER BY sclr_11 DESC, r0_.created_at DESC

[
  1
]

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.description AS description_2,
  r0_.status AS status_3,
  r0_.category AS category_4,
  r0_.is_user_submitted AS is_user_submitted_5,
  r0_.is_approved AS is_approved_6,
  r0_.approved_at AS approved_at_7,
  r0_.target_version AS target_version_8,
  r0_.created_at AS created_at_9,
  r0_.updated_at AS updated_at_10,
  COUNT(r1_.id) AS sclr_11,
  r0_.submitted_by_id AS submitted_by_id_12
FROM
  roadmap_items r0_
  LEFT JOIN roadmap_votes r1_ ON r0_.id = r1_.roadmap_item_id
WHERE
  r0_.is_approved = ?
GROUP BY
  r0_.id
ORDER BY
  sclr_11 DESC,
  r0_.created_at DESC

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.description AS description_2, r0_.status AS status_3, r0_.category AS category_4, r0_.is_user_submitted AS is_user_submitted_5, r0_.is_approved AS is_approved_6, r0_.approved_at AS approved_at_7, r0_.target_version AS target_version_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, COUNT(r1_.id) AS sclr_11, r0_.submitted_by_id AS submitted_by_id_12 FROM roadmap_items r0_ LEFT JOIN roadmap_votes r1_ ON r0_.id = r1_.roadmap_item_id WHERE r0_.is_approved = 1 GROUP BY r0_.id ORDER BY sclr_11 DESC, r0_.created_at DESC;