https://payments.neemaopticians.co.ke/web/mpesa/manual/new

Query Metrics

3 Database Queries
3 Different statements
5.36 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

mssql connection

Time Count Info
2.19 ms
(40.81%)
1
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.is_active AS is_active_6, t0.branch_id AS branch_id_7, t0.system_user_id AS system_user_id_8 FROM [neema].[user] t0 WHERE t0.id = ?
Parameters:
[
  20
]
1.71 ms
(31.87%)
1
SELECT t0.id AS id_1, t0.staff_name AS staff_name_2, t0.staff_code AS staff_code_3, t0.phone AS phone_4, t0.branch_code AS branch_code_5, t0.id_number AS id_number_6, t0.created_at AS created_at_7, t0.sign_up_code AS sign_up_code_8 FROM [neema].[system_user] t0 WHERE t0.id = ?
Parameters:
[
  29
]
1.46 ms
(27.32%)
1
SELECT b0_.id AS id_0, b0_.branch_name AS branch_name_1, b0_.branch_code AS branch_code_2, b0_.email AS email_3, b0_.contact_person AS contact_person_4, b0_.phone AS phone_5, b0_.active AS active_6, b0_.created_at AS created_at_7, b0_.location AS location_8 FROM neema.branch b0_
Parameters:
[]

Database Connections

Name Service
mssql doctrine.dbal.mssql_connection
other_db doctrine.dbal.other_db_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\Branch No errors.
App\Entity\SystemUser No errors.
App\Entity\MpesaTransaction
  • The mappings App\Entity\MpesaTransaction#createdBy and App\Entity\MpesaManual#mpesaTransaction are inconsistent with each other.