Symfony Profiler

Query Metrics

16 Database Queries

10 Different statements

11.97 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.72 ms
(31.04%)

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.designation AS designation_2, p0_.prix AS prix_3, p0_.poids AS poids_4, p0_.stock AS stock_5, p0_.image_name AS image_name_6, p0_.image_size AS image_size_7, p0_.updated_at AS updated_at_8, p0_.statut AS statut_9, p0_.quantite AS quantite_10, p0_.montant_lot AS montant_lot_11, p0_.cout_transport AS cout_transport_12, p0_.is_active AS is_active_13, p0_.category AS category_14, p0_.type_de_produit AS type_de_produit_15, p0_.stock_minimum AS stock_minimum_16, p0_.receive_start AS receive_start_17, p0_.max_quantity AS max_quantity_18, p0_.stock_alert_sent AS stock_alert_sent_19, p0_.commande_id AS commande_id_20 FROM produit p0_ WHERE p0_.is_active = ? AND p0_.stock > 0 ORDER BY p0_.reference ASC

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.designation AS designation_2,
  p0_.prix AS prix_3,
  p0_.poids AS poids_4,
  p0_.stock AS stock_5,
  p0_.image_name AS image_name_6,
  p0_.image_size AS image_size_7,
  p0_.updated_at AS updated_at_8,
  p0_.statut AS statut_9,
  p0_.quantite AS quantite_10,
  p0_.montant_lot AS montant_lot_11,
  p0_.cout_transport AS cout_transport_12,
  p0_.is_active AS is_active_13,
  p0_.category AS category_14,
  p0_.type_de_produit AS type_de_produit_15,
  p0_.stock_minimum AS stock_minimum_16,
  p0_.receive_start AS receive_start_17,
  p0_.max_quantity AS max_quantity_18,
  p0_.stock_alert_sent AS stock_alert_sent_19,
  p0_.commande_id AS commande_id_20
FROM
  produit p0_
WHERE
  p0_.is_active = ?
  AND p0_.stock > 0
ORDER BY
  p0_.reference ASC

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.designation AS designation_2, p0_.prix AS prix_3, p0_.poids AS poids_4, p0_.stock AS stock_5, p0_.image_name AS image_name_6, p0_.image_size AS image_size_7, p0_.updated_at AS updated_at_8, p0_.statut AS statut_9, p0_.quantite AS quantite_10, p0_.montant_lot AS montant_lot_11, p0_.cout_transport AS cout_transport_12, p0_.is_active AS is_active_13, p0_.category AS category_14, p0_.type_de_produit AS type_de_produit_15, p0_.stock_minimum AS stock_minimum_16, p0_.receive_start AS receive_start_17, p0_.max_quantity AS max_quantity_18, p0_.stock_alert_sent AS stock_alert_sent_19, p0_.commande_id AS commande_id_20 FROM produit p0_ WHERE p0_.is_active = 0 AND p0_.stock > 0 ORDER BY p0_.reference ASC;

