Symfony Profiler

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.city_id AS city_id_26,
  t0.place_id AS place_id_27,
  t0.rubric_id AS rubric_id_28,
  t0.organizer_id AS organizer_id_29,
  t0.festival_id AS festival_id_30
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.city_id AS city_id_26, t0.place_id AS place_id_27, t0.rubric_id AS rubric_id_28, t0.organizer_id AS organizer_id_29, t0.festival_id AS festival_id_30 FROM event t0 WHERE t0.slug = 'il-cammino-della-ninfa' LIMIT 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

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
  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 = 1;

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 = 133944;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.cover_image AS cover_image_4,
  t0.description AS description_5
FROM
  artist t0
  INNER JOIN artist_event ON t0.id = artist_event.artist_id
WHERE
  artist_event.event_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.cover_image AS cover_image_4, t0.description AS description_5 FROM artist t0 INNER JOIN artist_event ON t0.id = artist_event.artist_id WHERE artist_event.event_id = 133944;

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 = 133944;

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_

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_;

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

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