Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.foundation_year AS foundation_year_5,
  t0.website AS website_6,
  t0.facebook AS facebook_7,
  t0.instagram AS instagram_8,
  t0.tiktok AS tiktok_9,
  t0.soundcloud AS soundcloud_10,
  t0.youtube AS youtube_11,
  t0.discord AS discord_12,
  t0.twitter AS twitter_13,
  t0.spotify AS spotify_14,
  t0.twitch AS twitch_15,
  t0.bandsintown AS bandsintown_16,
  t0.bandsintown_api_key AS bandsintown_api_key_17,
  t0.cover_name AS cover_name_18,
  t0.cover_thumb AS cover_thumb_19,
  t0.date_add AS date_add_20,
  t0.date_upd AS date_upd_21,
  t0.total_points AS total_points_22,
  t0.ranking_position AS ranking_position_23,
  t0.city_id AS city_id_24,
  t0.owner_id AS owner_id_25,
  t0.current_tier_id AS current_tier_id_26
FROM
  band t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.slug AS slug_4, t0.foundation_year AS foundation_year_5, t0.website AS website_6, t0.facebook AS facebook_7, t0.instagram AS instagram_8, t0.tiktok AS tiktok_9, t0.soundcloud AS soundcloud_10, t0.youtube AS youtube_11, t0.discord AS discord_12, t0.twitter AS twitter_13, t0.spotify AS spotify_14, t0.twitch AS twitch_15, t0.bandsintown AS bandsintown_16, t0.bandsintown_api_key AS bandsintown_api_key_17, t0.cover_name AS cover_name_18, t0.cover_thumb AS cover_thumb_19, t0.date_add AS date_add_20, t0.date_upd AS date_upd_21, t0.total_points AS total_points_22, t0.ranking_position AS ranking_position_23, t0.city_id AS city_id_24, t0.owner_id AS owner_id_25, t0.current_tier_id AS current_tier_id_26 FROM band t0 WHERE t0.slug = 'fuori-dall-hype' LIMIT 1;

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user_band_follow u0_
WHERE
  u0_.band_id = ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user_band_follow u0_ WHERE u0_.band_id = 27;

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_.band_id = ?
  AND e0_.date_event >= ?
  AND e0_.venue_pending = 0
ORDER BY
  e0_.date_event ASC,
  e0_.id ASC
LIMIT
  4

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 = 2) WHERE e0_.band_id = 27 AND e0_.date_event >= '2026-11-02 14:07:19' AND e0_.venue_pending = 0 ORDER BY e0_.date_event ASC, e0_.id ASC LIMIT 4;

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_.band_id = ?
  AND e0_.date_event < ?
  AND e0_.active = 1
  AND e0_.deleted = 0
  AND e0_.venue_pending = 0
ORDER BY
  e0_.date_event DESC,
  e0_.id DESC
LIMIT
  4

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 = 2) WHERE e0_.band_id = 27 AND e0_.date_event < '2026-11-02 14:07:19' AND e0_.active = 1 AND e0_.deleted = 0 AND e0_.venue_pending = 0 ORDER BY e0_.date_event DESC, e0_.id DESC LIMIT 4;

SELECT
  COUNT(DISTINCT e0_.id) AS sclr_0
FROM
  event_vote_reaction e1_
  INNER JOIN event_vote e0_ ON e1_.vote_id = e0_.id
  INNER JOIN event e2_ ON e0_.event_id = e2_.id
WHERE
  e2_.band_id = ?

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM event_vote_reaction e1_ INNER JOIN event_vote e0_ ON e1_.vote_id = e0_.id INNER JOIN event e2_ ON e0_.event_id = e2_.id WHERE e2_.band_id = 27;

SELECT
  e0_.reaction AS reaction_0,
  COUNT(e0_.id) AS sclr_1
FROM
  event_vote_reaction e0_
  INNER JOIN event_vote e1_ ON e0_.vote_id = e1_.id
  INNER JOIN event e2_ ON e1_.event_id = e2_.id
WHERE
  e2_.band_id = ?
GROUP BY
  e0_.reaction

SELECT e0_.reaction AS reaction_0, COUNT(e0_.id) AS sclr_1 FROM event_vote_reaction e0_ INNER JOIN event_vote e1_ ON e0_.vote_id = e1_.id INNER JOIN event e2_ ON e1_.event_id = e2_.id WHERE e2_.band_id = 27 GROUP BY e0_.reaction;

SELECT
  t0.id AS id_1,
  t0.description_short AS description_short_2,
  t0.description AS description_3,
  t0.date_add AS date_add_4,
  t0.date_upd AS date_upd_5,
  t0.band_id AS band_id_6,
  t0.lang_id AS lang_id_7
FROM
  band_lang t0
WHERE
  t0.band_id = ?

SELECT t0.id AS id_1, t0.description_short AS description_short_2, t0.description AS description_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.band_id AS band_id_6, t0.lang_id AS lang_id_7 FROM band_lang t0 WHERE t0.band_id = 27;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.nickname AS nickname_4,
  t0.slug AS slug_5,
  t0.excerpt AS excerpt_6,
  t0.mood AS mood_7,
  t0.exhibition AS exhibition_8,
  t0.crew AS crew_9,
  t0.biography AS biography_10,
  t0.original AS original_11,
  t0.cover AS cover_12,
  t0.instrumentation AS instrumentation_13,
  t0.willingness AS willingness_14,
  t0.www AS www_15,
  t0.facebook AS facebook_16,
  t0.twitter AS twitter_17,
  t0.soundcloud AS soundcloud_18,
  t0.youtube AS youtube_19,
  t0.avatar AS avatar_20,
  t0.wide AS wide_21,
  t0.thumb AS thumb_22,
  t0.privacy AS privacy_23,
  t0.solo_artist AS solo_artist_24,
  t0.avatar_name AS avatar_name_25,
  t0.avatar_thumb_name AS avatar_thumb_name_26,
  t0.cover_name AS cover_name_27,
  t0.date_add AS date_add_28,
  t0.date_upd AS date_upd_29,
  t0.last_inactivity_reminder_at AS last_inactivity_reminder_at_30,
  t0.inactivity_reminder_count AS inactivity_reminder_count_31,
  t0.user_id AS user_id_32,
  t0.preferred_band_id AS preferred_band_id_33,
  t0.invited_by_id AS invited_by_id_34
FROM
  artist t0
  INNER JOIN band_artist ON t0.id = band_artist.artist_id
WHERE
  band_artist.band_id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.nickname AS nickname_4, t0.slug AS slug_5, t0.excerpt AS excerpt_6, t0.mood AS mood_7, t0.exhibition AS exhibition_8, t0.crew AS crew_9, t0.biography AS biography_10, t0.original AS original_11, t0.cover AS cover_12, t0.instrumentation AS instrumentation_13, t0.willingness AS willingness_14, t0.www AS www_15, t0.facebook AS facebook_16, t0.twitter AS twitter_17, t0.soundcloud AS soundcloud_18, t0.youtube AS youtube_19, t0.avatar AS avatar_20, t0.wide AS wide_21, t0.thumb AS thumb_22, t0.privacy AS privacy_23, t0.solo_artist AS solo_artist_24, t0.avatar_name AS avatar_name_25, t0.avatar_thumb_name AS avatar_thumb_name_26, t0.cover_name AS cover_name_27, t0.date_add AS date_add_28, t0.date_upd AS date_upd_29, t0.last_inactivity_reminder_at AS last_inactivity_reminder_at_30, t0.inactivity_reminder_count AS inactivity_reminder_count_31, t0.user_id AS user_id_32, t0.preferred_band_id AS preferred_band_id_33, t0.invited_by_id AS invited_by_id_34 FROM artist t0 INNER JOIN band_artist ON t0.id = band_artist.artist_id WHERE band_artist.band_id = 27;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.canonical_email AS canonical_email_3,
  t0.roles AS roles_4,
  t0.username AS username_5,
  t0.password AS password_6,
  t0.secure_key AS secure_key_7,
  t0.firstname AS firstname_8,
  t0.lastname AS lastname_9,
  t0.phone AS phone_10,
  t0.avatar AS avatar_11,
  t0.avatar_thumbnail AS avatar_thumbnail_12,
  t0.jwt AS jwt_13,
  t0.timezone AS timezone_14,
  t0.optin AS optin_15,
  t0.newsletter AS newsletter_16,
  t0.is_verified AS is_verified_17,
  t0.is_blocked AS is_blocked_18,
  t0.is_deleted AS is_deleted_19,
  t0.last_registration_link_request AS last_registration_link_request_20,
  t0.last_login_link_request AS last_login_link_request_21,
  t0.last_login AS last_login_22,
  t0.country AS country_23,
  t0.google AS google_24,
  t0.facebook AS facebook_25,
  t0.apple AS apple_26,
  t0.date_add AS date_add_27,
  t0.date_upd AS date_upd_28,
  t0.language_id AS language_id_29,
  t30.id AS id_31,
  t30.firstname AS firstname_32,
  t30.lastname AS lastname_33,
  t30.nickname AS nickname_34,
  t30.slug AS slug_35,
  t30.excerpt AS excerpt_36,
  t30.mood AS mood_37,
  t30.exhibition AS exhibition_38,
  t30.crew AS crew_39,
  t30.biography AS biography_40,
  t30.original AS original_41,
  t30.cover AS cover_42,
  t30.instrumentation AS instrumentation_43,
  t30.willingness AS willingness_44,
  t30.www AS www_45,
  t30.facebook AS facebook_46,
  t30.twitter AS twitter_47,
  t30.soundcloud AS soundcloud_48,
  t30.youtube AS youtube_49,
  t30.avatar AS avatar_50,
  t30.wide AS wide_51,
  t30.thumb AS thumb_52,
  t30.privacy AS privacy_53,
  t30.solo_artist AS solo_artist_54,
  t30.avatar_name AS avatar_name_55,
  t30.avatar_thumb_name AS avatar_thumb_name_56,
  t30.cover_name AS cover_name_57,
  t30.date_add AS date_add_58,
  t30.date_upd AS date_upd_59,
  t30.last_inactivity_reminder_at AS last_inactivity_reminder_at_60,
  t30.inactivity_reminder_count AS inactivity_reminder_count_61,
  t30.user_id AS user_id_62,
  t30.preferred_band_id AS preferred_band_id_63,
  t30.invited_by_id AS invited_by_id_64
FROM
  user t0
  LEFT JOIN artist t30 ON t30.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.canonical_email AS canonical_email_3, t0.roles AS roles_4, t0.username AS username_5, t0.password AS password_6, t0.secure_key AS secure_key_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.phone AS phone_10, t0.avatar AS avatar_11, t0.avatar_thumbnail AS avatar_thumbnail_12, t0.jwt AS jwt_13, t0.timezone AS timezone_14, t0.optin AS optin_15, t0.newsletter AS newsletter_16, t0.is_verified AS is_verified_17, t0.is_blocked AS is_blocked_18, t0.is_deleted AS is_deleted_19, t0.last_registration_link_request AS last_registration_link_request_20, t0.last_login_link_request AS last_login_link_request_21, t0.last_login AS last_login_22, t0.country AS country_23, t0.google AS google_24, t0.facebook AS facebook_25, t0.apple AS apple_26, t0.date_add AS date_add_27, t0.date_upd AS date_upd_28, t0.language_id AS language_id_29, t30.id AS id_31, t30.firstname AS firstname_32, t30.lastname AS lastname_33, t30.nickname AS nickname_34, t30.slug AS slug_35, t30.excerpt AS excerpt_36, t30.mood AS mood_37, t30.exhibition AS exhibition_38, t30.crew AS crew_39, t30.biography AS biography_40, t30.original AS original_41, t30.cover AS cover_42, t30.instrumentation AS instrumentation_43, t30.willingness AS willingness_44, t30.www AS www_45, t30.facebook AS facebook_46, t30.twitter AS twitter_47, t30.soundcloud AS soundcloud_48, t30.youtube AS youtube_49, t30.avatar AS avatar_50, t30.wide AS wide_51, t30.thumb AS thumb_52, t30.privacy AS privacy_53, t30.solo_artist AS solo_artist_54, t30.avatar_name AS avatar_name_55, t30.avatar_thumb_name AS avatar_thumb_name_56, t30.cover_name AS cover_name_57, t30.date_add AS date_add_58, t30.date_upd AS date_upd_59, t30.last_inactivity_reminder_at AS last_inactivity_reminder_at_60, t30.inactivity_reminder_count AS inactivity_reminder_count_61, t30.user_id AS user_id_62, t30.preferred_band_id AS preferred_band_id_63, t30.invited_by_id AS invited_by_id_64 FROM user t0 LEFT JOIN artist t30 ON t30.user_id = t0.id WHERE t0.id = 99;

SELECT
  t0.id AS id_1,
  t0.min_points AS min_points_2,
  t0.position AS position_3,
  t0.badge AS badge_4,
  t0.stars AS stars_5,
  t0.hex_code AS hex_code_6,
  t0.date_add AS date_add_7,
  t0.date_upd AS date_upd_8
FROM
  tier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.min_points AS min_points_2, t0.position AS position_3, t0.badge AS badge_4, t0.stars AS stars_5, t0.hex_code AS hex_code_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8 FROM tier t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tier_id AS tier_id_3,
  t0.language_id AS language_id_4
FROM
  tier_lang t0
WHERE
  t0.tier_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tier_id AS tier_id_3, t0.language_id AS language_id_4 FROM tier_lang t0 WHERE t0.tier_id = 1;

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:07:19' AND c0_.ends_at >= '2026-11-02 14:07:19' 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 = 6067;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.active AS active_3,
  t0.date_add AS date_add_4,
  t0.date_upd AS date_upd_5
FROM
  music_genre t0
  INNER JOIN band_music_genre ON t0.id = band_music_genre.music_genre_id
WHERE
  band_music_genre.band_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5 FROM music_genre t0 INNER JOIN band_music_genre ON t0.id = band_music_genre.music_genre_id WHERE band_music_genre.band_id = 27;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.music_genre_id AS music_genre_id_3,
  t0.language_id AS language_id_4
FROM
  music_genre_lang t0
WHERE
  t0.music_genre_id = ?