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

Query Metrics

18 Database Queries
15 Different statements
771.09 ms Query time
0 Invalid entities
251 Managed entities

Grouped Statements

Show all queries

Time Count Info
120.50 ms
(15.63%)
3
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
]
80.55 ms
(10.45%)
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
]
53.95 ms
(7.00%)
1
SELECT r0_.id AS id_0, r0_.listing_id AS listing_id_1, r0_.customer_name AS customer_name_2, r0_.guest_count AS guest_count_3, r0_.check_in_date AS check_in_date_4, r0_.check_out_date AS check_out_date_5, r0_.status_code AS status_code_6, r0_.contact_info AS contact_info_7, r0_.platform_code AS platform_code_8, r0_.channel_code AS channel_code_9, r0_.created_at AS created_at_10, r0_.channel_id AS channel_id_11, r0_.platform_order_id AS platform_order_id_12, r0_.integration AS integration_13, r0_.total AS total_14, r0_.currency AS currency_15, r0_.confirmed_at AS confirmed_at_16, r0_.is_paid AS is_paid_17, r0_.external_property_id AS external_property_id_18, r0_.confirmation_code AS confirmation_code_19, r0_.last_event_at AS last_event_at_20 FROM "reservation" r0_ WHERE r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  45034
  52752
  61596
  47281
  49573
  50473
  50474
  50592
  50593
  51029
  51178
  51409
  52906
  63963
  64368
]
48.03 ms
(6.23%)
1
SELECT p0_.id AS id_0, p0_.file_name AS file_name_1, p0_.directory AS directory_2, p0_.deleted AS deleted_3, p0_.created_at AS created_at_4, p0_.category AS category_5, p0_.latitude AS latitude_6, p0_.longitude AS longitude_7, p0_.captured_at AS captured_at_8, p0_.device_info AS device_info_9, p0_.file_size AS file_size_10, p0_.mime_type AS mime_type_11, p0_.related_id AS related_id_12, p0_.passed AS passed_13, p0_.photo_type AS photo_type_14, p0_.task_id AS task_id_15 FROM photo p0_ WHERE (p0_.task_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.deleted = false) AND p0_.photo_type IN ('task') ORDER BY p0_.created_at DESC
Parameters:
[
  71185
  105798
  84697
  105797
  99714
  75109
  79238
  80800
  80802
  81012
  81014
  81757
  82031
  82439
  84961
  105796
  104079
  105795
  105810
  79237
  81011
  81013
  81756
  84960
  104769
]
46.71 ms
(6.06%)
1
SELECT t0_.id AS id_0, t0_.content AS content_1, t0_.created_by_id AS created_by_id_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4, t0_.is_deleted AS is_deleted_5, t0_.note_type AS note_type_6, t0_.task_id AS task_id_7 FROM task_note t0_ WHERE (t0_.task_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0_.is_deleted = false) AND t0_.note_type IN ('GENERAL') ORDER BY t0_.created_at DESC
Parameters:
[
  71185
  105798
  84697
  105797
  99714
  75109
  79238
  80800
  80802
  81012
  81014
  81757
  82031
  82439
  84961
  105796
  104079
  105795
  105810
  79237
  81011
  81013
  81756
  84960
  104769
]
45.68 ms
(5.92%)
1
SELECT t0_.id AS id_0, t0_.order_id AS order_id_1, t0_.todo_date AS todo_date_2, t0_.status AS status_3, t0_.priority AS priority_4, t0_.assignee_id AS assignee_id_5, t0_.created_at AS created_at_6, t0_.company_id AS company_id_7, t0_.listing_id AS listing_id_8, t0_.related_task_id AS related_task_id_9, t0_.reported_by AS reported_by_10, t0_.team_id AS team_id_11, t0_.started_at AS started_at_12, t0_.completed_at AS completed_at_13, t0_.completed_by AS completed_by_14, t0_.estimated_duration AS estimated_duration_15, t0_.actual_duration AS actual_duration_16, t0_.updated_at AS updated_at_17, t0_.inspection_status AS inspection_status_18, t0_.inspected_by AS inspected_by_19, t0_.inspected_at AS inspected_at_20, t0_.source_issue_id AS source_issue_id_21, t0_.cancelled_at AS cancelled_at_22, t0_.due_at AS due_at_23, t0_.unit_price AS unit_price_24, t0_.is_deleted AS is_deleted_25, t0_.checkout_time AS checkout_time_26, t0_.guest_name AS guest_name_27, t0_.number_of_guests AS number_of_guests_28, t0_.next_checkin_time AS next_checkin_time_29, t0_.damage_check_completed AS damage_check_completed_30, t0_.checkin_time AS checkin_time_31, t0_.guest_name AS guest_name_32, t0_.number_of_guests AS number_of_guests_33, t0_.maintenance_type AS maintenance_type_34, t0_.actual_cost AS actual_cost_35, t0_.vendor_name AS vendor_name_36, t0_.vendor_phone AS vendor_phone_37, (CASE WHEN t0_.type IN ('CHECK_OUT') THEN 0 WHEN t0_.type IN ('ONE_TIME_CLEANING') THEN 1 WHEN t0_.type IN ('MAINTENANCE') THEN 2 WHEN t0_.type IN ('CHECK_IN') THEN 3 ELSE 4 END) AS sclr_38, t0_.type AS type_39 FROM task t0_ WHERE (t0_.is_deleted = false AND (t0_.todo_date >= ? AND t0_.todo_date <= ?)) AND t0_.type IN ('CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING', 'MAINTENANCE') ORDER BY (t0_.todo_date)::date DESC, sclr_38 ASC, t0_.id ASC LIMIT 25
Parameters:
[
  "2026-07-08 07:00:00"
  "2026-07-15 06:59:59"
]
45.16 ms
(5.86%)
1
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.is_completed AS is_completed_3, t0_.is_required AS is_required_4, t0_.requires_photo AS requires_photo_5, t0_.sort_order AS sort_order_6, t0_.key AS key_7, t0_.passed AS passed_8, t0_.completed_at AS completed_at_9, t0_.created_at AS created_at_10, t0_.task_id AS task_id_11, t0_.template_item_id AS template_item_id_12, t0_.completed_by_id AS completed_by_id_13 FROM task_checklist_item t0_ WHERE t0_.task_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0_.sort_order ASC
Parameters:
[
  71185
  105798
  84697
  105797
  99714
  75109
  79238
  80800
  80802
  81012
  81014
  81757
  82031
  82439
  84961
  105796
  104079
  105795
  105810
  79237
  81011
  81013
  81756
  84960
  104769
]
43.88 ms
(5.69%)
1
SELECT COUNT(t0_.id) AS sclr_0 FROM task t0_ WHERE (t0_.is_deleted = false AND (t0_.todo_date >= ? AND t0_.todo_date <= ?)) AND t0_.type IN ('CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING', 'MAINTENANCE')
Parameters:
[
  "2026-07-08 07:00:00"
  "2026-07-15 06:59:59"
]
42.32 ms
(5.49%)
1
SELECT t0_.id AS id_0, t0_.team_name AS team_name_1, t0_.phone_number AS phone_number_2, t0_.email AS email_3, t0_.cleaning_rules AS cleaning_rules_4, t0_.company_id AS company_id_5, t0_.created_at AS created_at_6 FROM team t0_ WHERE t0_.id IN (?, ?, ?)
Parameters:
[
  1
  10
  17
]
41.86 ms
(5.43%)
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.eyJpYXQiOjE3ODM1NjE0NzksImV4cCI6MTc4NDg1NzQ3OSwicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJhZG1pbkBjb3p5LmNvbSJ9.fz6fIn4C5QmPRQHVmWE8r6pQ1ULvnNxtZeah2VvPLzPoiuCq0FG0m1KGM67EbawwtZ_4BRW5J3_T8BZbCDI4kqpgDBO_nAY1Sd7zYGX-qBsBVUU7zoNXsCUBsD5oaUCtKpFsw7Eb4P_jNqzPxMpv6tVGZ7T6p9G2-2rIgRBBVhTpc6rjSUJNdLPeMkll9OYIukPv0IH6jHJPxKOyoSnbY-LNwo58B0HJDY3TwO9w92Ew8PbTbDVYwM8MPYkF4g7DqChdOb_mR-w8sd19FAImdptQ5Sx11gNz4GSt1ADh_EyPdMuAWIjxnYGq6N4nryhPE6tJ3cWsejH4sL2oThZlFA"
]
41.25 ms
(5.35%)
1
SELECT p0_.id AS id_0, p0_.file_name AS file_name_1, p0_.directory AS directory_2, p0_.deleted AS deleted_3, p0_.created_at AS created_at_4, p0_.category AS category_5, p0_.latitude AS latitude_6, p0_.longitude AS longitude_7, p0_.captured_at AS captured_at_8, p0_.device_info AS device_info_9, p0_.file_size AS file_size_10, p0_.mime_type AS mime_type_11, p0_.related_id AS related_id_12, p0_.passed AS passed_13, p0_.photo_type AS photo_type_14, p0_.task_id AS task_id_15, p0_.checklist_item_id AS checklist_item_id_16 FROM photo p0_ WHERE (p0_.checklist_item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.deleted = false) AND p0_.photo_type IN ('checklist') ORDER BY p0_.created_at DESC
Parameters:
[
  33
  34
  35
  36
  37
  555
  551
  552
  553
  554
  97
  98
  99
  100
  101
  546
  547
  548
  549
  550
  52
  53
  54
  55
  56
  62
  63
  64
  65
  66
  67
  68
  69
  70
  71
  77
  78
  79
  80
  81
  72
  73
  74
  75
  76
  87
  88
  89
  90
  91
  92
  93
  94
  95
  96
  24
  25
  26
  27
  23
  102
  103
  104
  105
  106
  541
  542
  543
  544
  545
  362
  363
  364
  365
  366
  536
  537
  538
  539
  540
  597
  593
  594
  595
  596
  423
  424
  425
  426
  427
  428
  429
  430
  431
  432
  433
]
41.05 ms
(5.32%)
1
SELECT p0_.id AS id_0, p0_.address AS address_1, p0_.nickname AS nickname_2, p0_.price AS price_3, p0_.pet_fee AS pet_fee_4, p0_.deposit_fee AS deposit_fee_5, p0_.cleaning_fee AS cleaning_fee_6, p0_.room_type AS room_type_7, p0_.house_rules AS house_rules_8, p0_.minimal_stay AS minimal_stay_9, p0_.maximum_stay AS maximum_stay_10, p0_.accommodates AS accommodates_11, p0_.room_area AS room_area_12, p0_.number_of_beds AS number_of_beds_13, p0_.number_of_rooms AS number_of_rooms_14, p0_.number_of_bathrooms AS number_of_bathrooms_15, p0_.access_code AS access_code_16, p0_.timezone AS timezone_17, p0_.company_id AS company_id_18, p0_.assignee_id AS assignee_id_19, p0_.team_id AS team_id_20, p0_.is_active AS is_active_21, p0_.need_key AS need_key_22, p0_.city AS city_23, p0_.latitude AS latitude_24, p0_.longitude AS longitude_25, p0_.has_living_room AS has_living_room_26, p0_.has_kitchen AS has_kitchen_27, p0_.has_garbage_bin AS has_garbage_bin_28, p0_.new_cleaning_fee AS new_cleaning_fee_29, p0_.cleaning_fee_effective_date AS cleaning_fee_effective_date_30, p0_.created_at AS created_at_31 FROM property p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1772
  11
  1788
  2194
  1773
  1774
  1775
  1776
  1777
  1778
  1779
  1780
  1789
  2272
  179
  632
]
40.42 ms
(5.24%)
1
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.full_name AS full_name_2, a0_.password AS password_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.contact_info AS contact_info_6, a0_.timezone AS timezone_7, a0_.current_company_id AS current_company_id_8, a0_.current_team_id AS current_team_id_9 FROM account a0_ WHERE a0_.id IN (?, ?, ?, ?, ?)
Parameters:
[
  1
  425
  446
  5
  118
]
40.06 ms
(5.20%)
1
SELECT c0_.id AS id_0, c0_.company_name AS company_name_1, c0_.phone_number AS phone_number_2, c0_.email AS email_3, c0_.created_at AS created_at_4, c0_.cleaning_rules AS cleaning_rules_5 FROM company c0_ WHERE c0_.id IN (?)
Parameters:
[
  1
]
39.67 ms
(5.14%)
1
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.full_name AS full_name_2, a0_.password AS password_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.contact_info AS contact_info_6, a0_.timezone AS timezone_7, a0_.current_company_id AS current_company_id_8, a0_.current_team_id AS current_team_id_9 FROM account a0_ WHERE a0_.id IN (?)
Parameters:
[
  450
]

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\TaskChecklistItem 96
App\Entity\PropertyChecklistTemplate 81
App\Entity\Task 25
App\Entity\Property 16
App\Entity\Reservation 15
App\Entity\Account 6
App\Entity\AbstractTaskNote 5
App\Entity\Team 4
App\Entity\AccessToken 1
App\Entity\AccountRole 1
App\Entity\Company 1