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

Query Metrics

4 Database Queries
4 Different statements
8.78 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

mssql connection

Time Count Info
3.39 ms
(38.61%)
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 t0 WHERE t0.transaction_id = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters:
[
  "UEF6N4B80F"
]
2.74 ms
(31.22%)
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
]
1.41 ms
(16.10%)
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:
[
  "UEF6N4B80F"
]
1.24 ms
(14.08%)
1
SELECT t0.id AS id_1, t0.staff_name AS staff_name_2, t0.staff_code AS staff_code_3, t0.phone AS phone_4, t0.branch_code AS branch_code_5, t0.id_number AS id_number_6, t0.created_at AS created_at_7, t0.sign_up_code AS sign_up_code_8 FROM [neema].[system_user] t0 WHERE t0.id = ?
Parameters:
[
  29
]

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\MpesaTransactionVerification
  • The mappings App\Entity\MpesaTransactionVerification#createdBy and App\Entity\MpesaManual#mpesaTransaction are inconsistent with each other.