Query Metrics
2
Database Queries
2
Different statements
100.42 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.18 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.created_at AS created_at_4, t0.roles AS roles_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.person_id AS person_id_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
157
]
|
| 2 | 99.24 ms |
SELECT count(t.id) as transactions, sum(t.amount) as amount, (select sum(a.amount) from station_expense a JOIN daily_account d on a.daily_account_id = d.id where d.station_daily_account = a.id) as expenses FROM station_daily_account a JOIN daily_account da on a.id = da.station_daily_account JOIN transaction t on da.id = t.daily_account_id WHERE a.account_date = :account_date
Parameters:
[ "account_date" => "2025-10-27" ] |
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\User | No errors. |
| App\Entity\Person | No errors. |
| App\Entity\DailyAccount | No errors. |