#	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 37)
7	App\Form\ArticleType->buildForm (line 96)
8	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 56)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 80)
11	Symfony\Component\Form\FormBuilder->create (line 38)
12	Symfony\Component\Form\Extension\Core\Type\CollectionType->buildForm (line 96)
13	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
14	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 56)
15	Symfony\Component\Form\FormFactory->createNamedBuilder (line 107)
16	EasyCorp\Bundle\EasyAdminBundle\Form\Type\CrudFormType->buildForm (line 96)
17	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 56)
19	Symfony\Component\Form\FormFactory->createNamedBuilder (line 56)
20	EasyCorp\Bundle\EasyAdminBundle\Factory\FormFactory->createNewFormBuilder (line 542)
21	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->createNewFormBuilder (line 537)
22	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->createNewForm (line 305)
23	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->new (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.58 ms
(13.22%)

"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 238)
5	App\Controller\Admin\CommandeCrudController->persistEntity (line 318)
6	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->new (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)

1.43 ms
(11.95%)

INSERT INTO order_line (quantity, command_id, product_id) VALUES (?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

INSERT INTO order_line (quantity, command_id, product_id)
VALUES
  (?, ?, ?)

INSERT INTO order_line (quantity, command_id, product_id) VALUES (5, 279, 2);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 238)
7	App\Controller\Admin\CommandeCrudController->persistEntity (line 318)
8	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->new (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)

1.18 ms
(9.84%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed AS password_changed_5, t0.last_password_change AS last_password_change_6, t0.temporary_password_count AS temporary_password_count_7, t0.plain_password AS plain_password_8, t0.password_reset_token AS password_reset_token_9 FROM user t0 WHERE t0.id = ?

Parameters:

[
  39
]

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.password_changed AS password_changed_5,
  t0.last_password_change AS last_password_change_6,
  t0.temporary_password_count AS temporary_password_count_7,
  t0.plain_password AS plain_password_8,
  t0.password_reset_token AS password_reset_token_9
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.password_changed AS password_changed_5, t0.last_password_change AS last_password_change_6, t0.temporary_password_count AS temporary_password_count_7, t0.plain_password AS plain_password_8, t0.password_reset_token AS password_reset_token_9 FROM user t0 WHERE t0.id = 39;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
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 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
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 60)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
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.80 ms
(6.67%)

UPDATE produit SET stock = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  produit
SET
  stock = ?
WHERE
  id = ?

UPDATE produit SET stock = 200 WHERE id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 490)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 374)
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 238)
7	App\Controller\Admin\CommandeCrudController->persistEntity (line 318)
8	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->new (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.74 ms
(6.17%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.rue AS rue_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5 FROM agences t0 INNER JOIN agences_users ON t0.id = agences_users.agences_id WHERE agences_users.user_id = ?

Parameters:

[
  39
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.rue AS rue_3,
  t0.code_postal AS code_postal_4,
  t0.ville AS ville_5
FROM
  agences t0
  INNER JOIN agences_users ON t0.id = agences_users.agences_id
WHERE
  agences_users.user_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.rue AS rue_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5 FROM agences t0 INNER JOIN agences_users ON t0.id = agences_users.agences_id WHERE agences_users.user_id = 39;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 167)
7	Doctrine\Common\Collections\AbstractLazyCollection->first (line 88)
8	App\Controller\Admin\CommandeCrudController->createEntity (line 300)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->new (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.70 ms
(5.85%)

INSERT INTO commande (numeros, objet, statut, autre_choix, suivi_envoi, quantities, created_at, status_date, instruction_detail, agency_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  174
  "POUR KAWASAKI avignon"
  "warning"
  null
  null
  "[]"
  "2026-04-29 15:35:05"
  null
  "PLANETE JMS MOTOS : 1 BIS ROUTE DE MORIERES 84000 AVIGNON"
  7
  39
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO commande (
  numeros, objet, statut, autre_choix,
  suivi_envoi, quantities, created_at,
  status_date, instruction_detail,
  agency_id, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO commande (numeros, objet, statut, autre_choix, suivi_envoi, quantities, created_at, status_date, instruction_detail, agency_id, user_id) VALUES (174, 'POUR KAWASAKI avignon', 'warning', NULL, NULL, '[]', '2026-04-29 15:35:05', NULL, 'PLANETE JMS MOTOS : 1 BIS ROUTE DE MORIERES 84000 AVIGNON', 7, 39);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 238)
7	App\Controller\Admin\CommandeCrudController->persistEntity (line 318)
8	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->new (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.69 ms
(5.76%)

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.rue AS rue_2, a0_.code_postal AS code_postal_3, a0_.ville AS ville_4 FROM agences a0_ WHERE a0_.id IN (?) ORDER BY a0_.nom ASC

Parameters:

[
  "7"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.rue AS rue_2,
  a0_.code_postal AS code_postal_3,
  a0_.ville AS ville_4
FROM
  agences a0_
WHERE
  a0_.id IN (?)
ORDER BY
  a0_.nom ASC

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.rue AS rue_2, a0_.code_postal AS code_postal_3, a0_.ville AS ville_4 FROM agences a0_ WHERE a0_.id IN ('7') ORDER BY a0_.nom ASC;

#	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 306)
17	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->new (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.65 ms
(5.40%)

SELECT MAX(c0_.numeros) AS sclr_0 FROM commande c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(c0_.numeros) AS sclr_0
FROM
  commande c0_

SELECT MAX(c0_.numeros) AS sclr_0 FROM commande c0_;

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 225)
8	App\Controller\Admin\CommandeCrudController->persistEntity (line 318)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->new (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.49 ms
(4.10%)

"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 238)
4	App\Controller\Admin\CommandeCrudController->persistEntity (line 318)
5	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->new (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\Agences	No errors.
App\Entity\Commande	No errors.
App\Entity\OrderLine	No errors.
App\Entity\Produit	No errors.

Symfony Profiler

POST https://www.stock-fi.fr/admin?crudAction=new&crudControllerFqcn=App%5CController%5CAdmin%5CCommandeCrudController

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping