| 1 |
5.38 ms |
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, r0_.submitted_by_id AS submitted_by_id_11 FROM roadmap_items r0_ WHERE r0_.is_approved = ? AND r0_.status = ? ORDER BY r0_.created_at DESC
Parameters: [
1
"completed"
]
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, r0_.submitted_by_id AS submitted_by_id_11 FROM roadmap_items r0_ WHERE r0_.is_approved = 1 AND r0_.status = 'completed' ORDER BY r0_.created_at DESC;
|
| 2 |
1.40 ms |
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 = ?
Parameters: [
"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 = '019aef75-86df-7cfa-bf49-7026e6bb9a3c';
|
| 3 |
0.50 ms |
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 = ?
Parameters: [
"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 = '019aef75-8629-7943-b0d3-28d0a49ee32a';
|
| 4 |
0.51 ms |
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 = ?
Parameters: [
"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 = '019aef75-8637-73f1-9ee0-4fe4fe625cb2';
|
| 5 |
0.41 ms |
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 = ?
Parameters: [
"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 = '019aef75-8644-742d-bd7d-f39b3c185178';
|
| 6 |
0.47 ms |
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 = ?
Parameters: [
"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 = '019aef75-8650-7de6-9228-2aa37d1f4f35';
|
| 7 |
0.43 ms |
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 = ?
Parameters: [
"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 = '019aef75-867f-74ae-bc12-e9fac162b610';
|
| 8 |
0.86 ms |
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 = ?
Parameters: [
"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 = '019aef75-8688-74c7-b3a9-fa27ef64d6c8';
|
| 9 |
0.46 ms |
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 = ?
Parameters: [
"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 = '019aef75-869f-71ad-8f72-5b32e5330aa4';
|
| 10 |
0.42 ms |
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 = ?
Parameters: [
"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 = '019aef75-86ab-7217-b22a-efffd58ada71';
|
| 11 |
0.41 ms |
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 = ?
Parameters: [
"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 = '019aef75-86b6-7a1a-ae33-a8b68b0acb1f';
|
| 12 |
0.40 ms |
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 = ?
Parameters: [
"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 = '019aef75-86c4-7998-aebb-631ec36ef5bd';
|
| 13 |
0.44 ms |
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 = ?
Parameters: [
"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 = '019aef75-86d9-77c5-8d68-dd0c6959d0c5';
|
| 14 |
0.43 ms |
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 = ?
Parameters: [
"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 = '019ae3ff-f09c-7a04-972e-22ec10936c40';
|
| 15 |
0.39 ms |
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 = ?
Parameters: [
"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 = '019ae3ff-f09f-78fc-b71a-e88508f209c8';
|
| 16 |
0.37 ms |
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 = ?
Parameters: [
"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 = '019ae3ff-f0a1-7f06-bf16-c22ef707e277';
|
| 17 |
0.35 ms |
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 = ?
Parameters: [
"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 = '019ae3ff-f0a4-70a8-ba4b-77d2077203af';
|
| 18 |
0.44 ms |
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 = ?
Parameters: [
"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 = '019ae3ff-f0a6-7829-a20a-1ca92a9eccfc';
|
| 19 |
0.35 ms |
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 = ?
Parameters: [
"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 = '019ae3ff-f0a8-7262-a877-add12fd14334';
|
| 20 |
0.41 ms |
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 = ?
Parameters: [
"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 = '019ae3ff-f0ab-783b-90a5-dade1d8df057';
|
| 21 |
0.30 ms |
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 = ?
Parameters: [
"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 = '019ae3ff-f0c8-7aa0-8787-c41ba4c105f4';
|
| 22 |
0.41 ms |
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 = ?
Parameters: [
"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 = '019ae3ff-f0ba-7911-b39a-4ea7718a8fcb';
|
| 23 |
0.33 ms |
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 = ?
Parameters: [
"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 = '019ae3ff-f0b7-7c41-9393-d0670d3ecb33';
|
| 24 |
0.38 ms |
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 = ?
Parameters: [
"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 = '019ae3ff-f07a-7227-9f78-2e8969becc28';
|