Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.79 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.94 ms
(52.49%)

SELECT DISTINCT r0_.id AS id_0 FROM region_provincia r0_ LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT r0_.id AS id_0
FROM
  region_provincia r0_
LIMIT
  20

SELECT DISTINCT r0_.id AS id_0 FROM region_provincia r0_ LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 67)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.56 ms
(31.09%)

SELECT r0_.id AS id_0, r0_.codigo AS codigo_1, r0_.nombre AS nombre_2 FROM region_provincia r0_ WHERE r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.codigo AS codigo_1,
  r0_.nombre AS nombre_2
FROM
  region_provincia r0_
WHERE
  r0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT r0_.id AS id_0, r0_.codigo AS codigo_1, r0_.nombre AS nombre_2 FROM region_provincia r0_ WHERE r0_.id IN (484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 67)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.29 ms
(16.42%)

SELECT count(r0_.id) AS sclr_0 FROM region_provincia r0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(r0_.id) AS sclr_0
FROM
  region_provincia r0_

SELECT count(r0_.id) AS sclr_0 FROM region_provincia r0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 68)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
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\RegionProvincia	No errors.

Symfony Profiler

GET http://sie.nesistel.net/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CRegionProvinciaCrudController&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping