GET https://app.dev.localero.it/event/152-guns-n-roses-tribute-band-live-at-la-notte-del-diavolo-venafro-is

Query Metrics

10 Database Queries
9 Different statements
8.64 ms Query time
0 Invalid entities
18 Managed entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

#▲ Time Info
1 0.68 ms
SELECT t0.id AS id_1, t0.date_event AS date_event_2, t0.location AS location_3, t0.address AS address_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.poster_name AS poster_name_7, t0.poster_thumb_name AS poster_thumb_name_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.bandsintown_event_id AS bandsintown_event_id_11, t0.venue_pending AS venue_pending_12, t0.excluded_from_ranking AS excluded_from_ranking_13, t0.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_14, t0.price AS price_15, t0.access AS access_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18, t0.followers_notified_at AS followers_notified_at_19, t0.reminder_day_before_sent_at AS reminder_day_before_sent_at_20, t0.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_21, t0.venue_id AS venue_id_22, t0.artist_id AS artist_id_23, t0.band_id AS band_id_24, t0.opener_id AS opener_id_25 FROM event t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  152
]
2 1.15 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_.venue_id = ? AND e0_.date_event >= ? ORDER BY e0_.date_event ASC LIMIT 4
Parameters:
[
  2
  12935
  "2026-11-02 14:52:18"
]
3 1.58 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.notes AS notes_5, t0.event_id AS event_id_6, t0.language_id AS language_id_7 FROM event_lang t0 WHERE t0.event_id = ?
Parameters:
[
  152
]
4 0.76 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:52:18"
  "2026-11-02 14:52:18"
]
5 1.00 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:
[
  12935
]
6 0.78 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.id = ?
Parameters:
[
  52
]
7 0.84 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:
[
  52
]
8 0.61 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
]
9 0.55 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:
[
  31
]
10 0.70 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:
[
  7710
]

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

0 Hits
0 Misses
0 Puts

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MusicGenreLang 4
App\Entity\EventLang 2
App\Entity\Lang 2
App\Entity\City 2
App\Entity\MusicGenre 2
App\Entity\Event 1
App\Entity\Venue 1
App\Entity\Artist 1
App\Entity\Band 1
App\Entity\Tier 1
App\Entity\Country 1

Entities Mapping

Class Mapping errors
App\Entity\Event No errors.
App\Entity\Venue No errors.
App\Entity\Artist No errors.
App\Entity\Band No errors.
App\Entity\EventLang No errors.
App\Entity\EventVote No errors.
App\Entity\Lang No errors.
App\Entity\CallForArtists No errors.
App\Entity\User No errors.
App\Entity\City No errors.
App\Entity\VenueLang No errors.
App\Entity\Tier No errors.
App\Entity\BandLang No errors.
App\Entity\BandMedia No errors.
App\Entity\MusicGenre No errors.
App\Entity\MusicGenreLang No errors.
App\Entity\Country No errors.