Symfony Profiler

Query Metrics

63 Database Queries

28 Different statements

47.34 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.45 ms
(22.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.actif AS actif_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id = ? AND t0.actif = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.photo AS photo_3,
  t0.actif AS actif_4,
  t0.description AS description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.link_rewrite AS link_rewrite_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.parent_id = ?
  AND t0.actif = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.actif AS actif_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id = 2 AND t0.actif = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 243)
5	App\Twig\TwigExtension->getSubcategories (line 89)
6	__TwigTemplate_9f3d5b8ede8c2a66727beab60c2c1aea->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 379)
9	Twig\Template->render (line 38)
10	Twig\TemplateWrapper->render (line 280)
11	Twig\Environment->render (line 235)
12	App\Twig\TwigExtension->megaMenuMobileWidget (line 145)
13	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 112)
16	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 48)
19	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 379)
22	Twig\Template->render (line 38)
23	Twig\TemplateWrapper->render (line 280)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
28	App\Controller\Front\PageFrontController->index (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

7.49 ms
(15.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.actif AS actif_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.actif = ? AND t0.parent_id = ?

Parameters:

[
  1
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.photo AS photo_3,
  t0.actif AS actif_4,
  t0.description AS description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.link_rewrite AS link_rewrite_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.actif = ?
  AND t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.actif AS actif_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.actif = 1 AND t0.parent_id = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
5	App\Twig\TwigExtension->generateCategoriesMenu (line 82)
6	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 379)
9	Twig\Template->render (line 38)
10	Twig\TemplateWrapper->render (line 280)
11	Twig\Environment->render (line 159)
12	App\Twig\TwigExtension->megaMenuWidget (line 124)
13	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 112)
16	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 48)
19	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 379)
22	Twig\Template->render (line 38)
23	Twig\TemplateWrapper->render (line 280)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
28	App\Controller\Front\PageFrontController->index (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

3.35 ms
(7.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slides_per_row AS slides_per_row_3, t0.slides_to_show AS slides_to_show_4, t0.actif AS actif_5, t0.page_block_id AS page_block_id_6 FROM module_carousel t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slides_per_row AS slides_per_row_3,
  t0.slides_to_show AS slides_to_show_4,
  t0.actif AS actif_5,
  t0.page_block_id AS page_block_id_6
FROM
  module_carousel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slides_per_row AS slides_per_row_3, t0.slides_to_show AS slides_to_show_4, t0.actif AS actif_5, t0.page_block_id AS page_block_id_6 FROM module_carousel 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 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
6	Proxies\__CG__\App\Entity\ModuleCarousel->__get (line 97)
7	App\Entity\ModuleCarousel->getModuleCarouselItems (line 1635)
8	twig_get_attribute (line 413)
9	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->block_body (line 171)
10	Twig\Template->displayBlock (line 118)
11	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 48)
14	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 280)
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 62)
23	App\Controller\Front\PageFrontController->index (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)

