https://sys.nenocourier.co.ke/payment/list Return to referer URL

Query Metrics

3 Database Queries
3 Different statements
240.23 ms Query time
0 Invalid entities
  • Queries
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Group similar statements

# Time Info
1 0.84 ms
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:
0 of 0
[ 115 ]
2 1.11 ms
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:
0 of 0
[ 1 "PROD" ]
3 238.28 ms
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_.created_at >= ? AND m0_.created_at <= ? AND m0_.is_used = 0 AND m0_.short_code = 4022961 ORDER BY m0_.id DESC LIMIT 100
Parameters:
0 of 0
[ "2025-03-26 00:00:00" "2025-03-26 23:59:59" ]