https://sys.nenocourier.co.ke/

Query Metrics

2 Database Queries
2 Different statements
100.42 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
99.24 ms
(98.82%)
1
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"
]
1.18 ms
(1.18%)
1
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
]

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.