Symfony Profiler

Query Metrics

28 Database Queries

8 Different statements

2.89 ms Query time

0 Invalid entities

125 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.24 ms
(42.80%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?

Parameters:

[
  26573
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.code_ean AS code_ean_4,
  t0.image_name AS image_name_5,
  t0.updated_at AS updated_at_6,
  t0.couleur_principale AS couleur_principale_7,
  t0.couleur_secondaire AS couleur_secondaire_8,
  t0.reduction_prix AS reduction_prix_9,
  t0.reduction_unite AS reduction_unite_10,
  t0.hidden AS hidden_11,
  t0.gamme_id AS gamme_id_12,
  t0.groupement_id AS groupement_id_13
FROM
  produit t0
  INNER JOIN operation_produit ON t0.id = operation_produit.produit_id
WHERE
  operation_produit.operation_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = 26573;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2601)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 171)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 946)
9	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2670)
10	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2646)
11	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 63)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 171)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 748)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
15	Doctrine\ORM\EntityManager->find (line 366)
16	Doctrine\ORM\EntityRepository->find (line 86)
17	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
18	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 119)
19	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 63)
20	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 60)
21	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
22	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 40)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 173)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.52 ms
(18.05%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.couleur_principale AS couleur_principale_3,
  t0.couleur_secondaire AS couleur_secondaire_4,
  t0.couleur_bordure AS couleur_bordure_5
FROM
  gamme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = 1;

#	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->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Gamme::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Gamme->__get (line 184)
7	App\Entity\Gamme->getTitre (line 49)
8	App\Service\PlanTradePdfGenerator->generate (line 85)
9	App\Controller\DefaultController->plantradepriceless (line 67)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.42 ms
(14.60%)

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.groupement AS groupement_3 FROM plan_trade t0 WHERE t0.id = ?

Parameters:

[
  "1224"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.annee AS annee_2,
  t0.groupement AS groupement_3
FROM
  plan_trade t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.groupement AS groupement_3 FROM plan_trade t0 WHERE t0.id = '1224';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 63)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 60)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 40)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 173)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 197)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.20 ms
(6.95%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3 FROM produit_groupement t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3
FROM
  produit_groupement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3 FROM produit_groupement t0 WHERE t0.id = 1;

#	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->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\ProduitGroupement::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\ProduitGroupement->__get (line 184)
7	App\Entity\ProduitGroupement->getDescription (line 89)
8	App\Service\PlanTradePdfGenerator->generate (line 134)
9	App\Controller\DefaultController->plantradepriceless (line 67)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.18 ms
(6.23%)

SELECT t0.id AS id_1, t0.annee AS annee_2 FROM plan_media t0 WHERE t0.annee = ? LIMIT 1

Parameters:

[
  2026
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.annee AS annee_2
FROM
  plan_media t0
WHERE
  t0.annee = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.annee AS annee_2 FROM plan_media t0 WHERE t0.annee = 2026 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\PlanTradePdfGenerator->generate (line 206)
5	App\Controller\DefaultController->plantradepriceless (line 67)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.13 ms
(4.43%)

SELECT t0.id AS id_1, t0.mois AS mois_2, t0.plan_trade_id AS plan_trade_id_3 FROM operation t0 WHERE t0.plan_trade_id IN (?)

Parameters:

[
  1224
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.mois AS mois_2,
  t0.plan_trade_id AS plan_trade_id_3
FROM
  operation t0
WHERE
  t0.plan_trade_id IN (?)

SELECT t0.id AS id_1, t0.mois AS mois_2, t0.plan_trade_id AS plan_trade_id_3 FROM operation t0 WHERE t0.plan_trade_id IN (1224);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2670)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2646)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 63)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 171)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 748)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
8	Doctrine\ORM\EntityManager->find (line 366)
9	Doctrine\ORM\EntityRepository->find (line 86)
10	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
11	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 119)
12	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 63)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 60)
14	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
15	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 40)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 173)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.11 ms
(3.74%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.updated_at AS updated_at_3, t0.correspondances AS correspondances_4 FROM logo t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.updated_at AS updated_at_3,
  t0.correspondances AS correspondances_4
FROM
  logo t0

SELECT t0.id AS id_1, t0.path AS path_2, t0.updated_at AS updated_at_3, t0.correspondances AS correspondances_4 FROM logo t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\PlanTradePdfGenerator->generate (line 321)
6	App\Controller\DefaultController->plantradepriceless (line 67)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.09 ms
(3.22%)

SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.months AS months_3, t0.plan_media_id AS plan_media_id_4, t0.gamme_id AS gamme_id_5 FROM plan_media_operation t0 WHERE t0.plan_media_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.prefix AS prefix_2,
  t0.months AS months_3,
  t0.plan_media_id AS plan_media_id_4,
  t0.gamme_id AS gamme_id_5
FROM
  plan_media_operation t0
WHERE
  t0.plan_media_id = ?

SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.months AS months_3, t0.plan_media_id AS plan_media_id_4, t0.gamme_id AS gamme_id_5 FROM plan_media_operation t0 WHERE t0.plan_media_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Service\PlanTradePdfGenerator->generate (line 211)
8	App\Controller\DefaultController->plantradepriceless (line 67)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	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\Logo	82
App\Entity\Operation	16
App\Entity\Produit	13
App\Entity\Gamme	6
App\Entity\PlanMediaOperation	5
App\Entity\PlanTrade	1
App\Entity\ProduitGroupement	1
App\Entity\PlanMedia	1

Entities Mapping

Class	Mapping errors
App\Entity\PlanTrade	No errors.
App\Entity\Operation	No errors.
App\Entity\Produit	No errors.
App\Entity\Gamme	No errors.
App\Entity\ProduitGroupement	No errors.
App\Entity\PlanMedia	No errors.
App\Entity\PlanMediaOperation	No errors.
App\Entity\Logo	No errors.

Symfony Profiler

GET https://pfm.texol.fr/plantrade/1224/priceless

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping