Symfony Profiler

SELECT
  DISTINCT UPPER(
    SUBSTRING(
      v0_.name
      FROM
        1 FOR 1
    )
  ) AS sclr_0
FROM
  venue v0_
WHERE
  v0_.type IN (?)
  AND (
    EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        event e1_
      WHERE
        e1_.venue_id = v0_.id
        AND e1_.active = 1
        AND e1_.deleted = 0
        AND e1_.venue_pending = 0
    )
  )

SELECT DISTINCT UPPER(SUBSTRING(v0_.name FROM 1 FOR 1)) AS sclr_0 FROM venue v0_ WHERE v0_.type IN ('PHYSICAL_VENUE') AND (EXISTS (SELECT 1 AS sclr_1 FROM event e1_ WHERE e1_.venue_id = v0_.id AND e1_.active = 1 AND e1_.deleted = 0 AND e1_.venue_pending = 0));

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  venue v0_
  LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id
  AND (
    v0_.id = v1_.venue_id
    AND v1_.language_id = ?
  )
WHERE
  v0_.type IN (?)
  AND (
    EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        event e2_
      WHERE
        e2_.venue_id = v0_.id
        AND e2_.active = 1
        AND e2_.deleted = 0
        AND e2_.venue_pending = 0
    )
  )

SELECT COUNT(v0_.id) AS sclr_0 FROM venue v0_ LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id AND (v0_.id = v1_.venue_id AND v1_.language_id = 1) WHERE v0_.type IN ('PHYSICAL_VENUE') AND (EXISTS (SELECT 1 AS sclr_1 FROM event e2_ WHERE e2_.venue_id = v0_.id AND e2_.active = 1 AND e2_.deleted = 0 AND e2_.venue_pending = 0));

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,
  v1_.excerpt AS excerpt_18,
  v1_.description AS description_19,
  v1_.opening_time AS opening_time_20,
  v1_.event_time AS event_time_21,
  v1_.instrumentation AS instrumentation_22,
  v1_.stage AS stage_23,
  v1_.service AS service_24,
  v1_.checksound_time AS checksound_time_25,
  v1_.more_info AS more_info_26,
  v0_.user_id AS user_id_27,
  v0_.city_id AS city_id_28,
  v1_.venue_id AS venue_id_29,
  v1_.language_id AS language_id_30
FROM
  venue v0_
  LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id
  AND (
    v0_.id = v1_.venue_id
    AND v1_.language_id = ?
  )
WHERE
  v0_.type IN (?)
  AND (
    EXISTS (
      SELECT
        1 AS sclr_31
      FROM
        event e2_
      WHERE
        e2_.venue_id = v0_.id
        AND e2_.active = 1
        AND e2_.deleted = 0
        AND e2_.venue_pending = 0
    )
  )
ORDER BY
  v0_.name ASC
LIMIT
  9
OFFSET
  45

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, v1_.excerpt AS excerpt_18, v1_.description AS description_19, v1_.opening_time AS opening_time_20, v1_.event_time AS event_time_21, v1_.instrumentation AS instrumentation_22, v1_.stage AS stage_23, v1_.service AS service_24, v1_.checksound_time AS checksound_time_25, v1_.more_info AS more_info_26, v0_.user_id AS user_id_27, v0_.city_id AS city_id_28, v1_.venue_id AS venue_id_29, v1_.language_id AS language_id_30 FROM venue v0_ LEFT JOIN venue_lang v1_ ON v0_.id = v1_.venue_id AND (v0_.id = v1_.venue_id AND v1_.language_id = 1) WHERE v0_.type IN ('PHYSICAL_VENUE') AND (EXISTS (SELECT 1 AS sclr_31 FROM event e2_ WHERE e2_.venue_id = v0_.id AND e2_.active = 1 AND e2_.deleted = 0 AND e2_.venue_pending = 0)) ORDER BY v0_.name ASC LIMIT 9 OFFSET 45;

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 14:38:18' AND c0_.ends_at >= '2026-11-02 14:38:18' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date_event AS date_event_2,
  t0.location AS location_3,
  t0.address AS address_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.poster_name AS poster_name_7,
  t0.poster_thumb_name AS poster_thumb_name_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.bandsintown_event_id AS bandsintown_event_id_11,
  t0.venue_pending AS venue_pending_12,
  t0.excluded_from_ranking AS excluded_from_ranking_13,
  t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14,
  t0.price AS price_15,
  t0.access AS access_16,
  t0.date_add AS date_add_17,
  t0.date_upd AS date_upd_18,
  t0.followers_notified_at AS followers_notified_at_19,
  t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20,
  t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21,
  t0.venue_id AS venue_id_22,
  t0.artist_id AS artist_id_23,
  t0.band_id AS band_id_24,
  t0.opener_id AS opener_id_25
FROM
  event t0
WHERE
  t0.venue_id = ?

SELECT t0.id AS id_1, t0.date_event AS date_event_2, t0.location AS location_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.poster_name AS poster_name_7, t0.poster_thumb_name AS poster_thumb_name_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.bandsintown_event_id AS bandsintown_event_id_11, t0.venue_pending AS venue_pending_12, t0.excluded_from_ranking AS excluded_from_ranking_13, t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14, t0.price AS price_15, t0.access AS access_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.followers_notified_at AS followers_notified_at_19, t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20, t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21, t0.venue_id AS venue_id_22, t0.artist_id AS artist_id_23, t0.band_id AS band_id_24, t0.opener_id AS opener_id_25 FROM event t0 WHERE t0.venue_id = 12884;

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

SELECT
  t0.id AS id_1,
  t0.date_event AS date_event_2,
  t0.location AS location_3,
  t0.address AS address_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.poster_name AS poster_name_7,
  t0.poster_thumb_name AS poster_thumb_name_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.bandsintown_event_id AS bandsintown_event_id_11,
  t0.venue_pending AS venue_pending_12,
  t0.excluded_from_ranking AS excluded_from_ranking_13,
  t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14,
  t0.price AS price_15,
  t0.access AS access_16,
  t0.date_add AS date_add_17,
  t0.date_upd AS date_upd_18,
  t0.followers_notified_at AS followers_notified_at_19,
  t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20,
  t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21,
  t0.venue_id AS venue_id_22,
  t0.artist_id AS artist_id_23,
  t0.band_id AS band_id_24,
  t0.opener_id AS opener_id_25
FROM
  event t0
WHERE
  t0.venue_id = ?

SELECT t0.id AS id_1, t0.date_event AS date_event_2, t0.location AS location_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.poster_name AS poster_name_7, t0.poster_thumb_name AS poster_thumb_name_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.bandsintown_event_id AS bandsintown_event_id_11, t0.venue_pending AS venue_pending_12, t0.excluded_from_ranking AS excluded_from_ranking_13, t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14, t0.price AS price_15, t0.access AS access_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.followers_notified_at AS followers_notified_at_19, t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20, t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21, t0.venue_id AS venue_id_22, t0.artist_id AS artist_id_23, t0.band_id AS band_id_24, t0.opener_id AS opener_id_25 FROM event t0 WHERE t0.venue_id = 12848;

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

SELECT
  t0.id AS id_1,
  t0.date_event AS date_event_2,
  t0.location AS location_3,
  t0.address AS address_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.poster_name AS poster_name_7,
  t0.poster_thumb_name AS poster_thumb_name_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.bandsintown_event_id AS bandsintown_event_id_11,
  t0.venue_pending AS venue_pending_12,
  t0.excluded_from_ranking AS excluded_from_ranking_13,
  t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14,
  t0.price AS price_15,
  t0.access AS access_16,
  t0.date_add AS date_add_17,
  t0.date_upd AS date_upd_18,
  t0.followers_notified_at AS followers_notified_at_19,
  t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20,
  t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21,
  t0.venue_id AS venue_id_22,
  t0.artist_id AS artist_id_23,
  t0.band_id AS band_id_24,
  t0.opener_id AS opener_id_25
FROM
  event t0
WHERE
  t0.venue_id = ?

SELECT t0.id AS id_1, t0.date_event AS date_event_2, t0.location AS location_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.poster_name AS poster_name_7, t0.poster_thumb_name AS poster_thumb_name_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.bandsintown_event_id AS bandsintown_event_id_11, t0.venue_pending AS venue_pending_12, t0.excluded_from_ranking AS excluded_from_ranking_13, t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14, t0.price AS price_15, t0.access AS access_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.followers_notified_at AS followers_notified_at_19, t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20, t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21, t0.venue_id AS venue_id_22, t0.artist_id AS artist_id_23, t0.band_id AS band_id_24, t0.opener_id AS opener_id_25 FROM event t0 WHERE t0.venue_id = 12846;

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

SELECT
  t0.id AS id_1,
  t0.date_event AS date_event_2,
  t0.location AS location_3,
  t0.address AS address_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.poster_name AS poster_name_7,
  t0.poster_thumb_name AS poster_thumb_name_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.bandsintown_event_id AS bandsintown_event_id_11,
  t0.venue_pending AS venue_pending_12,
  t0.excluded_from_ranking AS excluded_from_ranking_13,
  t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14,
  t0.price AS price_15,
  t0.access AS access_16,
  t0.date_add AS date_add_17,
  t0.date_upd AS date_upd_18,
  t0.followers_notified_at AS followers_notified_at_19,
  t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20,
  t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21,
  t0.venue_id AS venue_id_22,
  t0.artist_id AS artist_id_23,
  t0.band_id AS band_id_24,
  t0.opener_id AS opener_id_25
FROM
  event t0
WHERE
  t0.venue_id = ?

SELECT t0.id AS id_1, t0.date_event AS date_event_2, t0.location AS location_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.poster_name AS poster_name_7, t0.poster_thumb_name AS poster_thumb_name_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.bandsintown_event_id AS bandsintown_event_id_11, t0.venue_pending AS venue_pending_12, t0.excluded_from_ranking AS excluded_from_ranking_13, t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14, t0.price AS price_15, t0.access AS access_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.followers_notified_at AS followers_notified_at_19, t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20, t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21, t0.venue_id AS venue_id_22, t0.artist_id AS artist_id_23, t0.band_id AS band_id_24, t0.opener_id AS opener_id_25 FROM event t0 WHERE t0.venue_id = 12865;

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

SELECT
  t0.id AS id_1,
  t0.date_event AS date_event_2,
  t0.location AS location_3,
  t0.address AS address_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.poster_name AS poster_name_7,
  t0.poster_thumb_name AS poster_thumb_name_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.bandsintown_event_id AS bandsintown_event_id_11,
  t0.venue_pending AS venue_pending_12,
  t0.excluded_from_ranking AS excluded_from_ranking_13,
  t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14,
  t0.price AS price_15,
  t0.access AS access_16,
  t0.date_add AS date_add_17,
  t0.date_upd AS date_upd_18,
  t0.followers_notified_at AS followers_notified_at_19,
  t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20,
  t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21,
  t0.venue_id AS venue_id_22,
  t0.artist_id AS artist_id_23,
  t0.band_id AS band_id_24,
  t0.opener_id AS opener_id_25
FROM
  event t0
WHERE
  t0.venue_id = ?

SELECT t0.id AS id_1, t0.date_event AS date_event_2, t0.location AS location_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.poster_name AS poster_name_7, t0.poster_thumb_name AS poster_thumb_name_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.bandsintown_event_id AS bandsintown_event_id_11, t0.venue_pending AS venue_pending_12, t0.excluded_from_ranking AS excluded_from_ranking_13, t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14, t0.price AS price_15, t0.access AS access_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.followers_notified_at AS followers_notified_at_19, t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20, t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21, t0.venue_id AS venue_id_22, t0.artist_id AS artist_id_23, t0.band_id AS band_id_24, t0.opener_id AS opener_id_25 FROM event t0 WHERE t0.venue_id = 12856;

SELECT
  t0.id AS id_1,
  t0.date_event AS date_event_2,
  t0.location AS location_3,
  t0.address AS address_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.poster_name AS poster_name_7,
  t0.poster_thumb_name AS poster_thumb_name_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.bandsintown_event_id AS bandsintown_event_id_11,
  t0.venue_pending AS venue_pending_12,
  t0.excluded_from_ranking AS excluded_from_ranking_13,
  t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14,
  t0.price AS price_15,
  t0.access AS access_16,
  t0.date_add AS date_add_17,
  t0.date_upd AS date_upd_18,
  t0.followers_notified_at AS followers_notified_at_19,
  t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20,
  t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21,
  t0.venue_id AS venue_id_22,
  t0.artist_id AS artist_id_23,
  t0.band_id AS band_id_24,
  t0.opener_id AS opener_id_25
FROM
  event t0
WHERE
  t0.venue_id = ?

SELECT t0.id AS id_1, t0.date_event AS date_event_2, t0.location AS location_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.poster_name AS poster_name_7, t0.poster_thumb_name AS poster_thumb_name_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.bandsintown_event_id AS bandsintown_event_id_11, t0.venue_pending AS venue_pending_12, t0.excluded_from_ranking AS excluded_from_ranking_13, t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14, t0.price AS price_15, t0.access AS access_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.followers_notified_at AS followers_notified_at_19, t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20, t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21, t0.venue_id AS venue_id_22, t0.artist_id AS artist_id_23, t0.band_id AS band_id_24, t0.opener_id AS opener_id_25 FROM event t0 WHERE t0.venue_id = 12983;