POST http://dev-cleanfy.cozystay.com/graphql/

Query Metrics

17 Database Queries
11 Different statements
695.70 ms Query time
0 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

Time Count Info
122.63 ms
(17.63%)
3
"COMMIT"
Parameters:
[]
118.50 ms
(17.03%)
3
"START TRANSACTION"
Parameters:
[]
84.96 ms
(12.21%)
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
]
80.72 ms
(11.60%)
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
]
42.47 ms
(6.10%)
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:105795;}}"
  "[]"
  "default"
  "2026-06-18 00:37:35"
  "2026-06-18 00:37:35"
]
41.72 ms
(6.00%)
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.19 ms
(5.92%)
1
SELECT NEXTVAL('task_id_seq')
Parameters:
[]
41.11 ms
(5.91%)
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, type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  105795
  null
  "2026-07-11 10:00:00"
  "TODO"
  "MEDIUM"
  null
  "2026-06-17 17:37:34"
  null
  11
  null
  null
  null
  null
  null
  null
  null
  null
  null
  "NOT_APPLICABLE"
  null
  null
  null
  null
  null
  8000
  0
  "ONE_TIME_CLEANING"
]
40.95 ms
(5.89%)
1
INSERT INTO task_note (id, content, created_by_id, created_at, updated_at, is_deleted, task_id, note_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  5019
  "QA-ADV2 A6-XSS2 <script>window.__xss2=1</script>"
  450
  "2026-06-17 17:37:35"
  null
  0
  105795
  "GENERAL"
]
40.76 ms
(5.86%)
1
SELECT NEXTVAL('task_note_id_seq')
Parameters:
[]
40.70 ms
(5.85%)
1
SELECT t0.id AS id_1, t0.address AS address_2, t0.nickname AS nickname_3, t0.price AS price_4, t0.pet_fee AS pet_fee_5, t0.deposit_fee AS deposit_fee_6, t0.cleaning_fee AS cleaning_fee_7, t0.room_type AS room_type_8, t0.house_rules AS house_rules_9, t0.minimal_stay AS minimal_stay_10, t0.maximum_stay AS maximum_stay_11, t0.accommodates AS accommodates_12, t0.room_area AS room_area_13, t0.number_of_beds AS number_of_beds_14, t0.number_of_rooms AS number_of_rooms_15, t0.number_of_bathrooms AS number_of_bathrooms_16, t0.access_code AS access_code_17, t0.timezone AS timezone_18, t0.company_id AS company_id_19, t0.assignee_id AS assignee_id_20, t0.team_id AS team_id_21, t0.is_active AS is_active_22, t0.need_key AS need_key_23, t0.city AS city_24, t0.latitude AS latitude_25, t0.longitude AS longitude_26, t0.has_living_room AS has_living_room_27, t0.has_kitchen AS has_kitchen_28, t0.has_garbage_bin AS has_garbage_bin_29, t0.new_cleaning_fee AS new_cleaning_fee_30, t0.cleaning_fee_effective_date AS cleaning_fee_effective_date_31, t0.created_at AS created_at_32 FROM property t0 WHERE t0.id = ?
Parameters:
[
  11
]

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\Property 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\Property No errors.
App\Entity\Task No errors.
App\Entity\OneTimeCleaningTask No errors.
App\Entity\AbstractTaskNote No errors.
App\Entity\TaskNote No errors.