Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

6.11 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.93 ms
(15.24%)

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"
]

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 = 'PMN6AA00F57A9CB720260908133623' 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)

0.90 ms
(14.74%)

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
]

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

#	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.84 ms
(13.80%)

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
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  payment_attempt
SET
  transaction_id = ?,
  is_success = ?,
  notified_at = ?,
  notify_content = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE payment_attempt SET transaction_id = 'MP260908.1637.A64239', is_success = 1, notified_at = '2026-09-08 13:37:20', notify_content = '{\"status\":\"SUCCESS\",\"notif_token\":\"xtawbx0kn9pjsjyfeghit7urovzifk1d\",\"txnid\":\"MP260908.1637.A64239\"}', updated_at = '2026-09-08 13:37:20' WHERE id = 6;

#	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.76 ms
(12.48%)

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
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  transfert
SET
  status = ?,
  paid_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE transfert SET status = 'PAID', paid_at = '2026-09-08 13:37:20', updated_at = '2026-09-08 13:37:20' WHERE id = 6;

#	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.72 ms
(11.73%)

"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.67 ms
(10.94%)

"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.64 ms
(10.55%)

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.64 ms
(10.52%)

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/PMN6AA00F57A9CB720260908133623

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping