Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.62 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.88 ms

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

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
  120

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

#	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.42 ms

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 (1448, 1449, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467);

#	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.32 ms

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=7

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping