| 1 |
8.21 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
Parameters: [
"atelier-d-ecriture"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = 'atelier-d-ecriture' LIMIT 1;
|
| 2 |
2.14 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
Parameters: [
"atelier-d-ecriture"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = 'atelier-d-ecriture' LIMIT 1;
|
| 3 |
30.34 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 = 'live' LIMIT 1;
|
| 4 |
271.77 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-26"
]
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-26' GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC;
|
| 5 |
4.41 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 = 'live' LIMIT 1;
|
| 6 |
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 = 'live' LIMIT 1;
|
| 7 |
190.43 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-26 09:40:49"
]
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-26 09:40:49' GROUP BY r0_.id HAVING COUNT(e1_.id) > 0 ORDER BY COUNT(e1_.id) DESC;
|
| 8 |
3.35 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: [
133914
133959
133496
]
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 (133914, 133959, 133496) GROUP BY c0_.id ORDER BY COUNT(e1_.id) DESC, c0_.slug ASC;
|