GET https://inaia.ru/messages/unread-count

Query Metrics

5 Database Queries
5 Different statements
3.72 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.51 ms
(40.75%)
1
"COMMIT"
Parameters:
[]
0.73 ms
(19.63%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.status AS status_5, t0.phone_number AS phone_number_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.sex AS sex_10, t0.relationship AS relationship_11, t0.birthday AS birthday_12, t0.height AS height_13, t0.children AS children_14, t0.food_type AS food_type_15, t0.zodiac_sign AS zodiac_sign_16, t0.human_design AS human_design_17, t0.human_design_type AS human_design_type_18, t0.instagram AS instagram_19, t0.vkontakte AS vkontakte_20, t0.youtube AS youtube_21, t0.website AS website_22, t0.contact_email AS contact_email_23, t0.contact_phone_number AS contact_phone_number_24, t0.telegram AS telegram_25, t0.odnoklassniki AS odnoklassniki_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.activity_at AS activity_at_29, t0.last_seen_at AS last_seen_at_30, t0.offer AS offer_31, t0.profile_status AS profile_status_32, t0.about_text AS about_text_33, t0.dating_description AS dating_description_34, t0.visibility AS visibility_35, t0.activity AS activity_36, t0.invite_id AS invite_id_37, t0.profile_picture_id AS profile_picture_id_38, t0.question_id AS question_id_39, t0.city_id AS city_id_40 FROM users t0 WHERE t0.id = ?
Parameters:
[
  124
]
0.64 ms
(17.33%)
1
SELECT COUNT(m0_.id) AS sclr_0 FROM messages m0_ INNER JOIN conversations c1_ ON m0_.conversation_id = c1_.id INNER JOIN conversation_participants c2_ ON c1_.id = c2_.conversation_id WHERE c2_.user_id = ? AND m0_.sender_id <> ? AND m0_.deleted_at IS NULL AND ((c2_.last_read_at IS NULL OR m0_.created_at > c2_.last_read_at))
Parameters:
[
  124
  124
]
0.50 ms
(13.43%)
1
UPDATE users SET activity_at = ? WHERE id = ?
Parameters:
[
  "2025-12-04 13:17:47"
  124
]
0.33 ms
(8.86%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Invite No errors.
App\Entity\Attachment No errors.
App\Entity\Question No errors.
App\Entity\City No errors.
App\Entity\Film No errors.
App\Entity\Book No errors.
App\Entity\Quote No errors.
App\Entity\Video No errors.
App\Entity\Poem No errors.
App\Entity\Review No errors.
App\Entity\Interest No errors.
App\Entity\Activity No errors.
App\Entity\UserQuestionAnswer No errors.
App\Entity\BookQuestionAnswer No errors.
App\Entity\Subscription No errors.
App\Entity\Message No errors.
App\Entity\Conversation No errors.
App\Entity\ConversationParticipant No errors.