Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.91 ms Query time

0 Invalid entities

20 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.48 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.email_auth_code AS email_auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile_phone AS mobile_phone_9, t0.totp_secret AS totp_secret_10, t0.status AS status_11, t0.reference AS reference_12, t0.token AS token_13 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.email_auth_code AS email_auth_code_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.phone AS phone_8,
  t0.mobile_phone AS mobile_phone_9,
  t0.totp_secret AS totp_secret_10,
  t0.status AS status_11,
  t0.reference AS reference_12,
  t0.token AS token_13
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.email_auth_code AS email_auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile_phone AS mobile_phone_9, t0.totp_secret AS totp_secret_10, t0.status AS status_11, t0.reference AS reference_12, t0.token AS token_13 FROM `user` t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.92 ms

SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.reference AS reference_2, n0_.content AS content_3, n0_.target_id AS target_id_4, n0_.created_at AS created_at_5, n0_.status AS status_6, n0_.recipient_id AS recipient_id_7, n0_.created_by_id AS created_by_id_8 FROM notification n0_ WHERE n0_.recipient_id = ? ORDER BY n0_.created_at DESC LIMIT 2

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.type AS type_1,
  n0_.reference AS reference_2,
  n0_.content AS content_3,
  n0_.target_id AS target_id_4,
  n0_.created_at AS created_at_5,
  n0_.status AS status_6,
  n0_.recipient_id AS recipient_id_7,
  n0_.created_by_id AS created_by_id_8
FROM
  notification n0_
WHERE
  n0_.recipient_id = ?
ORDER BY
  n0_.created_at DESC
LIMIT
  2

SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.reference AS reference_2, n0_.content AS content_3, n0_.target_id AS target_id_4, n0_.created_at AS created_at_5, n0_.status AS status_6, n0_.recipient_id AS recipient_id_7, n0_.created_by_id AS created_by_id_8 FROM notification n0_ WHERE n0_.recipient_id = 1 ORDER BY n0_.created_at DESC LIMIT 2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\NotificationRepository->findLatestByRecipient (line 67)
7	App\Service\NotificationService->getLatest (line 96)
8	App\Service\NotificationService->getDataForNotificationHeader (line 56)
9	App\Twig\Runtime\NotificationExtensionRuntime->getDataForNotificationHeader (line 27)
10	__TwigTemplate_0ce3b453ea40aea84dbae803ebf0e520->block_breadcrumb_base (line 603)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_0ce3b453ea40aea84dbae803ebf0e520->block_navbar (line 511)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_0ce3b453ea40aea84dbae803ebf0e520->block_body (line 282)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_0ce3b453ea40aea84dbae803ebf0e520->doDisplay (line 109)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_ebaeeab4b238a8667119f376c64c1b8f->doDisplay (line 56)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
27	App\Controller\OcrController->pdfToText (line 35)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

0.51 ms

SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.reference AS reference_2, n0_.content AS content_3, n0_.target_id AS target_id_4, n0_.created_at AS created_at_5, n0_.status AS status_6, n0_.recipient_id AS recipient_id_7, n0_.created_by_id AS created_by_id_8 FROM notification n0_ WHERE n0_.recipient_id = ? AND n0_.status = ? ORDER BY n0_.created_at DESC

Parameters:

[
  1
  "unread"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.type AS type_1,
  n0_.reference AS reference_2,
  n0_.content AS content_3,
  n0_.target_id AS target_id_4,
  n0_.created_at AS created_at_5,
  n0_.status AS status_6,
  n0_.recipient_id AS recipient_id_7,
  n0_.created_by_id AS created_by_id_8
FROM
  notification n0_
WHERE
  n0_.recipient_id = ?
  AND n0_.status = ?
ORDER BY
  n0_.created_at DESC

SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.reference AS reference_2, n0_.content AS content_3, n0_.target_id AS target_id_4, n0_.created_at AS created_at_5, n0_.status AS status_6, n0_.recipient_id AS recipient_id_7, n0_.created_by_id AS created_by_id_8 FROM notification n0_ WHERE n0_.recipient_id = 1 AND n0_.status = 'unread' ORDER BY n0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\NotificationRepository->findUnreadByRecipient (line 31)
7	App\Service\NotificationService->findUnreadNotifications (line 76)
8	App\Service\NotificationService->getDataForNotificationHeader (line 57)
9	App\Twig\Runtime\NotificationExtensionRuntime->getDataForNotificationHeader (line 27)
10	__TwigTemplate_0ce3b453ea40aea84dbae803ebf0e520->block_breadcrumb_base (line 603)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_0ce3b453ea40aea84dbae803ebf0e520->block_navbar (line 511)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_0ce3b453ea40aea84dbae803ebf0e520->block_body (line 282)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_0ce3b453ea40aea84dbae803ebf0e520->doDisplay (line 109)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_ebaeeab4b238a8667119f376c64c1b8f->doDisplay (line 56)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
27	App\Controller\OcrController->pdfToText (line 35)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Notification	19
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Project	No errors.
App\Entity\Team	No errors.
App\Entity\Regulation	No errors.
App\Entity\Conversation	No errors.
App\Entity\Prompt	No errors.
App\Entity\Package	No errors.
App\Entity\Notification	No errors.

Symfony Profiler

POST https://local-cite.eryon.eu/fr-fr/ocr

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping