Query Metrics
4
Database Queries
4
Different statements
10.86 ms
Query time
0
Invalid entities
Grouped Statements
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. |