3.31 ms
(6.99%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.position AS position_5, t0.module_carousel_id AS module_carousel_id_6 FROM module_carousel_item t0 WHERE t0.module_carousel_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.title AS title_3,
  t0.subtitle AS subtitle_4,
  t0.position AS position_5,
  t0.module_carousel_id AS module_carousel_id_6
FROM
  module_carousel_item t0
WHERE
  t0.module_carousel_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.position AS position_5, t0.module_carousel_id AS module_carousel_id_6 FROM module_carousel_item t0 WHERE t0.module_carousel_id = 4;

#	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 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 413)
10	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->block_body (line 171)
11	Twig\Template->displayBlock (line 118)
12	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 48)
15	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
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 62)
24	App\Controller\Front\PageFrontController->index (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.65 ms
(5.61%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.actif AS actif_3,
  t0.modele AS modele_4,
  t0.description AS description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.link_rewrite AS link_rewrite_8,
  t0.ecoresponsable AS ecoresponsable_9,
  t0.fichetechnique AS fichetechnique_10,
  t0.date_add AS date_add_11,
  t0.date_upd AS date_upd_12,
  t0.crit_air AS crit_air_13,
  t0.category_id AS category_id_14,
  t0.marque_id AS marque_id_15
FROM
  product t0
WHERE
  t0.category_id IN (?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (10, 11, 14);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
8	Doctrine\ORM\EntityRepository->findBy (line 72)
9	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
10	App\Twig\TwigExtension->generateCategoriesMenu (line 162)
11	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 159)
17	App\Twig\TwigExtension->megaMenuWidget (line 124)
18	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 112)
21	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 48)
24	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 379)
27	Twig\Template->render (line 38)
28	Twig\TemplateWrapper->render (line 280)
29	Twig\Environment->render (line 448)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
33	App\Controller\Front\PageFrontController->index (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

1.95 ms
(4.13%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?)

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.actif AS actif_3,
  t0.modele AS modele_4,
  t0.description AS description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.link_rewrite AS link_rewrite_8,
  t0.ecoresponsable AS ecoresponsable_9,
  t0.fichetechnique AS fichetechnique_10,
  t0.date_add AS date_add_11,
  t0.date_upd AS date_upd_12,
  t0.crit_air AS crit_air_13,
  t0.category_id AS category_id_14,
  t0.marque_id AS marque_id_15
FROM
  product t0
WHERE
  t0.category_id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 742)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
9	Doctrine\ORM\EntityManager->find (line 86)
10	Doctrine\ORM\EntityRepository->find (line 60)
11	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 84)
12	App\Service\MegaMenuService->getUrlById (line 64)
13	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 159)
19	App\Twig\TwigExtension->megaMenuWidget (line 124)
20	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 112)
23	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 48)
26	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 379)
29	Twig\Template->render (line 38)
30	Twig\TemplateWrapper->render (line 280)
31	Twig\Environment->render (line 448)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
35	App\Controller\Front\PageFrontController->index (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

1.82 ms
(3.83%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.link_rewrite AS link_rewrite_5, t0.actif AS actif_6, t0.subtitle AS subtitle_7, t0.video_youtube_link AS video_youtube_link_8 FROM PAGE t0 WHERE t0.id = ?

Parameters:

[
  "6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.link_rewrite AS link_rewrite_5,
  t0.actif AS actif_6,
  t0.subtitle AS subtitle_7,
  t0.video_youtube_link AS video_youtube_link_8
FROM
  PAGE t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.link_rewrite AS link_rewrite_5, t0.actif AS actif_6, t0.subtitle AS subtitle_7, t0.video_youtube_link AS video_youtube_link_8 FROM PAGE t0 WHERE t0.id = '6';

#	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 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 90)
7	App\Service\MegaMenuService->getUrlById (line 64)
8	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 280)
13	Twig\Environment->render (line 159)
14	App\Twig\TwigExtension->megaMenuWidget (line 124)
15	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 112)
18	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 48)
21	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 379)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 280)
26	Twig\Environment->render (line 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
30	App\Controller\Front\PageFrontController->index (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

1.78 ms
(3.75%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.cover AS cover_3,
  t0.product_id AS product_id_4
FROM
  image t0
WHERE
  t0.product_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (2, 3, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
10	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
13	Doctrine\ORM\EntityRepository->findBy (line 72)
14	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
15	App\Twig\TwigExtension->generateCategoriesMenu (line 162)
16	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 159)
22	App\Twig\TwigExtension->megaMenuWidget (line 124)
23	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 112)
26	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 48)
29	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 379)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 280)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
38	App\Controller\Front\PageFrontController->index (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 5)

1.36 ms
(2.88%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.actif AS actif_3,
  t0.modele AS modele_4,
  t0.description AS description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.link_rewrite AS link_rewrite_8,
  t0.ecoresponsable AS ecoresponsable_9,
  t0.fichetechnique AS fichetechnique_10,
  t0.date_add AS date_add_11,
  t0.date_upd AS date_upd_12,
  t0.crit_air AS crit_air_13,
  t0.category_id AS category_id_14,
  t0.marque_id AS marque_id_15
FROM
  product t0
WHERE
  t0.category_id IN (?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (26, 28, 61, 63);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
8	Doctrine\ORM\EntityRepository->findBy (line 72)
9	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
10	App\Twig\TwigExtension->generateCategoriesMenu (line 162)
11	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 159)
17	App\Twig\TwigExtension->megaMenuWidget (line 124)
18	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 112)
21	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 48)
24	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 379)
27	Twig\Template->render (line 38)
28	Twig\TemplateWrapper->render (line 280)
29	Twig\Environment->render (line 448)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
33	App\Controller\Front\PageFrontController->index (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

1.35 ms
(2.86%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.actif AS actif_3,
  t0.modele AS modele_4,
  t0.description AS description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.link_rewrite AS link_rewrite_8,
  t0.ecoresponsable AS ecoresponsable_9,
  t0.fichetechnique AS fichetechnique_10,
  t0.date_add AS date_add_11,
  t0.date_upd AS date_upd_12,
  t0.crit_air AS crit_air_13,
  t0.category_id AS category_id_14,
  t0.marque_id AS marque_id_15
FROM
  product t0
WHERE
  t0.category_id IN (?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (2, 6);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
8	Doctrine\ORM\EntityRepository->findBy (line 72)
9	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
10	App\Twig\TwigExtension->generateCategoriesMenu (line 82)
11	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 159)
17	App\Twig\TwigExtension->megaMenuWidget (line 124)
18	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 112)
21	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 48)
24	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 379)
27	Twig\Template->render (line 38)
28	Twig\TemplateWrapper->render (line 280)
29	Twig\Environment->render (line 448)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
33	App\Controller\Front\PageFrontController->index (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

1.08 ms
(2.29%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_href AS custom_href_3, t0.type AS type_4, t0.target AS target_5, t0.position AS position_6 FROM mega_menu t0 ORDER BY t0.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.custom_href AS custom_href_3,
  t0.type AS type_4,
  t0.target AS target_5,
  t0.position AS position_6
FROM
  mega_menu t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_href AS custom_href_3, t0.type AS type_4, t0.target AS target_5, t0.position AS position_6 FROM mega_menu t0 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 157)
5	App\Twig\TwigExtension->megaMenuWidget (line 124)
6	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 112)
9	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 48)
12	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 379)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 280)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
21	App\Controller\Front\PageFrontController->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)

0.87 ms
(1.83%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_href AS custom_href_3, t0.type AS type_4, t0.target AS target_5, t0.position AS position_6, t0.emplacement AS emplacement_7 FROM menu_footer t0 WHERE t0.emplacement = ? ORDER BY t0.position ASC

Parameters:

[
  "menu_gauche"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.custom_href AS custom_href_3,
  t0.type AS type_4,
  t0.target AS target_5,
  t0.position AS position_6,
  t0.emplacement AS emplacement_7
FROM
  menu_footer t0
WHERE
  t0.emplacement = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_href AS custom_href_3, t0.type AS type_4, t0.target AS target_5, t0.position AS position_6, t0.emplacement AS emplacement_7 FROM menu_footer t0 WHERE t0.emplacement = 'menu_gauche' ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 224)
5	App\Twig\TwigExtension->menuFooterWidget (line 61)
6	__TwigTemplate_2fa8be2d988751ff714fdcf541b1945c->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 121)
9	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 48)
12	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 379)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 280)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
21	App\Controller\Front\PageFrontController->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)

0.74 ms
(1.56%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.cover AS cover_3,
  t0.product_id AS product_id_4
FROM
  image t0
WHERE
  t0.product_id IN (?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (30, 31, 32, 33, 34);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
10	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
13	Doctrine\ORM\EntityRepository->findBy (line 72)
14	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
15	App\Twig\TwigExtension->generateCategoriesMenu (line 162)
16	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 159)
22	App\Twig\TwigExtension->megaMenuWidget (line 124)
23	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 112)
26	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 48)
29	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 379)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 280)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
38	App\Controller\Front\PageFrontController->index (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 5)

0.73 ms
(1.53%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.link_rewrite AS link_rewrite_5, t0.actif AS actif_6, t0.subtitle AS subtitle_7, t0.video_youtube_link AS video_youtube_link_8 FROM PAGE t0 WHERE t0.actif = ? AND t0.id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.link_rewrite AS link_rewrite_5,
  t0.actif AS actif_6,
  t0.subtitle AS subtitle_7,
  t0.video_youtube_link AS video_youtube_link_8
FROM
  PAGE t0
WHERE
  t0.actif = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.link_rewrite AS link_rewrite_5, t0.actif AS actif_6, t0.subtitle AS subtitle_7, t0.video_youtube_link AS video_youtube_link_8 FROM PAGE t0 WHERE t0.actif = 1 AND t0.id = 1 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 25)
5	App\Controller\Front\PageFrontController->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)

0.69 ms
(1.46%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.actif AS actif_3,
  t0.modele AS modele_4,
  t0.description AS description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.link_rewrite AS link_rewrite_8,
  t0.ecoresponsable AS ecoresponsable_9,
  t0.fichetechnique AS fichetechnique_10,
  t0.date_add AS date_add_11,
  t0.date_upd AS date_upd_12,
  t0.crit_air AS crit_air_13,
  t0.category_id AS category_id_14,
  t0.marque_id AS marque_id_15
FROM
  product t0
WHERE
  t0.category_id IN (?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (7, 8, 9, 20, 24, 29);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
8	Doctrine\ORM\EntityRepository->findBy (line 72)
9	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
10	App\Twig\TwigExtension->generateCategoriesMenu (line 132)
11	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 159)
17	App\Twig\TwigExtension->megaMenuWidget (line 124)
18	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 112)
21	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 48)
24	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 379)
27	Twig\Template->render (line 38)
28	Twig\TemplateWrapper->render (line 280)
29	Twig\Environment->render (line 448)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
33	App\Controller\Front\PageFrontController->index (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

0.68 ms
(1.44%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.lien_title AS lien_title_3, t0.sub_title AS sub_title_4, t0.content AS content_5, t0.image_one AS image_one_6, t0.image_position AS image_position_7, t0.position AS position_8, t0.image_one_width AS image_one_width_9, t0.image_one_height AS image_one_height_10, t0.img_class AS img_class_11, t0.row_class AS row_class_12, t0.container_class AS container_class_13, t0.section_class AS section_class_14, t0.title_align AS title_align_15, t0.image_mode AS image_mode_16, t0.page_id AS page_id_17, t0.module_history_timeline_id AS module_history_timeline_id_18, t0.module_carousel_id AS module_carousel_id_19 FROM page_block t0 WHERE t0.page_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lien_title AS lien_title_3,
  t0.sub_title AS sub_title_4,
  t0.content AS content_5,
  t0.image_one AS image_one_6,
  t0.image_position AS image_position_7,
  t0.position AS position_8,
  t0.image_one_width AS image_one_width_9,
  t0.image_one_height AS image_one_height_10,
  t0.img_class AS img_class_11,
  t0.row_class AS row_class_12,
  t0.container_class AS container_class_13,
  t0.section_class AS section_class_14,
  t0.title_align AS title_align_15,
  t0.image_mode AS image_mode_16,
  t0.page_id AS page_id_17,
  t0.module_history_timeline_id AS module_history_timeline_id_18,
  t0.module_carousel_id AS module_carousel_id_19
FROM
  page_block t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.lien_title AS lien_title_3, t0.sub_title AS sub_title_4, t0.content AS content_5, t0.image_one AS image_one_6, t0.image_position AS image_position_7, t0.position AS position_8, t0.image_one_width AS image_one_width_9, t0.image_one_height AS image_one_height_10, t0.img_class AS img_class_11, t0.row_class AS row_class_12, t0.container_class AS container_class_13, t0.section_class AS section_class_14, t0.title_align AS title_align_15, t0.image_mode AS image_mode_16, t0.page_id AS page_id_17, t0.module_history_timeline_id AS module_history_timeline_id_18, t0.module_carousel_id AS module_carousel_id_19 FROM page_block t0 WHERE t0.page_id = 1 ORDER BY t0.position ASC;

#	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 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 145)
10	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->block_body (line 171)
11	Twig\Template->displayBlock (line 118)
12	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 48)
15	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
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 62)
24	App\Controller\Front\PageFrontController->index (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)

0.65 ms
(1.38%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.cover AS cover_3,
  t0.product_id AS product_id_4
FROM
  image t0
WHERE
  t0.product_id IN (?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (35, 36, 37, 38, 39, 40, 41);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
10	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
13	Doctrine\ORM\EntityRepository->findBy (line 72)
14	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
15	App\Twig\TwigExtension->generateCategoriesMenu (line 162)
16	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 159)
22	App\Twig\TwigExtension->megaMenuWidget (line 124)
23	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 112)
26	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 48)
29	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 379)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 280)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
38	App\Controller\Front\PageFrontController->index (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 5)

0.65 ms
(1.36%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.cover AS cover_3,
  t0.product_id AS product_id_4
FROM
  image t0
WHERE
  t0.product_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
10	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
13	Doctrine\ORM\EntityRepository->findBy (line 72)
14	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
15	App\Twig\TwigExtension->generateCategoriesMenu (line 162)
16	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 159)
22	App\Twig\TwigExtension->megaMenuWidget (line 124)
23	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 112)
26	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 48)
29	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 379)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 280)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
38	App\Controller\Front\PageFrontController->index (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 5)

0.64 ms
(1.36%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.actif AS actif_3,
  t0.modele AS modele_4,
  t0.description AS description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.link_rewrite AS link_rewrite_8,
  t0.ecoresponsable AS ecoresponsable_9,
  t0.fichetechnique AS fichetechnique_10,
  t0.date_add AS date_add_11,
  t0.date_upd AS date_upd_12,
  t0.crit_air AS crit_air_13,
  t0.category_id AS category_id_14,
  t0.marque_id AS marque_id_15
FROM
  product t0
WHERE
  t0.category_id IN (?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (56, 57, 58, 59, 60);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
8	Doctrine\ORM\EntityRepository->findBy (line 72)
9	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
10	App\Twig\TwigExtension->generateCategoriesMenu (line 162)
11	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 159)
17	App\Twig\TwigExtension->megaMenuWidget (line 124)
18	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 112)
21	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 48)
24	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 379)
27	Twig\Template->render (line 38)
28	Twig\TemplateWrapper->render (line 280)
29	Twig\Environment->render (line 448)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
33	App\Controller\Front\PageFrontController->index (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

0.64 ms
(1.36%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.cover AS cover_3,
  t0.product_id AS product_id_4
FROM
  image t0
WHERE
  t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (72, 122, 73, 74, 75, 123, 76, 77);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
10	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
13	Doctrine\ORM\EntityRepository->findBy (line 72)
14	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
15	App\Twig\TwigExtension->generateCategoriesMenu (line 162)
16	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 159)
22	App\Twig\TwigExtension->megaMenuWidget (line 124)
23	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 112)
26	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 48)
29	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 379)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 280)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
38	App\Controller\Front\PageFrontController->index (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 5)

0.63 ms
(1.34%)

SELECT t0.id AS id_1, t0.nom_client AS nom_client_2, t0.entreprise AS entreprise_3, t0.stars AS stars_4, t0.comment AS comment_5, t0.image_client AS image_client_6, t0.status AS status_7 FROM avis_client t0 WHERE t0.status = ? ORDER BY t0.id DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom_client AS nom_client_2,
  t0.entreprise AS entreprise_3,
  t0.stars AS stars_4,
  t0.comment AS comment_5,
  t0.image_client AS image_client_6,
  t0.status AS status_7
FROM
  avis_client t0
WHERE
  t0.status = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.nom_client AS nom_client_2, t0.entreprise AS entreprise_3, t0.stars AS stars_4, t0.comment AS comment_5, t0.image_client AS image_client_6, t0.status AS status_7 FROM avis_client t0 WHERE t0.status = 1 ORDER BY t0.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 273)
5	App\Twig\TwigExtension->getReviewSilder (line 47)
6	__TwigTemplate_82b32fb08afc02b6a6ef83947b15c4de->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 673)
9	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->block_body (line 171)
10	Twig\Template->displayBlock (line 118)
11	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 48)
14	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 280)
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 62)
23	App\Controller\Front\PageFrontController->index (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.62 ms
(1.31%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.cover AS cover_3,
  t0.product_id AS product_id_4
FROM
  image t0
WHERE
  t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
10	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
13	Doctrine\ORM\EntityRepository->findBy (line 72)
14	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
15	App\Twig\TwigExtension->generateCategoriesMenu (line 162)
16	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 159)
22	App\Twig\TwigExtension->megaMenuWidget (line 124)
23	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 112)
26	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 48)
29	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 379)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 280)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
38	App\Controller\Front\PageFrontController->index (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 5)

0.58 ms
(1.24%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.icon AS icon_4, t0.annee AS annee_5, t0.position AS position_6, t0.module_history_timeline_id AS module_history_timeline_id_7 FROM module_history_timeline_item t0 WHERE t0.module_history_timeline_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.subtitle AS subtitle_3,
  t0.icon AS icon_4,
  t0.annee AS annee_5,
  t0.position AS position_6,
  t0.module_history_timeline_id AS module_history_timeline_id_7
FROM
  module_history_timeline_item t0
WHERE
  t0.module_history_timeline_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.icon AS icon_4, t0.annee AS annee_5, t0.position AS position_6, t0.module_history_timeline_id AS module_history_timeline_id_7 FROM module_history_timeline_item t0 WHERE t0.module_history_timeline_id = 7;

#	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 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 457)
10	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->block_body (line 171)
11	Twig\Template->displayBlock (line 118)
12	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 48)
15	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
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 62)
24	App\Controller\Front\PageFrontController->index (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)

0.58 ms
(1.22%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.actif AS actif_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.photo AS photo_3,
  t0.actif AS actif_4,
  t0.description AS description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.link_rewrite AS link_rewrite_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.actif AS actif_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.parent_id AS parent_id_9 FROM category 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 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 84)
7	App\Service\MegaMenuService->getUrlById (line 64)
8	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 280)
13	Twig\Environment->render (line 159)
14	App\Twig\TwigExtension->megaMenuWidget (line 124)
15	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 112)
18	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 48)
21	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 379)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 280)
26	Twig\Environment->render (line 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
30	App\Controller\Front\PageFrontController->index (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.53 ms
(1.13%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.cover AS cover_3,
  t0.product_id AS product_id_4
FROM
  image t0
WHERE
  t0.product_id IN (?, ?)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (124, 126);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
10	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
13	Doctrine\ORM\EntityRepository->findBy (line 72)
14	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
15	App\Twig\TwigExtension->generateCategoriesMenu (line 82)
16	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 159)
22	App\Twig\TwigExtension->megaMenuWidget (line 124)
23	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 112)
26	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 48)
29	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 379)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 280)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
38	App\Controller\Front\PageFrontController->index (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 5)

0.52 ms
(1.09%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.cover AS cover_3,
  t0.product_id AS product_id_4
FROM
  image t0
WHERE
  t0.product_id IN (?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (102, 103, 104, 105, 106, 107);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
10	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
13	Doctrine\ORM\EntityRepository->findBy (line 72)
14	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
15	App\Twig\TwigExtension->generateCategoriesMenu (line 162)
16	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 159)
22	App\Twig\TwigExtension->megaMenuWidget (line 124)
23	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 112)
26	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 48)
29	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 379)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 280)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
38	App\Controller\Front\PageFrontController->index (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 5)

0.50 ms
(1.05%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.type_affichage AS type_affichage_4 FROM module_history_timeline t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.actif AS actif_3,
  t0.type_affichage AS type_affichage_4
FROM
  module_history_timeline t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.type_affichage AS type_affichage_4 FROM module_history_timeline t0 WHERE t0.id = 7;

#	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 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
6	Proxies\__CG__\App\Entity\ModuleHistoryTimeline->__get (line 85)
7	App\Entity\ModuleHistoryTimeline->getModuleHistoryTimelineItem (line 1635)
8	twig_get_attribute (line 457)
9	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->block_body (line 171)
10	Twig\Template->displayBlock (line 118)
11	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 48)
14	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 280)
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 62)
23	App\Controller\Front\PageFrontController->index (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.50 ms
(1.05%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.cover AS cover_3,
  t0.product_id AS product_id_4
FROM
  image t0
WHERE
  t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (64, 65, 66, 67, 68, 69, 63, 70, 71);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
10	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
13	Doctrine\ORM\EntityRepository->findBy (line 72)
14	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 103)
15	App\Twig\TwigExtension->generateCategoriesMenu (line 162)
16	__TwigTemplate_8f6460cb1be26546aafa1b804999beda->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 159)
22	App\Twig\TwigExtension->megaMenuWidget (line 124)
23	__TwigTemplate_4a287fa37b118a5518a7eb5f7475f4ed->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 112)
26	__TwigTemplate_be3630a72d563dcf1723e6126d03cb71->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 48)
29	__TwigTemplate_2369a3885e9e0ed556afccab60516f6b->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 379)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 280)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
38	App\Controller\Front\PageFrontController->index (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	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\Page	No errors.
App\Entity\PageBlock	No errors.
App\Entity\MegaMenu	No errors.
App\Entity\Category	No errors.
App\Entity\Product	No errors.
App\Entity\Caracteristique	The mappings App\Entity\Caracteristique#filters and App\Entity\Filters#caracteristique are inconsistent with each other.
App\Entity\Agence	No errors.
App\Entity\Marque	No errors.
App\Entity\Image	No errors.
App\Entity\CaracteristiqueProduct	No errors.
App\Entity\ProductBlocAvantage	No errors.
App\Entity\ProductAssocie	No errors.
App\Entity\QuizReponse	No errors.
App\Entity\Devis	No errors.
App\Entity\TrendingMachine	No errors.
App\Entity\ModuleHistoryTimeline	No errors.
App\Entity\ModuleCarousel	The field App\Entity\ModuleCarousel#pageBlock is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\PageBlock#ModuleCarousel does not contain the required 'mappedBy="pageBlock"' attribute. If association App\Entity\ModuleCarousel#pageBlock is many-to-one, then the inversed side App\Entity\PageBlock#ModuleCarousel has to be one-to-many.
App\Entity\ModuleHistoryTimelineItem	No errors.
App\Entity\ModuleCarouselItem	No errors.
App\Entity\AvisClient	No errors.
App\Entity\MenuFooter	No errors.

Symfony Profiler

GET https://locamod-preprod.kwantic.fr/page/1-decouvrir-locamod

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping