| 1 |
1.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = 'techno' LIMIT 1;
|
| 2 |
17.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = 'techno' LIMIT 1;
|
| 3 |
3.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = 'img' LIMIT 1;
|
| 4 |
229.82 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.slogan AS slogan_3, s0_.color AS color_4, s0_.resident AS resident_5, s0_.network AS network_6, s0_.main_borough_id AS main_borough_id_7 FROM subdomain s0_ INNER JOIN subdomain_borough s2_ ON s0_.id = s2_.subdomain_id INNER JOIN borough b1_ ON b1_.id = s2_.borough_id INNER JOIN city c3_ ON b1_.id = c3_.borough_id INNER JOIN event e4_ ON c3_.id = e4_.city_id WHERE e4_.date_end >= ? GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC
Parameters: [
"2025-10-25"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.slogan AS slogan_3, s0_.color AS color_4, s0_.resident AS resident_5, s0_.network AS network_6, s0_.main_borough_id AS main_borough_id_7 FROM subdomain s0_ INNER JOIN subdomain_borough s2_ ON s0_.id = s2_.subdomain_id INNER JOIN borough b1_ ON b1_.id = s2_.borough_id INNER JOIN city c3_ ON b1_.id = c3_.borough_id INNER JOIN event e4_ ON c3_.id = e4_.city_id WHERE e4_.date_end >= '2025-10-25' GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC;
|
| 5 |
2.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = 'img' LIMIT 1;
|
| 6 |
3.81 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = 'img' LIMIT 1;
|
| 7 |
186.52 ms |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.color AS color_3, r0_.single AS single_4, r0_.plural AS plural_5 FROM rubric r0_ INNER JOIN event e1_ ON r0_.id = e1_.rubric_id WHERE e1_.date_end >= ? GROUP BY r0_.id HAVING COUNT(e1_.id) > 0 ORDER BY COUNT(e1_.id) DESC
Parameters: [
"2025-10-25 16:46:37"
]
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.color AS color_3, r0_.single AS single_4, r0_.plural AS plural_5 FROM rubric r0_ INNER JOIN event e1_ ON r0_.id = e1_.rubric_id WHERE e1_.date_end >= '2025-10-25 16:46:37' GROUP BY r0_.id HAVING COUNT(e1_.id) > 0 ORDER BY COUNT(e1_.id) DESC;
|
| 8 |
2.37 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM category c0_ INNER JOIN event_category e2_ ON c0_.id = e2_.category_id INNER JOIN event e1_ ON e1_.id = e2_.event_id WHERE e1_.id IN (?, ?) GROUP BY c0_.id ORDER BY COUNT(e1_.id) DESC, c0_.slug ASC
Parameters: [
133783
133757
]
SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM category c0_ INNER JOIN event_category e2_ ON c0_.id = e2_.category_id INNER JOIN event e1_ ON e1_.id = e2_.event_id WHERE e1_.id IN (133783, 133757) GROUP BY c0_.id ORDER BY COUNT(e1_.id) DESC, c0_.slug ASC;
|