| 1 |
2.39 ms |
SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.widget AS widget_2, i0_.position AS position_3, i0_.created_at AS created_at_4 FROM inhouse_stage i0_ ORDER BY i0_.position ASC, i0_.created_at DESC LIMIT 1000
SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.widget AS widget_2, i0_.position AS position_3, i0_.created_at AS created_at_4 FROM inhouse_stage i0_ ORDER BY i0_.position ASC, i0_.created_at DESC LIMIT 1000;
|
| 2 |
1.10 ms |
SELECT COUNT(DISTINCT i0_.id) AS sclr_0 FROM inhouse_stage i0_
SELECT COUNT(DISTINCT i0_.id) AS sclr_0 FROM inhouse_stage i0_;
|
| 3 |
2.01 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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = ?
Parameters: [
"a5ea1e9e-f580-4f85-8726-55e5a49c58d9"
]
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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = 'a5ea1e9e-f580-4f85-8726-55e5a49c58d9';
|
| 4 |
2.39 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 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_.url AS url_3, t0_.created_at AS created_at_4 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'inhouse_stage' AND t1_.target_id = 'a5ea1e9e-f580-4f85-8726-55e5a49c58d9' ORDER BY t0_.title ASC;
|
| 5 |
0.92 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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = ?
Parameters: [
"0ca1d0cb-67e2-4c2e-aed3-f6a5f3f06d65"
]
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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = '0ca1d0cb-67e2-4c2e-aed3-f6a5f3f06d65';
|
| 6 |
0.80 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 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_.url AS url_3, t0_.created_at AS created_at_4 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'inhouse_stage' AND t1_.target_id = '0ca1d0cb-67e2-4c2e-aed3-f6a5f3f06d65' ORDER BY t0_.title ASC;
|
| 7 |
0.65 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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = ?
Parameters: [
"634773e7-fe71-4c2b-83fe-db72e16b8fa8"
]
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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = '634773e7-fe71-4c2b-83fe-db72e16b8fa8';
|
| 8 |
0.65 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 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_.url AS url_3, t0_.created_at AS created_at_4 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'inhouse_stage' AND t1_.target_id = '634773e7-fe71-4c2b-83fe-db72e16b8fa8' ORDER BY t0_.title ASC;
|
| 9 |
0.68 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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = ?
Parameters: [
"d03ca077-9603-4a5b-8d87-e73e4289a42b"
]
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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = 'd03ca077-9603-4a5b-8d87-e73e4289a42b';
|
| 10 |
0.59 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 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_.url AS url_3, t0_.created_at AS created_at_4 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = 'inhouse_stage' AND t1_.target_id = 'd03ca077-9603-4a5b-8d87-e73e4289a42b' ORDER BY t0_.title ASC;
|