Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.01 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.40 ms

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.30 ms

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.firstname AS firstname_4, u0_.lastname AS lastname_5, u0_.is_active AS is_active_6, u0_.created_at AS created_at_7, u0_.depot AS depot_8, u0_.avatar AS avatar_9, u0_.notif_internal AS notif_internal_10, u0_.notif_email AS notif_email_11, u0_.reset_token AS reset_token_12, u0_.reset_token_expires_at AS reset_token_expires_at_13 FROM user u0_ WHERE u0_.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.firstname AS firstname_4,
  u0_.lastname AS lastname_5,
  u0_.is_active AS is_active_6,
  u0_.created_at AS created_at_7,
  u0_.depot AS depot_8,
  u0_.avatar AS avatar_9,
  u0_.notif_internal AS notif_internal_10,
  u0_.notif_email AS notif_email_11,
  u0_.reset_token AS reset_token_12,
  u0_.reset_token_expires_at AS reset_token_expires_at_13
FROM
  user u0_
WHERE
  u0_.is_active = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.firstname AS firstname_4, u0_.lastname AS lastname_5, u0_.is_active AS is_active_6, u0_.created_at AS created_at_7, u0_.depot AS depot_8, u0_.avatar AS avatar_9, u0_.notif_internal AS notif_internal_10, u0_.notif_email AS notif_email_11, u0_.reset_token AS reset_token_12, u0_.reset_token_expires_at AS reset_token_expires_at_13 FROM user u0_ WHERE u0_.is_active = 1;

#	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\UserRepository->findActives (line 38)
7	App\Controller\UserController->index (line 26)
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)

0.31 ms

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_ba36922277d6bdfc1cee27560495af8c->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\UserController->index (line 25)
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)

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\Notification	No errors.

Symfony Profiler

GET https://sictom.mp-digital.fr/admin/users

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping