Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.43 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.80 ms
(32.98%)

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog_article b0_ WHERE b0_.published_at <= ?

Parameters:

[
  "2026-02-13 08:06:24"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  blog_article b0_
WHERE
  b0_.published_at <= ?

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog_article b0_ WHERE b0_.published_at <= '2026-02-13 08:06:24';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerCktRQSy\PaginatorProxyBa079e5->paginate (line 26)
16	App\Service\PaginatorService->paginate (line 34)
17	App\Controller\Front\BlogController->blog (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.70 ms
(28.90%)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.intro AS intro_3, b0_.content AS content_4, b0_.published_at AS published_at_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.photo_name AS photo_name_8, b0_.meta_keywords AS meta_keywords_9, b0_.meta_description AS meta_description_10, b0_.content_text AS content_text_11, b0_.category_id AS category_id_12, b0_.created_by_id AS created_by_id_13, b0_.updated_by_id AS updated_by_id_14 FROM blog_article b0_ WHERE b0_.published_at <= ? AND b0_.id IN (?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-02-13 08:06:24"
  1
  2
  3
  4
  5
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.intro AS intro_3,
  b0_.content AS content_4,
  b0_.published_at AS published_at_5,
  b0_.created_at AS created_at_6,
  b0_.updated_at AS updated_at_7,
  b0_.photo_name AS photo_name_8,
  b0_.meta_keywords AS meta_keywords_9,
  b0_.meta_description AS meta_description_10,
  b0_.content_text AS content_text_11,
  b0_.category_id AS category_id_12,
  b0_.created_by_id AS created_by_id_13,
  b0_.updated_by_id AS updated_by_id_14
FROM
  blog_article b0_
WHERE
  b0_.published_at <= ?
  AND b0_.id IN (?, ?, ?, ?, ?, ?)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.intro AS intro_3, b0_.content AS content_4, b0_.published_at AS published_at_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.photo_name AS photo_name_8, b0_.meta_keywords AS meta_keywords_9, b0_.meta_description AS meta_description_10, b0_.content_text AS content_text_11, b0_.category_id AS category_id_12, b0_.created_by_id AS created_by_id_13, b0_.updated_by_id AS updated_by_id_14 FROM blog_article b0_ WHERE b0_.published_at <= '2026-02-13 08:06:24' AND b0_.id IN (1, 2, 3, 4, 5, 6);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerCktRQSy\PaginatorProxyBa079e5->paginate (line 26)
16	App\Service\PaginatorService->paginate (line 34)
17	App\Controller\Front\BlogController->blog (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.47 ms
(19.27%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.created_at AS created_at_7, t0.is_actif AS is_actif_8, t0.mobile AS mobile_9, t0.reference AS reference_10, t0.photo_name AS photo_name_11, t0.updated_at AS updated_at_12, t0.token_password AS token_password_13 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.created_at AS created_at_7,
  t0.is_actif AS is_actif_8,
  t0.mobile AS mobile_9,
  t0.reference AS reference_10,
  t0.photo_name AS photo_name_11,
  t0.updated_at AS updated_at_12,
  t0.token_password AS token_password_13
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.created_at AS created_at_7, t0.is_actif AS is_actif_8, t0.mobile AS mobile_9, t0.reference AS reference_10, t0.photo_name AS photo_name_11, t0.updated_at AS updated_at_12, t0.token_password AS token_password_13 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\User->__get (line 132)
8	App\Entity\User->__toString (line 126)
9	Twig\Runtime\EscaperRuntime->escape (line 182)
10	__TwigTemplate_c20ce160c20ec4f84369c070df8a6d8b->block_body (line 432)
11	Twig\Template->yieldBlock (line 84)
12	__TwigTemplate_beb6c4682ca3a4a000b56989c9748839->doDisplay (line 388)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_c20ce160c20ec4f84369c070df8a6d8b->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 33)
23	App\Controller\Front\BlogController->blog (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.46 ms
(18.86%)

SELECT DISTINCT b0_.id AS id_0 FROM blog_article b0_ WHERE b0_.published_at <= ? LIMIT 6

Parameters:

[
  "2026-02-13 08:06:24"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b0_.id AS id_0
FROM
  blog_article b0_
WHERE
  b0_.published_at <= ?
LIMIT
  6

SELECT DISTINCT b0_.id AS id_0 FROM blog_article b0_ WHERE b0_.published_at <= '2026-02-13 08:06:24' LIMIT 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerCktRQSy\PaginatorProxyBa079e5->paginate (line 26)
16	App\Service\PaginatorService->paginate (line 34)
17	App\Controller\Front\BlogController->blog (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\BlogArticle	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\User	No errors.
App\Entity\BlogTag	No errors.
App\Entity\BlogArticleMeta	No errors.
App\Entity\RecapCommand	No errors.

Symfony Profiler

GET https://test.masterdi.fr/blog/blog.html

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping