Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

2.04 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.12 ms
(54.99%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.lft AS lft_2, c0_.lvl AS lvl_3, c0_.rgt AS rgt_4, c0_.slug AS slug_5, c0_.description AS description_6, c0_.titolo AS titolo_7, c0_.curatela AS curatela_8, c0_.luogo AS luogo_9, c0_.pathurl AS pathurl_10, c0_.dettagliosino AS dettagliosino_11, c0_.title AS title_12, c0_.metadescription AS metadescription_13, c0_.url AS url_14, c0_.testolungo AS testolungo_15, c0_.enabled AS enabled_16, c0_.position AS position_17, c0_.media_id AS media_id_18, c0_.media2_id AS media2_id_19, c0_.media3_id AS media3_id_20, c0_.recensioni_id AS recensioni_id_21, c0_.catalogo_id AS catalogo_id_22, c0_.tutteimmagini_id AS tutteimmagini_id_23, c0_.media23_id AS media23_id_24, c0_.seo_id AS seo_id_25, c0_.pdfcatalogo_id AS pdfcatalogo_id_26, c0_.opere_id AS opere_id_27, c0_.root_id AS root_id_28, c0_.parent_id AS parent_id_29 FROM classification__category c0_ WHERE c0_.name = ?

Parameters:

[
  "ARTWORKS"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.lft AS lft_2,
  c0_.lvl AS lvl_3,
  c0_.rgt AS rgt_4,
  c0_.slug AS slug_5,
  c0_.description AS description_6,
  c0_.titolo AS titolo_7,
  c0_.curatela AS curatela_8,
  c0_.luogo AS luogo_9,
  c0_.pathurl AS pathurl_10,
  c0_.dettagliosino AS dettagliosino_11,
  c0_.title AS title_12,
  c0_.metadescription AS metadescription_13,
  c0_.url AS url_14,
  c0_.testolungo AS testolungo_15,
  c0_.enabled AS enabled_16,
  c0_.position AS position_17,
  c0_.media_id AS media_id_18,
  c0_.media2_id AS media2_id_19,
  c0_.media3_id AS media3_id_20,
  c0_.recensioni_id AS recensioni_id_21,
  c0_.catalogo_id AS catalogo_id_22,
  c0_.tutteimmagini_id AS tutteimmagini_id_23,
  c0_.media23_id AS media23_id_24,
  c0_.seo_id AS seo_id_25,
  c0_.pdfcatalogo_id AS pdfcatalogo_id_26,
  c0_.opere_id AS opere_id_27,
  c0_.root_id AS root_id_28,
  c0_.parent_id AS parent_id_29
FROM
  classification__category c0_
WHERE
  c0_.name = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.lft AS lft_2, c0_.lvl AS lvl_3, c0_.rgt AS rgt_4, c0_.slug AS slug_5, c0_.description AS description_6, c0_.titolo AS titolo_7, c0_.curatela AS curatela_8, c0_.luogo AS luogo_9, c0_.pathurl AS pathurl_10, c0_.dettagliosino AS dettagliosino_11, c0_.title AS title_12, c0_.metadescription AS metadescription_13, c0_.url AS url_14, c0_.testolungo AS testolungo_15, c0_.enabled AS enabled_16, c0_.position AS position_17, c0_.media_id AS media_id_18, c0_.media2_id AS media2_id_19, c0_.media3_id AS media3_id_20, c0_.recensioni_id AS recensioni_id_21, c0_.catalogo_id AS catalogo_id_22, c0_.tutteimmagini_id AS tutteimmagini_id_23, c0_.media23_id AS media23_id_24, c0_.seo_id AS seo_id_25, c0_.pdfcatalogo_id AS pdfcatalogo_id_26, c0_.opere_id AS opere_id_27, c0_.root_id AS root_id_28, c0_.parent_id AS parent_id_29 FROM classification__category c0_ WHERE c0_.name = 'ARTWORKS';

#	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 45)
7	App\Repository\CategoriaRepository->findCatbyName (line 54)
8	App\Controller\IndexController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.60 ms
(29.60%)

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.parent_id = ?

Parameters:

[
  1
]

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.parent_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.parent_id = 1;

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 103)
8	__TwigTemplate_b32eb9a0639dfd41ff52588a87408ce9->doDisplay (line 393)
9	Twig\Template->yield (line 349)
10	Twig\Template->display (line 364)
11	Twig\Template->render (line 35)
12	Twig\TemplateWrapper->render (line 306)
13	Twig\Environment->render (line 243)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 40)
16	App\Controller\CategoryController->categoriesAction (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
20	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
21	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
22	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
23	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 282)
24	__TwigTemplate_5ad3ad93725a309d0150ef2d0c7cdc48->block_body (line 437)
25	Twig\Template->yieldBlock (line 69)
26	__TwigTemplate_5ad3ad93725a309d0150ef2d0c7cdc48->doDisplay (line 393)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_4418dc9acf95f6af55372ed26f39abb7->doDisplay (line 393)
29	Twig\Template->yield (line 349)
30	Twig\Template->display (line 364)
31	Twig\Template->render (line 35)
32	Twig\TemplateWrapper->render (line 306)
33	Twig\Environment->render (line 243)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 56)
36	App\Controller\IndexController->index (line 181)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

0.31 ms
(15.41%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.lft AS lft_2, c0_.lvl AS lvl_3, c0_.rgt AS rgt_4, c0_.slug AS slug_5, c0_.description AS description_6, c0_.titolo AS titolo_7, c0_.curatela AS curatela_8, c0_.luogo AS luogo_9, c0_.pathurl AS pathurl_10, c0_.dettagliosino AS dettagliosino_11, c0_.title AS title_12, c0_.metadescription AS metadescription_13, c0_.url AS url_14, c0_.testolungo AS testolungo_15, c0_.enabled AS enabled_16, c0_.position AS position_17, c0_.media_id AS media_id_18, c0_.media2_id AS media2_id_19, c0_.media3_id AS media3_id_20, c0_.recensioni_id AS recensioni_id_21, c0_.catalogo_id AS catalogo_id_22, c0_.tutteimmagini_id AS tutteimmagini_id_23, c0_.media23_id AS media23_id_24, c0_.seo_id AS seo_id_25, c0_.pdfcatalogo_id AS pdfcatalogo_id_26, c0_.opere_id AS opere_id_27, c0_.root_id AS root_id_28, c0_.parent_id AS parent_id_29 FROM classification__category c0_ WHERE c0_.parent_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.lft AS lft_2,
  c0_.lvl AS lvl_3,
  c0_.rgt AS rgt_4,
  c0_.slug AS slug_5,
  c0_.description AS description_6,
  c0_.titolo AS titolo_7,
  c0_.curatela AS curatela_8,
  c0_.luogo AS luogo_9,
  c0_.pathurl AS pathurl_10,
  c0_.dettagliosino AS dettagliosino_11,
  c0_.title AS title_12,
  c0_.metadescription AS metadescription_13,
  c0_.url AS url_14,
  c0_.testolungo AS testolungo_15,
  c0_.enabled AS enabled_16,
  c0_.position AS position_17,
  c0_.media_id AS media_id_18,
  c0_.media2_id AS media2_id_19,
  c0_.media3_id AS media3_id_20,
  c0_.recensioni_id AS recensioni_id_21,
  c0_.catalogo_id AS catalogo_id_22,
  c0_.tutteimmagini_id AS tutteimmagini_id_23,
  c0_.media23_id AS media23_id_24,
  c0_.seo_id AS seo_id_25,
  c0_.pdfcatalogo_id AS pdfcatalogo_id_26,
  c0_.opere_id AS opere_id_27,
  c0_.root_id AS root_id_28,
  c0_.parent_id AS parent_id_29
FROM
  classification__category c0_
WHERE
  c0_.parent_id IS NULL

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.lft AS lft_2, c0_.lvl AS lvl_3, c0_.rgt AS rgt_4, c0_.slug AS slug_5, c0_.description AS description_6, c0_.titolo AS titolo_7, c0_.curatela AS curatela_8, c0_.luogo AS luogo_9, c0_.pathurl AS pathurl_10, c0_.dettagliosino AS dettagliosino_11, c0_.title AS title_12, c0_.metadescription AS metadescription_13, c0_.url AS url_14, c0_.testolungo AS testolungo_15, c0_.enabled AS enabled_16, c0_.position AS position_17, c0_.media_id AS media_id_18, c0_.media2_id AS media2_id_19, c0_.media3_id AS media3_id_20, c0_.recensioni_id AS recensioni_id_21, c0_.catalogo_id AS catalogo_id_22, c0_.tutteimmagini_id AS tutteimmagini_id_23, c0_.media23_id AS media23_id_24, c0_.seo_id AS seo_id_25, c0_.pdfcatalogo_id AS pdfcatalogo_id_26, c0_.opere_id AS opere_id_27, c0_.root_id AS root_id_28, c0_.parent_id AS parent_id_29 FROM classification__category c0_ WHERE c0_.parent_id IS NULL;

#	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 36)
7	App\Repository\CategoriaRepository->findInitialCat (line 38)
8	App\Controller\CategoryController->categoriesAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 282)
16	__TwigTemplate_5ad3ad93725a309d0150ef2d0c7cdc48->block_body (line 437)
17	Twig\Template->yieldBlock (line 69)
18	__TwigTemplate_5ad3ad93725a309d0150ef2d0c7cdc48->doDisplay (line 393)
19	Twig\Template->yield (line 54)
20	__TwigTemplate_4418dc9acf95f6af55372ed26f39abb7->doDisplay (line 393)
21	Twig\Template->yield (line 349)
22	Twig\Template->display (line 364)
23	Twig\Template->render (line 35)
24	Twig\TemplateWrapper->render (line 306)
25	Twig\Environment->render (line 243)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 56)
28	App\Controller\IndexController->index (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	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
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\Cat	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.
App\Entity\MediaGallery	No errors.

Symfony Profiler

GET https://simoneracheli.it/catsmenu

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping