| 1 |
66.74 ms |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.data AS data_2, n0_.created_at AS created_at_3, n0_.pinned AS pinned_4, n0_.image_id AS image_id_5 FROM news n0_ ORDER BY n0_.created_at DESC LIMIT 6
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.data AS data_2, n0_.created_at AS created_at_3, n0_.pinned AS pinned_4, n0_.image_id AS image_id_5 FROM news n0_ ORDER BY n0_.created_at DESC LIMIT 6;
|
| 2 |
1.46 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM news n0_
SELECT COUNT(n0_.id) AS sclr_0 FROM news n0_;
|
| 3 |
1.14 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters: [
"73cdf429-8a43-4661-be68-bc98733ff4e2"
]
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = '73cdf429-8a43-4661-be68-bc98733ff4e2';
|
| 4 |
2.60 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'news' AND t1_.target_id = '7371cf40-c847-4f9a-bea6-1f334229e3ba' ORDER BY t0_.title ASC;
|
| 5 |
0.71 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters: [
"d70f5773-5429-4ba9-8089-cafb42f4ec58"
]
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = 'd70f5773-5429-4ba9-8089-cafb42f4ec58';
|
| 6 |
0.63 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'news' AND t1_.target_id = '3082bfac-6d2f-465a-b34f-dea887bd50d1' ORDER BY t0_.title ASC;
|
| 7 |
0.44 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters: [
"4ec502bc-abb2-4588-af6f-05ef7967f8c6"
]
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = '4ec502bc-abb2-4588-af6f-05ef7967f8c6';
|
| 8 |
0.90 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'news' AND t1_.target_id = '2eb598d4-91e3-4487-883b-2ea630f0f2fc' ORDER BY t0_.title ASC;
|
| 9 |
0.63 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters: [
"4e8595e9-3ce3-493d-99a1-fd989d970927"
]
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = '4e8595e9-3ce3-493d-99a1-fd989d970927';
|
| 10 |
0.72 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'news' AND t1_.target_id = '5c91e607-e920-4198-9a6a-8874119d986a' ORDER BY t0_.title ASC;
|
| 11 |
0.38 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters: [
"693e5ffc-e90b-4860-828a-0d35ff554f72"
]
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = '693e5ffc-e90b-4860-828a-0d35ff554f72';
|
| 12 |
0.55 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'news' AND t1_.target_id = '88b0043f-ea2e-4096-bc6e-273a1449b960' ORDER BY t0_.title ASC;
|
| 13 |
0.45 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters: [
"564a6b7d-164a-4712-9d38-dc92abc970ba"
]
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = '564a6b7d-164a-4712-9d38-dc92abc970ba';
|
| 14 |
0.57 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'news' AND t1_.target_id = '333d5a4a-4493-4935-8188-c37b41c563f8' ORDER BY t0_.title ASC;
|