Symfony Profiler

Query Metrics

27 Database Queries

7 Different statements

9.65 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.47 ms
(35.98%)

SELECT t0.id AS id_1, t0.contenu_fr AS contenu_fr_2, t0.contenu_en AS contenu_en_3, t0.contenu_es AS contenu_es_4, t0.est_modifiable AS est_modifiable_5, t0.image_fond AS image_fond_6, t0.image_contenu AS image_contenu_7, t0.pdf_fr AS pdf_fr_8, t0.pdf_en AS pdf_en_9, t0.pdf_es AS pdf_es_10, t0.sous_menu_id AS sous_menu_id_11, t0.menu_id AS menu_id_12 FROM page t0 WHERE t0.menu_id = ?

Parameters:

[
  249
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.contenu_fr AS contenu_fr_2,
  t0.contenu_en AS contenu_en_3,
  t0.contenu_es AS contenu_es_4,
  t0.est_modifiable AS est_modifiable_5,
  t0.image_fond AS image_fond_6,
  t0.image_contenu AS image_contenu_7,
  t0.pdf_fr AS pdf_fr_8,
  t0.pdf_en AS pdf_en_9,
  t0.pdf_es AS pdf_es_10,
  t0.sous_menu_id AS sous_menu_id_11,
  t0.menu_id AS menu_id_12
FROM
  page t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.contenu_fr AS contenu_fr_2, t0.contenu_en AS contenu_en_3, t0.contenu_es AS contenu_es_4, t0.est_modifiable AS est_modifiable_5, t0.image_fond AS image_fond_6, t0.image_contenu AS image_contenu_7, t0.pdf_fr AS pdf_fr_8, t0.pdf_en AS pdf_en_9, t0.pdf_es AS pdf_es_10, t0.sous_menu_id AS sous_menu_id_11, t0.menu_id AS menu_id_12 FROM page t0 WHERE t0.menu_id = 249;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 833)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 738)
