Symfony Profiler

Query Metrics

27 Database Queries

8 Different statements

9.65 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.70 ms
(38.27%)

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:

[
  248
]

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

#	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 58)
12	App\Twig\AppExtension->header (line 303)
13	__TwigTemplate_8577221a429931ff639a0d410c71cd50->doDisplay (line 393)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_e7edfb65addb697045150d1e297a69cb->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 67)
24	App\Controller\ProduitController->afficher_produit (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

2.47 ms
(25.55%)

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 27)
12	App\Repository\SousMenuRepository->findAllProductCategory (line 66)
13	App\Controller\ProduitController->afficher_produit (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.84 ms
(8.66%)

SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.libelle_es AS libelle_es_4, t0.est_actif AS est_actif_5, t0.ordre AS ordre_6, t0.code_couleur AS code_couleur_7, t0.image AS image_8, t0.menu_id AS menu_id_9, t10.id AS id_11, t10.contenu_fr AS contenu_fr_12, t10.contenu_en AS contenu_en_13, t10.contenu_es AS contenu_es_14, t10.est_modifiable AS est_modifiable_15, t10.image_fond AS image_fond_16, t10.image_contenu AS image_contenu_17, t10.pdf_fr AS pdf_fr_18, t10.pdf_en AS pdf_en_19, t10.pdf_es AS pdf_es_20, t10.sous_menu_id AS sous_menu_id_21, t10.menu_id AS menu_id_22 FROM sous_menu t0 LEFT JOIN page t10 ON t10.sous_menu_id = t0.id WHERE t0.id = ? LIMIT 1

Parameters:

[
  471
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle_fr AS libelle_fr_2,
  t0.libelle_en AS libelle_en_3,
  t0.libelle_es AS libelle_es_4,
  t0.est_actif AS est_actif_5,
  t0.ordre AS ordre_6,
  t0.code_couleur AS code_couleur_7,
  t0.image AS image_8,
  t0.menu_id AS menu_id_9,
  t10.id AS id_11,
  t10.contenu_fr AS contenu_fr_12,
  t10.contenu_en AS contenu_en_13,
  t10.contenu_es AS contenu_es_14,
  t10.est_modifiable AS est_modifiable_15,
  t10.image_fond AS image_fond_16,
  t10.image_contenu AS image_contenu_17,
  t10.pdf_fr AS pdf_fr_18,
  t10.pdf_en AS pdf_en_19,
  t10.pdf_es AS pdf_es_20,
  t10.sous_menu_id AS sous_menu_id_21,
  t10.menu_id AS menu_id_22
FROM
  sous_menu t0
  LEFT JOIN page t10 ON t10.sous_menu_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.libelle_es AS libelle_es_4, t0.est_actif AS est_actif_5, t0.ordre AS ordre_6, t0.code_couleur AS code_couleur_7, t0.image AS image_8, t0.menu_id AS menu_id_9, t10.id AS id_11, t10.contenu_fr AS contenu_fr_12, t10.contenu_en AS contenu_en_13, t10.contenu_es AS contenu_es_14, t10.est_modifiable AS est_modifiable_15, t10.image_fond AS image_fond_16, t10.image_contenu AS image_contenu_17, t10.pdf_fr AS pdf_fr_18, t10.pdf_en AS pdf_en_19, t10.pdf_es AS pdf_es_20, t10.sous_menu_id AS sous_menu_id_21, t10.menu_id AS menu_id_22 FROM sous_menu t0 LEFT JOIN page t10 ON t10.sous_menu_id = t0.id WHERE t0.id = 471 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 59)
5	App\Controller\ProduitController->afficher_produit (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)

0.75 ms
(7.81%)

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 56)
10	__TwigTemplate_e7edfb65addb697045150d1e297a69cb->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 67)
19	App\Controller\ProduitController->afficher_produit (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.74 ms
(7.70%)

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 56)
10	__TwigTemplate_e7edfb65addb697045150d1e297a69cb->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 67)
19	App\Controller\ProduitController->afficher_produit (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.47 ms
(4.85%)

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_.libelle_fr LIKE ?

Parameters:

[
  "%Nos Produits%"
]

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_.libelle_fr LIKE ?

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_.libelle_fr LIKE '%Nos Produits%';

#	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 27)
7	App\Repository\SousMenuRepository->findAllProductCategory (line 66)
8	App\Controller\ProduitController->afficher_produit (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.39 ms
(4.05%)

SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.libelle_es AS libelle_es_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_es AS description_es_7, t0.est_actif AS est_actif_8, t0.ordre AS ordre_9, t0.sous_menu_id AS sous_menu_id_10, t0.tag_id AS tag_id_11 FROM produit t0 WHERE t0.sous_menu_id = ?

Parameters:

[
  471
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle_fr AS libelle_fr_2,
  t0.libelle_en AS libelle_en_3,
  t0.libelle_es AS libelle_es_4,
  t0.description_fr AS description_fr_5,
  t0.description_en AS description_en_6,
  t0.description_es AS description_es_7,
  t0.est_actif AS est_actif_8,
  t0.ordre AS ordre_9,
  t0.sous_menu_id AS sous_menu_id_10,
  t0.tag_id AS tag_id_11
FROM
  produit t0
WHERE
  t0.sous_menu_id = ?

SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.libelle_es AS libelle_es_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_es AS description_es_7, t0.est_actif AS est_actif_8, t0.ordre AS ordre_9, t0.sous_menu_id AS sous_menu_id_10, t0.tag_id AS tag_id_11 FROM produit t0 WHERE t0.sous_menu_id = 471;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
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 1)
8	iterator_to_array (line 973)
9	Twig\Extension\CoreExtension::sort (line 339)
10	__TwigTemplate_e7edfb65addb697045150d1e297a69cb->block_body (line 437)
11	Twig\Template->yieldBlock (line 561)
12	__TwigTemplate_8577221a429931ff639a0d410c71cd50->doDisplay (line 393)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_e7edfb65addb697045150d1e297a69cb->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 67)
23	App\Controller\ProduitController->afficher_produit (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.30 ms
(3.11%)

SELECT t0.id AS id_1, t0.nom_tag_fr AS nom_tag_fr_2, t0.nom_tag_es AS nom_tag_es_3, t0.nom_tag_en AS nom_tag_en_4 FROM tag t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom_tag_fr AS nom_tag_fr_2,
  t0.nom_tag_es AS nom_tag_es_3,
  t0.nom_tag_en AS nom_tag_en_4
FROM
  tag t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_tag_fr AS nom_tag_fr_2, t0.nom_tag_es AS nom_tag_es_3, t0.nom_tag_en AS nom_tag_en_4 FROM tag t0 WHERE t0.id = 1;

#	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\Tag::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Tag->__get (line 99)
8	App\Entity\Tag->getNomTagEn (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 349)
10	__TwigTemplate_e7edfb65addb697045150d1e297a69cb->block_body (line 437)
11	Twig\Template->yieldBlock (line 561)
12	__TwigTemplate_8577221a429931ff639a0d410c71cd50->doDisplay (line 393)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_e7edfb65addb697045150d1e297a69cb->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 67)
23	App\Controller\ProduitController->afficher_produit (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\SousMenu	No errors.
App\Entity\Menu	No errors.
App\Entity\Page	No errors.
App\Entity\Produit	No errors.
App\Entity\Tag	No errors.
App\Entity\ParametresGlobaux	No errors.

Symfony Profiler

GET http://86.65.9.121/en/produits/categorie/471

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping