Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

6.45 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.29 ms
(35.51%)

UPDATE analytics_page_access SET is_bot = ?, bot_type = ? WHERE ip = ?

Parameters:

[
  1
  "Generic Bot"
  "216.73.217.123"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  analytics_page_access
SET
  is_bot = ?,
  bot_type = ?
WHERE
  ip = ?

UPDATE analytics_page_access SET is_bot = 1, bot_type = 'Generic Bot' WHERE ip = '216.73.217.123';

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 40)
2	Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 221)
6	App\Repository\Analytics\PageAccessRepository->updateAccessesByIpToBot (line 150)
7	App\Service\AnalyticsService->updateAllAccessesByIpToBot (line 86)
8	App\Service\AnalyticsService->trackPageAccess (line 47)
9	App\EventListener\AnalyticsListener->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 7)

1.94 ms
(30.08%)

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:

[
  "216.73.217.123"
  "/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 = '216.73.217.123' 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)

1.89 ms
(29.31%)

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

Parameters:

[
  "216.73.217.123"
]

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 = '216.73.217.123' 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.17 ms
(2.68%)

INSERT INTO analytics_page_access (ip, user_agent, page_url, accessed_at, session_id, visit_count, referer, country, city, is_bot, bot_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "216.73.217.123"
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "/landing"
  "2026-05-31 06:44:50"
  ""
  1
  "https://admin.ciano.chat/"
  null
  null
  1
  "Generic Bot"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO analytics_page_access (
  ip, user_agent, page_url, accessed_at,
  session_id, visit_count, referer,
  country, city, is_bot, bot_type
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO analytics_page_access (ip, user_agent, page_url, accessed_at, session_id, visit_count, referer, country, city, is_bot, bot_type) VALUES ('216.73.217.123', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/landing', '2026-05-31 06:44:50', '', 1, 'https://admin.ciano.chat/', NULL, NULL, 1, 'Generic Bot');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 248)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
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
(1.41%)

"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
(1.01%)

"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