GET https://app.dev.localero.it/en/artist/55-marsaldev

Query Metrics

9 Database Queries
9 Different statements
11.47 ms Query time
0 Invalid entities
12 Managed entities
6 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

default connection

Time▼ Count Info
1.84 ms
(16.05%)
1
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, b0_.city_id AS city_id_23, b0_.owner_id AS owner_id_24, b0_.current_tier_id AS current_tier_id_25 FROM band b0_ INNER JOIN band_artist b2_ ON b0_.id = b2_.band_id INNER JOIN artist a1_ ON a1_.id = b2_.artist_id WHERE a1_.id = ?
Parameters:
[
  55
]
1.56 ms
(13.57%)
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 INNER JOIN band_artist ON t0.id = band_artist.band_id WHERE band_artist.artist_id = ?
Parameters:
[
  55
]
1.54 ms
(13.40%)
1
SELECT t0.id AS id_1, t0.excerpt AS excerpt_2, t0.mood AS mood_3, t0.exhibition AS exhibition_4, t0.crew AS crew_5, t0.biography AS biography_6, t0.artist_id AS artist_id_7, t0.language_id AS language_id_8 FROM artist_lang t0 WHERE t0.artist_id = ?
Parameters:
[
  55
]
1.48 ms
(12.89%)
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 WHERE t0.id = ? LIMIT 1
Parameters:
[
  55
]
1.44 ms
(12.54%)
1
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:07:14"
  "2026-11-02 14:07:14"
]
1.22 ms
(10.66%)
1
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 artist_music_genre ON t0.id = artist_music_genre.music_genre_id WHERE artist_music_genre.artist_id = ?
Parameters:
[
  55
]
0.96 ms
(8.37%)
1
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:
[
  20
]
0.75 ms
(6.51%)
1
SELECT t0.id AS id_1, t0.active AS active_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.instrument_group_id AS instrument_group_id_5 FROM instrument t0 INNER JOIN instrument_artist ON t0.id = instrument_artist.instrument_id WHERE instrument_artist.artist_id = ?
Parameters:
[
  55
]
0.69 ms
(6.02%)
1
SELECT t0.id AS id_1, t0.active AS active_2, t0.icon AS icon_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5 FROM artist_type t0 INNER JOIN artist_artist_type ON t0.id = artist_artist_type.artist_type_id WHERE artist_artist_type.artist_id = ?
Parameters:
[
  55
]

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

6 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
append_only 6

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Lang 2
App\Entity\ArtistLang 2
App\Entity\ArtistTypeLang 2
App\Entity\MusicGenreLang 2
App\Entity\Artist 1
App\Entity\User 1
App\Entity\ArtistType 1
App\Entity\MusicGenre 1

Entities Mapping

Class Mapping errors
App\Entity\Artist No errors.
App\Entity\User No errors.
App\Entity\Band No errors.
App\Entity\ArtistLang No errors.
App\Entity\ArtistType No errors.
App\Entity\Event No errors.
App\Entity\MusicGenre No errors.
App\Entity\Instrument No errors.
App\Entity\City No errors.
App\Entity\Tier No errors.
App\Entity\Lang No errors.
App\Entity\InstrumentGroup No errors.
App\Entity\ArtistTypeLang No errors.
App\Entity\CallForArtists No errors.
App\Entity\MusicGenreLang No errors.