Symfony Profiler

Query Metrics

426 Database Queries

24 Different statements

933.26 ms Query time

6 Invalid entities

689 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

360.11 ms
(38.59%)

SELECT DISTINCT i0_.name AS name_0, i0_.tax_code AS tax_code_1, i0_.fiscal_code AS fiscal_code_2, i0_.pec_address AS pec_address_3, i0_.email_address AS email_address_4, i0_.telephone AS telephone_5, i0_.telephone_mobile AS telephone_mobile_6, i0_.operating AS operating_7, i0_.status AS status_8, i0_.id AS id_9, i0_.active AS active_10, i0_.created_at AS created_at_11, i0_.updated_at AS updated_at_12, i0_.deleted_at AS deleted_at_13, i0_.legal_form_id AS legal_form_id_14, i0_.institution_size_id AS institution_size_id_15, i0_.ateco_code_version_id AS ateco_code_version_id_16, i0_.legal_owner_id AS legal_owner_id_17 FROM institutions i0_ INNER JOIN accreditation_application a1_ ON i0_.id = a1_.institution_id LEFT JOIN legal_owner l2_ ON i0_.legal_owner_id = l2_.id LEFT JOIN persons p3_ ON l2_.person_id = p3_.id LEFT JOIN institution_office i4_ ON i0_.id = i4_.institution_id LEFT JOIN cities c5_ ON i4_.province = c5_.id LEFT JOIN institution_office_status i6_ ON i4_.id = i6_.institution_office_id LEFT JOIN accreditation_office a7_ ON a1_.id = a7_.accreditation_application_id LEFT JOIN institutions_accreditation_tipologies i8_ ON a1_.id = i8_.accreditation_application_id LEFT JOIN accreditation_tipologies a9_ ON i8_.tipology_id = a9_.id LEFT JOIN institution_accreditation_macrotypes i10_ ON a1_.id = i10_.accreditation_application_id LEFT JOIN macrotypologies m11_ ON i10_.macrotypologies_id = m11_.id LEFT JOIN institutions_seps i12_ ON a1_.id = i12_.accreditation_application_id LEFT JOIN seps s13_ ON i12_.sep_id = s13_.id LEFT JOIN institutions_accreditation_type i14_ ON a1_.institution_typology_id = i14_.id LEFT JOIN institution_type i15_ ON i14_.institution_type_id = i15_.id LEFT JOIN institution_macro_type i16_ ON i15_.institution_macro_type_id = i16_.id LEFT JOIN institution_special_users i17_ ON a1_.id = i17_.accreditation_application_id LEFT JOIN special_users s18_ ON i17_.special_users_id = s18_.id LEFT JOIN job_service j19_ ON a1_.id = j19_.accreditation_application_id LEFT JOIN job_service_specialist j20_ ON a1_.id = j20_.accreditation_application_id WHERE i0_.operating = ? AND a1_.status IN (?) AND i0_.status IN (?, ?, ?) ORDER BY i0_.name ASC LIMIT 25

Parameters:

[
  1
  "DETERMINA_COMPLETATA"
  "ACCREDITATO"
  "SOSPESO"
  "REVOCATO"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT i0_.name AS name_0,
  i0_.tax_code AS tax_code_1,
  i0_.fiscal_code AS fiscal_code_2,
  i0_.pec_address AS pec_address_3,
  i0_.email_address AS email_address_4,
  i0_.telephone AS telephone_5,
  i0_.telephone_mobile AS telephone_mobile_6,
  i0_.operating AS operating_7,
  i0_.status AS status_8,
  i0_.id AS id_9,
  i0_.active AS active_10,
  i0_.created_at AS created_at_11,
  i0_.updated_at AS updated_at_12,
  i0_.deleted_at AS deleted_at_13,
  i0_.legal_form_id AS legal_form_id_14,
  i0_.institution_size_id AS institution_size_id_15,
  i0_.ateco_code_version_id AS ateco_code_version_id_16,
  i0_.legal_owner_id AS legal_owner_id_17
FROM
  institutions i0_
  INNER JOIN accreditation_application a1_ ON i0_.id = a1_.institution_id
  LEFT JOIN legal_owner l2_ ON i0_.legal_owner_id = l2_.id
  LEFT JOIN persons p3_ ON l2_.person_id = p3_.id
  LEFT JOIN institution_office i4_ ON i0_.id = i4_.institution_id
  LEFT JOIN cities c5_ ON i4_.province = c5_.id
  LEFT JOIN institution_office_status i6_ ON i4_.id = i6_.institution_office_id
  LEFT JOIN accreditation_office a7_ ON a1_.id = a7_.accreditation_application_id
  LEFT JOIN institutions_accreditation_tipologies i8_ ON a1_.id = i8_.accreditation_application_id
  LEFT JOIN accreditation_tipologies a9_ ON i8_.tipology_id = a9_.id
  LEFT JOIN institution_accreditation_macrotypes i10_ ON a1_.id = i10_.accreditation_application_id
  LEFT JOIN macrotypologies m11_ ON i10_.macrotypologies_id = m11_.id
  LEFT JOIN institutions_seps i12_ ON a1_.id = i12_.accreditation_application_id
  LEFT JOIN seps s13_ ON i12_.sep_id = s13_.id
  LEFT JOIN institutions_accreditation_type i14_ ON a1_.institution_typology_id = i14_.id
  LEFT JOIN institution_type i15_ ON i14_.institution_type_id = i15_.id
  LEFT JOIN institution_macro_type i16_ ON i15_.institution_macro_type_id = i16_.id
  LEFT JOIN institution_special_users i17_ ON a1_.id = i17_.accreditation_application_id
  LEFT JOIN special_users s18_ ON i17_.special_users_id = s18_.id
  LEFT JOIN job_service j19_ ON a1_.id = j19_.accreditation_application_id
  LEFT JOIN job_service_specialist j20_ ON a1_.id = j20_.accreditation_application_id
WHERE
  i0_.operating = ?
  AND a1_.status IN (?)
  AND i0_.status IN (?, ?, ?)
ORDER BY
  i0_.name ASC
LIMIT
  25

SELECT DISTINCT i0_.name AS name_0, i0_.tax_code AS tax_code_1, i0_.fiscal_code AS fiscal_code_2, i0_.pec_address AS pec_address_3, i0_.email_address AS email_address_4, i0_.telephone AS telephone_5, i0_.telephone_mobile AS telephone_mobile_6, i0_.operating AS operating_7, i0_.status AS status_8, i0_.id AS id_9, i0_.active AS active_10, i0_.created_at AS created_at_11, i0_.updated_at AS updated_at_12, i0_.deleted_at AS deleted_at_13, i0_.legal_form_id AS legal_form_id_14, i0_.institution_size_id AS institution_size_id_15, i0_.ateco_code_version_id AS ateco_code_version_id_16, i0_.legal_owner_id AS legal_owner_id_17 FROM institutions i0_ INNER JOIN accreditation_application a1_ ON i0_.id = a1_.institution_id LEFT JOIN legal_owner l2_ ON i0_.legal_owner_id = l2_.id LEFT JOIN persons p3_ ON l2_.person_id = p3_.id LEFT JOIN institution_office i4_ ON i0_.id = i4_.institution_id LEFT JOIN cities c5_ ON i4_.province = c5_.id LEFT JOIN institution_office_status i6_ ON i4_.id = i6_.institution_office_id LEFT JOIN accreditation_office a7_ ON a1_.id = a7_.accreditation_application_id LEFT JOIN institutions_accreditation_tipologies i8_ ON a1_.id = i8_.accreditation_application_id LEFT JOIN accreditation_tipologies a9_ ON i8_.tipology_id = a9_.id LEFT JOIN institution_accreditation_macrotypes i10_ ON a1_.id = i10_.accreditation_application_id LEFT JOIN macrotypologies m11_ ON i10_.macrotypologies_id = m11_.id LEFT JOIN institutions_seps i12_ ON a1_.id = i12_.accreditation_application_id LEFT JOIN seps s13_ ON i12_.sep_id = s13_.id LEFT JOIN institutions_accreditation_type i14_ ON a1_.institution_typology_id = i14_.id LEFT JOIN institution_type i15_ ON i14_.institution_type_id = i15_.id LEFT JOIN institution_macro_type i16_ ON i15_.institution_macro_type_id = i16_.id LEFT JOIN institution_special_users i17_ ON a1_.id = i17_.accreditation_application_id LEFT JOIN special_users s18_ ON i17_.special_users_id = s18_.id LEFT JOIN job_service j19_ ON a1_.id = j19_.accreditation_application_id LEFT JOIN job_service_specialist j20_ ON a1_.id = j20_.accreditation_application_id WHERE i0_.operating = 1 AND a1_.status IN ('DETERMINA_COMPLETATA') AND i0_.status IN ('ACCREDITATO', 'SOSPESO', 'REVOCATO') ORDER BY i0_.name ASC LIMIT 25;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Service\AccreditedInstitutionSearchService->search (line 194)
9	App\Twig\Components\AccreditedInstitutionSearch->getResults (line 108)
10	App\Twig\Components\AccreditedInstitutionSearch->buildMap (line 316)
11	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
12	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
13	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
14	iterator_to_array (line 50)
15	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
16	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
17	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
18	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
19	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
20	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
21	Twig\Template->yieldBlock (line 458)
22	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
23	Twig\Template->yield (line 411)
24	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
25	Twig\Template->yield (line 411)
26	Twig\Template->display (line 366)
27	Twig\Template->render (line 381)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
33	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 193)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
38	require_once (line 32)
39	require_once (line 5)

58.00 ms
(6.21%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.sub_type AS sub_type_3, t0.context AS context_4, t0.status AS status_5, t0.tender_code AS tender_code_6, t0.temporary_validity_start_date AS temporary_validity_start_date_7, t0.temporary_validity_end_date AS temporary_validity_end_date_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.institution_office_id AS institution_office_id_11 FROM institution_office_status t0 WHERE t0.institution_office_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.sub_type AS sub_type_3,
  t0.context AS context_4,
  t0.status AS status_5,
  t0.tender_code AS tender_code_6,
  t0.temporary_validity_start_date AS temporary_validity_start_date_7,
  t0.temporary_validity_end_date AS temporary_validity_end_date_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.institution_office_id AS institution_office_id_11
FROM
  institution_office_status t0
WHERE
  t0.institution_office_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.sub_type AS sub_type_3, t0.context AS context_4, t0.status AS status_5, t0.tender_code AS tender_code_6, t0.temporary_validity_start_date AS temporary_validity_start_date_7, t0.temporary_validity_end_date AS temporary_validity_end_date_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.institution_office_id AS institution_office_id_11 FROM institution_office_status t0 WHERE t0.institution_office_id = 10;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->summarizeOfficeStatuses (line 743)
10	App\Service\AccreditedInstitutionSearchService->summarizeOffices (line 670)
11	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 226)
12	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
13	array_map (line 310)
14	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
15	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
16	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
17	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
18	iterator_to_array (line 50)
19	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
20	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
21	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
22	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
23	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
24	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
25	Twig\Template->yieldBlock (line 458)
26	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
27	Twig\Template->yield (line 411)
28	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
29	Twig\Template->yield (line 411)
30	Twig\Template->display (line 366)
31	Twig\Template->render (line 381)
32	Twig\TemplateWrapper->render (line 51)
33	Twig\Environment->render (line 333)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
37	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 193)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
42	require_once (line 32)
43	require_once (line 5)

43.14 ms
(4.62%)

SELECT c0_.name AS name_0, c0_.capital AS capital_1, c0_.inactive AS inactive_2, c0_.istat_code AS istat_code_3, c0_.cadastre_code AS cadastre_code_4, c0_.region_code AS region_code_5, c0_.province_code AS province_code_6, c0_.region_name AS region_name_7, c0_.province_name AS province_name_8, c0_.biletteral_code AS biletteral_code_9, c0_.telephone_prefix AS telephone_prefix_10, c0_.id AS id_11, c0_.active AS active_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.deleted_at AS deleted_at_15 FROM cities c0_ WHERE c0_.region_name = ? AND c0_.capital = ? AND c0_.inactive = ? ORDER BY c0_.province_name ASC

Parameters:

[
  "Lazio"
  1
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.name AS name_0,
  c0_.capital AS capital_1,
  c0_.inactive AS inactive_2,
  c0_.istat_code AS istat_code_3,
  c0_.cadastre_code AS cadastre_code_4,
  c0_.region_code AS region_code_5,
  c0_.province_code AS province_code_6,
  c0_.region_name AS region_name_7,
  c0_.province_name AS province_name_8,
  c0_.biletteral_code AS biletteral_code_9,
  c0_.telephone_prefix AS telephone_prefix_10,
  c0_.id AS id_11,
  c0_.active AS active_12,
  c0_.created_at AS created_at_13,
  c0_.updated_at AS updated_at_14,
  c0_.deleted_at AS deleted_at_15
FROM
  cities c0_
WHERE
  c0_.region_name = ?
  AND c0_.capital = ?
  AND c0_.inactive = ?
ORDER BY
  c0_.province_name ASC

SELECT c0_.name AS name_0, c0_.capital AS capital_1, c0_.inactive AS inactive_2, c0_.istat_code AS istat_code_3, c0_.cadastre_code AS cadastre_code_4, c0_.region_code AS region_code_5, c0_.province_code AS province_code_6, c0_.region_name AS region_name_7, c0_.province_name AS province_name_8, c0_.biletteral_code AS biletteral_code_9, c0_.telephone_prefix AS telephone_prefix_10, c0_.id AS id_11, c0_.active AS active_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.deleted_at AS deleted_at_15 FROM cities c0_ WHERE c0_.region_name = 'Lazio' AND c0_.capital = 1 AND c0_.inactive = 0 ORDER BY c0_.province_name ASC;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Service\AccreditedInstitutionSearchService->provinceOptions (line 480)
9	App\Twig\Components\AccreditedInstitutionSearch->getProvinceOptions (line 279)
10	Twig\Extension\CoreExtension->getAttribute (line 1928)
11	__TwigTemplate_6297cc1a38f037bd3bcee1e4408f8a74::doDisplay (line 526)
12	Twig\Template->yield (line 411)
13	Twig\Template->display (line 366)
14	Twig\Template->render (line 381)
15	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
18	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
19	Twig\Template->yieldBlock (line 458)
20	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
21	Twig\Template->yield (line 411)
22	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
23	Twig\Template->yield (line 411)
24	Twig\Template->display (line 366)
25	Twig\Template->render (line 381)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
31	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 193)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
36	require_once (line 32)
37	require_once (line 5)

39.41 ms
(4.22%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.status AS status_4, t0.note AS note_5, t0.note_next_investigator AS note_next_investigator_6, t0.deadline AS deadline_7, t0.completed_at AS completed_at_8, t0.integration_requested_at AS integration_requested_at_9, t0.integration_deadline_at AS integration_deadline_at_10, t0.integration_final_deadline_at AS integration_final_deadline_at_11, t0.deadline_notification_sent AS deadline_notification_sent_12, t0.already_been_requested_integration AS already_been_requested_integration_13, t0.started_at AS started_at_14, t0.assigned_to_id AS assigned_to_id_15, t0.accreditation_application_id AS accreditation_application_id_16, t17.numero_determina AS numero_determina_18, t17.codice_protocollo AS codice_protocollo_19, t17.id AS id_20, t17.active AS active_21, t17.created_at AS created_at_22, t17.updated_at AS updated_at_23, t17.deleted_at AS deleted_at_24, t17.accreditation_investigation_l3 AS accreditation_investigation_l3_25, t17.document_id AS document_id_26 FROM accreditation_investigation_l3 t0 LEFT JOIN investigation_determina t17 ON t17.accreditation_investigation_l3 = t0.id WHERE t0.accreditation_application_id = ?

Parameters:

[
  109
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.status AS status_4,
  t0.note AS note_5,
  t0.note_next_investigator AS note_next_investigator_6,
  t0.deadline AS deadline_7,
  t0.completed_at AS completed_at_8,
  t0.integration_requested_at AS integration_requested_at_9,
  t0.integration_deadline_at AS integration_deadline_at_10,
  t0.integration_final_deadline_at AS integration_final_deadline_at_11,
  t0.deadline_notification_sent AS deadline_notification_sent_12,
  t0.already_been_requested_integration AS already_been_requested_integration_13,
  t0.started_at AS started_at_14,
  t0.assigned_to_id AS assigned_to_id_15,
  t0.accreditation_application_id AS accreditation_application_id_16,
  t17.numero_determina AS numero_determina_18,
  t17.codice_protocollo AS codice_protocollo_19,
  t17.id AS id_20,
  t17.active AS active_21,
  t17.created_at AS created_at_22,
  t17.updated_at AS updated_at_23,
  t17.deleted_at AS deleted_at_24,
  t17.accreditation_investigation_l3 AS accreditation_investigation_l3_25,
  t17.document_id AS document_id_26
FROM
  accreditation_investigation_l3 t0
  LEFT JOIN investigation_determina t17 ON t17.accreditation_investigation_l3 = t0.id
WHERE
  t0.accreditation_application_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.status AS status_4, t0.note AS note_5, t0.note_next_investigator AS note_next_investigator_6, t0.deadline AS deadline_7, t0.completed_at AS completed_at_8, t0.integration_requested_at AS integration_requested_at_9, t0.integration_deadline_at AS integration_deadline_at_10, t0.integration_final_deadline_at AS integration_final_deadline_at_11, t0.deadline_notification_sent AS deadline_notification_sent_12, t0.already_been_requested_integration AS already_been_requested_integration_13, t0.started_at AS started_at_14, t0.assigned_to_id AS assigned_to_id_15, t0.accreditation_application_id AS accreditation_application_id_16, t17.numero_determina AS numero_determina_18, t17.codice_protocollo AS codice_protocollo_19, t17.id AS id_20, t17.active AS active_21, t17.created_at AS created_at_22, t17.updated_at AS updated_at_23, t17.deleted_at AS deleted_at_24, t17.accreditation_investigation_l3 AS accreditation_investigation_l3_25, t17.document_id AS document_id_26 FROM accreditation_investigation_l3 t0 LEFT JOIN investigation_determina t17 ON t17.accreditation_investigation_l3 = t0.id WHERE t0.accreditation_application_id = 109;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->summarizeAccreditationDeterminas (line 798)
10	App\Service\AccreditedInstitutionSearchService->summarizeApplication (line 568)
11	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 558)
12	array_map (line 557)
13	App\Service\AccreditedInstitutionSearchService::summarizeApplications (line 557)
14	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 223)
15	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
16	array_map (line 310)
17	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
18	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
19	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
20	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
21	iterator_to_array (line 50)
22	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
23	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
28	Twig\Template->yieldBlock (line 458)
29	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
32	Twig\Template->yield (line 411)
33	Twig\Template->display (line 366)
34	Twig\Template->render (line 381)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
45	require_once (line 32)
46	require_once (line 5)

38.72 ms
(4.15%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.area AS area_3, t0.type AS type_4, t0.sub_type AS sub_type_5, t0.status AS status_6, t0.submitted_at AS submitted_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_documentary_investigation AS is_documentary_investigation_10, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_11, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_12, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_13, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_14, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_15, t0.send_at AS send_at_16, t0.institution_id AS institution_id_17, t18.numero_determina AS numero_determina_19, t18.codice_protocollo AS codice_protocollo_20, t18.data_determina AS data_determina_21, t18.id AS id_22, t18.active AS active_23, t18.created_at AS created_at_24, t18.updated_at AS updated_at_25, t18.deleted_at AS deleted_at_26, t18.variation_investigation_l3_id AS variation_investigation_l3_id_27, t18.variation_request_id AS variation_request_id_28, t18.document_id AS document_id_29 FROM variation_request t0 LEFT JOIN variation_investigation_determina t18 ON t18.variation_request_id = t0.id WHERE t0.institution_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.area AS area_3,
  t0.type AS type_4,
  t0.sub_type AS sub_type_5,
  t0.status AS status_6,
  t0.submitted_at AS submitted_at_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.is_documentary_investigation AS is_documentary_investigation_10,
  t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_11,
  t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_12,
  t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_13,
  t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_14,
  t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_15,
  t0.send_at AS send_at_16,
  t0.institution_id AS institution_id_17,
  t18.numero_determina AS numero_determina_19,
  t18.codice_protocollo AS codice_protocollo_20,
  t18.data_determina AS data_determina_21,
  t18.id AS id_22,
  t18.active AS active_23,
  t18.created_at AS created_at_24,
  t18.updated_at AS updated_at_25,
  t18.deleted_at AS deleted_at_26,
  t18.variation_investigation_l3_id AS variation_investigation_l3_id_27,
  t18.variation_request_id AS variation_request_id_28,
  t18.document_id AS document_id_29
FROM
  variation_request t0
  LEFT JOIN variation_investigation_determina t18 ON t18.variation_request_id = t0.id
WHERE
  t0.institution_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.area AS area_3, t0.type AS type_4, t0.sub_type AS sub_type_5, t0.status AS status_6, t0.submitted_at AS submitted_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_documentary_investigation AS is_documentary_investigation_10, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_11, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_12, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_13, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_14, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_15, t0.send_at AS send_at_16, t0.institution_id AS institution_id_17, t18.numero_determina AS numero_determina_19, t18.codice_protocollo AS codice_protocollo_20, t18.data_determina AS data_determina_21, t18.id AS id_22, t18.active AS active_23, t18.created_at AS created_at_24, t18.updated_at AS updated_at_25, t18.deleted_at AS deleted_at_26, t18.variation_investigation_l3_id AS variation_investigation_l3_id_27, t18.variation_request_id AS variation_request_id_28, t18.document_id AS document_id_29 FROM variation_request t0 LEFT JOIN variation_investigation_determina t18 ON t18.variation_request_id = t0.id WHERE t0.institution_id = 7;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->summarizeVariations (line 836)
10	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 224)
11	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
12	array_map (line 310)
13	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
14	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
15	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
16	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
17	iterator_to_array (line 50)
18	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
19	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
20	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
21	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
22	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
23	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
24	Twig\Template->yieldBlock (line 458)
25	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
28	Twig\Template->yield (line 411)
29	Twig\Template->display (line 366)
30	Twig\Template->render (line 381)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
36	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 193)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
41	require_once (line 32)
42	require_once (line 5)

36.55 ms
(3.92%)

SELECT t0.id AS id_1, t0.address AS address_2, t0.address_number AS address_number_3, t0.address_zip AS address_zip_4, t0.city AS city_5, t0.province AS province_6, t0.interior AS interior_7, t0.stair AS stair_8, t0.cadastral_sheet AS cadastral_sheet_9, t0.cadastral_parcel AS cadastral_parcel_10, t0.sub_unit AS sub_unit_11, t0.telephone AS telephone_12, t0.telephone_mobile AS telephone_mobile_13, t0.email AS email_14, t0.pec AS pec_15, t0.type AS type_16, t0.sub_type AS sub_type_17, t0.status AS status_18, t0.accreditation_application_id AS accreditation_application_id_19, t0.related_office_id AS related_office_id_20 FROM accreditation_office t0 WHERE t0.accreditation_application_id = ?

Parameters:

[
  109
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.address AS address_2,
  t0.address_number AS address_number_3,
  t0.address_zip AS address_zip_4,
  t0.city AS city_5,
  t0.province AS province_6,
  t0.interior AS interior_7,
  t0.stair AS stair_8,
  t0.cadastral_sheet AS cadastral_sheet_9,
  t0.cadastral_parcel AS cadastral_parcel_10,
  t0.sub_unit AS sub_unit_11,
  t0.telephone AS telephone_12,
  t0.telephone_mobile AS telephone_mobile_13,
  t0.email AS email_14,
  t0.pec AS pec_15,
  t0.type AS type_16,
  t0.sub_type AS sub_type_17,
  t0.status AS status_18,
  t0.accreditation_application_id AS accreditation_application_id_19,
  t0.related_office_id AS related_office_id_20
FROM
  accreditation_office t0
WHERE
  t0.accreditation_application_id = ?

SELECT t0.id AS id_1, t0.address AS address_2, t0.address_number AS address_number_3, t0.address_zip AS address_zip_4, t0.city AS city_5, t0.province AS province_6, t0.interior AS interior_7, t0.stair AS stair_8, t0.cadastral_sheet AS cadastral_sheet_9, t0.cadastral_parcel AS cadastral_parcel_10, t0.sub_unit AS sub_unit_11, t0.telephone AS telephone_12, t0.telephone_mobile AS telephone_mobile_13, t0.email AS email_14, t0.pec AS pec_15, t0.type AS type_16, t0.sub_type AS sub_type_17, t0.status AS status_18, t0.accreditation_application_id AS accreditation_application_id_19, t0.related_office_id AS related_office_id_20 FROM accreditation_office t0 WHERE t0.accreditation_application_id = 109;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->summarizeOffices (line 693)
10	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 226)
11	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
12	array_map (line 310)
13	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
14	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
15	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
16	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
17	iterator_to_array (line 50)
18	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
19	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
20	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
21	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
22	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
23	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
24	Twig\Template->yieldBlock (line 458)
25	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
28	Twig\Template->yield (line 411)
29	Twig\Template->display (line 366)
30	Twig\Template->render (line 381)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
36	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 193)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
41	require_once (line 32)
42	require_once (line 5)

34.59 ms
(3.71%)

SELECT t0.address AS address_1, t0.address_number AS address_number_2, t0.interior AS interior_3, t0.stair AS stair_4, t0.address_zip AS address_zip_5, t0.abroad AS abroad_6, t0.foreign_nation AS foreign_nation_7, t0.foreign_city AS foreign_city_8, t0.cadastral_sheet AS cadastral_sheet_9, t0.cadastral_parcel AS cadastral_parcel_10, t0.sub_unit AS sub_unit_11, t0.pec AS pec_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.telephone_mobile AS telephone_mobile_15, t0.id AS id_16, t0.active AS active_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t0.institution_id AS institution_id_21, t0.city AS city_22, t0.province AS province_23 FROM institution_office t0 WHERE t0.institution_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.address AS address_1,
  t0.address_number AS address_number_2,
  t0.interior AS interior_3,
  t0.stair AS stair_4,
  t0.address_zip AS address_zip_5,
  t0.abroad AS abroad_6,
  t0.foreign_nation AS foreign_nation_7,
  t0.foreign_city AS foreign_city_8,
  t0.cadastral_sheet AS cadastral_sheet_9,
  t0.cadastral_parcel AS cadastral_parcel_10,
  t0.sub_unit AS sub_unit_11,
  t0.pec AS pec_12,
  t0.email AS email_13,
  t0.telephone AS telephone_14,
  t0.telephone_mobile AS telephone_mobile_15,
  t0.id AS id_16,
  t0.active AS active_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.deleted_at AS deleted_at_20,
  t0.institution_id AS institution_id_21,
  t0.city AS city_22,
  t0.province AS province_23
FROM
  institution_office t0
WHERE
  t0.institution_id = ?

SELECT t0.address AS address_1, t0.address_number AS address_number_2, t0.interior AS interior_3, t0.stair AS stair_4, t0.address_zip AS address_zip_5, t0.abroad AS abroad_6, t0.foreign_nation AS foreign_nation_7, t0.foreign_city AS foreign_city_8, t0.cadastral_sheet AS cadastral_sheet_9, t0.cadastral_parcel AS cadastral_parcel_10, t0.sub_unit AS sub_unit_11, t0.pec AS pec_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.telephone_mobile AS telephone_mobile_15, t0.id AS id_16, t0.active AS active_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t0.institution_id AS institution_id_21, t0.city AS city_22, t0.province AS province_23 FROM institution_office t0 WHERE t0.institution_id = 7;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->summarizeOffices (line 669)
10	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 226)
11	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
12	array_map (line 310)
13	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
14	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
15	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
16	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
17	iterator_to_array (line 50)
18	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
19	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
20	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
21	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
22	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
23	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
24	Twig\Template->yieldBlock (line 458)
25	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
28	Twig\Template->yield (line 411)
29	Twig\Template->display (line 366)
30	Twig\Template->render (line 381)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
36	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 193)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
41	require_once (line 32)
42	require_once (line 5)

34.00 ms
(3.64%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.maintenance_type AS maintenance_type_3, t0.accreditation_context AS accreditation_context_4, t0.status AS status_5, t0.send_at AS send_at_6, t0.reviewed_at AS reviewed_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.is_admin_shadow AS is_admin_shadow_13, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_14, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_15, t0.determina_completed_at AS determina_completed_at_16, t0.integration_round AS integration_round_17, t0.institution_id AS institution_id_18, t0.accreditation_application_id AS accreditation_application_id_19, t0.office_id AS office_id_20 FROM maintenance_request t0 WHERE t0.institution_id = ? ORDER BY t0.send_at DESC

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.maintenance_type AS maintenance_type_3,
  t0.accreditation_context AS accreditation_context_4,
  t0.status AS status_5,
  t0.send_at AS send_at_6,
  t0.reviewed_at AS reviewed_at_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10,
  t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11,
  t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12,
  t0.is_admin_shadow AS is_admin_shadow_13,
  t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_14,
  t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_15,
  t0.determina_completed_at AS determina_completed_at_16,
  t0.integration_round AS integration_round_17,
  t0.institution_id AS institution_id_18,
  t0.accreditation_application_id AS accreditation_application_id_19,
  t0.office_id AS office_id_20
FROM
  maintenance_request t0
WHERE
  t0.institution_id = ?
ORDER BY
  t0.send_at DESC

SELECT t0.id AS id_1, t0.code AS code_2, t0.maintenance_type AS maintenance_type_3, t0.accreditation_context AS accreditation_context_4, t0.status AS status_5, t0.send_at AS send_at_6, t0.reviewed_at AS reviewed_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.is_admin_shadow AS is_admin_shadow_13, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_14, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_15, t0.determina_completed_at AS determina_completed_at_16, t0.integration_round AS integration_round_17, t0.institution_id AS institution_id_18, t0.accreditation_application_id AS accreditation_application_id_19, t0.office_id AS office_id_20 FROM maintenance_request t0 WHERE t0.institution_id = 7 ORDER BY t0.send_at DESC;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\EntityRepository->findBy (line 110)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
6	App\Service\AccreditedInstitutionSearchService->summarizeMaintenances (line 889)
7	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 225)
8	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
9	array_map (line 310)
10	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
11	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
12	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
13	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
14	iterator_to_array (line 50)
15	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
16	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
17	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
18	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
19	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
20	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
21	Twig\Template->yieldBlock (line 458)
22	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
23	Twig\Template->yield (line 411)
24	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
25	Twig\Template->yield (line 411)
26	Twig\Template->display (line 366)
27	Twig\Template->render (line 381)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
33	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 193)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
38	require_once (line 32)
39	require_once (line 5)

31.91 ms
(3.42%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.accreditation_application_id AS accreditation_application_id_3 FROM job_service t0 WHERE t0.accreditation_application_id = ?

Parameters:

[
  109
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.accreditation_application_id AS accreditation_application_id_3
FROM
  job_service t0
WHERE
  t0.accreditation_application_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.accreditation_application_id AS accreditation_application_id_3 FROM job_service t0 WHERE t0.accreditation_application_id = 109;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->jobServiceLabels (line 1158)
10	App\Service\AccreditedInstitutionSearchService->summarizeApplication (line 582)
11	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 558)
12	array_map (line 557)
13	App\Service\AccreditedInstitutionSearchService::summarizeApplications (line 557)
14	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 223)
15	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
16	array_map (line 310)
17	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
18	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
19	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
20	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
21	iterator_to_array (line 50)
22	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
23	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
28	Twig\Template->yieldBlock (line 458)
29	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
32	Twig\Template->yield (line 411)
33	Twig\Template->display (line 366)
34	Twig\Template->render (line 381)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
45	require_once (line 32)
46	require_once (line 5)

31.42 ms
(3.37%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.accreditation_application_id AS accreditation_application_id_3 FROM job_service_specialist t0 WHERE t0.accreditation_application_id = ?

Parameters:

[
  109
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.accreditation_application_id AS accreditation_application_id_3
FROM
  job_service_specialist t0
WHERE
  t0.accreditation_application_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.accreditation_application_id AS accreditation_application_id_3 FROM job_service_specialist t0 WHERE t0.accreditation_application_id = 109;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->jobServiceSpecialistLabels (line 1174)
10	App\Service\AccreditedInstitutionSearchService->summarizeApplication (line 583)
11	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 558)
12	array_map (line 557)
13	App\Service\AccreditedInstitutionSearchService::summarizeApplications (line 557)
14	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 223)
15	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
16	array_map (line 310)
17	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
18	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
19	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
20	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
21	iterator_to_array (line 50)
22	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
23	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
28	Twig\Template->yieldBlock (line 458)
29	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
32	Twig\Template->yield (line 411)
33	Twig\Template->display (line 366)
34	Twig\Template->render (line 381)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
45	require_once (line 32)
46	require_once (line 5)

30.93 ms
(3.31%)

SELECT t0.id AS id_1, t0.active AS active_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.accreditation_application_id AS accreditation_application_id_6, t0.special_users_id AS special_users_id_7 FROM institution_special_users t0 WHERE t0.accreditation_application_id = ?

Parameters:

[
  109
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.accreditation_application_id AS accreditation_application_id_6,
  t0.special_users_id AS special_users_id_7
FROM
  institution_special_users t0
WHERE
  t0.accreditation_application_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.accreditation_application_id AS accreditation_application_id_6, t0.special_users_id AS special_users_id_7 FROM institution_special_users t0 WHERE t0.accreditation_application_id = 109;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->specialUserLabels (line 1142)
10	App\Service\AccreditedInstitutionSearchService->summarizeApplication (line 581)
11	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 558)
12	array_map (line 557)
13	App\Service\AccreditedInstitutionSearchService::summarizeApplications (line 557)
14	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 223)
15	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
16	array_map (line 310)
17	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
18	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
19	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
20	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
21	iterator_to_array (line 50)
22	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
23	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
28	Twig\Template->yieldBlock (line 458)
29	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
32	Twig\Template->yield (line 411)
33	Twig\Template->display (line 366)
34	Twig\Template->render (line 381)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
45	require_once (line 32)
46	require_once (line 5)

30.42 ms
(3.26%)

SELECT t0.init_insert AS init_insert_1, t0.id AS id_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.accreditation_application_id AS accreditation_application_id_7, t0.sep_id AS sep_id_8 FROM institutions_seps t0 WHERE t0.accreditation_application_id = ?

Parameters:

[
  109
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.init_insert AS init_insert_1,
  t0.id AS id_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.accreditation_application_id AS accreditation_application_id_7,
  t0.sep_id AS sep_id_8
FROM
  institutions_seps t0
WHERE
  t0.accreditation_application_id = ?

SELECT t0.init_insert AS init_insert_1, t0.id AS id_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.accreditation_application_id AS accreditation_application_id_7, t0.sep_id AS sep_id_8 FROM institutions_seps t0 WHERE t0.accreditation_application_id = 109;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->sepLabels (line 1126)
10	App\Service\AccreditedInstitutionSearchService->summarizeApplication (line 580)
11	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 558)
12	array_map (line 557)
13	App\Service\AccreditedInstitutionSearchService::summarizeApplications (line 557)
14	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 223)
15	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
16	array_map (line 310)
17	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
18	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
19	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
20	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
21	iterator_to_array (line 50)
22	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
23	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
28	Twig\Template->yieldBlock (line 458)
29	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
32	Twig\Template->yield (line 411)
33	Twig\Template->display (line 366)
34	Twig\Template->render (line 381)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
45	require_once (line 32)
46	require_once (line 5)

30.15 ms
(3.23%)

SELECT t0.id AS id_1, t0.active AS active_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.accreditation_application_id AS accreditation_application_id_6, t0.macrotypologies_id AS macrotypologies_id_7 FROM institution_accreditation_macrotypes t0 WHERE t0.accreditation_application_id = ?

Parameters:

[
  109
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.accreditation_application_id AS accreditation_application_id_6,
  t0.macrotypologies_id AS macrotypologies_id_7
FROM
  institution_accreditation_macrotypes t0
WHERE
  t0.accreditation_application_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.accreditation_application_id AS accreditation_application_id_6, t0.macrotypologies_id AS macrotypologies_id_7 FROM institution_accreditation_macrotypes t0 WHERE t0.accreditation_application_id = 109;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->macrotypologyLabels (line 1110)
10	App\Service\AccreditedInstitutionSearchService->summarizeApplication (line 579)
11	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 558)
12	array_map (line 557)
13	App\Service\AccreditedInstitutionSearchService::summarizeApplications (line 557)
14	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 223)
15	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
16	array_map (line 310)
17	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
18	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
19	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
20	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
21	iterator_to_array (line 50)
22	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
23	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
28	Twig\Template->yieldBlock (line 458)
29	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
32	Twig\Template->yield (line 411)
33	Twig\Template->display (line 366)
34	Twig\Template->render (line 381)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
45	require_once (line 32)
46	require_once (line 5)

25.67 ms
(2.75%)

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.migrated AS migrated_15, t0.id AS id_16, t0.active AS active_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t21.id AS id_22, t21.active AS active_23, t21.created_at AS created_at_24, t21.updated_at AS updated_at_25, t21.deleted_at AS deleted_at_26, t21.accreditation_application_id AS accreditation_application_id_27, t21.tipology_id AS tipology_id_28, t0.institution_id AS institution_id_29, t0.legal_owner_id AS legal_owner_id_30, t0.institution_typology_id AS institution_typology_id_31, t0.parent_application_id AS parent_application_id_32 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t21 ON t21.accreditation_application_id = t0.id WHERE t0.parent_application_id = ?

Parameters:

[
  109
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.status AS status_1,
  t0.request_type AS request_type_2,
  t0.code AS code_3,
  t0.accreditation_type AS accreditation_type_4,
  t0.score AS score_5,
  t0.send_at AS send_at_6,
  t0.determina_completed_at AS determina_completed_at_7,
  t0.accreditation_end_date AS accreditation_end_date_8,
  t0.renewal_notification_level AS renewal_notification_level_9,
  t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10,
  t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11,
  t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12,
  t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13,
  t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14,
  t0.migrated AS migrated_15,
  t0.id AS id_16,
  t0.active AS active_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.deleted_at AS deleted_at_20,
  t21.id AS id_22,
  t21.active AS active_23,
  t21.created_at AS created_at_24,
  t21.updated_at AS updated_at_25,
  t21.deleted_at AS deleted_at_26,
  t21.accreditation_application_id AS accreditation_application_id_27,
  t21.tipology_id AS tipology_id_28,
  t0.institution_id AS institution_id_29,
  t0.legal_owner_id AS legal_owner_id_30,
  t0.institution_typology_id AS institution_typology_id_31,
  t0.parent_application_id AS parent_application_id_32
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t21 ON t21.accreditation_application_id = t0.id
WHERE
  t0.parent_application_id = ?

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.migrated AS migrated_15, t0.id AS id_16, t0.active AS active_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t21.id AS id_22, t21.active AS active_23, t21.created_at AS created_at_24, t21.updated_at AS updated_at_25, t21.deleted_at AS deleted_at_26, t21.accreditation_application_id AS accreditation_application_id_27, t21.tipology_id AS tipology_id_28, t0.institution_id AS institution_id_29, t0.legal_owner_id AS legal_owner_id_30, t0.institution_typology_id AS institution_typology_id_31, t0.parent_application_id AS parent_application_id_32 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t21 ON t21.accreditation_application_id = t0.id WHERE t0.parent_application_id = 109;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Entity\AccreditationApplication->isSupersededByRenewal (line 991)
10	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 615)
11	array_filter (line 604)
12	App\Service\AccreditedInstitutionSearchService::visibleApplications (line 604)
13	App\Service\AccreditedInstitutionSearchService->summarizeInstitution (line 511)
14	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 193)
15	array_map (line 192)
16	App\Service\AccreditedInstitutionSearchService::search (line 192)
17	App\Twig\Components\AccreditedInstitutionSearch->getResults (line 108)
18	App\Twig\Components\AccreditedInstitutionSearch->buildMap (line 316)
19	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
20	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
21	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
22	iterator_to_array (line 50)
23	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
24	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
25	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
26	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
27	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
28	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
29	Twig\Template->yieldBlock (line 458)
30	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
31	Twig\Template->yield (line 411)
32	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
33	Twig\Template->yield (line 411)
34	Twig\Template->display (line 366)
35	Twig\Template->render (line 381)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
41	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
44	Symfony\Component\HttpKernel\Kernel->handle (line 193)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
46	require_once (line 32)
47	require_once (line 5)

25.16 ms
(2.70%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.fiscal_code AS fiscal_code_4, t0.birth_date AS birth_date_5, t0.gender AS gender_6, t0.residence_address AS residence_address_7, t0.residence_address_number AS residence_address_number_8, t0.residence_address_zip AS residence_address_zip_9, t0.foreign_city AS foreign_city_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t14.identifier AS identifier_15, t14.provider AS provider_16, t14.username AS username_17, t14.email AS email_18, t14.pec AS pec_19, t14.cellular AS cellular_20, t14.fiscal_code AS fiscal_code_21, t14.password AS password_22, t14.last_access AS last_access_23, t14.is_user_suspended AS is_user_suspended_24, t14.id AS id_25, t14.active AS active_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.deleted_at AS deleted_at_29, t14.person_id AS person_id_30, t14.last_operating_institution_id AS last_operating_institution_id_31, t0.birth_nation_id AS birth_nation_id_32, t0.birth_city_id AS birth_city_id_33, t0.residence_city_id AS residence_city_id_34, t0.residence_province_id AS residence_province_id_35, t0.residence_nation_id AS residence_nation_id_36, t37.signature_certificate_expires_on AS signature_certificate_expires_on_38, t37.signature_kit_notification_level AS signature_kit_notification_level_39, t37.id AS id_40, t37.active AS active_41, t37.created_at AS created_at_42, t37.updated_at AS updated_at_43, t37.deleted_at AS deleted_at_44, t37.person_id AS person_id_45, t37.signature_certifier_id AS signature_certifier_id_46 FROM persons t0 LEFT JOIN user t14 ON t14.person_id = t0.id LEFT JOIN legal_owner t37 ON t37.person_id = t0.id WHERE t0.id = ?

Parameters:

[
  453
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.fiscal_code AS fiscal_code_4,
  t0.birth_date AS birth_date_5,
  t0.gender AS gender_6,
  t0.residence_address AS residence_address_7,
  t0.residence_address_number AS residence_address_number_8,
  t0.residence_address_zip AS residence_address_zip_9,
  t0.foreign_city AS foreign_city_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t14.identifier AS identifier_15,
  t14.provider AS provider_16,
  t14.username AS username_17,
  t14.email AS email_18,
  t14.pec AS pec_19,
  t14.cellular AS cellular_20,
  t14.fiscal_code AS fiscal_code_21,
  t14.password AS password_22,
  t14.last_access AS last_access_23,
  t14.is_user_suspended AS is_user_suspended_24,
  t14.id AS id_25,
  t14.active AS active_26,
  t14.created_at AS created_at_27,
  t14.updated_at AS updated_at_28,
  t14.deleted_at AS deleted_at_29,
  t14.person_id AS person_id_30,
  t14.last_operating_institution_id AS last_operating_institution_id_31,
  t0.birth_nation_id AS birth_nation_id_32,
  t0.birth_city_id AS birth_city_id_33,
  t0.residence_city_id AS residence_city_id_34,
  t0.residence_province_id AS residence_province_id_35,
  t0.residence_nation_id AS residence_nation_id_36,
  t37.signature_certificate_expires_on AS signature_certificate_expires_on_38,
  t37.signature_kit_notification_level AS signature_kit_notification_level_39,
  t37.id AS id_40,
  t37.active AS active_41,
  t37.created_at AS created_at_42,
  t37.updated_at AS updated_at_43,
  t37.deleted_at AS deleted_at_44,
  t37.person_id AS person_id_45,
  t37.signature_certifier_id AS signature_certifier_id_46
FROM
  persons t0
  LEFT JOIN user t14 ON t14.person_id = t0.id
  LEFT JOIN legal_owner t37 ON t37.person_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.fiscal_code AS fiscal_code_4, t0.birth_date AS birth_date_5, t0.gender AS gender_6, t0.residence_address AS residence_address_7, t0.residence_address_number AS residence_address_number_8, t0.residence_address_zip AS residence_address_zip_9, t0.foreign_city AS foreign_city_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t14.identifier AS identifier_15, t14.provider AS provider_16, t14.username AS username_17, t14.email AS email_18, t14.pec AS pec_19, t14.cellular AS cellular_20, t14.fiscal_code AS fiscal_code_21, t14.password AS password_22, t14.last_access AS last_access_23, t14.is_user_suspended AS is_user_suspended_24, t14.id AS id_25, t14.active AS active_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.deleted_at AS deleted_at_29, t14.person_id AS person_id_30, t14.last_operating_institution_id AS last_operating_institution_id_31, t0.birth_nation_id AS birth_nation_id_32, t0.birth_city_id AS birth_city_id_33, t0.residence_city_id AS residence_city_id_34, t0.residence_province_id AS residence_province_id_35, t0.residence_nation_id AS residence_nation_id_36, t37.signature_certificate_expires_on AS signature_certificate_expires_on_38, t37.signature_kit_notification_level AS signature_kit_notification_level_39, t37.id AS id_40, t37.active AS active_41, t37.created_at AS created_at_42, t37.updated_at AS updated_at_43, t37.deleted_at AS deleted_at_44, t37.person_id AS person_id_45, t37.signature_certifier_id AS signature_certifier_id_46 FROM persons t0 LEFT JOIN user t14 ON t14.person_id = t0.id LEFT JOIN legal_owner t37 ON t37.person_id = t0.id WHERE t0.id = 453;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
6	Proxies\__CG__\App\Entity\Person::Doctrine\ORM\Proxy\{closure} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
8	Proxies\__CG__\App\Entity\Person->__get (line 153)
9	App\Entity\Person->getName (line 114)
10	App\Service\AccreditedInstitutionSearchService->legalOwnerName (line 1101)
11	App\Service\AccreditedInstitutionSearchService->summarizeInstitution (line 528)
12	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 193)
13	array_map (line 192)
14	App\Service\AccreditedInstitutionSearchService::search (line 192)
15	App\Twig\Components\AccreditedInstitutionSearch->getResults (line 108)
16	App\Twig\Components\AccreditedInstitutionSearch->buildMap (line 316)
17	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
18	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
19	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
20	iterator_to_array (line 50)
21	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
22	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
23	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
24	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
25	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
26	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
27	Twig\Template->yieldBlock (line 458)
28	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
29	Twig\Template->yield (line 411)
30	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
31	Twig\Template->yield (line 411)
32	Twig\Template->display (line 366)
33	Twig\Template->render (line 381)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
44	require_once (line 32)
45	require_once (line 5)

23.66 ms
(2.54%)

SELECT t0.id AS id_1, t0.note AS note_2, t0.note_next_investigator AS note_next_investigator_3, t0.status AS status_4, t0.already_been_requested_integration AS already_been_requested_integration_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deadline AS deadline_8, t0.completed_at AS completed_at_9, t0.integration_requested_at AS integration_requested_at_10, t0.integration_deadline_at AS integration_deadline_at_11, t0.integration_final_deadline_at AS integration_final_deadline_at_12, t0.deadline_notification_sent AS deadline_notification_sent_13, t0.started_at AS started_at_14, t0.variation_request_id AS variation_request_id_15, t0.assigned_to_id AS assigned_to_id_16, t17.numero_determina AS numero_determina_18, t17.codice_protocollo AS codice_protocollo_19, t17.data_determina AS data_determina_20, t17.id AS id_21, t17.active AS active_22, t17.created_at AS created_at_23, t17.updated_at AS updated_at_24, t17.deleted_at AS deleted_at_25, t17.variation_investigation_l3_id AS variation_investigation_l3_id_26, t17.variation_request_id AS variation_request_id_27, t17.document_id AS document_id_28 FROM variation_investigation_l3 t0 LEFT JOIN variation_investigation_determina t17 ON t17.variation_investigation_l3_id = t0.id WHERE t0.variation_request_id = ?

Parameters:

[
  85
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.note AS note_2,
  t0.note_next_investigator AS note_next_investigator_3,
  t0.status AS status_4,
  t0.already_been_requested_integration AS already_been_requested_integration_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deadline AS deadline_8,
  t0.completed_at AS completed_at_9,
  t0.integration_requested_at AS integration_requested_at_10,
  t0.integration_deadline_at AS integration_deadline_at_11,
  t0.integration_final_deadline_at AS integration_final_deadline_at_12,
  t0.deadline_notification_sent AS deadline_notification_sent_13,
  t0.started_at AS started_at_14,
  t0.variation_request_id AS variation_request_id_15,
  t0.assigned_to_id AS assigned_to_id_16,
  t17.numero_determina AS numero_determina_18,
  t17.codice_protocollo AS codice_protocollo_19,
  t17.data_determina AS data_determina_20,
  t17.id AS id_21,
  t17.active AS active_22,
  t17.created_at AS created_at_23,
  t17.updated_at AS updated_at_24,
  t17.deleted_at AS deleted_at_25,
  t17.variation_investigation_l3_id AS variation_investigation_l3_id_26,
  t17.variation_request_id AS variation_request_id_27,
  t17.document_id AS document_id_28
FROM
  variation_investigation_l3 t0
  LEFT JOIN variation_investigation_determina t17 ON t17.variation_investigation_l3_id = t0.id
WHERE
  t0.variation_request_id = ?

SELECT t0.id AS id_1, t0.note AS note_2, t0.note_next_investigator AS note_next_investigator_3, t0.status AS status_4, t0.already_been_requested_integration AS already_been_requested_integration_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deadline AS deadline_8, t0.completed_at AS completed_at_9, t0.integration_requested_at AS integration_requested_at_10, t0.integration_deadline_at AS integration_deadline_at_11, t0.integration_final_deadline_at AS integration_final_deadline_at_12, t0.deadline_notification_sent AS deadline_notification_sent_13, t0.started_at AS started_at_14, t0.variation_request_id AS variation_request_id_15, t0.assigned_to_id AS assigned_to_id_16, t17.numero_determina AS numero_determina_18, t17.codice_protocollo AS codice_protocollo_19, t17.data_determina AS data_determina_20, t17.id AS id_21, t17.active AS active_22, t17.created_at AS created_at_23, t17.updated_at AS updated_at_24, t17.deleted_at AS deleted_at_25, t17.variation_investigation_l3_id AS variation_investigation_l3_id_26, t17.variation_request_id AS variation_request_id_27, t17.document_id AS document_id_28 FROM variation_investigation_l3 t0 LEFT JOIN variation_investigation_determina t17 ON t17.variation_investigation_l3_id = t0.id WHERE t0.variation_request_id = 85;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->summarizeVariationDeterminasForRequest (line 1037)
10	App\Service\AccreditedInstitutionSearchService->summarizeVariation (line 865)
11	App\Service\AccreditedInstitutionSearchService->summarizeVariations (line 849)
12	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 224)
13	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
14	array_map (line 310)
15	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
16	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
17	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
18	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
19	iterator_to_array (line 50)
20	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
21	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
22	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
23	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
24	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
25	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
26	Twig\Template->yieldBlock (line 458)
27	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
28	Twig\Template->yield (line 411)
29	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
30	Twig\Template->yield (line 411)
31	Twig\Template->display (line 366)
32	Twig\Template->render (line 381)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
38	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 193)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
43	require_once (line 32)
44	require_once (line 5)

19.02 ms
(2.04%)

SELECT t0.signature_certificate_expires_on AS signature_certificate_expires_on_1, t0.signature_kit_notification_level AS signature_kit_notification_level_2, t0.id AS id_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.person_id AS person_id_8, t0.signature_certifier_id AS signature_certifier_id_9 FROM legal_owner t0 WHERE t0.id = ?

Parameters:

[
  180
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.signature_certificate_expires_on AS signature_certificate_expires_on_1,
  t0.signature_kit_notification_level AS signature_kit_notification_level_2,
  t0.id AS id_3,
  t0.active AS active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.person_id AS person_id_8,
  t0.signature_certifier_id AS signature_certifier_id_9
FROM
  legal_owner t0
WHERE
  t0.id = ?

SELECT t0.signature_certificate_expires_on AS signature_certificate_expires_on_1, t0.signature_kit_notification_level AS signature_kit_notification_level_2, t0.id AS id_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.person_id AS person_id_8, t0.signature_certifier_id AS signature_certifier_id_9 FROM legal_owner t0 WHERE t0.id = 180;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
6	Proxies\__CG__\App\Entity\LegalOwner::Doctrine\ORM\Proxy\{closure} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
8	Proxies\__CG__\App\Entity\LegalOwner->__get (line 153)
9	App\Entity\LegalOwner->getPerson (line 59)
10	App\Service\AccreditedInstitutionSearchService->legalOwnerName (line 1096)
11	App\Service\AccreditedInstitutionSearchService->summarizeInstitution (line 528)
12	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 193)
13	array_map (line 192)
14	App\Service\AccreditedInstitutionSearchService::search (line 192)
15	App\Twig\Components\AccreditedInstitutionSearch->getResults (line 108)
16	App\Twig\Components\AccreditedInstitutionSearch->buildMap (line 316)
17	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
18	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
19	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
20	iterator_to_array (line 50)
21	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
22	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
23	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
24	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
25	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
26	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
27	Twig\Template->yieldBlock (line 458)
28	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
29	Twig\Template->yield (line 411)
30	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
31	Twig\Template->yield (line 411)
32	Twig\Template->display (line 366)
33	Twig\Template->render (line 381)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
44	require_once (line 32)
45	require_once (line 5)

16.38 ms
(1.76%)

SELECT t0.name AS name_1, t0.capital AS capital_2, t0.inactive AS inactive_3, t0.istat_code AS istat_code_4, t0.cadastre_code AS cadastre_code_5, t0.region_code AS region_code_6, t0.province_code AS province_code_7, t0.region_name AS region_name_8, t0.province_name AS province_name_9, t0.biletteral_code AS biletteral_code_10, t0.telephone_prefix AS telephone_prefix_11, t0.id AS id_12, t0.active AS active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16 FROM cities t0 WHERE t0.id = ?

Parameters:

[
  16556
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.capital AS capital_2,
  t0.inactive AS inactive_3,
  t0.istat_code AS istat_code_4,
  t0.cadastre_code AS cadastre_code_5,
  t0.region_code AS region_code_6,
  t0.province_code AS province_code_7,
  t0.region_name AS region_name_8,
  t0.province_name AS province_name_9,
  t0.biletteral_code AS biletteral_code_10,
  t0.telephone_prefix AS telephone_prefix_11,
  t0.id AS id_12,
  t0.active AS active_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16
FROM
  cities t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.capital AS capital_2, t0.inactive AS inactive_3, t0.istat_code AS istat_code_4, t0.cadastre_code AS cadastre_code_5, t0.region_code AS region_code_6, t0.province_code AS province_code_7, t0.region_name AS region_name_8, t0.province_name AS province_name_9, t0.biletteral_code AS biletteral_code_10, t0.telephone_prefix AS telephone_prefix_11, t0.id AS id_12, t0.active AS active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16 FROM cities t0 WHERE t0.id = 16556;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
6	Proxies\__CG__\App\Entity\City::Doctrine\ORM\Proxy\{closure} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
8	Proxies\__CG__\App\Entity\City->__get (line 153)
9	App\Entity\City->getBiletteralCode (line 158)
10	App\Service\AccreditedInstitutionSearchService->resolveInstitutionOfficeCoordinates (line 1211)
11	App\Service\AccreditedInstitutionSearchService->summarizeOffices (line 675)
12	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 226)
13	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
14	array_map (line 310)
15	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
16	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
17	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
18	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
19	iterator_to_array (line 50)
20	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
21	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
22	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
23	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
24	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
25	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
26	Twig\Template->yieldBlock (line 458)
27	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
28	Twig\Template->yield (line 411)
29	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
30	Twig\Template->yield (line 411)
31	Twig\Template->display (line 366)
32	Twig\Template->render (line 381)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
38	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 193)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
43	require_once (line 32)
44	require_once (line 5)

7.04 ms
(0.75%)

SELECT t0.description AS description_1, t0.context AS context_2, t0.legal_form AS legal_form_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.institution_macro_type_id AS institution_macro_type_id_9 FROM institution_type t0 WHERE t0.id = ?

Parameters:

[
  27
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.description AS description_1,
  t0.context AS context_2,
  t0.legal_form AS legal_form_3,
  t0.id AS id_4,
  t0.active AS active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.institution_macro_type_id AS institution_macro_type_id_9
FROM
  institution_type t0
WHERE
  t0.id = ?

SELECT t0.description AS description_1, t0.context AS context_2, t0.legal_form AS legal_form_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.institution_macro_type_id AS institution_macro_type_id_9 FROM institution_type t0 WHERE t0.id = 27;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
6	Proxies\__CG__\App\Entity\InstitutionType::Doctrine\ORM\Proxy\{closure} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
8	Proxies\__CG__\App\Entity\InstitutionType->__get (line 153)
9	App\Entity\InstitutionType->getDescription (line 28)
10	App\Service\AccreditedInstitutionSearchService->summarizeApplication (line 577)
11	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 558)
12	array_map (line 557)
13	App\Service\AccreditedInstitutionSearchService::summarizeApplications (line 557)
14	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 223)
15	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
16	array_map (line 310)
17	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
18	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
19	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
20	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
21	iterator_to_array (line 50)
22	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
23	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
28	Twig\Template->yieldBlock (line 458)
29	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
32	Twig\Template->yield (line 411)
33	Twig\Template->display (line 366)
34	Twig\Template->render (line 381)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
45	require_once (line 32)
46	require_once (line 5)

6.10 ms
(0.65%)

SELECT t0.id AS id_1, t0.note AS note_2, t0.note_next_investigator AS note_next_investigator_3, t0.status AS status_4, t0.already_been_requested_integration AS already_been_requested_integration_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deadline AS deadline_8, t0.completed_at AS completed_at_9, t0.integration_requested_at AS integration_requested_at_10, t0.integration_deadline_at AS integration_deadline_at_11, t0.integration_final_deadline_at AS integration_final_deadline_at_12, t0.deadline_notification_sent AS deadline_notification_sent_13, t0.started_at AS started_at_14, t0.maintenance_request_id AS maintenance_request_id_15, t0.assigned_to_id AS assigned_to_id_16, t17.numero_determina AS numero_determina_18, t17.codice_protocollo AS codice_protocollo_19, t17.id AS id_20, t17.active AS active_21, t17.created_at AS created_at_22, t17.updated_at AS updated_at_23, t17.deleted_at AS deleted_at_24, t17.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_25, t17.document_id AS document_id_26 FROM maintenance_investigation_l3 t0 LEFT JOIN maintenance_determina t17 ON t17.maintenance_investigation_l3_id = t0.id WHERE t0.maintenance_request_id = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.note AS note_2,
  t0.note_next_investigator AS note_next_investigator_3,
  t0.status AS status_4,
  t0.already_been_requested_integration AS already_been_requested_integration_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deadline AS deadline_8,
  t0.completed_at AS completed_at_9,
  t0.integration_requested_at AS integration_requested_at_10,
  t0.integration_deadline_at AS integration_deadline_at_11,
  t0.integration_final_deadline_at AS integration_final_deadline_at_12,
  t0.deadline_notification_sent AS deadline_notification_sent_13,
  t0.started_at AS started_at_14,
  t0.maintenance_request_id AS maintenance_request_id_15,
  t0.assigned_to_id AS assigned_to_id_16,
  t17.numero_determina AS numero_determina_18,
  t17.codice_protocollo AS codice_protocollo_19,
  t17.id AS id_20,
  t17.active AS active_21,
  t17.created_at AS created_at_22,
  t17.updated_at AS updated_at_23,
  t17.deleted_at AS deleted_at_24,
  t17.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_25,
  t17.document_id AS document_id_26
FROM
  maintenance_investigation_l3 t0
  LEFT JOIN maintenance_determina t17 ON t17.maintenance_investigation_l3_id = t0.id
WHERE
  t0.maintenance_request_id = ?

SELECT t0.id AS id_1, t0.note AS note_2, t0.note_next_investigator AS note_next_investigator_3, t0.status AS status_4, t0.already_been_requested_integration AS already_been_requested_integration_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deadline AS deadline_8, t0.completed_at AS completed_at_9, t0.integration_requested_at AS integration_requested_at_10, t0.integration_deadline_at AS integration_deadline_at_11, t0.integration_final_deadline_at AS integration_final_deadline_at_12, t0.deadline_notification_sent AS deadline_notification_sent_13, t0.started_at AS started_at_14, t0.maintenance_request_id AS maintenance_request_id_15, t0.assigned_to_id AS assigned_to_id_16, t17.numero_determina AS numero_determina_18, t17.codice_protocollo AS codice_protocollo_19, t17.id AS id_20, t17.active AS active_21, t17.created_at AS created_at_22, t17.updated_at AS updated_at_23, t17.deleted_at AS deleted_at_24, t17.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_25, t17.document_id AS document_id_26 FROM maintenance_investigation_l3 t0 LEFT JOIN maintenance_determina t17 ON t17.maintenance_investigation_l3_id = t0.id WHERE t0.maintenance_request_id = 12;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
9	App\Service\AccreditedInstitutionSearchService->summarizeMaintenanceDeterminas (line 1069)
10	App\Service\AccreditedInstitutionSearchService->summarizeMaintenance (line 928)
11	App\Service\AccreditedInstitutionSearchService->summarizeMaintenances (line 912)
12	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 225)
13	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
14	array_map (line 310)
15	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
16	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
17	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
18	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
19	iterator_to_array (line 50)
20	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
21	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
22	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
23	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
24	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
25	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
26	Twig\Template->yieldBlock (line 458)
27	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
28	Twig\Template->yield (line 411)
29	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
30	Twig\Template->yield (line 411)
31	Twig\Template->display (line 366)
32	Twig\Template->render (line 381)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
38	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 193)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
43	require_once (line 32)
44	require_once (line 5)

4.59 ms
(0.49%)

SELECT t0.description AS description_1, t0.id AS id_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM institution_macro_type t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.description AS description_1,
  t0.id AS id_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  institution_macro_type t0
WHERE
  t0.id = ?

SELECT t0.description AS description_1, t0.id AS id_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM institution_macro_type t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
6	Proxies\__CG__\App\Entity\InstitutionMacroType::Doctrine\ORM\Proxy\{closure} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
8	Proxies\__CG__\App\Entity\InstitutionMacroType->__get (line 153)
9	App\Entity\InstitutionMacroType->getDescription (line 16)
10	App\Service\AccreditedInstitutionSearchService->summarizeApplication (line 578)
11	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 558)
12	array_map (line 557)
13	App\Service\AccreditedInstitutionSearchService::summarizeApplications (line 557)
14	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 223)
15	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
16	array_map (line 310)
17	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
18	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
19	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
20	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
21	iterator_to_array (line 50)
22	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
23	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
28	Twig\Template->yieldBlock (line 458)
29	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
32	Twig\Template->yield (line 411)
33	Twig\Template->display (line 366)
34	Twig\Template->render (line 381)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
45	require_once (line 32)
46	require_once (line 5)

2.71 ms
(0.29%)

SELECT t0.code AS code_1, t0.description AS description_2, t0.context AS context_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM accreditation_tipologies t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.description AS description_2,
  t0.context AS context_3,
  t0.id AS id_4,
  t0.active AS active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8
FROM
  accreditation_tipologies t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.description AS description_2, t0.context AS context_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM accreditation_tipologies t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
6	Proxies\__CG__\App\Entity\AccreditationTipologies::Doctrine\ORM\Proxy\{closure} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
8	Proxies\__CG__\App\Entity\AccreditationTipologies->__get (line 153)
9	App\Entity\AccreditationTipologies->getDescription (line 34)
10	App\Service\AccreditedInstitutionSearchService->summarizeApplication (line 576)
11	App\Service\AccreditedInstitutionSearchService->App\Service\{closure} (line 558)
12	array_map (line 557)
13	App\Service\AccreditedInstitutionSearchService::summarizeApplications (line 557)
14	App\Service\AccreditedInstitutionSearchService->getInstitutionDetails (line 223)
15	App\Twig\Components\AccreditedInstitutionSearch->App\Twig\Components\{closure} (line 311)
16	array_map (line 310)
17	App\Twig\Components\AccreditedInstitutionSearch::buildMap (line 310)
18	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
19	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
20	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
21	iterator_to_array (line 50)
22	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
23	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
28	Twig\Template->yieldBlock (line 458)
29	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
32	Twig\Template->yield (line 411)
33	Twig\Template->display (line 366)
34	Twig\Template->render (line 381)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
45	require_once (line 32)
46	require_once (line 5)

1.97 ms
(0.21%)

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.migrated AS migrated_15, t0.id AS id_16, t0.active AS active_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t21.id AS id_22, t21.active AS active_23, t21.created_at AS created_at_24, t21.updated_at AS updated_at_25, t21.deleted_at AS deleted_at_26, t21.accreditation_application_id AS accreditation_application_id_27, t21.tipology_id AS tipology_id_28, t0.institution_id AS institution_id_29, t0.legal_owner_id AS legal_owner_id_30, t0.institution_typology_id AS institution_typology_id_31, t0.parent_application_id AS parent_application_id_32 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t21 ON t21.accreditation_application_id = t0.id WHERE t0.institution_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.status AS status_1,
  t0.request_type AS request_type_2,
  t0.code AS code_3,
  t0.accreditation_type AS accreditation_type_4,
  t0.score AS score_5,
  t0.send_at AS send_at_6,
  t0.determina_completed_at AS determina_completed_at_7,
  t0.accreditation_end_date AS accreditation_end_date_8,
  t0.renewal_notification_level AS renewal_notification_level_9,
  t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10,
  t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11,
  t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12,
  t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13,
  t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14,
  t0.migrated AS migrated_15,
  t0.id AS id_16,
  t0.active AS active_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.deleted_at AS deleted_at_20,
  t21.id AS id_22,
  t21.active AS active_23,
  t21.created_at AS created_at_24,
  t21.updated_at AS updated_at_25,
  t21.deleted_at AS deleted_at_26,
  t21.accreditation_application_id AS accreditation_application_id_27,
  t21.tipology_id AS tipology_id_28,
  t0.institution_id AS institution_id_29,
  t0.legal_owner_id AS legal_owner_id_30,
  t0.institution_typology_id AS institution_typology_id_31,
  t0.parent_application_id AS parent_application_id_32
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t21 ON t21.accreditation_application_id = t0.id
WHERE
  t0.institution_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.migrated AS migrated_15, t0.id AS id_16, t0.active AS active_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t21.id AS id_22, t21.active AS active_23, t21.created_at AS created_at_24, t21.updated_at AS updated_at_25, t21.deleted_at AS deleted_at_26, t21.accreditation_application_id AS accreditation_application_id_27, t21.tipology_id AS tipology_id_28, t0.institution_id AS institution_id_29, t0.legal_owner_id AS legal_owner_id_30, t0.institution_typology_id AS institution_typology_id_31, t0.parent_application_id AS parent_application_id_32 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t21 ON t21.accreditation_application_id = t0.id WHERE t0.institution_id IN (7, 443, 118, 397, 195, 94, 302, 91, 65, 220, 264, 298, 261, 379, 388, 68, 398, 296, 253, 16, 249, 197, 17, 10, 374);

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
5	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Service\AccreditedInstitutionSearchService->search (line 194)
12	App\Twig\Components\AccreditedInstitutionSearch->getResults (line 108)
13	App\Twig\Components\AccreditedInstitutionSearch->buildMap (line 316)
14	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
15	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
16	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
17	iterator_to_array (line 50)
18	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
19	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
20	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
21	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
22	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
23	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
24	Twig\Template->yieldBlock (line 458)
25	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
28	Twig\Template->yield (line 411)
29	Twig\Template->display (line 366)
30	Twig\Template->render (line 381)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
36	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 193)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
41	require_once (line 32)
42	require_once (line 5)

1.62 ms
(0.17%)

SELECT t0.context AS context_1, t0.id AS id_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.institution_type_id AS institution_type_id_7, t0.institution_id AS institution_id_8, t9.status AS status_10, t9.request_type AS request_type_11, t9.code AS code_12, t9.accreditation_type AS accreditation_type_13, t9.score AS score_14, t9.send_at AS send_at_15, t9.determina_completed_at AS determina_completed_at_16, t9.accreditation_end_date AS accreditation_end_date_17, t9.renewal_notification_level AS renewal_notification_level_18, t9.viewed_by_instructor_l1 AS viewed_by_instructor_l1_19, t9.viewed_by_instructor_l2 AS viewed_by_instructor_l2_20, t9.viewed_by_instructor_l3 AS viewed_by_instructor_l3_21, t9.assignment_notification2_days_sent AS assignment_notification2_days_sent_22, t9.assignment_notification25_days_sent AS assignment_notification25_days_sent_23, t9.migrated AS migrated_24, t9.id AS id_25, t9.active AS active_26, t9.created_at AS created_at_27, t9.updated_at AS updated_at_28, t9.deleted_at AS deleted_at_29, t9.institution_id AS institution_id_30, t9.legal_owner_id AS legal_owner_id_31, t9.institution_typology_id AS institution_typology_id_32, t9.parent_application_id AS parent_application_id_33 FROM institutions_accreditation_type t0 LEFT JOIN accreditation_application t9 ON t9.institution_typology_id = t0.id WHERE t0.institution_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.context AS context_1,
  t0.id AS id_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.institution_type_id AS institution_type_id_7,
  t0.institution_id AS institution_id_8,
  t9.status AS status_10,
  t9.request_type AS request_type_11,
  t9.code AS code_12,
  t9.accreditation_type AS accreditation_type_13,
  t9.score AS score_14,
  t9.send_at AS send_at_15,
  t9.determina_completed_at AS determina_completed_at_16,
  t9.accreditation_end_date AS accreditation_end_date_17,
  t9.renewal_notification_level AS renewal_notification_level_18,
  t9.viewed_by_instructor_l1 AS viewed_by_instructor_l1_19,
  t9.viewed_by_instructor_l2 AS viewed_by_instructor_l2_20,
  t9.viewed_by_instructor_l3 AS viewed_by_instructor_l3_21,
  t9.assignment_notification2_days_sent AS assignment_notification2_days_sent_22,
  t9.assignment_notification25_days_sent AS assignment_notification25_days_sent_23,
  t9.migrated AS migrated_24,
  t9.id AS id_25,
  t9.active AS active_26,
  t9.created_at AS created_at_27,
  t9.updated_at AS updated_at_28,
  t9.deleted_at AS deleted_at_29,
  t9.institution_id AS institution_id_30,
  t9.legal_owner_id AS legal_owner_id_31,
  t9.institution_typology_id AS institution_typology_id_32,
  t9.parent_application_id AS parent_application_id_33
FROM
  institutions_accreditation_type t0
  LEFT JOIN accreditation_application t9 ON t9.institution_typology_id = t0.id
