| 1 |
2.80 ms |
SELECT t0.id AS id_1, t0.vType AS vType_2, t0.name AS name_3, t0.value AS value_4 FROM variable t0 WHERE t0.name = ? LIMIT 1
Parameters: [
"announcement"
]
SELECT t0.id AS id_1, t0.vType AS vType_2, t0.name AS name_3, t0.value AS value_4 FROM variable t0 WHERE t0.name = 'announcement' LIMIT 1;
|
| 2 |
1.20 ms |
SELECT t0.id AS id_1, t0.vType AS vType_2, t0.name AS name_3, t0.value AS value_4 FROM variable t0 WHERE t0.name = ? LIMIT 1
Parameters: [
"siteTitle"
]
SELECT t0.id AS id_1, t0.vType AS vType_2, t0.name AS name_3, t0.value AS value_4 FROM variable t0 WHERE t0.name = 'siteTitle' LIMIT 1;
|
| 3 |
4.66 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.imageName AS imageName_2, p0_.updated_at AS updated_at_3, p0_.caption AS caption_4, p0_.published AS published_5, p0_.date AS date_6, p0_.slideshow AS slideshow_7, p0_.gallery_id AS gallery_id_8 FROM photo p0_ WHERE p0_.slideshow = 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.imageName AS imageName_2, p0_.updated_at AS updated_at_3, p0_.caption AS caption_4, p0_.published AS published_5, p0_.date AS date_6, p0_.slideshow AS slideshow_7, p0_.gallery_id AS gallery_id_8 FROM photo p0_ WHERE p0_.slideshow = 1;
|
| 4 |
1.20 ms |
SELECT t0.id AS id_1, t0.vType AS vType_2, t0.name AS name_3, t0.value AS value_4 FROM variable t0 WHERE t0.name = ? LIMIT 1
Parameters: [
"currentYear"
]
SELECT t0.id AS id_1, t0.vType AS vType_2, t0.name AS name_3, t0.value AS value_4 FROM variable t0 WHERE t0.name = 'currentYear' LIMIT 1;
|
| 5 |
1.99 ms |
SELECT c0_.id AS id_0, c0_.year AS year_1, c0_.imageName AS imageName_2, n1_.title AS title_3, n1_.id AS id_4 FROM competition c0_ LEFT JOIN nomination n1_ ON c0_.nomination_id = n1_.id WHERE c0_.year = ?
SELECT c0_.id AS id_0, c0_.year AS year_1, c0_.imageName AS imageName_2, n1_.title AS title_3, n1_.id AS id_4 FROM competition c0_ LEFT JOIN nomination n1_ ON c0_.nomination_id = n1_.id WHERE c0_.year = 2026;
|
| 6 |
2.65 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.date AS date_3, t0.description AS description_4, t0.summary AS summary_5, t0.published AS published_6 FROM gallery t0 ORDER BY t0.date DESC LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.date AS date_3, t0.description AS description_4, t0.summary AS summary_5, t0.published AS published_6 FROM gallery t0 ORDER BY t0.date DESC LIMIT 1;
|
| 7 |
2.81 ms |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.url AS url_2, c0_.imageName AS imageName_3, c0_.description AS description_4, c0_.updated_at AS updated_at_5, c0_.approved AS approved_6, c0_.uploaded AS uploaded_7, c0_.votes1 AS votes1_8, c0_.votes2 AS votes2_9, c0_.band_id AS band_id_10 FROM composition c0_ WHERE c0_.approved = 1 ORDER BY c0_.uploaded DESC LIMIT 3
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.url AS url_2, c0_.imageName AS imageName_3, c0_.description AS description_4, c0_.updated_at AS updated_at_5, c0_.approved AS approved_6, c0_.uploaded AS uploaded_7, c0_.votes1 AS votes1_8, c0_.votes2 AS votes2_9, c0_.band_id AS band_id_10 FROM composition c0_ WHERE c0_.approved = 1 ORDER BY c0_.uploaded DESC LIMIT 3;
|
| 8 |
1.33 ms |
SELECT n0_.title AS title_0, n0_.id AS id_1 FROM nomination n0_
SELECT n0_.title AS title_0, n0_.id AS id_1 FROM nomination n0_;
|
| 9 |
1.33 ms |
SELECT DISTINCT c0_.year AS year_0 FROM competition c0_ ORDER BY c0_.year DESC
SELECT DISTINCT c0_.year AS year_0 FROM competition c0_ ORDER BY c0_.year DESC;
|
| 10 |
3.11 ms |
SELECT DISTINCT m0_.year AS year_0 FROM media m0_ ORDER BY m0_.year DESC
SELECT DISTINCT m0_.year AS year_0 FROM media m0_ ORDER BY m0_.year DESC;
|
| 11 |
1.12 ms |
SELECT DISTINCT g0_.id AS id_0, g0_.title AS title_1 FROM gallery g0_ WHERE g0_.published = 1 ORDER BY g0_.title DESC
SELECT DISTINCT g0_.id AS id_0, g0_.title AS title_1 FROM gallery g0_ WHERE g0_.published = 1 ORDER BY g0_.title DESC;
|