Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.10 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.77 ms
(36.83%)

SELECT DISTINCT u0_.id AS id_0, u0_.nombre AS nombre_1 FROM usuario u0_ ORDER BY u0_.nombre ASC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.nombre AS nombre_1
FROM
  usuario u0_
ORDER BY
  u0_.nombre ASC
LIMIT
  20

SELECT DISTINCT u0_.id AS id_0, u0_.nombre AS nombre_1 FROM usuario u0_ ORDER BY u0_.nombre ASC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 70)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.57 ms
(27.06%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.create_at AS create_at_4, t0.update_at AS update_at_5, t0.supervisor_id AS supervisor_id_6, t0.create_by_id AS create_by_id_7, t0.update_by_id AS update_by_id_8 FROM usuario_nivel t0 INNER JOIN usuario_usuario_nivel ON t0.id = usuario_usuario_nivel.usuario_nivel_id WHERE usuario_usuario_nivel.usuario_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.codigo AS codigo_3,
  t0.create_at AS create_at_4,
  t0.update_at AS update_at_5,
  t0.supervisor_id AS supervisor_id_6,
  t0.create_by_id AS create_by_id_7,
  t0.update_by_id AS update_by_id_8
FROM
  usuario_nivel t0
  INNER JOIN usuario_usuario_nivel ON t0.id = usuario_usuario_nivel.usuario_nivel_id
WHERE
  usuario_usuario_nivel.usuario_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.create_at AS create_at_4, t0.update_at AS update_at_5, t0.supervisor_id AS supervisor_id_6, t0.create_by_id AS create_by_id_7, t0.update_by_id AS update_by_id_8 FROM usuario_nivel t0 INNER JOIN usuario_usuario_nivel ON t0.id = usuario_usuario_nivel.usuario_nivel_id WHERE usuario_usuario_nivel.usuario_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 276)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->countNumElements (line 226)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToManyAssociation (line 142)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 102)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 143)
15	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.43 ms
(20.39%)

SELECT u0_.id AS id_0, u0_.nick AS nick_1, u0_.password AS password_2, u0_.nombre AS nombre_3, u0_.dni AS dni_4, u0_.direccion AS direccion_5, u0_.telefono AS telefono_6, u0_.localidad AS localidad_7, u0_.visible AS visible_8, u0_.email AS email_9, u0_.create_at AS create_at_10, u0_.update_at AS update_at_11, u0_.create_by_id AS create_by_id_12, u0_.update_by_id AS update_by_id_13 FROM usuario u0_ WHERE u0_.id IN (?) ORDER BY u0_.nombre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.nick AS nick_1,
  u0_.password AS password_2,
  u0_.nombre AS nombre_3,
  u0_.dni AS dni_4,
  u0_.direccion AS direccion_5,
  u0_.telefono AS telefono_6,
  u0_.localidad AS localidad_7,
  u0_.visible AS visible_8,
  u0_.email AS email_9,
  u0_.create_at AS create_at_10,
  u0_.update_at AS update_at_11,
  u0_.create_by_id AS create_by_id_12,
  u0_.update_by_id AS update_by_id_13
FROM
  usuario u0_
WHERE
  u0_.id IN (?)
ORDER BY
  u0_.nombre ASC

SELECT u0_.id AS id_0, u0_.nick AS nick_1, u0_.password AS password_2, u0_.nombre AS nombre_3, u0_.dni AS dni_4, u0_.direccion AS direccion_5, u0_.telefono AS telefono_6, u0_.localidad AS localidad_7, u0_.visible AS visible_8, u0_.email AS email_9, u0_.create_at AS create_at_10, u0_.update_at AS update_at_11, u0_.create_by_id AS create_by_id_12, u0_.update_by_id AS update_by_id_13 FROM usuario u0_ WHERE u0_.id IN (1) ORDER BY u0_.nombre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 70)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.33 ms
(15.72%)

SELECT count(*) AS sclr_0 FROM usuario u0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  usuario u0_

SELECT count(*) AS sclr_0 FROM usuario u0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\Usuario	No errors.
App\Entity\UsuarioNivel	No errors.

Symfony Profiler

GET http://whatsapp.jizen.com.ar/usuario?page=1&sort%5Bnombre%5D=ASC

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping