Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.72 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.86 ms
(49.95%)

SELECT DISTINCT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.permisos AS permisos_3, u0_.password AS password_4, u0_.nombre AS nombre_5, u0_.apellido AS apellido_6, u0_.activo AS activo_7, u0_.last_login_at AS last_login_at_8, u0_.password_changed_at AS password_changed_at_9, u0_.created_at AS created_at_10, u0_.updated_at AS updated_at_11, u0_.failed_login_attempts AS failed_login_attempts_12, u0_.locked_until AS locked_until_13, u0_.must_change_password AS must_change_password_14, u0_.clearance AS clearance_15, a1_.id AS id_16, a1_.uuid AS uuid_17, a1_.clearance AS clearance_18, a1_.nombre_original AS nombre_original_19, a1_.nombre_almacenado AS nombre_almacenado_20, a1_.ruta AS ruta_21, a1_.mime_type AS mime_type_22, a1_.tamanio AS tamanio_23, a1_.extension AS extension_24, a1_.contexto AS contexto_25, a1_.entity_type AS entity_type_26, a1_.entity_id AS entity_id_27, a1_.created_at AS created_at_28, a1_.updated_at AS updated_at_29, u0_.avatar_id AS avatar_id_30, a1_.subido_por_id AS subido_por_id_31 FROM user u0_ LEFT JOIN user_empresa u3_ ON u0_.id = u3_.user_id LEFT JOIN empresa e2_ ON e2_.id = u3_.empresa_id LEFT JOIN archivo a1_ ON u0_.avatar_id = a1_.id ORDER BY u0_.apellido ASC, u0_.nombre ASC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.permisos AS permisos_3,
  u0_.password AS password_4,
  u0_.nombre AS nombre_5,
  u0_.apellido AS apellido_6,
  u0_.activo AS activo_7,
  u0_.last_login_at AS last_login_at_8,
  u0_.password_changed_at AS password_changed_at_9,
  u0_.created_at AS created_at_10,
  u0_.updated_at AS updated_at_11,
  u0_.failed_login_attempts AS failed_login_attempts_12,
  u0_.locked_until AS locked_until_13,
  u0_.must_change_password AS must_change_password_14,
  u0_.clearance AS clearance_15,
  a1_.id AS id_16,
  a1_.uuid AS uuid_17,
  a1_.clearance AS clearance_18,
  a1_.nombre_original AS nombre_original_19,
  a1_.nombre_almacenado AS nombre_almacenado_20,
  a1_.ruta AS ruta_21,
  a1_.mime_type AS mime_type_22,
  a1_.tamanio AS tamanio_23,
  a1_.extension AS extension_24,
  a1_.contexto AS contexto_25,
  a1_.entity_type AS entity_type_26,
  a1_.entity_id AS entity_id_27,
  a1_.created_at AS created_at_28,
  a1_.updated_at AS updated_at_29,
  u0_.avatar_id AS avatar_id_30,
  a1_.subido_por_id AS subido_por_id_31
FROM
  user u0_
  LEFT JOIN user_empresa u3_ ON u0_.id = u3_.user_id
  LEFT JOIN empresa e2_ ON e2_.id = u3_.empresa_id
  LEFT JOIN archivo a1_ ON u0_.avatar_id = a1_.id
ORDER BY
  u0_.apellido ASC,
  u0_.nombre ASC
LIMIT
  10

SELECT DISTINCT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.permisos AS permisos_3, u0_.password AS password_4, u0_.nombre AS nombre_5, u0_.apellido AS apellido_6, u0_.activo AS activo_7, u0_.last_login_at AS last_login_at_8, u0_.password_changed_at AS password_changed_at_9, u0_.created_at AS created_at_10, u0_.updated_at AS updated_at_11, u0_.failed_login_attempts AS failed_login_attempts_12, u0_.locked_until AS locked_until_13, u0_.must_change_password AS must_change_password_14, u0_.clearance AS clearance_15, a1_.id AS id_16, a1_.uuid AS uuid_17, a1_.clearance AS clearance_18, a1_.nombre_original AS nombre_original_19, a1_.nombre_almacenado AS nombre_almacenado_20, a1_.ruta AS ruta_21, a1_.mime_type AS mime_type_22, a1_.tamanio AS tamanio_23, a1_.extension AS extension_24, a1_.contexto AS contexto_25, a1_.entity_type AS entity_type_26, a1_.entity_id AS entity_id_27, a1_.created_at AS created_at_28, a1_.updated_at AS updated_at_29, u0_.avatar_id AS avatar_id_30, a1_.subido_por_id AS subido_por_id_31 FROM user u0_ LEFT JOIN user_empresa u3_ ON u0_.id = u3_.user_id LEFT JOIN empresa e2_ ON e2_.id = u3_.empresa_id LEFT JOIN archivo a1_ ON u0_.avatar_id = a1_.id ORDER BY u0_.apellido ASC, u0_.nombre ASC LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\UserRepository->findByFilters (line 301)
7	App\Controller\UserController->index (line 35)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.98 ms
(26.33%)

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_empresa u2_ ON u0_.id = u2_.user_id LEFT JOIN empresa e1_ ON e1_.id = u2_.empresa_id LEFT JOIN archivo a3_ ON u0_.avatar_id = a3_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_empresa u2_ ON u0_.id = u2_.user_id
  LEFT JOIN empresa e1_ ON e1_.id = u2_.empresa_id
  LEFT JOIN archivo a3_ ON u0_.avatar_id = a3_.id

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_empresa u2_ ON u0_.id = u2_.user_id LEFT JOIN empresa e1_ ON e1_.id = u2_.empresa_id LEFT JOIN archivo a3_ ON u0_.avatar_id = a3_.id;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\UserRepository->findByFilters (line 271)
8	App\Controller\UserController->index (line 35)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.88 ms
(23.73%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.permisos AS permisos_4, t0.password AS password_5, t0.nombre AS nombre_6, t0.apellido AS apellido_7, t0.activo AS activo_8, t0.last_login_at AS last_login_at_9, t0.password_changed_at AS password_changed_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.failed_login_attempts AS failed_login_attempts_13, t0.locked_until AS locked_until_14, t0.must_change_password AS must_change_password_15, t0.clearance AS clearance_16, t0.avatar_id AS avatar_id_17 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

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.permisos AS permisos_4,
  t0.password AS password_5,
  t0.nombre AS nombre_6,
  t0.apellido AS apellido_7,
  t0.activo AS activo_8,
  t0.last_login_at AS last_login_at_9,
  t0.password_changed_at AS password_changed_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.failed_login_attempts AS failed_login_attempts_13,
  t0.locked_until AS locked_until_14,
  t0.must_change_password AS must_change_password_15,
  t0.clearance AS clearance_16,
  t0.avatar_id AS avatar_id_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.permisos AS permisos_4, t0.password AS password_5, t0.nombre AS nombre_6, t0.apellido AS apellido_7, t0.activo AS activo_8, t0.last_login_at AS last_login_at_9, t0.password_changed_at AS password_changed_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.failed_login_attempts AS failed_login_attempts_13, t0.locked_until AS locked_until_14, t0.must_change_password AS must_change_password_15, t0.clearance AS clearance_16, t0.avatar_id AS avatar_id_17 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 191)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	10

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Archivo	No errors.
App\Entity\Empresa	No errors.

Symfony Profiler

GET https://tidy.alfredocruz.cl/admin/users

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping