Symfony Profiler

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

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      ranking_position_22,
      total_points_21,
      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,
          t2_.id AS id_28,
          t2_.min_points AS min_points_29,
          t2_.position AS position_30,
          t2_.badge AS badge_31,
          t2_.stars AS stars_32,
          t2_.hex_code AS hex_code_33,
          t2_.date_add AS date_add_34,
          t2_.date_upd AS date_upd_35,
          t3_.id AS id_36,
          t3_.name AS name_37,
          a4_.id AS id_38,
          a4_.firstname AS firstname_39,
          a4_.lastname AS lastname_40,
          a4_.nickname AS nickname_41,
          a4_.slug AS slug_42,
          a4_.excerpt AS excerpt_43,
          a4_.mood AS mood_44,
          a4_.exhibition AS exhibition_45,
          a4_.crew AS crew_46,
          a4_.biography AS biography_47,
          a4_.original AS original_48,
          a4_.cover AS cover_49,
          a4_.instrumentation AS instrumentation_50,
          a4_.willingness AS willingness_51,
          a4_.www AS www_52,
          a4_.facebook AS facebook_53,
          a4_.twitter AS twitter_54,
          a4_.soundcloud AS soundcloud_55,
          a4_.youtube AS youtube_56,
          a4_.avatar AS avatar_57,
          a4_.wide AS wide_58,
          a4_.thumb AS thumb_59,
          a4_.privacy AS privacy_60,
          a4_.solo_artist AS solo_artist_61,
          a4_.avatar_name AS avatar_name_62,
          a4_.avatar_thumb_name AS avatar_thumb_name_63,
          a4_.cover_name AS cover_name_64,
          a4_.date_add AS date_add_65,
          a4_.date_upd AS date_upd_66,
          a4_.last_inactivity_reminder_at AS last_inactivity_reminder_at_67,
          a4_.inactivity_reminder_count AS inactivity_reminder_count_68
        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 tier t2_ ON b0_.current_tier_id = t2_.id
          LEFT JOIN tier_lang t3_ ON t2_.id = t3_.tier_id
          AND (
            t2_.id = t3_.tier_id
            AND t3_.language_id = ?
          )
          LEFT JOIN band_artist b5_ ON b0_.id = b5_.band_id
          LEFT JOIN artist a4_ ON a4_.id = b5_.artist_id
      ) dctrn_result_inner
    ORDER BY
      ranking_position_22 ASC,
      total_points_21 DESC,
      name_2 ASC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, ranking_position_22, total_points_21, 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, t2_.id AS id_28, t2_.min_points AS min_points_29, t2_.position AS position_30, t2_.badge AS badge_31, t2_.stars AS stars_32, t2_.hex_code AS hex_code_33, t2_.date_add AS date_add_34, t2_.date_upd AS date_upd_35, t3_.id AS id_36, t3_.name AS name_37, a4_.id AS id_38, a4_.firstname AS firstname_39, a4_.lastname AS lastname_40, a4_.nickname AS nickname_41, a4_.slug AS slug_42, a4_.excerpt AS excerpt_43, a4_.mood AS mood_44, a4_.exhibition AS exhibition_45, a4_.crew AS crew_46, a4_.biography AS biography_47, a4_.original AS original_48, a4_.cover AS cover_49, a4_.instrumentation AS instrumentation_50, a4_.willingness AS willingness_51, a4_.www AS www_52, a4_.facebook AS facebook_53, a4_.twitter AS twitter_54, a4_.soundcloud AS soundcloud_55, a4_.youtube AS youtube_56, a4_.avatar AS avatar_57, a4_.wide AS wide_58, a4_.thumb AS thumb_59, a4_.privacy AS privacy_60, a4_.solo_artist AS solo_artist_61, a4_.avatar_name AS avatar_name_62, a4_.avatar_thumb_name AS avatar_thumb_name_63, a4_.cover_name AS cover_name_64, a4_.date_add AS date_add_65, a4_.date_upd AS date_upd_66, a4_.last_inactivity_reminder_at AS last_inactivity_reminder_at_67, a4_.inactivity_reminder_count AS inactivity_reminder_count_68 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 tier t2_ ON b0_.current_tier_id = t2_.id LEFT JOIN tier_lang t3_ ON t2_.id = t3_.tier_id AND (t2_.id = t3_.tier_id AND t3_.language_id = 1) LEFT JOIN band_artist b5_ ON b0_.id = b5_.band_id LEFT JOIN artist a4_ ON a4_.id = b5_.artist_id) dctrn_result_inner ORDER BY ranking_position_22 ASC, total_points_21 DESC, name_2 ASC) dctrn_result LIMIT 20;

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

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,
  t2_.id AS id_28,
  t2_.min_points AS min_points_29,
  t2_.position AS position_30,
  t2_.badge AS badge_31,
  t2_.stars AS stars_32,
  t2_.hex_code AS hex_code_33,
  t2_.date_add AS date_add_34,
  t2_.date_upd AS date_upd_35,
  t3_.id AS id_36,
  t3_.name AS name_37,
  a4_.id AS id_38,
  a4_.firstname AS firstname_39,
  a4_.lastname AS lastname_40,
  a4_.nickname AS nickname_41,
  a4_.slug AS slug_42,
  a4_.excerpt AS excerpt_43,
  a4_.mood AS mood_44,
  a4_.exhibition AS exhibition_45,
  a4_.crew AS crew_46,
  a4_.biography AS biography_47,
  a4_.original AS original_48,
  a4_.cover AS cover_49,
  a4_.instrumentation AS instrumentation_50,
  a4_.willingness AS willingness_51,
  a4_.www AS www_52,
  a4_.facebook AS facebook_53,
  a4_.twitter AS twitter_54,
  a4_.soundcloud AS soundcloud_55,
  a4_.youtube AS youtube_56,
  a4_.avatar AS avatar_57,
  a4_.wide AS wide_58,
  a4_.thumb AS thumb_59,
  a4_.privacy AS privacy_60,
  a4_.solo_artist AS solo_artist_61,
  a4_.avatar_name AS avatar_name_62,
  a4_.avatar_thumb_name AS avatar_thumb_name_63,
  a4_.cover_name AS cover_name_64,
  a4_.date_add AS date_add_65,
  a4_.date_upd AS date_upd_66,
  a4_.last_inactivity_reminder_at AS last_inactivity_reminder_at_67,
  a4_.inactivity_reminder_count AS inactivity_reminder_count_68,
  b0_.city_id AS city_id_69,
  b0_.owner_id AS owner_id_70,
  b0_.current_tier_id AS current_tier_id_71,
  b1_.band_id AS band_id_72,
  b1_.lang_id AS lang_id_73,
  t3_.tier_id AS tier_id_74,
  t3_.language_id AS language_id_75,
  a4_.user_id AS user_id_76,
  a4_.preferred_band_id AS preferred_band_id_77,
  a4_.invited_by_id AS invited_by_id_78
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 tier t2_ ON b0_.current_tier_id = t2_.id
  LEFT JOIN tier_lang t3_ ON t2_.id = t3_.tier_id
  AND (
    t2_.id = t3_.tier_id
    AND t3_.language_id = ?
  )
  LEFT JOIN band_artist b5_ ON b0_.id = b5_.band_id
  LEFT JOIN artist a4_ ON a4_.id = b5_.artist_id
WHERE
  b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  b0_.ranking_position ASC,
  b0_.total_points DESC,
  b0_.name 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, t2_.id AS id_28, t2_.min_points AS min_points_29, t2_.position AS position_30, t2_.badge AS badge_31, t2_.stars AS stars_32, t2_.hex_code AS hex_code_33, t2_.date_add AS date_add_34, t2_.date_upd AS date_upd_35, t3_.id AS id_36, t3_.name AS name_37, a4_.id AS id_38, a4_.firstname AS firstname_39, a4_.lastname AS lastname_40, a4_.nickname AS nickname_41, a4_.slug AS slug_42, a4_.excerpt AS excerpt_43, a4_.mood AS mood_44, a4_.exhibition AS exhibition_45, a4_.crew AS crew_46, a4_.biography AS biography_47, a4_.original AS original_48, a4_.cover AS cover_49, a4_.instrumentation AS instrumentation_50, a4_.willingness AS willingness_51, a4_.www AS www_52, a4_.facebook AS facebook_53, a4_.twitter AS twitter_54, a4_.soundcloud AS soundcloud_55, a4_.youtube AS youtube_56, a4_.avatar AS avatar_57, a4_.wide AS wide_58, a4_.thumb AS thumb_59, a4_.privacy AS privacy_60, a4_.solo_artist AS solo_artist_61, a4_.avatar_name AS avatar_name_62, a4_.avatar_thumb_name AS avatar_thumb_name_63, a4_.cover_name AS cover_name_64, a4_.date_add AS date_add_65, a4_.date_upd AS date_upd_66, a4_.last_inactivity_reminder_at AS last_inactivity_reminder_at_67, a4_.inactivity_reminder_count AS inactivity_reminder_count_68, b0_.city_id AS city_id_69, b0_.owner_id AS owner_id_70, b0_.current_tier_id AS current_tier_id_71, b1_.band_id AS band_id_72, b1_.lang_id AS lang_id_73, t3_.tier_id AS tier_id_74, t3_.language_id AS language_id_75, a4_.user_id AS user_id_76, a4_.preferred_band_id AS preferred_band_id_77, a4_.invited_by_id AS invited_by_id_78 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 tier t2_ ON b0_.current_tier_id = t2_.id LEFT JOIN tier_lang t3_ ON t2_.id = t3_.tier_id AND (t2_.id = t3_.tier_id AND t3_.language_id = 1) LEFT JOIN band_artist b5_ ON b0_.id = b5_.band_id LEFT JOIN artist a4_ ON a4_.id = b5_.artist_id WHERE b0_.id IN (18, 32, 1, 9, 20, 13, 3, 55, 4, 12, 6, 47, 71, 2, 94, 26, 46, 78, 52, 53) ORDER BY b0_.ranking_position ASC, b0_.total_points DESC, b0_.name 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 12:24:52' AND c0_.ends_at >= '2026-11-02 12:24:52' LIMIT 1;

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

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