GET https://staging.troskovi.com/apiV2/residents/flats/211535/problems/0?status=0

Response
200 OK
Browse referrer URL
IP
172.68.152.176
Profiled on
Token
159b6b

Query Metrics

7 Database Queries
7 Different statements
12.15 ms Query time
0 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
4.30 ms
(35.41%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.88 ms
(15.49%) 		1 
SELECT t0_.created_at AS created_at_0, t0_.status AS status_1, t0_.description AS description_2, t1_.name AS name_3, t0_.comment AS comment_4, t0_.scope AS scope_5 FROM task t0_ LEFT JOIN task_types t1_ ON t0_.task_type_id = t1_.id WHERE t0_.building_id = ? AND t0_.status = ? AND t0_.scope = 0 AND t0_.display_flat_id <> ? ORDER BY t0_.id DESC LIMIT 10
Parameters: 
[
  9079
  0
  "13"
]
View formatted query    View runnable query    Explain query
1.65 ms
(13.58%) 		1 
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
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:26:\"App\\Message\\StoreActionLog\":5:{s:34:\"\0App\\Message\\StoreActionLog\0userId\";N;s:34:\"\0App\\Message\\StoreActionLog\0method\";s:3:\"GET\";s:34:\"\0App\\Message\\StoreActionLog\0action\";s:49:\"/apiV2/residents/flats/211535/problems/0?status=0\";s:44:\"\0App\\Message\\StoreActionLog\0controllerAction\";s:83:\"App\\Controller\\ApiV2\\Residents\\ProblemController::getResidentsFlatProblemsWithScope\";s:32:\"\0App\\Message\\StoreActionLog\0body\";N;}}"
  "[]"
  "async-action-log"
  "2026-08-11 08:46:29"
  "2026-08-11 08:46:29"
]
View formatted query    View runnable query    Explain query
1.16 ms
(9.57%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.09 ms
(8.99%) 		1 
SELECT t0.id AS id_1, t0.display_flat_id AS display_flat_id_2, t0.size AS size_3, t0.owner_name AS owner_name_4, t0.owner_lastname AS owner_lastname_5, t0.owner_address AS owner_address_6, t0.owner_contact AS owner_contact_7, t0.owner_phone_number AS owner_phone_number_8, t0.rent AS rent_9, t0.debit AS debit_10, t0.previous_bill AS previous_bill_11, t0.type AS type_12, t0.subType AS subType_13, t0.old_debit AS old_debit_14, t0.comment AS comment_15, t0.members AS members_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_name AS company_name_19, t0.mat_id AS mat_id_20, t0.pib AS pib_21, t0.owner_email AS owner_email_22, t0.email_can_be_used AS email_can_be_used_23, t0.company_place AS company_place_24, t0.occupant AS occupant_25, t0.occupantEmail AS occupantEmail_26, t0.archived AS archived_27, t0.archived_at AS archived_at_28, t0.bank_account AS bank_account_29, t0.createdBy AS createdBy_30, t0.eInvoice AS eInvoice_31, t0.jbkjs AS jbkjs_32, t0.contract_number AS contract_number_33, t0.order_number AS order_number_34, t0.object_code AS object_code_35, t0.print_bill AS print_bill_36, t0.old_debit_date AS old_debit_date_37, t0.user_id AS user_id_38, t0.building_id AS building_id_39, t0.current_flat AS current_flat_40, t0.resident_id AS resident_id_41 FROM flat t0 WHERE t0.id = ?
Parameters: 
[
  211535
]
View formatted query    View runnable query    Explain query
1.05 ms
(8.65%) 		1 
SELECT COUNT(t0_.id) AS sclr_0 FROM task t0_ WHERE t0_.building_id = ? AND t0_.status = ? AND t0_.scope = 0 AND t0_.display_flat_id <> ?
Parameters: 
[
  9079
  0
  "13"
]
View formatted query    View runnable query    Explain query
1.01 ms
(8.31%) 		1 
SELECT t0.id AS id_1, t0.email AS email_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_code AS reset_password_code_7, t0.has_accepted_terms AS has_accepted_terms_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.disabled AS disabled_11 FROM residents t0 WHERE t0.email = ? LIMIT 1
Parameters: 
[
  "[email protected]"
]
View formatted query    View runnable query    Explain query

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\Resident 1
App\Entity\Flat 1
App\Entity\User 1
App\Entity\Building 1

Entities Mapping

Class Mapping errors
App\Entity\Resident No errors.
App\Entity\Flat No errors.
App\Entity\User No errors.
App\Entity\Building No errors.
App\Entity\FlatWarning No errors.
App\Entity\PollOption No errors.
App\Entity\Task No errors.
App\Entity\TaskType No errors.