GET http://bandoo-dev.ru/api/user/online/01945c33-6f15-0e5c-b3f8-b45196ae7e3b

Query Metrics

5 Database Queries
5 Different statements
19.25 ms Query time
2 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

Time Count Info
10.29 ms
(53.47%)
1
SELECT u0_.id AS id_0, u0_.date AS date_1, u0_.email AS email_2, u0_.password AS password_3, u0_.about AS about_4, u0_.vk_code_verifier AS vk_code_verifier_5, u0_.vk_id AS vk_id_6, u0_.vk_avatar AS vk_avatar_7, u0_.new_email AS new_email_8, u0_.new_email_token AS new_email_token_9, u0_.status AS status_10, u0_.role AS role_11, u0_.is_online AS is_online_12, u0_.last_visit AS last_visit_13, u0_.last_visit_at AS last_visit_at_14, u0_.confirm_token_token AS confirm_token_token_15, u0_.confirm_token_expires AS confirm_token_expires_16, u0_.name_first AS name_first_17, u0_.name_last AS name_last_18, u0_.name_middle AS name_middle_19, u0_.avatar_small_hash AS avatar_small_hash_20, u0_.avatar_original_hash AS avatar_original_hash_21, u0_.reset_token_token AS reset_token_token_22, u0_.reset_token_expires AS reset_token_expires_23, u0_.city_id AS city_id_24 FROM "user_users" u0_ WHERE u0_.id = ?
Parameters:
[
  "01945c33-6f15-0e5c-b3f8-b45196ae7e3b"
]
6.23 ms
(32.37%)
1
SELECT u0_.id AS id_0, u0_.date AS date_1, u0_.email AS email_2, u0_.password AS password_3, u0_.about AS about_4, u0_.vk_code_verifier AS vk_code_verifier_5, u0_.vk_id AS vk_id_6, u0_.vk_avatar AS vk_avatar_7, u0_.new_email AS new_email_8, u0_.new_email_token AS new_email_token_9, u0_.status AS status_10, u0_.role AS role_11, u0_.is_online AS is_online_12, u0_.last_visit AS last_visit_13, u0_.last_visit_at AS last_visit_at_14, u0_.confirm_token_token AS confirm_token_token_15, u0_.confirm_token_expires AS confirm_token_expires_16, u0_.name_first AS name_first_17, u0_.name_last AS name_last_18, u0_.name_middle AS name_middle_19, u0_.avatar_small_hash AS avatar_small_hash_20, u0_.avatar_original_hash AS avatar_original_hash_21, u0_.reset_token_token AS reset_token_token_22, u0_.reset_token_expires AS reset_token_expires_23, u0_.city_id AS city_id_24 FROM "user_users" u0_ WHERE u0_.email = ?
Parameters:
[
  "mk@mk.yo"
]
1.59 ms
(8.25%)
1
UPDATE "user_users" SET last_visit_at = ? WHERE id = ?
Parameters:
[
  "2026-03-19 05:14:58"
  "01945c33-6f15-0e5c-b3f8-b45196ae7e3b"
]
0.81 ms
(4.21%)
1
"COMMIT"
Parameters:
[]
0.33 ms
(1.70%)
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Model\User\Entity\User 1

Entities Mapping

Class Mapping errors
App\Model\User\Entity\ConfirmToken No errors.
App\Model\User\Entity\Name No errors.
App\Model\User\Entity\Avatar No errors.
App\Model\User\Entity\ResetToken No errors.
App\Model\User\Entity\User No errors.
App\Model\City\Entity\CityReference
  • The field 'App\Model\City\Entity\CityReference#foundationYear' has the property type 'int' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Model\User\Entity\Network\Network No errors.
App\Model\User\Entity\Review\Reply No errors.
App\Model\User\Entity\Review\Review No errors.
App\Model\User\Entity\Achievement\Achievement No errors.
App\Model\User\Entity\Photo No errors.
App\Model\User\Entity\Video No errors.
App\Model\User\Entity\Audio
  • The field 'App\Model\User\Entity\Audio#duration' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Model\User\Entity\Like\Like No errors.
App\Model\User\Entity\Viewed\Viewed No errors.
App\Model\User\Entity\Favorite\Favorite No errors.
App\Model\User\Entity\Message\MessageStatus No errors.
App\Model\User\Entity\Message\Message No errors.
App\Model\User\Entity\FcmToken\UserFcmToken No errors.