https://sys.nenocourier.co.ke/fos/my/transactions/transaction-list Return to referer URL

Query Metrics

5 Database Queries
5 Different statements
11.92 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.39 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.person_id AS person_id_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
  149
]
2 2.25 ms
SELECT t0.id AS id_1, t0.drawer_cash AS drawer_cash_2, t0.account_date AS account_date_3, t0.is_closed AS is_closed_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.station_daily_account AS station_daily_account_7, t0.closed_by AS closed_by_8 FROM daily_account t0 WHERE t0.user_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  149
]
3 3.14 ms
SELECT b.id,c.account_date,a.expenses,a.created_at,b.percel_count,a.payment_method,d.station_name,b.sender_name,b.sender_phone_number,b.receiver_name,b.receiver_phone_number,a.amount, a.is_cancelled  FROM transaction a 
                            JOIN way_bill b on a.way_bill_id = b.id
                            JOIN daily_account c ON c.id = a.daily_account_id
                            JOIN station d ON d.id = b.to_station_id
                  WHERE  b.from_station_id = 1 AND a.daily_account_id = 36882 AND a.created_by = 149  ORDER BY b.id DESC LIMIT  0,20
Parameters:
[]
4 2.76 ms
SELECT  count(*) as total  FROM transaction a 
                            JOIN way_bill b on a.way_bill_id = b.id
                            JOIN daily_account c ON c.id = a.daily_account_id
                            JOIN station d ON d.id = b.to_station_id
                  WHERE  b.from_station_id = 1 AND a.daily_account_id = 36882 AND a.created_by = 149
Parameters:
[]
5 2.39 ms
SELECT  SUM(b.percel_count) as parcel_count, SUM(a.station_expenses) as station_expenses,SUM(a.tax_amount) as tax_amount, SUM(a.amount) as amount, SUM(a.expenses) as expenses, SUM(a.balance) as balance FROM transaction a 
                            JOIN way_bill b on a.way_bill_id = b.id
                            JOIN daily_account c ON c.id = a.daily_account_id
                            JOIN station d ON d.id = b.to_station_id                    
                  WHERE  b.from_station_id = 1 AND a.is_cancelled = false AND a.daily_account_id = 36882 AND a.created_by = 149
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.
App\Entity\StationDailyAccount No errors.
App\Entity\StationExpense No errors.
App\Entity\Transaction No errors.