Symfony Profiler

Query Metrics

570 Database Queries

6 Different statements

40.31 ms Query time

0 Invalid entities

635 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

31.46 ms
(78.05%)

546

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:

[
  25307
]

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

#	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)

4.09 ms
(10.14%)

SELECT p0_.id AS id_0, p0_.annee AS annee_1, p0_.groupement AS groupement_2, (SELECT COUNT(o1_.id) AS sclr_4 FROM operation o1_ WHERE o1_.plan_trade_id = p0_.id) AS sclr_3 FROM plan_trade p0_ LEFT JOIN operation o2_ ON p0_.id = o2_.plan_trade_id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_3 DESC, p0_.id 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,
  (
    SELECT
      COUNT(o1_.id) AS sclr_4
    FROM
      operation o1_
    WHERE
      o1_.plan_trade_id = p0_.id
  ) AS sclr_3
FROM
  plan_trade p0_
  LEFT JOIN operation o2_ ON p0_.id = o2_.plan_trade_id
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  sclr_3 DESC,
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.annee AS annee_1, p0_.groupement AS groupement_2, (SELECT COUNT(o1_.id) AS sclr_4 FROM operation o1_ WHERE o1_.plan_trade_id = p0_.id) AS sclr_3 FROM plan_trade p0_ LEFT JOIN operation o2_ ON p0_.id = o2_.plan_trade_id WHERE p0_.id IN (1171, 1165, 1172, 1169, 1167, 1164, 1163, 1158, 1243, 1230, 1166, 1159, 1244, 1234, 1229, 1215, 1205, 1201, 1196, 1183) ORDER BY sclr_3 DESC, p0_.id 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)

2.00 ms
(4.96%)

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)

1.36 ms
(3.38%)

SELECT DISTINCT p0_.id AS id_0, (SELECT COUNT(o1_.id) AS sclr_2 FROM operation o1_ WHERE o1_.plan_trade_id = p0_.id) AS sclr_1, p0_.id AS id_3 FROM plan_trade p0_ LEFT JOIN operation o2_ ON p0_.id = o2_.plan_trade_id ORDER BY sclr_1 DESC, p0_.id DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  (
    SELECT
      COUNT(o1_.id) AS sclr_2
    FROM
      operation o1_
    WHERE
      o1_.plan_trade_id = p0_.id
  ) AS sclr_1,
  p0_.id AS id_3
FROM
  plan_trade p0_
  LEFT JOIN operation o2_ ON p0_.id = o2_.plan_trade_id
ORDER BY
  sclr_1 DESC,
  p0_.id DESC
LIMIT
  20

SELECT DISTINCT p0_.id AS id_0, (SELECT COUNT(o1_.id) AS sclr_2 FROM operation o1_ WHERE o1_.plan_trade_id = p0_.id) AS sclr_1, p0_.id AS id_3 FROM plan_trade p0_ LEFT JOIN operation o2_ ON p0_.id = o2_.plan_trade_id ORDER BY sclr_1 DESC, p0_.id 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.70 ms
(1.74%)

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 (1171, 1165, 1172, 1169, 1167, 1164, 1163, 1158, 1243, 1230, 1166, 1159, 1244, 1234, 1229, 1215, 1205, 1201, 1196, 1183);

#	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.70 ms
(1.73%)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM plan_trade p0_ LEFT JOIN operation o1_ ON p0_.id = o1_.plan_trade_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  plan_trade p0_
  LEFT JOIN operation o1_ ON p0_.id = o1_.plan_trade_id

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM plan_trade p0_ LEFT JOIN operation o1_ ON p0_.id = o1_.plan_trade_id;

#	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	546
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%5Boperations%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