Symfony Profiler

SELECT
  DISTINCT UPPER(
    SUBSTRING(
      b0_.name
      FROM
        1 FOR 1
    )
  ) AS sclr_0
FROM
  band b0_

SELECT DISTINCT UPPER(SUBSTRING(b0_.name FROM 1 FOR 1)) AS sclr_0 FROM band b0_;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  band b0_

SELECT COUNT(b0_.id) AS sclr_0 FROM band b0_;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      name_2
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.active AS active_1,
          b0_.name AS name_2,
          b0_.slug AS slug_3,
          b0_.foundation_year AS foundation_year_4,
          b0_.website AS website_5,
          b0_.facebook AS facebook_6,
          b0_.instagram AS instagram_7,
          b0_.tiktok AS tiktok_8,
          b0_.soundcloud AS soundcloud_9,
          b0_.youtube AS youtube_10,
          b0_.discord AS discord_11,
          b0_.twitter AS twitter_12,
          b0_.spotify AS spotify_13,
          b0_.twitch AS twitch_14,
          b0_.bandsintown AS bandsintown_15,
          b0_.bandsintown_api_key AS bandsintown_api_key_16,
          b0_.cover_name AS cover_name_17,
          b0_.cover_thumb AS cover_thumb_18,
          b0_.date_add AS date_add_19,
          b0_.date_upd AS date_upd_20,
          b0_.total_points AS total_points_21,
          b0_.ranking_position AS ranking_position_22,
          b1_.id AS id_23,
          b1_.description_short AS description_short_24,
          b1_.description AS description_25,
          b1_.date_add AS date_add_26,
          b1_.date_upd AS date_upd_27,
          b2_.id AS id_28,
          b2_.type AS type_29,
          b2_.file_name AS file_name_30,
          b2_.position AS position_31,
          b2_.date_add AS date_add_32,
          t3_.id AS id_33,
          t3_.min_points AS min_points_34,
          t3_.position AS position_35,
          t3_.badge AS badge_36,
          t3_.stars AS stars_37,
          t3_.hex_code AS hex_code_38,
          t3_.date_add AS date_add_39,
          t3_.date_upd AS date_upd_40,
          t4_.id AS id_41,
          t4_.name AS name_42,
          m5_.id AS id_43,
          m5_.position AS position_44,
          m5_.active AS active_45,
          m5_.date_add AS date_add_46,
          m5_.date_upd AS date_upd_47,
          m6_.id AS id_48,
          m6_.name AS name_49
        FROM
          band b0_
          LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id
          AND (
            b0_.id = b1_.band_id
            AND b1_.lang_id = ?
          )
          LEFT JOIN band_media b2_ ON b0_.id = b2_.band_id
          LEFT JOIN tier t3_ ON b0_.current_tier_id = t3_.id
          LEFT JOIN tier_lang t4_ ON t3_.id = t4_.tier_id
          AND (
            t3_.id = t4_.tier_id
            AND t4_.language_id = ?
          )
          LEFT JOIN band_music_genre b7_ ON b0_.id = b7_.band_id
          LEFT JOIN music_genre m5_ ON m5_.id = b7_.music_genre_id
          LEFT JOIN music_genre_lang m6_ ON m5_.id = m6_.music_genre_id
          AND (m6_.language_id = ?)
        ORDER BY
          b2_.position ASC
      ) dctrn_result_inner
    ORDER BY
      name_2 ASC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_2 FROM (SELECT b0_.id AS id_0, b0_.active AS active_1, b0_.name AS name_2, b0_.slug AS slug_3, b0_.foundation_year AS foundation_year_4, b0_.website AS website_5, b0_.facebook AS facebook_6, b0_.instagram AS instagram_7, b0_.tiktok AS tiktok_8, b0_.soundcloud AS soundcloud_9, b0_.youtube AS youtube_10, b0_.discord AS discord_11, b0_.twitter AS twitter_12, b0_.spotify AS spotify_13, b0_.twitch AS twitch_14, b0_.bandsintown AS bandsintown_15, b0_.bandsintown_api_key AS bandsintown_api_key_16, b0_.cover_name AS cover_name_17, b0_.cover_thumb AS cover_thumb_18, b0_.date_add AS date_add_19, b0_.date_upd AS date_upd_20, b0_.total_points AS total_points_21, b0_.ranking_position AS ranking_position_22, b1_.id AS id_23, b1_.description_short AS description_short_24, b1_.description AS description_25, b1_.date_add AS date_add_26, b1_.date_upd AS date_upd_27, b2_.id AS id_28, b2_.type AS type_29, b2_.file_name AS file_name_30, b2_.position AS position_31, b2_.date_add AS date_add_32, t3_.id AS id_33, t3_.min_points AS min_points_34, t3_.position AS position_35, t3_.badge AS badge_36, t3_.stars AS stars_37, t3_.hex_code AS hex_code_38, t3_.date_add AS date_add_39, t3_.date_upd AS date_upd_40, t4_.id AS id_41, t4_.name AS name_42, m5_.id AS id_43, m5_.position AS position_44, m5_.active AS active_45, m5_.date_add AS date_add_46, m5_.date_upd AS date_upd_47, m6_.id AS id_48, m6_.name AS name_49 FROM band b0_ LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id AND (b0_.id = b1_.band_id AND b1_.lang_id = 1) LEFT JOIN band_media b2_ ON b0_.id = b2_.band_id LEFT JOIN tier t3_ ON b0_.current_tier_id = t3_.id LEFT JOIN tier_lang t4_ ON t3_.id = t4_.tier_id AND (t3_.id = t4_.tier_id AND t4_.language_id = 1) LEFT JOIN band_music_genre b7_ ON b0_.id = b7_.band_id LEFT JOIN music_genre m5_ ON m5_.id = b7_.music_genre_id LEFT JOIN music_genre_lang m6_ ON m5_.id = m6_.music_genre_id AND (m6_.language_id = 1) ORDER BY b2_.position ASC) dctrn_result_inner ORDER BY name_2 ASC) dctrn_result LIMIT 12;

SELECT
  b0_.id AS id_0,
  b0_.active AS active_1,
  b0_.name AS name_2,
  b0_.slug AS slug_3,
  b0_.foundation_year AS foundation_year_4,
  b0_.website AS website_5,
  b0_.facebook AS facebook_6,
  b0_.instagram AS instagram_7,
  b0_.tiktok AS tiktok_8,
  b0_.soundcloud AS soundcloud_9,
  b0_.youtube AS youtube_10,
  b0_.discord AS discord_11,
  b0_.twitter AS twitter_12,
  b0_.spotify AS spotify_13,
  b0_.twitch AS twitch_14,
  b0_.bandsintown AS bandsintown_15,
  b0_.bandsintown_api_key AS bandsintown_api_key_16,
  b0_.cover_name AS cover_name_17,
  b0_.cover_thumb AS cover_thumb_18,
  b0_.date_add AS date_add_19,
  b0_.date_upd AS date_upd_20,
  b0_.total_points AS total_points_21,
  b0_.ranking_position AS ranking_position_22,
  b1_.id AS id_23,
  b1_.description_short AS description_short_24,
  b1_.description AS description_25,
  b1_.date_add AS date_add_26,
  b1_.date_upd AS date_upd_27,
  b2_.id AS id_28,
  b2_.type AS type_29,
  b2_.file_name AS file_name_30,
  b2_.position AS position_31,
  b2_.date_add AS date_add_32,
  t3_.id AS id_33,
  t3_.min_points AS min_points_34,
  t3_.position AS position_35,
  t3_.badge AS badge_36,
  t3_.stars AS stars_37,
  t3_.hex_code AS hex_code_38,
  t3_.date_add AS date_add_39,
  t3_.date_upd AS date_upd_40,
  t4_.id AS id_41,
  t4_.name AS name_42,
  m5_.id AS id_43,
  m5_.position AS position_44,
  m5_.active AS active_45,
  m5_.date_add AS date_add_46,
  m5_.date_upd AS date_upd_47,
  m6_.id AS id_48,
  m6_.name AS name_49,
  b0_.city_id AS city_id_50,
  b0_.owner_id AS owner_id_51,
  b0_.current_tier_id AS current_tier_id_52,
  b1_.band_id AS band_id_53,
  b1_.lang_id AS lang_id_54,
  b2_.band_id AS band_id_55,
  t4_.tier_id AS tier_id_56,
  t4_.language_id AS language_id_57,
  m6_.music_genre_id AS music_genre_id_58,
  m6_.language_id AS language_id_59
FROM
  band b0_
  LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id
  AND (
    b0_.id = b1_.band_id
    AND b1_.lang_id = ?
  )
  LEFT JOIN band_media b2_ ON b0_.id = b2_.band_id
  LEFT JOIN tier t3_ ON b0_.current_tier_id = t3_.id
  LEFT JOIN tier_lang t4_ ON t3_.id = t4_.tier_id
  AND (
    t3_.id = t4_.tier_id
    AND t4_.language_id = ?
  )
  LEFT JOIN band_music_genre b7_ ON b0_.id = b7_.band_id
  LEFT JOIN music_genre m5_ ON m5_.id = b7_.music_genre_id
  LEFT JOIN music_genre_lang m6_ ON m5_.id = m6_.music_genre_id
  AND (m6_.language_id = ?)
WHERE
  b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.name ASC,
  b2_.position ASC

SELECT b0_.id AS id_0, b0_.active AS active_1, b0_.name AS name_2, b0_.slug AS slug_3, b0_.foundation_year AS foundation_year_4, b0_.website AS website_5, b0_.facebook AS facebook_6, b0_.instagram AS instagram_7, b0_.tiktok AS tiktok_8, b0_.soundcloud AS soundcloud_9, b0_.youtube AS youtube_10, b0_.discord AS discord_11, b0_.twitter AS twitter_12, b0_.spotify AS spotify_13, b0_.twitch AS twitch_14, b0_.bandsintown AS bandsintown_15, b0_.bandsintown_api_key AS bandsintown_api_key_16, b0_.cover_name AS cover_name_17, b0_.cover_thumb AS cover_thumb_18, b0_.date_add AS date_add_19, b0_.date_upd AS date_upd_20, b0_.total_points AS total_points_21, b0_.ranking_position AS ranking_position_22, b1_.id AS id_23, b1_.description_short AS description_short_24, b1_.description AS description_25, b1_.date_add AS date_add_26, b1_.date_upd AS date_upd_27, b2_.id AS id_28, b2_.type AS type_29, b2_.file_name AS file_name_30, b2_.position AS position_31, b2_.date_add AS date_add_32, t3_.id AS id_33, t3_.min_points AS min_points_34, t3_.position AS position_35, t3_.badge AS badge_36, t3_.stars AS stars_37, t3_.hex_code AS hex_code_38, t3_.date_add AS date_add_39, t3_.date_upd AS date_upd_40, t4_.id AS id_41, t4_.name AS name_42, m5_.id AS id_43, m5_.position AS position_44, m5_.active AS active_45, m5_.date_add AS date_add_46, m5_.date_upd AS date_upd_47, m6_.id AS id_48, m6_.name AS name_49, b0_.city_id AS city_id_50, b0_.owner_id AS owner_id_51, b0_.current_tier_id AS current_tier_id_52, b1_.band_id AS band_id_53, b1_.lang_id AS lang_id_54, b2_.band_id AS band_id_55, t4_.tier_id AS tier_id_56, t4_.language_id AS language_id_57, m6_.music_genre_id AS music_genre_id_58, m6_.language_id AS language_id_59 FROM band b0_ LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id AND (b0_.id = b1_.band_id AND b1_.lang_id = 1) LEFT JOIN band_media b2_ ON b0_.id = b2_.band_id LEFT JOIN tier t3_ ON b0_.current_tier_id = t3_.id LEFT JOIN tier_lang t4_ ON t3_.id = t4_.tier_id AND (t3_.id = t4_.tier_id AND t4_.language_id = 1) LEFT JOIN band_music_genre b7_ ON b0_.id = b7_.band_id LEFT JOIN music_genre m5_ ON m5_.id = b7_.music_genre_id LEFT JOIN music_genre_lang m6_ ON m5_.id = m6_.music_genre_id AND (m6_.language_id = 1) WHERE b0_.id IN (33, 95, 85, 105, 77, 64, 35, 88, 9, 101, 47, 76) ORDER BY b0_.name ASC, b2_.position ASC;

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

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

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

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