Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.87 ms Query time

5 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.87 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.fcm_token_hermes AS fcm_token_hermes_14, t0.base_password AS base_password_15, t0.empleado_id AS empleado_id_16 FROM usuario t0 WHERE t0.username = ? LIMIT 1

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.fcm_token_hermes AS fcm_token_hermes_14,
  t0.base_password AS base_password_15,
  t0.empleado_id AS empleado_id_16
FROM
  usuario t0
WHERE
  t0.username = ?
LIMIT
  1

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.fcm_token_hermes AS fcm_token_hermes_14, t0.base_password AS base_password_15, t0.empleado_id AS empleado_id_16 FROM usuario t0 WHERE t0.username = '413' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 54)
4	Symfony\Component\Security\Http\RememberMe\AbstractRememberMeHandler->consumeRememberMeCookie (line 60)
5	Symfony\Component\Security\Http\RememberMe\SignatureRememberMeHandler->consumeRememberMeCookie (line 64)
6	Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator->{closure:Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator::authenticate():105} (line 105)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 101)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	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

Entities Mapping

Class	Mapping errors
App\Entity\ATAccion	No errors.
App\Entity\ATAccionAdjunto	No errors.
App\Entity\ATEtiqueta	No errors.
App\Entity\AbonoPrestamo	No errors.
App\Entity\Acceso	No errors.
App\Entity\AccesoPlanta	No errors.
App\Entity\AgendaTrabajo	No errors.
App\Entity\Anden	No errors.
App\Entity\Area	No errors.
App\Entity\Asistencia	No errors.
App\Entity\Banco	No errors.
App\Entity\BusinessPartner	No errors.
App\Entity\CambioEstado	No errors.
App\Entity\Categoria	No errors.
App\Entity\Checador	No errors.
App\Entity\Concepto	No errors.
App\Entity\ConceptoMantenimiento	No errors.
App\Entity\Contacto	The association App\Entity\Contacto#empleado refers to the inverse side field App\Entity\Empleado#contacto which does not exist.
App\Entity\ContenidoReporteFotografico	No errors.
App\Entity\CuentaBancaria	No errors.
App\Entity\Departamento	No errors.
App\Entity\Descanso	No errors.
App\Entity\DiasFestivos	No errors.
App\Entity\Documento	No errors.
App\Entity\Empleado	The mappings App\Entity\Empleado#contactos and App\Entity\Contacto#empleado are inconsistent with each other.
App\Entity\EmpleadoPlanta	The association App\Entity\EmpleadoPlanta#nominas refers to the owning side field App\Entity\Nomina#EmpleadoPlanta which does not exist.
App\Entity\EntradaSalida	No errors.
App\Entity\Estado	No errors.
App\Entity\Estatus	No errors.
App\Entity\FCatalogo	No errors.
App\Entity\FFormulario	No errors.
App\Entity\FFormularioACL	No errors.
App\Entity\FReporte	No errors.
App\Entity\FRespuesta	No errors.
App\Entity\FormatoUbicacion	No errors.
App\Entity\Gafete	No errors.
App\Entity\GeneralLog	No errors.
App\Entity\Geolog	No errors.
App\Entity\GlobalConfig	No errors.
App\Entity\GrupoEmpresarial	No errors.
App\Entity\GrupoUsuario	No errors.
App\Entity\Horario	No errors.
App\Entity\HorasExtra	No errors.
App\Entity\HorasExtraEvidenciaDocumental	No errors.
App\Entity\Item	No errors.
App\Entity\ItemGroup	No errors.
App\Entity\ItemPrice	No errors.
App\Entity\ItemProperty	No errors.
App\Entity\Itinerario	No errors.
App\Entity\JustificacionIncidencia	The association App\Entity\JustificacionIncidencia#documentos refers to the owning side field App\Entity\Documento#justificacion which does not exist.
App\Entity\Kilometraje	No errors.
App\Entity\Localidad	No errors.
App\Entity\Mantenimiento	No errors.
App\Entity\Marca	No errors.
App\Entity\MotivoBaja	No errors.
App\Entity\MotivoBajaUnidad	No errors.
App\Entity\Municipio	No errors.
App\Entity\Nacionalidad	No errors.
App\Entity\Nomina	The mappings App\Entity\Nomina#empleadoPlanta and App\Entity\EmpleadoPlanta#nominas are inconsistent with each other.
App\Entity\NominaConcentrado	No errors.
App\Entity\OcTemplates	No errors.
App\Entity\Placa	No errors.
App\Entity\Usuario	No errors.

Symfony Profiler

GET https://qa.siopex.com/test

Configuration Settings

Theme

Page Width