Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.86 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.61 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed_at AS password_changed_at_5, t0.password_reset_required AS password_reset_required_6, t0.is_active AS is_active_7, t0.preferences AS preferences_8, t0.sso_id AS sso_id_9, t0.sso_provider AS sso_provider_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.personne_id AS personne_id_14 FROM `user` t0 WHERE t0.email = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

Parameters:

[
  "valentin.meriel@ag2i.fr"
]

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.password_changed_at AS password_changed_at_5,
  t0.password_reset_required AS password_reset_required_6,
  t0.is_active AS is_active_7,
  t0.preferences AS preferences_8,
  t0.sso_id AS sso_id_9,
  t0.sso_provider AS sso_provider_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.personne_id AS personne_id_14
FROM
  `user` t0
WHERE
  t0.email = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed_at AS password_changed_at_5, t0.password_reset_required AS password_reset_required_6, t0.is_active AS is_active_7, t0.preferences AS preferences_8, t0.sso_id AS sso_id_9, t0.sso_provider AS sso_provider_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.personne_id AS personne_id_14 FROM `user` t0 WHERE t0.email = 'valentin.meriel@ag2i.fr' AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 55)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 176)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 191)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 14)

1.25 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed_at AS password_changed_at_5, t0.password_reset_required AS password_reset_required_6, t0.is_active AS is_active_7, t0.preferences AS preferences_8, t0.sso_id AS sso_id_9, t0.sso_provider AS sso_provider_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.personne_id AS personne_id_14 FROM `user` t0 WHERE ((t0.deleted_at IS NULL)) ORDER BY t0.id ASC LIMIT 1

Parameters:

[]

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.password_changed_at AS password_changed_at_5,
  t0.password_reset_required AS password_reset_required_6,
  t0.is_active AS is_active_7,
  t0.preferences AS preferences_8,
  t0.sso_id AS sso_id_9,
  t0.sso_provider AS sso_provider_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.personne_id AS personne_id_14
FROM
  `user` t0
WHERE
  (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed_at AS password_changed_at_5, t0.password_reset_required AS password_reset_required_6, t0.is_active AS is_active_7, t0.preferences AS preferences_8, t0.sso_id AS sso_id_9, t0.sso_provider AS sso_provider_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.personne_id AS personne_id_14 FROM `user` t0 WHERE ((t0.deleted_at IS NULL)) ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Core\EventSubscriber\ErrorNotificationSubscriber->resolveRecipient (line 168)
5	App\Core\EventSubscriber\ErrorNotificationSubscriber->sendAlertEmail (line 111)
6	App\Core\EventSubscriber\ErrorNotificationSubscriber->onKernelException (line 99)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
11	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 14)

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\Core\Entity\User	1
App\Core\Entity\Personne	1

Entities Mapping

Class	Mapping errors
App\Core\Entity\User	No errors.
App\Core\Entity\Personne	No errors.
App\Core\Entity\Group	No errors.
App\Core\Entity\UserPermission	No errors.
App\Core\Entity\PermissionSchedule	No errors.
App\Core\Entity\NetworkRule	No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Core\Entity\RefreshToken	No errors.
App\Core\Entity\GroupPermission	No errors.
App\Core\Entity\Permission	No errors.

Symfony Profiler

POST https://myworkspace.val.lab/login

Configuration Settings

Theme

Page Width