Symfony Profiler

Query Metrics

26 Database Queries

6 Different statements

6.61 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.67 ms
(55.49%)

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:

[
  4113
]

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

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

1.56 ms
(23.53%)

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
(9.12%)

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
(4.75%)

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)

0.24 ms
(3.57%)

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 = ? ORDER BY t0.position ASC

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 = ?
ORDER BY
  t0.position ASC

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 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 921)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCriteria (line 680)
3	Doctrine\ORM\PersistentCollection->matching (line 57)
4	App\Controller\CategoryController->sliderAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 103)
12	__TwigTemplate_4418dc9acf95f6af55372ed26f39abb7->block_contenuto (line 437)
13	Twig\Template->yieldBlock (line 72)
14	__TwigTemplate_5ad3ad93725a309d0150ef2d0c7cdc48->doDisplay (line 393)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_4418dc9acf95f6af55372ed26f39abb7->doDisplay (line 393)
17	Twig\Template->yield (line 349)
18	Twig\Template->display (line 364)
19	Twig\Template->render (line 35)
20	Twig\TemplateWrapper->render (line 306)
21	Twig\Environment->render (line 243)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 56)
24	App\Controller\IndexController->index (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.24 ms
(3.55%)

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_.category_id = ?

Parameters:

[
  3
]

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_.category_id = ?

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_.category_id = 3;

#	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 29)
7	App\Repository\MediaGalleryRepository->findGallbyCat (line 51)
8	App\Controller\CategoryController->sliderAction (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 103)
16	__TwigTemplate_4418dc9acf95f6af55372ed26f39abb7->block_contenuto (line 437)
17	Twig\Template->yieldBlock (line 72)
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.
App\Entity\CategoryImages	No errors.
App\Entity\Galleryhasmedia	No errors.

Symfony Profiler

GET https://simoneracheli.it/artworksmenu

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping