Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.98 ms Query time

1 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.98 ms
(100.00%)

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->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::__invoke():71} (line 74)
21	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
22	Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector->collect (line 70)
23	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
24	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
29	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	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\Usuario	No errors.
App\Entity\Empleado	The mappings App\Entity\Empleado#contactos and App\Entity\Contacto#empleado are inconsistent with each other.

Symfony Profiler

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

Configuration Settings

Theme

Page Width