Symfony Profiler

Query Metrics

23 Database Queries

7 Different statements

36.56 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.52 ms
(34.25%)

SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = ?

Parameters:

[
  "01944169-f198-78b5-a4bf-ae8f15cd0e39"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.checksum AS checksum_1,
  t0.id AS id_2,
  t0.api_id AS api_id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.file_metadata_name AS file_metadata_name_6,
  t0.file_metadata_original_name AS file_metadata_original_name_7,
  t0.file_metadata_mime_type AS file_metadata_mime_type_8,
  t0.file_metadata_size AS file_metadata_size_9,
  t0.file_metadata_dimensions AS file_metadata_dimensions_10
FROM
  "sebii__file__media" t0
WHERE
  t0.id = ?

SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = '01944169-f198-78b5-a4bf-ae8f15cd0e39';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\File\Media::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 99)
7	Proxies\__CG__\App\Entity\File\Media->initializeLazyObject (line 20)
8	Proxies\__CG__\App\Entity\File\Media->__load (line 96)
9	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromFirstField (line 137)
10	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 68)
11	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 35)
12	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 28)
13	Vich\UploaderBundle\Twig\Extension\UploaderExtensionRuntime->asset (line 486)
14	__TwigTemplate_1ff94db0c705dae90718ce20409dda49->{closure} (line 2061)
15	Twig\Extension\CoreExtension::captureOutput (line 474)
16	__TwigTemplate_1ff94db0c705dae90718ce20409dda49->macro_experience (line 322)
17	__TwigTemplate_1ff94db0c705dae90718ce20409dda49->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 22)
26	App\Controller\Front\Pro\Cv->__invoke (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 28)
30	require (line 9)
31	require_once (line 8)

5.87 ms
(16.06%)

SELECT t0.name AS name_1, t0.company AS company_2, t0.place AS place_3, t0.current AS current_4, t0.started_at AS started_at_5, t0.ended_at AS ended_at_6, t0.type AS type_7, t0.env AS env_8, t0.description AS description_9, t0.id AS id_10, t0.api_id AS api_id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.logo_media_id AS logo_media_id_14 FROM "sebii__cv__experience" t0 ORDER BY t0.current DESC, t0.ended_at DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.company AS company_2,
  t0.place AS place_3,
  t0.current AS current_4,
  t0.started_at AS started_at_5,
  t0.ended_at AS ended_at_6,
  t0.type AS type_7,
  t0.env AS env_8,
  t0.description AS description_9,
  t0.id AS id_10,
  t0.api_id AS api_id_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.logo_media_id AS logo_media_id_14
FROM
  "sebii__cv__experience" t0
ORDER BY
  t0.current DESC,
  t0.ended_at DESC

SELECT t0.name AS name_1, t0.company AS company_2, t0.place AS place_3, t0.current AS current_4, t0.started_at AS started_at_5, t0.ended_at AS ended_at_6, t0.type AS type_7, t0.env AS env_8, t0.description AS description_9, t0.id AS id_10, t0.api_id AS api_id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.logo_media_id AS logo_media_id_14 FROM "sebii__cv__experience" t0 ORDER BY t0.current DESC, t0.ended_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 25)
5	App\Controller\Front\Pro\Cv->__invoke (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 28)
9	require (line 9)
10	require_once (line 8)

5.51 ms
(15.07%)

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.customized_route AS customized_route_3, t0.customized_domain AS customized_domain_4, t0.iconify_code AS iconify_code_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10, t0.background__sebii__file__media__id AS background__sebii__file__media__id_11 FROM "sebii__category__universe" t0 WHERE t0.customized_domain = ? LIMIT 1

Parameters:

[
  "sb.sebii.dev"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.customized_route AS customized_route_3,
  t0.customized_domain AS customized_domain_4,
  t0.iconify_code AS iconify_code_5,
  t0.id AS id_6,
  t0.api_id AS api_id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10,
  t0.background__sebii__file__media__id AS background__sebii__file__media__id_11
FROM
  "sebii__category__universe" t0
WHERE
  t0.customized_domain = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.customized_route AS customized_route_3, t0.customized_domain AS customized_domain_4, t0.iconify_code AS iconify_code_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10, t0.background__sebii__file__media__id AS background__sebii__file__media__id_11 FROM "sebii__category__universe" t0 WHERE t0.customized_domain = 'sb.sebii.dev' 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 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 158)
