Symfony Profiler

Query Metrics

22 Database Queries

10 Different statements

74.70 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

38.66 ms
(51.75%)

SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.county_id AS county_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM county_view_stats t0 WHERE t0.county_id = ? AND t0.start_day_time = ? LIMIT 1

Parameters:

[
  40
  "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.county_id AS county_id_3,
  t0.hit_count AS hit_count_4,
  t0.updated_at AS updated_at_5
FROM
  county_view_stats t0
WHERE
  t0.county_id = ?
  AND t0.start_day_time = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.county_id AS county_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM county_view_stats t0 WHERE t0.county_id = 40 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 65)
5	App\Twig\Components\StatsUpdateService->updateCountyStats (line 68)
6	App\Controller\CountyInformationController->getInformation (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)

22.73 ms
(30.42%)

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:

[
  4
  "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 = 4 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 77)
6	App\EventListener\KernelRequestCompanyInformation->updateHitCount (line 42)
7	App\EventListener\KernelRequestCompanyInformation->onKernelResponse (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 211)
12	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 199)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

6.35 ms
(8.50%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.capital AS capital_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.about AS about_7, t8.id AS id_9, t8.info AS info_10, t8.imgage1_url AS imgage1_url_11, t8.image2_url AS image2_url_12, t8.image3_url AS image3_url_13, t8.created_at AS created_at_14, t8.updated_at AS updated_at_15, t8.seo_title AS seo_title_16, t8.seo_description AS seo_description_17, t8.seo_keywords AS seo_keywords_18, t8.hit_count AS hit_count_19, t8.county_id AS county_id_20 FROM county t0 LEFT JOIN county_information t8 ON t8.county_id = t0.id WHERE t0.id = ?

Parameters:

[
  "39"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.capital AS capital_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.about AS about_7,
  t8.id AS id_9,
  t8.info AS info_10,
  t8.imgage1_url AS imgage1_url_11,
  t8.image2_url AS image2_url_12,
  t8.image3_url AS image3_url_13,
  t8.created_at AS created_at_14,
  t8.updated_at AS updated_at_15,
  t8.seo_title AS seo_title_16,
  t8.seo_description AS seo_description_17,
  t8.seo_keywords AS seo_keywords_18,
  t8.hit_count AS hit_count_19,
  t8.county_id AS county_id_20
FROM
  county t0
  LEFT JOIN county_information t8 ON t8.county_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.capital AS capital_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.about AS about_7, t8.id AS id_9, t8.info AS info_10, t8.imgage1_url AS imgage1_url_11, t8.image2_url AS image2_url_12, t8.image3_url AS image3_url_13, t8.created_at AS created_at_14, t8.updated_at AS updated_at_15, t8.seo_title AS seo_title_16, t8.seo_description AS seo_description_17, t8.seo_keywords AS seo_keywords_18, t8.hit_count AS hit_count_19, t8.county_id AS county_id_20 FROM county t0 LEFT JOIN county_information t8 ON t8.county_id = t0.id WHERE t0.id = '39';

#	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 116)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.46 ms
(1.95%)

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

Parameters:

[
  "post-update"
  "App\Entity\CountyViewStats"
  "28961"
  null
  "2026-04-15 05:26:08"
  "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\\CountyViewStats', '28961', NULL, '2026-04-15 05:26:08', '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 83)
15	App\Twig\Components\StatsUpdateService->updateCountyStats (line 68)
16	App\Controller\CountyInformationController->getInformation (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.35 ms
(1.80%)

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

Parameters:

[
  4
  "2026-04-15 05:26:08"
  28961
]

View formatted query View runnable query Explain query View query backtrace

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

UPDATE county_view_stats SET hit_count = 4, updated_at = '2026-04-15 05:26:08' WHERE id = 28961;

#	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 83)
7	App\Twig\Components\StatsUpdateService->updateCountyStats (line 68)
8	App\Controller\CountyInformationController->getInformation (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)

1.08 ms
(1.44%)

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 83)
14	App\Twig\Components\StatsUpdateService->updateCountyStats (line 68)
15	App\Controller\CountyInformationController->getInformation (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)

0.98 ms
(1.31%)

"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 83)
5	App\Twig\Components\StatsUpdateService->updateCountyStats (line 68)
6	App\Controller\CountyInformationController->getInformation (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.83 ms
(1.11%)

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 83)
14	App\Twig\Components\StatsUpdateService->updateCountyStats (line 68)
15	App\Controller\CountyInformationController->getInformation (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)

0.82 ms
(1.10%)

"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 83)
4	App\Twig\Components\StatsUpdateService->updateCountyStats (line 68)
5	App\Controller\CountyInformationController->getInformation (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)

0.46 ms
(0.61%)

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

Parameters:

[
  50904
  "2026-04-15 05:26:09"
  59953
]

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 = 50904, updated_at = '2026-04-15 05:26:09' WHERE id = 59953;

#	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 77)
8	App\EventListener\KernelRequestCompanyInformation->updateHitCount (line 42)
9	App\EventListener\KernelRequestCompanyInformation->onKernelResponse (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 211)
14	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 199)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	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\County	No errors.
App\Entity\CountyInformation	No errors.
App\Entity\Post	No errors.
App\Entity\CountyViewStats	No errors.
App\Entity\AuditLog	No errors.
App\Entity\PostViewStats	No errors.

Symfony Profiler

GET https://statskenya.co.ke/county-information/Bungoma/39

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping