Query Metrics
3
Database Queries
3
Different statements
8.09 ms
Query time
1
Invalid entities
Grouped Statements
mssql connection
| Time▼ | Count | Info |
|---|---|---|
|
4.31 ms (53.30%) |
1 |
INSERT INTO neema.mpesa_transaction_verification (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:
[ "Customer Merchant Payment" "UEC903SX63" "2026-05-12 13:39:08.000000" 4500.0 7256331 "" null 0.0 "" "254797252101" "Rachael" "Nanjala" "Wekesa" 0 "2026-05-12 10:39:10.616068" 0 0 null null null null null "196.201.212.69" 0 ] |
|
2.60 ms (32.12%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.18 ms (14.58%) |
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\MpesaTransactionVerification |
|
| App\Entity\MpesaManual | No errors. |