Query Metrics
13
Database Queries
11
Different statements
319.07 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
286.38 ms (89.75%) |
1 |
SELECT m0_.id AS id_0, m0_.transaction_id AS transaction_id_1, m0_.transaction_type AS transaction_type_2, m0_.transaction_time AS transaction_time_3, m0_.transaction_amount AS transaction_amount_4, m0_.ref_number AS ref_number_5, m0_.short_code AS short_code_6, m0_.balance AS balance_7, m0_.msisdn AS msisdn_8, m0_.first_name AS first_name_9, m0_.middle_name AS middle_name_10, m0_.last_name AS last_name_11, m0_.created_at AS created_at_12, m0_.is_used AS is_used_13 FROM mpesa m0_ WHERE m0_.is_used = 0 AND m0_.short_code = 4022961
Parameters:
[] |
14.36 ms (4.50%) |
2 |
"COMMIT"
Parameters:
[] |
4.00 ms (1.25%) |
1 |
INSERT INTO mpesa_transaction (created_at, mpesa_id, transaction_id, created_by) VALUES (?, ?, ?, ?)
Parameters:
[ "2025-03-18 12:20:35" 183440 1059622 69 ] |
3.10 ms (0.97%) |
1 |
UPDATE transaction SET cash_amount = ?, mpesa_amount = ?, is_complete = ?, is_paid = ?, paid_by = ?, payment_method = ? WHERE id = ?
Parameters:
[ 0 200.0 1 1 "OTHER" "MPESA" 1059622 ] |
2.25 ms (0.70%) |
1 |
SELECT t0.id AS id_1, t0.paybill AS paybill_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.token_updated_at AS token_updated_at_7, t0.auth_type AS auth_type_8, t0.short_code_type AS short_code_type_9, t0.station AS station_10 FROM mpesa_auth t0 WHERE t0.station = ? AND t0.auth_type = ? LIMIT 1
Parameters:
[ 1 "PROD" ] |
2.01 ms (0.63%) |
1 |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.cash_amount AS cash_amount_3, t0.mpesa_amount AS mpesa_amount_4, t0.tax_percentage AS tax_percentage_5, t0.tax_amount AS tax_amount_6, t0.gross_amount AS gross_amount_7, t0.station_expenses AS station_expenses_8, t0.station_balance AS station_balance_9, t0.expenses AS expenses_10, t0.balance AS balance_11, t0.created_at AS created_at_12, t0.is_cancelled AS is_cancelled_13, t0.is_complete AS is_complete_14, t0.is_paid AS is_paid_15, t0.paid_by AS paid_by_16, t0.mpesa_payment_phone AS mpesa_payment_phone_17, t0.payment_method AS payment_method_18, t0.pin_number AS pin_number_19, t0.cu_invoice_number AS cu_invoice_number_20, t0.cu_invoice_number_credit AS cu_invoice_number_credit_21, t0.cu_serial_number AS cu_serial_number_22, t0.is_final AS is_final_23, t0.way_bill_id AS way_bill_id_24, t0.created_by AS created_by_25, t0.organization_id AS organization_id_26, t0.daily_account_id AS daily_account_id_27 FROM transaction t0 WHERE t0.way_bill_id = ? LIMIT 1
Parameters:
[
"1059663"
]
|
1.74 ms (0.54%) |
2 |
"START TRANSACTION"
Parameters:
[] |
1.67 ms (0.52%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.created_at AS created_at_4, t0.roles AS roles_5, t0.email AS email_6, t0.person_id AS person_id_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
69
]
|
1.34 ms (0.42%) |
1 |
SELECT m0_.id AS id_0, m0_.transaction_id AS transaction_id_1, m0_.transaction_type AS transaction_type_2, m0_.transaction_time AS transaction_time_3, m0_.transaction_amount AS transaction_amount_4, m0_.ref_number AS ref_number_5, m0_.short_code AS short_code_6, m0_.balance AS balance_7, m0_.msisdn AS msisdn_8, m0_.first_name AS first_name_9, m0_.middle_name AS middle_name_10, m0_.last_name AS last_name_11, m0_.created_at AS created_at_12, m0_.is_used AS is_used_13 FROM mpesa m0_ WHERE m0_.is_used = 0 AND m0_.short_code = 4022961 AND m0_.id IN (?)
Parameters:
[
"183440"
]
|
1.28 ms (0.40%) |
1 |
SELECT t0.id AS id_1, t0.transaction_id AS transaction_id_2, t0.transaction_type AS transaction_type_3, t0.transaction_time AS transaction_time_4, t0.transaction_amount AS transaction_amount_5, t0.ref_number AS ref_number_6, t0.short_code AS short_code_7, t0.balance AS balance_8, t0.msisdn AS msisdn_9, t0.first_name AS first_name_10, t0.middle_name AS middle_name_11, t0.last_name AS last_name_12, t0.created_at AS created_at_13, t0.is_used AS is_used_14 FROM mpesa t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
183440
]
|
0.94 ms (0.30%) |
1 |
UPDATE mpesa SET is_used = ? WHERE id = ?
Parameters:
[ 1 183440 ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_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\Person | No errors. |
App\Entity\Transaction | No errors. |
App\Entity\WayBill |
|
App\Entity\Organization | No errors. |
App\Entity\DailyAccount | No errors. |
App\Entity\TransactionExpense | No errors. |
App\Entity\MpesaAuth | No errors. |
App\Entity\Station | No errors. |
App\Entity\Mpesa | No errors. |
App\Entity\MpesaTransaction | No errors. |