11	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 41)
12	App\Repository\MenuRepository->getActiveMenuFromID (line 35)
13	App\Controller\ProduitController->index (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

3.02 ms
(31.33%)

SELECT t0.id AS id_1, t0.contenu_fr AS contenu_fr_2, t0.contenu_en AS contenu_en_3, t0.contenu_es AS contenu_es_4, t0.est_modifiable AS est_modifiable_5, t0.image_fond AS image_fond_6, t0.image_contenu AS image_contenu_7, t0.pdf_fr AS pdf_fr_8, t0.pdf_en AS pdf_en_9, t0.pdf_es AS pdf_es_10, t0.sous_menu_id AS sous_menu_id_11, t0.menu_id AS menu_id_12 FROM page t0 WHERE t0.sous_menu_id = ?

Parameters:

[
  465
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.contenu_fr AS contenu_fr_2,
  t0.contenu_en AS contenu_en_3,
  t0.contenu_es AS contenu_es_4,
  t0.est_modifiable AS est_modifiable_5,
  t0.image_fond AS image_fond_6,
  t0.image_contenu AS image_contenu_7,
  t0.pdf_fr AS pdf_fr_8,
  t0.pdf_en AS pdf_en_9,
  t0.pdf_es AS pdf_es_10,
  t0.sous_menu_id AS sous_menu_id_11,
  t0.menu_id AS menu_id_12
FROM
  page t0
WHERE
  t0.sous_menu_id = ?

SELECT t0.id AS id_1, t0.contenu_fr AS contenu_fr_2, t0.contenu_en AS contenu_en_3, t0.contenu_es AS contenu_es_4, t0.est_modifiable AS est_modifiable_5, t0.image_fond AS image_fond_6, t0.image_contenu AS image_contenu_7, t0.pdf_fr AS pdf_fr_8, t0.pdf_en AS pdf_en_9, t0.pdf_es AS pdf_es_10, t0.sous_menu_id AS sous_menu_id_11, t0.menu_id AS menu_id_12 FROM page t0 WHERE t0.sous_menu_id = 465;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 833)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 63)
12	App\Repository\SousMenuRepository->findAllActifSousMenuFromMenu (line 33)
13	App\Controller\ProduitController->index (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.77 ms
(8.00%)

SELECT p0_.id AS id_0, p0_.mail_destinataire AS mail_destinataire_1, p0_.mail_expediteur AS mail_expediteur_2, p0_.facebook AS facebook_3, p0_.instagram AS instagram_4, p0_.latitude AS latitude_5, p0_.longitude AS longitude_6, p0_.linkedin AS linkedin_7 FROM parametres_globaux p0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.mail_destinataire AS mail_destinataire_1,
  p0_.mail_expediteur AS mail_expediteur_2,
  p0_.facebook AS facebook_3,
  p0_.instagram AS instagram_4,
  p0_.latitude AS latitude_5,
  p0_.longitude AS longitude_6,
  p0_.linkedin AS linkedin_7
FROM
  parametres_globaux p0_
LIMIT
  1

SELECT p0_.id AS id_0, p0_.mail_destinataire AS mail_destinataire_1, p0_.mail_expediteur AS mail_expediteur_2, p0_.facebook AS facebook_3, p0_.instagram AS instagram_4, p0_.latitude AS latitude_5, p0_.longitude AS longitude_6, p0_.linkedin AS linkedin_7 FROM parametres_globaux p0_ LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 69)
7	App\Twig\AppExtension->globalParameter (line 594)
8	__TwigTemplate_8577221a429931ff639a0d410c71cd50->doDisplay (line 393)
9	Twig\Template->yield (line 55)
10	__TwigTemplate_52ceaba1c776932f75b10b933e2c3acc->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 36)
19	App\Controller\ProduitController->index (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.77 ms
(7.93%)

SELECT p0_.id AS id_0, p0_.libelle_fr AS libelle_fr_1, p0_.libelle_en AS libelle_en_2, p0_.libelle_es AS libelle_es_3, p0_.description_fr AS description_fr_4, p0_.description_en AS description_en_5, p0_.description_es AS description_es_6, p0_.est_actif AS est_actif_7, p0_.ordre AS ordre_8, p0_.sous_menu_id AS sous_menu_id_9, p0_.tag_id AS tag_id_10 FROM produit p0_ WHERE p0_.est_actif = 1 ORDER BY p0_.ordre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.libelle_fr AS libelle_fr_1,
  p0_.libelle_en AS libelle_en_2,
  p0_.libelle_es AS libelle_es_3,
  p0_.description_fr AS description_fr_4,
  p0_.description_en AS description_en_5,
  p0_.description_es AS description_es_6,
  p0_.est_actif AS est_actif_7,
  p0_.ordre AS ordre_8,
  p0_.sous_menu_id AS sous_menu_id_9,
  p0_.tag_id AS tag_id_10
FROM
  produit p0_
WHERE
  p0_.est_actif = 1
ORDER BY
  p0_.ordre ASC

SELECT p0_.id AS id_0, p0_.libelle_fr AS libelle_fr_1, p0_.libelle_en AS libelle_en_2, p0_.libelle_es AS libelle_es_3, p0_.description_fr AS description_fr_4, p0_.description_en AS description_en_5, p0_.description_es AS description_es_6, p0_.est_actif AS est_actif_7, p0_.ordre AS ordre_8, p0_.sous_menu_id AS sous_menu_id_9, p0_.tag_id AS tag_id_10 FROM produit p0_ WHERE p0_.est_actif = 1 ORDER BY p0_.ordre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 25)
7	App\Repository\ProduitRepository->getActiveProduits (line 32)
8	App\Controller\ProduitController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.70 ms
(7.25%)

SELECT m0_.id AS id_0, m0_.libelle_fr AS libelle_fr_1, m0_.libelle_en AS libelle_en_2, m0_.libelle_es AS libelle_es_3, m0_.est_actif AS est_actif_4, m0_.peut_contenir_page AS peut_contenir_page_5, m0_.est_footer AS est_footer_6, m0_.est_affiche AS est_affiche_7, m0_.ordre AS ordre_8, m0_.image AS image_9, m0_.nom_route AS nom_route_10 FROM menu m0_ WHERE m0_.est_actif = ? AND m0_.est_footer = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.libelle_fr AS libelle_fr_1,
  m0_.libelle_en AS libelle_en_2,
  m0_.libelle_es AS libelle_es_3,
  m0_.est_actif AS est_actif_4,
  m0_.peut_contenir_page AS peut_contenir_page_5,
  m0_.est_footer AS est_footer_6,
  m0_.est_affiche AS est_affiche_7,
  m0_.ordre AS ordre_8,
  m0_.image AS image_9,
  m0_.nom_route AS nom_route_10
FROM
  menu m0_
WHERE
  m0_.est_actif = ?
  AND m0_.est_footer = ?

SELECT m0_.id AS id_0, m0_.libelle_fr AS libelle_fr_1, m0_.libelle_en AS libelle_en_2, m0_.libelle_es AS libelle_es_3, m0_.est_actif AS est_actif_4, m0_.peut_contenir_page AS peut_contenir_page_5, m0_.est_footer AS est_footer_6, m0_.est_affiche AS est_affiche_7, m0_.ordre AS ordre_8, m0_.image AS image_9, m0_.nom_route AS nom_route_10 FROM menu m0_ WHERE m0_.est_actif = 1 AND m0_.est_footer = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 58)
7	App\Twig\AppExtension->header (line 303)
8	__TwigTemplate_8577221a429931ff639a0d410c71cd50->doDisplay (line 393)
9	Twig\Template->yield (line 55)
10	__TwigTemplate_52ceaba1c776932f75b10b933e2c3acc->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 36)
19	App\Controller\ProduitController->index (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.56 ms
(5.79%)

SELECT s0_.id AS id_0, s0_.libelle_fr AS libelle_fr_1, s0_.libelle_en AS libelle_en_2, s0_.libelle_es AS libelle_es_3, s0_.est_actif AS est_actif_4, s0_.ordre AS ordre_5, s0_.code_couleur AS code_couleur_6, s0_.image AS image_7, s0_.menu_id AS menu_id_8 FROM sous_menu s0_ INNER JOIN menu m1_ ON s0_.menu_id = m1_.id WHERE m1_.id LIKE ? AND s0_.est_actif = 1 ORDER BY s0_.ordre ASC

Parameters:

[
  "249"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.libelle_fr AS libelle_fr_1,
  s0_.libelle_en AS libelle_en_2,
  s0_.libelle_es AS libelle_es_3,
  s0_.est_actif AS est_actif_4,
  s0_.ordre AS ordre_5,
  s0_.code_couleur AS code_couleur_6,
  s0_.image AS image_7,
  s0_.menu_id AS menu_id_8
FROM
  sous_menu s0_
  INNER JOIN menu m1_ ON s0_.menu_id = m1_.id
WHERE
  m1_.id LIKE ?
  AND s0_.est_actif = 1
ORDER BY
  s0_.ordre ASC

SELECT s0_.id AS id_0, s0_.libelle_fr AS libelle_fr_1, s0_.libelle_en AS libelle_en_2, s0_.libelle_es AS libelle_es_3, s0_.est_actif AS est_actif_4, s0_.ordre AS ordre_5, s0_.code_couleur AS code_couleur_6, s0_.image AS image_7, s0_.menu_id AS menu_id_8 FROM sous_menu s0_ INNER JOIN menu m1_ ON s0_.menu_id = m1_.id WHERE m1_.id LIKE '249' AND s0_.est_actif = 1 ORDER BY s0_.ordre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 63)
7	App\Repository\SousMenuRepository->findAllActifSousMenuFromMenu (line 33)
8	App\Controller\ProduitController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.36 ms
(3.72%)

SELECT m0_.id AS id_0, m0_.libelle_fr AS libelle_fr_1, m0_.libelle_en AS libelle_en_2, m0_.libelle_es AS libelle_es_3, m0_.est_actif AS est_actif_4, m0_.peut_contenir_page AS peut_contenir_page_5, m0_.est_footer AS est_footer_6, m0_.est_affiche AS est_affiche_7, m0_.ordre AS ordre_8, m0_.image AS image_9, m0_.nom_route AS nom_route_10 FROM menu m0_ WHERE m0_.id LIKE ? AND m0_.est_actif = 1 ORDER BY m0_.ordre ASC LIMIT 1

Parameters:

[
  "249"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.libelle_fr AS libelle_fr_1,
  m0_.libelle_en AS libelle_en_2,
  m0_.libelle_es AS libelle_es_3,
  m0_.est_actif AS est_actif_4,
  m0_.peut_contenir_page AS peut_contenir_page_5,
  m0_.est_footer AS est_footer_6,
  m0_.est_affiche AS est_affiche_7,
  m0_.ordre AS ordre_8,
  m0_.image AS image_9,
  m0_.nom_route AS nom_route_10
FROM
  menu m0_
WHERE
  m0_.id LIKE ?
  AND m0_.est_actif = 1
ORDER BY
  m0_.ordre ASC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.libelle_fr AS libelle_fr_1, m0_.libelle_en AS libelle_en_2, m0_.libelle_es AS libelle_es_3, m0_.est_actif AS est_actif_4, m0_.peut_contenir_page AS peut_contenir_page_5, m0_.est_footer AS est_footer_6, m0_.est_affiche AS est_affiche_7, m0_.ordre AS ordre_8, m0_.image AS image_9, m0_.nom_route AS nom_route_10 FROM menu m0_ WHERE m0_.id LIKE '249' AND m0_.est_actif = 1 ORDER BY m0_.ordre ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 41)
7	App\Repository\MenuRepository->getActiveMenuFromID (line 35)
8	App\Controller\ProduitController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
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\Produit	No errors.
App\Entity\SousMenu	No errors.
App\Entity\Tag	No errors.
App\Entity\Menu	No errors.
App\Entity\Page	No errors.
App\Entity\ParametresGlobaux	No errors.

Symfony Profiler

GET https://dev.moulinhoche.com/en/produits

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping