Symfony Profiler

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

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-30' GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC;

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

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-30 19:36:25' GROUP BY r0_.id HAVING COUNT(e1_.id) > 0 ORDER BY COUNT(e1_.id) DESC;

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

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 (133983, 134034, 132846, 133305, 133920, 132647, 115429, 134008, 133729, 133956, 133972, 134009, 133974, 133783, 133888, 133295, 134010, 134011, 133846, 134046, 134012, 134013, 134014, 134018, 134037, 134039, 134019, 134020, 132516, 134021, 134022, 133171, 133760, 134023, 133935, 134072, 134024, 133945, 133843, 134035, 133995, 133993, 134016, 134015, 133875, 133744, 134025, 134026, 131225, 134027, 134028, 134029, 134030, 134031, 134032, 132428, 133936, 134043, 134073, 133914, 133990, 133265, 134056, 133510, 133800, 133939, 134052, 133172, 134033, 133938, 133998, 134074, 133494, 134036, 133947, 134075, 134061, 134041, 133908, 133863, 133991, 133994, 133483, 133951, 133757, 133925, 133899, 133955, 133895, 133934, 133962, 133909, 133999, 134076, 134077, 133649, 133501, 133992, 133980, 134045, 130520, 133910, 134007, 133296, 133901, 133462, 133173, 133911, 134049, 134050, 133996, 133728, 133297, 134051, 134062, 133981, 122201, 133780, 133949, 134038, 133254, 133889, 133912, 133916, 134040, 134078, 133823, 134060, 133257, 132847, 133850, 133174, 133979, 133255, 133944, 134042, 133982, 133429, 133928, 133950, 133274, 133633, 133975, 134079, 133317, 133941, 133318, 133511, 133942, 133180, 133976, 133319, 133913, 134063, 133809, 133952, 133175, 133298, 134047, 134080, 134081, 134064, 132969, 133268, 133660, 134057, 133482, 133932, 134044, 133946, 133964, 133960, 133555, 134065, 128681, 123846, 123845, 132363, 121150, 128682, 128683, 132524, 132525, 121149, 121148, 133306, 133301, 133302, 133573, 133176, 133512, 133562, 130988, 132950, 133989, 132949, 134066, 132429, 134017, 133177, 133634, 133969, 133959, 133299, 133594, 134067, 133965, 133101, 130924, 133513, 134068, 131675, 131863, 131333, 133777, 115153, 115152, 132906, 132905, 133781, 133514, 132250, 133921, 133919, 133953, 133954, 133830, 131836, 133178, 133515, 133179, 133182, 133307, 133590, 133308, 133516, 133183, 134048, 133309, 133184, 133310, 133311, 133185, 133186, 133517, 132960, 133603, 133187, 133188, 133518, 133189, 133826, 133190, 133191, 133312, 133313, 133519, 133314, 133591, 133315, 133316, 133771, 133773, 133192, 133193, 133194, 133196, 133197, 133468, 133689, 133198, 133199, 133471, 133853, 133266, 133532, 133496, 133473, 133469, 133464, 133958, 131671, 132195) GROUP BY c0_.id ORDER BY COUNT(e1_.id) DESC, c0_.slug ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.coat_of_arms AS coat_of_arms_4,
  c0_.latitude AS latitude_5,
  c0_.longitude AS longitude_6,
  c0_.borough_id AS borough_id_7
FROM
  city c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.coat_of_arms AS coat_of_arms_4, c0_.latitude AS latitude_5, c0_.longitude AS longitude_6, c0_.borough_id AS borough_id_7 FROM city c0_;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.cover_image AS cover_image_3,
  p0_.description AS description_4,
  p0_.pronoun AS pronoun_5,
  p0_.name AS name_6,
  p0_.number AS number_7,
  p0_.address AS address_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10,
  p0_.oldserial AS oldserial_11,
  p0_.oldurl AS oldurl_12,
  p0_.opening AS opening_13,
  p0_.links AS links_14,
  p0_.map_url AS map_url_15,
  p0_.street_url AS street_url_16,
  p0_.email AS email_17,
  p0_.phone AS phone_18,
  p0_.ip AS ip_19,
  p0_.transport AS transport_20,
  p0_.data_link AS data_link_21,
  p0_.opinion AS opinion_22,
  p0_.summary AS summary_23,
  p0_.wifi AS wifi_24,
  p0_.last_service AS last_service_25,
  p0_.parking AS parking_26,
  p0_.multi_titles AS multi_titles_27,
  p0_.latitude AS latitude_28,
  p0_.longitude AS longitude_29,
  p0_.city_id AS city_id_30,
  p0_.district_id AS district_id_31
FROM
  place p0_
  LEFT JOIN event e1_ ON p0_.id = e1_.place_id
WHERE
  e1_.is_published = 1
  AND e1_.is_validated = 1

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.cover_image AS cover_image_3, p0_.description AS description_4, p0_.pronoun AS pronoun_5, p0_.name AS name_6, p0_.number AS number_7, p0_.address AS address_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.oldserial AS oldserial_11, p0_.oldurl AS oldurl_12, p0_.opening AS opening_13, p0_.links AS links_14, p0_.map_url AS map_url_15, p0_.street_url AS street_url_16, p0_.email AS email_17, p0_.phone AS phone_18, p0_.ip AS ip_19, p0_.transport AS transport_20, p0_.data_link AS data_link_21, p0_.opinion AS opinion_22, p0_.summary AS summary_23, p0_.wifi AS wifi_24, p0_.last_service AS last_service_25, p0_.parking AS parking_26, p0_.multi_titles AS multi_titles_27, p0_.latitude AS latitude_28, p0_.longitude AS longitude_29, p0_.city_id AS city_id_30, p0_.district_id AS district_id_31 FROM place p0_ LEFT JOIN event e1_ ON p0_.id = e1_.place_id WHERE e1_.is_published = 1 AND e1_.is_validated = 1;