Symfony Profiler

Query Metrics

513 Database Queries

6 Different statements

36.04 ms Query time

0 Invalid entities

578 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

32.36 ms
(89.78%)

489

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:

[
  25340
]

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 = 25340;

#	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\ObjectHydrator->cleanup (line 124)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 173)
13	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
14	Doctrine\ORM\AbstractQuery->execute (line 891)
15	Doctrine\ORM\AbstractQuery->getResult (line 689)
16	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
17	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 68)
18	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
19	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 197)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

1.74 ms
(4.82%)

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\Controller\Admin\PlanTradeCrudController->App\Controller\Admin\{closure} (line 54)
6	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\CommonPostConfigurator->buildFormattedValueOption (line 51)
7	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\CommonPostConfigurator->configure (line 38)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 116)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFieldsForAll (line 150)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 149)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
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.90 ms
(2.51%)

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:

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 (1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1246);

#	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\ObjectHydrator->cleanup (line 124)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 173)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
7	Doctrine\ORM\AbstractQuery->execute (line 891)
8	Doctrine\ORM\AbstractQuery->getResult (line 689)
9	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
10	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 68)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
12	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 197)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

0.71 ms
(1.96%)

SELECT DISTINCT p0_.id AS id_0, p0_.annee AS annee_1 FROM plan_trade p0_ ORDER BY p0_.annee DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.annee AS annee_1
FROM
  plan_trade p0_
ORDER BY
  p0_.annee DESC
LIMIT
  20

SELECT DISTINCT p0_.id AS id_0, p0_.annee AS annee_1 FROM plan_trade p0_ ORDER BY p0_.annee DESC LIMIT 20;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 68)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
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.27 ms
(0.74%)

SELECT p0_.id AS id_0, p0_.annee AS annee_1, p0_.groupement AS groupement_2 FROM plan_trade p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.annee DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.annee AS annee_1,
  p0_.groupement AS groupement_2
FROM
  plan_trade p0_
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  p0_.annee DESC

SELECT p0_.id AS id_0, p0_.annee AS annee_1, p0_.groupement AS groupement_2 FROM plan_trade p0_ WHERE p0_.id IN (1246, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1169, 1168, 1167, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166) ORDER BY p0_.annee DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 68)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
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.07 ms
(0.20%)

SELECT count(*) AS sclr_0 FROM plan_trade p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  plan_trade p0_

SELECT count(*) AS sclr_0 FROM plan_trade p0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 69)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
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)

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\Operation	489
App\Entity\Logo	38
App\Entity\Produit	21
App\Entity\PlanTrade	20
App\Entity\Gamme	8
App\Entity\ProduitGroupement	2

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\Logo	No errors.

Symfony Profiler

GET https://pfm.texol.fr/admin/plan-trade?page=1&sort%5Bannee%5D=DESC

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping