GET https://app.dev.localero.it/news/news-titolo-eng

Query Metrics

5 Database Queries
5 Different statements
6.51 ms Query time
0 Invalid entities
11 Managed entities
1 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

#▲ Time Info
1 1.28 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.meta_title AS meta_title_4, n0_.meta_description AS meta_description_5, n1_.id AS id_6, n1_.published AS published_7, n1_.published_at AS published_at_8, n1_.notification_queued_at AS notification_queued_at_9, n1_.notification_sent_at AS notification_sent_at_10, n1_.notification_last_user_id AS notification_last_user_id_11, n1_.notifications_created AS notifications_created_12, n1_.date_add AS date_add_13, n1_.date_upd AS date_upd_14, l2_.id AS id_15, l2_.name AS name_16, l2_.active AS active_17, l2_.iso_code AS iso_code_18, l2_.language_code AS language_code_19, l2_.locale AS locale_20, l2_.is_rtl AS is_rtl_21, n0_.news_id AS news_id_22, n0_.language_id AS language_id_23, n1_.created_by_id AS created_by_id_24 FROM news_lang n0_ INNER JOIN news n1_ ON n0_.news_id = n1_.id INNER JOIN lang l2_ ON n0_.language_id = l2_.id WHERE n1_.published = 1 AND n0_.slug = ? AND l2_.iso_code = ?
Parameters:
[
  "news-titolo-eng"
  "en"
]
2 1.13 ms
SELECT n0_.id AS id_0, n0_.body AS body_1, n0_.status AS status_2, n0_.date_add AS date_add_3, n0_.moderated_at AS moderated_at_4, u1_.id AS id_5, u1_.email AS email_6, u1_.canonical_email AS canonical_email_7, u1_.roles AS roles_8, u1_.username AS username_9, u1_.password AS password_10, u1_.secure_key AS secure_key_11, u1_.firstname AS firstname_12, u1_.lastname AS lastname_13, u1_.phone AS phone_14, u1_.avatar AS avatar_15, u1_.avatar_thumbnail AS avatar_thumbnail_16, u1_.jwt AS jwt_17, u1_.timezone AS timezone_18, u1_.optin AS optin_19, u1_.newsletter AS newsletter_20, u1_.is_verified AS is_verified_21, u1_.is_blocked AS is_blocked_22, u1_.is_deleted AS is_deleted_23, u1_.last_registration_link_request AS last_registration_link_request_24, u1_.last_login_link_request AS last_login_link_request_25, u1_.last_login AS last_login_26, u1_.country AS country_27, u1_.google AS google_28, u1_.facebook AS facebook_29, u1_.apple AS apple_30, u1_.date_add AS date_add_31, u1_.date_upd AS date_upd_32, n0_.news_id AS news_id_33, n0_.user_id AS user_id_34, u1_.language_id AS language_id_35 FROM news_comment n0_ INNER JOIN user u1_ ON n0_.user_id = u1_.id WHERE n0_.news_id = ? AND n0_.status = ? ORDER BY n0_.date_add ASC
Parameters:
[
  1
  "approved"
]
3 0.65 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.user_id = ?
Parameters:
[
  735
]
4 1.32 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.news_id AS news_id_7, t0.language_id AS language_id_8 FROM news_lang t0 WHERE t0.news_id = ?
Parameters:
[
  1
]
5 2.12 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 13:35:19"
  "2026-11-02 13:35:19"
]

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

1 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
append_only 1

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\NewsLang 2
App\Entity\Lang 2
App\Entity\NewsComment 2
App\Entity\News 1
App\Entity\Admin\Employee 1
App\Entity\User 1
App\Entity\Artist 1
App\Entity\Band 1

Entities Mapping

Class Mapping errors
App\Entity\NewsLang No errors.
App\Entity\News No errors.
App\Entity\Lang No errors.
App\Entity\Admin\Employee No errors.
App\Entity\NewsComment No errors.
App\Entity\User No errors.
App\Entity\Artist 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\Venue No errors.
App\Entity\EventVote No errors.
App\Entity\Notification No errors.
App\Entity\CallForArtists No errors.