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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
12058.91 ms
(99.95%)
1
SELECT COUNT(t.id) AS count_t                     
                    FROM transaction t 
                        JOIN daily_account d on d.id = t.daily_account_id
                        JOIN way_bill w ON w.id = t.way_bill_id
                        JOIN station ts ON ts.id = w.to_station_id
                        JOIN station fs ON fs.id = w.from_station_id
                    WHERE t.id > 0
Parameters:
[]
5.75 ms
(0.05%)
1
SELECT t.id,
                       t.amount,
                       d.account_date,
                       ts.station_name as to_station,
                       fs.station_name as from_station,
                       w.id as waybill,
                       t.expenses,
                       t.is_cancelled,
                       t.tax_amount,
                       t.balance,
                       t.pin_number,
                       w.percel_count,          
                       t.is_cancelled
                    FROM transaction t 
                        JOIN daily_account d on d.id = t.daily_account_id
                        JOIN way_bill w ON w.id = t.way_bill_id
                        JOIN station ts ON ts.id = w.to_station_id
                        JOIN station fs ON fs.id = w.from_station_id
                    WHERE t.id > 0  ORDER BY t.id DESC LIMIT 0, 20
Parameters:
[]
0.86 ms
(0.01%)
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\Transaction No errors.