Query Metrics
6
Database Queries
6
Different statements
8.76 ms
Query time
1
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.91 ms (44.57%) |
1 |
SELECT nextval('pii_access_log_id_seq')
Parameters:
[] |
|
1.76 ms (20.13%) |
1 |
INSERT INTO pii_access_log (id, admin_user_id, operator, source, target_user_id, lookup_by, reason, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 11 2 "admin" "admin" 23 "phone" "Консоль запросов: Профиль" "2026-10-07 12:51:58" ] |
|
1.11 ms (12.70%) |
1 |
SELECT u0_.id AS id_0 FROM "user" u0_ WHERE u0_.phone_hash IN (?, ?, ?)
Parameters:
[ "3bc16c544d637860c90747abec5f9d01c8ca3e818e7566e5ae1b10f7ce541798" "9a9699a18201dcffa0297aecd2e1b30a8e34038c0e3b0e1e0acbf0e0c4a835ba" "b60de6003b74f0a039830705e2a3ab75cc3291239aff51fd50aba2a9cf888064" ] |
|
0.93 ms (10.59%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.name AS name_4, t0.is_active AS is_active_5, t0.last_login_at AS last_login_at_6, t0.created_at AS created_at_7, t0.password AS password_8 FROM admin_user t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.57 ms (6.51%) |
1 |
SELECT d0_.client_timezone AS client_timezone_0, CASE WHEN d0_.status = ? THEN 0 ELSE 1 END AS sclr_1, COALESCE(d0_.last_activity_at, d0_.created_at) AS sclr_2 FROM device d0_ WHERE d0_.user_id = ? AND d0_.client_timezone IS NOT NULL ORDER BY sclr_1 ASC, sclr_2 DESC, d0_.id DESC LIMIT 1
Parameters:
[ 10 23 ] |
|
0.48 ms (5.50%) |
1 |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.surname AS surname_3, t0.patronymic AS patronymic_4, t0.date_birth AS date_birth_5, t0.email AS email_6, t0.email_hash AS email_hash_7, t0.phone AS phone_8, t0.phone_hash AS phone_hash_9, t0.status AS status_10, t0.verification_status AS verification_status_11, t0.bonus AS bonus_12, t0.notification_subscription_status AS notification_subscription_status_13, t0.created_at AS created_at_14, t0.last_activity_at AS last_activity_at_15, t0.is_guest AS is_guest_16, t0.external_uid AS external_uid_17, t0.roles AS roles_18, t0.vk_id AS vk_id_19, t0.vk_id_hash AS vk_id_hash_20, t0.is_pin_enabled AS is_pin_enabled_21, t0.is_biometry_enabled AS is_biometry_enabled_22, t0.email_updated_at AS email_updated_at_23, t0.email_requested_at AS email_requested_at_24, t0.gender AS gender_25, t0.is_evaluation_on_catalog AS is_evaluation_on_catalog_26, t0.last_platform_presentation_at AS last_platform_presentation_at_27, t0.last_dealer_id AS last_dealer_id_28, t0.city_id AS city_id_29, t0.registration_city_id AS registration_city_id_30 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
23
]
|
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\Entity\AdminUser | 1 |
| App\Entity\User | 1 |
| App\Entity\City | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\AdminUser | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Dealer | No errors. |
| App\Entity\City |
|
| App\Entity\Invoice | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\UserWatchedFavourite | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\FeedbackSession | No errors. |
| App\Entity\CarEvaluationRequest | No errors. |
| App\Entity\Device | No errors. |