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

Query Metrics

7 Database Queries
6 Different statements
287.92 ms Query time
0 Invalid entities
20 Managed entities

Grouped Statements

Show all queries

Time Count Info
81.73 ms
(28.39%)
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
]
42.09 ms
(14.62%)
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.eyJpYXQiOjE3ODEwMjY4MTUsImV4cCI6MTc4MjMyMjgxNSwicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJhZG1pbkBjb3p5LmNvbSJ9.Vqpr2RRVGRbxrG9Iu0ERNJD7L9ilSDiPkWY-zYMPEI-wUB-bf1BTYJstbWkS8vcjzsY44XfesVqtzA-vaGrzNwh1GY8rrIMqZKmET_YdRsnqaZPCbxnvgpE3RA0HvZx-t5r9AF2kEmWlI6b1jveJEz4MCAHTegrG1r5H8Pupw2So1arueJdcmC-qzbewVxUE2JNvq91MVUIVTu-jB2lwfQp3topszlwSLb9rtdO5PxJwRu6sNkU0gYBsJvEhTVAokx8o0DFcm4R_EoaEMxs4F5d7mm7GYS7M8z6v4n5ECylBEaHTlLuz-7OROA3Ulu3DtjWg8u89k6c5d5SkoLrzAg"
]
41.56 ms
(14.43%)
1
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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  77
  122
  117
  50
  51
  49
  47
  112
  7
  76
  15
  48
  169
  78
  168
]
41.35 ms
(14.36%)
1
SELECT DISTINCT a0_.account_id AS sclr_0 FROM account_role a0_ WHERE a0_.team_id = ? AND a0_.is_active = true
Parameters:
[
  5
]
40.97 ms
(14.23%)
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:
[
  485
]
40.22 ms
(13.97%)
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:
[
  5
]

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\Account 16
App\Entity\AccessToken 1
App\Entity\Property 1
App\Entity\Team 1
App\Entity\Company 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.