Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.72 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.72 ms
(100.00%)

SELECT c0_.id AS id_0, c0_.caption AS caption_1, c0_.font AS font_2, c0_.picture AS picture_3, c0_.slug AS slug_4, c0_.icon_id AS icon_id_5, c0_.icon2_id AS icon2_id_6, c0_.categorygroup_id AS categorygroup_id_7 FROM category c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.category_id INNER JOIN catalog c1_ ON c1_.id = c2_.catalog_id WHERE ? BETWEEN c1_.dtfrom AND c1_.dtto ORDER BY c0_.caption ASC

Parameters:

[
  "2025-12-09 17:00:11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.caption AS caption_1,
  c0_.font AS font_2,
  c0_.picture AS picture_3,
  c0_.slug AS slug_4,
  c0_.icon_id AS icon_id_5,
  c0_.icon2_id AS icon2_id_6,
  c0_.categorygroup_id AS categorygroup_id_7
FROM
  category c0_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.category_id
  INNER JOIN catalog c1_ ON c1_.id = c2_.catalog_id
WHERE
  ? BETWEEN c1_.dtfrom
  AND c1_.dtto
ORDER BY
  c0_.caption ASC

SELECT c0_.id AS id_0, c0_.caption AS caption_1, c0_.font AS font_2, c0_.picture AS picture_3, c0_.slug AS slug_4, c0_.icon_id AS icon_id_5, c0_.icon2_id AS icon2_id_6, c0_.categorygroup_id AS categorygroup_id_7 FROM category c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.category_id INNER JOIN catalog c1_ ON c1_.id = c2_.catalog_id WHERE '2025-12-09 17:00:11' BETWEEN c1_.dtfrom AND c1_.dtto ORDER BY c0_.caption ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 83)
7	App\Repository\CategoryRepository->findActive (line 64)
8	App\Repository\CategoryRepository->findForFooter (line 17)
9	App\Controller\FooterController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
13	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
14	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
15	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
16	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 428)
17	__TwigTemplate_cf6e113c8d8894064dd48e7c9b0d9150->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 49)
20	__TwigTemplate_170958ff69c746b492db54e9d35a83b1->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
29	App\Controller\UtilsController->perso (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	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\Category	No errors.
App\Entity\Catalog	No errors.
App\Entity\Icon	No errors.
App\Entity\CategoryGroup	No errors.

Symfony Profiler

GET https://test20204.tahitibestpromo.fr/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CFooterController%253A%253Aindex

Configuration Settings

Theme