Query Metrics
4
Database Queries
4
Different statements
5.11 ms
Query time
2
Invalid entities
Grouped Statements
mssql connection
Time▼ | Count | Info |
---|---|---|
2.01 ms (39.39%) |
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:
[ "Customer Merchant Payment" "TEA37N3KCN" "2025-05-10 18:03:18.000000" 500.0 7397542 "" null 16916.3 null "254723751767" "DANIEL" "WANJOHI" "" 1 "2025-05-10 15:03:20.353113" 0 0 null null null null null "196.201.212.138" 1 ] |
1.32 ms (25.75%) |
1 |
SELECT t0.id AS id_1, t0.transaction_type AS transaction_type_2, t0.transaction_id AS transaction_id_3, t0.transaction_time AS transaction_time_4, t0.transaction_amount AS transaction_amount_5, t0.short_code AS short_code_6, t0.bill_reference_number AS bill_reference_number_7, t0.invoice_number AS invoice_number_8, t0.account_balance AS account_balance_9, t0.third_party_transaction_id AS third_party_transaction_id_10, t0.msisdn AS msisdn_11, t0.first_name AS first_name_12, t0.middle_name AS middle_name_13, t0.last_name AS last_name_14, t0.is_complete AS is_complete_15, t0.created_at AS created_at_16, t0.is_used AS is_used_17, t0.is_seen AS is_seen_18, t0.read_at AS read_at_19, t0.used_at AS used_at_20, t0.completed_at AS completed_at_21, t0.seen_from_ip AS seen_from_ip_22, t0.mpesa_from_ip AS mpesa_from_ip_23, t0.completed_mpesa_from_ip AS completed_mpesa_from_ip_24, t0.is_validated AS is_validated_25 FROM neema.mpesa_transaction_verification t0 WHERE t0.transaction_id = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters:
[
"TEA37N3KCN"
]
|
1.28 ms (24.97%) |
1 |
"COMMIT"
Parameters:
[] |
0.50 ms (9.88%) |
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. |
App\Entity\MpesaTransaction |
|