Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

26.35 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

24.75 ms
(93.93%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 513)
5	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->updateEntity (line 261)
6	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->edit (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.77 ms
(2.91%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.is_verified AS is_verified_8, t0.date_time_payant AS date_time_payant_9, t0.date_time_creation AS date_time_creation_10, t0.google_id AS google_id_11, t0.stripe_id AS stripe_id_12, t0.last_pourcentage AS last_pourcentage_13, t0.google_authenticator_secret AS google_authenticator_secret_14, t0.trusted_version AS trusted_version_15 FROM user t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.telephone AS telephone_7,
  t0.is_verified AS is_verified_8,
  t0.date_time_payant AS date_time_payant_9,
  t0.date_time_creation AS date_time_creation_10,
  t0.google_id AS google_id_11,
  t0.stripe_id AS stripe_id_12,
  t0.last_pourcentage AS last_pourcentage_13,
  t0.google_authenticator_secret AS google_authenticator_secret_14,
  t0.trusted_version AS trusted_version_15
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.is_verified AS is_verified_8, t0.date_time_payant AS date_time_payant_9, t0.date_time_creation AS date_time_creation_10, t0.google_id AS google_id_11, t0.stripe_id AS stripe_id_12, t0.last_pourcentage AS last_pourcentage_13, t0.google_authenticator_secret AS google_authenticator_secret_14, t0.trusted_version AS trusted_version_15 FROM user t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 205)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 125)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.29 ms
(1.09%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nom AS nom_4, u0_.prenom AS prenom_5, u0_.telephone AS telephone_6, u0_.is_verified AS is_verified_7, u0_.date_time_payant AS date_time_payant_8, u0_.date_time_creation AS date_time_creation_9, u0_.google_id AS google_id_10, u0_.stripe_id AS stripe_id_11, u0_.last_pourcentage AS last_pourcentage_12, u0_.google_authenticator_secret AS google_authenticator_secret_13, u0_.trusted_version AS trusted_version_14 FROM user u0_ WHERE u0_.id IN (?)

Parameters:

[
  "947"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.nom AS nom_4,
  u0_.prenom AS prenom_5,
  u0_.telephone AS telephone_6,
  u0_.is_verified AS is_verified_7,
  u0_.date_time_payant AS date_time_payant_8,
  u0_.date_time_creation AS date_time_creation_9,
  u0_.google_id AS google_id_10,
  u0_.stripe_id AS stripe_id_11,
  u0_.last_pourcentage AS last_pourcentage_12,
  u0_.google_authenticator_secret AS google_authenticator_secret_13,
  u0_.trusted_version AS trusted_version_14
FROM
  user u0_
WHERE
  u0_.id IN (?)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nom AS nom_4, u0_.prenom AS prenom_5, u0_.telephone AS telephone_6, u0_.is_verified AS is_verified_7, u0_.date_time_payant AS date_time_payant_8, u0_.date_time_creation AS date_time_creation_9, u0_.google_id AS google_id_10, u0_.stripe_id AS stripe_id_11, u0_.last_pourcentage AS last_pourcentage_12, u0_.google_authenticator_secret AS google_authenticator_secret_13, u0_.trusted_version AS trusted_version_14 FROM user u0_ WHERE u0_.id IN ('947');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 99)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 92)
8	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 76)
10	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 41)
11	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 1002)
12	Symfony\Component\Form\Form->viewToNorm (line 552)
13	Symfony\Component\Form\Form->submit (line 493)
14	Symfony\Component\Form\Form->submit (line 107)
15	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 414)
16	Symfony\Component\Form\Form->handleRequest (line 253)
17	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->edit (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.22 ms
(0.84%)

UPDATE quart SET debut = ?, fin = ? WHERE id = ?

Parameters:

[
  "2026-01-27 00:45:00"
  "2026-01-27 09:55:00"
  890
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  quart
SET
  debut = ?,
  fin = ?
WHERE
  id = ?

UPDATE quart SET debut = '2026-01-27 00:45:00', fin = '2026-01-27 09:55:00' WHERE id = 890;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 513)
7	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->updateEntity (line 261)
8	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->edit (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.19 ms
(0.71%)

SELECT t0.id AS id_1, t0.debut AS debut_2, t0.fin AS fin_3, t0.user_id AS user_id_4 FROM quart t0 WHERE t0.id = ?

Parameters:

[
  "890"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.debut AS debut_2,
  t0.fin AS fin_3,
  t0.user_id AS user_id_4
FROM
  quart t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.debut AS debut_2, t0.fin AS fin_3, t0.user_id AS user_id_4 FROM quart t0 WHERE t0.id = '890';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 146)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 111)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 70)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 254)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 65)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 121)
12	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.14 ms
(0.52%)

"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 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 513)
4	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->updateEntity (line 261)
5	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->edit (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Fiche	No errors.
App\Entity\Vehicule	No errors.
App\Entity\Depence	No errors.
App\Entity\Facture	No errors.
App\Entity\Revenu	No errors.
App\Entity\Employe	No errors.
App\Entity\Quart	No errors.
App\Entity\Course	No errors.
App\Entity\Horaire	No errors.
App\Entity\Incident	No errors.

Symfony Profiler

POST https://flottigo.com/fr/app/voiture?crudAction=edit&crudControllerFqcn=App%5CController%5CAdmin%5CQuartCrudController&entityId=890&filters%5Buser%5D%5Bcompariso…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping