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 = 'les-italiens' 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 = 14;

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 = 1) WHERE e0_.band_id = 14 AND e0_.date_event >= '2026-11-02 13:34:40' 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 = 1) WHERE e0_.band_id = 14 AND e0_.date_event < '2026-11-02 13:34:40' 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 = 14;

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

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

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 13:34:40' AND c0_.ends_at >= '2026-11-02 13:34:40' 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 = 4071;

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

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 = ?

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

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 = ?

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

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 = ?

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

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.file_name AS file_name_3,
  t0.position AS position_4,
  t0.date_add AS date_add_5,
  t0.band_id AS band_id_6
FROM
  band_media t0
WHERE
  t0.band_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.file_name AS file_name_3, t0.position AS position_4, t0.date_add AS date_add_5, t0.band_id AS band_id_6 FROM band_media t0 WHERE t0.band_id = 14 ORDER BY t0.position ASC;