WHERE
  t0.institution_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.context AS context_1, t0.id AS id_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.institution_type_id AS institution_type_id_7, t0.institution_id AS institution_id_8, t9.status AS status_10, t9.request_type AS request_type_11, t9.code AS code_12, t9.accreditation_type AS accreditation_type_13, t9.score AS score_14, t9.send_at AS send_at_15, t9.determina_completed_at AS determina_completed_at_16, t9.accreditation_end_date AS accreditation_end_date_17, t9.renewal_notification_level AS renewal_notification_level_18, t9.viewed_by_instructor_l1 AS viewed_by_instructor_l1_19, t9.viewed_by_instructor_l2 AS viewed_by_instructor_l2_20, t9.viewed_by_instructor_l3 AS viewed_by_instructor_l3_21, t9.assignment_notification2_days_sent AS assignment_notification2_days_sent_22, t9.assignment_notification25_days_sent AS assignment_notification25_days_sent_23, t9.migrated AS migrated_24, t9.id AS id_25, t9.active AS active_26, t9.created_at AS created_at_27, t9.updated_at AS updated_at_28, t9.deleted_at AS deleted_at_29, t9.institution_id AS institution_id_30, t9.legal_owner_id AS legal_owner_id_31, t9.institution_typology_id AS institution_typology_id_32, t9.parent_application_id AS parent_application_id_33 FROM institutions_accreditation_type t0 LEFT JOIN accreditation_application t9 ON t9.institution_typology_id = t0.id WHERE t0.institution_id IN (7, 443, 118, 397, 195, 94, 302, 91, 65, 220, 264, 298, 261, 379, 388, 68, 398, 296, 253, 16, 249, 197, 17, 10, 374);

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
5	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Service\AccreditedInstitutionSearchService->search (line 194)
12	App\Twig\Components\AccreditedInstitutionSearch->getResults (line 108)
13	App\Twig\Components\AccreditedInstitutionSearch->buildMap (line 316)
14	App\Twig\Components\AccreditedInstitutionSearch->instantiateMap (line 292)
15	App\Twig\Components\AccreditedInstitutionSearch->getMap (line 37)
16	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 78)
17	iterator_to_array (line 50)
18	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
19	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
20	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
21	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
22	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
23	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->block_content (line 120)
24	Twig\Template->yieldBlock (line 458)
25	__TwigTemplate_273e74c57071d1b0ff3d5ef8c5afa2d1->doDisplay (line 105)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_8c9976bb9bc5c49894728bac059aec5f->doDisplay (line 55)
28	Twig\Template->yield (line 411)
29	Twig\Template->display (line 366)
30	Twig\Template->render (line 381)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
36	App\Controller\PublicAccreditedInstitutionSearchController->__invoke (line 39)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 193)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
41	require_once (line 32)
42	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\JobService	104
App\Entity\JobServiceSpecialist	76
App\Entity\InstitutionOfficeStatus	56
App\Entity\InstitutionOffice	45
App\Entity\Document	41
App\Entity\City	37
App\Entity\AccreditationOffice	29
App\Entity\InstitutionAccreditationType	27
App\Entity\AccreditationApplication	26
App\Entity\InstitutionAccreditationTipology	26
App\Entity\User	26
App\Entity\Institution	25
App\Entity\LegalOwner	25
App\Entity\Person	25
App\Entity\AccreditationInvestigationL3	25
App\Entity\InvestigationDetermina	25
App\Entity\VariationRequest	16
App\Entity\VariationInvestigationDetermina	14
App\Entity\LegalForms	8
App\Entity\AtecoCodeVersion	6
App\Entity\InstitutionType	6
App\Entity\InstitutionSize	4
App\Entity\InstitutionMacroType	4
App\Entity\Nation	3
App\Entity\AccreditationTipologies	2
App\Entity\VariationInvestigationL3	2
App\Entity\MaintenanceRequest	2
App\Entity\MaintenanceInvestigationL3	2
App\Entity\MaintenanceDetermina	2

Entities Mapping

Class	Mapping errors
App\Entity\Institution	The field App\Entity\Institution#accreditationApplications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AccreditationApplication#institution does not contain the required 'inversedBy: "accreditationApplications"' attribute. The field App\Entity\Institution#institutionAccreditationTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\InstitutionAccreditationType#institution does not contain the required 'inversedBy: "institutionAccreditationTypes"' attribute.
App\Entity\AccreditationApplication	The field App\Entity\AccreditationApplication#institutionAccreditationTipology is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\InstitutionAccreditationTipology#accreditationApplication does not contain the required 'inversedBy: "institutionAccreditationTipology"' attribute. The mappings App\Entity\AccreditationApplication#jobServicesSpecialists and App\Entity\JobServiceSpecialist#accreditationApplication are inconsistent with each other.
App\Entity\LegalOwner	No errors.
App\Entity\Person	The mappings App\Entity\Person#personDocuments and App\Entity\PersonDocument#person are inconsistent with each other.
App\Entity\InstitutionOffice	No errors.
App\Entity\City	No errors.
App\Entity\InstitutionOfficeStatus	No errors.
App\Entity\AccreditationOffice	No errors.
App\Entity\InstitutionAccreditationTipology	No errors.
App\Entity\AccreditationTipologies	No errors.
App\Entity\InstitutionAccreditationMacrotype	No errors.
App\Entity\Macrotypologies	No errors.
App\Entity\InstitutionSep	No errors.
App\Entity\Sep	No errors.
App\Entity\InstitutionAccreditationType	No errors.
App\Entity\InstitutionType	No errors.
App\Entity\InstitutionMacroType	No errors.
App\Entity\InstitutionSpecialUser	No errors.
App\Entity\SpecialUsers	No errors.
App\Entity\JobService	No errors.
App\Entity\JobServiceSpecialist	No errors.
App\Entity\LegalForms	No errors.
App\Entity\InstitutionSize	No errors.
App\Entity\AtecoCodeVersion	No errors.
App\Entity\VariationRequest	No errors.
App\Entity\SuspensionRevocation	No errors.
App\Entity\InstitutionAccreditationTabs	No errors.
App\Entity\Document	No errors.
App\Entity\AccreditationInvestigationL1	No errors.
App\Entity\AccreditationInvestigationL2	No errors.
App\Entity\AccreditationInvestigationL3	No errors.
App\Entity\SignedApplicationDocument	No errors.
App\Entity\SignatureCertifier	No errors.
App\Entity\User	The field App\Entity\User#notificheRicevute is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Notification#utente does not contain the required 'inversedBy: "notificheRicevute"' attribute. The field App\Entity\User#notificheCreate is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Notification#creatore does not contain the required 'inversedBy: "notificheCreate"' attribute.
App\Entity\Nation	No errors.
App\Entity\IdentityDocument	No errors.
App\Entity\PersonDocument	No errors.
App\Entity\Role	No errors.
App\Entity\Notification	No errors.
App\Entity\TemporaryOfficeValidityHistory	No errors.
App\Entity\InvestigationDetermina	No errors.
App\Entity\InvestigationNoteHistory	No errors.
App\Entity\AccreditationDocumentReviewL3	No errors.
App\Entity\AccreditationMetadataReviewL3	No errors.
App\Entity\VariationInvestigationDetermina	No errors.
App\Entity\VariationInvestigationL3	No errors.
App\Entity\VariationOperation	No errors.
App\Entity\VariationInvestigationL1	No errors.
App\Entity\VariationInvestigationL2	No errors.
App\Entity\VariationRequirementDocument	No errors.
App\Entity\VariationRequirementMetadata	No errors.
App\Entity\VariationSelectedRequirement	No errors.
App\Entity\VariationRequestSubType	No errors.
App\Entity\MaintenanceRequest	No errors.
App\Entity\VariationDocumentReviewL3	No errors.
App\Entity\VariationMetadataReviewL3	No errors.
App\Entity\MaintenanceDocument	No errors.
App\Entity\MaintenanceInvestigationL1	No errors.
App\Entity\MaintenanceInvestigationL2	No errors.
App\Entity\MaintenanceInvestigationL3	No errors.
App\Entity\MaintenanceRequestMetadata	No errors.
App\Entity\MaintenanceDetermina	No errors.
App\Entity\MaintenanceDocumentReviewL3	No errors.
App\Entity\MaintenanceMetadataReviewL3	No errors.
App\Entity\AtecoCode	No errors.
App\Entity\AtecoVersion	No errors.
App\Entity\AccreditationRequirement	The field App\Entity\AccreditationRequirement#requirements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Requirement#accreditationRequirement does not contain the required 'inversedBy: "requirements"' attribute.
App\Entity\RequirementMetadataField	No errors.
App\Entity\RequirementDocumentType	No errors.
App\Entity\AccreditationDocumentReviewL1	No errors.
App\Entity\AccreditationMetadataReviewL1	No errors.
App\Entity\AccreditationDocumentReviewL2	No errors.
App\Entity\AccreditationMetadataReviewL2	No errors.
App\Entity\TemporaryOfficeRequest	The mappings App\Entity\TemporaryOfficeRequest#temporaryOfficeInvestigationL2s and App\Entity\TemporaryOfficeInvestigationL2#temporaryOfficeRequest are inconsistent with each other.
App\Entity\ReviewNoteHistory	No errors.
App\Entity\VariationRequestDocument	No errors.
App\Entity\VariationDocumentReviewL1	No errors.
App\Entity\VariationMetadataReviewL1	No errors.
App\Entity\VariationDocumentReviewL2	No errors.
App\Entity\VariationMetadataReviewL2	No errors.
App\Entity\Requirement	No errors.
App\Entity\MaintenanceDocumentReviewL1	No errors.
App\Entity\MaintenanceMetadataReviewL1	No errors.
App\Entity\MaintenanceDocumentReviewL2	No errors.
App\Entity\MaintenanceMetadataReviewL2	No errors.
App\Entity\AccreditationRequirementMetaValue	No errors.
App\Entity\FieldGroup	No errors.
App\Entity\DocumentType	No errors.
App\Entity\TemporaryOfficeDocument	No errors.
App\Entity\TemporaryOfficeMetadata	No errors.
App\Entity\TemporaryOfficeInvestigationL1	No errors.
App\Entity\TemporaryOfficeInvestigationL2	No errors.
App\Entity\TemporaryDeskJobServiceSnapshot	No errors.
App\Entity\TemporaryDeskInvestigationDetermina	No errors.
App\Entity\TemporaryDeskJobServiceSpecialistSnapshot	No errors.
App\Entity\TemporaryDeskRequest	No errors.
App\Entity\AuditRequest	No errors.
App\Entity\TemporaryDeskMetadata	No errors.
App\Entity\LogEntry	No errors.
App\Entity\Capital	No errors.
App\Entity\TemporaryDeskDocument	No errors.
App\Entity\TemporaryDeskInvestigationL3	No errors.
App\Entity\TabDAnnualSubmission	No errors.
App\Entity\Configuration	No errors.
App\Entity\AuditRequirementReview	No errors.
App\Entity\TemporaryDeskInvestigationL1	No errors.
App\Entity\WorkflowStatusHistory	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://sac-test.schema31.it/ricerca-enti-accreditati

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping