Symfony Profiler

Query Metrics

12 Database Queries

3 Different statements

19.34 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.27 ms
(53.08%)

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_unitaire AS prix_unitaire_3, t0.products_id AS products_id_4, t0.shop_id AS shop_id_5 FROM stock t0 WHERE t0.products_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.prix_unitaire AS prix_unitaire_3,
  t0.products_id AS products_id_4,
  t0.shop_id AS shop_id_5
FROM
  stock t0
WHERE
  t0.products_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_unitaire AS prix_unitaire_3, t0.products_id AS products_id_4, t0.shop_id AS shop_id_5 FROM stock t0 WHERE t0.products_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 705)
9	__TwigTemplate_74446509bc696018b33c6ef0dfceae1f->block_sectionExpo (line 171)
10	Twig\Template->displayBlock (line 95)
11	__TwigTemplate_74446509bc696018b33c6ef0dfceae1f->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 48)
14	__TwigTemplate_b8a5b023d09af441b8f22d9a9d43dbc2->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 25)
22	App\Controller\HomeController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

7.51 ms
(38.85%)

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

Parameters:

[]

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

SELECT t0.id AS id_1, t0.name_categorie AS name_categorie_2, t0.couverture AS couverture_3 FROM categorie 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 26)
5	App\Controller\HomeController->index (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)

1.56 ms
(8.08%)

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.categorie_id = ?

Parameters:

[
  1
]

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.categorie_id = ?

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.categorie_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 693)
8	__TwigTemplate_74446509bc696018b33c6ef0dfceae1f->block_sectionExpo (line 171)
9	Twig\Template->displayBlock (line 95)
10	__TwigTemplate_74446509bc696018b33c6ef0dfceae1f->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 48)
13	__TwigTemplate_b8a5b023d09af441b8f22d9a9d43dbc2->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 40)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 25)
21	App\Controller\HomeController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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.
App\Entity\Stock	No errors.
App\Entity\Shop	No errors.
App\Entity\OrdersDetails	No errors.

Symfony Profiler

GET https://damkomateriaux.marchemondialgn.com/public/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping