POST https://api.madex.mg/api/callback/orange/notify/PMN6AA00F57A9CB720260908133623

Query Metrics

8 Database Queries
8 Different statements
6.11 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 0.93 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.provider AS provider_3, t0.external_order_id AS external_order_id_4, t0.pay_token AS pay_token_5, t0.notif_token AS notif_token_6, t0.payment_url AS payment_url_7, t0.transaction_id AS transaction_id_8, t0.is_success AS is_success_9, t0.notified_at AS notified_at_10, t0.notify_content AS notify_content_11, t0.has_error AS has_error_12, t0.error_text AS error_text_13, t0.payload AS payload_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.transfert_id AS transfert_id_17 FROM payment_attempt t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "PMN6AA00F57A9CB720260908133623"
]
2 0.90 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.montant AS montant_4, t0.frais AS frais_5, t0.destinataire_phone AS destinataire_phone_6, t0.note AS note_7, t0.status AS status_8, t0.paid_at AS paid_at_9, t0.sent_at AS sent_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.emetteur_id AS emetteur_id_13 FROM transfert t0 WHERE t0.id = ?
Parameters:
[
  6
]
3 0.67 ms
"START TRANSACTION"
Parameters:
[]
4 0.64 ms
SAVEPOINT DOCTRINE_2
Parameters:
[]
5 0.84 ms
UPDATE payment_attempt SET transaction_id = ?, is_success = ?, notified_at = ?, notify_content = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "MP260908.1637.A64239"
  1
  "2026-09-08 13:37:20"
  "{"status":"SUCCESS","notif_token":"xtawbx0kn9pjsjyfeghit7urovzifk1d","txnid":"MP260908.1637.A64239"}"
  "2026-09-08 13:37:20"
  6
]
6 0.76 ms
UPDATE transfert SET status = ?, paid_at = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "PAID"
  "2026-09-08 13:37:20"
  "2026-09-08 13:37:20"
  6
]
7 0.64 ms
RELEASE SAVEPOINT DOCTRINE_2
Parameters:
[]
8 0.72 ms
"COMMIT"
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\PaymentAttempt 1
App\Entity\Transfert 1
App\Entity\Utilisateur 1

Entities Mapping