Query Metrics
6
Database Queries
6
Different statements
48.62 ms
Query time
3
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
30.44 ms (62.60%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.email AS email_3, t0.phone AS phone_4, t0.phone_numeric AS phone_numeric_5, t0.privacy_mask AS privacy_mask_6, t0.push_settings_mask AS push_settings_mask_7, t0.password AS password_8, t0.about AS about_9, t0.stuff AS stuff_10, t0.vk_code_verifier AS vk_code_verifier_11, t0.vk_id AS vk_id_12, t0.vk_avatar AS vk_avatar_13, t0.new_email AS new_email_14, t0.new_email_token AS new_email_token_15, t0.status AS status_16, t0.role AS role_17, t0.is_online AS is_online_18, t0.last_visit AS last_visit_19, t0.last_visit_at AS last_visit_at_20, t0.confirm_token_token AS confirm_token_token_21, t0.confirm_token_expires AS confirm_token_expires_22, t0.name_first AS name_first_23, t0.name_last AS name_last_24, t0.name_middle AS name_middle_25, t0.avatar_small_hash AS avatar_small_hash_26, t0.avatar_original_hash AS avatar_original_hash_27, t0.reset_token_token AS reset_token_token_28, t0.reset_token_expires AS reset_token_expires_29, t0.city_id AS city_id_30 FROM "user_users" t0 WHERE t0.id = ?
Parameters:
[
"019deeab-5934-3cf0-ae98-dc6d872da1b4"
]
|
|
8.13 ms (16.72%) |
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:
[
"73ee8243-c222-4e78-8531-b0b1108d27bc"
]
|
|
4.51 ms (9.28%) |
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:
[
"80e51a4e-1b0b-456a-93dd-210d099ca9ed@775d2008-9edb-4e71-bccf-e3a51be771ba.com"
]
|
|
4.38 ms (9.02%) |
1 |
UPDATE "user_users" SET last_visit_at = ? WHERE id = ?
Parameters:
[ "2026-05-03 22:55:42" "73ee8243-c222-4e78-8531-b0b1108d27bc" ] |
|
0.60 ms (1.24%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.55 ms (1.14%) |
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 | 2 |
| 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 |
|
| App\Model\City\Entity\CityReference |
|
| 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 |
|
| 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. |