Symfony Profiler

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;

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
  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 = '019aef75-8629-7943-b0d3-28d0a49ee32a';

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 = '019aef75-86b6-7a1a-ae33-a8b68b0acb1f';

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 = '019aef75-86ab-7217-b22a-efffd58ada71';

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 = '019aef75-86f7-7727-b458-5a3c0619877f';

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 = '019aef75-86df-7cfa-bf49-7026e6bb9a3c';

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 = '019aef75-8637-73f1-9ee0-4fe4fe625cb2';

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 = '019aef75-869f-71ad-8f72-5b32e5330aa4';

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 = '019aef75-8688-74c7-b3a9-fa27ef64d6c8';

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 = '019aef75-8644-742d-bd7d-f39b3c185178';

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 = '019aef75-867f-74ae-bc12-e9fac162b610';

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 = '019aef75-86c4-7998-aebb-631ec36ef5bd';

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 = '019aef75-8650-7de6-9228-2aa37d1f4f35';

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 = '019aef75-86d9-77c5-8d68-dd0c6959d0c5';

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-f108-73d0-b43d-d1bd30f4565e';

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-f10f-7aca-b533-880409435220';

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-f0af-7474-aec7-b49f90fed294';

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-f0a8-7262-a877-add12fd14334';

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-f07a-7227-9f78-2e8969becc28';

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-f09c-7a04-972e-22ec10936c40';

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-f0a4-70a8-ba4b-77d2077203af';

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-f0c8-7aa0-8787-c41ba4c105f4';

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-f0a6-7829-a20a-1ca92a9eccfc';

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-f0a1-7f06-bf16-c22ef707e277';

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-f0ba-7911-b39a-4ea7718a8fcb';

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-f09f-78fc-b71a-e88508f209c8';

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-f0ab-783b-90a5-dade1d8df057';

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-f0b2-74bb-bc27-8301e36684d8';