Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.59 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.11 ms
(69.95%)

SELECT DISTINCT m0_.id AS id_0 FROM media__media m0_ LIMIT 20 OFFSET 180

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT m0_.id AS id_0
FROM
  media__media m0_
LIMIT
  20
OFFSET
  180

SELECT DISTINCT m0_.id AS id_0 FROM media__media m0_ LIMIT 20 OFFSET 180;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
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.34 ms
(21.68%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.description AS description_2, m0_.enabled AS enabled_3, m0_.provider_reference AS provider_reference_4, m0_.tecnica AS tecnica_5, m0_.dimensione AS dimensione_6, m0_.altro AS altro_7, m0_.dataopera AS dataopera_8, m0_.titolo AS titolo_9, m0_.descrizione AS descrizione_10, m0_.title AS title_11, m0_.metadescription AS metadescription_12, m0_.url AS url_13 FROM media__media m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.description AS description_2,
  m0_.enabled AS enabled_3,
  m0_.provider_reference AS provider_reference_4,
  m0_.tecnica AS tecnica_5,
  m0_.dimensione AS dimensione_6,
  m0_.altro AS altro_7,
  m0_.dataopera AS dataopera_8,
  m0_.titolo AS titolo_9,
  m0_.descrizione AS descrizione_10,
  m0_.title AS title_11,
  m0_.metadescription AS metadescription_12,
  m0_.url AS url_13
FROM
  media__media m0_
WHERE
  m0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.description AS description_2, m0_.enabled AS enabled_3, m0_.provider_reference AS provider_reference_4, m0_.tecnica AS tecnica_5, m0_.dimensione AS dimensione_6, m0_.altro AS altro_7, m0_.dataopera AS dataopera_8, m0_.titolo AS titolo_9, m0_.descrizione AS descrizione_10, m0_.title AS title_11, m0_.metadescription AS metadescription_12, m0_.url AS url_13 FROM media__media m0_ WHERE m0_.id IN (1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1521, 1522, 1523, 1524, 1525, 1526, 1527, 1529, 1530);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
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.13 ms
(8.37%)

SELECT count(m0_.id) AS sclr_0 FROM media__media m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(m0_.id) AS sclr_0
FROM
  media__media m0_

SELECT count(m0_.id) AS sclr_0 FROM media__media m0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
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\MediaMedia	The mappings App\Entity\MediaMedia#categorias and App\Entity\Categoria#parent are inconsistent with each other.
Umanit\EasyAdminTreeBundle\Entity\AbstractTreeItem	No errors.
App\Entity\Categoria	The mappings App\Entity\Categoria#opere and App\Entity\Cat#categorias are inconsistent with each other.

Symfony Profiler

GET https://simoneracheli.it/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CMediaMediaCrudController&page=10

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping