Symfony Profiler

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

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

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,
  b2_.id AS id_26,
  b2_.active AS active_27,
  b2_.name AS name_28,
  b2_.slug AS slug_29,
  b2_.foundation_year AS foundation_year_30,
  b2_.website AS website_31,
  b2_.facebook AS facebook_32,
  b2_.instagram AS instagram_33,
  b2_.tiktok AS tiktok_34,
  b2_.soundcloud AS soundcloud_35,
  b2_.youtube AS youtube_36,
  b2_.discord AS discord_37,
  b2_.twitter AS twitter_38,
  b2_.spotify AS spotify_39,
  b2_.twitch AS twitch_40,
  b2_.bandsintown AS bandsintown_41,
  b2_.bandsintown_api_key AS bandsintown_api_key_42,
  b2_.cover_name AS cover_name_43,
  b2_.cover_thumb AS cover_thumb_44,
  b2_.date_add AS date_add_45,
  b2_.date_upd AS date_upd_46,
  b2_.total_points AS total_points_47,
  b2_.ranking_position AS ranking_position_48,
  e0_.venue_id AS venue_id_49,
  e0_.artist_id AS artist_id_50,
  e0_.band_id AS band_id_51,
  e0_.opener_id AS opener_id_52,
  e1_.event_id AS event_id_53,
  e1_.language_id AS language_id_54,
  b2_.city_id AS city_id_55,
  b2_.owner_id AS owner_id_56,
  b2_.current_tier_id AS current_tier_id_57
FROM
  event e0_
  LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id
  AND (e1_.language_id = ?)
  LEFT JOIN band b2_ ON e0_.band_id = b2_.id
WHERE
  (
    e0_.date_event BETWEEN ?
    AND ?
  )
  AND e0_.venue_pending = 0
ORDER BY
  e0_.date_event ASC
LIMIT
  100

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, b2_.id AS id_26, b2_.active AS active_27, b2_.name AS name_28, b2_.slug AS slug_29, b2_.foundation_year AS foundation_year_30, b2_.website AS website_31, b2_.facebook AS facebook_32, b2_.instagram AS instagram_33, b2_.tiktok AS tiktok_34, b2_.soundcloud AS soundcloud_35, b2_.youtube AS youtube_36, b2_.discord AS discord_37, b2_.twitter AS twitter_38, b2_.spotify AS spotify_39, b2_.twitch AS twitch_40, b2_.bandsintown AS bandsintown_41, b2_.bandsintown_api_key AS bandsintown_api_key_42, b2_.cover_name AS cover_name_43, b2_.cover_thumb AS cover_thumb_44, b2_.date_add AS date_add_45, b2_.date_upd AS date_upd_46, b2_.total_points AS total_points_47, b2_.ranking_position AS ranking_position_48, e0_.venue_id AS venue_id_49, e0_.artist_id AS artist_id_50, e0_.band_id AS band_id_51, e0_.opener_id AS opener_id_52, e1_.event_id AS event_id_53, e1_.language_id AS language_id_54, b2_.city_id AS city_id_55, b2_.owner_id AS owner_id_56, b2_.current_tier_id AS current_tier_id_57 FROM event e0_ LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id AND (e1_.language_id = 1) LEFT JOIN band b2_ ON e0_.band_id = b2_.id WHERE (e0_.date_event BETWEEN '2026-09-14 00:00:00' AND '2026-09-20 23:59:59') AND e0_.venue_pending = 0 ORDER BY e0_.date_event ASC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.value AS value_3,
  t0.type AS type_4,
  t0.description AS description_5,
  t0.date_add AS date_add_6,
  t0.date_upd AS date_upd_7
FROM
  configuration t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.value AS value_3, t0.type AS type_4, t0.description AS description_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7 FROM configuration t0 WHERE t0.code = 'maintenance' LIMIT 1;

SELECT
  a0_.id AS id_0
FROM
  artist a0_
WHERE
  a0_.nickname IS NOT NULL
  AND (a0_.nickname REGEXP ?) = 0
  AND a0_.avatar_name IS NOT NULL

SELECT a0_.id AS id_0 FROM artist a0_ WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP '^artist_[0-9]+$') = 0 AND a0_.avatar_name IS NOT NULL;

SELECT
  b0_.id AS id_0
FROM
  band b0_

SELECT b0_.id AS id_0 FROM band b0_;