Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.54 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.48 ms

SELECT COUNT(c0_.id) AS sclr_0 FROM comments c0_ WHERE c0_.is_active = 1 AND c0_.is_moderated = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.is_active = 1
  AND c0_.is_moderated = 0

SELECT COUNT(c0_.id) AS sclr_0 FROM comments c0_ WHERE c0_.is_active = 1 AND c0_.is_moderated = 0;

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 34)
8	App\Service\AdminNotificationService->App\Service\{closure} (line 47)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 96)
10	Symfony\Component\Cache\LockRegistry::compute (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 52)
15	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 26)
16	App\Service\AdminNotificationService->getUnmoderatedCommentsCount (line 73)
17	App\Service\AdminNotificationService->getAdminBadges (line 18)
18	App\Twig\AdminExtension->getGlobals (line 330)
19	Twig\ExtensionSet->getGlobals (line 838)
20	Twig\Environment->getGlobals (line 383)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 35)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 14)
29	App\Controller\StaticPageController->about (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.32 ms

SELECT COUNT(c0_.id) AS sclr_0 FROM comments c0_ WHERE c0_.is_active = 0 AND c0_.is_moderated = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.is_active = 0
  AND c0_.is_moderated = 1

SELECT COUNT(c0_.id) AS sclr_0 FROM comments c0_ WHERE c0_.is_active = 0 AND c0_.is_moderated = 1;

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 51)
8	App\Service\AdminNotificationService->App\Service\{closure} (line 47)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 96)
10	Symfony\Component\Cache\LockRegistry::compute (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 52)
15	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 43)
16	App\Service\AdminNotificationService->getPendingModerationCount (line 74)
17	App\Service\AdminNotificationService->getAdminBadges (line 18)
18	App\Twig\AdminExtension->getGlobals (line 330)
19	Twig\ExtensionSet->getGlobals (line 838)
20	Twig\Environment->getGlobals (line 383)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 35)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 14)
29	App\Controller\StaticPageController->about (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.38 ms

SELECT COUNT(c0_.id) AS sclr_0 FROM comments c0_ WHERE c0_.created_at >= ?

Parameters:

[
  "2026-01-22 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.created_at >= ?

SELECT COUNT(c0_.id) AS sclr_0 FROM comments c0_ WHERE c0_.created_at >= '2026-01-22 00:00:00';

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 93)
8	App\Service\AdminNotificationService->getTodayCommentsCount (line 76)
9	App\Service\AdminNotificationService->getAdminBadges (line 18)
10	App\Twig\AdminExtension->getGlobals (line 330)
11	Twig\ExtensionSet->getGlobals (line 838)
12	Twig\Environment->getGlobals (line 383)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 14)
21	App\Controller\StaticPageController->about (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.36 ms

SELECT COUNT(c0_.id) AS sclr_0 FROM contact_message c0_ WHERE c0_.is_read = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  contact_message c0_
WHERE
  c0_.is_read = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM contact_message c0_ WHERE c0_.is_read = 0;

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 36)
8	App\Repository\ContactMessageRepository->countUnreadMessages (line 77)
9	App\Service\AdminNotificationService->getAdminBadges (line 18)
10	App\Twig\AdminExtension->getGlobals (line 330)
11	Twig\ExtensionSet->getGlobals (line 838)
12	Twig\Environment->getGlobals (line 383)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 14)
21	App\Controller\StaticPageController->about (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\Comment	No errors.
App\Entity\ContactMessage	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://kinkyclub.e-world-france.fr/a-propos

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping