Symfony Profiler

Query Metrics

695 Database Queries

39 Different statements

1046.50 ms Query time

6 Invalid entities

1506 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

608.92 ms
(58.19%)

428

SELECT t0.id AS id_1, t0.tabella AS tabella_2, t0.code AS code_3, t0.label AS label_4, t0.type AS type_5, t0.choices AS choices_6, t0.required AS required_7, t0.position AS position_8, t0.active AS active_9, t0.help AS help_10, t0.default_value AS default_value_11, t0.placeholder AS placeholder_12, t0.min_length AS min_length_13, t0.max_length AS max_length_14, t0.pattern AS pattern_15, t0.min_value AS min_value_16, t0.max_value AS max_value_17, t0.step AS step_18, t0.date_format AS date_format_19, t0.duplicable AS duplicable_20, t0.data_element AS data_element_21, t0.anchor_data_element AS anchor_data_element_22, t0.anchor_element AS anchor_element_23, t0.data_type AS data_type_24, t0.anchor_data_type AS anchor_data_type_25, t0.data_constraints AS data_constraints_26, t0.transfer_value AS transfer_value_27, t0.associated_value AS associated_value_28, t0.tipo_accreditamento AS tipo_accreditamento_29, t0.label_field AS label_field_30, t0.choice_reference AS choice_reference_31, t0.metadata_filter AS metadata_filter_32, t0.is_visible_to_audit AS is_visible_to_audit_33, t0.is_visible_to_pdf AS is_visible_to_pdf_34, t0.is_editable_investigation AS is_editable_investigation_35, t0.field_group_id AS field_group_id_36 FROM requirement_metadata_field t0 WHERE t0.id = ?

Parameters:

[
  397
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tabella AS tabella_2,
  t0.code AS code_3,
  t0.label AS label_4,
  t0.type AS type_5,
  t0.choices AS choices_6,
  t0.required AS required_7,
  t0.position AS position_8,
  t0.active AS active_9,
  t0.help AS help_10,
  t0.default_value AS default_value_11,
  t0.placeholder AS placeholder_12,
  t0.min_length AS min_length_13,
  t0.max_length AS max_length_14,
  t0.pattern AS pattern_15,
  t0.min_value AS min_value_16,
  t0.max_value AS max_value_17,
  t0.step AS step_18,
  t0.date_format AS date_format_19,
  t0.duplicable AS duplicable_20,
  t0.data_element AS data_element_21,
  t0.anchor_data_element AS anchor_data_element_22,
  t0.anchor_element AS anchor_element_23,
  t0.data_type AS data_type_24,
  t0.anchor_data_type AS anchor_data_type_25,
  t0.data_constraints AS data_constraints_26,
  t0.transfer_value AS transfer_value_27,
  t0.associated_value AS associated_value_28,
  t0.tipo_accreditamento AS tipo_accreditamento_29,
  t0.label_field AS label_field_30,
  t0.choice_reference AS choice_reference_31,
  t0.metadata_filter AS metadata_filter_32,
  t0.is_visible_to_audit AS is_visible_to_audit_33,
  t0.is_visible_to_pdf AS is_visible_to_pdf_34,
  t0.is_editable_investigation AS is_editable_investigation_35,
  t0.field_group_id AS field_group_id_36
FROM
  requirement_metadata_field t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.tabella AS tabella_2, t0.code AS code_3, t0.label AS label_4, t0.type AS type_5, t0.choices AS choices_6, t0.required AS required_7, t0.position AS position_8, t0.active AS active_9, t0.help AS help_10, t0.default_value AS default_value_11, t0.placeholder AS placeholder_12, t0.min_length AS min_length_13, t0.max_length AS max_length_14, t0.pattern AS pattern_15, t0.min_value AS min_value_16, t0.max_value AS max_value_17, t0.step AS step_18, t0.date_format AS date_format_19, t0.duplicable AS duplicable_20, t0.data_element AS data_element_21, t0.anchor_data_element AS anchor_data_element_22, t0.anchor_element AS anchor_element_23, t0.data_type AS data_type_24, t0.anchor_data_type AS anchor_data_type_25, t0.data_constraints AS data_constraints_26, t0.transfer_value AS transfer_value_27, t0.associated_value AS associated_value_28, t0.tipo_accreditamento AS tipo_accreditamento_29, t0.label_field AS label_field_30, t0.choice_reference AS choice_reference_31, t0.metadata_filter AS metadata_filter_32, t0.is_visible_to_audit AS is_visible_to_audit_33, t0.is_visible_to_pdf AS is_visible_to_pdf_34, t0.is_editable_investigation AS is_editable_investigation_35, t0.field_group_id AS field_group_id_36 FROM requirement_metadata_field t0 WHERE t0.id = 397;

#	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\RequirementMetadataField::Doctrine\ORM\Proxy\{closure} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
8	Proxies\__CG__\App\Entity\RequirementMetadataField->__get (line 146)
9	App\Entity\RequirementMetadataField->getType (line 227)
10	App\Entity\InstitutionAccreditationTabs->getDisplayValue (line 211)
11	Twig\Extension\CoreExtension->getAttribute (line 1913)
12	__TwigTemplate_6b70732dbc8d706dedccd5422a72c560::doDisplay (line 74)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_d38baa65c3c01d852b5564e131ab649b->{closure} (line 1257)
15	Twig\Extension\CoreExtension->captureOutput (line 2110)
16	__TwigTemplate_d38baa65c3c01d852b5564e131ab649b::macro_renderAccordion (line 1030)
17	__TwigTemplate_d38baa65c3c01d852b5564e131ab649b->doDisplay (line 414)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_6297c010a53f63744e41abbc583e9409->block_content (line 2151)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_ef2cb7e231c49e8daf5501931fbdca9c->doDisplay (line 104)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_6297c010a53f63744e41abbc583e9409->doDisplay (line 149)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
32	App\Controller\LandingPageController->home (line 144)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 182)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 5)

114.59 ms
(10.95%)

SELECT t0.id AS id_1, t0.extension_accepted AS extension_accepted_2, t0.document_type_id AS document_type_id_3, t0.accreditation_requirement_id AS accreditation_requirement_id_4 FROM requirement_document_type t0 WHERE t0.id = ?

Parameters:

[
  29
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.extension_accepted AS extension_accepted_2,
  t0.document_type_id AS document_type_id_3,
  t0.accreditation_requirement_id AS accreditation_requirement_id_4
FROM
  requirement_document_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.extension_accepted AS extension_accepted_2, t0.document_type_id AS document_type_id_3, t0.accreditation_requirement_id AS accreditation_requirement_id_4 FROM requirement_document_type t0 WHERE t0.id = 29;

#	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\RequirementDocumentType::Doctrine\ORM\Proxy\{closure} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
8	Proxies\__CG__\App\Entity\RequirementDocumentType->__get (line 146)
9	App\Entity\RequirementDocumentType->getAccreditationRequirement (line 52)
10	App\Service\DocumentiInVigenzaService->findAccreditationDocumentsForApp (line 197)
11	App\Service\DocumentiInVigenzaService->buildItemsForApplication (line 223)
12	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerInstitution (line 106)
13	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerLegalOwner (line 74)
14	App\Controller\LandingPageController->home (line 136)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

113.26 ms
(10.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.field_name AS field_name_4, t0.multiple_document AS multiple_document_5, t0.extension_accepted AS extension_accepted_6, t0.field_group_id AS field_group_id_7 FROM document_type t0 WHERE t0.id = ?

Parameters:

[
  197
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.field_name AS field_name_4,
  t0.multiple_document AS multiple_document_5,
  t0.extension_accepted AS extension_accepted_6,
  t0.field_group_id AS field_group_id_7
FROM
  document_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.field_name AS field_name_4, t0.multiple_document AS multiple_document_5, t0.extension_accepted AS extension_accepted_6, t0.field_group_id AS field_group_id_7 FROM document_type t0 WHERE t0.id = 197;

#	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\DocumentType::Doctrine\ORM\Proxy\{closure} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
8	Proxies\__CG__\App\Entity\DocumentType->__get (line 146)
9	App\Entity\DocumentType->getDescription (line 83)
10	Twig\Extension\CoreExtension->getAttribute (line 1913)
11	__TwigTemplate_d38baa65c3c01d852b5564e131ab649b::{closure} (line 1346)
12	Twig\Extension\CoreExtension->captureOutput (line 2110)
13	__TwigTemplate_d38baa65c3c01d852b5564e131ab649b::macro_renderAccordion (line 1030)
14	__TwigTemplate_d38baa65c3c01d852b5564e131ab649b->doDisplay (line 414)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_6297c010a53f63744e41abbc583e9409->block_content (line 2151)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_ef2cb7e231c49e8daf5501931fbdca9c->doDisplay (line 104)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_6297c010a53f63744e41abbc583e9409->doDisplay (line 149)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
29	App\Controller\LandingPageController->home (line 144)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

50.30 ms
(4.81%)

SELECT a0_.id AS id_0, a0_.meta_type AS meta_type_1, a0_.tab AS tab_2, a0_.status AS status_3, a0_.nota AS nota_4, a0_.has_expiration_date AS has_expiration_date_5, a0_.expiration_date AS expiration_date_6, a0_.reviewed_at AS reviewed_at_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.additional_data AS additional_data_10, d1_.entity AS entity_11, d1_.entity_id AS entity_id_12, d1_.file_name AS file_name_13, d1_.description AS description_14, d1_.valid_to AS valid_to_15, d1_.sac_id AS sac_id_16, d1_.sac_path AS sac_path_17, d1_.hash AS hash_18, d1_.is_old_file AS is_old_file_19, d1_.old_doc_json AS old_doc_json_20, d1_.id AS id_21, d1_.active AS active_22, d1_.created_at AS created_at_23, d1_.updated_at AS updated_at_24, d1_.deleted_at AS deleted_at_25, a2_.id AS id_26, a2_.tabella AS tabella_27, a2_.requisito AS requisito_28, a2_.universita_statali AS universita_statali_29, a2_.scuole_statali AS scuole_statali_30, a2_.scuole_paritarie AS scuole_paritarie_31, a2_.soggetti_privati AS soggetti_privati_32, a2_.centri_formazione_pubblici AS centri_formazione_pubblici_33, a2_.soggetti_legislativi AS soggetti_legislativi_34, a2_.comuni_metropolitane AS comuni_metropolitane_35, a2_.centri_regionali_provinciali AS centri_regionali_provinciali_36, a2_.enti_pubblici55 AS enti_pubblici55_37, a2_.accreditati_anorma_dgr AS accreditati_anorma_dgr_38, a2_.centri_impiego AS centri_impiego_39, a2_.altri_soggetti_a AS altri_soggetti_a_40, a2_.altri_soggetti_g AS altri_soggetti_g_41, a2_.altri_soggetti_h AS altri_soggetti_h_42, a2_.altri_soggetti_i AS altri_soggetti_i_43, a2_.altri_soggetti_m AS altri_soggetti_m_44, a2_.altri_soggetti_f AS altri_soggetti_f_45, a2_.altri_soggetti_cciaa AS altri_soggetti_cciaa_46, a2_.accreditati_di_diritto_c AS accreditati_di_diritto_c_47, a2_.accreditati_di_diritto_d AS accreditati_di_diritto_d_48, a2_.accreditati_di_diritto_e AS accreditati_di_diritto_e_49, a2_.accreditati_di_diritto_j AS accreditati_di_diritto_j_50, a2_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_51, a2_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_52, a2_.tipologia_accreditamento AS tipologia_accreditamento_53, a2_.type AS type_54, a2_.codice_sac AS codice_sac_55, a2_.autodichiarazione AS autodichiarazione_56, a2_.metadati AS metadati_57, a2_.documenti_allegati AS documenti_allegati_58, a2_.scadenza_documenti AS scadenza_documenti_59, a2_.attivita_controllo AS attivita_controllo_60, a2_.tipologia_istruttoria AS tipologia_istruttoria_61, a2_.tempi_verifica AS tempi_verifica_62, a2_.note AS note_63, a2_.is_active AS is_active_64, a2_.data_inizio_validita AS data_inizio_validita_65, a2_.data_fine_validita AS data_fine_validita_66, a2_.primo_accreditamento AS primo_accreditamento_67, a2_.mantenimento AS mantenimento_68, a2_.variazione AS variazione_69, a2_.sede_temporanea AS sede_temporanea_70, a2_.sportello_temporaneo AS sportello_temporaneo_71, a2_.isRequestedForRenewal AS isRequestedForRenewal_72, a2_.accreditamento_autorizzato AS accreditamento_autorizzato_73, a2_.its AS its_74, a2_.diritto_dovere AS diritto_dovere_75, a2_.post_diritto_dovere AS post_diritto_dovere_76, a2_.formazione_continua AS formazione_continua_77, a2_.utenze_speciali AS utenze_speciali_78, a2_.accreditamento_finanziato AS accreditamento_finanziato_79, a2_.tipo_accreditamento AS tipo_accreditamento_80, a2_.sort_index AS sort_index_81, a2_.next_level_accreditation AS next_level_accreditation_82, a2_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_83, a2_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_84, a2_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_85, a2_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_86, a2_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_87, a2_.sequence_to_pdf_show AS sequence_to_pdf_show_88, a2_.variation_type AS variation_type_89, a2_.future_presentation_months AS future_presentation_months_90, a0_.accreditation_investigation_l3_id AS accreditation_investigation_l3_id_91, a0_.accreditation_requirement_id AS accreditation_requirement_id_92, a0_.document_id AS document_id_93, d1_.requirement_document_type_id AS requirement_document_type_id_94, d1_.previous_document_id AS previous_document_id_95, d1_.accreditation_application_id AS accreditation_application_id_96, d1_.variation_request_id AS variation_request_id_97, d1_.maintenance_request_id AS maintenance_request_id_98, d1_.metadata_relation_id AS metadata_relation_id_99, d1_.accreditation_office_id AS accreditation_office_id_100 FROM accreditation_document_review_l3 a0_ INNER JOIN accreditation_investigation_l3 a3_ ON a0_.accreditation_investigation_l3_id = a3_.id INNER JOIN documents d1_ ON a0_.document_id = d1_.id INNER JOIN accreditation_requirement a2_ ON a0_.accreditation_requirement_id = a2_.id WHERE a3_.accreditation_application_id IN (?) AND a0_.status = ? AND d1_.active = ? ORDER BY a0_.created_at DESC

Parameters:

[
  1
  "APPROVED"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.meta_type AS meta_type_1,
  a0_.tab AS tab_2,
  a0_.status AS status_3,
  a0_.nota AS nota_4,
  a0_.has_expiration_date AS has_expiration_date_5,
  a0_.expiration_date AS expiration_date_6,
  a0_.reviewed_at AS reviewed_at_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.additional_data AS additional_data_10,
  d1_.entity AS entity_11,
  d1_.entity_id AS entity_id_12,
  d1_.file_name AS file_name_13,
  d1_.description AS description_14,
  d1_.valid_to AS valid_to_15,
  d1_.sac_id AS sac_id_16,
  d1_.sac_path AS sac_path_17,
  d1_.hash AS hash_18,
  d1_.is_old_file AS is_old_file_19,
  d1_.old_doc_json AS old_doc_json_20,
  d1_.id AS id_21,
  d1_.active AS active_22,
  d1_.created_at AS created_at_23,
  d1_.updated_at AS updated_at_24,
  d1_.deleted_at AS deleted_at_25,
  a2_.id AS id_26,
  a2_.tabella AS tabella_27,
  a2_.requisito AS requisito_28,
  a2_.universita_statali AS universita_statali_29,
  a2_.scuole_statali AS scuole_statali_30,
  a2_.scuole_paritarie AS scuole_paritarie_31,
  a2_.soggetti_privati AS soggetti_privati_32,
  a2_.centri_formazione_pubblici AS centri_formazione_pubblici_33,
  a2_.soggetti_legislativi AS soggetti_legislativi_34,
  a2_.comuni_metropolitane AS comuni_metropolitane_35,
  a2_.centri_regionali_provinciali AS centri_regionali_provinciali_36,
  a2_.enti_pubblici55 AS enti_pubblici55_37,
  a2_.accreditati_anorma_dgr AS accreditati_anorma_dgr_38,
  a2_.centri_impiego AS centri_impiego_39,
  a2_.altri_soggetti_a AS altri_soggetti_a_40,
  a2_.altri_soggetti_g AS altri_soggetti_g_41,
  a2_.altri_soggetti_h AS altri_soggetti_h_42,
  a2_.altri_soggetti_i AS altri_soggetti_i_43,
  a2_.altri_soggetti_m AS altri_soggetti_m_44,
  a2_.altri_soggetti_f AS altri_soggetti_f_45,
  a2_.altri_soggetti_cciaa AS altri_soggetti_cciaa_46,
  a2_.accreditati_di_diritto_c AS accreditati_di_diritto_c_47,
  a2_.accreditati_di_diritto_d AS accreditati_di_diritto_d_48,
  a2_.accreditati_di_diritto_e AS accreditati_di_diritto_e_49,
  a2_.accreditati_di_diritto_j AS accreditati_di_diritto_j_50,
  a2_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_51,
  a2_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_52,
  a2_.tipologia_accreditamento AS tipologia_accreditamento_53,
  a2_.type AS type_54,
  a2_.codice_sac AS codice_sac_55,
  a2_.autodichiarazione AS autodichiarazione_56,
  a2_.metadati AS metadati_57,
  a2_.documenti_allegati AS documenti_allegati_58,
  a2_.scadenza_documenti AS scadenza_documenti_59,
  a2_.attivita_controllo AS attivita_controllo_60,
  a2_.tipologia_istruttoria AS tipologia_istruttoria_61,
  a2_.tempi_verifica AS tempi_verifica_62,
  a2_.note AS note_63,
  a2_.is_active AS is_active_64,
  a2_.data_inizio_validita AS data_inizio_validita_65,
  a2_.data_fine_validita AS data_fine_validita_66,
  a2_.primo_accreditamento AS primo_accreditamento_67,
  a2_.mantenimento AS mantenimento_68,
  a2_.variazione AS variazione_69,
  a2_.sede_temporanea AS sede_temporanea_70,
  a2_.sportello_temporaneo AS sportello_temporaneo_71,
  a2_.isRequestedForRenewal AS isRequestedForRenewal_72,
  a2_.accreditamento_autorizzato AS accreditamento_autorizzato_73,
  a2_.its AS its_74,
  a2_.diritto_dovere AS diritto_dovere_75,
  a2_.post_diritto_dovere AS post_diritto_dovere_76,
  a2_.formazione_continua AS formazione_continua_77,
  a2_.utenze_speciali AS utenze_speciali_78,
  a2_.accreditamento_finanziato AS accreditamento_finanziato_79,
  a2_.tipo_accreditamento AS tipo_accreditamento_80,
  a2_.sort_index AS sort_index_81,
  a2_.next_level_accreditation AS next_level_accreditation_82,
  a2_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_83,
  a2_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_84,
  a2_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_85,
  a2_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_86,
  a2_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_87,
  a2_.sequence_to_pdf_show AS sequence_to_pdf_show_88,
  a2_.variation_type AS variation_type_89,
  a2_.future_presentation_months AS future_presentation_months_90,
  a0_.accreditation_investigation_l3_id AS accreditation_investigation_l3_id_91,
  a0_.accreditation_requirement_id AS accreditation_requirement_id_92,
  a0_.document_id AS document_id_93,
  d1_.requirement_document_type_id AS requirement_document_type_id_94,
  d1_.previous_document_id AS previous_document_id_95,
  d1_.accreditation_application_id AS accreditation_application_id_96,
  d1_.variation_request_id AS variation_request_id_97,
  d1_.maintenance_request_id AS maintenance_request_id_98,
  d1_.metadata_relation_id AS metadata_relation_id_99,
  d1_.accreditation_office_id AS accreditation_office_id_100
FROM
  accreditation_document_review_l3 a0_
  INNER JOIN accreditation_investigation_l3 a3_ ON a0_.accreditation_investigation_l3_id = a3_.id
  INNER JOIN documents d1_ ON a0_.document_id = d1_.id
  INNER JOIN accreditation_requirement a2_ ON a0_.accreditation_requirement_id = a2_.id
WHERE
  a3_.accreditation_application_id IN (?)
  AND a0_.status = ?
  AND d1_.active = ?
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.meta_type AS meta_type_1, a0_.tab AS tab_2, a0_.status AS status_3, a0_.nota AS nota_4, a0_.has_expiration_date AS has_expiration_date_5, a0_.expiration_date AS expiration_date_6, a0_.reviewed_at AS reviewed_at_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.additional_data AS additional_data_10, d1_.entity AS entity_11, d1_.entity_id AS entity_id_12, d1_.file_name AS file_name_13, d1_.description AS description_14, d1_.valid_to AS valid_to_15, d1_.sac_id AS sac_id_16, d1_.sac_path AS sac_path_17, d1_.hash AS hash_18, d1_.is_old_file AS is_old_file_19, d1_.old_doc_json AS old_doc_json_20, d1_.id AS id_21, d1_.active AS active_22, d1_.created_at AS created_at_23, d1_.updated_at AS updated_at_24, d1_.deleted_at AS deleted_at_25, a2_.id AS id_26, a2_.tabella AS tabella_27, a2_.requisito AS requisito_28, a2_.universita_statali AS universita_statali_29, a2_.scuole_statali AS scuole_statali_30, a2_.scuole_paritarie AS scuole_paritarie_31, a2_.soggetti_privati AS soggetti_privati_32, a2_.centri_formazione_pubblici AS centri_formazione_pubblici_33, a2_.soggetti_legislativi AS soggetti_legislativi_34, a2_.comuni_metropolitane AS comuni_metropolitane_35, a2_.centri_regionali_provinciali AS centri_regionali_provinciali_36, a2_.enti_pubblici55 AS enti_pubblici55_37, a2_.accreditati_anorma_dgr AS accreditati_anorma_dgr_38, a2_.centri_impiego AS centri_impiego_39, a2_.altri_soggetti_a AS altri_soggetti_a_40, a2_.altri_soggetti_g AS altri_soggetti_g_41, a2_.altri_soggetti_h AS altri_soggetti_h_42, a2_.altri_soggetti_i AS altri_soggetti_i_43, a2_.altri_soggetti_m AS altri_soggetti_m_44, a2_.altri_soggetti_f AS altri_soggetti_f_45, a2_.altri_soggetti_cciaa AS altri_soggetti_cciaa_46, a2_.accreditati_di_diritto_c AS accreditati_di_diritto_c_47, a2_.accreditati_di_diritto_d AS accreditati_di_diritto_d_48, a2_.accreditati_di_diritto_e AS accreditati_di_diritto_e_49, a2_.accreditati_di_diritto_j AS accreditati_di_diritto_j_50, a2_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_51, a2_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_52, a2_.tipologia_accreditamento AS tipologia_accreditamento_53, a2_.type AS type_54, a2_.codice_sac AS codice_sac_55, a2_.autodichiarazione AS autodichiarazione_56, a2_.metadati AS metadati_57, a2_.documenti_allegati AS documenti_allegati_58, a2_.scadenza_documenti AS scadenza_documenti_59, a2_.attivita_controllo AS attivita_controllo_60, a2_.tipologia_istruttoria AS tipologia_istruttoria_61, a2_.tempi_verifica AS tempi_verifica_62, a2_.note AS note_63, a2_.is_active AS is_active_64, a2_.data_inizio_validita AS data_inizio_validita_65, a2_.data_fine_validita AS data_fine_validita_66, a2_.primo_accreditamento AS primo_accreditamento_67, a2_.mantenimento AS mantenimento_68, a2_.variazione AS variazione_69, a2_.sede_temporanea AS sede_temporanea_70, a2_.sportello_temporaneo AS sportello_temporaneo_71, a2_.isRequestedForRenewal AS isRequestedForRenewal_72, a2_.accreditamento_autorizzato AS accreditamento_autorizzato_73, a2_.its AS its_74, a2_.diritto_dovere AS diritto_dovere_75, a2_.post_diritto_dovere AS post_diritto_dovere_76, a2_.formazione_continua AS formazione_continua_77, a2_.utenze_speciali AS utenze_speciali_78, a2_.accreditamento_finanziato AS accreditamento_finanziato_79, a2_.tipo_accreditamento AS tipo_accreditamento_80, a2_.sort_index AS sort_index_81, a2_.next_level_accreditation AS next_level_accreditation_82, a2_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_83, a2_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_84, a2_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_85, a2_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_86, a2_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_87, a2_.sequence_to_pdf_show AS sequence_to_pdf_show_88, a2_.variation_type AS variation_type_89, a2_.future_presentation_months AS future_presentation_months_90, a0_.accreditation_investigation_l3_id AS accreditation_investigation_l3_id_91, a0_.accreditation_requirement_id AS accreditation_requirement_id_92, a0_.document_id AS document_id_93, d1_.requirement_document_type_id AS requirement_document_type_id_94, d1_.previous_document_id AS previous_document_id_95, d1_.accreditation_application_id AS accreditation_application_id_96, d1_.variation_request_id AS variation_request_id_97, d1_.maintenance_request_id AS maintenance_request_id_98, d1_.metadata_relation_id AS metadata_relation_id_99, d1_.accreditation_office_id AS accreditation_office_id_100 FROM accreditation_document_review_l3 a0_ INNER JOIN accreditation_investigation_l3 a3_ ON a0_.accreditation_investigation_l3_id = a3_.id INNER JOIN documents d1_ ON a0_.document_id = d1_.id INNER JOIN accreditation_requirement a2_ ON a0_.accreditation_requirement_id = a2_.id WHERE a3_.accreditation_application_id IN (1) AND a0_.status = 'APPROVED' AND d1_.active = 1 ORDER BY a0_.created_at DESC;

#	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\DocumentiInVigenzaService->findAccreditationDocumentsForApp (line 188)
9	App\Service\DocumentiInVigenzaService->buildItemsForApplication (line 223)
10	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerInstitution (line 106)
11	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerLegalOwner (line 74)
12	App\Controller\LandingPageController->home (line 136)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

28.96 ms
(2.77%)

SELECT i0_.type AS type_0, i0_.tab AS tab_1, i0_.meta_data_key AS meta_data_key_2, i0_.is_valid AS is_valid_3, i0_.meta_data_value AS meta_data_value_4, i0_.data_type AS data_type_5, i0_.is_old_data AS is_old_data_6, i0_.id AS id_7, i0_.active AS active_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.deleted_at AS deleted_at_11, a1_.id AS id_12, a1_.tabella AS tabella_13, a1_.requisito AS requisito_14, a1_.universita_statali AS universita_statali_15, a1_.scuole_statali AS scuole_statali_16, a1_.scuole_paritarie AS scuole_paritarie_17, a1_.soggetti_privati AS soggetti_privati_18, a1_.centri_formazione_pubblici AS centri_formazione_pubblici_19, a1_.soggetti_legislativi AS soggetti_legislativi_20, a1_.comuni_metropolitane AS comuni_metropolitane_21, a1_.centri_regionali_provinciali AS centri_regionali_provinciali_22, a1_.enti_pubblici55 AS enti_pubblici55_23, a1_.accreditati_anorma_dgr AS accreditati_anorma_dgr_24, a1_.centri_impiego AS centri_impiego_25, a1_.altri_soggetti_a AS altri_soggetti_a_26, a1_.altri_soggetti_g AS altri_soggetti_g_27, a1_.altri_soggetti_h AS altri_soggetti_h_28, a1_.altri_soggetti_i AS altri_soggetti_i_29, a1_.altri_soggetti_m AS altri_soggetti_m_30, a1_.altri_soggetti_f AS altri_soggetti_f_31, a1_.altri_soggetti_cciaa AS altri_soggetti_cciaa_32, a1_.accreditati_di_diritto_c AS accreditati_di_diritto_c_33, a1_.accreditati_di_diritto_d AS accreditati_di_diritto_d_34, a1_.accreditati_di_diritto_e AS accreditati_di_diritto_e_35, a1_.accreditati_di_diritto_j AS accreditati_di_diritto_j_36, a1_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_37, a1_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_38, a1_.tipologia_accreditamento AS tipologia_accreditamento_39, a1_.type AS type_40, a1_.codice_sac AS codice_sac_41, a1_.autodichiarazione AS autodichiarazione_42, a1_.metadati AS metadati_43, a1_.documenti_allegati AS documenti_allegati_44, a1_.scadenza_documenti AS scadenza_documenti_45, a1_.attivita_controllo AS attivita_controllo_46, a1_.tipologia_istruttoria AS tipologia_istruttoria_47, a1_.tempi_verifica AS tempi_verifica_48, a1_.note AS note_49, a1_.is_active AS is_active_50, a1_.data_inizio_validita AS data_inizio_validita_51, a1_.data_fine_validita AS data_fine_validita_52, a1_.primo_accreditamento AS primo_accreditamento_53, a1_.mantenimento AS mantenimento_54, a1_.variazione AS variazione_55, a1_.sede_temporanea AS sede_temporanea_56, a1_.sportello_temporaneo AS sportello_temporaneo_57, a1_.isRequestedForRenewal AS isRequestedForRenewal_58, a1_.accreditamento_autorizzato AS accreditamento_autorizzato_59, a1_.its AS its_60, a1_.diritto_dovere AS diritto_dovere_61, a1_.post_diritto_dovere AS post_diritto_dovere_62, a1_.formazione_continua AS formazione_continua_63, a1_.utenze_speciali AS utenze_speciali_64, a1_.accreditamento_finanziato AS accreditamento_finanziato_65, a1_.tipo_accreditamento AS tipo_accreditamento_66, a1_.sort_index AS sort_index_67, a1_.next_level_accreditation AS next_level_accreditation_68, a1_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_69, a1_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_70, a1_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_71, a1_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_72, a1_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_73, a1_.sequence_to_pdf_show AS sequence_to_pdf_show_74, a1_.variation_type AS variation_type_75, a1_.future_presentation_months AS future_presentation_months_76, i0_.accreditation_application_id AS accreditation_application_id_77, i0_.accreditation_requirement_id AS accreditation_requirement_id_78, i0_.requirement_metadata_field_id AS requirement_metadata_field_id_79 FROM institutions_accreditation_tabs i0_ INNER JOIN accreditation_requirement a1_ ON i0_.accreditation_requirement_id = a1_.id WHERE i0_.accreditation_application_id IN (?) AND i0_.is_old_data = ? ORDER BY i0_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.type AS type_0,
  i0_.tab AS tab_1,
  i0_.meta_data_key AS meta_data_key_2,
  i0_.is_valid AS is_valid_3,
  i0_.meta_data_value AS meta_data_value_4,
  i0_.data_type AS data_type_5,
  i0_.is_old_data AS is_old_data_6,
  i0_.id AS id_7,
  i0_.active AS active_8,
  i0_.created_at AS created_at_9,
  i0_.updated_at AS updated_at_10,
  i0_.deleted_at AS deleted_at_11,
  a1_.id AS id_12,
  a1_.tabella AS tabella_13,
  a1_.requisito AS requisito_14,
  a1_.universita_statali AS universita_statali_15,
  a1_.scuole_statali AS scuole_statali_16,
  a1_.scuole_paritarie AS scuole_paritarie_17,
  a1_.soggetti_privati AS soggetti_privati_18,
  a1_.centri_formazione_pubblici AS centri_formazione_pubblici_19,
  a1_.soggetti_legislativi AS soggetti_legislativi_20,
  a1_.comuni_metropolitane AS comuni_metropolitane_21,
  a1_.centri_regionali_provinciali AS centri_regionali_provinciali_22,
  a1_.enti_pubblici55 AS enti_pubblici55_23,
  a1_.accreditati_anorma_dgr AS accreditati_anorma_dgr_24,
  a1_.centri_impiego AS centri_impiego_25,
  a1_.altri_soggetti_a AS altri_soggetti_a_26,
  a1_.altri_soggetti_g AS altri_soggetti_g_27,
  a1_.altri_soggetti_h AS altri_soggetti_h_28,
  a1_.altri_soggetti_i AS altri_soggetti_i_29,
  a1_.altri_soggetti_m AS altri_soggetti_m_30,
  a1_.altri_soggetti_f AS altri_soggetti_f_31,
  a1_.altri_soggetti_cciaa AS altri_soggetti_cciaa_32,
  a1_.accreditati_di_diritto_c AS accreditati_di_diritto_c_33,
  a1_.accreditati_di_diritto_d AS accreditati_di_diritto_d_34,
  a1_.accreditati_di_diritto_e AS accreditati_di_diritto_e_35,
  a1_.accreditati_di_diritto_j AS accreditati_di_diritto_j_36,
  a1_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_37,
  a1_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_38,
  a1_.tipologia_accreditamento AS tipologia_accreditamento_39,
  a1_.type AS type_40,
  a1_.codice_sac AS codice_sac_41,
  a1_.autodichiarazione AS autodichiarazione_42,
  a1_.metadati AS metadati_43,
  a1_.documenti_allegati AS documenti_allegati_44,
  a1_.scadenza_documenti AS scadenza_documenti_45,
  a1_.attivita_controllo AS attivita_controllo_46,
  a1_.tipologia_istruttoria AS tipologia_istruttoria_47,
  a1_.tempi_verifica AS tempi_verifica_48,
  a1_.note AS note_49,
  a1_.is_active AS is_active_50,
  a1_.data_inizio_validita AS data_inizio_validita_51,
  a1_.data_fine_validita AS data_fine_validita_52,
  a1_.primo_accreditamento AS primo_accreditamento_53,
  a1_.mantenimento AS mantenimento_54,
  a1_.variazione AS variazione_55,
  a1_.sede_temporanea AS sede_temporanea_56,
  a1_.sportello_temporaneo AS sportello_temporaneo_57,
  a1_.isRequestedForRenewal AS isRequestedForRenewal_58,
  a1_.accreditamento_autorizzato AS accreditamento_autorizzato_59,
  a1_.its AS its_60,
  a1_.diritto_dovere AS diritto_dovere_61,
  a1_.post_diritto_dovere AS post_diritto_dovere_62,
  a1_.formazione_continua AS formazione_continua_63,
  a1_.utenze_speciali AS utenze_speciali_64,
  a1_.accreditamento_finanziato AS accreditamento_finanziato_65,
  a1_.tipo_accreditamento AS tipo_accreditamento_66,
  a1_.sort_index AS sort_index_67,
  a1_.next_level_accreditation AS next_level_accreditation_68,
  a1_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_69,
  a1_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_70,
  a1_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_71,
  a1_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_72,
  a1_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_73,
  a1_.sequence_to_pdf_show AS sequence_to_pdf_show_74,
  a1_.variation_type AS variation_type_75,
  a1_.future_presentation_months AS future_presentation_months_76,
  i0_.accreditation_application_id AS accreditation_application_id_77,
  i0_.accreditation_requirement_id AS accreditation_requirement_id_78,
  i0_.requirement_metadata_field_id AS requirement_metadata_field_id_79
FROM
  institutions_accreditation_tabs i0_
  INNER JOIN accreditation_requirement a1_ ON i0_.accreditation_requirement_id = a1_.id
WHERE
  i0_.accreditation_application_id IN (?)
  AND i0_.is_old_data = ?
ORDER BY
  i0_.id ASC

SELECT i0_.type AS type_0, i0_.tab AS tab_1, i0_.meta_data_key AS meta_data_key_2, i0_.is_valid AS is_valid_3, i0_.meta_data_value AS meta_data_value_4, i0_.data_type AS data_type_5, i0_.is_old_data AS is_old_data_6, i0_.id AS id_7, i0_.active AS active_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.deleted_at AS deleted_at_11, a1_.id AS id_12, a1_.tabella AS tabella_13, a1_.requisito AS requisito_14, a1_.universita_statali AS universita_statali_15, a1_.scuole_statali AS scuole_statali_16, a1_.scuole_paritarie AS scuole_paritarie_17, a1_.soggetti_privati AS soggetti_privati_18, a1_.centri_formazione_pubblici AS centri_formazione_pubblici_19, a1_.soggetti_legislativi AS soggetti_legislativi_20, a1_.comuni_metropolitane AS comuni_metropolitane_21, a1_.centri_regionali_provinciali AS centri_regionali_provinciali_22, a1_.enti_pubblici55 AS enti_pubblici55_23, a1_.accreditati_anorma_dgr AS accreditati_anorma_dgr_24, a1_.centri_impiego AS centri_impiego_25, a1_.altri_soggetti_a AS altri_soggetti_a_26, a1_.altri_soggetti_g AS altri_soggetti_g_27, a1_.altri_soggetti_h AS altri_soggetti_h_28, a1_.altri_soggetti_i AS altri_soggetti_i_29, a1_.altri_soggetti_m AS altri_soggetti_m_30, a1_.altri_soggetti_f AS altri_soggetti_f_31, a1_.altri_soggetti_cciaa AS altri_soggetti_cciaa_32, a1_.accreditati_di_diritto_c AS accreditati_di_diritto_c_33, a1_.accreditati_di_diritto_d AS accreditati_di_diritto_d_34, a1_.accreditati_di_diritto_e AS accreditati_di_diritto_e_35, a1_.accreditati_di_diritto_j AS accreditati_di_diritto_j_36, a1_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_37, a1_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_38, a1_.tipologia_accreditamento AS tipologia_accreditamento_39, a1_.type AS type_40, a1_.codice_sac AS codice_sac_41, a1_.autodichiarazione AS autodichiarazione_42, a1_.metadati AS metadati_43, a1_.documenti_allegati AS documenti_allegati_44, a1_.scadenza_documenti AS scadenza_documenti_45, a1_.attivita_controllo AS attivita_controllo_46, a1_.tipologia_istruttoria AS tipologia_istruttoria_47, a1_.tempi_verifica AS tempi_verifica_48, a1_.note AS note_49, a1_.is_active AS is_active_50, a1_.data_inizio_validita AS data_inizio_validita_51, a1_.data_fine_validita AS data_fine_validita_52, a1_.primo_accreditamento AS primo_accreditamento_53, a1_.mantenimento AS mantenimento_54, a1_.variazione AS variazione_55, a1_.sede_temporanea AS sede_temporanea_56, a1_.sportello_temporaneo AS sportello_temporaneo_57, a1_.isRequestedForRenewal AS isRequestedForRenewal_58, a1_.accreditamento_autorizzato AS accreditamento_autorizzato_59, a1_.its AS its_60, a1_.diritto_dovere AS diritto_dovere_61, a1_.post_diritto_dovere AS post_diritto_dovere_62, a1_.formazione_continua AS formazione_continua_63, a1_.utenze_speciali AS utenze_speciali_64, a1_.accreditamento_finanziato AS accreditamento_finanziato_65, a1_.tipo_accreditamento AS tipo_accreditamento_66, a1_.sort_index AS sort_index_67, a1_.next_level_accreditation AS next_level_accreditation_68, a1_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_69, a1_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_70, a1_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_71, a1_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_72, a1_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_73, a1_.sequence_to_pdf_show AS sequence_to_pdf_show_74, a1_.variation_type AS variation_type_75, a1_.future_presentation_months AS future_presentation_months_76, i0_.accreditation_application_id AS accreditation_application_id_77, i0_.accreditation_requirement_id AS accreditation_requirement_id_78, i0_.requirement_metadata_field_id AS requirement_metadata_field_id_79 FROM institutions_accreditation_tabs i0_ INNER JOIN accreditation_requirement a1_ ON i0_.accreditation_requirement_id = a1_.id WHERE i0_.accreditation_application_id IN (1) AND i0_.is_old_data = 0 ORDER BY i0_.id 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\DocumentiInVigenzaService->fetchMetadataByRequirementForApp (line 479)
9	App\Service\DocumentiInVigenzaService->buildItemsForApplication (line 220)
10	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerInstitution (line 106)
11	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerLegalOwner (line 74)
12	App\Controller\LandingPageController->home (line 136)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

12.27 ms
(1.17%)

SELECT t0.name AS name_1, t0.tax_code AS tax_code_2, t0.fiscal_code AS fiscal_code_3, t0.pec_address AS pec_address_4, t0.email_address AS email_address_5, t0.telephone AS telephone_6, t0.telephone_mobile AS telephone_mobile_7, t0.operating AS operating_8, t0.status AS status_9, t0.id AS id_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.legal_form_id AS legal_form_id_15, t0.institution_size_id AS institution_size_id_16, t0.ateco_code_version_id AS ateco_code_version_id_17, t0.legal_owner_id AS legal_owner_id_18 FROM institutions t0 WHERE t0.legal_owner_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.tax_code AS tax_code_2,
  t0.fiscal_code AS fiscal_code_3,
  t0.pec_address AS pec_address_4,
  t0.email_address AS email_address_5,
  t0.telephone AS telephone_6,
  t0.telephone_mobile AS telephone_mobile_7,
  t0.operating AS operating_8,
  t0.status AS status_9,
  t0.id AS id_10,
  t0.active AS active_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.legal_form_id AS legal_form_id_15,
  t0.institution_size_id AS institution_size_id_16,
  t0.ateco_code_version_id AS ateco_code_version_id_17,
  t0.legal_owner_id AS legal_owner_id_18
FROM
  institutions t0
WHERE
  t0.legal_owner_id = ?

SELECT t0.name AS name_1, t0.tax_code AS tax_code_2, t0.fiscal_code AS fiscal_code_3, t0.pec_address AS pec_address_4, t0.email_address AS email_address_5, t0.telephone AS telephone_6, t0.telephone_mobile AS telephone_mobile_7, t0.operating AS operating_8, t0.status AS status_9, t0.id AS id_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.legal_form_id AS legal_form_id_15, t0.institution_size_id AS institution_size_id_16, t0.ateco_code_version_id AS ateco_code_version_id_17, t0.legal_owner_id AS legal_owner_id_18 FROM institutions t0 WHERE t0.legal_owner_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->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 313)
9	App\EventListener\InstitutionBlockedListener->getOperatingInstitution (line 237)
10	App\EventListener\InstitutionBlockedListener->__invoke (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

8.51 ms
(0.81%)

SELECT v0_.id AS id_0, v0_.meta_type AS meta_type_1, v0_.tab AS tab_2, v0_.status AS status_3, v0_.nota AS nota_4, v0_.has_expiration_date AS has_expiration_date_5, v0_.expiration_date AS expiration_date_6, v0_.reviewed_at AS reviewed_at_7, v0_.created_at AS created_at_8, v0_.updated_at AS updated_at_9, v0_.additional_data AS additional_data_10, d1_.entity AS entity_11, d1_.entity_id AS entity_id_12, d1_.file_name AS file_name_13, d1_.description AS description_14, d1_.valid_to AS valid_to_15, d1_.sac_id AS sac_id_16, d1_.sac_path AS sac_path_17, d1_.hash AS hash_18, d1_.is_old_file AS is_old_file_19, d1_.old_doc_json AS old_doc_json_20, d1_.id AS id_21, d1_.active AS active_22, d1_.created_at AS created_at_23, d1_.updated_at AS updated_at_24, d1_.deleted_at AS deleted_at_25, a2_.id AS id_26, a2_.tabella AS tabella_27, a2_.requisito AS requisito_28, a2_.universita_statali AS universita_statali_29, a2_.scuole_statali AS scuole_statali_30, a2_.scuole_paritarie AS scuole_paritarie_31, a2_.soggetti_privati AS soggetti_privati_32, a2_.centri_formazione_pubblici AS centri_formazione_pubblici_33, a2_.soggetti_legislativi AS soggetti_legislativi_34, a2_.comuni_metropolitane AS comuni_metropolitane_35, a2_.centri_regionali_provinciali AS centri_regionali_provinciali_36, a2_.enti_pubblici55 AS enti_pubblici55_37, a2_.accreditati_anorma_dgr AS accreditati_anorma_dgr_38, a2_.centri_impiego AS centri_impiego_39, a2_.altri_soggetti_a AS altri_soggetti_a_40, a2_.altri_soggetti_g AS altri_soggetti_g_41, a2_.altri_soggetti_h AS altri_soggetti_h_42, a2_.altri_soggetti_i AS altri_soggetti_i_43, a2_.altri_soggetti_m AS altri_soggetti_m_44, a2_.altri_soggetti_f AS altri_soggetti_f_45, a2_.altri_soggetti_cciaa AS altri_soggetti_cciaa_46, a2_.accreditati_di_diritto_c AS accreditati_di_diritto_c_47, a2_.accreditati_di_diritto_d AS accreditati_di_diritto_d_48, a2_.accreditati_di_diritto_e AS accreditati_di_diritto_e_49, a2_.accreditati_di_diritto_j AS accreditati_di_diritto_j_50, a2_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_51, a2_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_52, a2_.tipologia_accreditamento AS tipologia_accreditamento_53, a2_.type AS type_54, a2_.codice_sac AS codice_sac_55, a2_.autodichiarazione AS autodichiarazione_56, a2_.metadati AS metadati_57, a2_.documenti_allegati AS documenti_allegati_58, a2_.scadenza_documenti AS scadenza_documenti_59, a2_.attivita_controllo AS attivita_controllo_60, a2_.tipologia_istruttoria AS tipologia_istruttoria_61, a2_.tempi_verifica AS tempi_verifica_62, a2_.note AS note_63, a2_.is_active AS is_active_64, a2_.data_inizio_validita AS data_inizio_validita_65, a2_.data_fine_validita AS data_fine_validita_66, a2_.primo_accreditamento AS primo_accreditamento_67, a2_.mantenimento AS mantenimento_68, a2_.variazione AS variazione_69, a2_.sede_temporanea AS sede_temporanea_70, a2_.sportello_temporaneo AS sportello_temporaneo_71, a2_.isRequestedForRenewal AS isRequestedForRenewal_72, a2_.accreditamento_autorizzato AS accreditamento_autorizzato_73, a2_.its AS its_74, a2_.diritto_dovere AS diritto_dovere_75, a2_.post_diritto_dovere AS post_diritto_dovere_76, a2_.formazione_continua AS formazione_continua_77, a2_.utenze_speciali AS utenze_speciali_78, a2_.accreditamento_finanziato AS accreditamento_finanziato_79, a2_.tipo_accreditamento AS tipo_accreditamento_80, a2_.sort_index AS sort_index_81, a2_.next_level_accreditation AS next_level_accreditation_82, a2_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_83, a2_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_84, a2_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_85, a2_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_86, a2_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_87, a2_.sequence_to_pdf_show AS sequence_to_pdf_show_88, a2_.variation_type AS variation_type_89, a2_.future_presentation_months AS future_presentation_months_90, v0_.variation_investigation_l3_id AS variation_investigation_l3_id_91, v0_.accreditation_requirement_id AS accreditation_requirement_id_92, v0_.document_id AS document_id_93, v0_.variation_requirement_document_id AS variation_requirement_document_id_94, d1_.requirement_document_type_id AS requirement_document_type_id_95, d1_.previous_document_id AS previous_document_id_96, d1_.accreditation_application_id AS accreditation_application_id_97, d1_.variation_request_id AS variation_request_id_98, d1_.maintenance_request_id AS maintenance_request_id_99, d1_.metadata_relation_id AS metadata_relation_id_100, d1_.accreditation_office_id AS accreditation_office_id_101 FROM variation_document_review_l3 v0_ INNER JOIN variation_investigation_l3 v3_ ON v0_.variation_investigation_l3_id = v3_.id INNER JOIN variation_request v4_ ON v3_.variation_request_id = v4_.id INNER JOIN documents d1_ ON v0_.document_id = d1_.id INNER JOIN accreditation_requirement a2_ ON v0_.accreditation_requirement_id = a2_.id WHERE v4_.institution_id = ? AND v4_.area = ? AND v4_.status = ? AND v0_.status = ? AND d1_.active = ? ORDER BY v0_.created_at DESC

Parameters:

[
  2
  "Formazione"
  "DETERMINA_COMPLETATA"
  "APPROVED"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.meta_type AS meta_type_1,
  v0_.tab AS tab_2,
  v0_.status AS status_3,
  v0_.nota AS nota_4,
  v0_.has_expiration_date AS has_expiration_date_5,
  v0_.expiration_date AS expiration_date_6,
  v0_.reviewed_at AS reviewed_at_7,
  v0_.created_at AS created_at_8,
  v0_.updated_at AS updated_at_9,
  v0_.additional_data AS additional_data_10,
  d1_.entity AS entity_11,
  d1_.entity_id AS entity_id_12,
  d1_.file_name AS file_name_13,
  d1_.description AS description_14,
  d1_.valid_to AS valid_to_15,
  d1_.sac_id AS sac_id_16,
  d1_.sac_path AS sac_path_17,
  d1_.hash AS hash_18,
  d1_.is_old_file AS is_old_file_19,
  d1_.old_doc_json AS old_doc_json_20,
  d1_.id AS id_21,
  d1_.active AS active_22,
  d1_.created_at AS created_at_23,
  d1_.updated_at AS updated_at_24,
  d1_.deleted_at AS deleted_at_25,
  a2_.id AS id_26,
  a2_.tabella AS tabella_27,
  a2_.requisito AS requisito_28,
  a2_.universita_statali AS universita_statali_29,
  a2_.scuole_statali AS scuole_statali_30,
  a2_.scuole_paritarie AS scuole_paritarie_31,
  a2_.soggetti_privati AS soggetti_privati_32,
  a2_.centri_formazione_pubblici AS centri_formazione_pubblici_33,
  a2_.soggetti_legislativi AS soggetti_legislativi_34,
  a2_.comuni_metropolitane AS comuni_metropolitane_35,
  a2_.centri_regionali_provinciali AS centri_regionali_provinciali_36,
  a2_.enti_pubblici55 AS enti_pubblici55_37,
  a2_.accreditati_anorma_dgr AS accreditati_anorma_dgr_38,
  a2_.centri_impiego AS centri_impiego_39,
  a2_.altri_soggetti_a AS altri_soggetti_a_40,
  a2_.altri_soggetti_g AS altri_soggetti_g_41,
  a2_.altri_soggetti_h AS altri_soggetti_h_42,
  a2_.altri_soggetti_i AS altri_soggetti_i_43,
  a2_.altri_soggetti_m AS altri_soggetti_m_44,
  a2_.altri_soggetti_f AS altri_soggetti_f_45,
  a2_.altri_soggetti_cciaa AS altri_soggetti_cciaa_46,
  a2_.accreditati_di_diritto_c AS accreditati_di_diritto_c_47,
  a2_.accreditati_di_diritto_d AS accreditati_di_diritto_d_48,
  a2_.accreditati_di_diritto_e AS accreditati_di_diritto_e_49,
  a2_.accreditati_di_diritto_j AS accreditati_di_diritto_j_50,
  a2_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_51,
  a2_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_52,
  a2_.tipologia_accreditamento AS tipologia_accreditamento_53,
  a2_.type AS type_54,
  a2_.codice_sac AS codice_sac_55,
  a2_.autodichiarazione AS autodichiarazione_56,
  a2_.metadati AS metadati_57,
  a2_.documenti_allegati AS documenti_allegati_58,
  a2_.scadenza_documenti AS scadenza_documenti_59,
  a2_.attivita_controllo AS attivita_controllo_60,
  a2_.tipologia_istruttoria AS tipologia_istruttoria_61,
  a2_.tempi_verifica AS tempi_verifica_62,
  a2_.note AS note_63,
  a2_.is_active AS is_active_64,
  a2_.data_inizio_validita AS data_inizio_validita_65,
  a2_.data_fine_validita AS data_fine_validita_66,
  a2_.primo_accreditamento AS primo_accreditamento_67,
  a2_.mantenimento AS mantenimento_68,
  a2_.variazione AS variazione_69,
  a2_.sede_temporanea AS sede_temporanea_70,
  a2_.sportello_temporaneo AS sportello_temporaneo_71,
  a2_.isRequestedForRenewal AS isRequestedForRenewal_72,
  a2_.accreditamento_autorizzato AS accreditamento_autorizzato_73,
  a2_.its AS its_74,
  a2_.diritto_dovere AS diritto_dovere_75,
  a2_.post_diritto_dovere AS post_diritto_dovere_76,
  a2_.formazione_continua AS formazione_continua_77,
  a2_.utenze_speciali AS utenze_speciali_78,
  a2_.accreditamento_finanziato AS accreditamento_finanziato_79,
  a2_.tipo_accreditamento AS tipo_accreditamento_80,
  a2_.sort_index AS sort_index_81,
  a2_.next_level_accreditation AS next_level_accreditation_82,
  a2_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_83,
  a2_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_84,
  a2_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_85,
  a2_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_86,
  a2_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_87,
  a2_.sequence_to_pdf_show AS sequence_to_pdf_show_88,
  a2_.variation_type AS variation_type_89,
  a2_.future_presentation_months AS future_presentation_months_90,
  v0_.variation_investigation_l3_id AS variation_investigation_l3_id_91,
  v0_.accreditation_requirement_id AS accreditation_requirement_id_92,
  v0_.document_id AS document_id_93,
  v0_.variation_requirement_document_id AS variation_requirement_document_id_94,
  d1_.requirement_document_type_id AS requirement_document_type_id_95,
  d1_.previous_document_id AS previous_document_id_96,
  d1_.accreditation_application_id AS accreditation_application_id_97,
  d1_.variation_request_id AS variation_request_id_98,
  d1_.maintenance_request_id AS maintenance_request_id_99,
  d1_.metadata_relation_id AS metadata_relation_id_100,
  d1_.accreditation_office_id AS accreditation_office_id_101
FROM
  variation_document_review_l3 v0_
  INNER JOIN variation_investigation_l3 v3_ ON v0_.variation_investigation_l3_id = v3_.id
  INNER JOIN variation_request v4_ ON v3_.variation_request_id = v4_.id
  INNER JOIN documents d1_ ON v0_.document_id = d1_.id
  INNER JOIN accreditation_requirement a2_ ON v0_.accreditation_requirement_id = a2_.id
WHERE
  v4_.institution_id = ?
  AND v4_.area = ?
  AND v4_.status = ?
  AND v0_.status = ?
  AND d1_.active = ?
ORDER BY
  v0_.created_at DESC

SELECT v0_.id AS id_0, v0_.meta_type AS meta_type_1, v0_.tab AS tab_2, v0_.status AS status_3, v0_.nota AS nota_4, v0_.has_expiration_date AS has_expiration_date_5, v0_.expiration_date AS expiration_date_6, v0_.reviewed_at AS reviewed_at_7, v0_.created_at AS created_at_8, v0_.updated_at AS updated_at_9, v0_.additional_data AS additional_data_10, d1_.entity AS entity_11, d1_.entity_id AS entity_id_12, d1_.file_name AS file_name_13, d1_.description AS description_14, d1_.valid_to AS valid_to_15, d1_.sac_id AS sac_id_16, d1_.sac_path AS sac_path_17, d1_.hash AS hash_18, d1_.is_old_file AS is_old_file_19, d1_.old_doc_json AS old_doc_json_20, d1_.id AS id_21, d1_.active AS active_22, d1_.created_at AS created_at_23, d1_.updated_at AS updated_at_24, d1_.deleted_at AS deleted_at_25, a2_.id AS id_26, a2_.tabella AS tabella_27, a2_.requisito AS requisito_28, a2_.universita_statali AS universita_statali_29, a2_.scuole_statali AS scuole_statali_30, a2_.scuole_paritarie AS scuole_paritarie_31, a2_.soggetti_privati AS soggetti_privati_32, a2_.centri_formazione_pubblici AS centri_formazione_pubblici_33, a2_.soggetti_legislativi AS soggetti_legislativi_34, a2_.comuni_metropolitane AS comuni_metropolitane_35, a2_.centri_regionali_provinciali AS centri_regionali_provinciali_36, a2_.enti_pubblici55 AS enti_pubblici55_37, a2_.accreditati_anorma_dgr AS accreditati_anorma_dgr_38, a2_.centri_impiego AS centri_impiego_39, a2_.altri_soggetti_a AS altri_soggetti_a_40, a2_.altri_soggetti_g AS altri_soggetti_g_41, a2_.altri_soggetti_h AS altri_soggetti_h_42, a2_.altri_soggetti_i AS altri_soggetti_i_43, a2_.altri_soggetti_m AS altri_soggetti_m_44, a2_.altri_soggetti_f AS altri_soggetti_f_45, a2_.altri_soggetti_cciaa AS altri_soggetti_cciaa_46, a2_.accreditati_di_diritto_c AS accreditati_di_diritto_c_47, a2_.accreditati_di_diritto_d AS accreditati_di_diritto_d_48, a2_.accreditati_di_diritto_e AS accreditati_di_diritto_e_49, a2_.accreditati_di_diritto_j AS accreditati_di_diritto_j_50, a2_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_51, a2_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_52, a2_.tipologia_accreditamento AS tipologia_accreditamento_53, a2_.type AS type_54, a2_.codice_sac AS codice_sac_55, a2_.autodichiarazione AS autodichiarazione_56, a2_.metadati AS metadati_57, a2_.documenti_allegati AS documenti_allegati_58, a2_.scadenza_documenti AS scadenza_documenti_59, a2_.attivita_controllo AS attivita_controllo_60, a2_.tipologia_istruttoria AS tipologia_istruttoria_61, a2_.tempi_verifica AS tempi_verifica_62, a2_.note AS note_63, a2_.is_active AS is_active_64, a2_.data_inizio_validita AS data_inizio_validita_65, a2_.data_fine_validita AS data_fine_validita_66, a2_.primo_accreditamento AS primo_accreditamento_67, a2_.mantenimento AS mantenimento_68, a2_.variazione AS variazione_69, a2_.sede_temporanea AS sede_temporanea_70, a2_.sportello_temporaneo AS sportello_temporaneo_71, a2_.isRequestedForRenewal AS isRequestedForRenewal_72, a2_.accreditamento_autorizzato AS accreditamento_autorizzato_73, a2_.its AS its_74, a2_.diritto_dovere AS diritto_dovere_75, a2_.post_diritto_dovere AS post_diritto_dovere_76, a2_.formazione_continua AS formazione_continua_77, a2_.utenze_speciali AS utenze_speciali_78, a2_.accreditamento_finanziato AS accreditamento_finanziato_79, a2_.tipo_accreditamento AS tipo_accreditamento_80, a2_.sort_index AS sort_index_81, a2_.next_level_accreditation AS next_level_accreditation_82, a2_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_83, a2_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_84, a2_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_85, a2_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_86, a2_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_87, a2_.sequence_to_pdf_show AS sequence_to_pdf_show_88, a2_.variation_type AS variation_type_89, a2_.future_presentation_months AS future_presentation_months_90, v0_.variation_investigation_l3_id AS variation_investigation_l3_id_91, v0_.accreditation_requirement_id AS accreditation_requirement_id_92, v0_.document_id AS document_id_93, v0_.variation_requirement_document_id AS variation_requirement_document_id_94, d1_.requirement_document_type_id AS requirement_document_type_id_95, d1_.previous_document_id AS previous_document_id_96, d1_.accreditation_application_id AS accreditation_application_id_97, d1_.variation_request_id AS variation_request_id_98, d1_.maintenance_request_id AS maintenance_request_id_99, d1_.metadata_relation_id AS metadata_relation_id_100, d1_.accreditation_office_id AS accreditation_office_id_101 FROM variation_document_review_l3 v0_ INNER JOIN variation_investigation_l3 v3_ ON v0_.variation_investigation_l3_id = v3_.id INNER JOIN variation_request v4_ ON v3_.variation_request_id = v4_.id INNER JOIN documents d1_ ON v0_.document_id = d1_.id INNER JOIN accreditation_requirement a2_ ON v0_.accreditation_requirement_id = a2_.id WHERE v4_.institution_id = 2 AND v4_.area = 'Formazione' AND v4_.status = 'DETERMINA_COMPLETATA' AND v0_.status = 'APPROVED' AND d1_.active = 1 ORDER BY v0_.created_at DESC;

#	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\DocumentiInVigenzaService->findVariationDocumentsForAmbito (line 262)
9	App\Service\DocumentiInVigenzaService->buildItemsForApplication (line 224)
10	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerInstitution (line 106)
11	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerLegalOwner (line 74)
12	App\Controller\LandingPageController->home (line 136)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

7.89 ms
(0.75%)

SELECT m0_.id AS id_0, m0_.status AS status_1, m0_.nota AS nota_2, m0_.has_expiration_date AS has_expiration_date_3, m0_.expiration_date AS expiration_date_4, m0_.reviewed_at AS reviewed_at_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.additional_data AS additional_data_8, m0_.meta_type AS meta_type_9, m0_.tab AS tab_10, m1_.id AS id_11, m1_.original_expiration_date AS original_expiration_date_12, m1_.name AS name_13, m1_.original_name AS original_name_14, m1_.size AS size_15, m1_.mime_type AS mime_type_16, m1_.validated AS validated_17, m1_.review_notes AS review_notes_18, m1_.rejection_reason AS rejection_reason_19, m1_.is_old_file AS is_old_file_20, m1_.created_at AS created_at_21, m1_.updated_at AS updated_at_22, m1_.modified_during_integration AS modified_during_integration_23, m1_.integration_round AS integration_round_24, a2_.id AS id_25, a2_.tabella AS tabella_26, a2_.requisito AS requisito_27, a2_.universita_statali AS universita_statali_28, a2_.scuole_statali AS scuole_statali_29, a2_.scuole_paritarie AS scuole_paritarie_30, a2_.soggetti_privati AS soggetti_privati_31, a2_.centri_formazione_pubblici AS centri_formazione_pubblici_32, a2_.soggetti_legislativi AS soggetti_legislativi_33, a2_.comuni_metropolitane AS comuni_metropolitane_34, a2_.centri_regionali_provinciali AS centri_regionali_provinciali_35, a2_.enti_pubblici55 AS enti_pubblici55_36, a2_.accreditati_anorma_dgr AS accreditati_anorma_dgr_37, a2_.centri_impiego AS centri_impiego_38, a2_.altri_soggetti_a AS altri_soggetti_a_39, a2_.altri_soggetti_g AS altri_soggetti_g_40, a2_.altri_soggetti_h AS altri_soggetti_h_41, a2_.altri_soggetti_i AS altri_soggetti_i_42, a2_.altri_soggetti_m AS altri_soggetti_m_43, a2_.altri_soggetti_f AS altri_soggetti_f_44, a2_.altri_soggetti_cciaa AS altri_soggetti_cciaa_45, a2_.accreditati_di_diritto_c AS accreditati_di_diritto_c_46, a2_.accreditati_di_diritto_d AS accreditati_di_diritto_d_47, a2_.accreditati_di_diritto_e AS accreditati_di_diritto_e_48, a2_.accreditati_di_diritto_j AS accreditati_di_diritto_j_49, a2_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_50, a2_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_51, a2_.tipologia_accreditamento AS tipologia_accreditamento_52, a2_.type AS type_53, a2_.codice_sac AS codice_sac_54, a2_.autodichiarazione AS autodichiarazione_55, a2_.metadati AS metadati_56, a2_.documenti_allegati AS documenti_allegati_57, a2_.scadenza_documenti AS scadenza_documenti_58, a2_.attivita_controllo AS attivita_controllo_59, a2_.tipologia_istruttoria AS tipologia_istruttoria_60, a2_.tempi_verifica AS tempi_verifica_61, a2_.note AS note_62, a2_.is_active AS is_active_63, a2_.data_inizio_validita AS data_inizio_validita_64, a2_.data_fine_validita AS data_fine_validita_65, a2_.primo_accreditamento AS primo_accreditamento_66, a2_.mantenimento AS mantenimento_67, a2_.variazione AS variazione_68, a2_.sede_temporanea AS sede_temporanea_69, a2_.sportello_temporaneo AS sportello_temporaneo_70, a2_.isRequestedForRenewal AS isRequestedForRenewal_71, a2_.accreditamento_autorizzato AS accreditamento_autorizzato_72, a2_.its AS its_73, a2_.diritto_dovere AS diritto_dovere_74, a2_.post_diritto_dovere AS post_diritto_dovere_75, a2_.formazione_continua AS formazione_continua_76, a2_.utenze_speciali AS utenze_speciali_77, a2_.accreditamento_finanziato AS accreditamento_finanziato_78, a2_.tipo_accreditamento AS tipo_accreditamento_79, a2_.sort_index AS sort_index_80, a2_.next_level_accreditation AS next_level_accreditation_81, a2_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_82, a2_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_83, a2_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_84, a2_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_85, a2_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_86, a2_.sequence_to_pdf_show AS sequence_to_pdf_show_87, a2_.variation_type AS variation_type_88, a2_.future_presentation_months AS future_presentation_months_89, m0_.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_90, m0_.maintenance_document_id AS maintenance_document_id_91, m0_.document_id AS document_id_92, m0_.accreditation_requirement_id AS accreditation_requirement_id_93, m1_.maintenance_request_id AS maintenance_request_id_94, m1_.previous_document_id AS previous_document_id_95, m1_.accreditation_requirement_id AS accreditation_requirement_id_96, m1_.requirement_id AS requirement_id_97, m1_.previous_maintenance_document_id AS previous_maintenance_document_id_98 FROM maintenance_document_review_l1 m0_ INNER JOIN maintenance_investigation_l1 m3_ ON m0_.maintenance_investigation_l1_id = m3_.id INNER JOIN maintenance_request m4_ ON m3_.maintenance_request_id = m4_.id INNER JOIN maintenance_document m1_ ON m0_.maintenance_document_id = m1_.id INNER JOIN accreditation_requirement a2_ ON m0_.accreditation_requirement_id = a2_.id WHERE m4_.accreditation_application_id = ? AND m4_.status IN (?, ?) AND m0_.status = ? ORDER BY m0_.created_at DESC

Parameters:

[
  1
  "DEFINITIVELY_APPROVED"
  "L1_APPROVED"
  "APPROVED"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.status AS status_1,
  m0_.nota AS nota_2,
  m0_.has_expiration_date AS has_expiration_date_3,
  m0_.expiration_date AS expiration_date_4,
  m0_.reviewed_at AS reviewed_at_5,
  m0_.created_at AS created_at_6,
  m0_.updated_at AS updated_at_7,
  m0_.additional_data AS additional_data_8,
  m0_.meta_type AS meta_type_9,
  m0_.tab AS tab_10,
  m1_.id AS id_11,
  m1_.original_expiration_date AS original_expiration_date_12,
  m1_.name AS name_13,
  m1_.original_name AS original_name_14,
  m1_.size AS size_15,
  m1_.mime_type AS mime_type_16,
  m1_.validated AS validated_17,
  m1_.review_notes AS review_notes_18,
  m1_.rejection_reason AS rejection_reason_19,
  m1_.is_old_file AS is_old_file_20,
  m1_.created_at AS created_at_21,
  m1_.updated_at AS updated_at_22,
  m1_.modified_during_integration AS modified_during_integration_23,
  m1_.integration_round AS integration_round_24,
  a2_.id AS id_25,
  a2_.tabella AS tabella_26,
  a2_.requisito AS requisito_27,
  a2_.universita_statali AS universita_statali_28,
  a2_.scuole_statali AS scuole_statali_29,
  a2_.scuole_paritarie AS scuole_paritarie_30,
  a2_.soggetti_privati AS soggetti_privati_31,
  a2_.centri_formazione_pubblici AS centri_formazione_pubblici_32,
  a2_.soggetti_legislativi AS soggetti_legislativi_33,
  a2_.comuni_metropolitane AS comuni_metropolitane_34,
  a2_.centri_regionali_provinciali AS centri_regionali_provinciali_35,
  a2_.enti_pubblici55 AS enti_pubblici55_36,
  a2_.accreditati_anorma_dgr AS accreditati_anorma_dgr_37,
  a2_.centri_impiego AS centri_impiego_38,
  a2_.altri_soggetti_a AS altri_soggetti_a_39,
  a2_.altri_soggetti_g AS altri_soggetti_g_40,
  a2_.altri_soggetti_h AS altri_soggetti_h_41,
  a2_.altri_soggetti_i AS altri_soggetti_i_42,
  a2_.altri_soggetti_m AS altri_soggetti_m_43,
  a2_.altri_soggetti_f AS altri_soggetti_f_44,
  a2_.altri_soggetti_cciaa AS altri_soggetti_cciaa_45,
  a2_.accreditati_di_diritto_c AS accreditati_di_diritto_c_46,
  a2_.accreditati_di_diritto_d AS accreditati_di_diritto_d_47,
  a2_.accreditati_di_diritto_e AS accreditati_di_diritto_e_48,
  a2_.accreditati_di_diritto_j AS accreditati_di_diritto_j_49,
  a2_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_50,
  a2_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_51,
  a2_.tipologia_accreditamento AS tipologia_accreditamento_52,
  a2_.type AS type_53,
  a2_.codice_sac AS codice_sac_54,
  a2_.autodichiarazione AS autodichiarazione_55,
  a2_.metadati AS metadati_56,
  a2_.documenti_allegati AS documenti_allegati_57,
  a2_.scadenza_documenti AS scadenza_documenti_58,
  a2_.attivita_controllo AS attivita_controllo_59,
  a2_.tipologia_istruttoria AS tipologia_istruttoria_60,
  a2_.tempi_verifica AS tempi_verifica_61,
  a2_.note AS note_62,
  a2_.is_active AS is_active_63,
  a2_.data_inizio_validita AS data_inizio_validita_64,
  a2_.data_fine_validita AS data_fine_validita_65,
  a2_.primo_accreditamento AS primo_accreditamento_66,
  a2_.mantenimento AS mantenimento_67,
  a2_.variazione AS variazione_68,
  a2_.sede_temporanea AS sede_temporanea_69,
  a2_.sportello_temporaneo AS sportello_temporaneo_70,
  a2_.isRequestedForRenewal AS isRequestedForRenewal_71,
  a2_.accreditamento_autorizzato AS accreditamento_autorizzato_72,
  a2_.its AS its_73,
  a2_.diritto_dovere AS diritto_dovere_74,
  a2_.post_diritto_dovere AS post_diritto_dovere_75,
  a2_.formazione_continua AS formazione_continua_76,
  a2_.utenze_speciali AS utenze_speciali_77,
  a2_.accreditamento_finanziato AS accreditamento_finanziato_78,
  a2_.tipo_accreditamento AS tipo_accreditamento_79,
  a2_.sort_index AS sort_index_80,
  a2_.next_level_accreditation AS next_level_accreditation_81,
  a2_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_82,
  a2_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_83,
  a2_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_84,
  a2_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_85,
  a2_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_86,
  a2_.sequence_to_pdf_show AS sequence_to_pdf_show_87,
  a2_.variation_type AS variation_type_88,
  a2_.future_presentation_months AS future_presentation_months_89,
  m0_.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_90,
  m0_.maintenance_document_id AS maintenance_document_id_91,
  m0_.document_id AS document_id_92,
  m0_.accreditation_requirement_id AS accreditation_requirement_id_93,
  m1_.maintenance_request_id AS maintenance_request_id_94,
  m1_.previous_document_id AS previous_document_id_95,
  m1_.accreditation_requirement_id AS accreditation_requirement_id_96,
  m1_.requirement_id AS requirement_id_97,
  m1_.previous_maintenance_document_id AS previous_maintenance_document_id_98
FROM
  maintenance_document_review_l1 m0_
  INNER JOIN maintenance_investigation_l1 m3_ ON m0_.maintenance_investigation_l1_id = m3_.id
  INNER JOIN maintenance_request m4_ ON m3_.maintenance_request_id = m4_.id
  INNER JOIN maintenance_document m1_ ON m0_.maintenance_document_id = m1_.id
  INNER JOIN accreditation_requirement a2_ ON m0_.accreditation_requirement_id = a2_.id
WHERE
  m4_.accreditation_application_id = ?
  AND m4_.status IN (?, ?)
  AND m0_.status = ?
ORDER BY
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.status AS status_1, m0_.nota AS nota_2, m0_.has_expiration_date AS has_expiration_date_3, m0_.expiration_date AS expiration_date_4, m0_.reviewed_at AS reviewed_at_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.additional_data AS additional_data_8, m0_.meta_type AS meta_type_9, m0_.tab AS tab_10, m1_.id AS id_11, m1_.original_expiration_date AS original_expiration_date_12, m1_.name AS name_13, m1_.original_name AS original_name_14, m1_.size AS size_15, m1_.mime_type AS mime_type_16, m1_.validated AS validated_17, m1_.review_notes AS review_notes_18, m1_.rejection_reason AS rejection_reason_19, m1_.is_old_file AS is_old_file_20, m1_.created_at AS created_at_21, m1_.updated_at AS updated_at_22, m1_.modified_during_integration AS modified_during_integration_23, m1_.integration_round AS integration_round_24, a2_.id AS id_25, a2_.tabella AS tabella_26, a2_.requisito AS requisito_27, a2_.universita_statali AS universita_statali_28, a2_.scuole_statali AS scuole_statali_29, a2_.scuole_paritarie AS scuole_paritarie_30, a2_.soggetti_privati AS soggetti_privati_31, a2_.centri_formazione_pubblici AS centri_formazione_pubblici_32, a2_.soggetti_legislativi AS soggetti_legislativi_33, a2_.comuni_metropolitane AS comuni_metropolitane_34, a2_.centri_regionali_provinciali AS centri_regionali_provinciali_35, a2_.enti_pubblici55 AS enti_pubblici55_36, a2_.accreditati_anorma_dgr AS accreditati_anorma_dgr_37, a2_.centri_impiego AS centri_impiego_38, a2_.altri_soggetti_a AS altri_soggetti_a_39, a2_.altri_soggetti_g AS altri_soggetti_g_40, a2_.altri_soggetti_h AS altri_soggetti_h_41, a2_.altri_soggetti_i AS altri_soggetti_i_42, a2_.altri_soggetti_m AS altri_soggetti_m_43, a2_.altri_soggetti_f AS altri_soggetti_f_44, a2_.altri_soggetti_cciaa AS altri_soggetti_cciaa_45, a2_.accreditati_di_diritto_c AS accreditati_di_diritto_c_46, a2_.accreditati_di_diritto_d AS accreditati_di_diritto_d_47, a2_.accreditati_di_diritto_e AS accreditati_di_diritto_e_48, a2_.accreditati_di_diritto_j AS accreditati_di_diritto_j_49, a2_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_50, a2_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_51, a2_.tipologia_accreditamento AS tipologia_accreditamento_52, a2_.type AS type_53, a2_.codice_sac AS codice_sac_54, a2_.autodichiarazione AS autodichiarazione_55, a2_.metadati AS metadati_56, a2_.documenti_allegati AS documenti_allegati_57, a2_.scadenza_documenti AS scadenza_documenti_58, a2_.attivita_controllo AS attivita_controllo_59, a2_.tipologia_istruttoria AS tipologia_istruttoria_60, a2_.tempi_verifica AS tempi_verifica_61, a2_.note AS note_62, a2_.is_active AS is_active_63, a2_.data_inizio_validita AS data_inizio_validita_64, a2_.data_fine_validita AS data_fine_validita_65, a2_.primo_accreditamento AS primo_accreditamento_66, a2_.mantenimento AS mantenimento_67, a2_.variazione AS variazione_68, a2_.sede_temporanea AS sede_temporanea_69, a2_.sportello_temporaneo AS sportello_temporaneo_70, a2_.isRequestedForRenewal AS isRequestedForRenewal_71, a2_.accreditamento_autorizzato AS accreditamento_autorizzato_72, a2_.its AS its_73, a2_.diritto_dovere AS diritto_dovere_74, a2_.post_diritto_dovere AS post_diritto_dovere_75, a2_.formazione_continua AS formazione_continua_76, a2_.utenze_speciali AS utenze_speciali_77, a2_.accreditamento_finanziato AS accreditamento_finanziato_78, a2_.tipo_accreditamento AS tipo_accreditamento_79, a2_.sort_index AS sort_index_80, a2_.next_level_accreditation AS next_level_accreditation_81, a2_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_82, a2_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_83, a2_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_84, a2_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_85, a2_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_86, a2_.sequence_to_pdf_show AS sequence_to_pdf_show_87, a2_.variation_type AS variation_type_88, a2_.future_presentation_months AS future_presentation_months_89, m0_.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_90, m0_.maintenance_document_id AS maintenance_document_id_91, m0_.document_id AS document_id_92, m0_.accreditation_requirement_id AS accreditation_requirement_id_93, m1_.maintenance_request_id AS maintenance_request_id_94, m1_.previous_document_id AS previous_document_id_95, m1_.accreditation_requirement_id AS accreditation_requirement_id_96, m1_.requirement_id AS requirement_id_97, m1_.previous_maintenance_document_id AS previous_maintenance_document_id_98 FROM maintenance_document_review_l1 m0_ INNER JOIN maintenance_investigation_l1 m3_ ON m0_.maintenance_investigation_l1_id = m3_.id INNER JOIN maintenance_request m4_ ON m3_.maintenance_request_id = m4_.id INNER JOIN maintenance_document m1_ ON m0_.maintenance_document_id = m1_.id INNER JOIN accreditation_requirement a2_ ON m0_.accreditation_requirement_id = a2_.id WHERE m4_.accreditation_application_id = 1 AND m4_.status IN ('DEFINITIVELY_APPROVED', 'L1_APPROVED') AND m0_.status = 'APPROVED' ORDER BY m0_.created_at DESC;

#	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\DocumentiInVigenzaService->findMaintenanceDocumentsForApp (line 290)
9	App\Service\DocumentiInVigenzaService->buildItemsForApplication (line 225)
10	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerInstitution (line 106)
11	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerLegalOwner (line 74)
12	App\Controller\LandingPageController->home (line 136)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

7.72 ms
(0.74%)

SELECT u0_.identifier AS identifier_0, u0_.provider AS provider_1, u0_.username AS username_2, u0_.email AS email_3, u0_.pec AS pec_4, u0_.cellular AS cellular_5, u0_.fiscal_code AS fiscal_code_6, u0_.password AS password_7, u0_.last_access AS last_access_8, u0_.is_user_suspended AS is_user_suspended_9, u0_.id AS id_10, u0_.active AS active_11, u0_.created_at AS created_at_12, u0_.updated_at AS updated_at_13, u0_.deleted_at AS deleted_at_14, u0_.person_id AS person_id_15, u0_.last_operating_institution_id AS last_operating_institution_id_16 FROM user u0_ LEFT JOIN user_role u2_ ON u0_.id = u2_.user_id LEFT JOIN role r1_ ON r1_.id = u2_.role_id WHERE u0_.active = ? AND r1_.name = ? ORDER BY u0_.id ASC

Parameters:

[
  1
  "ROLE_OPERATORE_UNICO"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.identifier AS identifier_0,
  u0_.provider AS provider_1,
  u0_.username AS username_2,
  u0_.email AS email_3,
  u0_.pec AS pec_4,
  u0_.cellular AS cellular_5,
  u0_.fiscal_code AS fiscal_code_6,
  u0_.password AS password_7,
  u0_.last_access AS last_access_8,
  u0_.is_user_suspended AS is_user_suspended_9,
  u0_.id AS id_10,
  u0_.active AS active_11,
  u0_.created_at AS created_at_12,
  u0_.updated_at AS updated_at_13,
  u0_.deleted_at AS deleted_at_14,
  u0_.person_id AS person_id_15,
  u0_.last_operating_institution_id AS last_operating_institution_id_16
FROM
  user u0_
  LEFT JOIN user_role u2_ ON u0_.id = u2_.user_id
  LEFT JOIN role r1_ ON r1_.id = u2_.role_id
WHERE
  u0_.active = ?
  AND r1_.name = ?
ORDER BY
  u0_.id ASC

SELECT u0_.identifier AS identifier_0, u0_.provider AS provider_1, u0_.username AS username_2, u0_.email AS email_3, u0_.pec AS pec_4, u0_.cellular AS cellular_5, u0_.fiscal_code AS fiscal_code_6, u0_.password AS password_7, u0_.last_access AS last_access_8, u0_.is_user_suspended AS is_user_suspended_9, u0_.id AS id_10, u0_.active AS active_11, u0_.created_at AS created_at_12, u0_.updated_at AS updated_at_13, u0_.deleted_at AS deleted_at_14, u0_.person_id AS person_id_15, u0_.last_operating_institution_id AS last_operating_institution_id_16 FROM user u0_ LEFT JOIN user_role u2_ ON u0_.id = u2_.user_id LEFT JOIN role r1_ ON r1_.id = u2_.role_id WHERE u0_.active = 1 AND r1_.name = 'ROLE_OPERATORE_UNICO' ORDER BY u0_.id 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\Repository\UserRepository->findTrainerL1Users (line 180)
9	App\Controller\LandingPageController->loadTrainers (line 517)
10	App\Controller\LandingPageController->home (line 122)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

7.23 ms
(0.69%)

SELECT u0_.identifier AS identifier_0, u0_.provider AS provider_1, u0_.username AS username_2, u0_.email AS email_3, u0_.pec AS pec_4, u0_.cellular AS cellular_5, u0_.fiscal_code AS fiscal_code_6, u0_.password AS password_7, u0_.last_access AS last_access_8, u0_.is_user_suspended AS is_user_suspended_9, u0_.id AS id_10, u0_.active AS active_11, u0_.created_at AS created_at_12, u0_.updated_at AS updated_at_13, u0_.deleted_at AS deleted_at_14, u0_.person_id AS person_id_15, u0_.last_operating_institution_id AS last_operating_institution_id_16 FROM user u0_ LEFT JOIN user_role u2_ ON u0_.id = u2_.user_id LEFT JOIN role r1_ ON r1_.id = u2_.role_id WHERE u0_.active = ? AND r1_.name = ?

Parameters:

[
  1
  "ROLE_AUDITOR"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.identifier AS identifier_0,
  u0_.provider AS provider_1,
  u0_.username AS username_2,
  u0_.email AS email_3,
  u0_.pec AS pec_4,
  u0_.cellular AS cellular_5,
  u0_.fiscal_code AS fiscal_code_6,
  u0_.password AS password_7,
  u0_.last_access AS last_access_8,
  u0_.is_user_suspended AS is_user_suspended_9,
  u0_.id AS id_10,
  u0_.active AS active_11,
  u0_.created_at AS created_at_12,
  u0_.updated_at AS updated_at_13,
  u0_.deleted_at AS deleted_at_14,
  u0_.person_id AS person_id_15,
  u0_.last_operating_institution_id AS last_operating_institution_id_16
FROM
  user u0_
  LEFT JOIN user_role u2_ ON u0_.id = u2_.user_id
  LEFT JOIN role r1_ ON r1_.id = u2_.role_id
WHERE
  u0_.active = ?
  AND r1_.name = ?

SELECT u0_.identifier AS identifier_0, u0_.provider AS provider_1, u0_.username AS username_2, u0_.email AS email_3, u0_.pec AS pec_4, u0_.cellular AS cellular_5, u0_.fiscal_code AS fiscal_code_6, u0_.password AS password_7, u0_.last_access AS last_access_8, u0_.is_user_suspended AS is_user_suspended_9, u0_.id AS id_10, u0_.active AS active_11, u0_.created_at AS created_at_12, u0_.updated_at AS updated_at_13, u0_.deleted_at AS deleted_at_14, u0_.person_id AS person_id_15, u0_.last_operating_institution_id AS last_operating_institution_id_16 FROM user u0_ LEFT JOIN user_role u2_ ON u0_.id = u2_.user_id LEFT JOIN role r1_ ON r1_.id = u2_.role_id WHERE u0_.active = 1 AND r1_.name = 'ROLE_AUDITOR';

#	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\Repository\UserRepository->findTrainerL2Users (line 257)
9	App\Controller\LandingPageController->loadTrainers (line 518)
10	App\Controller\LandingPageController->home (line 122)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

6.99 ms
(0.67%)

SELECT m0_.id AS id_0, m0_.meta_type AS meta_type_1, m0_.tab AS tab_2, m0_.status AS status_3, m0_.nota AS nota_4, m0_.reviewed_at AS reviewed_at_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.additional_data AS additional_data_8, a1_.id AS id_9, a1_.tabella AS tabella_10, a1_.requisito AS requisito_11, a1_.universita_statali AS universita_statali_12, a1_.scuole_statali AS scuole_statali_13, a1_.scuole_paritarie AS scuole_paritarie_14, a1_.soggetti_privati AS soggetti_privati_15, a1_.centri_formazione_pubblici AS centri_formazione_pubblici_16, a1_.soggetti_legislativi AS soggetti_legislativi_17, a1_.comuni_metropolitane AS comuni_metropolitane_18, a1_.centri_regionali_provinciali AS centri_regionali_provinciali_19, a1_.enti_pubblici55 AS enti_pubblici55_20, a1_.accreditati_anorma_dgr AS accreditati_anorma_dgr_21, a1_.centri_impiego AS centri_impiego_22, a1_.altri_soggetti_a AS altri_soggetti_a_23, a1_.altri_soggetti_g AS altri_soggetti_g_24, a1_.altri_soggetti_h AS altri_soggetti_h_25, a1_.altri_soggetti_i AS altri_soggetti_i_26, a1_.altri_soggetti_m AS altri_soggetti_m_27, a1_.altri_soggetti_f AS altri_soggetti_f_28, a1_.altri_soggetti_cciaa AS altri_soggetti_cciaa_29, a1_.accreditati_di_diritto_c AS accreditati_di_diritto_c_30, a1_.accreditati_di_diritto_d AS accreditati_di_diritto_d_31, a1_.accreditati_di_diritto_e AS accreditati_di_diritto_e_32, a1_.accreditati_di_diritto_j AS accreditati_di_diritto_j_33, a1_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_34, a1_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_35, a1_.tipologia_accreditamento AS tipologia_accreditamento_36, a1_.type AS type_37, a1_.codice_sac AS codice_sac_38, a1_.autodichiarazione AS autodichiarazione_39, a1_.metadati AS metadati_40, a1_.documenti_allegati AS documenti_allegati_41, a1_.scadenza_documenti AS scadenza_documenti_42, a1_.attivita_controllo AS attivita_controllo_43, a1_.tipologia_istruttoria AS tipologia_istruttoria_44, a1_.tempi_verifica AS tempi_verifica_45, a1_.note AS note_46, a1_.is_active AS is_active_47, a1_.data_inizio_validita AS data_inizio_validita_48, a1_.data_fine_validita AS data_fine_validita_49, a1_.primo_accreditamento AS primo_accreditamento_50, a1_.mantenimento AS mantenimento_51, a1_.variazione AS variazione_52, a1_.sede_temporanea AS sede_temporanea_53, a1_.sportello_temporaneo AS sportello_temporaneo_54, a1_.isRequestedForRenewal AS isRequestedForRenewal_55, a1_.accreditamento_autorizzato AS accreditamento_autorizzato_56, a1_.its AS its_57, a1_.diritto_dovere AS diritto_dovere_58, a1_.post_diritto_dovere AS post_diritto_dovere_59, a1_.formazione_continua AS formazione_continua_60, a1_.utenze_speciali AS utenze_speciali_61, a1_.accreditamento_finanziato AS accreditamento_finanziato_62, a1_.tipo_accreditamento AS tipo_accreditamento_63, a1_.sort_index AS sort_index_64, a1_.next_level_accreditation AS next_level_accreditation_65, a1_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_66, a1_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_67, a1_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_68, a1_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_69, a1_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_70, a1_.sequence_to_pdf_show AS sequence_to_pdf_show_71, a1_.variation_type AS variation_type_72, a1_.future_presentation_months AS future_presentation_months_73, m2_.id AS id_74, m2_.tab AS tab_75, m2_.meta_data_key AS meta_data_key_76, m2_.meta_data_value AS meta_data_value_77, m2_.type AS type_78, m2_.is_valid AS is_valid_79, m2_.created_at AS created_at_80, m2_.updated_at AS updated_at_81, m2_.modified_during_integration AS modified_during_integration_82, m2_.is_old_data AS is_old_data_83, m2_.integration_round AS integration_round_84, m0_.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_85, m0_.accreditation_requirement_id AS accreditation_requirement_id_86, m0_.maintenance_request_metadata_id AS maintenance_request_metadata_id_87, m2_.maintenance_request_id AS maintenance_request_id_88, m2_.accreditation_requirement_id AS accreditation_requirement_id_89, m2_.requirement_metadata_field_id AS requirement_metadata_field_id_90, m2_.previous_maintenance_request_metadata_id AS previous_maintenance_request_metadata_id_91 FROM maintenance_metadata_review_l1 m0_ INNER JOIN maintenance_investigation_l1 m3_ ON m0_.maintenance_investigation_l1_id = m3_.id INNER JOIN maintenance_request m4_ ON m3_.maintenance_request_id = m4_.id INNER JOIN accreditation_requirement a1_ ON m0_.accreditation_requirement_id = a1_.id LEFT JOIN maintenance_request_metadata m2_ ON m0_.maintenance_request_metadata_id = m2_.id WHERE m4_.accreditation_application_id = ? AND m4_.status IN (?, ?) AND m0_.status = ? ORDER BY m0_.created_at DESC

Parameters:

[
  1
  "DEFINITIVELY_APPROVED"
  "L1_APPROVED"
  "APPROVED"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.meta_type AS meta_type_1,
  m0_.tab AS tab_2,
  m0_.status AS status_3,
  m0_.nota AS nota_4,
  m0_.reviewed_at AS reviewed_at_5,
  m0_.created_at AS created_at_6,
  m0_.updated_at AS updated_at_7,
  m0_.additional_data AS additional_data_8,
  a1_.id AS id_9,
  a1_.tabella AS tabella_10,
  a1_.requisito AS requisito_11,
  a1_.universita_statali AS universita_statali_12,
  a1_.scuole_statali AS scuole_statali_13,
  a1_.scuole_paritarie AS scuole_paritarie_14,
  a1_.soggetti_privati AS soggetti_privati_15,
  a1_.centri_formazione_pubblici AS centri_formazione_pubblici_16,
  a1_.soggetti_legislativi AS soggetti_legislativi_17,
  a1_.comuni_metropolitane AS comuni_metropolitane_18,
  a1_.centri_regionali_provinciali AS centri_regionali_provinciali_19,
  a1_.enti_pubblici55 AS enti_pubblici55_20,
  a1_.accreditati_anorma_dgr AS accreditati_anorma_dgr_21,
  a1_.centri_impiego AS centri_impiego_22,
  a1_.altri_soggetti_a AS altri_soggetti_a_23,
  a1_.altri_soggetti_g AS altri_soggetti_g_24,
  a1_.altri_soggetti_h AS altri_soggetti_h_25,
  a1_.altri_soggetti_i AS altri_soggetti_i_26,
  a1_.altri_soggetti_m AS altri_soggetti_m_27,
  a1_.altri_soggetti_f AS altri_soggetti_f_28,
  a1_.altri_soggetti_cciaa AS altri_soggetti_cciaa_29,
  a1_.accreditati_di_diritto_c AS accreditati_di_diritto_c_30,
  a1_.accreditati_di_diritto_d AS accreditati_di_diritto_d_31,
  a1_.accreditati_di_diritto_e AS accreditati_di_diritto_e_32,
  a1_.accreditati_di_diritto_j AS accreditati_di_diritto_j_33,
  a1_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_34,
  a1_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_35,
  a1_.tipologia_accreditamento AS tipologia_accreditamento_36,
  a1_.type AS type_37,
  a1_.codice_sac AS codice_sac_38,
  a1_.autodichiarazione AS autodichiarazione_39,
  a1_.metadati AS metadati_40,
  a1_.documenti_allegati AS documenti_allegati_41,
  a1_.scadenza_documenti AS scadenza_documenti_42,
  a1_.attivita_controllo AS attivita_controllo_43,
  a1_.tipologia_istruttoria AS tipologia_istruttoria_44,
  a1_.tempi_verifica AS tempi_verifica_45,
  a1_.note AS note_46,
  a1_.is_active AS is_active_47,
  a1_.data_inizio_validita AS data_inizio_validita_48,
  a1_.data_fine_validita AS data_fine_validita_49,
  a1_.primo_accreditamento AS primo_accreditamento_50,
  a1_.mantenimento AS mantenimento_51,
  a1_.variazione AS variazione_52,
  a1_.sede_temporanea AS sede_temporanea_53,
  a1_.sportello_temporaneo AS sportello_temporaneo_54,
  a1_.isRequestedForRenewal AS isRequestedForRenewal_55,
  a1_.accreditamento_autorizzato AS accreditamento_autorizzato_56,
  a1_.its AS its_57,
  a1_.diritto_dovere AS diritto_dovere_58,
  a1_.post_diritto_dovere AS post_diritto_dovere_59,
  a1_.formazione_continua AS formazione_continua_60,
  a1_.utenze_speciali AS utenze_speciali_61,
  a1_.accreditamento_finanziato AS accreditamento_finanziato_62,
  a1_.tipo_accreditamento AS tipo_accreditamento_63,
  a1_.sort_index AS sort_index_64,
  a1_.next_level_accreditation AS next_level_accreditation_65,
  a1_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_66,
  a1_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_67,
  a1_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_68,
  a1_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_69,
  a1_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_70,
  a1_.sequence_to_pdf_show AS sequence_to_pdf_show_71,
  a1_.variation_type AS variation_type_72,
  a1_.future_presentation_months AS future_presentation_months_73,
  m2_.id AS id_74,
  m2_.tab AS tab_75,
  m2_.meta_data_key AS meta_data_key_76,
  m2_.meta_data_value AS meta_data_value_77,
  m2_.type AS type_78,
  m2_.is_valid AS is_valid_79,
  m2_.created_at AS created_at_80,
  m2_.updated_at AS updated_at_81,
  m2_.modified_during_integration AS modified_during_integration_82,
  m2_.is_old_data AS is_old_data_83,
  m2_.integration_round AS integration_round_84,
  m0_.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_85,
  m0_.accreditation_requirement_id AS accreditation_requirement_id_86,
  m0_.maintenance_request_metadata_id AS maintenance_request_metadata_id_87,
  m2_.maintenance_request_id AS maintenance_request_id_88,
  m2_.accreditation_requirement_id AS accreditation_requirement_id_89,
  m2_.requirement_metadata_field_id AS requirement_metadata_field_id_90,
  m2_.previous_maintenance_request_metadata_id AS previous_maintenance_request_metadata_id_91
FROM
  maintenance_metadata_review_l1 m0_
  INNER JOIN maintenance_investigation_l1 m3_ ON m0_.maintenance_investigation_l1_id = m3_.id
  INNER JOIN maintenance_request m4_ ON m3_.maintenance_request_id = m4_.id
  INNER JOIN accreditation_requirement a1_ ON m0_.accreditation_requirement_id = a1_.id
  LEFT JOIN maintenance_request_metadata m2_ ON m0_.maintenance_request_metadata_id = m2_.id
WHERE
  m4_.accreditation_application_id = ?
  AND m4_.status IN (?, ?)
  AND m0_.status = ?
ORDER BY
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.meta_type AS meta_type_1, m0_.tab AS tab_2, m0_.status AS status_3, m0_.nota AS nota_4, m0_.reviewed_at AS reviewed_at_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.additional_data AS additional_data_8, a1_.id AS id_9, a1_.tabella AS tabella_10, a1_.requisito AS requisito_11, a1_.universita_statali AS universita_statali_12, a1_.scuole_statali AS scuole_statali_13, a1_.scuole_paritarie AS scuole_paritarie_14, a1_.soggetti_privati AS soggetti_privati_15, a1_.centri_formazione_pubblici AS centri_formazione_pubblici_16, a1_.soggetti_legislativi AS soggetti_legislativi_17, a1_.comuni_metropolitane AS comuni_metropolitane_18, a1_.centri_regionali_provinciali AS centri_regionali_provinciali_19, a1_.enti_pubblici55 AS enti_pubblici55_20, a1_.accreditati_anorma_dgr AS accreditati_anorma_dgr_21, a1_.centri_impiego AS centri_impiego_22, a1_.altri_soggetti_a AS altri_soggetti_a_23, a1_.altri_soggetti_g AS altri_soggetti_g_24, a1_.altri_soggetti_h AS altri_soggetti_h_25, a1_.altri_soggetti_i AS altri_soggetti_i_26, a1_.altri_soggetti_m AS altri_soggetti_m_27, a1_.altri_soggetti_f AS altri_soggetti_f_28, a1_.altri_soggetti_cciaa AS altri_soggetti_cciaa_29, a1_.accreditati_di_diritto_c AS accreditati_di_diritto_c_30, a1_.accreditati_di_diritto_d AS accreditati_di_diritto_d_31, a1_.accreditati_di_diritto_e AS accreditati_di_diritto_e_32, a1_.accreditati_di_diritto_j AS accreditati_di_diritto_j_33, a1_.accreditati_dal_ministero_b AS accreditati_dal_ministero_b_34, a1_.accreditati_dal_ministero_k AS accreditati_dal_ministero_k_35, a1_.tipologia_accreditamento AS tipologia_accreditamento_36, a1_.type AS type_37, a1_.codice_sac AS codice_sac_38, a1_.autodichiarazione AS autodichiarazione_39, a1_.metadati AS metadati_40, a1_.documenti_allegati AS documenti_allegati_41, a1_.scadenza_documenti AS scadenza_documenti_42, a1_.attivita_controllo AS attivita_controllo_43, a1_.tipologia_istruttoria AS tipologia_istruttoria_44, a1_.tempi_verifica AS tempi_verifica_45, a1_.note AS note_46, a1_.is_active AS is_active_47, a1_.data_inizio_validita AS data_inizio_validita_48, a1_.data_fine_validita AS data_fine_validita_49, a1_.primo_accreditamento AS primo_accreditamento_50, a1_.mantenimento AS mantenimento_51, a1_.variazione AS variazione_52, a1_.sede_temporanea AS sede_temporanea_53, a1_.sportello_temporaneo AS sportello_temporaneo_54, a1_.isRequestedForRenewal AS isRequestedForRenewal_55, a1_.accreditamento_autorizzato AS accreditamento_autorizzato_56, a1_.its AS its_57, a1_.diritto_dovere AS diritto_dovere_58, a1_.post_diritto_dovere AS post_diritto_dovere_59, a1_.formazione_continua AS formazione_continua_60, a1_.utenze_speciali AS utenze_speciali_61, a1_.accreditamento_finanziato AS accreditamento_finanziato_62, a1_.tipo_accreditamento AS tipo_accreditamento_63, a1_.sort_index AS sort_index_64, a1_.next_level_accreditation AS next_level_accreditation_65, a1_.servizi_specialistici_area_funzionale_cinque AS servizi_specialistici_area_funzionale_cinque_66, a1_.servizi_specialistici_area_funzionale_sei AS servizi_specialistici_area_funzionale_sei_67, a1_.servizi_specialistici_area_funzionale_sette AS servizi_specialistici_area_funzionale_sette_68, a1_.servizi_specialistici_area_funzionale_otto AS servizi_specialistici_area_funzionale_otto_69, a1_.servizi_specialistici_area_funzionale_nove AS servizi_specialistici_area_funzionale_nove_70, a1_.sequence_to_pdf_show AS sequence_to_pdf_show_71, a1_.variation_type AS variation_type_72, a1_.future_presentation_months AS future_presentation_months_73, m2_.id AS id_74, m2_.tab AS tab_75, m2_.meta_data_key AS meta_data_key_76, m2_.meta_data_value AS meta_data_value_77, m2_.type AS type_78, m2_.is_valid AS is_valid_79, m2_.created_at AS created_at_80, m2_.updated_at AS updated_at_81, m2_.modified_during_integration AS modified_during_integration_82, m2_.is_old_data AS is_old_data_83, m2_.integration_round AS integration_round_84, m0_.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_85, m0_.accreditation_requirement_id AS accreditation_requirement_id_86, m0_.maintenance_request_metadata_id AS maintenance_request_metadata_id_87, m2_.maintenance_request_id AS maintenance_request_id_88, m2_.accreditation_requirement_id AS accreditation_requirement_id_89, m2_.requirement_metadata_field_id AS requirement_metadata_field_id_90, m2_.previous_maintenance_request_metadata_id AS previous_maintenance_request_metadata_id_91 FROM maintenance_metadata_review_l1 m0_ INNER JOIN maintenance_investigation_l1 m3_ ON m0_.maintenance_investigation_l1_id = m3_.id INNER JOIN maintenance_request m4_ ON m3_.maintenance_request_id = m4_.id INNER JOIN accreditation_requirement a1_ ON m0_.accreditation_requirement_id = a1_.id LEFT JOIN maintenance_request_metadata m2_ ON m0_.maintenance_request_metadata_id = m2_.id WHERE m4_.accreditation_application_id = 1 AND m4_.status IN ('DEFINITIVELY_APPROVED', 'L1_APPROVED') AND m0_.status = 'APPROVED' ORDER BY m0_.created_at DESC;

#	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\DocumentiInVigenzaService->findMaintenanceMetadataDocumentsForApp (line 364)
9	App\Service\DocumentiInVigenzaService->buildItemsForApplication (line 226)
10	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerInstitution (line 106)
11	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerLegalOwner (line 74)
12	App\Controller\LandingPageController->home (line 136)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

6.02 ms
(0.58%)

SELECT t0.id AS id_1, t0.nota AS nota_2, t0.note_type AS note_type_3, t0.investigation_round AS investigation_round_4, t0.created_at AS created_at_5, t0.created_by_id AS created_by_id_6, t0.investigation_l1_id AS investigation_l1_id_7, t0.investigation_l2_id AS investigation_l2_id_8, t0.investigation_l3_id AS investigation_l3_id_9, t0.variation_investigation_l1_id AS variation_investigation_l1_id_10, t0.variation_investigation_l2_id AS variation_investigation_l2_id_11, t0.variation_investigation_l3_id AS variation_investigation_l3_id_12, t0.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_13, t0.maintenance_investigation_l2_id AS maintenance_investigation_l2_id_14, t0.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_15 FROM investigation_note_history t0 WHERE t0.investigation_l1_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nota AS nota_2,
  t0.note_type AS note_type_3,
  t0.investigation_round AS investigation_round_4,
  t0.created_at AS created_at_5,
  t0.created_by_id AS created_by_id_6,
  t0.investigation_l1_id AS investigation_l1_id_7,
  t0.investigation_l2_id AS investigation_l2_id_8,
  t0.investigation_l3_id AS investigation_l3_id_9,
  t0.variation_investigation_l1_id AS variation_investigation_l1_id_10,
  t0.variation_investigation_l2_id AS variation_investigation_l2_id_11,
  t0.variation_investigation_l3_id AS variation_investigation_l3_id_12,
  t0.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_13,
  t0.maintenance_investigation_l2_id AS maintenance_investigation_l2_id_14,
  t0.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_15
FROM
  investigation_note_history t0
WHERE
  t0.investigation_l1_id = ?

SELECT t0.id AS id_1, t0.nota AS nota_2, t0.note_type AS note_type_3, t0.investigation_round AS investigation_round_4, t0.created_at AS created_at_5, t0.created_by_id AS created_by_id_6, t0.investigation_l1_id AS investigation_l1_id_7, t0.investigation_l2_id AS investigation_l2_id_8, t0.investigation_l3_id AS investigation_l3_id_9, t0.variation_investigation_l1_id AS variation_investigation_l1_id_10, t0.variation_investigation_l2_id AS variation_investigation_l2_id_11, t0.variation_investigation_l3_id AS variation_investigation_l3_id_12, t0.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_13, t0.maintenance_investigation_l2_id AS maintenance_investigation_l2_id_14, t0.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_15 FROM investigation_note_history t0 WHERE t0.investigation_l1_id = 4;

#	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 313)
9	App\Entity\AccreditationApplication->getIntegrationNotes (line 1053)
10	Twig\Extension\CoreExtension->getAttribute (line 1913)
11	__TwigTemplate_6297c010a53f63744e41abbc583e9409::block_content (line 1022)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_ef2cb7e231c49e8daf5501931fbdca9c->doDisplay (line 104)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_6297c010a53f63744e41abbc583e9409->doDisplay (line 149)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\LandingPageController->home (line 144)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

5.89 ms
(0.56%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.label AS label_4
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 15;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->map (line 257)
9	App\Entity\User->getRoles (line 183)
10	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 308)
11	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 217)
12	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 74)
15	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
16	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
17	Symfony\Bundle\SecurityBundle\Security->getToken (line 68)
18	Symfony\Bundle\SecurityBundle\Security->getUser (line 50)
19	App\EventListener\RoleBaseRedirectListener->onKernelRequest (line 30)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

5.82 ms
(0.56%)

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.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.institution_id = ? AND t0.accreditation_type = ? AND t0.status = ?

Parameters:

[
  2
  "Formazione"
  "DETERMINA_COMPLETATA"
]

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.id AS id_15,
  t0.active AS active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t20.id AS id_21,
  t20.active AS active_22,
  t20.created_at AS created_at_23,
  t20.updated_at AS updated_at_24,
  t20.deleted_at AS deleted_at_25,
  t20.accreditation_application_id AS accreditation_application_id_26,
  t20.tipology_id AS tipology_id_27,
  t0.institution_id AS institution_id_28,
  t0.legal_owner_id AS legal_owner_id_29,
  t0.institution_typology_id AS institution_typology_id_30,
  t0.parent_application_id AS parent_application_id_31
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id
WHERE
  t0.institution_id = ?
  AND t0.accreditation_type = ?
  AND t0.status = ?

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.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.institution_id = 2 AND t0.accreditation_type = 'Formazione' AND t0.status = 'DETERMINA_COMPLETATA';

#	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\Balance\BalanceReclassificationService->getReferenceApplication (line 567)
7	App\Service\Balance\BalanceReclassificationService->getDeterminaYear (line 159)
8	App\Service\Balance\BalanceReclassificationService->getAnnoDisponibilita (line 145)
9	App\Service\Balance\BalanceReclassificationService->isFunzionalitaDisponibile (line 173)
10	App\Twig\Extension\IsInstitutionAccreditatedExtension->isBalanceReclassificationAvailable (line 52)
11	App\Twig\Extension\IsInstitutionAccreditatedExtension->getGlobals (line 35)
12	Twig\ExtensionSet->getGlobals (line 361)
13	Twig\Environment->getGlobals (line 908)
14	Twig\Template->yield (line 398)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\LandingPageController->home (line 144)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

5.21 ms
(0.50%)

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:

[
  5
]

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

#	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 313)
9	App\Entity\AccreditationApplication->getIntegrationNotes (line 1047)
10	Twig\Extension\CoreExtension->getAttribute (line 1913)
11	__TwigTemplate_6297c010a53f63744e41abbc583e9409::block_content (line 1022)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_ef2cb7e231c49e8daf5501931fbdca9c->doDisplay (line 104)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_6297c010a53f63744e41abbc583e9409->doDisplay (line 149)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\LandingPageController->home (line 144)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

4.70 ms
(0.45%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.note AS note_4, t0.note_next_investigator AS note_next_investigator_5, t0.status AS status_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.verbale_esito AS verbale_esito_15, t0.verbale_generated_at AS verbale_generated_at_16, t0.verbale_firmato_at AS verbale_firmato_at_17, t0.awaiting_verbale_firmato AS awaiting_verbale_firmato_18, t0.resp_area_controllo_revision_note AS resp_area_controllo_revision_note_19, t0.resp_area_controllo_revision_note_at AS resp_area_controllo_revision_note_at_20, t0.resp_area_controllo_esito_change_note AS resp_area_controllo_esito_change_note_21, t0.resp_area_controllo_esito_change_note_at AS resp_area_controllo_esito_change_note_at_22, t0.assigned_to_id AS assigned_to_id_23, t0.accreditation_application_id AS accreditation_application_id_24, t0.verbale_firmato_id AS verbale_firmato_id_25 FROM accreditation_investigation_l2 t0 WHERE t0.accreditation_application_id = ?

Parameters:

[
  5
]

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.note AS note_4,
  t0.note_next_investigator AS note_next_investigator_5,
  t0.status AS status_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.verbale_esito AS verbale_esito_15,
  t0.verbale_generated_at AS verbale_generated_at_16,
  t0.verbale_firmato_at AS verbale_firmato_at_17,
  t0.awaiting_verbale_firmato AS awaiting_verbale_firmato_18,
  t0.resp_area_controllo_revision_note AS resp_area_controllo_revision_note_19,
  t0.resp_area_controllo_revision_note_at AS resp_area_controllo_revision_note_at_20,
  t0.resp_area_controllo_esito_change_note AS resp_area_controllo_esito_change_note_21,
  t0.resp_area_controllo_esito_change_note_at AS resp_area_controllo_esito_change_note_at_22,
  t0.assigned_to_id AS assigned_to_id_23,
  t0.accreditation_application_id AS accreditation_application_id_24,
  t0.verbale_firmato_id AS verbale_firmato_id_25
FROM
  accreditation_investigation_l2 t0
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.note AS note_4, t0.note_next_investigator AS note_next_investigator_5, t0.status AS status_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.verbale_esito AS verbale_esito_15, t0.verbale_generated_at AS verbale_generated_at_16, t0.verbale_firmato_at AS verbale_firmato_at_17, t0.awaiting_verbale_firmato AS awaiting_verbale_firmato_18, t0.resp_area_controllo_revision_note AS resp_area_controllo_revision_note_19, t0.resp_area_controllo_revision_note_at AS resp_area_controllo_revision_note_at_20, t0.resp_area_controllo_esito_change_note AS resp_area_controllo_esito_change_note_21, t0.resp_area_controllo_esito_change_note_at AS resp_area_controllo_esito_change_note_at_22, t0.assigned_to_id AS assigned_to_id_23, t0.accreditation_application_id AS accreditation_application_id_24, t0.verbale_firmato_id AS verbale_firmato_id_25 FROM accreditation_investigation_l2 t0 WHERE t0.accreditation_application_id = 5;

#	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 313)
9	App\Entity\AccreditationApplication->getIntegrationNotes (line 1047)
10	Twig\Extension\CoreExtension->getAttribute (line 1913)
11	__TwigTemplate_6297c010a53f63744e41abbc583e9409::block_content (line 1022)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_ef2cb7e231c49e8daf5501931fbdca9c->doDisplay (line 104)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_6297c010a53f63744e41abbc583e9409->doDisplay (line 149)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\LandingPageController->home (line 144)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

4.38 ms
(0.42%)

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.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.parent_application_id = ?

Parameters:

[
  5
]

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.id AS id_15,
  t0.active AS active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t20.id AS id_21,
  t20.active AS active_22,
  t20.created_at AS created_at_23,
  t20.updated_at AS updated_at_24,
  t20.deleted_at AS deleted_at_25,
  t20.accreditation_application_id AS accreditation_application_id_26,
  t20.tipology_id AS tipology_id_27,
  t0.institution_id AS institution_id_28,
  t0.legal_owner_id AS legal_owner_id_29,
  t0.institution_typology_id AS institution_typology_id_30,
  t0.parent_application_id AS parent_application_id_31
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t20 ON t20.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.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.parent_application_id = 5;

#	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 313)
9	App\Entity\AccreditationApplication->isSupersededByRenewal (line 988)
10	App\Controller\LandingPageController->App\Controller\{closure} (line 923)
11	array_filter (line 921)
12	App\Controller\LandingPageController::loadCasesForLegalOwner (line 921)
13	App\Controller\LandingPageController->loadCasesForRole (line 261)
14	App\Controller\LandingPageController->home (line 114)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

4.18 ms
(0.40%)

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.email AS email_13, t0.pec AS pec_14, t0.type AS type_15, t0.sub_type AS sub_type_16, t0.status AS status_17, t0.accreditation_application_id AS accreditation_application_id_18, t0.related_office_id AS related_office_id_19 FROM accreditation_office t0 WHERE t0.accreditation_application_id = ?

Parameters:

[
  1
]

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.email AS email_13,
  t0.pec AS pec_14,
  t0.type AS type_15,
  t0.sub_type AS sub_type_16,
  t0.status AS status_17,
  t0.accreditation_application_id AS accreditation_application_id_18,
  t0.related_office_id AS related_office_id_19
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.email AS email_13, t0.pec AS pec_14, t0.type AS type_15, t0.sub_type AS sub_type_16, t0.status AS status_17, t0.accreditation_application_id AS accreditation_application_id_18, t0.related_office_id AS related_office_id_19 FROM accreditation_office t0 WHERE t0.accreditation_application_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->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->toArray (line 157)
9	App\Service\DocumentiInVigenzaService->buildSedeGrouped (line 577)
10	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerInstitution (line 123)
11	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerLegalOwner (line 74)
12	App\Controller\LandingPageController->home (line 136)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

4.13 ms
(0.39%)

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.checklist_file_path AS checklist_file_path_15, t0.checklist_file_name AS checklist_file_name_16, t0.checklist_uploaded_at AS checklist_uploaded_at_17, t0.accreditation_application_id AS accreditation_application_id_18, t0.assigned_to_id AS assigned_to_id_19 FROM accreditation_investigation_l1 t0 WHERE t0.accreditation_application_id = ?

Parameters:

[
  5
]

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.checklist_file_path AS checklist_file_path_15,
  t0.checklist_file_name AS checklist_file_name_16,
  t0.checklist_uploaded_at AS checklist_uploaded_at_17,
  t0.accreditation_application_id AS accreditation_application_id_18,
  t0.assigned_to_id AS assigned_to_id_19
FROM
  accreditation_investigation_l1 t0
WHERE
  t0.accreditation_application_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.checklist_file_path AS checklist_file_path_15, t0.checklist_file_name AS checklist_file_name_16, t0.checklist_uploaded_at AS checklist_uploaded_at_17, t0.accreditation_application_id AS accreditation_application_id_18, t0.assigned_to_id AS assigned_to_id_19 FROM accreditation_investigation_l1 t0 WHERE t0.accreditation_application_id = 5;

#	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 313)
9	App\Entity\AccreditationApplication->getIntegrationNotes (line 1047)
10	Twig\Extension\CoreExtension->getAttribute (line 1913)
11	__TwigTemplate_6297c010a53f63744e41abbc583e9409::block_content (line 1022)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_ef2cb7e231c49e8daf5501931fbdca9c->doDisplay (line 104)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_6297c010a53f63744e41abbc583e9409->doDisplay (line 149)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\LandingPageController->home (line 144)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

3.90 ms
(0.37%)

SELECT t0.id AS id_1, t0.nota AS nota_2, t0.note_type AS note_type_3, t0.investigation_round AS investigation_round_4, t0.created_at AS created_at_5, t0.created_by_id AS created_by_id_6, t0.investigation_l1_id AS investigation_l1_id_7, t0.investigation_l2_id AS investigation_l2_id_8, t0.investigation_l3_id AS investigation_l3_id_9, t0.variation_investigation_l1_id AS variation_investigation_l1_id_10, t0.variation_investigation_l2_id AS variation_investigation_l2_id_11, t0.variation_investigation_l3_id AS variation_investigation_l3_id_12, t0.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_13, t0.maintenance_investigation_l2_id AS maintenance_investigation_l2_id_14, t0.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_15 FROM investigation_note_history t0 WHERE t0.investigation_l3_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nota AS nota_2,
  t0.note_type AS note_type_3,
  t0.investigation_round AS investigation_round_4,
  t0.created_at AS created_at_5,
  t0.created_by_id AS created_by_id_6,
  t0.investigation_l1_id AS investigation_l1_id_7,
  t0.investigation_l2_id AS investigation_l2_id_8,
  t0.investigation_l3_id AS investigation_l3_id_9,
  t0.variation_investigation_l1_id AS variation_investigation_l1_id_10,
  t0.variation_investigation_l2_id AS variation_investigation_l2_id_11,
  t0.variation_investigation_l3_id AS variation_investigation_l3_id_12,
  t0.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_13,
  t0.maintenance_investigation_l2_id AS maintenance_investigation_l2_id_14,
  t0.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_15
FROM
  investigation_note_history t0
WHERE
  t0.investigation_l3_id = ?

SELECT t0.id AS id_1, t0.nota AS nota_2, t0.note_type AS note_type_3, t0.investigation_round AS investigation_round_4, t0.created_at AS created_at_5, t0.created_by_id AS created_by_id_6, t0.investigation_l1_id AS investigation_l1_id_7, t0.investigation_l2_id AS investigation_l2_id_8, t0.investigation_l3_id AS investigation_l3_id_9, t0.variation_investigation_l1_id AS variation_investigation_l1_id_10, t0.variation_investigation_l2_id AS variation_investigation_l2_id_11, t0.variation_investigation_l3_id AS variation_investigation_l3_id_12, t0.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_13, t0.maintenance_investigation_l2_id AS maintenance_investigation_l2_id_14, t0.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_15 FROM investigation_note_history t0 WHERE t0.investigation_l3_id = 3;

#	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 313)
9	App\Entity\AccreditationApplication->getIntegrationNotes (line 1053)
10	Twig\Extension\CoreExtension->getAttribute (line 1913)
11	__TwigTemplate_6297c010a53f63744e41abbc583e9409::block_content (line 1022)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_ef2cb7e231c49e8daf5501931fbdca9c->doDisplay (line 104)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_6297c010a53f63744e41abbc583e9409->doDisplay (line 149)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\LandingPageController->home (line 144)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

3.29 ms
(0.31%)

SELECT t0.identifier AS identifier_1, t0.provider AS provider_2, t0.username AS username_3, t0.email AS email_4, t0.pec AS pec_5, t0.cellular AS cellular_6, t0.fiscal_code AS fiscal_code_7, t0.password AS password_8, t0.last_access AS last_access_9, t0.is_user_suspended AS is_user_suspended_10, t0.id AS id_11, t0.active AS active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.person_id AS person_id_16, t0.last_operating_institution_id AS last_operating_institution_id_17 FROM user t0 WHERE t0.id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.identifier AS identifier_1,
  t0.provider AS provider_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.pec AS pec_5,
  t0.cellular AS cellular_6,
  t0.fiscal_code AS fiscal_code_7,
  t0.password AS password_8,
  t0.last_access AS last_access_9,
  t0.is_user_suspended AS is_user_suspended_10,
  t0.id AS id_11,
  t0.active AS active_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.person_id AS person_id_16,
  t0.last_operating_institution_id AS last_operating_institution_id_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.identifier AS identifier_1, t0.provider AS provider_2, t0.username AS username_3, t0.email AS email_4, t0.pec AS pec_5, t0.cellular AS cellular_6, t0.fiscal_code AS fiscal_code_7, t0.password AS password_8, t0.last_access AS last_access_9, t0.is_user_suspended AS is_user_suspended_10, t0.id AS id_11, t0.active AS active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.person_id AS person_id_16, t0.last_operating_institution_id AS last_operating_institution_id_17 FROM user t0 WHERE t0.id = 15;

#	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\EntityManager->find (line 366)
6	Doctrine\ORM\EntityRepository->find (line 86)
7	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
8	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
9	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
10	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 74)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
14	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
15	Symfony\Bundle\SecurityBundle\Security->getToken (line 68)
16	Symfony\Bundle\SecurityBundle\Security->getUser (line 50)
17	App\EventListener\RoleBaseRedirectListener->onKernelRequest (line 30)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

3.11 ms
(0.30%)

SELECT a0_.code AS code_0, a0_.type AS type_1, a0_.status AS status_2, a0_.sampling_date AS sampling_date_3, a0_.verification_date AS verification_date_4, a0_.nota_complessiva AS nota_complessiva_5, a0_.note_programmazione AS note_programmazione_6, a0_.revision_note AS revision_note_7, a0_.revision_note_at AS revision_note_at_8, a0_.assigned_at AS assigned_at_9, a0_.started_at AS started_at_10, a0_.completed_at AS completed_at_11, a0_.archived_at AS archived_at_12, a0_.verbale_esito AS verbale_esito_13, a0_.verbale_generated_at AS verbale_generated_at_14, a0_.verbale_firmato_at AS verbale_firmato_at_15, a0_.awaiting_verbale_firmato AS awaiting_verbale_firmato_16, a0_.viewed_by_auditor AS viewed_by_auditor_17, a0_.viewed_by_controllo AS viewed_by_controllo_18, a0_.viewed_by_programmazione AS viewed_by_programmazione_19, a0_.id AS id_20, a0_.active AS active_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23, a0_.deleted_at AS deleted_at_24, a0_.institution_id AS institution_id_25, a0_.assigned_to_id AS assigned_to_id_26, a0_.source_maintenance_request_id AS source_maintenance_request_id_27, a0_.verbale_firmato_id AS verbale_firmato_id_28 FROM audit_request a0_ WHERE a0_.institution_id = ? ORDER BY a0_.created_at DESC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.code AS code_0,
  a0_.type AS type_1,
  a0_.status AS status_2,
  a0_.sampling_date AS sampling_date_3,
  a0_.verification_date AS verification_date_4,
  a0_.nota_complessiva AS nota_complessiva_5,
  a0_.note_programmazione AS note_programmazione_6,
  a0_.revision_note AS revision_note_7,
  a0_.revision_note_at AS revision_note_at_8,
  a0_.assigned_at AS assigned_at_9,
  a0_.started_at AS started_at_10,
  a0_.completed_at AS completed_at_11,
  a0_.archived_at AS archived_at_12,
  a0_.verbale_esito AS verbale_esito_13,
  a0_.verbale_generated_at AS verbale_generated_at_14,
  a0_.verbale_firmato_at AS verbale_firmato_at_15,
  a0_.awaiting_verbale_firmato AS awaiting_verbale_firmato_16,
  a0_.viewed_by_auditor AS viewed_by_auditor_17,
  a0_.viewed_by_controllo AS viewed_by_controllo_18,
  a0_.viewed_by_programmazione AS viewed_by_programmazione_19,
  a0_.id AS id_20,
  a0_.active AS active_21,
  a0_.created_at AS created_at_22,
  a0_.updated_at AS updated_at_23,
  a0_.deleted_at AS deleted_at_24,
  a0_.institution_id AS institution_id_25,
  a0_.assigned_to_id AS assigned_to_id_26,
  a0_.source_maintenance_request_id AS source_maintenance_request_id_27,
  a0_.verbale_firmato_id AS verbale_firmato_id_28
FROM
  audit_request a0_
WHERE
  a0_.institution_id = ?
ORDER BY
  a0_.created_at DESC

SELECT a0_.code AS code_0, a0_.type AS type_1, a0_.status AS status_2, a0_.sampling_date AS sampling_date_3, a0_.verification_date AS verification_date_4, a0_.nota_complessiva AS nota_complessiva_5, a0_.note_programmazione AS note_programmazione_6, a0_.revision_note AS revision_note_7, a0_.revision_note_at AS revision_note_at_8, a0_.assigned_at AS assigned_at_9, a0_.started_at AS started_at_10, a0_.completed_at AS completed_at_11, a0_.archived_at AS archived_at_12, a0_.verbale_esito AS verbale_esito_13, a0_.verbale_generated_at AS verbale_generated_at_14, a0_.verbale_firmato_at AS verbale_firmato_at_15, a0_.awaiting_verbale_firmato AS awaiting_verbale_firmato_16, a0_.viewed_by_auditor AS viewed_by_auditor_17, a0_.viewed_by_controllo AS viewed_by_controllo_18, a0_.viewed_by_programmazione AS viewed_by_programmazione_19, a0_.id AS id_20, a0_.active AS active_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23, a0_.deleted_at AS deleted_at_24, a0_.institution_id AS institution_id_25, a0_.assigned_to_id AS assigned_to_id_26, a0_.source_maintenance_request_id AS source_maintenance_request_id_27, a0_.verbale_firmato_id AS verbale_firmato_id_28 FROM audit_request a0_ WHERE a0_.institution_id = 2 ORDER BY a0_.created_at DESC;

#	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\Repository\AuditRequestRepository->findByInstitution (line 42)
9	App\Controller\LandingPageController->loadCasesForLegalOwner (line 971)
10	App\Controller\LandingPageController->loadCasesForRole (line 261)
11	App\Controller\LandingPageController->home (line 114)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

2.59 ms
(0.25%)

SELECT t0.id AS id_1, t0.nota AS nota_2, t0.note_type AS note_type_3, t0.investigation_round AS investigation_round_4, t0.created_at AS created_at_5, t0.created_by_id AS created_by_id_6, t0.investigation_l1_id AS investigation_l1_id_7, t0.investigation_l2_id AS investigation_l2_id_8, t0.investigation_l3_id AS investigation_l3_id_9, t0.variation_investigation_l1_id AS variation_investigation_l1_id_10, t0.variation_investigation_l2_id AS variation_investigation_l2_id_11, t0.variation_investigation_l3_id AS variation_investigation_l3_id_12, t0.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_13, t0.maintenance_investigation_l2_id AS maintenance_investigation_l2_id_14, t0.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_15 FROM investigation_note_history t0 WHERE t0.investigation_l2_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nota AS nota_2,
  t0.note_type AS note_type_3,
  t0.investigation_round AS investigation_round_4,
  t0.created_at AS created_at_5,
  t0.created_by_id AS created_by_id_6,
  t0.investigation_l1_id AS investigation_l1_id_7,
  t0.investigation_l2_id AS investigation_l2_id_8,
  t0.investigation_l3_id AS investigation_l3_id_9,
  t0.variation_investigation_l1_id AS variation_investigation_l1_id_10,
  t0.variation_investigation_l2_id AS variation_investigation_l2_id_11,
  t0.variation_investigation_l3_id AS variation_investigation_l3_id_12,
  t0.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_13,
  t0.maintenance_investigation_l2_id AS maintenance_investigation_l2_id_14,
  t0.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_15
FROM
  investigation_note_history t0
WHERE
  t0.investigation_l2_id = ?

SELECT t0.id AS id_1, t0.nota AS nota_2, t0.note_type AS note_type_3, t0.investigation_round AS investigation_round_4, t0.created_at AS created_at_5, t0.created_by_id AS created_by_id_6, t0.investigation_l1_id AS investigation_l1_id_7, t0.investigation_l2_id AS investigation_l2_id_8, t0.investigation_l3_id AS investigation_l3_id_9, t0.variation_investigation_l1_id AS variation_investigation_l1_id_10, t0.variation_investigation_l2_id AS variation_investigation_l2_id_11, t0.variation_investigation_l3_id AS variation_investigation_l3_id_12, t0.maintenance_investigation_l1_id AS maintenance_investigation_l1_id_13, t0.maintenance_investigation_l2_id AS maintenance_investigation_l2_id_14, t0.maintenance_investigation_l3_id AS maintenance_investigation_l3_id_15 FROM investigation_note_history t0 WHERE t0.investigation_l2_id = 2;

#	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 313)
9	App\Entity\AccreditationApplication->getIntegrationNotes (line 1053)
10	Twig\Extension\CoreExtension->getAttribute (line 1913)
11	__TwigTemplate_6297c010a53f63744e41abbc583e9409::block_content (line 1022)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_ef2cb7e231c49e8daf5501931fbdca9c->doDisplay (line 104)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_6297c010a53f63744e41abbc583e9409->doDisplay (line 149)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\LandingPageController->home (line 144)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

2.47 ms
(0.24%)

SELECT a0_.status AS status_0, a0_.request_type AS request_type_1, a0_.code AS code_2, a0_.accreditation_type AS accreditation_type_3, a0_.score AS score_4, a0_.send_at AS send_at_5, a0_.determina_completed_at AS determina_completed_at_6, a0_.accreditation_end_date AS accreditation_end_date_7, a0_.renewal_notification_level AS renewal_notification_level_8, a0_.viewed_by_instructor_l1 AS viewed_by_instructor_l1_9, a0_.viewed_by_instructor_l2 AS viewed_by_instructor_l2_10, a0_.viewed_by_instructor_l3 AS viewed_by_instructor_l3_11, a0_.assignment_notification2_days_sent AS assignment_notification2_days_sent_12, a0_.assignment_notification25_days_sent AS assignment_notification25_days_sent_13, a0_.id AS id_14, a0_.active AS active_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.deleted_at AS deleted_at_18, a0_.institution_id AS institution_id_19, a0_.legal_owner_id AS legal_owner_id_20, a0_.institution_typology_id AS institution_typology_id_21, a0_.parent_application_id AS parent_application_id_22 FROM accreditation_application a0_ WHERE a0_.institution_id = ? AND a0_.status = ? AND a0_.id IN (SELECT MIN(a1_.id) AS sclr_23 FROM accreditation_application a1_ WHERE a1_.institution_id = ? GROUP BY a1_.accreditation_type)

Parameters:

[
  2
  "DETERMINA_COMPLETATA"
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.status AS status_0,
  a0_.request_type AS request_type_1,
  a0_.code AS code_2,
  a0_.accreditation_type AS accreditation_type_3,
  a0_.score AS score_4,
  a0_.send_at AS send_at_5,
  a0_.determina_completed_at AS determina_completed_at_6,
  a0_.accreditation_end_date AS accreditation_end_date_7,
  a0_.renewal_notification_level AS renewal_notification_level_8,
  a0_.viewed_by_instructor_l1 AS viewed_by_instructor_l1_9,
  a0_.viewed_by_instructor_l2 AS viewed_by_instructor_l2_10,
  a0_.viewed_by_instructor_l3 AS viewed_by_instructor_l3_11,
  a0_.assignment_notification2_days_sent AS assignment_notification2_days_sent_12,
  a0_.assignment_notification25_days_sent AS assignment_notification25_days_sent_13,
  a0_.id AS id_14,
  a0_.active AS active_15,
  a0_.created_at AS created_at_16,
  a0_.updated_at AS updated_at_17,
  a0_.deleted_at AS deleted_at_18,
  a0_.institution_id AS institution_id_19,
  a0_.legal_owner_id AS legal_owner_id_20,
  a0_.institution_typology_id AS institution_typology_id_21,
  a0_.parent_application_id AS parent_application_id_22
FROM
  accreditation_application a0_
WHERE
  a0_.institution_id = ?
  AND a0_.status = ?
  AND a0_.id IN (
    SELECT
      MIN(a1_.id) AS sclr_23
    FROM
      accreditation_application a1_
    WHERE
      a1_.institution_id = ?
    GROUP BY
      a1_.accreditation_type
  )

SELECT a0_.status AS status_0, a0_.request_type AS request_type_1, a0_.code AS code_2, a0_.accreditation_type AS accreditation_type_3, a0_.score AS score_4, a0_.send_at AS send_at_5, a0_.determina_completed_at AS determina_completed_at_6, a0_.accreditation_end_date AS accreditation_end_date_7, a0_.renewal_notification_level AS renewal_notification_level_8, a0_.viewed_by_instructor_l1 AS viewed_by_instructor_l1_9, a0_.viewed_by_instructor_l2 AS viewed_by_instructor_l2_10, a0_.viewed_by_instructor_l3 AS viewed_by_instructor_l3_11, a0_.assignment_notification2_days_sent AS assignment_notification2_days_sent_12, a0_.assignment_notification25_days_sent AS assignment_notification25_days_sent_13, a0_.id AS id_14, a0_.active AS active_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.deleted_at AS deleted_at_18, a0_.institution_id AS institution_id_19, a0_.legal_owner_id AS legal_owner_id_20, a0_.institution_typology_id AS institution_typology_id_21, a0_.parent_application_id AS parent_application_id_22 FROM accreditation_application a0_ WHERE a0_.institution_id = 2 AND a0_.status = 'DETERMINA_COMPLETATA' AND a0_.id IN (SELECT MIN(a1_.id) AS sclr_23 FROM accreditation_application a1_ WHERE a1_.institution_id = 2 GROUP BY a1_.accreditation_type);

#	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\DocumentiInVigenzaService->getDocumentiInVigenzaPerInstitution (line 91)
9	App\Service\DocumentiInVigenzaService->getDocumentiInVigenzaPerLegalOwner (line 74)
10	App\Controller\LandingPageController->home (line 136)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

2.29 ms
(0.22%)

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM accreditation_investigation_l1 a1_ INNER JOIN accreditation_application a0_ ON a1_.accreditation_application_id = a0_.id WHERE a1_.assigned_to_id = ? AND a0_.status IN (?, ?, ?)

Parameters:

[
  6
  "L1_ASSIGNED"
  "L1_UNDER_INVESTIGATION"
  "L1_REQUESTED_INTEGRATION"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  accreditation_investigation_l1 a1_
  INNER JOIN accreditation_application a0_ ON a1_.accreditation_application_id = a0_.id
WHERE
  a1_.assigned_to_id = ?
  AND a0_.status IN (?, ?, ?)

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM accreditation_investigation_l1 a1_ INNER JOIN accreditation_application a0_ ON a1_.accreditation_application_id = a0_.id WHERE a1_.assigned_to_id = 6 AND a0_.status IN ('L1_ASSIGNED', 'L1_UNDER_INVESTIGATION', 'L1_REQUESTED_INTEGRATION');

#	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->getSingleResult (line 772)
8	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
9	App\Repository\UserRepository->findTrainerL1Users (line 197)
10	App\Controller\LandingPageController->loadTrainers (line 517)
11	App\Controller\LandingPageController->home (line 122)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

2.12 ms
(0.20%)

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.id AS id_24, t9.active AS active_25, t9.created_at AS created_at_26, t9.updated_at AS updated_at_27, t9.deleted_at AS deleted_at_28, t9.institution_id AS institution_id_29, t9.legal_owner_id AS legal_owner_id_30, t9.institution_typology_id AS institution_typology_id_31, t9.parent_application_id AS parent_application_id_32 FROM institutions_accreditation_type t0 LEFT JOIN accreditation_application t9 ON t9.institution_typology_id = t0.id WHERE t0.institution_id IN (?)

Parameters:

[
  2
]

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.id AS id_24,
  t9.active AS active_25,
  t9.created_at AS created_at_26,
  t9.updated_at AS updated_at_27,
  t9.deleted_at AS deleted_at_28,
  t9.institution_id AS institution_id_29,
  t9.legal_owner_id AS legal_owner_id_30,
  t9.institution_typology_id AS institution_typology_id_31,
  t9.parent_application_id AS parent_application_id_32
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.id AS id_24, t9.active AS active_25, t9.created_at AS created_at_26, t9.updated_at AS updated_at_27, t9.deleted_at AS deleted_at_28, t9.institution_id AS institution_id_29, t9.legal_owner_id AS legal_owner_id_30, t9.institution_typology_id AS institution_typology_id_31, t9.parent_application_id AS parent_application_id_32 FROM institutions_accreditation_type t0 LEFT JOIN accreditation_application t9 ON t9.institution_typology_id = t0.id WHERE t0.institution_id IN (2);

#	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\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1819)
10	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
11	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
12	Doctrine\ORM\PersistentCollection->initialize (line 186)
13	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
14	App\EventListener\InstitutionBlockedListener->getOperatingInstitution (line 237)
15	App\EventListener\InstitutionBlockedListener->__invoke (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

1.98 ms
(0.19%)

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.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.institution_id = ? ORDER BY t0.created_at DESC

Parameters:

[
  2
]

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.id AS id_15,
  t0.active AS active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t20.id AS id_21,
  t20.active AS active_22,
  t20.created_at AS created_at_23,
  t20.updated_at AS updated_at_24,
  t20.deleted_at AS deleted_at_25,
  t20.accreditation_application_id AS accreditation_application_id_26,
  t20.tipology_id AS tipology_id_27,
  t0.institution_id AS institution_id_28,
  t0.legal_owner_id AS legal_owner_id_29,
  t0.institution_typology_id AS institution_typology_id_30,
  t0.parent_application_id AS parent_application_id_31
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id
WHERE
  t0.institution_id = ?
ORDER BY
  t0.created_at DESC

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.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.institution_id = 2 ORDER BY t0.created_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\Controller\LandingPageController->loadCasesForLegalOwner (line 913)
7	App\Controller\LandingPageController->loadCasesForRole (line 261)
8	App\Controller\LandingPageController->home (line 114)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.90 ms
(0.18%)

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.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.institution_id IN (?)

Parameters:

[
  2
]

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.id AS id_15,
  t0.active AS active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t20.id AS id_21,
  t20.active AS active_22,
  t20.created_at AS created_at_23,
  t20.updated_at AS updated_at_24,
  t20.deleted_at AS deleted_at_25,
  t20.accreditation_application_id AS accreditation_application_id_26,
  t20.tipology_id AS tipology_id_27,
  t0.institution_id AS institution_id_28,
  t0.legal_owner_id AS legal_owner_id_29,
  t0.institution_typology_id AS institution_typology_id_30,
  t0.parent_application_id AS parent_application_id_31
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t20 ON t20.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.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.institution_id IN (2);

#	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\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1819)
10	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
11	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
12	Doctrine\ORM\PersistentCollection->initialize (line 186)
13	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
14	App\EventListener\InstitutionBlockedListener->getOperatingInstitution (line 237)
15	App\EventListener\InstitutionBlockedListener->__invoke (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

1.82 ms
(0.17%)

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:

[
  15
]

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

#	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 59)
8	Proxies\__CG__\App\Entity\Person->__get (line 146)
9	App\Entity\Person->getLegalOwner (line 234)
10	App\EventListener\InstitutionBlockedListener->getOperatingInstitution (line 231)
11	App\EventListener\InstitutionBlockedListener->__invoke (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.77 ms
(0.17%)

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM temporary_office_investigation_l1 t1_ INNER JOIN temporary_office_request t0_ ON t1_.temporary_office_request_id = t0_.id WHERE t1_.assigned_to_id = ? AND t0_.status IN (?, ?, ?)

Parameters:

[
  6
  "L1_ASSIGNED"
  "L1_UNDER_INVESTIGATION"
  "L1_REQUESTED_INTEGRATION"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  temporary_office_investigation_l1 t1_
  INNER JOIN temporary_office_request t0_ ON t1_.temporary_office_request_id = t0_.id
WHERE
  t1_.assigned_to_id = ?
  AND t0_.status IN (?, ?, ?)

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM temporary_office_investigation_l1 t1_ INNER JOIN temporary_office_request t0_ ON t1_.temporary_office_request_id = t0_.id WHERE t1_.assigned_to_id = 6 AND t0_.status IN ('L1_ASSIGNED', 'L1_UNDER_INVESTIGATION', 'L1_REQUESTED_INTEGRATION');

#	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->getSingleResult (line 772)
8	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
9	App\Repository\UserRepository->findTrainerL1Users (line 233)
10	App\Controller\LandingPageController->loadTrainers (line 517)
11	App\Controller\LandingPageController->home (line 122)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

1.60 ms
(0.15%)

SELECT t0.name AS name_1, t0.tax_code AS tax_code_2, t0.fiscal_code AS fiscal_code_3, t0.pec_address AS pec_address_4, t0.email_address AS email_address_5, t0.telephone AS telephone_6, t0.telephone_mobile AS telephone_mobile_7, t0.operating AS operating_8, t0.status AS status_9, t0.id AS id_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.legal_form_id AS legal_form_id_15, t0.institution_size_id AS institution_size_id_16, t0.ateco_code_version_id AS ateco_code_version_id_17, t0.legal_owner_id AS legal_owner_id_18 FROM institutions t0 WHERE t0.operating = ? AND t0.legal_owner_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.tax_code AS tax_code_2,
  t0.fiscal_code AS fiscal_code_3,
  t0.pec_address AS pec_address_4,
  t0.email_address AS email_address_5,
  t0.telephone AS telephone_6,
  t0.telephone_mobile AS telephone_mobile_7,
  t0.operating AS operating_8,
  t0.status AS status_9,
  t0.id AS id_10,
  t0.active AS active_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.legal_form_id AS legal_form_id_15,
  t0.institution_size_id AS institution_size_id_16,
  t0.ateco_code_version_id AS ateco_code_version_id_17,
  t0.legal_owner_id AS legal_owner_id_18
FROM
  institutions t0
WHERE
  t0.operating = ?
  AND t0.legal_owner_id = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.tax_code AS tax_code_2, t0.fiscal_code AS fiscal_code_3, t0.pec_address AS pec_address_4, t0.email_address AS email_address_5, t0.telephone AS telephone_6, t0.telephone_mobile AS telephone_mobile_7, t0.operating AS operating_8, t0.status AS status_9, t0.id AS id_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.legal_form_id AS legal_form_id_15, t0.institution_size_id AS institution_size_id_16, t0.ateco_code_version_id AS ateco_code_version_id_17, t0.legal_owner_id AS legal_owner_id_18 FROM institutions t0 WHERE t0.operating = 1 AND t0.legal_owner_id = 1 LIMIT 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\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	App\Twig\Extension\EnteOperatingExtension->getEnteOperating (line 75)
7	App\Twig\Extension\EnteOperatingExtension->getGlobals (line 39)
8	Twig\ExtensionSet->getGlobals (line 361)
9	Twig\Environment->getGlobals (line 908)
10	Twig\Template->yield (line 398)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
18	App\Controller\LandingPageController->home (line 144)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

1.57 ms
(0.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 = ? ORDER BY t0.created_at DESC

Parameters:

[
  2
]

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 = ?
ORDER BY
  t0.created_at DESC

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 = 2 ORDER BY t0.created_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\Controller\LandingPageController->loadCasesForLegalOwner (line 926)
7	App\Controller\LandingPageController->loadCasesForRole (line 261)
8	App\Controller\LandingPageController->home (line 114)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.45 ms
(0.14%)

SELECT n0_.id AS id_0, n0_.titolo AS titolo_1, n0_.messaggio AS messaggio_2, n0_.data_creazione AS data_creazione_3, n0_.data_lettura AS data_lettura_4, n0_.letta AS letta_5, n0_.tipo AS tipo_6, n0_.priorita AS priorita_7, n0_.dati_aggiuntivi AS dati_aggiuntivi_8, n0_.link AS link_9, n0_.presa_visione_obbligatoria AS presa_visione_obbligatoria_10, n0_.acknowledged_at AS acknowledged_at_11, n0_.utente_id AS utente_id_12, n0_.creatore_id AS creatore_id_13, n0_.acknowledged_by_id AS acknowledged_by_id_14 FROM notification n0_ WHERE n0_.utente_id = ? ORDER BY n0_.id DESC

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.titolo AS titolo_1,
  n0_.messaggio AS messaggio_2,
  n0_.data_creazione AS data_creazione_3,
  n0_.data_lettura AS data_lettura_4,
  n0_.letta AS letta_5,
  n0_.tipo AS tipo_6,
  n0_.priorita AS priorita_7,
  n0_.dati_aggiuntivi AS dati_aggiuntivi_8,
  n0_.link AS link_9,
  n0_.presa_visione_obbligatoria AS presa_visione_obbligatoria_10,
  n0_.acknowledged_at AS acknowledged_at_11,
  n0_.utente_id AS utente_id_12,
  n0_.creatore_id AS creatore_id_13,
  n0_.acknowledged_by_id AS acknowledged_by_id_14
FROM
  notification n0_
WHERE
  n0_.utente_id = ?
ORDER BY
  n0_.id DESC

SELECT n0_.id AS id_0, n0_.titolo AS titolo_1, n0_.messaggio AS messaggio_2, n0_.data_creazione AS data_creazione_3, n0_.data_lettura AS data_lettura_4, n0_.letta AS letta_5, n0_.tipo AS tipo_6, n0_.priorita AS priorita_7, n0_.dati_aggiuntivi AS dati_aggiuntivi_8, n0_.link AS link_9, n0_.presa_visione_obbligatoria AS presa_visione_obbligatoria_10, n0_.acknowledged_at AS acknowledged_at_11, n0_.utente_id AS utente_id_12, n0_.creatore_id AS creatore_id_13, n0_.acknowledged_by_id AS acknowledged_by_id_14 FROM notification n0_ WHERE n0_.utente_id = 15 ORDER BY n0_.id DESC;

#	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\Repository\NotificationRepository->getNotificationsForUserAndInstitution (line 72)
9	App\Controller\LandingPageController->preparePaginators (line 397)
10	App\Controller\LandingPageController->home (line 119)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

1.39 ms
(0.13%)

SELECT COUNT(DISTINCT m0_.id) AS sclr_0 FROM maintenance_investigation_l1 m1_ INNER JOIN maintenance_request m0_ ON m1_.maintenance_request_id = m0_.id WHERE m1_.assigned_to_id = ? AND m0_.status IN (?, ?, ?)

Parameters:

[
  6
  "L1_ASSIGNED"
  "L1_UNDER_INVESTIGATION"
  "L1_REQUESTED_INTEGRATION"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT m0_.id) AS sclr_0
FROM
  maintenance_investigation_l1 m1_
  INNER JOIN maintenance_request m0_ ON m1_.maintenance_request_id = m0_.id
WHERE
  m1_.assigned_to_id = ?
  AND m0_.status IN (?, ?, ?)

SELECT COUNT(DISTINCT m0_.id) AS sclr_0 FROM maintenance_investigation_l1 m1_ INNER JOIN maintenance_request m0_ ON m1_.maintenance_request_id = m0_.id WHERE m1_.assigned_to_id = 6 AND m0_.status IN ('L1_ASSIGNED', 'L1_UNDER_INVESTIGATION', 'L1_REQUESTED_INTEGRATION');

#	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->getSingleResult (line 772)
8	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
9	App\Repository\UserRepository->findTrainerL1Users (line 221)
10	App\Controller\LandingPageController->loadTrainers (line 517)
11	App\Controller\LandingPageController->home (line 122)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

1.34 ms
(0.13%)

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.created_at DESC

Parameters:

[
  2
]

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.created_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 = 2 ORDER BY t0.created_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\Controller\LandingPageController->loadCasesForLegalOwner (line 930)
7	App\Controller\LandingPageController->loadCasesForRole (line 261)
8	App\Controller\LandingPageController->home (line 114)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.33 ms
(0.13%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM role t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "ROLE_LEGALE_RAPPRESENTANTE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.label AS label_4
FROM
  role t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM role t0 WHERE t0.name = 'ROLE_LEGALE_RAPPRESENTANTE' LIMIT 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\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	App\Service\RoleManager->getRoleEntityByName (line 43)
7	App\Twig\Extension\RoleExtension->getRoleLabel (line 27)
8	__TwigTemplate_099fa7a54caee493e9767a7908b20511->doDisplay (line 89)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_ef2cb7e231c49e8daf5501931fbdca9c->doDisplay (line 87)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_6297c010a53f63744e41abbc583e9409->doDisplay (line 149)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
21	App\Controller\LandingPageController->home (line 144)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

1.29 ms
(0.12%)

SELECT COUNT(DISTINCT v0_.id) AS sclr_0 FROM variation_investigation_l1 v1_ INNER JOIN variation_request v0_ ON v1_.variation_request_id = v0_.id WHERE v1_.assigned_to_id = ? AND v0_.status IN (?, ?, ?)

Parameters:

[
  6
  "L1_ASSIGNED"
  "L1_UNDER_INVESTIGATION"
  "L1_REQUESTED_INTEGRATION"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT v0_.id) AS sclr_0
FROM
  variation_investigation_l1 v1_
  INNER JOIN variation_request v0_ ON v1_.variation_request_id = v0_.id
WHERE
  v1_.assigned_to_id = ?
  AND v0_.status IN (?, ?, ?)

SELECT COUNT(DISTINCT v0_.id) AS sclr_0 FROM variation_investigation_l1 v1_ INNER JOIN variation_request v0_ ON v1_.variation_request_id = v0_.id WHERE v1_.assigned_to_id = 6 AND v0_.status IN ('L1_ASSIGNED', 'L1_UNDER_INVESTIGATION', 'L1_REQUESTED_INTEGRATION');

#	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->getSingleResult (line 772)
8	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
9	App\Repository\UserRepository->findTrainerL1Users (line 209)
10	App\Controller\LandingPageController->loadTrainers (line 517)
11	App\Controller\LandingPageController->home (line 122)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

1.22 ms
(0.12%)

SELECT a0_.source_maintenance_request_id AS sclr_0 FROM audit_request a0_ WHERE a0_.source_maintenance_request_id IS NOT NULL AND a0_.status NOT IN (?, ?)

Parameters:

[
  "ARCHIVED_POSITIVE"
  "ARCHIVED_NEGATIVE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.source_maintenance_request_id AS sclr_0
FROM
  audit_request a0_
WHERE
  a0_.source_maintenance_request_id IS NOT NULL
  AND a0_.status NOT IN (?, ?)

SELECT a0_.source_maintenance_request_id AS sclr_0 FROM audit_request a0_ WHERE a0_.source_maintenance_request_id IS NOT NULL AND a0_.status NOT IN ('ARCHIVED_POSITIVE', 'ARCHIVED_NEGATIVE');

#	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->getScalarResult (line 724)
8	App\Repository\AuditRequestRepository->findActiveSourceMaintenanceIds (line 229)
9	App\Controller\LandingPageController->home (line 142)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

1.11 ms
(0.11%)

SELECT t0.code AS code_1, t0.description AS description_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 FROM accreditation_tipologies t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.description AS description_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
FROM
  accreditation_tipologies t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.description AS description_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 FROM accreditation_tipologies 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\AccreditationTipologies::Doctrine\ORM\Proxy\{closure} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
8	Proxies\__CG__\App\Entity\AccreditationTipologies->__get (line 146)
9	App\Entity\AccreditationTipologies->getCode (line 19)
10	App\Service\Balance\BalanceReclassificationService->isEnteObbligato (line 129)
11	App\Service\Balance\BalanceReclassificationService->isAlertActive (line 242)
12	App\Twig\Components\Balance\BalanceAlertComponent->postMount (line 39)
13	Symfony\UX\TwigComponent\ComponentFactory->postMount (line 199)
14	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 108)
15	Symfony\UX\TwigComponent\ComponentFactory->create (line 84)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
18	__TwigTemplate_6297c010a53f63744e41abbc583e9409->block_content (line 239)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_ef2cb7e231c49e8daf5501931fbdca9c->doDisplay (line 104)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_6297c010a53f63744e41abbc583e9409->doDisplay (line 149)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
31	App\Controller\LandingPageController->home (line 144)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 182)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 29)
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\InstitutionAccreditationTabs	501
App\Entity\RequirementMetadataField	428
App\Entity\AccreditationRequirement	130
App\Entity\Document	101
App\Entity\AccreditationDocumentReviewL3	96
App\Entity\RequirementDocumentType	96
App\Entity\DocumentType	93
App\Entity\Notification	8
App\Entity\User	6
App\Entity\Person	6
App\Entity\Role	4
App\Entity\AccreditationApplication	3
App\Entity\InstitutionAccreditationType	3
App\Entity\InstitutionAccreditationTipology	3
App\Entity\InstitutionType	3
App\Entity\AccreditationInvestigationL3	3
App\Entity\AccreditationOffice	3
App\Entity\AccreditationInvestigationL1	3
App\Entity\InvestigationDetermina	3
App\Entity\City	2
App\Entity\AccreditationInvestigationL2	2
App\Entity\Institution	1
App\Entity\Nation	1
App\Entity\LegalOwner	1
App\Entity\SignatureCertifier	1
App\Entity\LegalForms	1
App\Entity\InstitutionSize	1
App\Entity\AtecoCodeVersion	1
App\Entity\AccreditationTipologies	1
App\Entity\InstitutionOffice	1

Entities Mapping

Class	Mapping 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\Person	The mappings App\Entity\Person#personDocuments and App\Entity\PersonDocument#person are inconsistent with each other.
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\Role	No errors.
App\Entity\Notification	No errors.
App\Entity\SuspensionRevocation	No errors.
App\Entity\TemporaryOfficeValidityHistory	No errors.
App\Entity\Nation	No errors.
App\Entity\City	No errors.
App\Entity\LegalOwner	No errors.
App\Entity\SignatureCertifier	No errors.
App\Entity\IdentityDocument	No errors.
App\Entity\PersonDocument	No errors.
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\LegalForms	No errors.
App\Entity\InstitutionSize	No errors.
App\Entity\AtecoCodeVersion	No errors.
App\Entity\InstitutionAccreditationType	No errors.
App\Entity\VariationRequest	No errors.
App\Entity\InstitutionOffice	No errors.
App\Entity\InstitutionAccreditationTipology	No errors.
App\Entity\AccreditationTipologies	No errors.
App\Entity\InstitutionAccreditationMacrotype	No errors.
App\Entity\InstitutionSep	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\InstitutionSpecialUser	No errors.
App\Entity\JobService	No errors.
App\Entity\JobServiceSpecialist	No errors.
App\Entity\SignedApplicationDocument	No errors.
App\Entity\AccreditationOffice	No errors.
App\Entity\InstitutionType	No errors.
App\Entity\VariationInvestigationDetermina	No errors.
App\Entity\VariationInvestigationL3	No errors.
App\Entity\MaintenanceRequest	No errors.
App\Entity\AuditRequest	No errors.
App\Entity\VariationInvestigationL1	No errors.
App\Entity\MaintenanceInvestigationL1	No errors.
App\Entity\TemporaryOfficeInvestigationL1	No errors.
App\Entity\TemporaryOfficeRequest	The mappings App\Entity\TemporaryOfficeRequest#temporaryOfficeInvestigationL2s and App\Entity\TemporaryOfficeInvestigationL2#temporaryOfficeRequest are inconsistent with each other.
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\AccreditationRequirementMetaValue	No errors.
App\Entity\Requirement	No errors.
App\Entity\RequirementDocumentType	No errors.
App\Entity\AccreditationDocumentReviewL3	No errors.
App\Entity\ReviewNoteHistory	No errors.
App\Entity\DocumentType	No errors.
App\Entity\VariationDocumentReviewL3	No errors.
App\Entity\VariationRequirementDocument	No errors.
App\Entity\MaintenanceDocumentReviewL1	No errors.
App\Entity\MaintenanceDocument	No errors.
App\Entity\MaintenanceMetadataReviewL1	No errors.
App\Entity\MaintenanceRequestMetadata	No errors.
App\Entity\AccreditationDocumentReviewL1	No errors.
App\Entity\AccreditationMetadataReviewL1	No errors.
App\Entity\InvestigationNoteHistory	No errors.
App\Entity\VariationInvestigationL2	No errors.
App\Entity\MaintenanceInvestigationL2	No errors.
App\Entity\MaintenanceInvestigationL3	No errors.
App\Entity\InvestigationDetermina	No errors.
App\Entity\AccreditationMetadataReviewL3	No errors.
App\Entity\AccreditationDocumentReviewL2	No errors.
App\Entity\AccreditationMetadataReviewL2	No errors.
App\Entity\FieldGroup	No errors.

Symfony Profiler

GET https://sac-dev.schema31.it/home

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping