GET https://app.dev.localero.it/band/profile/hydraulic-orange

Query Metrics

19 Database Queries
16 Different statements
29.70 ms Query time
0 Invalid entities
24 Managed entities
5 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

#▲ Time Info
1 0.93 ms
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
Parameters:
[
  "hydraulic-orange"
]
2 0.88 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_band_follow u0_ WHERE u0_.band_id = ?
Parameters:
[
  102
]
3 1.57 ms
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
Parameters:
[
  2
  102
  "2026-11-02 14:43:45"
]
4 0.78 ms
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
Parameters:
[
  2
  102
  "2026-11-02 14:43:45"
]
5 0.94 ms
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 = ?
Parameters:
[
  102
]
6 1.11 ms
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
Parameters:
[
  102
]
7 3.75 ms
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 = ?
Parameters:
[
  102
]
8 0.79 ms
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 = ?
Parameters:
[
  102
]
9 0.80 ms
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 = ?
Parameters:
[
  711
]
10 3.35 ms
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 = ?
Parameters:
[
  713
]
11 0.94 ms
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 = ?
Parameters:
[
  716
]
12 3.00 ms
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 = ?
Parameters:
[
  1
]
13 2.24 ms
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 = ?
Parameters:
[
  1
]
14 1.23 ms
SELECT c0_.id AS id_0 FROM call_for_artists c0_ WHERE c0_.starts_at <= ? AND c0_.ends_at >= ? LIMIT 1
Parameters:
[
  "2026-11-02 14:43:45"
  "2026-11-02 14:43:45"
]
15 3.77 ms
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 = ?
Parameters:
[
  7720
]
16 0.78 ms
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 = ?
Parameters:
[
  102
]
17 1.65 ms
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 = ?
Parameters:
[
  3
]
18 0.36 ms
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 = ?
Parameters:
[
  14
]
19 0.81 ms
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
Parameters:
[
  102
]

Database Connections

Name Service
default doctrine.dbal.default_connection
messenger doctrine.dbal.messenger_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

5 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
append_only 5

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MusicGenreLang 4
App\Entity\Artist 3
App\Entity\User 3
App\Entity\Lang 2
App\Entity\BandLang 2
App\Entity\TierLang 2
App\Entity\MusicGenre 2
App\Entity\BandMedia 2
App\Entity\Band 1
App\Entity\City 1
App\Entity\Tier 1
App\Entity\Country 1

Entities Mapping