Query Metrics
5
Database Queries
5
Different statements
5.41 ms
Query time
0
Invalid entities
11
Managed entities
1
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.45 ms (26.77%) |
1 |
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-test" "it" ]
|
||||||||||||||||||||||||||||||
|
1.24 ms (22.87%) |
1 |
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
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (22.85%) |
1 |
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" ]
|
||||||||||||||||||||||||||||||
|
0.81 ms (14.94%) |
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.user_id = ?
Parameters:
[
735
]
|
||||||||||||||||||||||||||||||
|
0.68 ms (12.58%) |
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 13:03:09" "2026-11-02 13:03:09" ] |
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. |