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
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.price AS price_4,
  t0.precision_price AS precision_price_5,
  t0.date_start AS date_start_6,
  t0.date_end AS date_end_7,
  t0.time_start AS time_start_8,
  t0.time_end AS time_end_9,
  t0.precision_date AS precision_date_10,
  t0.choice_of_days AS choice_of_days_11,
  t0.description AS description_12,
  t0.cover_image AS cover_image_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.place_temporary AS place_temporary_16,
  t0.is_validated AS is_validated_17,
  t0.is_canceled AS is_canceled_18,
  t0.is_published AS is_published_19,
  t0.is_spam AS is_spam_20,
  t0.is_mistake AS is_mistake_21,
  t0.is_duplicated AS is_duplicated_22,
  t0.is_full AS is_full_23,
  t0.is_postponed AS is_postponed_24,
  t0.links AS links_25,
  t0.oldserial AS oldserial_26,
  t0.mail_anonymous AS mail_anonymous_27,
  t0.ip_anonymous AS ip_anonymous_28,
  t0.secret_anonymous AS secret_anonymous_29,
  t0.date_multiple AS date_multiple_30,
  t0.time_open AS time_open_31,
  t0.city_id AS city_id_32,
  t0.place_id AS place_id_33,
  t0.rubric_id AS rubric_id_34,
  t0.organizer_id AS organizer_id_35,
  t0.festival_id AS festival_id_36,
  t0.author_id AS author_id_37,
  t0.verified_by_id AS verified_by_id_38
FROM
  event t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.price AS price_4, t0.precision_price AS precision_price_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.time_start AS time_start_8, t0.time_end AS time_end_9, t0.precision_date AS precision_date_10, t0.choice_of_days AS choice_of_days_11, t0.description AS description_12, t0.cover_image AS cover_image_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.place_temporary AS place_temporary_16, t0.is_validated AS is_validated_17, t0.is_canceled AS is_canceled_18, t0.is_published AS is_published_19, t0.is_spam AS is_spam_20, t0.is_mistake AS is_mistake_21, t0.is_duplicated AS is_duplicated_22, t0.is_full AS is_full_23, t0.is_postponed AS is_postponed_24, t0.links AS links_25, t0.oldserial AS oldserial_26, t0.mail_anonymous AS mail_anonymous_27, t0.ip_anonymous AS ip_anonymous_28, t0.secret_anonymous AS secret_anonymous_29, t0.date_multiple AS date_multiple_30, t0.time_open AS time_open_31, t0.city_id AS city_id_32, t0.place_id AS place_id_33, t0.rubric_id AS rubric_id_34, t0.organizer_id AS organizer_id_35, t0.festival_id AS festival_id_36, t0.author_id AS author_id_37, t0.verified_by_id AS verified_by_id_38 FROM event t0 WHERE t0.slug = 'le-mega-festival-des-80-s-et-90-s-l-original-a-europa-park-resort' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.cover_image AS cover_image_4,
  t0.description AS description_5,
  t0.pronoun AS pronoun_6,
  t0.name AS name_7,
  t0.number AS number_8,
  t0.address AS address_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.oldserial AS oldserial_12,
  t0.oldurl AS oldurl_13,
  t0.opening AS opening_14,
  t0.links AS links_15,
  t0.map_url AS map_url_16,
  t0.street_url AS street_url_17,
  t0.email AS email_18,
  t0.phone AS phone_19,
  t0.ip AS ip_20,
  t0.transport AS transport_21,
  t0.data_link AS data_link_22,
  t0.opinion AS opinion_23,
  t0.summary AS summary_24,
  t0.wifi AS wifi_25,
  t0.last_service AS last_service_26,
  t0.parking AS parking_27,
  t0.multi_titles AS multi_titles_28,
  t0.latitude AS latitude_29,
  t0.longitude AS longitude_30,
  t0.city_id AS city_id_31,
  t0.district_id AS district_id_32,
  t0.postcode_id AS postcode_id_33,
  t0.placekind_primary_id AS placekind_primary_id_34,
  t0.placekind_secondary_id AS placekind_secondary_id_35,
  t0.placekind_tertiary_id AS placekind_tertiary_id_36,
  t0.author_id AS author_id_37
FROM
  place t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.cover_image AS cover_image_4, t0.description AS description_5, t0.pronoun AS pronoun_6, t0.name AS name_7, t0.number AS number_8, t0.address AS address_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.oldserial AS oldserial_12, t0.oldurl AS oldurl_13, t0.opening AS opening_14, t0.links AS links_15, t0.map_url AS map_url_16, t0.street_url AS street_url_17, t0.email AS email_18, t0.phone AS phone_19, t0.ip AS ip_20, t0.transport AS transport_21, t0.data_link AS data_link_22, t0.opinion AS opinion_23, t0.summary AS summary_24, t0.wifi AS wifi_25, t0.last_service AS last_service_26, t0.parking AS parking_27, t0.multi_titles AS multi_titles_28, t0.latitude AS latitude_29, t0.longitude AS longitude_30, t0.city_id AS city_id_31, t0.district_id AS district_id_32, t0.postcode_id AS postcode_id_33, t0.placekind_primary_id AS placekind_primary_id_34, t0.placekind_secondary_id AS placekind_secondary_id_35, t0.placekind_tertiary_id AS placekind_tertiary_id_36, t0.author_id AS author_id_37 FROM place t0 WHERE t0.id = 2217;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.coat_of_arms AS coat_of_arms_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.borough_id AS borough_id_8,
  t0.department_id AS department_id_9
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.coat_of_arms AS coat_of_arms_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.borough_id AS borough_id_8, t0.department_id AS department_id_9 FROM city t0 WHERE t0.id = 35894;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.country_id AS country_id_4
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.country_id AS country_id_4 FROM region t0 WHERE t0.id = 42;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  category t0
  INNER JOIN event_category ON t0.id = event_category.category_id
WHERE
  event_category.event_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 INNER JOIN event_category ON t0.id = event_category.category_id WHERE event_category.event_id = 134089;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.single AS single_5,
  t0.plural AS plural_6
FROM
  rubric t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4, t0.single AS single_5, t0.plural AS plural_6 FROM rubric t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.code AS code_4
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code AS code_4 FROM country t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.resident AS resident_4,
  t0.chief_town AS chief_town_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.description AS description_8,
  t0.zoom AS zoom_9,
  t0.department_id AS department_id_10,
  t11.id AS id_12,
  t11.name AS name_13,
  t11.slug AS slug_14,
  t11.slogan AS slogan_15,
  t11.color AS color_16,
  t11.resident AS resident_17,
  t11.network AS network_18,
  t11.is_created AS is_created_19,
  t11.is_activated AS is_activated_20,
  t11.created_at AS created_at_21,
  t11.data AS data_22,
  t11.legal AS legal_23,
  t11.wallpaper AS wallpaper_24,
  t11.statistical AS statistical_25,
  t11.manager_id AS manager_id_26,
  t11.main_borough_id AS main_borough_id_27
FROM
  borough t0
  LEFT JOIN subdomain t11 ON t11.main_borough_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.resident AS resident_4, t0.chief_town AS chief_town_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.description AS description_8, t0.zoom AS zoom_9, t0.department_id AS department_id_10, t11.id AS id_12, t11.name AS name_13, t11.slug AS slug_14, t11.slogan AS slogan_15, t11.color AS color_16, t11.resident AS resident_17, t11.network AS network_18, t11.is_created AS is_created_19, t11.is_activated AS is_activated_20, t11.created_at AS created_at_21, t11.data AS data_22, t11.legal AS legal_23, t11.wallpaper AS wallpaper_24, t11.statistical AS statistical_25, t11.manager_id AS manager_id_26, t11.main_borough_id AS main_borough_id_27 FROM borough t0 LEFT JOIN subdomain t11 ON t11.main_borough_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.caption AS caption_3,
  t0.videostore_id AS videostore_id_4,
  t0.event_id AS event_id_5
FROM
  video t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.caption AS caption_3, t0.videostore_id AS videostore_id_4, t0.event_id AS event_id_5 FROM video t0 WHERE t0.event_id = 134089;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.price AS price_3,
  t0.information AS information_4,
  t0.event_id AS event_id_5,
  t0.ticketing_id AS ticketing_id_6
FROM
  ticket t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.price AS price_3, t0.information AS information_4, t0.event_id AS event_id_5, t0.ticketing_id AS ticketing_id_6 FROM ticket t0 WHERE t0.event_id = 134089;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.code AS code_4,
  t0.region_id AS region_id_5
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code AS code_4, t0.region_id AS region_id_5 FROM department t0 WHERE t0.id = 163;