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

Query Metrics

4 Database Queries
4 Different statements
6.61 ms Query time
0 Invalid entities
  • Grouped Statements
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Show all queries

Time Count Info
4.97 ms
(75.07%)
1
"COMMIT"
Parameters:
[]
0.82 ms
(12.44%)
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:
0 of 0
[ 186501 ]
0.57 ms
(8.66%)
1
INSERT INTO action_log (method, action, controller_action, body, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
0 of 0
[ "GET" "/apiV2/residents/flats/186501/problems/?limit=7&page=1&status=0" "A" null "2025-03-14 20:55:40" "2025-03-14 20:55:40" null ]
0.25 ms
(3.83%)
1
"START TRANSACTION"
Parameters:
[]