Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

19.25 ms Query time

2 Invalid entities

1 Managed entities

Queries


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 = ?
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 = ?
"START TRANSACTION"
UPDATE "user_users" SET last_visit_at = ? WHERE id = ?
"COMMIT"

#▲	Time	Info
1	6.23 ms	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"`] View formatted query View runnable query Explain query 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 = ? 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 = 'mk@mk.yo';
2	10.29 ms	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"`] View formatted query View runnable query Explain query 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 = ? 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 = '01945c33-6f15-0e5c-b3f8-b45196ae7e3b';
3	0.33 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
4	1.59 ms	UPDATE "user_users" SET last_visit_at = ? WHERE id = ? Parameters: [`"2026-03-19 05:14:58" "01945c33-6f15-0e5c-b3f8-b45196ae7e3b"`] View formatted query View runnable query Explain query UPDATE "user_users" SET last_visit_at = ? WHERE id = ? UPDATE "user_users" SET last_visit_at = '2026-03-19 05:14:58' WHERE id = '01945c33-6f15-0e5c-b3f8-b45196ae7e3b';
5	0.81 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping