Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.53 ms Query time

2 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.53 ms

SELECT t0.id AS id_1, t0.username AS username_2, t0.correo AS correo_3, t0.roles AS roles_4, t0.password AS password_5, t0.last_access AS last_access_6, t0.last_ip AS last_ip_7, t0.created_at AS created_at_8, t0.estatus AS estatus_9, t0.restore_hash AS restore_hash_10, t0.permisos AS permisos_11, t0.fcm_token AS fcm_token_12, t0.fcm_token_web AS fcm_token_web_13, t0.base_password AS base_password_14, t0.empleado_id AS empleado_id_15 FROM usuario t0 WHERE t0.id = ?

Parameters:

[
  413
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.correo AS correo_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.last_access AS last_access_6,
  t0.last_ip AS last_ip_7,
  t0.created_at AS created_at_8,
  t0.estatus AS estatus_9,
  t0.restore_hash AS restore_hash_10,
  t0.permisos AS permisos_11,
  t0.fcm_token AS fcm_token_12,
  t0.fcm_token_web AS fcm_token_web_13,
  t0.base_password AS base_password_14,
  t0.empleado_id AS empleado_id_15
FROM
  usuario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.correo AS correo_3, t0.roles AS roles_4, t0.password AS password_5, t0.last_access AS last_access_6, t0.last_ip AS last_ip_7, t0.created_at AS created_at_8, t0.estatus AS estatus_9, t0.restore_hash AS restore_hash_10, t0.permisos AS permisos_11, t0.fcm_token AS fcm_token_12, t0.fcm_token_web AS fcm_token_web_13, t0.base_password AS base_password_14, t0.empleado_id AS empleado_id_15 FROM usuario t0 WHERE t0.id = 413;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 799)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::__invoke():71} (line 74)
10	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
11	Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector->collect (line 70)
12	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
13	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	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\Usuario	1
App\Entity\Empleado	1

Entities Mapping

Class	Mapping errors
App\Entity\Usuario	No errors.
App\Entity\Empleado	The mappings App\Entity\Empleado#contactos and App\Entity\Contacto#empleado are inconsistent with each other.
App\Entity\Visita	No errors.
App\Entity\Unidad	The field 'App\Entity\Unidad#eco' has the property type 'int' that differs from the metadata field type 'string' returned by the 'string' DBAL type. The mappings App\Entity\Unidad#placa and App\Entity\Placa#unidad are inconsistent with each other.
App\Entity\Visitante	No errors.
App\Entity\Documento	No errors.
App\Entity\EntradaSalida	No errors.
App\Entity\PlantillaSeguridad	No errors.
App\Entity\GrupoUsuario	No errors.
App\Entity\Acceso	No errors.
App\Entity\VisEtiqueta	No errors.
App\Entity\Planta	No errors.
App\Entity\GeneralLog	No errors.
App\Entity\Kilometraje	No errors.
App\Entity\ReporteGasolina	No errors.
App\Entity\Proveedor	No errors.
App\Entity\Mantenimiento	No errors.
App\Entity\ReporteKilometraje	No errors.
App\Entity\ReporteFotografico	No errors.

Symfony Profiler

GET https://devtoo.siopex.com/check_idle_time

Configuration Settings

Theme

Page Width