Query Metrics
16
Database Queries
10
Different statements
690.35 ms
Query time
0
Invalid entities
5
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
124.20 ms (17.99%) |
3 |
"COMMIT"
Parameters:
[] |
|
119.06 ms (17.25%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
81.75 ms (11.84%) |
2 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.full_name AS full_name_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.contact_info AS contact_info_7, t0.timezone AS timezone_8, t0.current_company_id AS current_company_id_9, t0.current_team_id AS current_team_id_10 FROM account t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
450
]
|
|
81.04 ms (11.74%) |
2 |
SELECT a0_.id AS id_0, a0_.role AS role_1, a0_.scope AS scope_2, a0_.is_active AS is_active_3, a0_.created_at AS created_at_4, a0_.account_id AS account_id_5, a0_.company_id AS company_id_6, a0_.team_id AS team_id_7 FROM account_role a0_ WHERE a0_.account_id = ? AND a0_.is_active = true
Parameters:
[
450
]
|
|
67.87 ms (9.83%) |
1 |
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id
Parameters:
[ "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:23:\"App\\Message\\TaskUpdated\":1:{s:31:\"\0App\\Message\\TaskUpdated\0taskId\";i:105782;}}" "[]" "default" "2026-06-18 00:29:22" "2026-06-18 00:29:22" ] |
|
49.63 ms (7.19%) |
1 |
INSERT INTO task (id, order_id, todo_date, status, priority, assignee_id, created_at, company_id, listing_id, related_task_id, reported_by, team_id, started_at, completed_at, completed_by, estimated_duration, actual_duration, updated_at, inspection_status, inspected_by, inspected_at, source_issue_id, cancelled_at, due_at, unit_price, is_deleted, checkout_time, guest_name, number_of_guests, next_checkin_time, damage_check_completed, type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 105782 null "2026-07-01 10:00:00" "TODO" "MEDIUM" null "2026-06-17 17:29:22" null null null null null null null null null null null "NOT_APPLICABLE" null null null null null null 0 null null null null 0 "CHECK_OUT" ] |
|
42.66 ms (6.18%) |
1 |
INSERT INTO task_note (id, content, created_by_id, created_at, updated_at, is_deleted, task_id, note_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 5009 "QA-ADV2 A1 empty-gate bypass (only todoDate provided, no listing/type)" 450 "2026-06-17 17:29:22" null 0 105782 "GENERAL" ] |
|
42.26 ms (6.12%) |
1 |
SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.expires_in AS expires_in_3, t0.token AS token_4, t0.created_at AS created_at_5 FROM access_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
"eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3ODE3NDIyODQsImV4cCI6MTc4MzAzODI4NCwicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJhZG1pbkBjb3p5LmNvbSJ9.R75pB157BTbXOldRrTmJJ8Q6RfrEBbZO_E9_YJ7uCp7JsH0JhpdUdlVA3ayEw_5MZZ7b4TcrSmlaF0AOGxuE5FfZvFFLI5NGceu6QwSTnFxgmN_Voyn5q-7dSGCPOiMcZRuLTFOi0pnVPSdFeVqAAP586yzfi8TWuudttuO7O2xhONrczvVNvjHsxuILxsnp6if7j_nExbkmcDrtUv9VKxWPRxNWcj0MhtwoxIcZN9zu6pDufLQXHWrNhcYA5qplz9WLwjj3GCPHav7dZsgNUg1w3UUGhc6k8dvCBY46E2zmzMG03rE3TaBWKlEayBuRdKo9VnLNGWl-eVIlUUvNTw"
]
|
|
41.55 ms (6.02%) |
1 |
SELECT NEXTVAL('task_note_id_seq')
Parameters:
[] |
|
40.33 ms (5.84%) |
1 |
SELECT NEXTVAL('task_id_seq')
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\AccessToken | 1 |
| App\Entity\Account | 1 |
| App\Entity\AccountRole | 1 |
| App\Entity\Task | 1 |
| App\Entity\AbstractTaskNote | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\AccessToken | No errors. |
| App\Entity\Account | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Team | No errors. |
| App\Entity\AccountRole | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\DepartureCleaningTask | No errors. |
| App\Entity\AbstractTaskNote | No errors. |
| App\Entity\TaskNote | No errors. |