Symfony Profiler

Query Metrics

33 Database Queries

14 Different statements

428.11 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

149.49 ms
(34.92%)

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(h0_.hits) AS sclr_0,
  SUM(h0_.unique_views) AS sclr_1
FROM
  hit_counter h0_

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_;

#	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 80)
7	App\Service\HitCounterService->App\Service\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 71)
15	App\Service\HitCounterService->getHitCounter (line 109)
16	App\Twig\Runtime\AppExtensionRuntime->getHitCounter (line 259)
17	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
18	Twig\Template->yield (line 56)
19	__TwigTemplate_c337972ae3890df9539d3ad8b94b204e->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
28	App\Controller\Website2Controller->categoryIndex (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

134.95 ms
(31.52%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.uri AS uri_3, t0.date AS date_4, t0.hits AS hits_5, t0.unique_views AS unique_views_6, t0.mime_type AS mime_type_7, t0.language_id AS language_id_8 FROM hit_counter t0 WHERE t0.path = ? AND t0.date = ? AND t0.language_id = ? LIMIT 1

Parameters:

[
  "/hi/index/categories"
  "2026-03-24"
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.uri AS uri_3,
  t0.date AS date_4,
  t0.hits AS hits_5,
  t0.unique_views AS unique_views_6,
  t0.mime_type AS mime_type_7,
  t0.language_id AS language_id_8
FROM
  hit_counter t0
WHERE
  t0.path = ?
  AND t0.date = ?
  AND t0.language_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.path AS path_2, t0.uri AS uri_3, t0.date AS date_4, t0.hits AS hits_5, t0.unique_views AS unique_views_6, t0.mime_type AS mime_type_7, t0.language_id AS language_id_8 FROM hit_counter t0 WHERE t0.path = '/hi/index/categories' AND t0.date = '2026-03-24' AND t0.language_id = 3 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 36)
5	App\MessageHandler\RecordHitMessageHandler->__invoke (line 152)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
7	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
8	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 61)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
13	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
14	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
15	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 54)
16	Symfony\Component\Messenger\RoutableMessageBus->dispatch (line 58)
17	Symfony\Component\Messenger\Transport\Sync\SyncTransport->send (line 62)
18	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
19	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
20	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
21	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
22	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
23	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
24	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
25	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 56)
26	App\Service\HitCounterService->record (line 47)
27	App\EventSubscriber\HitCounterSubscriber->onKernelRequest (line 116)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

86.12 ms
(20.12%)

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_ WHERE h0_.date = ?

Parameters:

[
  "2026-03-24 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(h0_.hits) AS sclr_0,
  SUM(h0_.unique_views) AS sclr_1
FROM
  hit_counter h0_
WHERE
  h0_.date = ?

SELECT SUM(h0_.hits) AS sclr_0, SUM(h0_.unique_views) AS sclr_1 FROM hit_counter h0_ WHERE h0_.date = '2026-03-24 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 87)
7	App\Service\HitCounterService->App\Service\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 71)
15	App\Service\HitCounterService->getHitCounter (line 109)
16	App\Twig\Runtime\AppExtensionRuntime->getHitCounter (line 259)
17	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
18	Twig\Template->yield (line 56)
19	__TwigTemplate_c337972ae3890df9539d3ad8b94b204e->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
28	App\Controller\Website2Controller->categoryIndex (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

36.69 ms
(8.57%)

SELECT n0_.id AS id_0, n0_.news_id AS news_id_1, n0_.title AS title_2, n0_.publish_date AS publish_date_3 FROM news n0_ WHERE n0_.category_id = ? AND n0_.language_id = ? AND n0_.status = ? ORDER BY n0_.publish_date DESC LIMIT 5

Parameters:

[
  2081
  3
  "a"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.news_id AS news_id_1,
  n0_.title AS title_2,
  n0_.publish_date AS publish_date_3
FROM
  news n0_
WHERE
  n0_.category_id = ?
  AND n0_.language_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.publish_date DESC
LIMIT
  5

SELECT n0_.id AS id_0, n0_.news_id AS news_id_1, n0_.title AS title_2, n0_.publish_date AS publish_date_3 FROM news n0_ WHERE n0_.category_id = 2081 AND n0_.language_id = 3 AND n0_.status = 'a' ORDER BY n0_.publish_date DESC LIMIT 5;

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 60)
7	App\Controller\Website2Controller->categoryIndex (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

6.36 ms
(1.49%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso AS iso_4, t0.color AS color_5, t0.domain AS domain_6, t0.name_in_language AS name_in_language_7, t0.writing_direction AS writing_direction_8, t0.time_zone AS time_zone_9 FROM language t0 WHERE t0.iso = ? LIMIT 1

Parameters:

[
  "hi"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso AS iso_4,
  t0.color AS color_5,
  t0.domain AS domain_6,
  t0.name_in_language AS name_in_language_7,
  t0.writing_direction AS writing_direction_8,
  t0.time_zone AS time_zone_9
FROM
  language t0
WHERE
  t0.iso = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.iso AS iso_4, t0.color AS color_5, t0.domain AS domain_6, t0.name_in_language AS name_in_language_7, t0.writing_direction AS writing_direction_8, t0.time_zone AS time_zone_9 FROM language t0 WHERE t0.iso = 'hi' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 44)
5	App\EventSubscriber\HitCounterSubscriber->onKernelRequest (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

4.01 ms
(0.94%)

SELECT COUNT(*) FROM category t0 WHERE t0.slug = ?

Parameters:

[
  "teknolaji"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  category t0
WHERE
  t0.slug = ?

SELECT COUNT(*) FROM category t0 WHERE t0.slug = 'teknolaji';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 865)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 140)
3	Doctrine\ORM\EntityRepository->count (line 86)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 78)
5	App\Service\SlugService->slugExists (line 50)
6	App\Service\SlugService->createUniqueSlug (line 259)
7	App\Twig\Runtime\AppExtensionRuntime->createSlug (line 594)
8	__TwigTemplate_cc808ae27b3a6f5f189f75ee57fae35e->doDisplay (line 387)
9	Twig\Template->yield (line 343)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 320)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 354)
17	App\Controller\WebsiteController->header (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
21	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
22	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
23	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
24	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 176)
25	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
26	Twig\Template->yield (line 56)
27	__TwigTemplate_c337972ae3890df9539d3ad8b94b204e->doDisplay (line 387)
28	Twig\Template->yield (line 343)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 51)
31	Twig\TemplateWrapper->render (line 320)
32	Twig\Environment->render (line 448)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
36	App\Controller\Website2Controller->categoryIndex (line 181)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

3.35 ms
(0.78%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 59)
4	App\MessageHandler\RecordHitMessageHandler->__invoke (line 152)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 61)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 54)
15	Symfony\Component\Messenger\RoutableMessageBus->dispatch (line 58)
16	Symfony\Component\Messenger\Transport\Sync\SyncTransport->send (line 62)
17	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
18	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
19	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
20	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
21	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
22	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
23	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
24	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 56)
25	App\Service\HitCounterService->record (line 47)
26	App\EventSubscriber\HitCounterSubscriber->onKernelRequest (line 116)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
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.47 ms
(0.34%)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.active AS active_2, l0_.iso AS iso_3, l0_.color AS color_4, l0_.domain AS domain_5, l0_.name_in_language AS name_in_language_6, l0_.writing_direction AS writing_direction_7, l0_.time_zone AS time_zone_8 FROM language l0_ ORDER BY l0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.active AS active_2,
  l0_.iso AS iso_3,
  l0_.color AS color_4,
  l0_.domain AS domain_5,
  l0_.name_in_language AS name_in_language_6,
  l0_.writing_direction AS writing_direction_7,
  l0_.time_zone AS time_zone_8
FROM
  language l0_
ORDER BY
  l0_.name ASC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.active AS active_2, l0_.iso AS iso_3, l0_.color AS color_4, l0_.domain AS domain_5, l0_.name_in_language AS name_in_language_6, l0_.writing_direction AS writing_direction_7, l0_.time_zone AS time_zone_8 FROM language l0_ ORDER BY l0_.name ASC;

#	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 23)
7	App\Controller\Website2Controller->categoryIndex (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.13 ms
(0.26%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c0_.language_id AS language_id_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.language_id = ? AND c0_.active = ? ORDER BY c0_.sorting_rank ASC, c0_.name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.slug AS slug_3,
  c0_.sorting_rank AS sorting_rank_4,
  c0_.language_id AS language_id_5,
  c0_.parent_id AS parent_id_6
FROM
  category c0_
WHERE
  c0_.language_id = ?
  AND c0_.active = ?
ORDER BY
  c0_.sorting_rank ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c0_.language_id AS language_id_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.language_id = 3 AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c0_.name ASC;

#	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 43)
7	App\Controller\Website2Controller->categoryIndex (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.11 ms
(0.26%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c1_.id AS id_5, c1_.name AS name_6, c1_.active AS active_7, c1_.slug AS slug_8, c1_.sorting_rank AS sorting_rank_9, c0_.language_id AS language_id_10, c0_.parent_id AS parent_id_11, c1_.language_id AS language_id_12, c1_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id AND (c1_.active = 1) WHERE c0_.language_id = ? AND c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c1_.sorting_rank ASC, c1_.name ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.slug AS slug_3,
  c0_.sorting_rank AS sorting_rank_4,
  c1_.id AS id_5,
  c1_.name AS name_6,
  c1_.active AS active_7,
  c1_.slug AS slug_8,
  c1_.sorting_rank AS sorting_rank_9,
  c0_.language_id AS language_id_10,
  c0_.parent_id AS parent_id_11,
  c1_.language_id AS language_id_12,
  c1_.parent_id AS parent_id_13
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.parent_id
  AND (c1_.active = 1)
WHERE
  c0_.language_id = ?
  AND c0_.parent_id IS NULL
  AND c0_.active = 1
ORDER BY
  c0_.sorting_rank ASC,
  c1_.sorting_rank ASC,
  c1_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.slug AS slug_3, c0_.sorting_rank AS sorting_rank_4, c1_.id AS id_5, c1_.name AS name_6, c1_.active AS active_7, c1_.slug AS slug_8, c1_.sorting_rank AS sorting_rank_9, c0_.language_id AS language_id_10, c0_.parent_id AS parent_id_11, c1_.language_id AS language_id_12, c1_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id AND (c1_.active = 1) WHERE c0_.language_id = 3 AND c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.sorting_rank ASC, c1_.sorting_rank ASC, c1_.name ASC;

#	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 351)
7	App\Controller\WebsiteController->header (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 176)
15	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
16	Twig\Template->yield (line 56)
17	__TwigTemplate_c337972ae3890df9539d3ad8b94b204e->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
26	App\Controller\Website2Controller->categoryIndex (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.08 ms
(0.25%)

UPDATE hit_counter SET uri = ?, hits = ?, unique_views = ? WHERE id = ?

Parameters:

[
  "http://nazranatimes.com/public/hi/index/categories"
  2
  2
  259175
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  hit_counter
SET
  uri = ?,
  hits = ?,
  unique_views = ?
WHERE
  id = ?

UPDATE hit_counter SET uri = 'http://nazranatimes.com/public/hi/index/categories', hits = 2, unique_views = 2 WHERE id = 259175;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 59)
7	App\MessageHandler\RecordHitMessageHandler->__invoke (line 152)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
11	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 61)
12	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
13	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
14	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
15	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
16	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
17	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 54)
18	Symfony\Component\Messenger\RoutableMessageBus->dispatch (line 58)
19	Symfony\Component\Messenger\Transport\Sync\SyncTransport->send (line 62)
20	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
21	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
22	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
23	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
24	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
25	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
26	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
27	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 56)
28	App\Service\HitCounterService->record (line 47)
29	App\EventSubscriber\HitCounterSubscriber->onKernelRequest (line 116)
30	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
31	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
32	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

1.03 ms
(0.24%)

SELECT COUNT(a.id)
             FROM advertisement a
             WHERE a.location = ?
               AND a.status = ?
               AND a.start_date <= ?
               AND a.end_date >= ?

Parameters:

[
  "header"
  "active"
  "2026-03-24"
  "2026-03-24"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a.id)
FROM
  advertisement a
WHERE
  a.location = ?
  AND a.status = ?
  AND a.start_date <= ?
  AND a.end_date >= ?

SELECT COUNT(a.id)
             FROM advertisement a
             WHERE a.location = 'header'
               AND a.status = 'active'
               AND a.start_date <= '2026-03-24'
               AND a.end_date >= '2026-03-24';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 32)
3	App\Repository\AdvertisementRepository->findRandomActiveForLocation (line 347)
4	App\Controller\BaseController->getAds (line 353)
5	App\Controller\WebsiteController->header (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 176)
13	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_c337972ae3890df9539d3ad8b94b204e->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 320)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
24	App\Controller\Website2Controller->categoryIndex (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.80 ms
(0.19%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 59)
5	App\MessageHandler\RecordHitMessageHandler->__invoke (line 152)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
7	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
8	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 61)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
13	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
14	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
15	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 54)
16	Symfony\Component\Messenger\RoutableMessageBus->dispatch (line 58)
17	Symfony\Component\Messenger\Transport\Sync\SyncTransport->send (line 62)
18	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
19	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
20	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
21	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
22	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
23	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
24	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
25	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 56)
26	App\Service\HitCounterService->record (line 47)
27	App\EventSubscriber\HitCounterSubscriber->onKernelRequest (line 116)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

0.51 ms
(0.12%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4, t0.options AS options_5, t0.dev AS dev_6 FROM setting 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.value AS value_3,
  t0.type AS type_4,
  t0.options AS options_5,
  t0.dev AS dev_6
FROM
  setting t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4, t0.options AS options_5, t0.dev AS dev_6 FROM setting t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 56)
6	App\Service\SettingProvider->loadFromDatabase (line 25)
7	App\Service\SettingProvider->getSetting (line 39)
8	App\Service\SettingProvider->getSettingOneByName (line 75)
9	App\Service\HitCounterService->App\Service\{closure} (line 48)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
11	Symfony\Component\Cache\LockRegistry::compute (line 102)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
16	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 71)
17	App\Service\HitCounterService->getHitCounter (line 109)
18	App\Twig\Runtime\AppExtensionRuntime->getHitCounter (line 259)
19	__TwigTemplate_8c94056c31618e6557de2a053a15a5ec->doDisplay (line 387)
20	Twig\Template->yield (line 56)
21	__TwigTemplate_c337972ae3890df9539d3ad8b94b204e->doDisplay (line 387)
22	Twig\Template->yield (line 343)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 320)
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 78)
30	App\Controller\Website2Controller->categoryIndex (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)

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\Language	No errors.
App\Entity\Category	No errors.
App\Entity\News	No errors.
App\Entity\BrandingImage	No errors.
App\Entity\HitCounter	No errors.
App\Entity\Advertisement	No errors.
App\Entity\ImageStore	No errors.
App\Entity\Comment	No errors.
App\Entity\Reporter	No errors.
App\Entity\ImageNewsMapper	No errors.
App\Entity\Author	No errors.
App\Entity\AdditionalImage	No errors.
App\Entity\NewsStat	No errors.
App\Entity\Setting	No errors.

Symfony Profiler

GET http://nazranatimes.com/public/hi/index/categories

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping