Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.77 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.57 ms
(31.96%)

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, (SELECT COUNT(u1_.id) AS sclr_13 FROM usuario u1_ INNER JOIN usuario_usuario_nivel u3_ ON u1_.id = u3_.usuario_id INNER JOIN usuario_nivel u2_ ON u2_.id = u3_.usuario_nivel_id WHERE u1_.id = u0_.id) AS sclr_12, u0_.create_by_id AS create_by_id_14, u0_.update_by_id AS update_by_id_15 FROM usuario u0_ LEFT JOIN usuario_usuario_nivel u5_ ON u0_.id = u5_.usuario_id LEFT JOIN usuario_nivel u4_ ON u4_.id = u5_.usuario_nivel_id WHERE u0_.id IN (?) ORDER BY sclr_12 DESC, u0_.id DESC

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,
  (
    SELECT
      COUNT(u1_.id) AS sclr_13
    FROM
      usuario u1_
      INNER JOIN usuario_usuario_nivel u3_ ON u1_.id = u3_.usuario_id
      INNER JOIN usuario_nivel u2_ ON u2_.id = u3_.usuario_nivel_id
    WHERE
      u1_.id = u0_.id
  ) AS sclr_12,
  u0_.create_by_id AS create_by_id_14,
  u0_.update_by_id AS update_by_id_15
FROM
  usuario u0_
  LEFT JOIN usuario_usuario_nivel u5_ ON u0_.id = u5_.usuario_id
  LEFT JOIN usuario_nivel u4_ ON u4_.id = u5_.usuario_nivel_id
WHERE
  u0_.id IN (?)
ORDER BY
  sclr_12 DESC,
  u0_.id DESC

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, (SELECT COUNT(u1_.id) AS sclr_13 FROM usuario u1_ INNER JOIN usuario_usuario_nivel u3_ ON u1_.id = u3_.usuario_id INNER JOIN usuario_nivel u2_ ON u2_.id = u3_.usuario_nivel_id WHERE u1_.id = u0_.id) AS sclr_12, u0_.create_by_id AS create_by_id_14, u0_.update_by_id AS update_by_id_15 FROM usuario u0_ LEFT JOIN usuario_usuario_nivel u5_ ON u0_.id = u5_.usuario_id LEFT JOIN usuario_nivel u4_ ON u4_.id = u5_.usuario_nivel_id WHERE u0_.id IN (1) ORDER BY sclr_12 DESC, u0_.id DESC;

#	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.49 ms
(27.77%)

SELECT DISTINCT u0_.id AS id_0, (SELECT COUNT(u1_.id) AS sclr_2 FROM usuario u1_ INNER JOIN usuario_usuario_nivel u3_ ON u1_.id = u3_.usuario_id INNER JOIN usuario_nivel u2_ ON u2_.id = u3_.usuario_nivel_id WHERE u1_.id = u0_.id) AS sclr_1, u0_.id AS id_3 FROM usuario u0_ LEFT JOIN usuario_usuario_nivel u5_ ON u0_.id = u5_.usuario_id LEFT JOIN usuario_nivel u4_ ON u4_.id = u5_.usuario_nivel_id ORDER BY sclr_1 DESC, u0_.id DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT u0_.id AS id_0,
  (
    SELECT
      COUNT(u1_.id) AS sclr_2
    FROM
      usuario u1_
      INNER JOIN usuario_usuario_nivel u3_ ON u1_.id = u3_.usuario_id
      INNER JOIN usuario_nivel u2_ ON u2_.id = u3_.usuario_nivel_id
    WHERE
      u1_.id = u0_.id
  ) AS sclr_1,
  u0_.id AS id_3
FROM
  usuario u0_
  LEFT JOIN usuario_usuario_nivel u5_ ON u0_.id = u5_.usuario_id
  LEFT JOIN usuario_nivel u4_ ON u4_.id = u5_.usuario_nivel_id
ORDER BY
  sclr_1 DESC,
  u0_.id DESC
LIMIT
  20

SELECT DISTINCT u0_.id AS id_0, (SELECT COUNT(u1_.id) AS sclr_2 FROM usuario u1_ INNER JOIN usuario_usuario_nivel u3_ ON u1_.id = u3_.usuario_id INNER JOIN usuario_nivel u2_ ON u2_.id = u3_.usuario_nivel_id WHERE u1_.id = u0_.id) AS sclr_1, u0_.id AS id_3 FROM usuario u0_ LEFT JOIN usuario_usuario_nivel u5_ ON u0_.id = u5_.usuario_id LEFT JOIN usuario_nivel u4_ ON u4_.id = u5_.usuario_nivel_id ORDER BY sclr_1 DESC, u0_.id DESC 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.39 ms
(21.96%)

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM usuario u0_ LEFT JOIN usuario_usuario_nivel u2_ ON u0_.id = u2_.usuario_id LEFT JOIN usuario_nivel u1_ ON u1_.id = u2_.usuario_nivel_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  usuario u0_
  LEFT JOIN usuario_usuario_nivel u2_ ON u0_.id = u2_.usuario_id
  LEFT JOIN usuario_nivel u1_ ON u1_.id = u2_.usuario_nivel_id

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM usuario u0_ LEFT JOIN usuario_usuario_nivel u2_ ON u0_.id = u2_.usuario_id LEFT JOIN usuario_nivel u1_ ON u1_.id = u2_.usuario_nivel_id;

#	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)

0.32 ms
(18.31%)

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)

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%5Bnivel%5D=DESC

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping