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

Query Metrics

12 Database Queries
11 Different statements
472.29 ms Query time
0 Invalid entities
7 Managed entities

Grouped Statements

Show all queries

Time Count Info
69.93 ms
(14.81%)
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
]
66.10 ms
(14.00%)
1
UPDATE task SET status = ?, started_at = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "IN_PROGRESS"
  "2026-06-10 14:31:12"
  "2026-06-10 14:31:12"
  102234
]
45.00 ms
(9.53%)
1
SELECT NEXTVAL('task_audit_log_id_seq')
Parameters:
[]
42.53 ms
(9.01%)
1
INSERT INTO task_audit_log (id, action, old_value, new_value, metadata, performed_by_id, created_at, ip_address, task_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  38
  "STATUS_CHANGE"
  "ASSIGNED"
  "IN_PROGRESS"
  null
  450
  "2026-06-10 14:31:12"
  null
  102234
]
37.27 ms
(7.89%)
1
SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.todo_date AS todo_date_3, t0.status AS status_4, t0.priority AS priority_5, t0.assignee_id AS assignee_id_6, t0.created_at AS created_at_7, t0.company_id AS company_id_8, t0.listing_id AS listing_id_9, t0.related_task_id AS related_task_id_10, t0.reported_by AS reported_by_11, t0.team_id AS team_id_12, t0.started_at AS started_at_13, t0.completed_at AS completed_at_14, t0.completed_by AS completed_by_15, t0.estimated_duration AS estimated_duration_16, t0.actual_duration AS actual_duration_17, t0.updated_at AS updated_at_18, t0.inspection_status AS inspection_status_19, t0.inspected_by AS inspected_by_20, t0.inspected_at AS inspected_at_21, t0.source_issue_id AS source_issue_id_22, t0.cancelled_at AS cancelled_at_23, t0.due_at AS due_at_24, t0.unit_price AS unit_price_25, t0.is_deleted AS is_deleted_26, t0.type, t0.checkout_time AS checkout_time_27, t0.guest_name AS guest_name_28, t0.number_of_guests AS number_of_guests_29, t0.next_checkin_time AS next_checkin_time_30, t0.damage_check_completed AS damage_check_completed_31, t0.checkin_time AS checkin_time_32, t0.guest_name AS guest_name_33, t0.number_of_guests AS number_of_guests_34, t0.maintenance_type AS maintenance_type_35, t0.actual_cost AS actual_cost_36, t0.vendor_name AS vendor_name_37, t0.vendor_phone AS vendor_phone_38 FROM task t0 WHERE t0.id = ? AND t0.type IN ('CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING', 'MAINTENANCE')
Parameters:
[
  102234
]
36.79 ms
(7.79%)
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.eyJpYXQiOjE3ODExMjcwMzIsImV4cCI6MTc4MjQyMzAzMiwicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJhZG1pbkBjb3p5LmNvbSJ9.huYbGikSBMw8D9V8ZQN_oAFO1VPZiFWfi5XWfF3_o0q7MAoadroCLTBDdrmkrRFr2wAkt-sNPbJMMqbbdcy_Py1Qu0x1EUDg-6u8kMqH0mBK-JHzE9MIlH7QPDuT1GNivNd0r35a7iE5vs3h2xYRUSwKheTT_HMTwe_sS2T0zSZUhaeH-uxE2oKHbrCJAJywU4vq6gCdVfYdk2LXQ_mbzarA4LulW56OJ89y8DhtcWqeq5VfO5uq6nYLYzpyyw522MeJhEFcSG8yfsUZXEK6vYVLFoZUpoZbh0T2ZQBz4h_2Tji_mwl1T-mQradjlIoEMW6VyJ49w_RZOzFUoakmIQ"
]
35.83 ms
(7.59%)
1
"COMMIT"
Parameters:
[]
35.45 ms
(7.51%)
1
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
]
35.43 ms
(7.50%)
1
SELECT t0.id AS id_1, t0.team_name AS team_name_2, t0.phone_number AS phone_number_3, t0.email AS email_4, t0.cleaning_rules AS cleaning_rules_5, t0.company_id AS company_id_6, t0.created_at AS created_at_7 FROM team t0 WHERE t0.id = ?
Parameters:
[
  17
]
34.29 ms
(7.26%)
1
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.phone_number AS phone_number_3, t0.email AS email_4, t0.created_at AS created_at_5, t0.cleaning_rules AS cleaning_rules_6 FROM company t0 WHERE t0.id = ?
Parameters:
[
  1
]
33.67 ms
(7.13%)
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\AccessToken 1
App\Entity\Account 1
App\Entity\AccountRole 1
App\Entity\Task 1
App\Entity\Company 1
App\Entity\Team 1
App\Entity\TaskAuditLog 1

Entities Mapping