Query Metrics
7
Database Queries
7
Different statements
33.10 ms
Query time
4
Invalid entities
2
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.71 ms (23.29%) |
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"
]
|
|
7.52 ms (22.73%) |
1 |
SELECT a.id, a.initiator, a.recipient, a.recipient_message_counter, a.initiator_message_counter, a.created_at, a.updated_at, i.name_first as initiator_name, i.name_last as initiator_name_last, i.avatar_small_hash as initiator_avatar_small_hash, r.name_first as recipient_name, r.name_last as recipient_name_last, r.avatar_small_hash as recipient_avatar_small_hash, a.recipient_last_message_message_id, a.recipient_last_message_message, a.recipient_last_message_timestamp, a.recipient_last_message_updated_at, a.recipient_last_message_status, a.initiator_last_message_message_id, a.initiator_last_message_message, a.initiator_last_message_timestamp, a.initiator_last_message_updated_at, a.initiator_last_message_status FROM user_conversations a LEFT JOIN user_users i ON a.initiator = i.id LEFT JOIN user_users r ON a.recipient = r.id WHERE ((a.initiator = ?) OR (a.recipient = ?)) AND (a.status = ?) LIMIT 25
Parameters:
[ "01945c33-6f15-0e5c-b3f8-b45196ae7e3b" "01945c33-6f15-0e5c-b3f8-b45196ae7e3b" "active" ] |
|
6.95 ms (21.01%) |
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"
]
|
|
5.86 ms (17.70%) |
1 |
SELECT COUNT(DISTINCT a.id) AS total_results FROM user_conversations a LEFT JOIN user_users i ON a.initiator = i.id LEFT JOIN user_users r ON a.recipient = r.id WHERE ((a.initiator = ?) OR (a.recipient = ?)) AND (a.status = ?) LIMIT 1
Parameters:
[ "01945c33-6f15-0e5c-b3f8-b45196ae7e3b" "01945c33-6f15-0e5c-b3f8-b45196ae7e3b" "active" ] |
|
3.22 ms (9.72%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
1.30 ms (3.93%) |
1 |
UPDATE "user_users" SET phone_numeric = ?, last_visit_at = ? WHERE id = ?
Parameters:
[ 79213857589 "2026-05-01 16:41:28" "01945c33-6f15-0e5c-b3f8-b45196ae7e3b" ] |
|
0.53 ms (1.61%) |
1 |
"COMMIT"
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 |
| 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. |
| App\Model\User\Entity\Message\InitiatorLastMessage | No errors. |
| App\Model\User\Entity\Message\RecipientLastMessage | No errors. |
| App\Model\User\Entity\Message\Conversation |
|