Symfony Profiler

Query Metrics

14 Database Queries

7 Different statements

279.37 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

130.30 ms
(46.64%)

SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.post_id AS post_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM post_view_stats t0 WHERE t0.post_id = ? AND t0.start_day_time = ? LIMIT 1

Parameters:

[
  3
  "2026-04-15"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start_day_time AS start_day_time_2,
  t0.post_id AS post_id_3,
  t0.hit_count AS hit_count_4,
  t0.updated_at AS updated_at_5
FROM
  post_view_stats t0
WHERE
  t0.post_id = ?
  AND t0.start_day_time = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.post_id AS post_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM post_view_stats t0 WHERE t0.post_id = 3 AND t0.start_day_time = '2026-04-15' 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 30)
5	App\Twig\Components\StatsUpdateService->updatePostStats (line 288)
6	App\Controller\AtStatsKenyaPostController->getPostsByCategory (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

87.82 ms
(31.43%)

"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 48)
4	App\Twig\Components\StatsUpdateService->updatePostStats (line 288)
5	App\Controller\AtStatsKenyaPostController->getPostsByCategory (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

56.86 ms
(20.35%)

SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 1574)
2	Doctrine\DBAL\Connection->createSavepoint (line 1371)
3	Doctrine\DBAL\Connection->beginTransaction (line 379)
4	Doctrine\ORM\UnitOfWork->commit (line 264)
5	Doctrine\ORM\EntityManager->flush (line 46)
6	App\Audit\AuditLogger->log (line 56)
7	App\EventListener\AuditLogDoctrineEventListener->log (line 63)
8	App\EventListener\AuditLogDoctrineEventListener->postUpdate (line 63)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 95)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1135)
11	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
12	Doctrine\ORM\UnitOfWork->commit (line 264)
13	Doctrine\ORM\EntityManager->flush (line 48)
14	App\Twig\Components\StatsUpdateService->updatePostStats (line 288)
15	App\Controller\AtStatsKenyaPostController->getPostsByCategory (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.55 ms
(0.56%)

INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "post-update"
  "App\Entity\PostViewStats"
  "59960"
  null
  "2026-04-15 03:37:53"
  "No user"
  ""[]""
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO audit_log (
  action, entity, entity_id, user, log_time,
  action_description, value_object
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES ('post-update', 'App\\Entity\\PostViewStats', '59960', NULL, '2026-04-15 03:37:53', 'No user', '\"[]\"');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 251)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 46)
7	App\Audit\AuditLogger->log (line 56)
8	App\EventListener\AuditLogDoctrineEventListener->log (line 63)
9	App\EventListener\AuditLogDoctrineEventListener->postUpdate (line 63)
10	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 95)
11	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1135)
12	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
13	Doctrine\ORM\UnitOfWork->commit (line 264)
14	Doctrine\ORM\EntityManager->flush (line 48)
15	App\Twig\Components\StatsUpdateService->updatePostStats (line 288)
16	App\Controller\AtStatsKenyaPostController->getPostsByCategory (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.34 ms
(0.48%)

UPDATE post_view_stats SET hit_count = ?, updated_at = ? WHERE id = ?

Parameters:

[
  27
  "2026-04-15 03:37:52"
  59960
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  post_view_stats
SET
  hit_count = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE post_view_stats SET hit_count = 27, updated_at = '2026-04-15 03:37:52' WHERE id = 59960;

#	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 48)
7	App\Twig\Components\StatsUpdateService->updatePostStats (line 288)
8	App\Controller\AtStatsKenyaPostController->getPostsByCategory (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.77 ms
(0.27%)

"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 48)
5	App\Twig\Components\StatsUpdateService->updatePostStats (line 288)
6	App\Controller\AtStatsKenyaPostController->getPostsByCategory (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.72 ms
(0.26%)

RELEASE SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 1608)
2	Doctrine\DBAL\Connection->releaseSavepoint (line 1425)
3	Doctrine\DBAL\Connection->commit (line 430)
4	Doctrine\ORM\UnitOfWork->commit (line 264)
5	Doctrine\ORM\EntityManager->flush (line 46)
6	App\Audit\AuditLogger->log (line 56)
7	App\EventListener\AuditLogDoctrineEventListener->log (line 63)
8	App\EventListener\AuditLogDoctrineEventListener->postUpdate (line 63)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 95)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1135)
11	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
12	Doctrine\ORM\UnitOfWork->commit (line 264)
13	Doctrine\ORM\EntityManager->flush (line 48)
14	App\Twig\Components\StatsUpdateService->updatePostStats (line 288)
15	App\Controller\AtStatsKenyaPostController->getPostsByCategory (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	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\PostViewStats	No errors.
App\Entity\AuditLog	No errors.

Symfony Profiler

GET https://statskenya.co.ke/public/at-stats-kenya/category/Banking%2520and%2520Finance/8/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping