GET https://staging.troskovi.com/apiV2/residents/flats/211535/bills/?limit=10&page=1

Response
200 OK
Browse referrer URL
IP
172.68.152.176
Profiled on
Token
f2c5d3

Query Metrics

7 Database Queries
7 Different statements
21.27 ms Query time
0 Invalid entities
17 Managed entities

Queries

Group similar statements

#▲ Time Info
1 3.75 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.36 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 0.85 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:52:\"/apiV2/residents/flats/211535/bills/?page=1&limit=10\";s:44:\"\0App\\Message\\StoreActionLog\0controllerAction\";s:52:\"App\\Controller\\ApiV2\\Residents\\BillController::index\";s:32:\"\0App\\Message\\StoreActionLog\0body\";N;}}"
  "[]"
  "async-action-log"
  "2026-08-11 06:53:29"
  "2026-08-11 06:53:29"
]
View formatted query    View runnable query    Explain query
4 6.48 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 2.55 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 3.92 ms 
SELECT m0_.id AS id_0, m0_.amount AS amount_1, m0_.month AS month_2, m0_.created_at AS created_at_3, m0_.update_at AS update_at_4, m0_.log_creation_date AS log_creation_date_5, m0_.debit AS debit_6, m0_.comment AS comment_7, m0_.monthly_bill AS monthly_bill_8, m0_.start_money_data AS start_money_data_9, m0_.left_money_data AS left_money_data_10, m0_.status AS status_11, m0_.over_money AS over_money_12, m0_.createdBy AS createdBy_13, m0_.month_paid AS month_paid_14, m0_.bankFileId AS bankFileId_15, m0_.publish_bill AS publish_bill_16, m0_.user_id AS user_id_17, m0_.building_id AS building_id_18, m0_.flat_id AS flat_id_19, m0_.processed_flat_id AS processed_flat_id_20 FROM money_log m0_ WHERE m0_.flat_id = ? AND m0_.publish_bill = 1 AND m0_.debit NOT IN (?, ?)
Parameters: 
[
  211535
  5
  6
]
View formatted query    View runnable query    Explain query
7 3.36 ms 
SELECT count(m0_.id) AS sclr_0 FROM money_log m0_ WHERE m0_.flat_id = ? AND m0_.publish_bill = 1 AND m0_.debit NOT IN (?, ?)
Parameters: 
[
  211535
  5
  6
]
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\MoneyLog 13
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\MoneyLog No errors.
App\Entity\ProcessedFlats No errors.