Symfony Profiler

Query Metrics

10 Database Queries

8 Different statements

59.65 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

31.76 ms
(53.24%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.css AS css_5, t0.js AS js_6, t0.published AS published_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM PAGE t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "accueil"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.css AS css_5,
  t0.js AS js_6,
  t0.published AS published_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  PAGE t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.css AS css_5, t0.js AS js_6, t0.published AS published_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM PAGE t0 WHERE t0.slug = 'accueil' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 45)
5	App\Controller\PagePublicController->page (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)

9.57 ms
(16.05%)

"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 259)
3	Doctrine\ORM\EntityManager->flush (line 68)
4	App\EventSubscriber\VisitorTrackerSubscriber->onKernelRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
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)

6.99 ms
(11.72%)

INSERT INTO session_visiteur (ip, user_agent, started_at, last_activity, session_token) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "216.73.216.75"
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "2026-05-23 08:45:17"
  "2026-05-23 08:45:17"
  "eadc46229677e020661557d9037e7202"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO session_visiteur (
  ip, user_agent, started_at, last_activity,
  session_token
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO session_visiteur (ip, user_agent, started_at, last_activity, session_token) VALUES ('216.73.216.75', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '2026-05-23 08:45:17', '2026-05-23 08:45:17', 'eadc46229677e020661557d9037e7202');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 68)
7	App\EventSubscriber\VisitorTrackerSubscriber->onKernelRequest (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 154)
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)

5.27 ms
(8.84%)

INSERT INTO page_visitee (url, visited_at, duration, session_id) VALUES (?, ?, ?, ?)

Parameters:

[
  "/accueil"
  "2026-05-23 08:45:17"
  null
  4612
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO page_visitee (
  url, visited_at, duration, session_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO page_visitee (url, visited_at, duration, session_id) VALUES ('/accueil', '2026-05-23 08:45:17', NULL, 4612);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 87)
7	App\EventSubscriber\VisitorTrackerSubscriber->onKernelRequest (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 154)
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)

3.48 ms
(5.83%)

UPDATE session_visiteur SET last_activity = ? WHERE id = ?

Parameters:

[
  "2026-05-23 08:45:17"
  4612
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  session_visiteur
SET
  last_activity = ?
WHERE
  id = ?

UPDATE session_visiteur SET last_activity = '2026-05-23 08:45:17' WHERE id = 4612;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 490)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 374)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1126)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 404)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 87)
7	App\EventSubscriber\VisitorTrackerSubscriber->onKernelRequest (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 154)
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.07 ms
(1.79%)

"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 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 68)
5	App\EventSubscriber\VisitorTrackerSubscriber->onKernelRequest (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 154)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.78 ms
(1.31%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.robots AS robots_5, t0.lang AS lang_6, t0.favicon AS favicon_7, t0.updated_at AS updated_at_8 FROM seo t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.keywords AS keywords_4,
  t0.robots AS robots_5,
  t0.lang AS lang_6,
  t0.favicon AS favicon_7,
  t0.updated_at AS updated_at_8
FROM
  seo t0
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.robots AS robots_5, t0.lang AS lang_6, t0.favicon AS favicon_7, t0.updated_at AS updated_at_8 FROM seo t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 21)
5	App\Twig\SeoExtension->getGlobals (line 331)
6	Twig\ExtensionSet->getGlobals (line 825)
7	Twig\Environment->getGlobals (line 838)
8	Twig\Environment->mergeGlobals (line 347)
9	Twig\Template->yield (line 335)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 307)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 53)
16	App\Controller\PagePublicController->page (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)

0.73 ms
(1.22%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.user_agent AS user_agent_3, t0.started_at AS started_at_4, t0.last_activity AS last_activity_5, t0.session_token AS session_token_6 FROM session_visiteur t0 WHERE t0.session_token = ? LIMIT 1

Parameters:

[
  "eadc46229677e020661557d9037e7202"
]

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.started_at AS started_at_4,
  t0.last_activity AS last_activity_5,
  t0.session_token AS session_token_6
FROM
  session_visiteur t0
WHERE
  t0.session_token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.user_agent AS user_agent_3, t0.started_at AS started_at_4, t0.last_activity AS last_activity_5, t0.session_token AS session_token_6 FROM session_visiteur t0 WHERE t0.session_token = 'eadc46229677e020661557d9037e7202' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 73)
5	App\EventSubscriber\VisitorTrackerSubscriber->onKernelRequest (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 154)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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\SessionVisiteur	No errors.
App\Entity\PageVisitee	No errors.
App\Entity\Page	No errors.
App\Entity\Seo	No errors.

Symfony Profiler

GET https://athci.thebestforwarder.com/accueil

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping