Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

145.30 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

139.53 ms
(96.03%)

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 IS NULL LIMIT 1

Parameters:

[
  "/corporate/1-about-us.html"
  "2026-03-24"
]

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 IS NULL
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 = '/corporate/1-about-us.html' AND t0.date = '2026-03-24' AND t0.language_id IS NULL 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)

3.45 ms
(2.37%)

SELECT w0_.id AS id_0, w0_.type AS type_1, w0_.file_name AS file_name_2, w0_.file_type AS file_type_3 FROM web_image w0_ WHERE w0_.type = ? ORDER BY w0_.id DESC LIMIT 1

Parameters:

[
  "logo"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.type AS type_1,
  w0_.file_name AS file_name_2,
  w0_.file_type AS file_type_3
FROM
  web_image w0_
WHERE
  w0_.type = ?
ORDER BY
  w0_.id DESC
LIMIT
  1

SELECT w0_.id AS id_0, w0_.type AS type_1, w0_.file_name AS file_name_2, w0_.file_type AS file_type_3 FROM web_image w0_ WHERE w0_.type = 'logo' ORDER BY w0_.id DESC LIMIT 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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 515)
7	App\Twig\Runtime\AppExtensionRuntime->App\Twig\Runtime\{closure} (line 64)
8	App\Twig\Runtime\AppExtensionRuntime->App\Twig\Runtime\{closure} (line 48)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
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 53)
15	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
16	App\Twig\Runtime\AppExtensionRuntime->remember (line 505)
17	App\Twig\Runtime\AppExtensionRuntime->getWebImage (line 87)
18	__TwigTemplate_cd927d5f11c508501af1cc4107433f09->doDisplay (line 387)
19	Twig\Template->yield (line 56)
20	__TwigTemplate_4e0262fd0420da0773dd2b50104adf38->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
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 26)
29	App\Controller\CorporateController->webPage (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)

0.85 ms
(0.58%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.body AS body_3, t0.sorting_rank AS sorting_rank_4, t0.seo_description AS seo_description_5, t0.seo_keywords AS seo_keywords_6, t0.is_published AS is_published_7, t0.seo_title AS seo_title_8, t0.location AS location_9, t0.is_home AS is_home_10, t0.slug AS slug_11, t0.url AS url_12 FROM web_page t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.body AS body_3,
  t0.sorting_rank AS sorting_rank_4,
  t0.seo_description AS seo_description_5,
  t0.seo_keywords AS seo_keywords_6,
  t0.is_published AS is_published_7,
  t0.seo_title AS seo_title_8,
  t0.location AS location_9,
  t0.is_home AS is_home_10,
  t0.slug AS slug_11,
  t0.url AS url_12
FROM
  web_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.body AS body_3, t0.sorting_rank AS sorting_rank_4, t0.seo_description AS seo_description_5, t0.seo_keywords AS seo_keywords_6, t0.is_published AS is_published_7, t0.seo_title AS seo_title_8, t0.location AS location_9, t0.is_home AS is_home_10, t0.slug AS slug_11, t0.url AS url_12 FROM web_page 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 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 21)
7	App\Controller\CorporateController->webPage (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)

0.68 ms
(0.47%)

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

Parameters:

[
  "http://nazranatimes.com/public/corporate/1-about-us.html"
  2
  2
  "*/*"
  258340
]

View formatted query View runnable query Explain query View query backtrace

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

UPDATE hit_counter SET uri = 'http://nazranatimes.com/public/corporate/1-about-us.html', hits = 2, unique_views = 2, mime_type = '*/*' WHERE id = 258340;

#	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)

0.54 ms
(0.37%)

"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.24 ms
(0.17%)

"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)

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\HitCounter	No errors.
App\Entity\Language	No errors.
App\Entity\WebPage	No errors.
App\Entity\WebImage	No errors.

Symfony Profiler

GET http://nazranatimes.com/public/corporate/1-about-us.html

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping