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_.is_created AS is_created_7,
  s0_.is_activated AS is_activated_8,
  s0_.created_at AS created_at_9,
  s0_.data AS data_10,
  s0_.legal AS legal_11,
  s0_.wallpaper AS wallpaper_12,
  s0_.statistical AS statistical_13,
  s0_.manager_id AS manager_id_14,
  s0_.main_borough_id AS main_borough_id_15
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_.is_created AS is_created_7, s0_.is_activated AS is_activated_8, s0_.created_at AS created_at_9, s0_.data AS data_10, s0_.legal AS legal_11, s0_.wallpaper AS wallpaper_12, s0_.statistical AS statistical_13, s0_.manager_id AS manager_id_14, s0_.main_borough_id AS main_borough_id_15 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 >= '2026-08-14' GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC;

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,
  e0_.oldserial AS oldserial_25,
  e0_.mail_anonymous AS mail_anonymous_26,
  e0_.ip_anonymous AS ip_anonymous_27,
  e0_.secret_anonymous AS secret_anonymous_28,
  e0_.date_multiple AS date_multiple_29,
  e0_.time_open AS time_open_30,
  r1_.id AS id_31,
  r1_.name AS name_32,
  r1_.slug AS slug_33,
  r1_.color AS color_34,
  r1_.single AS single_35,
  r1_.plural AS plural_36,
  p2_.id AS id_37,
  p2_.title AS title_38,
  p2_.slug AS slug_39,
  p2_.cover_image AS cover_image_40,
  p2_.description AS description_41,
  p2_.pronoun AS pronoun_42,
  p2_.name AS name_43,
  p2_.number AS number_44,
  p2_.address AS address_45,
  p2_.created_at AS created_at_46,
  p2_.updated_at AS updated_at_47,
  p2_.oldserial AS oldserial_48,
  p2_.oldurl AS oldurl_49,
  p2_.opening AS opening_50,
  p2_.links AS links_51,
  p2_.map_url AS map_url_52,
  p2_.street_url AS street_url_53,
  p2_.email AS email_54,
  p2_.phone AS phone_55,
  p2_.ip AS ip_56,
  p2_.transport AS transport_57,
  p2_.data_link AS data_link_58,
  p2_.opinion AS opinion_59,
  p2_.summary AS summary_60,
  p2_.wifi AS wifi_61,
  p2_.last_service AS last_service_62,
  p2_.parking AS parking_63,
  p2_.multi_titles AS multi_titles_64,
  p2_.latitude AS latitude_65,
  p2_.longitude AS longitude_66,
  c3_.id AS id_67,
  c3_.name AS name_68,
  c3_.slug AS slug_69,
  c3_.description AS description_70,
  c3_.coat_of_arms AS coat_of_arms_71,
  c3_.latitude AS latitude_72,
  c3_.longitude AS longitude_73,
  c4_.id AS id_74,
  c4_.name AS name_75,
  c4_.slug AS slug_76,
  c4_.description AS description_77,
  c4_.coat_of_arms AS coat_of_arms_78,
  c4_.latitude AS latitude_79,
  c4_.longitude AS longitude_80,
  c5_.id AS id_81,
  c5_.name AS name_82,
  c5_.slug AS slug_83,
  v6_.id AS id_84,
  v6_.url AS url_85,
  v6_.caption AS caption_86,
  v7_.id AS id_87,
  v7_.name AS name_88,
  v7_.website AS website_89,
  v7_.embed AS embed_90,
  v7_.shortcut AS shortcut_91,
  v7_.linked AS linked_92,
  t8_.id AS id_93,
  t8_.url AS url_94,
  t8_.price AS price_95,
  t8_.information AS information_96,
  t9_.id AS id_97,
  t9_.name AS name_98,
  t9_.website AS website_99,
  t9_.embed AS embed_100,
  t9_.setting AS setting_101,
  t9_.source AS source_102,
  t9_.linked AS linked_103,
  t9_.domain AS domain_104,
  t9_.redirections AS redirections_105,
  t9_.is_activated AS is_activated_106,
  t9_.is_embeddable AS is_embeddable_107,
  t9_.is_only_responsive AS is_only_responsive_108,
  e0_.city_id AS city_id_109,
  e0_.place_id AS place_id_110,
  e0_.rubric_id AS rubric_id_111,
  e0_.organizer_id AS organizer_id_112,
  e0_.festival_id AS festival_id_113,
  e0_.author_id AS author_id_114,
  e0_.verified_by_id AS verified_by_id_115,
  p2_.city_id AS city_id_116,
  p2_.district_id AS district_id_117,
  p2_.postcode_id AS postcode_id_118,
  p2_.placekind_primary_id AS placekind_primary_id_119,
  p2_.placekind_secondary_id AS placekind_secondary_id_120,
  p2_.placekind_tertiary_id AS placekind_tertiary_id_121,
  p2_.author_id AS author_id_122,
  c3_.borough_id AS borough_id_123,
  c3_.department_id AS department_id_124,
  c4_.borough_id AS borough_id_125,
  c4_.department_id AS department_id_126,
  v6_.videostore_id AS videostore_id_127,
  v6_.event_id AS event_id_128,
  t8_.event_id AS event_id_129,
  t8_.ticketing_id AS ticketing_id_130
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 event_category e10_ ON e0_.id = e10_.event_id
  LEFT JOIN category c5_ ON c5_.id = e10_.category_id
  LEFT JOIN video v6_ ON e0_.id = v6_.event_id
  LEFT JOIN videostore v7_ ON v6_.videostore_id = v7_.id
  LEFT JOIN ticket t8_ ON e0_.id = t8_.event_id
  LEFT JOIN ticketing t9_ ON t8_.ticketing_id = t9_.id
  LEFT JOIN event_category e12_ ON e0_.id = e12_.event_id
  LEFT JOIN category c11_ ON c11_.id = e12_.category_id
WHERE
  e0_.is_published = 1
  AND e0_.is_validated = 1
  AND e0_.date_end >= ?
  AND c11_.slug = ?
ORDER BY
  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, e0_.oldserial AS oldserial_25, e0_.mail_anonymous AS mail_anonymous_26, e0_.ip_anonymous AS ip_anonymous_27, e0_.secret_anonymous AS secret_anonymous_28, e0_.date_multiple AS date_multiple_29, e0_.time_open AS time_open_30, r1_.id AS id_31, r1_.name AS name_32, r1_.slug AS slug_33, r1_.color AS color_34, r1_.single AS single_35, r1_.plural AS plural_36, p2_.id AS id_37, p2_.title AS title_38, p2_.slug AS slug_39, p2_.cover_image AS cover_image_40, p2_.description AS description_41, p2_.pronoun AS pronoun_42, p2_.name AS name_43, p2_.number AS number_44, p2_.address AS address_45, p2_.created_at AS created_at_46, p2_.updated_at AS updated_at_47, p2_.oldserial AS oldserial_48, p2_.oldurl AS oldurl_49, p2_.opening AS opening_50, p2_.links AS links_51, p2_.map_url AS map_url_52, p2_.street_url AS street_url_53, p2_.email AS email_54, p2_.phone AS phone_55, p2_.ip AS ip_56, p2_.transport AS transport_57, p2_.data_link AS data_link_58, p2_.opinion AS opinion_59, p2_.summary AS summary_60, p2_.wifi AS wifi_61, p2_.last_service AS last_service_62, p2_.parking AS parking_63, p2_.multi_titles AS multi_titles_64, p2_.latitude AS latitude_65, p2_.longitude AS longitude_66, c3_.id AS id_67, c3_.name AS name_68, c3_.slug AS slug_69, c3_.description AS description_70, c3_.coat_of_arms AS coat_of_arms_71, c3_.latitude AS latitude_72, c3_.longitude AS longitude_73, c4_.id AS id_74, c4_.name AS name_75, c4_.slug AS slug_76, c4_.description AS description_77, c4_.coat_of_arms AS coat_of_arms_78, c4_.latitude AS latitude_79, c4_.longitude AS longitude_80, c5_.id AS id_81, c5_.name AS name_82, c5_.slug AS slug_83, v6_.id AS id_84, v6_.url AS url_85, v6_.caption AS caption_86, v7_.id AS id_87, v7_.name AS name_88, v7_.website AS website_89, v7_.embed AS embed_90, v7_.shortcut AS shortcut_91, v7_.linked AS linked_92, t8_.id AS id_93, t8_.url AS url_94, t8_.price AS price_95, t8_.information AS information_96, t9_.id AS id_97, t9_.name AS name_98, t9_.website AS website_99, t9_.embed AS embed_100, t9_.setting AS setting_101, t9_.source AS source_102, t9_.linked AS linked_103, t9_.domain AS domain_104, t9_.redirections AS redirections_105, t9_.is_activated AS is_activated_106, t9_.is_embeddable AS is_embeddable_107, t9_.is_only_responsive AS is_only_responsive_108, e0_.city_id AS city_id_109, e0_.place_id AS place_id_110, e0_.rubric_id AS rubric_id_111, e0_.organizer_id AS organizer_id_112, e0_.festival_id AS festival_id_113, e0_.author_id AS author_id_114, e0_.verified_by_id AS verified_by_id_115, p2_.city_id AS city_id_116, p2_.district_id AS district_id_117, p2_.postcode_id AS postcode_id_118, p2_.placekind_primary_id AS placekind_primary_id_119, p2_.placekind_secondary_id AS placekind_secondary_id_120, p2_.placekind_tertiary_id AS placekind_tertiary_id_121, p2_.author_id AS author_id_122, c3_.borough_id AS borough_id_123, c3_.department_id AS department_id_124, c4_.borough_id AS borough_id_125, c4_.department_id AS department_id_126, v6_.videostore_id AS videostore_id_127, v6_.event_id AS event_id_128, t8_.event_id AS event_id_129, t8_.ticketing_id AS ticketing_id_130 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 event_category e10_ ON e0_.id = e10_.event_id LEFT JOIN category c5_ ON c5_.id = e10_.category_id LEFT JOIN video v6_ ON e0_.id = v6_.event_id LEFT JOIN videostore v7_ ON v6_.videostore_id = v7_.id LEFT JOIN ticket t8_ ON e0_.id = t8_.event_id LEFT JOIN ticketing t9_ ON t8_.ticketing_id = t9_.id LEFT JOIN event_category e12_ ON e0_.id = e12_.event_id LEFT JOIN category c11_ ON c11_.id = e12_.category_id WHERE e0_.is_published = 1 AND e0_.is_validated = 1 AND e0_.date_end >= '2026-08-14' AND c11_.slug = 'marche' ORDER BY e0_.date_start ASC, e0_.time_start ASC, e0_.date_end ASC, e0_.time_end ASC;

