| 1 |
0.90 ms
|
SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.last_connection_at AS last_connection_at_9, t0.last_activity_at AS last_activity_at_10, t0.utilisateur_role_id AS utilisateur_role_id_11 FROM utilisateur t0 WHERE t0.username = ? LIMIT 1
Parameters: [
"340000001"
]
SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.last_connection_at AS last_connection_at_9, t0.last_activity_at AS last_activity_at_10, t0.utilisateur_role_id AS utilisateur_role_id_11 FROM utilisateur t0 WHERE t0.username = '340000001' LIMIT 1;
|
| 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.code = ? LIMIT 1
Parameters: [
"TRN6AA00F56147E320260908133622"
]
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.code = 'TRN6AA00F56147E320260908133622' LIMIT 1;
|
| 4 |
0.98 ms
|
INSERT INTO payment_attempt (code, provider, external_order_id, pay_token, notif_token, payment_url, transaction_id, is_success, notified_at, notify_content, has_error, error_text, payload, created_at, updated_at, transfert_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
"PMN6AA00F567E8E320260908133622"
"ORANGE"
"MDX-C0201C4B-4DF939CA"
null
null
null
null
0
null
null
0
null
null
"2026-09-08 13:36:22"
"2026-09-08 13:36:22"
5
]
INSERT INTO payment_attempt (code, provider, external_order_id, pay_token, notif_token, payment_url, transaction_id, is_success, notified_at, notify_content, has_error, error_text, payload, created_at, updated_at, transfert_id) VALUES ('PMN6AA00F567E8E320260908133622', 'ORANGE', 'MDX-C0201C4B-4DF939CA', NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, '2026-09-08 13:36:22', '2026-09-08 13:36:22', 5);
|
| 7 |
0.97 ms
|
UPDATE payment_attempt SET pay_token = ?, notif_token = ?, payment_url = ?, payload = ?, updated_at = ? WHERE id = ?
Parameters: [
"v13mfoazal2nfjd0p0emnhem8psqpztpfwptbgwedvoauhqgdkwmkl1sxpkpsjfw"
"khloc5etefeouhkfild6qtc7kjub45vo"
"https://mpayment.orange-money.com/mg/mpayment/abstract/v13mfoazal2nfjd0p0emnhem8psqpztpfwptbgwedvoauhqgdkwmkl1sxpkpsjfw"
"{"request":{"merchant_key":"68d1eabe","currency":"MGA","order_id":"MDX-C0201C4B-4DF939CA","amount":500,"return_url":"https:\/\/api.madex.mg\/payment\/orange\/return?attempt=PMN6AA00F567E8E320260908133622&ref=MDX-C0201C4B&code=TRN6AA00F56147E320260908133622","cancel_url":"https:\/\/api.madex.mg\/payment\/orange\/cancel?attempt=PMN6AA00F567E8E320260908133622&ref=MDX-C0201C4B&code=TRN6AA00F56147E320260908133622","notif_url":"https:\/\/api.madex.mg\/api\/callback\/orange\/notify\/PMN6AA00F567E8E320260908133622","lang":"fr","reference":"ref MDX-C0201C4B-4DF939CA"},"response":{"status":201,"message":"OK","pay_token":"v13mfoazal2nfjd0p0emnhem8psqpztpfwptbgwedvoauhqgdkwmkl1sxpkpsjfw","payment_url":"https:\/\/mpayment.orange-money.com\/mg\/mpayment\/abstract\/v13mfoazal2nfjd0p0emnhem8psqpztpfwptbgwedvoauhqgdkwmkl1sxpkpsjfw","notif_token":"khloc5etefeouhkfild6qtc7kjub45vo"}}"
"2026-09-08 13:36:22"
5
]
UPDATE payment_attempt SET pay_token = 'v13mfoazal2nfjd0p0emnhem8psqpztpfwptbgwedvoauhqgdkwmkl1sxpkpsjfw', notif_token = 'khloc5etefeouhkfild6qtc7kjub45vo', payment_url = 'https://mpayment.orange-money.com/mg/mpayment/abstract/v13mfoazal2nfjd0p0emnhem8psqpztpfwptbgwedvoauhqgdkwmkl1sxpkpsjfw', payload = '{\"request\":{\"merchant_key\":\"68d1eabe\",\"currency\":\"MGA\",\"order_id\":\"MDX-C0201C4B-4DF939CA\",\"amount\":500,\"return_url\":\"https:\\/\\/api.madex.mg\\/payment\\/orange\\/return?attempt=PMN6AA00F567E8E320260908133622&ref=MDX-C0201C4B&code=TRN6AA00F56147E320260908133622\",\"cancel_url\":\"https:\\/\\/api.madex.mg\\/payment\\/orange\\/cancel?attempt=PMN6AA00F567E8E320260908133622&ref=MDX-C0201C4B&code=TRN6AA00F56147E320260908133622\",\"notif_url\":\"https:\\/\\/api.madex.mg\\/api\\/callback\\/orange\\/notify\\/PMN6AA00F567E8E320260908133622\",\"lang\":\"fr\",\"reference\":\"ref MDX-C0201C4B-4DF939CA\"},\"response\":{\"status\":201,\"message\":\"OK\",\"pay_token\":\"v13mfoazal2nfjd0p0emnhem8psqpztpfwptbgwedvoauhqgdkwmkl1sxpkpsjfw\",\"payment_url\":\"https:\\/\\/mpayment.orange-money.com\\/mg\\/mpayment\\/abstract\\/v13mfoazal2nfjd0p0emnhem8psqpztpfwptbgwedvoauhqgdkwmkl1sxpkpsjfw\",\"notif_token\":\"khloc5etefeouhkfild6qtc7kjub45vo\"}}', updated_at = '2026-09-08 13:36:22' WHERE id = 5;
|