Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.54 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.54 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.service AS service_7, t0.is_active AS is_active_8, t0.next_id AS next_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.responsable_id AS responsable_id_15 FROM `user` t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "abdulatif.yessoufou@topchrono.com"
]

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.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.service AS service_7,
  t0.is_active AS is_active_8,
  t0.next_id AS next_id_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12,
  t0.created_by AS created_by_13,
  t0.updated_by AS updated_by_14,
  t0.responsable_id AS responsable_id_15
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.service AS service_7, t0.is_active AS is_active_8, t0.next_id AS next_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.responsable_id AS responsable_id_15 FROM `user` t0 WHERE t0.email = 'abdulatif.yessoufou@topchrono.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 91)
6	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
7	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
8	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
19	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Demande	No errors.
App\Entity\Bon	No errors.
App\Entity\Assignation	No errors.
App\Entity\Operation	No errors.
App\Entity\Permission	No errors.
App\Entity\OperationCaisse	No errors.
App\Entity\BonDispatch	No errors.
App\Entity\BonRestitution	No errors.

Symfony Profiler

POST https://tc-logistic.topcrono.com/login

Configuration Settings

Theme