SELECT
  p0_.slug AS slug_0,
  p0_.title AS title_1
FROM
  place p0_
WHERE
  EXISTS (
    SELECT
      e1_.id
    FROM
      event e1_
    WHERE
      e1_.place_id = p0_.id
      AND e1_.is_published = 1
      AND e1_.is_validated = 1
      AND e1_.date_end >= ?
  )
ORDER BY
  p0_.title ASC
LIMIT
  300

SELECT p0_.slug AS slug_0, p0_.title AS title_1 FROM place p0_ WHERE EXISTS (SELECT e1_.id FROM event e1_ WHERE e1_.place_id = p0_.id AND e1_.is_published = 1 AND e1_.is_validated = 1 AND e1_.date_end >= '2026-08-14 00:00:00') ORDER BY p0_.title ASC LIMIT 300;

SELECT
  c0_.slug AS slug_0,
  c0_.name AS name_1
FROM
  city c0_
  INNER JOIN event e1_ ON c0_.id = e1_.city_id
WHERE
  e1_.is_published = 1
  AND e1_.is_validated = 1
  AND e1_.date_end >= ?
GROUP BY
  c0_.id
ORDER BY
  c0_.name ASC
LIMIT
  300

SELECT c0_.slug AS slug_0, c0_.name AS name_1 FROM city c0_ INNER JOIN event e1_ ON c0_.id = e1_.city_id WHERE e1_.is_published = 1 AND e1_.is_validated = 1 AND e1_.date_end >= '2026-08-14' GROUP BY c0_.id ORDER BY c0_.name ASC LIMIT 300;

SELECT
  COUNT(DISTINCT e0_.id) AS sclr_0
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 e0_.city_id = c3_.id
  LEFT JOIN event_category e5_ ON e0_.id = e5_.event_id
  LEFT JOIN category c4_ ON c4_.id = e5_.category_id
WHERE
  e0_.is_published = 1
  AND e0_.is_validated = 1
  AND e0_.date_end >= ?
  AND c4_.slug = ?

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 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 e0_.city_id = c3_.id LEFT JOIN event_category e5_ ON e0_.id = e5_.event_id LEFT JOIN category c4_ ON c4_.id = e5_.category_id WHERE e0_.is_published = 1 AND e0_.is_validated = 1 AND e0_.date_end >= '2026-08-14' AND c4_.slug = 'marche';

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 = 'marche' LIMIT 1;

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 (139676, 138943) GROUP BY c0_.id ORDER BY COUNT(e1_.id) DESC, c0_.slug ASC;