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

Response
200 OK
IP
192.168.144.9
Profiled on
Token
3b4d65

Query Metrics

5 Database Queries
5 Different statements
20.63 ms Query time
3 Invalid entities
2 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
10.95 ms
(53.08%) 		1 
SELECT u0_.id AS id_0, u0_.date AS date_1, u0_.email AS email_2, u0_.phone AS phone_3, u0_.phone_numeric AS phone_numeric_4, u0_.privacy_mask AS privacy_mask_5, u0_.push_settings_mask AS push_settings_mask_6, u0_.password AS password_7, u0_.about AS about_8, u0_.stuff AS stuff_9, u0_.vk_code_verifier AS vk_code_verifier_10, u0_.vk_id AS vk_id_11, u0_.vk_avatar AS vk_avatar_12, u0_.new_email AS new_email_13, u0_.new_email_token AS new_email_token_14, u0_.status AS status_15, u0_.role AS role_16, u0_.is_online AS is_online_17, u0_.last_visit AS last_visit_18, u0_.last_visit_at AS last_visit_at_19, u0_.confirm_token_token AS confirm_token_token_20, u0_.confirm_token_expires AS confirm_token_expires_21, u0_.name_first AS name_first_22, u0_.name_last AS name_last_23, u0_.name_middle AS name_middle_24, u0_.avatar_small_hash AS avatar_small_hash_25, u0_.avatar_original_hash AS avatar_original_hash_26, u0_.reset_token_token AS reset_token_token_27, u0_.reset_token_expires AS reset_token_expires_28, u0_.city_id AS city_id_29 FROM "user_users" u0_ WHERE u0_.id = ?
Parameters: 
[
  "01945c33-6f15-0e5c-b3f8-b45196ae7e3b"
]
View formatted query    View runnable query    Explain query
4.53 ms
(21.97%) 		1 
SELECT u0_.id AS id_0, u0_.date AS date_1, u0_.email AS email_2, u0_.phone AS phone_3, u0_.phone_numeric AS phone_numeric_4, u0_.privacy_mask AS privacy_mask_5, u0_.push_settings_mask AS push_settings_mask_6, u0_.password AS password_7, u0_.about AS about_8, u0_.stuff AS stuff_9, u0_.vk_code_verifier AS vk_code_verifier_10, u0_.vk_id AS vk_id_11, u0_.vk_avatar AS vk_avatar_12, u0_.new_email AS new_email_13, u0_.new_email_token AS new_email_token_14, u0_.status AS status_15, u0_.role AS role_16, u0_.is_online AS is_online_17, u0_.last_visit AS last_visit_18, u0_.last_visit_at AS last_visit_at_19, u0_.confirm_token_token AS confirm_token_token_20, u0_.confirm_token_expires AS confirm_token_expires_21, u0_.name_first AS name_first_22, u0_.name_last AS name_last_23, u0_.name_middle AS name_middle_24, u0_.avatar_small_hash AS avatar_small_hash_25, u0_.avatar_original_hash AS avatar_original_hash_26, u0_.reset_token_token AS reset_token_token_27, u0_.reset_token_expires AS reset_token_expires_28, u0_.city_id AS city_id_29 FROM "user_users" u0_ WHERE u0_.email = ?
Parameters: 
[
  "mk@mk.yo"
]
View formatted query    View runnable query    Explain query
3.04 ms
(14.72%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.34 ms
(6.51%) 		1 
UPDATE "user_users" SET phone_numeric = ?, last_visit_at = ? WHERE id = ?
Parameters: 
[
  79213857589
  "2026-05-01 16:42:52"
  "01945c33-6f15-0e5c-b3f8-b45196ae7e3b"
]
View formatted query    View runnable query    Explain query
0.77 ms
(3.72%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query

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
App\Model\City\Entity\CityReference 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
  • The field 'App\Model\User\Entity\User#phoneNumeric' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
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\Album No errors.
App\Model\User\Entity\Link\Link No errors.
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\Instrument\UserInstrument No errors.
App\Model\User\Entity\FcmToken\UserFcmToken No errors.