Symfony Profiler

Query Metrics

13 Database Queries

6 Different statements

4.98 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.63 ms
(32.82%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM ingredient t0 INNER JOIN ingredient_mesure ON t0.id = ingredient_mesure.ingredient_id WHERE ingredient_mesure.mesure_id = ?

Parameters:

[
  47
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  ingredient t0
  INNER JOIN ingredient_mesure ON t0.id = ingredient_mesure.ingredient_id
WHERE
  ingredient_mesure.mesure_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM ingredient t0 INNER JOIN ingredient_mesure ON t0.id = ingredient_mesure.ingredient_id WHERE ingredient_mesure.mesure_id = 47;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1137)
9	Twig\Extension\CoreExtension::length (line 177)
10	__TwigTemplate_7937e31b9b4bc212459773f34edbdcc8->block_body (line 430)
11	Twig\Template->yieldBlock (line 90)
12	__TwigTemplate_118fd5bf2fe0b5facbb2fc8689c7ba27->doDisplay (line 360)
13	Twig\Template->yield (line 50)
14	__TwigTemplate_7937e31b9b4bc212459773f34edbdcc8->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 102)
22	App\Controller\RecetteController->recette (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.11 ms
(22.33%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.preparation AS preparation_3, t0.cuisson AS cuisson_4, t0.repos AS repos_5, t0.pays AS pays_6, t0.instruction AS instruction_7, t0.brouillon AS brouillon_8, t0.image AS image_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.slug AS slug_12, t0.portion AS portion_13, t0.categorie_id AS categorie_id_14 FROM recette t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "brownies"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.preparation AS preparation_3,
  t0.cuisson AS cuisson_4,
  t0.repos AS repos_5,
  t0.pays AS pays_6,
  t0.instruction AS instruction_7,
  t0.brouillon AS brouillon_8,
  t0.image AS image_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.slug AS slug_12,
  t0.portion AS portion_13,
  t0.categorie_id AS categorie_id_14
FROM
  recette t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.preparation AS preparation_3, t0.cuisson AS cuisson_4, t0.repos AS repos_5, t0.pays AS pays_6, t0.instruction AS instruction_7, t0.brouillon AS brouillon_8, t0.image AS image_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.slug AS slug_12, t0.portion AS portion_13, t0.categorie_id AS categorie_id_14 FROM recette t0 WHERE t0.slug = 'brownies' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 96)
5	App\Controller\RecetteController->recette (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.84 ms
(16.94%)

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.mesure AS mesure_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM mesure t0 INNER JOIN mesure_recette ON t0.id = mesure_recette.mesure_id WHERE mesure_recette.recette_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.mesure AS mesure_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  mesure t0
  INNER JOIN mesure_recette ON t0.id = mesure_recette.mesure_id
WHERE
  mesure_recette.recette_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.mesure AS mesure_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM mesure t0 INNER JOIN mesure_recette ON t0.id = mesure_recette.mesure_id WHERE mesure_recette.recette_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 171)
8	__TwigTemplate_7937e31b9b4bc212459773f34edbdcc8->block_body (line 430)
9	Twig\Template->yieldBlock (line 90)
10	__TwigTemplate_118fd5bf2fe0b5facbb2fc8689c7ba27->doDisplay (line 360)
11	Twig\Template->yield (line 50)
12	__TwigTemplate_7937e31b9b4bc212459773f34edbdcc8->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 307)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 102)
20	App\Controller\RecetteController->recette (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.57 ms
(11.36%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM categorie t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM categorie t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Categorie::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Categorie->__get (line 67)
8	App\Entity\Categorie->getNom (line 132)
9	App\Entity\Categorie->__toString (line 114)
10	Twig\Runtime\EscaperRuntime->escape (line 111)
11	__TwigTemplate_7937e31b9b4bc212459773f34edbdcc8->block_body (line 430)
12	Twig\Template->yieldBlock (line 90)
13	__TwigTemplate_118fd5bf2fe0b5facbb2fc8689c7ba27->doDisplay (line 360)
14	Twig\Template->yield (line 50)
15	__TwigTemplate_7937e31b9b4bc212459773f34edbdcc8->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 307)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 102)
23	App\Controller\RecetteController->recette (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.44 ms
(8.82%)

SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.statut AS statut_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.recette_id AS recette_id_6, t0.auteur_id AS auteur_id_7 FROM commentaire t0 WHERE t0.recette_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.contenu AS contenu_2,
  t0.statut AS statut_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.recette_id AS recette_id_6,
  t0.auteur_id AS auteur_id_7
FROM
  commentaire t0
WHERE
  t0.recette_id = ?

SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.statut AS statut_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.recette_id AS recette_id_6, t0.auteur_id AS auteur_id_7 FROM commentaire t0 WHERE t0.recette_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 645)
8	__TwigTemplate_7937e31b9b4bc212459773f34edbdcc8->block_body (line 430)
9	Twig\Template->yieldBlock (line 90)
10	__TwigTemplate_118fd5bf2fe0b5facbb2fc8689c7ba27->doDisplay (line 360)
11	Twig\Template->yield (line 50)
12	__TwigTemplate_7937e31b9b4bc212459773f34edbdcc8->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 307)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 102)
20	App\Controller\RecetteController->recette (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.39 ms
(7.74%)

SELECT t0.id AS id_1, t0.etoile AS etoile_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.recette_id AS recette_id_5, t0.auteur_id AS auteur_id_6 FROM note t0 WHERE t0.recette_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.etoile AS etoile_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.recette_id AS recette_id_5,
  t0.auteur_id AS auteur_id_6
FROM
  note t0
WHERE
  t0.recette_id = ?

SELECT t0.id AS id_1, t0.etoile AS etoile_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.recette_id AS recette_id_5, t0.auteur_id AS auteur_id_6 FROM note t0 WHERE t0.recette_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 98)
8	App\Controller\RecetteController->recette (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\Recette	No errors.
App\Entity\Categorie	No errors.
App\Entity\Note	No errors.
App\Entity\Commentaire	No errors.
App\Entity\Ingredient	No errors.
App\Entity\Mesure	No errors.
App\Entity\Utilisateur	No errors.

Symfony Profiler

GET https://cookbook.ekaterinalecam.com/recette/brownies

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping