Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

5.35 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

5.35 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.device_id AS device_id_7, t0.enable_device_check AS enable_device_check_8, t9.id AS id_10, t9.matricule AS matricule_11, t9.nom AS nom_12, t9.prenom AS prenom_13, t9.tel AS tel_14, t9.create_at AS create_at_15, t9.update_at AS update_at_16, t9.salaire AS salaire_17, t9.salaire_restant AS salaire_restant_18, t9.agence_id AS agence_id_19, t9.user_id AS user_id_20, t0.role_id AS role_id_21, t0.role_profile_id AS role_profile_id_22 FROM "user" t0 LEFT JOIN employe t9 ON t9.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  11
]

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.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.device_id AS device_id_7,
  t0.enable_device_check AS enable_device_check_8,
  t9.id AS id_10,
  t9.matricule AS matricule_11,
  t9.nom AS nom_12,
  t9.prenom AS prenom_13,
  t9.tel AS tel_14,
  t9.create_at AS create_at_15,
  t9.update_at AS update_at_16,
  t9.salaire AS salaire_17,
  t9.salaire_restant AS salaire_restant_18,
  t9.agence_id AS agence_id_19,
  t9.user_id AS user_id_20,
  t0.role_id AS role_id_21,
  t0.role_profile_id AS role_profile_id_22
FROM
  "user" t0
  LEFT JOIN employe t9 ON t9.user_id = t0.id
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.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.device_id AS device_id_7, t0.enable_device_check AS enable_device_check_8, t9.id AS id_10, t9.matricule AS matricule_11, t9.nom AS nom_12, t9.prenom AS prenom_13, t9.tel AS tel_14, t9.create_at AS create_at_15, t9.update_at AS update_at_16, t9.salaire AS salaire_17, t9.salaire_restant AS salaire_restant_18, t9.agence_id AS agence_id_19, t9.user_id AS user_id_20, t0.role_id AS role_id_21, t0.role_profile_id AS role_profile_id_22 FROM "user" t0 LEFT JOIN employe t9 ON t9.user_id = t0.id WHERE t0.id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\Employe	No errors.
App\Entity\Agence	No errors.
App\Entity\Role	No errors.
App\Entity\RoleProfile	No errors.
App\Entity\Ticket	No errors.
App\Entity\Mission	No errors.
App\Entity\Presence	No errors.
App\Entity\Notification	No errors.
App\Entity\TicketRapport	No errors.
App\Entity\Penalite	No errors.
App\Entity\UserDevice	No errors.

Symfony Profiler

GET http://gpi.datm.tech/deconnexion

Configuration Settings

Theme