https://sys.nenocourier.co.ke/fos/all/expenses-list Return to referer URL

Query Metrics

4 Database Queries
4 Different statements
8.43 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.17 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:
[
  102
]
2 1.95 ms
SELECT t0.id AS id_1, t0.station_name AS station_name_2, t0.station_address AS station_address_3, t0.phone_numbers AS phone_numbers_4, t0.created_at AS created_at_5, t0.operating_hrs AS operating_hrs_6, t0.is_mobile AS is_mobile_7, t0.organization_id AS organization_id_8, t0.created_by AS created_by_9 FROM station t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  32
]
3 2.38 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 = ? AND t0.is_closed = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  102
  0
]
4 1.92 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.expense_accrued AS expense_accrued_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.is_cancelled AS is_cancelled_6, t0.station_id AS station_id_7, t0.daily_account_id AS daily_account_id_8, t0.expense_type_id AS expense_type_id_9, t0.created_by AS created_by_10 FROM station_expense t0 WHERE t0.station_id = ? AND t0.daily_account_id = ?
Parameters:
[
  32
  48662
]

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\Station No errors.
App\Entity\Organization No errors.
App\Entity\DailyAccount No errors.
App\Entity\StationDailyAccount No errors.
App\Entity\StationExpense No errors.
App\Entity\ExpenseType No errors.