Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.97 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.39 ms
(39.97%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.depot AS depot_9, t0.avatar AS avatar_10, t0.notif_internal AS notif_internal_11, t0.notif_email AS notif_email_12, t0.reset_token AS reset_token_13, t0.reset_token_expires_at AS reset_token_expires_at_14 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.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.is_active AS is_active_7,
  t0.created_at AS created_at_8,
  t0.depot AS depot_9,
  t0.avatar AS avatar_10,
  t0.notif_internal AS notif_internal_11,
  t0.notif_email AS notif_email_12,
  t0.reset_token AS reset_token_13,
  t0.reset_token_expires_at AS reset_token_expires_at_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.depot AS depot_9, t0.avatar AS avatar_10, t0.notif_internal AS notif_internal_11, t0.notif_email AS notif_email_12, t0.reset_token AS reset_token_13, t0.reset_token_expires_at AS reset_token_expires_at_14 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\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
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 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
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 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 191)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.31 ms
(32.51%)

SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.message AS message_2, n0_.link AS link_3, n0_.created_at AS created_at_4, n0_.read_at AS read_at_5, n0_.recipient_id AS recipient_id_6 FROM notification n0_ WHERE n0_.recipient_id = ? AND n0_.read_at IS NULL ORDER BY n0_.created_at DESC LIMIT 20

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_.message AS message_2,
  n0_.link AS link_3,
  n0_.created_at AS created_at_4,
  n0_.read_at AS read_at_5,
  n0_.recipient_id AS recipient_id_6
FROM
  notification n0_
WHERE
  n0_.recipient_id = ?
  AND n0_.read_at IS NULL
ORDER BY
  n0_.created_at DESC
LIMIT
  20

SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.message AS message_2, n0_.link AS link_3, n0_.created_at AS created_at_4, n0_.read_at AS read_at_5, n0_.recipient_id AS recipient_id_6 FROM notification n0_ WHERE n0_.recipient_id = 1 AND n0_.read_at IS NULL ORDER BY n0_.created_at DESC LIMIT 20;

#	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->findUnreadForUser (line 30)
7	App\Twig\NotificationExtension->getUnreadNotifications (line 25)
8	__TwigTemplate_bd73e0d6b01bdea056d91ec0d6b3928c->doDisplay (line 70)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_97e9418c91ec145e8c7f94a9b31532d6->block_body (line 84)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_f623cd5e682b6d8c1511e382e86623c5->doDisplay (line 97)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_97e9418c91ec145e8c7f94a9b31532d6->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_703d81a7860ed10b87bf882850b725f9->doDisplay (line 54)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
25	App\Controller\LeaveRequestController->index (line 35)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 191)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.27 ms
(27.52%)

SELECT l0_.id AS id_0, l0_.type AS type_1, l0_.granularity AS granularity_2, l0_.start_date AS start_date_3, l0_.end_date AS end_date_4, l0_.comment AS comment_5, l0_.status AS status_6, l0_.refusal_reason AS refusal_reason_7, l0_.processed_at AS processed_at_8, l0_.created_at AS created_at_9, l0_.requested_by_id AS requested_by_id_10, l0_.processed_by_id AS processed_by_id_11 FROM leave_request l0_ ORDER BY l0_.created_at DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.type AS type_1,
  l0_.granularity AS granularity_2,
  l0_.start_date AS start_date_3,
  l0_.end_date AS end_date_4,
  l0_.comment AS comment_5,
  l0_.status AS status_6,
  l0_.refusal_reason AS refusal_reason_7,
  l0_.processed_at AS processed_at_8,
  l0_.created_at AS created_at_9,
  l0_.requested_by_id AS requested_by_id_10,
  l0_.processed_by_id AS processed_by_id_11
FROM
  leave_request l0_
ORDER BY
  l0_.created_at DESC

SELECT l0_.id AS id_0, l0_.type AS type_1, l0_.granularity AS granularity_2, l0_.start_date AS start_date_3, l0_.end_date AS end_date_4, l0_.comment AS comment_5, l0_.status AS status_6, l0_.refusal_reason AS refusal_reason_7, l0_.processed_at AS processed_at_8, l0_.created_at AS created_at_9, l0_.requested_by_id AS requested_by_id_10, l0_.processed_by_id AS processed_by_id_11 FROM leave_request l0_ ORDER BY l0_.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\LeaveRequestRepository->findAllOrdered (line 43)
7	App\Controller\LeaveRequestController->index (line 32)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\LeaveRequest	No errors.
App\Entity\Notification	No errors.

Symfony Profiler

GET https://sictom.mp-digital.fr/conges

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping