Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

6 Database Queries

6 Different statements

33.58 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

30.80 ms
(91.74%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1427)
2	Doctrine\DBAL\Connection->commit (line 476)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 29)
5	App\Repository\AbortRegistrationRepository->add (line 72)
6	App\Form\Handler\RegistrationHandler->registrationCheck (line 39)
7	App\Controller\RegistrationController->register (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.01 ms
(3.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_new_custom AS is_new_custom_3, t0.position AS position_4 FROM groupe t0 ORDER BY t0.position ASC, t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_new_custom AS is_new_custom_3,
  t0.position AS position_4
FROM
  groupe t0
ORDER BY
  t0.position ASC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_new_custom AS is_new_custom_3, t0.position AS position_4 FROM groupe t0 ORDER BY t0.position ASC, t0.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 36)
4	App\Form\Type\AgenceType->buildForm (line 102)
5	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
6	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
7	Symfony\Component\Form\FormFactory->createNamedBuilder (line 85)
8	Symfony\Component\Form\FormBuilder->create (line 212)
9	Symfony\Component\Form\FormBuilder->resolveChildren (line 165)
10	Symfony\Component\Form\FormBuilder->getForm (line 28)
11	Symfony\Component\Form\FormFactory->create (line 340)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 38)
13	App\Controller\RegistrationController->register (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.62 ms
(1.85%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM user_fonction t0 ORDER BY t0.position ASC, t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3
FROM
  user_fonction t0
ORDER BY
  t0.position ASC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM user_fonction t0 ORDER BY t0.position ASC, t0.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 41)
4	App\Form\Type\AgenceType->buildForm (line 102)
5	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
6	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
7	Symfony\Component\Form\FormFactory->createNamedBuilder (line 85)
8	Symfony\Component\Form\FormBuilder->create (line 212)
9	Symfony\Component\Form\FormBuilder->resolveChildren (line 165)
10	Symfony\Component\Form\FormBuilder->getForm (line 28)
11	Symfony\Component\Form\FormFactory->create (line 340)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 38)
13	App\Controller\RegistrationController->register (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.55 ms
(1.64%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3 FROM abort_registration t0 WHERE t0.ip = ? LIMIT 1

Parameters:

[
  "216.73.216.1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.created_at AS created_at_3
FROM
  abort_registration t0
WHERE
  t0.ip = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3 FROM abort_registration t0 WHERE t0.ip = '216.73.216.1' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 67)
4	App\Form\Handler\RegistrationHandler->registrationCheck (line 39)
5	App\Controller\RegistrationController->register (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.35 ms
(1.05%)

INSERT INTO abort_registration (ip, created_at) VALUES (?, ?)

Parameters:

[
  "216.73.216.1"
  "2026-03-10 12:50:05"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO abort_registration (ip, created_at)
VALUES
  (?, ?)

INSERT INTO abort_registration (ip, created_at) VALUES ('216.73.216.1', '2026-03-10 12:50:05');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 285)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1183)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 29)
7	App\Repository\AbortRegistrationRepository->add (line 72)
8	App\Form\Handler\RegistrationHandler->registrationCheck (line 39)
9	App\Controller\RegistrationController->register (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.23 ms
(0.69%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 428)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 29)
4	App\Repository\AbortRegistrationRepository->add (line 72)
5	App\Form\Handler\RegistrationHandler->registrationCheck (line 39)
6	App\Controller\RegistrationController->register (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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.

Entities Mapping

Class	Mapping errors
App\Entity\Groupe	No errors.
App\Entity\Enseigne	No errors.
App\Entity\Agence	No errors.
App\Entity\UserFonction	No errors.
App\Entity\AbortRegistration	No errors.

Symfony Profiler

GET https://operation5sur5.demo-stimactiv.com/inscription

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping