Symfony Profiler

Query Metrics

60 Database Queries

6 Different statements

11.19 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.82 ms
(43.06%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.description AS description_7, t0.titolo AS titolo_8, t0.curatela AS curatela_9, t0.luogo AS luogo_10, t0.pathurl AS pathurl_11, t0.dettagliosino AS dettagliosino_12, t0.title AS title_13, t0.metadescription AS metadescription_14, t0.url AS url_15, t0.testolungo AS testolungo_16, t0.enabled AS enabled_17, t0.position AS position_18, t0.media_id AS media_id_19, t0.media2_id AS media2_id_20, t0.media3_id AS media3_id_21, t0.recensioni_id AS recensioni_id_22, t0.catalogo_id AS catalogo_id_23, t0.tutteimmagini_id AS tutteimmagini_id_24, t0.media23_id AS media23_id_25, t0.seo_id AS seo_id_26, t0.pdfcatalogo_id AS pdfcatalogo_id_27, t0.opere_id AS opere_id_28, t0.root_id AS root_id_29, t0.parent_id AS parent_id_30 FROM classification__category t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.description AS description_7,
  t0.titolo AS titolo_8,
  t0.curatela AS curatela_9,
  t0.luogo AS luogo_10,
  t0.pathurl AS pathurl_11,
  t0.dettagliosino AS dettagliosino_12,
  t0.title AS title_13,
  t0.metadescription AS metadescription_14,
  t0.url AS url_15,
  t0.testolungo AS testolungo_16,
  t0.enabled AS enabled_17,
  t0.position AS position_18,
  t0.media_id AS media_id_19,
  t0.media2_id AS media2_id_20,
  t0.media3_id AS media3_id_21,
  t0.recensioni_id AS recensioni_id_22,
  t0.catalogo_id AS catalogo_id_23,
  t0.tutteimmagini_id AS tutteimmagini_id_24,
  t0.media23_id AS media23_id_25,
  t0.seo_id AS seo_id_26,
  t0.pdfcatalogo_id AS pdfcatalogo_id_27,
  t0.opere_id AS opere_id_28,
  t0.root_id AS root_id_29,
  t0.parent_id AS parent_id_30
FROM
  classification__category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.description AS description_7, t0.titolo AS titolo_8, t0.curatela AS curatela_9, t0.luogo AS luogo_10, t0.pathurl AS pathurl_11, t0.dettagliosino AS dettagliosino_12, t0.title AS title_13, t0.metadescription AS metadescription_14, t0.url AS url_15, t0.testolungo AS testolungo_16, t0.enabled AS enabled_17, t0.position AS position_18, t0.media_id AS media_id_19, t0.media2_id AS media2_id_20, t0.media3_id AS media3_id_21, t0.recensioni_id AS recensioni_id_22, t0.catalogo_id AS catalogo_id_23, t0.tutteimmagini_id AS tutteimmagini_id_24, t0.media23_id AS media23_id_25, t0.seo_id AS seo_id_26, t0.pdfcatalogo_id AS pdfcatalogo_id_27, t0.opere_id AS opere_id_28, t0.root_id AS root_id_29, t0.parent_id AS parent_id_30 FROM classification__category t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 333)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 111)
5	Closure->__invoke (line 111)
6	Proxies\__CG__\App\Entity\Categoria->__load (line 116)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 75)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->createForEntityInstance (line 188)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToOneAssociation (line 133)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 107)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 143)
14	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

2.63 ms
(23.53%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.media_id AS media_id_3, t0.gallery_id AS gallery_id_4 FROM media__gallery_media t0 WHERE t0.gallery_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.media_id AS media_id_3,
  t0.gallery_id AS gallery_id_4
FROM
  media__gallery_media t0
WHERE
  t0.gallery_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.media_id AS media_id_3, t0.gallery_id AS gallery_id_4 FROM media__gallery_media t0 WHERE t0.gallery_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 57)
9	App\Entity\MediaGallery->getImmagine (line 411)
10	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 112)
11	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 51)
12	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\CommonPreConfigurator->configure (line 107)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
15	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 143)
16	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

2.62 ms
(23.40%)

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.type AS type_3, t0.width AS width_4, t0.height AS height_5, t0.immagine AS immagine_6, t0.url AS url_7, t0.titolo AS titolo_8, t0.ext AS ext_9, t0.folder AS folder_10, t0.sel AS sel_11, t0.idold AS idold_12, t0.tecnica AS tecnica_13, t0.dimensione AS dimensione_14, t0.altro AS altro_15, t0.dataopera AS dataopera_16, t0.descrizione AS descrizione_17, t0.parent_id AS parent_id_18, t0.category_id AS category_id_19, t0.seo_id AS seo_id_20 FROM cat t0 WHERE t0.id = ?

Parameters:

[
  4112
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.type AS type_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.immagine AS immagine_6,
  t0.url AS url_7,
  t0.titolo AS titolo_8,
  t0.ext AS ext_9,
  t0.folder AS folder_10,
  t0.sel AS sel_11,
  t0.idold AS idold_12,
  t0.tecnica AS tecnica_13,
  t0.dimensione AS dimensione_14,
  t0.altro AS altro_15,
  t0.dataopera AS dataopera_16,
  t0.descrizione AS descrizione_17,
  t0.parent_id AS parent_id_18,
  t0.category_id AS category_id_19,
  t0.seo_id AS seo_id_20
FROM
  cat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.type AS type_3, t0.width AS width_4, t0.height AS height_5, t0.immagine AS immagine_6, t0.url AS url_7, t0.titolo AS titolo_8, t0.ext AS ext_9, t0.folder AS folder_10, t0.sel AS sel_11, t0.idold AS idold_12, t0.tecnica AS tecnica_13, t0.dimensione AS dimensione_14, t0.altro AS altro_15, t0.dataopera AS dataopera_16, t0.descrizione AS descrizione_17, t0.parent_id AS parent_id_18, t0.category_id AS category_id_19, t0.seo_id AS seo_id_20 FROM cat t0 WHERE t0.id = 4112;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 333)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 186)
5	Closure->__invoke (line 186)
6	Proxies\__CG__\App\Entity\Cat->__toString (line 76)
7	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\ImageConfigurator->getImagePath (line 36)
8	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\ImageConfigurator->configure (line 107)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 143)
12	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.79 ms
(7.05%)

SELECT DISTINCT m0_.id AS id_0 FROM media__gallery m0_ LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT m0_.id AS id_0
FROM
  media__gallery m0_
LIMIT
  20

SELECT DISTINCT m0_.id AS id_0 FROM media__gallery m0_ LIMIT 20;

#	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.18 ms
(1.59%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.context AS context_2, m0_.enabled AS enabled_3, m0_.titolo AS titolo_4, m0_.descrizione AS descrizione_5, m0_.title AS title_6, m0_.metadescription AS metadescription_7, m0_.url AS url_8, m0_.category_id AS category_id_9 FROM media__gallery 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_.context AS context_2,
  m0_.enabled AS enabled_3,
  m0_.titolo AS titolo_4,
  m0_.descrizione AS descrizione_5,
  m0_.title AS title_6,
  m0_.metadescription AS metadescription_7,
  m0_.url AS url_8,
  m0_.category_id AS category_id_9
FROM
  media__gallery m0_
WHERE
  m0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.context AS context_2, m0_.enabled AS enabled_3, m0_.titolo AS titolo_4, m0_.descrizione AS descrizione_5, m0_.title AS title_6, m0_.metadescription AS metadescription_7, m0_.url AS url_8, m0_.category_id AS category_id_9 FROM media__gallery m0_ WHERE m0_.id IN (2, 5, 6, 13, 8, 9, 7, 12, 16, 14, 15, 17, 10, 11, 19, 20, 21, 22, 23);

#	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.15 ms
(1.36%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT count(m0_.id) AS sclr_0 FROM media__gallery 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\MediaGallery	No errors.
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.
App\Entity\Galleryhasmedia	No errors.
App\Entity\Cat	No errors.
App\Entity\CategoryImages	No errors.
App\Entity\Seo	The association App\Entity\Seo#immagine refers to the inverse side field App\Entity\Cat#seos which does not exist.

Symfony Profiler

GET https://simoneracheli.it/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CMediaGalleryCrudController&entityFqcn=App%5CEntity%5CMediaGallery

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping