Symfony Profiler

Query Metrics

21 Database Queries

3 Different statements

19.42 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.51 ms
(38.66%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.link AS link_4, t0.date AS date_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.publishing_status AS publishing_status_8, t0.document_name AS document_name_9, t0.document_original_name AS document_original_name_10, t0.document_url AS document_url_11 FROM event t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = ? ORDER BY t0.date DESC LIMIT 999

Parameters:

[
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.link AS link_4,
  t0.date AS date_5,
  t0.created_at AS created_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.publishing_status AS publishing_status_8,
  t0.document_name AS document_name_9,
  t0.document_original_name AS document_original_name_10,
  t0.document_url AS document_url_11
FROM
  event t0
WHERE
  t0.deleted_at IS NULL
  AND t0.publishing_status = ?
ORDER BY
  t0.date DESC
LIMIT
  999

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.link AS link_4, t0.date AS date_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.publishing_status AS publishing_status_8, t0.document_name AS document_name_9, t0.document_original_name AS document_original_name_10, t0.document_url AS document_url_11 FROM event t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = 'published' ORDER BY t0.date DESC LIMIT 999;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 77)
4	App\Infrastructure\Repository\DatabaseEventRepository->findPublished (line 28)
5	App\Infrastructure\Controller\FrontendEventController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

6.15 ms
(31.69%)

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?

Parameters:

[
  "6afa21f7-3964-41de-9f59-22ecc7ccc9e3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.image AS image_3,
  t0.event_id AS event_id_4
FROM
  event_image t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = '6afa21f7-3964-41de-9f59-22ecc7ccc9e3';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3298)
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 1175)
9	Twig\Extension\CoreExtension::lengthFilter (line 322)
10	__TwigTemplate_f7e8059406753dd223de6d1068ea299b->block_page_content (line 430)
11	Twig\Template->yieldBlock (line 83)
12	__TwigTemplate_c5bdf34573864c433e31b51506961578->doDisplay (line 360)
13	Twig\Template->yield (line 49)
14	__TwigTemplate_f7e8059406753dd223de6d1068ea299b->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 299)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 33)
22	App\Infrastructure\Controller\FrontendEventController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

5.76 ms
(29.65%)

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = ?

Parameters:

[
  "6afa21f7-3964-41de-9f59-22ecc7ccc9e3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.embed AS embed_3,
  t0.event_id AS event_id_4
FROM
  event_video t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = '6afa21f7-3964-41de-9f59-22ecc7ccc9e3';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3298)
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 1175)
9	Twig\Extension\CoreExtension::lengthFilter (line 358)
10	__TwigTemplate_f7e8059406753dd223de6d1068ea299b->block_page_content (line 430)
11	Twig\Template->yieldBlock (line 83)
12	__TwigTemplate_c5bdf34573864c433e31b51506961578->doDisplay (line 360)
13	Twig\Template->yield (line 49)
14	__TwigTemplate_f7e8059406753dd223de6d1068ea299b->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 299)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 33)
22	App\Infrastructure\Controller\FrontendEventController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	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\Domain\User\Entity\User	No errors.
App\Domain\English\Entity\English	No errors.
App\Domain\Basic\Entity\Document	No errors.
App\Domain\LegalSummary\Entity\LegalSummary	No errors.
App\Domain\Podcast\Entity\Podcast	No errors.
App\Domain\Release\Entity\Release	No errors.
App\Domain\Event\Entity\Event	No errors.
App\Domain\Event\Entity\EventImage	No errors.
App\Domain\Event\Entity\EventVideo	No errors.
App\Domain\Release\Entity\ReleaseImage	No errors.
App\Domain\Release\Entity\ReleaseVideo	No errors.
App\Domain\Release\Entity\ReleaseLink	No errors.

Symfony Profiler

GET https://cortecostituzionale.strategiedigitali.net/eventi/1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping