Query Metrics
8
Database Queries
8
Different statements
57.84 ms
Query time
1
Invalid entities
Grouped Statements
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 |
|
| App\Entity\MpesaManual | No errors. |
| App\Entity\MpesaAuth | No errors. |