GET https://app.dev.localero.it/en/artist/382-violafuel

Query Metrics

16 Database Queries
14 Different statements
22.18 ms Query time
0 Invalid entities
38 Managed entities
10 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

#▲ Time Info
1 1.62 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 WHERE t0.id = ? LIMIT 1
Parameters:
[
  382
]
2 1.72 ms
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:
[
  382
]
3 1.93 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 3
Parameters:
[
  2
  83
  "2026-11-02 14:08:07"
]
4 1.39 ms
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:
[
  382
]
5 1.85 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 INNER JOIN band_artist ON t0.id = band_artist.band_id WHERE band_artist.artist_id = ?
Parameters:
[
  382
]
6 1.17 ms
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:
[
  382
]
7 1.40 ms
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:
[
  382
]
8 2.44 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:08:07"
  "2026-11-02 14:08:07"
]
9 1.20 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 artist_music_genre ON t0.id = artist_music_genre.music_genre_id WHERE artist_music_genre.artist_id = ?
Parameters:
[
  382
]
10 1.90 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
]
11 2.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instrument_id AS instrument_id_3, t0.lang_id AS lang_id_4 FROM instrument_lang t0 WHERE t0.instrument_id = ?
Parameters:
[
  1
]
12 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instrument_id AS instrument_id_3, t0.lang_id AS lang_id_4 FROM instrument_lang t0 WHERE t0.instrument_id = ?
Parameters:
[
  9
]
13 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instrument_id AS instrument_id_3, t0.lang_id AS lang_id_4 FROM instrument_lang t0 WHERE t0.instrument_id = ?
Parameters:
[
  14
]
14 1.30 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:
[
  83
]
15 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.email AS email_7, t0.www AS www_8, t0.facebook AS facebook_9, t0.twitter AS twitter_10, t0.soundcloud AS soundcloud_11, t0.youtube AS youtube_12, t0.status AS status_13, t0.type AS type_14, t0.google_place_id AS google_place_id_15, t0.slug AS slug_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.user_id AS user_id_19, t0.city_id AS city_id_20 FROM venue t0 WHERE t0.id = ?
Parameters:
[
  12969
]
16 0.38 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:
[
  4071
]

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

10 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
append_only 10

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ArtistTypeLang 6
App\Entity\InstrumentLang 6
App\Entity\Instrument 3
App\Entity\InstrumentGroup 3
App\Entity\ArtistType 3
App\Entity\City 2
App\Entity\Lang 2
App\Entity\ArtistLang 2
App\Entity\MusicGenreLang 2
App\Entity\Artist 1
App\Entity\User 1
App\Entity\Band 1
App\Entity\Tier 1
App\Entity\Event 1
App\Entity\Venue 1
App\Entity\EventLang 1
App\Entity\MusicGenre 1
App\Entity\Country 1

Entities Mapping