https://sys.nenocourier.co.ke/sms/callback

Query Metrics

4 Database Queries
4 Different statements
1979.37 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1973.01 ms
(99.68%)
1
SELECT t0.id AS id_1, t0.status AS status_2, t0.amount AS amount_3, t0.sms AS sms_4, t0.recepient AS recepient_5, t0.created_at AS created_at_6, t0.status_code AS status_code_7, t0.manually_sent AS manually_sent_8, t0.action AS action_9, t0.message_id AS message_id_10, t0.transaction_id AS transaction_id_11, t0.organization_id AS organization_id_12, t0.created_by AS created_by_13 FROM sms t0 WHERE t0.message_id = ? LIMIT 1
Parameters:
[
  "ATXid_00b22962a5721b0eb3b5ee0db3c62d9c"
]
3.95 ms
(0.20%)
1
"COMMIT"
Parameters:
[]
1.96 ms
(0.10%)
1
UPDATE sms SET status = ? WHERE id = ?
Parameters:
[
  "Failed"
  1205448
]
0.46 ms
(0.02%)
1
"START TRANSACTION"
Parameters:
[]

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\Sms No errors.
App\Entity\Transaction No errors.
App\Entity\Organization No errors.
App\Entity\User No errors.