Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

12.96 ms Query time

0 Invalid entities

27 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.03 ms
(69.69%)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start_date AS start_date_2, e0_.end_date AS end_date_3, e0_.image AS image_4, e0_.alt_image AS alt_image_5, e0_.link AS link_6 FROM event e0_ WHERE e0_.start_date >= ? ORDER BY e0_.start_date ASC LIMIT 5

Parameters:

[
  "2026-06-03 15:21:24"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.start_date AS start_date_2,
  e0_.end_date AS end_date_3,
  e0_.image AS image_4,
  e0_.alt_image AS alt_image_5,
  e0_.link AS link_6
FROM
  event e0_
WHERE
  e0_.start_date >= ?
ORDER BY
  e0_.start_date ASC
LIMIT
  5

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start_date AS start_date_2, e0_.end_date AS end_date_3, e0_.image AS image_4, e0_.alt_image AS alt_image_5, e0_.link AS link_6 FROM event e0_ WHERE e0_.start_date >= '2026-06-03 15:21:24' ORDER BY e0_.start_date ASC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\EventRepository->orderByDateStartNow (line 27)
7	App\Controller\ArticleController->index (line 17)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.16 ms
(8.94%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.linkmap AS linkmap_6 FROM shop t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.postal_code AS postal_code_4,
  t0.city AS city_5,
  t0.linkmap AS linkmap_6
FROM
  shop t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.linkmap AS linkmap_6 FROM shop t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\ArticleController->index (line 20)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

1.07 ms
(8.27%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.parent_id = ?

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.alt AS alt_5,
  t0.min_price AS min_price_6,
  t0.update_at AS update_at_7,
  t0.title_page AS title_page_8,
  t0.sub_title_page AS sub_title_page_9,
  t0.cite_page AS cite_page_10,
  t0.main_image AS main_image_11,
  t0.main_alt AS main_alt_12,
  t0.second_image AS second_image_13,
  t0.second_alt AS second_alt_14,
  t0.third_image AS third_image_15,
  t0.third_alt AS third_alt_16,
  t0.fourth_image AS fourth_image_17,
  t0.fourth_alt AS fourth_alt_18,
  t0.nb_display AS nb_display_19,
  t0.sort AS sort_20,
  t0.show_sub_categories AS show_sub_categories_21,
  t0.description AS description_22,
  t0.meta_title AS meta_title_23,
  t0.parent_id AS parent_id_24
FROM
  category t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.parent_id = 23;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_7fd2214dc7de902875640c151e913af3->doDisplay (line 107)
8	Twig\Template->yield (line 411)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
16	App\Controller\DefaultController->navbar (line 150)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
20	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
21	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
22	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
23	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
24	__TwigTemplate_62372baa4809c8c57b8ed3566f98e4dd->doDisplay (line 112)
25	Twig\Template->yield (line 411)
26	__TwigTemplate_af54a0b7da9d22e8e87486ef579dc7d2->doDisplay (line 56)
27	Twig\Template->yield (line 411)
28	Twig\Template->display (line 366)
29	Twig\Template->render (line 381)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
35	App\Controller\ArticleController->index (line 26)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 32)
41	require_once (line 5)

0.85 ms
(6.55%)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start_date AS start_date_2, e0_.end_date AS end_date_3, e0_.image AS image_4, e0_.alt_image AS alt_image_5, e0_.link AS link_6 FROM event e0_ WHERE e0_.start_date <= ? AND e0_.end_date >= ? ORDER BY e0_.end_date ASC LIMIT 5

Parameters:

[
  "2026-06-03 15:21:24"
  "2026-06-03 15:21:24"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.start_date AS start_date_2,
  e0_.end_date AS end_date_3,
  e0_.image AS image_4,
  e0_.alt_image AS alt_image_5,
  e0_.link AS link_6
FROM
  event e0_
WHERE
  e0_.start_date <= ?
  AND e0_.end_date >= ?
ORDER BY
  e0_.end_date ASC
LIMIT
  5

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start_date AS start_date_2, e0_.end_date AS end_date_3, e0_.image AS image_4, e0_.alt_image AS alt_image_5, e0_.link AS link_6 FROM event e0_ WHERE e0_.start_date <= '2026-06-03 15:21:24' AND e0_.end_date >= '2026-06-03 15:21:24' ORDER BY e0_.end_date ASC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\EventRepository->findEventInProcess (line 38)
7	App\Controller\ArticleController->index (line 24)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.45 ms
(3.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "Collection MER"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.alt AS alt_5,
  t0.min_price AS min_price_6,
  t0.update_at AS update_at_7,
  t0.title_page AS title_page_8,
  t0.sub_title_page AS sub_title_page_9,
  t0.cite_page AS cite_page_10,
  t0.main_image AS main_image_11,
  t0.main_alt AS main_alt_12,
  t0.second_image AS second_image_13,
  t0.second_alt AS second_alt_14,
  t0.third_image AS third_image_15,
  t0.third_alt AS third_alt_16,
  t0.fourth_image AS fourth_image_17,
  t0.fourth_alt AS fourth_alt_18,
  t0.nb_display AS nb_display_19,
  t0.sort AS sort_20,
  t0.show_sub_categories AS show_sub_categories_21,
  t0.description AS description_22,
  t0.meta_title AS meta_title_23,
  t0.parent_id AS parent_id_24
FROM
  category t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.name = 'Collection MER' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\DefaultController->navbar (line 146)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_62372baa4809c8c57b8ed3566f98e4dd->doDisplay (line 112)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_af54a0b7da9d22e8e87486ef579dc7d2->doDisplay (line 56)
15	Twig\Template->yield (line 411)
16	Twig\Template->display (line 366)
17	Twig\Template->render (line 381)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
23	App\Controller\ArticleController->index (line 26)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.40 ms
(3.09%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.alt AS alt_4, c0_.min_price AS min_price_5, c0_.update_at AS update_at_6, c0_.title_page AS title_page_7, c0_.sub_title_page AS sub_title_page_8, c0_.cite_page AS cite_page_9, c0_.main_image AS main_image_10, c0_.main_alt AS main_alt_11, c0_.second_image AS second_image_12, c0_.second_alt AS second_alt_13, c0_.third_image AS third_image_14, c0_.third_alt AS third_alt_15, c0_.fourth_image AS fourth_image_16, c0_.fourth_alt AS fourth_alt_17, c0_.nb_display AS nb_display_18, c0_.sort AS sort_19, c0_.show_sub_categories AS show_sub_categories_20, c0_.description AS description_21, c0_.meta_title AS meta_title_22, c0_.parent_id AS parent_id_23 FROM category c0_ WHERE c0_.parent_id = ? ORDER BY c0_.nb_display ASC

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.image AS image_3,
  c0_.alt AS alt_4,
  c0_.min_price AS min_price_5,
  c0_.update_at AS update_at_6,
  c0_.title_page AS title_page_7,
  c0_.sub_title_page AS sub_title_page_8,
  c0_.cite_page AS cite_page_9,
  c0_.main_image AS main_image_10,
  c0_.main_alt AS main_alt_11,
  c0_.second_image AS second_image_12,
  c0_.second_alt AS second_alt_13,
  c0_.third_image AS third_image_14,
  c0_.third_alt AS third_alt_15,
  c0_.fourth_image AS fourth_image_16,
  c0_.fourth_alt AS fourth_alt_17,
  c0_.nb_display AS nb_display_18,
  c0_.sort AS sort_19,
  c0_.show_sub_categories AS show_sub_categories_20,
  c0_.description AS description_21,
  c0_.meta_title AS meta_title_22,
  c0_.parent_id AS parent_id_23
FROM
  category c0_
WHERE
  c0_.parent_id = ?
ORDER BY
  c0_.nb_display ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.alt AS alt_4, c0_.min_price AS min_price_5, c0_.update_at AS update_at_6, c0_.title_page AS title_page_7, c0_.sub_title_page AS sub_title_page_8, c0_.cite_page AS cite_page_9, c0_.main_image AS main_image_10, c0_.main_alt AS main_alt_11, c0_.second_image AS second_image_12, c0_.second_alt AS second_alt_13, c0_.third_image AS third_image_14, c0_.third_alt AS third_alt_15, c0_.fourth_image AS fourth_image_16, c0_.fourth_alt AS fourth_alt_17, c0_.nb_display AS nb_display_18, c0_.sort AS sort_19, c0_.show_sub_categories AS show_sub_categories_20, c0_.description AS description_21, c0_.meta_title AS meta_title_22, c0_.parent_id AS parent_id_23 FROM category c0_ WHERE c0_.parent_id = 17 ORDER BY c0_.nb_display ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findSubCategoriesOrderedByNbDisplay (line 31)
7	App\Controller\DefaultController->navbar (line 147)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_62372baa4809c8c57b8ed3566f98e4dd->doDisplay (line 112)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_af54a0b7da9d22e8e87486ef579dc7d2->doDisplay (line 56)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\ArticleController->index (line 26)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Category	22
App\Entity\Shop	5

Entities Mapping

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\Shop	No errors.
App\Entity\Category	No errors.
App\Entity\Product	No errors.

Symfony Profiler

GET http://v2.tussor.net/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CDefaultController%253A%253Anavbar

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping