https://sys.nenocourier.co.ke/json/daily_accounts Return to referer URL

Query Metrics

3 Database Queries
3 Different statements
26.10 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.14 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 9.42 ms
select a.id,a.account_date, a.station_id, d.station_name, sum(c.amount) as amount, count(c.id) as transactions, 
                        (SELECT sum(inner_a.amount) FROM station_expense inner_a 
                                    JOIN daily_account inner_b ON inner_b.id = inner_a.daily_account_id 
                                    JOIN station_daily_account inner_c ON inner_c.id = inner_b.station_daily_account 
                                                    WHERE inner_c.id =a.id ) as expenses 
                             FROM station_daily_account a 
                                    JOIN daily_account b ON b.station_daily_account = a.id 
                                    JOIN transaction c ON c.daily_account_id = b.id 
                                    JOIN station d ON a.station_id = d.id
                                    
                                     WHERE DATE(a.account_date) >= CAST('2026-08-01' AS DATE) AND DATE(a.account_date) <= CAST('2026-08-07' AS DATE)  
                             GROUP BY a.id ORDER BY a.id DESC LIMIT 0, 20
Parameters:
[]
3 15.54 ms
SELECT count(a.id) total_accounts from station_daily_account a  WHERE DATE(a.account_date) >= CAST('2026-08-01' AS DATE) AND DATE(a.account_date) <= CAST('2026-08-07' AS DATE)
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\User No errors.
App\Entity\Person No errors.
App\Entity\DailyAccount No errors.