Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

47.17 ms Query time

3 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

4.41 ms

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_22c8afe426648d94325cdc9396688811->block_content (line 120)
21	Twig\Template->yieldBlock (line 458)
22	__TwigTemplate_6786f5f75f39457c754b415e0685618e->doDisplay (line 105)
23	Twig\Template->yield (line 411)
24	__TwigTemplate_22c8afe426648d94325cdc9396688811->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)

3.63 ms

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	Twig\Extension\CoreExtension->getAttribute (line 1928)
11	__TwigTemplate_5db54e9bbdfce2c0483e037e5a67f789::doDisplay (line 53)
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_22c8afe426648d94325cdc9396688811->block_content (line 120)
19	Twig\Template->yieldBlock (line 458)
20	__TwigTemplate_6786f5f75f39457c754b415e0685618e->doDisplay (line 105)
21	Twig\Template->yield (line 411)
22	__TwigTemplate_22c8afe426648d94325cdc9396688811->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.14 ms

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_5db54e9bbdfce2c0483e037e5a67f789::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_22c8afe426648d94325cdc9396688811->block_content (line 120)
19	Twig\Template->yieldBlock (line 458)
20	__TwigTemplate_6786f5f75f39457c754b415e0685618e->doDisplay (line 105)
21	Twig\Template->yield (line 411)
22	__TwigTemplate_22c8afe426648d94325cdc9396688811->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)

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\City	4

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping