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

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;

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 = 'atelier-d-ecriture' LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.slug AS slug_2,
  e0_.price AS price_3,
  e0_.precision_price AS precision_price_4,
  e0_.date_start AS date_start_5,
  e0_.date_end AS date_end_6,
  e0_.time_start AS time_start_7,
  e0_.time_end AS time_end_8,
  e0_.precision_date AS precision_date_9,
  e0_.choice_of_days AS choice_of_days_10,
  e0_.description AS description_11,
  e0_.cover_image AS cover_image_12,
  e0_.created_at AS created_at_13,
  e0_.updated_at AS updated_at_14,
  e0_.place_temporary AS place_temporary_15,
  e0_.is_validated AS is_validated_16,
  e0_.is_canceled AS is_canceled_17,
  e0_.is_published AS is_published_18,
  e0_.is_spam AS is_spam_19,
  e0_.is_mistake AS is_mistake_20,
  e0_.is_duplicated AS is_duplicated_21,
  e0_.is_full AS is_full_22,
  e0_.is_postponed AS is_postponed_23,
  e0_.links AS links_24,
  r1_.id AS id_25,
  r1_.name AS name_26,
  r1_.slug AS slug_27,
  r1_.color AS color_28,
  r1_.single AS single_29,
  r1_.plural AS plural_30,
  p2_.id AS id_31,
  p2_.title AS title_32,
  p2_.slug AS slug_33,
  p2_.cover_image AS cover_image_34,
  p2_.description AS description_35,
  p2_.pronoun AS pronoun_36,
  p2_.name AS name_37,
  p2_.number AS number_38,
  p2_.address AS address_39,
  p2_.created_at AS created_at_40,
  p2_.updated_at AS updated_at_41,
  p2_.oldserial AS oldserial_42,
  p2_.oldurl AS oldurl_43,
  p2_.opening AS opening_44,
  p2_.links AS links_45,
  p2_.map_url AS map_url_46,
  p2_.street_url AS street_url_47,
  p2_.email AS email_48,
  p2_.phone AS phone_49,
  p2_.ip AS ip_50,
  p2_.transport AS transport_51,
  p2_.data_link AS data_link_52,
  p2_.opinion AS opinion_53,
  p2_.summary AS summary_54,
  p2_.wifi AS wifi_55,
  p2_.last_service AS last_service_56,
  p2_.parking AS parking_57,
  p2_.multi_titles AS multi_titles_58,
  p2_.latitude AS latitude_59,
  p2_.longitude AS longitude_60,
  c3_.id AS id_61,
  c3_.name AS name_62,
  c3_.slug AS slug_63,
  c3_.description AS description_64,
  c3_.coat_of_arms AS coat_of_arms_65,
  c3_.latitude AS latitude_66,
  c3_.longitude AS longitude_67,
  c4_.id AS id_68,
  c4_.name AS name_69,
  c4_.slug AS slug_70,
  c4_.description AS description_71,
  c4_.coat_of_arms AS coat_of_arms_72,
  c4_.latitude AS latitude_73,
  c4_.longitude AS longitude_74,
  v5_.id AS id_75,
  v5_.url AS url_76,
  v5_.caption AS caption_77,
  v6_.id AS id_78,
  v6_.name AS name_79,
  v6_.website AS website_80,
  v6_.embed AS embed_81,
  v6_.shortcut AS shortcut_82,
  v6_.linked AS linked_83,
  e0_.city_id AS city_id_84,
  e0_.place_id AS place_id_85,
  e0_.rubric_id AS rubric_id_86,
  e0_.organizer_id AS organizer_id_87,
  e0_.festival_id AS festival_id_88,
  p2_.city_id AS city_id_89,
  p2_.district_id AS district_id_90,
  c3_.borough_id AS borough_id_91,
  c4_.borough_id AS borough_id_92,
  v5_.videostore_id AS videostore_id_93,
  v5_.event_id AS event_id_94
FROM
  event e0_
  LEFT JOIN rubric r1_ ON e0_.rubric_id = r1_.id
  LEFT JOIN place p2_ ON e0_.place_id = p2_.id
  LEFT JOIN city c3_ ON p2_.city_id = c3_.id
  LEFT JOIN city c4_ ON e0_.city_id = c4_.id
  LEFT JOIN video v5_ ON e0_.id = v5_.event_id
  LEFT JOIN videostore v6_ ON v5_.videostore_id = v6_.id
  LEFT JOIN event_category e8_ ON e0_.id = e8_.event_id
  LEFT JOIN category c7_ ON c7_.id = e8_.category_id
WHERE
  e0_.is_published = 1
  AND e0_.is_validated = 1
  AND e0_.date_end >= ?
  AND c7_.slug = ?
ORDER BY
  e0_.date_end ASC,
  e0_.date_start ASC,
  e0_.time_start ASC,
  e0_.date_end ASC,
  e0_.time_end ASC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.price AS price_3, e0_.precision_price AS precision_price_4, e0_.date_start AS date_start_5, e0_.date_end AS date_end_6, e0_.time_start AS time_start_7, e0_.time_end AS time_end_8, e0_.precision_date AS precision_date_9, e0_.choice_of_days AS choice_of_days_10, e0_.description AS description_11, e0_.cover_image AS cover_image_12, e0_.created_at AS created_at_13, e0_.updated_at AS updated_at_14, e0_.place_temporary AS place_temporary_15, e0_.is_validated AS is_validated_16, e0_.is_canceled AS is_canceled_17, e0_.is_published AS is_published_18, e0_.is_spam AS is_spam_19, e0_.is_mistake AS is_mistake_20, e0_.is_duplicated AS is_duplicated_21, e0_.is_full AS is_full_22, e0_.is_postponed AS is_postponed_23, e0_.links AS links_24, r1_.id AS id_25, r1_.name AS name_26, r1_.slug AS slug_27, r1_.color AS color_28, r1_.single AS single_29, r1_.plural AS plural_30, p2_.id AS id_31, p2_.title AS title_32, p2_.slug AS slug_33, p2_.cover_image AS cover_image_34, p2_.description AS description_35, p2_.pronoun AS pronoun_36, p2_.name AS name_37, p2_.number AS number_38, p2_.address AS address_39, p2_.created_at AS created_at_40, p2_.updated_at AS updated_at_41, p2_.oldserial AS oldserial_42, p2_.oldurl AS oldurl_43, p2_.opening AS opening_44, p2_.links AS links_45, p2_.map_url AS map_url_46, p2_.street_url AS street_url_47, p2_.email AS email_48, p2_.phone AS phone_49, p2_.ip AS ip_50, p2_.transport AS transport_51, p2_.data_link AS data_link_52, p2_.opinion AS opinion_53, p2_.summary AS summary_54, p2_.wifi AS wifi_55, p2_.last_service AS last_service_56, p2_.parking AS parking_57, p2_.multi_titles AS multi_titles_58, p2_.latitude AS latitude_59, p2_.longitude AS longitude_60, c3_.id AS id_61, c3_.name AS name_62, c3_.slug AS slug_63, c3_.description AS description_64, c3_.coat_of_arms AS coat_of_arms_65, c3_.latitude AS latitude_66, c3_.longitude AS longitude_67, c4_.id AS id_68, c4_.name AS name_69, c4_.slug AS slug_70, c4_.description AS description_71, c4_.coat_of_arms AS coat_of_arms_72, c4_.latitude AS latitude_73, c4_.longitude AS longitude_74, v5_.id AS id_75, v5_.url AS url_76, v5_.caption AS caption_77, v6_.id AS id_78, v6_.name AS name_79, v6_.website AS website_80, v6_.embed AS embed_81, v6_.shortcut AS shortcut_82, v6_.linked AS linked_83, e0_.city_id AS city_id_84, e0_.place_id AS place_id_85, e0_.rubric_id AS rubric_id_86, e0_.organizer_id AS organizer_id_87, e0_.festival_id AS festival_id_88, p2_.city_id AS city_id_89, p2_.district_id AS district_id_90, c3_.borough_id AS borough_id_91, c4_.borough_id AS borough_id_92, v5_.videostore_id AS videostore_id_93, v5_.event_id AS event_id_94 FROM event e0_ LEFT JOIN rubric r1_ ON e0_.rubric_id = r1_.id LEFT JOIN place p2_ ON e0_.place_id = p2_.id LEFT JOIN city c3_ ON p2_.city_id = c3_.id LEFT JOIN city c4_ ON e0_.city_id = c4_.id LEFT JOIN video v5_ ON e0_.id = v5_.event_id LEFT JOIN videostore v6_ ON v5_.videostore_id = v6_.id LEFT JOIN event_category e8_ ON e0_.id = e8_.event_id LEFT JOIN category c7_ ON c7_.id = e8_.category_id WHERE e0_.is_published = 1 AND e0_.is_validated = 1 AND e0_.date_end >= '2025-10-28' AND c7_.slug = 'atelier-d-ecriture' ORDER BY e0_.date_end ASC, e0_.date_start ASC, e0_.time_start ASC, e0_.date_end ASC, e0_.time_end 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 (?, ?, ?)
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 (133914, 133959, 133496) GROUP BY c0_.id ORDER BY COUNT(e1_.id) DESC, c0_.slug ASC;