Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

3.95 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.28 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.image_file AS image_file_4, t0.is_public AS is_public_5, t0.ordering AS ordering_6, t0.speech_date AS speech_date_7, t0.in_homepage AS in_homepage_8, t0.location AS location_9, t0.judge_code AS judge_code_10, t0.created_at AS created_at_11, t0.deleted_at AS deleted_at_12, t0.publishing_status AS publishing_status_13 FROM speeches t0 WHERE t0.deleted_at IS NULL AND t0.judge_code = ? ORDER BY t0.speech_date DESC

Parameters:

[
  "138"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.subtitle AS subtitle_3,
  t0.image_file AS image_file_4,
  t0.is_public AS is_public_5,
  t0.ordering AS ordering_6,
  t0.speech_date AS speech_date_7,
  t0.in_homepage AS in_homepage_8,
  t0.location AS location_9,
  t0.judge_code AS judge_code_10,
  t0.created_at AS created_at_11,
  t0.deleted_at AS deleted_at_12,
  t0.publishing_status AS publishing_status_13
FROM
  speeches t0
WHERE
  t0.deleted_at IS NULL
  AND t0.judge_code = ?
ORDER BY
  t0.speech_date DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.image_file AS image_file_4, t0.is_public AS is_public_5, t0.ordering AS ordering_6, t0.speech_date AS speech_date_7, t0.in_homepage AS in_homepage_8, t0.location AS location_9, t0.judge_code AS judge_code_10, t0.created_at AS created_at_11, t0.deleted_at AS deleted_at_12, t0.publishing_status AS publishing_status_13 FROM speeches t0 WHERE t0.deleted_at IS NULL AND t0.judge_code = '138' ORDER BY t0.speech_date DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 84)
4	App\Infrastructure\Repository\DatabaseSpeechRepository->findByJudgeCode (line 130)
5	App\Infrastructure\Controller\FrontendJudgeController->speech (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)

1.30 ms

SELECT t0.id AS id_1, t0.permalink AS permalink_2, t0.name AS name_3, t0.surname AS surname_4, t0.appointed_date AS appointed_date_5, t0.swearing_date AS swearing_date_6, t0.qualification AS qualification_7, t0.elected_by AS elected_by_8, t0.status AS status_9, t0.office AS office_10, t0.swearing_in_order AS swearing_in_order_11, t0.biography AS biography_12, t0.extended_biography AS extended_biography_13, t0.english_biography AS english_biography_14, t0.extended_english_biography AS extended_english_biography_15, t0.small_picture AS small_picture_16, t0.extended_picture AS extended_picture_17, t0.created_at AS created_at_18, t0.deleted_at AS deleted_at_19, t0.publishing_status AS publishing_status_20, t0.sigico_id AS sigico_id_21 FROM judge t0 WHERE t0.sigico_id = ? LIMIT 1

Parameters:

[
  "138"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.permalink AS permalink_2,
  t0.name AS name_3,
  t0.surname AS surname_4,
  t0.appointed_date AS appointed_date_5,
  t0.swearing_date AS swearing_date_6,
  t0.qualification AS qualification_7,
  t0.elected_by AS elected_by_8,
  t0.status AS status_9,
  t0.office AS office_10,
  t0.swearing_in_order AS swearing_in_order_11,
  t0.biography AS biography_12,
  t0.extended_biography AS extended_biography_13,
  t0.english_biography AS english_biography_14,
  t0.extended_english_biography AS extended_english_biography_15,
  t0.small_picture AS small_picture_16,
  t0.extended_picture AS extended_picture_17,
  t0.created_at AS created_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.publishing_status AS publishing_status_20,
  t0.sigico_id AS sigico_id_21
FROM
  judge t0
WHERE
  t0.sigico_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.permalink AS permalink_2, t0.name AS name_3, t0.surname AS surname_4, t0.appointed_date AS appointed_date_5, t0.swearing_date AS swearing_date_6, t0.qualification AS qualification_7, t0.elected_by AS elected_by_8, t0.status AS status_9, t0.office AS office_10, t0.swearing_in_order AS swearing_in_order_11, t0.biography AS biography_12, t0.extended_biography AS extended_biography_13, t0.english_biography AS english_biography_14, t0.extended_english_biography AS extended_english_biography_15, t0.small_picture AS small_picture_16, t0.extended_picture AS extended_picture_17, t0.created_at AS created_at_18, t0.deleted_at AS deleted_at_19, t0.publishing_status AS publishing_status_20, t0.sigico_id AS sigico_id_21 FROM judge t0 WHERE t0.sigico_id = '138' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 78)
4	App\Infrastructure\Repository\DatabaseJudgeRepository->findBySigicoId (line 131)
5	App\Infrastructure\Controller\FrontendJudgeController->speech (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)

0.82 ms

SELECT t0.id AS id_1, t0.description AS description_2, t0.type AS type_3, t0.is_public AS is_public_4, t0.ordering AS ordering_5, t0.document_name AS document_name_6, t0.document_original_name AS document_original_name_7, t0.document_url AS document_url_8, t0.speech_id AS speech_id_9 FROM speech_documents t0 WHERE t0.speech_id = ?

Parameters:

[
  "ccd156b9-b78c-4c7a-84fb-fa964b59ab5a"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.type AS type_3,
  t0.is_public AS is_public_4,
  t0.ordering AS ordering_5,
  t0.document_name AS document_name_6,
  t0.document_original_name AS document_original_name_7,
  t0.document_url AS document_url_8,
  t0.speech_id AS speech_id_9
FROM
  speech_documents t0
WHERE
  t0.speech_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.type AS type_3, t0.is_public AS is_public_4, t0.ordering AS ordering_5, t0.document_name AS document_name_6, t0.document_original_name AS document_original_name_7, t0.document_url AS document_url_8, t0.speech_id AS speech_id_9 FROM speech_documents t0 WHERE t0.speech_id = 'ccd156b9-b78c-4c7a-84fb-fa964b59ab5a';

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 175)
8	__TwigTemplate_8b3d782ce78c1642b29ddda5bb08ce24->block_page_content (line 430)
9	Twig\Template->yieldBlock (line 83)
10	__TwigTemplate_c5bdf34573864c433e31b51506961578->doDisplay (line 360)
11	Twig\Template->yield (line 52)
12	__TwigTemplate_8b3d782ce78c1642b29ddda5bb08ce24->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 299)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 133)
20	App\Infrastructure\Controller\FrontendJudgeController->speech (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.55 ms

SELECT t0.id AS id_1, t0.description AS description_2, t0.type AS type_3, t0.is_public AS is_public_4, t0.ordering AS ordering_5, t0.document_name AS document_name_6, t0.document_original_name AS document_original_name_7, t0.document_url AS document_url_8, t0.speech_id AS speech_id_9 FROM speech_documents t0 WHERE t0.speech_id = ?

Parameters:

[
  "b79d05d2-0bf1-413b-90f9-9efeabeeaa7f"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.type AS type_3,
  t0.is_public AS is_public_4,
  t0.ordering AS ordering_5,
  t0.document_name AS document_name_6,
  t0.document_original_name AS document_original_name_7,
  t0.document_url AS document_url_8,
  t0.speech_id AS speech_id_9
FROM
  speech_documents t0
WHERE
  t0.speech_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.type AS type_3, t0.is_public AS is_public_4, t0.ordering AS ordering_5, t0.document_name AS document_name_6, t0.document_original_name AS document_original_name_7, t0.document_url AS document_url_8, t0.speech_id AS speech_id_9 FROM speech_documents t0 WHERE t0.speech_id = 'b79d05d2-0bf1-413b-90f9-9efeabeeaa7f';

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 175)
8	__TwigTemplate_8b3d782ce78c1642b29ddda5bb08ce24->block_page_content (line 430)
9	Twig\Template->yieldBlock (line 83)
10	__TwigTemplate_c5bdf34573864c433e31b51506961578->doDisplay (line 360)
11	Twig\Template->yield (line 52)
12	__TwigTemplate_8b3d782ce78c1642b29ddda5bb08ce24->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 299)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 133)
20	App\Infrastructure\Controller\FrontendJudgeController->speech (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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\Speech\Entity\Speech	No errors.
App\Domain\Judge\Entity\Judge	No errors.
App\Domain\Speech\Entity\SpeechDocument	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/interventi-giudici/138

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping