https://payments.neemaopticians.co.ke/web/mpesa/manual/new Return to referer URL

Query Metrics

8 Database Queries
8 Different statements
57.84 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

mssql connection

Time Count Info
19.01 ms
(32.86%)
1
"COMMIT"
Parameters:
[]
11.61 ms
(20.07%)
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
]
7.35 ms
(12.70%)
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_ WHERE b0_.id IN (?)
Parameters:
[
  "17"
]
7.03 ms
(12.15%)
1
INSERT INTO neema.mpesa_manual (created_at, mpesa_transaction_id, created_by_id, branch_id) VALUES (?, ?, ?, ?)
Parameters:
[
  "2026-06-11 12:21:44.547133"
  165009
  1
  17
]
6.50 ms
(11.24%)
1
INSERT INTO neema.mpesa_transaction (transaction_type, transaction_id, transaction_time, transaction_amount, short_code, bill_reference_number, invoice_number, account_balance, third_party_transaction_id, msisdn, first_name, middle_name, last_name, is_complete, created_at, is_used, is_seen, read_at, used_at, completed_at, seen_from_ip, mpesa_from_ip, completed_mpesa_from_ip, is_validated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "NA"
  "UFAAP7H8ZP"
  "2026-06-11 12:21:44.546988"
  500.0
  7397540
  ""
  null
  0.0
  null
  "254720685058"
  "LUCY"
  "WAITHIRA MUMBI"
  null
  1
  "2026-06-10 00:00:00.000000"
  0
  0
  null
  null
  null
  null
  null
  null
  0
]
3.27 ms
(5.65%)
1
SELECT t0.id AS id_1, t0.till_number AS till_number_2, t0.consumer_key AS consumer_key_3, t0.consumer_secret AS consumer_secret_4, t0.pass_key AS pass_key_5, t0.token AS token_6, t0.pss AS pss_7, t0.token_updated_at AS token_updated_at_8, t0.auth_type AS auth_type_9, t0.branch AS branch_10 FROM neema.mpesa_auth t0 WHERE t0.branch = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters:
[
  17
]
1.70 ms
(2.93%)
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 = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters:
[
  1
]
1.39 ms
(2.40%)
1
"START TRANSACTION"
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.
App\Entity\MpesaManual No errors.
App\Entity\MpesaAuth No errors.