Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

5.54 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.11 ms
(20.06%)

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:

[
  "PMN6AA03E79492E720260908165729"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 'PMN6AA03E79492E720260908165729' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Repository\PaymentAttemptRepository->findOneByCode (line 39)
5	App\Service\Transfert\TransfertServices->processPayinNotification (line 170)
6	App\Controller\Api\PaymentCallbackController->orangeNotify (line 32)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

1.01 ms
(18.14%)

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:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	App\Entity\Transfert::getStatus (line 174)
5	App\Service\Transfert\TransfertServices->processPayinNotification (line 188)
6	App\Controller\Api\PaymentCallbackController->orangeNotify (line 32)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.78 ms
(14.12%)

UPDATE payment_attempt SET notified_at = ?, notify_content = ?, has_error = ?, error_text = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "2026-09-08 17:09:04"
  "{"status":"FAILED","notif_token":"1wabdkhmejrntdn8ttraesqb5hnivjpy","txnid":""}"
  1
  "Paiement échoué via Orange Money"
  "2026-09-08 17:09:04"
  9
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  payment_attempt
SET
  notified_at = ?,
  notify_content = ?,
  has_error = ?,
  error_text = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE payment_attempt SET notified_at = '2026-09-08 17:09:04', notify_content = '{\"status\":\"FAILED\",\"notif_token\":\"1wabdkhmejrntdn8ttraesqb5hnivjpy\",\"txnid\":\"\"}', has_error = 1, error_text = 'Paiement échoué via Orange Money', updated_at = '2026-09-08 17:09:04' WHERE id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 496)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 380)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1228)
4	Doctrine\ORM\UnitOfWork->commit (line 433)
5	Doctrine\ORM\EntityManager->flush (line 270)
6	Doctrine\ORM\EntityManager->wrapInTransaction (line 191)
7	App\Service\Transfert\TransfertServices->processPayinNotification (line 197)
8	App\Controller\Api\PaymentCallbackController->orangeNotify (line 32)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

0.71 ms
(12.78%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\EntityManager->wrapInTransaction (line 192)
2	App\Service\Transfert\TransfertServices->processPayinNotification (line 197)
3	App\Controller\Api\PaymentCallbackController->orangeNotify (line 32)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
8	require_once (line 32)
9	require_once (line 5)

0.66 ms
(11.90%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\EntityManager->wrapInTransaction (line 184)
2	App\Service\Transfert\TransfertServices->processPayinNotification (line 197)
3	App\Controller\Api\PaymentCallbackController->orangeNotify (line 32)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
8	require_once (line 32)
9	require_once (line 5)

0.65 ms
(11.66%)

SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->createSavepoint (line 1169)
2	Doctrine\DBAL\Connection->beginTransaction (line 1061)
3	Doctrine\ORM\UnitOfWork->commit (line 405)
4	Doctrine\ORM\EntityManager->flush (line 270)
5	Doctrine\ORM\EntityManager->wrapInTransaction (line 191)
6	App\Service\Transfert\TransfertServices->processPayinNotification (line 197)
7	App\Controller\Api\PaymentCallbackController->orangeNotify (line 32)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.63 ms
(11.35%)

RELEASE SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->releaseSavepoint (line 1188)
2	Doctrine\DBAL\Connection->commit (line 1086)
3	Doctrine\ORM\UnitOfWork->commit (line 458)
4	Doctrine\ORM\EntityManager->flush (line 270)
5	Doctrine\ORM\EntityManager->wrapInTransaction (line 191)
6	App\Service\Transfert\TransfertServices->processPayinNotification (line 197)
7	App\Controller\Api\PaymentCallbackController->orangeNotify (line 32)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

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

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\PaymentAttempt	No errors.
App\Entity\Transfert	No errors.
App\Entity\Utilisateur	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping