Query Metrics
5
Database Queries
5
Different statements
95.05 ms
Query time
0
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
93.66 ms (98.54%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.56 ms (0.59%) |
1 |
SELECT v0_.id AS id_0, v0_.full_name AS full_name_1, v0_.photo_name AS photo_name_2, v0_.role AS role_3, v0_.phone AS phone_4, v0_.car_number AS car_number_5, v0_.tariff_start_date AS tariff_start_date_6, v0_.tariff_end_date AS tariff_end_date_7, v0_.access_card_number AS access_card_number_8, v0_.created_at AS created_at_9, v0_.updated_at AS updated_at_10, t1_.id AS id_11, t1_.name AS name_12, t1_.description AS description_13, t1_.price AS price_14, t1_.duration_days AS duration_days_15, t1_.available_after_expiration AS available_after_expiration_16, t1_.is_active AS is_active_17, t1_.sort_order AS sort_order_18, t1_.created_at AS created_at_19, t1_.updated_at AS updated_at_20, v0_.tariff_id AS tariff_id_21 FROM visitor v0_ LEFT JOIN tariff t1_ ON v0_.tariff_id = t1_.id WHERE v0_.id = ?
Parameters:
[
84
]
|
|
0.37 ms (0.39%) |
1 |
INSERT INTO visitor_history (visitor_id, visitor_full_name, action, name_apm, request_method, request_body, created_at) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 84 "кккк кккк" "extend_tariff" "terminal" "PATCH /api/visitors/84/extend-tariff?tariffId=5" "{"nameAPM":"terminal"}" "2026-04-16 16:05:28" ] |
|
0.30 ms (0.32%) |
1 |
UPDATE visitor SET tariff_end_date = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-04-19" "2026-04-16 16:05:28" 84 ] |
|
0.16 ms (0.17%) |
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\Entity\Visitor | 1 |
| App\Entity\Tariff | 1 |
| App\Entity\VisitorHistory | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Visitor | No errors. |
| App\Entity\Tariff | No errors. |
| App\Entity\VisitorHistory | No errors. |