5	Doctrine\ORM\EntityRepository->__call (line 94)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 36)
7	App\Event\EventSubscriber\Kernel\UniverseSubscriber->detectUniverse (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 28)
15	require (line 9)
16	require_once (line 8)

3.90 ms
(10.65%)

INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id

Parameters:

[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:46:\"App\\Messenger\\Message\\Security\\AnalyticMessage\":6:{s:50:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0at\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2025-05-02 11:42:16.967239\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:3:\"/cv\";s:54:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0domain\";s:12:\"sb.sebii.dev\";s:57:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0ipAddress\";s:10:\"172.19.0.1\";s:57:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0userAgent\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:56:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0referrer\";s:21:\"https://sb.sebii.dev/\";}}"
  "[]"
  "security_analytic"
  "2025-05-02 11:42:16"
  "2025-05-02 11:42:16"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO sebii__messenger__message (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?) RETURNING id

INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:46:\\\"App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\\":6:{s:50:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0at\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-05-02 11:42:16.967239\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:52:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0page\\\";s:3:\\\"/cv\\\";s:54:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0domain\\\";s:12:\\\"sb.sebii.dev\\\";s:57:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0ipAddress\\\";s:10:\\\"172.19.0.1\\\";s:57:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0userAgent\\\";s:103:\\\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\\\";s:56:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0referrer\\\";s:21:\\\"https://sb.sebii.dev/\\\";}}', '[]', 'security_analytic', '2025-05-02 11:42:16', '2025-05-02 11:42:16') RETURNING id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 953)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 450)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 141)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 46)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 70)
6	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 62)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 69)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 37)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 29)
15	App\Event\EventSubscriber\RequestSubscriber->onKernelRequest (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 28)
23	require (line 9)
24	require_once (line 8)

3.16 ms
(8.63%)

SELECT t0.name AS name_1, t0.order_position AS order_position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.displayed AS displayed_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM "sebii__cv__skill" t0 WHERE t0.displayed = ? ORDER BY t0.order_position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.order_position AS order_position_2,
  t0.id AS id_3,
  t0.api_id AS api_id_4,
  t0.displayed AS displayed_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  "sebii__cv__skill" t0
WHERE
  t0.displayed = ?
ORDER BY
  t0.order_position ASC

SELECT t0.name AS name_1, t0.order_position AS order_position_2, t0.id AS id_3, t0.api_id AS api_id_4, t0.displayed AS displayed_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM "sebii__cv__skill" t0 WHERE t0.displayed = 1 ORDER BY t0.order_position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 26)
5	App\Controller\Front\Pro\Cv->__invoke (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 28)
9	require (line 9)
10	require_once (line 8)

3.01 ms
(8.23%)

"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 446)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 141)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 70)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 62)
6	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
7	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
8	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
9	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
10	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
11	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 69)
12	Symfony\Component\Messenger\MessageBus->dispatch (line 37)
13	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 29)
14	App\Event\EventSubscriber\RequestSubscriber->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 28)
22	require (line 9)
23	require_once (line 8)

2.60 ms
(7.10%)

"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 477)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 141)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 46)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 70)
6	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 62)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 69)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 37)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 29)
15	App\Event\EventSubscriber\RequestSubscriber->onKernelRequest (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 28)
23	require (line 9)
24	require_once (line 8)

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\Category\Universe	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\File\Media	No errors.
App\Entity\Cv\Experience	No errors.
App\Entity\Cv\Skill	The association App\Entity\Cv\Skill#experiences refers to the owning side field App\Entity\Cv\Skill#skills which does not exist. The association App\Entity\Cv\Skill#experiences is ordered by a foreign field startedAt that is not a field on the target entity App\Entity\Cv\Skill.

Symfony Profiler

GET https://sb.sebii.dev/cv

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping