Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.50 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.12 ms
(44.76%)

INSERT INTO otp_request (code, username, otp_code, token, created_at, expires_at, is_verified, attempt) VALUES (?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "TPR6AA00F2BC450820260908133539"
  "340000001"
  "123456"
  "d5afdbb17552aed24d3efcdefb568936c7997f52c722dc8c2940586280361353"
  "2026-09-08 13:35:39"
  "2026-09-08 13:45:39"
  0
  0
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO otp_request (
  code, username, otp_code, token, created_at,
  expires_at, is_verified, attempt
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO otp_request (code, username, otp_code, token, created_at, expires_at, is_verified, attempt) VALUES ('TPR6AA00F2BC450820260908133539', '340000001', '123456', 'd5afdbb17552aed24d3efcdefb568936c7997f52c722dc8c2940586280361353', '2026-09-08 13:35:39', '2026-09-08 13:45:39', 0, 0);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 255)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1144)
4	Doctrine\ORM\UnitOfWork->commit (line 426)
5	Doctrine\ORM\EntityManager->flush (line 270)
6	App\Service\Notification\OtpRequestServices->send (line 106)
7	App\Controller\Api\OtpRequestController->send (line 31)
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.70 ms
(27.82%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 458)
2	Doctrine\ORM\EntityManager->flush (line 270)
3	App\Service\Notification\OtpRequestServices->send (line 106)
4	App\Controller\Api\OtpRequestController->send (line 31)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.69 ms
(27.42%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 405)
2	Doctrine\ORM\EntityManager->flush (line 270)
3	App\Service\Notification\OtpRequestServices->send (line 106)
4	App\Controller\Api\OtpRequestController->send (line 31)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	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\OtpRequest	1

Entities Mapping

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\OtpRequest	No errors.

Symfony Profiler

POST https://api.madex.mg/api/v1/otp/request/send

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping