Query Metrics
6
Database Queries
5
Different statements
399.51 ms
Query time
0
Invalid entities
29
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 35.81 ms |
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.eyJpYXQiOjE3NzQwNDUyOTEsImV4cCI6MTc3NTM0MTI5MSwicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJ0b2J5LnplbmdAY296eXN0YXkuY29tIn0.ucXl9r21B1qwHZnoMFC105WGhvf7zL0-LJMYOD4-UimcIA6w6Z2Ka38sQeXU3SCClfZa6URiLmBqagULRKvJGMjf5rHIgM2FEW-Ijn8qPib_IlHcTuni4CPemccKyf7W9YY4oXNHTvoWylnYtUhw9TeHZl1C4Cxxh-TSlvtQCXXGIgRduNXLyekJxaruLYw-jg0dqtzLOWZhEYo0mpEd6v3d7CfUaRhDls4rzFUl7NccHlssedzfJpqjxxNsqgFjMqPprnenGAGF_Sf2cKPFT6LGE9fg5_sv8-s8wWBA5E4kQSg4lQLwLOKYi8GUSXN7YQ-sAohN-vKq2uIqmnHvqg"
]
|
| 2 | 35.39 ms |
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:
[
5
]
|
| 3 | 33.90 ms |
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:
[
5
]
|
| 4 | 34.65 ms |
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:
[
5
]
|
| 5 | 197.59 ms |
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_.latitude AS latitude_23, p0_.longitude AS longitude_24, p0_.has_living_room AS has_living_room_25, p0_.has_kitchen AS has_kitchen_26, p0_.has_garbage_bin AS has_garbage_bin_27, p0_.created_at AS created_at_28 FROM property p0_ LEFT JOIN channel_listings c1_ ON (p0_.id = c1_.listing_id) WHERE c1_.status = ? AND p0_.team_id = ? ORDER BY p0_.id ASC
Parameters:
[ "LISTED" 17 ] |
| 6 | 62.18 ms |
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 FROM "reservation" r0_ WHERE r0_.listing_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND r0_.check_in_date < ? AND r0_.check_out_date > ? AND r0_.status_code = ? ORDER BY r0_.check_in_date ASC
Parameters:
[ 221 239 320 343 536 586 592 626 646 647 667 674 675 700 872 873 876 879 882 883 889 900 946 968 969 970 971 986 988 992 994 999 1043 1044 1049 1056 1088 1094 1110 1119 1173 1179 1212 1218 1223 1224 1236 1245 1246 1247 1248 1249 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1297 1298 1299 1301 1302 1303 1304 1350 1396 1397 1430 1491 1492 1560 1562 1563 1564 1565 1575 1708 1709 1730 1736 1743 1752 1753 1760 1763 1868 1869 1870 1871 1872 1873 1874 1875 1891 1896 1897 1908 1909 1956 1957 2043 2047 2123 2124 2125 2126 2132 2133 2134 2143 2148 2157 2176 2177 2178 2179 2180 2181 2195 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2227 2260 2261 2262 2263 2264 2265 2288 2289 2290 2291 2292 "2026-03-25 06:59:59" "2026-03-20 07:00:00" "CONFIRMED" ] |
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\Reservation | 24 |
| App\Entity\AccessToken | 1 |
| App\Entity\Account | 1 |
| App\Entity\Company | 1 |
| App\Entity\Team | 1 |
| App\Entity\AccountRole | 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\ChannelListings | No errors. |
| App\Entity\Reservation | No errors. |