Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.27 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.10 ms
(33.54%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.href AS href_4, t0.button AS button_5 FROM slider t0 ORDER BY t0.id 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.caption AS caption_3,
  t0.href AS href_4,
  t0.button AS button_5
FROM
  slider t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.href AS href_4, t0.button AS button_5 FROM slider t0 ORDER BY t0.id 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 34)
5	App\Controller\HomeController->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)

1.88 ms
(29.92%)

SELECT a0_.id AS id_0, a0_.company AS company_1, a0_.category AS category_2, a0_.adress AS adress_3, a0_.box AS box_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.facebook AS facebook_7, a0_.twitter AS twitter_8, a0_.linkedin AS linkedin_9, a0_.date AS date_10, a0_.phones AS phones_11, a0_.slug AS slug_12, a0_.logobig_id AS logobig_id_13, a0_.logosmall_id AS logosmall_id_14, a0_.loyalty_id AS loyalty_id_15 FROM advertiser a0_ INNER JOIN catalog c1_ ON a0_.id = c1_.advertiser_id WHERE ? BETWEEN c1_.dtfrom AND c1_.dtto ORDER BY a0_.company ASC

Parameters:

[
  "2025-12-08 14:03:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.company AS company_1,
  a0_.category AS category_2,
  a0_.adress AS adress_3,
  a0_.box AS box_4,
  a0_.zip AS zip_5,
  a0_.city AS city_6,
  a0_.facebook AS facebook_7,
  a0_.twitter AS twitter_8,
  a0_.linkedin AS linkedin_9,
  a0_.date AS date_10,
  a0_.phones AS phones_11,
  a0_.slug AS slug_12,
  a0_.logobig_id AS logobig_id_13,
  a0_.logosmall_id AS logosmall_id_14,
  a0_.loyalty_id AS loyalty_id_15
FROM
  advertiser a0_
  INNER JOIN catalog c1_ ON a0_.id = c1_.advertiser_id
WHERE
  ? BETWEEN c1_.dtfrom
  AND c1_.dtto
ORDER BY
  a0_.company ASC

SELECT a0_.id AS id_0, a0_.company AS company_1, a0_.category AS category_2, a0_.adress AS adress_3, a0_.box AS box_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.facebook AS facebook_7, a0_.twitter AS twitter_8, a0_.linkedin AS linkedin_9, a0_.date AS date_10, a0_.phones AS phones_11, a0_.slug AS slug_12, a0_.logobig_id AS logobig_id_13, a0_.logosmall_id AS logosmall_id_14, a0_.loyalty_id AS loyalty_id_15 FROM advertiser a0_ INNER JOIN catalog c1_ ON a0_.id = c1_.advertiser_id WHERE '2025-12-08 14:03:59' BETWEEN c1_.dtfrom AND c1_.dtto ORDER BY a0_.company 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 134)
7	App\Repository\AdvertiserRepository->findActive (line 35)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.29 ms
(20.54%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE (c0_.label_code = 0 OR c0_.label_code IS NULL) AND (? BETWEEN c0_.dtfrom AND c0_.dtto) ORDER BY c0_.dtfrom DESC

Parameters:

[
  "2025-12-08 14:03:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.date AS date_2,
  c0_.dtfrom AS dtfrom_3,
  c0_.dtto AS dtto_4,
  c0_.link AS link_5,
  c0_.precedence AS precedence_6,
  c0_.statut AS statut_7,
  c0_.label_code AS label_code_8,
  c0_.label_text AS label_text_9,
  c0_.keywords AS keywords_10,
  c0_.slug AS slug_11,
  c0_.cover_id AS cover_id_12,
  c0_.pdf_id AS pdf_id_13,
  c0_.advertiser_id AS advertiser_id_14
FROM
  catalog c0_
WHERE
  (
    c0_.label_code = 0
    OR c0_.label_code IS NULL
  )
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )
ORDER BY
  c0_.dtfrom DESC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE (c0_.label_code = 0 OR c0_.label_code IS NULL) AND ('2025-12-08 14:03:59' BETWEEN c0_.dtfrom AND c0_.dtto) ORDER BY c0_.dtfrom DESC;

#	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 142)
7	App\Repository\CatalogRepository->findAllActive (line 180)
8	App\Controller\CatalogController->grid (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 327)
16	__TwigTemplate_459e23a58be7e31bd8daebe4b19cbf0b->block_content (line 171)
17	Twig\Template->displayBlock (line 374)
18	__TwigTemplate_cf6e113c8d8894064dd48e7c9b0d9150->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 52)
21	__TwigTemplate_459e23a58be7e31bd8daebe4b19cbf0b->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 39)
30	App\Controller\HomeController->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.00 ms
(16.00%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE c0_.label_code <> 0 AND c0_.label_code IS NOT NULL AND (? BETWEEN c0_.dtfrom AND c0_.dtto) ORDER BY c0_.label_code ASC

Parameters:

[
  "2025-12-08 14:03:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.date AS date_2,
  c0_.dtfrom AS dtfrom_3,
  c0_.dtto AS dtto_4,
  c0_.link AS link_5,
  c0_.precedence AS precedence_6,
  c0_.statut AS statut_7,
  c0_.label_code AS label_code_8,
  c0_.label_text AS label_text_9,
  c0_.keywords AS keywords_10,
  c0_.slug AS slug_11,
  c0_.cover_id AS cover_id_12,
  c0_.pdf_id AS pdf_id_13,
  c0_.advertiser_id AS advertiser_id_14
FROM
  catalog c0_
WHERE
  c0_.label_code <> 0
  AND c0_.label_code IS NOT NULL
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )
ORDER BY
  c0_.label_code ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE c0_.label_code <> 0 AND c0_.label_code IS NOT NULL AND ('2025-12-08 14:03:59' BETWEEN c0_.dtfrom AND c0_.dtto) ORDER BY c0_.label_code 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 154)
7	App\Repository\CatalogRepository->findANPM (line 36)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Slider	No errors.
App\Entity\Advertiser	No errors.
App\Entity\Catalog	No errors.
App\Entity\Image	No errors.
App\Entity\Cover	No errors.
App\Entity\CatalogPdf	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping