GET https://staging.troskovi.com/apiV2/residents/flats/211535/reports/

Response
200 OK
Browse referrer URL
IP
172.68.152.176
Profiled on
Token
7aabff

Query Metrics

6 Database Queries
6 Different statements
31.46 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.88 ms 
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
2 0.38 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 0.83 ms 
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:38:\"/apiV2/residents/flats/211535/reports/\";s:44:\"\0App\\Message\\StoreActionLog\0controllerAction\";s:71:\"App\\Controller\\ApiV2\\Residents\\ReportController::getAllPublishedReports\";s:32:\"\0App\\Message\\StoreActionLog\0body\";N;}}"
  "[]"
  "async-action-log"
  "2026-08-11 09:27:16"
  "2026-08-11 09:27:16"
]
View formatted query    View runnable query    Explain query
4 27.36 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 1.01 ms 
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
6 1.00 ms 
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.title AS title_3, r0_.meeting_date AS meeting_date_4, r0_.comment AS comment_5, r0_.time AS time_6, r0_.meeting_end AS meeting_end_7, r0_.written_by AS written_by_8, r0_.report_number AS report_number_9, r0_.company_user AS company_user_10, r0_.owner_number AS owner_number_11, r0_.owners_with_vote AS owners_with_vote_12, r0_.owners_without_vote AS owners_without_vote_13, r0_.numbers_of_owners AS numbers_of_owners_14, r0_.numbers_of_owners_without_vote AS numbers_of_owners_without_vote_15, r0_.publish AS publish_16, r0_.status AS status_17 FROM report r0_ WHERE r0_.building_id = ? AND r0_.publish = ? ORDER BY r0_.id DESC
Parameters: 
[
  9079
  1
]
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\Report No errors.