https://staging.troskovi.com/apiV2/residents/flats/186501/problems/?limit=7&page=1&status=0

Query Metrics

4 Database Queries
4 Different statements
10.86 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
9.34 ms
(85.94%)
1
"COMMIT"
Parameters:
[]
0.71 ms
(6.49%)
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:
[
  186501
]
0.57 ms
(5.26%)
1
INSERT INTO action_log (method, action, controller_action, body, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "GET"
  "/apiV2/residents/flats/186501/problems/?limit=7&page=1&status=0"
  "A"
  null
  "2025-03-14 20:52:07"
  "2025-03-14 20:52:07"
  null
]
0.25 ms
(2.30%)
1
"START TRANSACTION"
Parameters:
[]

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.

Entities Mapping

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