Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.22 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.21 ms
(54.50%)

SELECT COUNT(a0_.id) AS sclr_0 FROM analytics_page_access a0_ WHERE a0_.ip = ? AND a0_.is_bot = 1

Parameters:

[
  "170.106.72.93"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  analytics_page_access a0_
WHERE
  a0_.ip = ?
  AND a0_.is_bot = 1

SELECT COUNT(a0_.id) AS sclr_0 FROM analytics_page_access a0_ WHERE a0_.ip = '170.106.72.93' AND a0_.is_bot = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 232)
8	App\Repository\Analytics\PageAccessRepository->isIpKnownAsBot (line 53)
9	App\Service\AnalyticsService->trackPageAccess (line 47)
10	App\EventListener\AnalyticsListener->onKernelResponse (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 211)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 199)
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 7)

0.69 ms
(31.30%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.user_agent AS user_agent_3, t0.page_url AS page_url_4, t0.accessed_at AS accessed_at_5, t0.session_id AS session_id_6, t0.visit_count AS visit_count_7, t0.referer AS referer_8, t0.country AS country_9, t0.city AS city_10, t0.is_bot AS is_bot_11, t0.bot_type AS bot_type_12 FROM analytics_page_access t0 WHERE t0.ip = ? AND t0.page_url = ? LIMIT 1

Parameters:

[
  "170.106.72.93"
  "/landing"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.user_agent AS user_agent_3,
  t0.page_url AS page_url_4,
  t0.accessed_at AS accessed_at_5,
  t0.session_id AS session_id_6,
  t0.visit_count AS visit_count_7,
  t0.referer AS referer_8,
  t0.country AS country_9,
  t0.city AS city_10,
  t0.is_bot AS is_bot_11,
  t0.bot_type AS bot_type_12
FROM
  analytics_page_access t0
WHERE
  t0.ip = ?
  AND t0.page_url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.user_agent AS user_agent_3, t0.page_url AS page_url_4, t0.accessed_at AS accessed_at_5, t0.session_id AS session_id_6, t0.visit_count AS visit_count_7, t0.referer AS referer_8, t0.country AS country_9, t0.city AS city_10, t0.is_bot AS is_bot_11, t0.bot_type AS bot_type_12 FROM analytics_page_access t0 WHERE t0.ip = '170.106.72.93' AND t0.page_url = '/landing' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
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\Repository\Analytics\PageAccessRepository->findByIpAndUrl (line 59)
6	App\Service\AnalyticsService->trackPageAccess (line 47)
7	App\EventListener\AnalyticsListener->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 7)

0.16 ms
(7.17%)

UPDATE analytics_page_access SET accessed_at = ?, visit_count = ?, referer = ? WHERE id = ?

Parameters:

[
  "2026-05-31 04:07:55"
  12
  "https://admin.ciano.chat/"
  1287
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  analytics_page_access
SET
  accessed_at = ?,
  visit_count = ?,
  referer = ?
WHERE
  id = ?

UPDATE analytics_page_access SET accessed_at = '2026-05-31 04:07:55', visit_count = 12, referer = 'https://admin.ciano.chat/' WHERE id = 1287;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 489)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 373)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1126)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 404)
5	Doctrine\ORM\UnitOfWork->commit (line 260)
6	Doctrine\ORM\EntityManager->flush (line 89)
7	App\Service\AnalyticsService->trackPageAccess (line 47)
8	App\EventListener\AnalyticsListener->onKernelResponse (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 211)
13	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 199)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 7)

0.09 ms
(3.87%)

"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 380)
2	Doctrine\ORM\UnitOfWork->commit (line 260)
3	Doctrine\ORM\EntityManager->flush (line 89)
4	App\Service\AnalyticsService->trackPageAccess (line 47)
5	App\EventListener\AnalyticsListener->onKernelResponse (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 211)
10	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 199)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 7)

0.07 ms
(3.16%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1427)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 260)
4	Doctrine\ORM\EntityManager->flush (line 89)
5	App\Service\AnalyticsService->trackPageAccess (line 47)
6	App\EventListener\AnalyticsListener->onKernelResponse (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 211)
11	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 199)
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 7)

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\Analytics\PageAccess	No errors.

Symfony Profiler

GET https://admin.ciano.chat/landing

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping