Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.42 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.46 ms
(32.46%)

SELECT t0.id AS id_1, t0.valeur_dimension AS valeur_dimension_2, t0.categorie_id AS categorie_id_3 FROM dimensions t0 WHERE t0.categorie_id = ? ORDER BY t0.categorie_id ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.valeur_dimension AS valeur_dimension_2,
  t0.categorie_id AS categorie_id_3
FROM
  dimensions t0
WHERE
  t0.categorie_id = ?
ORDER BY
  t0.categorie_id ASC

SELECT t0.id AS id_1, t0.valeur_dimension AS valeur_dimension_2, t0.categorie_id AS categorie_id_3 FROM dimensions t0 WHERE t0.categorie_id = 2 ORDER BY t0.categorie_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 62)
4	App\Controller\HomeController->choixProduct (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.42 ms
(29.24%)

SELECT t0.id AS id_1, t0.name_categorie AS name_categorie_2, t0.couverture AS couverture_3 FROM categorie t0 WHERE t0.id = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_categorie AS name_categorie_2,
  t0.couverture AS couverture_3
FROM
  categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_categorie AS name_categorie_2, t0.couverture AS couverture_3 FROM categorie t0 WHERE t0.id = '2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.34 ms
(23.95%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.categorie_id AS categorie_id_4, t0.epaisseur_id AS epaisseur_id_5, t0.dimension_id AS dimension_id_6 FROM products t0 WHERE t0.dimension_id IS NULL AND t0.epaisseur_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.designation AS designation_3,
  t0.categorie_id AS categorie_id_4,
  t0.epaisseur_id AS epaisseur_id_5,
  t0.dimension_id AS dimension_id_6
FROM
  products t0
WHERE
  t0.dimension_id IS NULL
  AND t0.epaisseur_id IS NULL

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.categorie_id AS categorie_id_4, t0.epaisseur_id AS epaisseur_id_5, t0.dimension_id AS dimension_id_6 FROM products t0 WHERE t0.dimension_id IS NULL AND t0.epaisseur_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 57)
4	App\Controller\HomeController->choixProduct (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.20 ms
(14.36%)

SELECT t0.id AS id_1, t0.valeur_epaisseur AS valeur_epaisseur_2 FROM epaisseurs t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.valeur_epaisseur AS valeur_epaisseur_2
FROM
  epaisseurs t0

SELECT t0.id AS id_1, t0.valeur_epaisseur AS valeur_epaisseur_2 FROM epaisseurs t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 63)
5	App\Controller\HomeController->choixProduct (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
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\Categorie	No errors.
App\Entity\Products	No errors.
App\Entity\Dimensions	No errors.
App\Entity\Epaisseurs	No errors.

Symfony Profiler

GET https://damkomateriaux.marchemondialgn.com/public/home/choixproduct/2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping