Symfony Profiler

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.address AS address_2,
  v0_.phone AS phone_3,
  v0_.latitude AS latitude_4,
  v0_.longitude AS longitude_5,
  v0_.email AS email_6,
  v0_.www AS www_7,
  v0_.facebook AS facebook_8,
  v0_.twitter AS twitter_9,
  v0_.soundcloud AS soundcloud_10,
  v0_.youtube AS youtube_11,
  v0_.status AS status_12,
  v0_.type AS type_13,
  v0_.google_place_id AS google_place_id_14,
  v0_.slug AS slug_15,
  v0_.date_add AS date_add_16,
  v0_.date_upd AS date_upd_17,
  v0_.user_id AS user_id_18,
  v0_.city_id AS city_id_19
FROM
  venue v0_
WHERE
  v0_.slug = ?
  AND v0_.type IN (?)
LIMIT
  1

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.address AS address_2, v0_.phone AS phone_3, v0_.latitude AS latitude_4, v0_.longitude AS longitude_5, v0_.email AS email_6, v0_.www AS www_7, v0_.facebook AS facebook_8, v0_.twitter AS twitter_9, v0_.soundcloud AS soundcloud_10, v0_.youtube AS youtube_11, v0_.status AS status_12, v0_.type AS type_13, v0_.google_place_id AS google_place_id_14, v0_.slug AS slug_15, v0_.date_add AS date_add_16, v0_.date_upd AS date_upd_17, v0_.user_id AS user_id_18, v0_.city_id AS city_id_19 FROM venue v0_ WHERE v0_.slug = 'statua-piazza-della-resistenza' AND v0_.type IN ('PHYSICAL_VENUE') LIMIT 1;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  event e0_
WHERE
  e0_.venue_id = ?
  AND e0_.active = 1
  AND e0_.deleted = 0
  AND e0_.venue_pending = 0

SELECT COUNT(e0_.id) AS sclr_0 FROM event e0_ WHERE e0_.venue_id = 12889 AND e0_.active = 1 AND e0_.deleted = 0 AND e0_.venue_pending = 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso_code AS iso_code_4,
  t0.language_code AS language_code_5,
  t0.locale AS locale_6,
  t0.is_rtl AS is_rtl_7
FROM
  lang t0
WHERE
  t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.locale AS locale_6, t0.is_rtl AS is_rtl_7 FROM lang t0 WHERE t0.locale = 'it' LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.date_event AS date_event_1,
  e0_.location AS location_2,
  e0_.address AS address_3,
  e0_.latitude AS latitude_4,
  e0_.longitude AS longitude_5,
  e0_.poster_name AS poster_name_6,
  e0_.poster_thumb_name AS poster_thumb_name_7,
  e0_.active AS active_8,
  e0_.deleted AS deleted_9,
  e0_.bandsintown_event_id AS bandsintown_event_id_10,
  e0_.venue_pending AS venue_pending_11,
  e0_.excluded_from_ranking AS excluded_from_ranking_12,
  e0_.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_13,
  e0_.price AS price_14,
  e0_.access AS access_15,
  e0_.date_add AS date_add_16,
  e0_.date_upd AS date_upd_17,
  e0_.followers_notified_at AS followers_notified_at_18,
  e0_.reminder_day_before_sent_at AS reminder_day_before_sent_at_19,
  e0_.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_20,
  e1_.id AS id_21,
  e1_.title AS title_22,
  e1_.slug AS slug_23,
  e1_.description AS description_24,
  e1_.notes AS notes_25,
  e0_.venue_id AS venue_id_26,
  e0_.artist_id AS artist_id_27,
  e0_.band_id AS band_id_28,
  e0_.opener_id AS opener_id_29,
  e1_.event_id AS event_id_30,
  e1_.language_id AS language_id_31
FROM
  event e0_
  LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id
  AND (e1_.language_id = ?)
WHERE
  e0_.venue_id = ?
  AND e0_.date_event >= ?
ORDER BY
  e0_.date_event ASC
LIMIT
  5

SELECT e0_.id AS id_0, e0_.date_event AS date_event_1, e0_.location AS location_2, e0_.address AS address_3, e0_.latitude AS latitude_4, e0_.longitude AS longitude_5, e0_.poster_name AS poster_name_6, e0_.poster_thumb_name AS poster_thumb_name_7, e0_.active AS active_8, e0_.deleted AS deleted_9, e0_.bandsintown_event_id AS bandsintown_event_id_10, e0_.venue_pending AS venue_pending_11, e0_.excluded_from_ranking AS excluded_from_ranking_12, e0_.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_13, e0_.price AS price_14, e0_.access AS access_15, e0_.date_add AS date_add_16, e0_.date_upd AS date_upd_17, e0_.followers_notified_at AS followers_notified_at_18, e0_.reminder_day_before_sent_at AS reminder_day_before_sent_at_19, e0_.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_20, e1_.id AS id_21, e1_.title AS title_22, e1_.slug AS slug_23, e1_.description AS description_24, e1_.notes AS notes_25, e0_.venue_id AS venue_id_26, e0_.artist_id AS artist_id_27, e0_.band_id AS band_id_28, e0_.opener_id AS opener_id_29, e1_.event_id AS event_id_30, e1_.language_id AS language_id_31 FROM event e0_ LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id AND (e1_.language_id = 1) WHERE e0_.venue_id = 12889 AND e0_.date_event >= '2026-11-02 15:10:47' ORDER BY e0_.date_event ASC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.logistics AS logistics_2,
  t0.rating_stage AS rating_stage_3,
  t0.rating_backstage AS rating_backstage_4,
  t0.rating_audio AS rating_audio_5,
  t0.rating_public AS rating_public_6,
  t0.rating_staff AS rating_staff_7,
  t0.rating_overall AS rating_overall_8,
  t0.comment AS comment_9,
  t0.date_add AS date_add_10,
  t0.date_upd AS date_upd_11,
  t0.artist_id AS artist_id_12,
  t0.event_id AS event_id_13,
  t0.venue_id AS venue_id_14
FROM
  venue_review t0
WHERE
  t0.venue_id = ?
ORDER BY
  t0.date_add DESC

SELECT t0.id AS id_1, t0.logistics AS logistics_2, t0.rating_stage AS rating_stage_3, t0.rating_backstage AS rating_backstage_4, t0.rating_audio AS rating_audio_5, t0.rating_public AS rating_public_6, t0.rating_staff AS rating_staff_7, t0.rating_overall AS rating_overall_8, t0.comment AS comment_9, t0.date_add AS date_add_10, t0.date_upd AS date_upd_11, t0.artist_id AS artist_id_12, t0.event_id AS event_id_13, t0.venue_id AS venue_id_14 FROM venue_review t0 WHERE t0.venue_id = 12889 ORDER BY t0.date_add DESC;

SELECT
  t0.excerpt AS excerpt_1,
  t0.description AS description_2,
  t0.opening_time AS opening_time_3,
  t0.event_time AS event_time_4,
  t0.instrumentation AS instrumentation_5,
  t0.stage AS stage_6,
  t0.service AS service_7,
  t0.checksound_time AS checksound_time_8,
  t0.more_info AS more_info_9,
  t0.venue_id AS venue_id_10,
  t0.language_id AS language_id_11
FROM
  venue_lang t0
WHERE
  t0.venue_id = ?

SELECT t0.excerpt AS excerpt_1, t0.description AS description_2, t0.opening_time AS opening_time_3, t0.event_time AS event_time_4, t0.instrumentation AS instrumentation_5, t0.stage AS stage_6, t0.service AS service_7, t0.checksound_time AS checksound_time_8, t0.more_info AS more_info_9, t0.venue_id AS venue_id_10, t0.language_id AS language_id_11 FROM venue_lang t0 WHERE t0.venue_id = 12889;

SELECT
  c0_.id AS id_0
FROM
  call_for_artists c0_
WHERE
  c0_.starts_at <= ?
  AND c0_.ends_at >= ?
LIMIT
  1

SELECT c0_.id AS id_0 FROM call_for_artists c0_ WHERE c0_.starts_at <= '2026-11-02 15:10:47' AND c0_.ends_at >= '2026-11-02 15:10:47' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.state AS state_4,
  t0.people AS people_5,
  t0.google_place_id AS google_place_id_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.country_id AS country_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.state AS state_4, t0.people AS people_5, t0.google_place_id AS google_place_id_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.country_id AS country_id_9 FROM city t0 WHERE t0.id = 7106;