32.95 ms
1
SELECT c0_ . name AS name_0 , c0_ . capital AS capital_1 , c0_ . inactive AS inactive_2 , c0_ . istat_code AS istat_code_3 , c0_ . cadastre_code AS cadastre_code_4 , c0_ . region_code AS region_code_5 , c0_ . province_code AS province_code_6 , c0_ . region_name AS region_name_7 , c0_ . province_name AS province_name_8 , c0_ . biletteral_code AS biletteral_code_9 , c0_ . id AS id_10 , c0_ . active AS active_11 , c0_ . created_at AS created_at_12 , c0_ . updated_at AS updated_at_13 , c0_ . deleted_at AS deleted_at_14 FROM cities c0_ WHERE c0_ . region_name = ? AND c0_ . capital = ? AND c0_ . inactive = ? ORDER BY c0_ . province_name ASC
Parameters :
[
"Lazio "
1
0
]
SELECT c0_ . name AS name_0 , c0_ . capital AS capital_1 , c0_ . inactive AS inactive_2 , c0_ . istat_code AS istat_code_3 , c0_ . cadastre_code AS cadastre_code_4 , c0_ . region_code AS region_code_5 , c0_ . province_code AS province_code_6 , c0_ . region_name AS region_name_7 , c0_ . province_name AS province_name_8 , c0_ . biletteral_code AS biletteral_code_9 , c0_ . id AS id_10 , c0_ . active AS active_11 , c0_ . created_at AS created_at_12 , c0_ . updated_at AS updated_at_13 , c0_ . deleted_at AS deleted_at_14 FROM cities c0_ WHERE c0_ . region_name = 'Lazio' AND c0_ . capital = 1 AND c0_ . inactive = 0 ORDER BY c0_ . province_name ASC ; Copy
30.11 ms
2
SELECT DISTINCT i0_ . name AS name_0 , i0_ . tax_code AS tax_code_1 , i0_ . fiscal_code AS fiscal_code_2 , i0_ . pec_address AS pec_address_3 , i0_ . email_address AS email_address_4 , i0_ . telephone AS telephone_5 , i0_ . telephone_mobile AS telephone_mobile_6 , i0_ . operating AS operating_7 , i0_ . status AS status_8 , i0_ . id AS id_9 , i0_ . active AS active_10 , i0_ . created_at AS created_at_11 , i0_ . updated_at AS updated_at_12 , i0_ . deleted_at AS deleted_at_13 , i0_ . legal_form_id AS legal_form_id_14 , i0_ . institution_size_id AS institution_size_id_15 , i0_ . ateco_code_version_id AS ateco_code_version_id_16 , i0_ . legal_owner_id AS legal_owner_id_17 FROM institutions i0_ INNER JOIN accreditation_application a1_ ON i0_ . id = a1_ . institution_id LEFT JOIN legal_owner l2_ ON i0_ . legal_owner_id = l2_ . id LEFT JOIN persons p3_ ON l2_ . person_id = p3_ . id LEFT JOIN institution_office i4_ ON i0_ . id = i4_ . institution_id LEFT JOIN cities c5_ ON i4_ . province = c5_ . id LEFT JOIN institution_office_status i6_ ON i4_ . id = i6_ . institution_office_id LEFT JOIN accreditation_office a7_ ON a1_ . id = a7_ . accreditation_application_id LEFT JOIN institutions_accreditation_tipologies i8_ ON a1_ . id = i8_ . accreditation_application_id LEFT JOIN accreditation_tipologies a9_ ON i8_ . tipology_id = a9_ . id LEFT JOIN institution_accreditation_macrotypes i10_ ON a1_ . id = i10_ . accreditation_application_id LEFT JOIN macrotypologies m11_ ON i10_ . macrotypologies_id = m11_ . id LEFT JOIN institutions_seps i12_ ON a1_ . id = i12_ . accreditation_application_id LEFT JOIN seps s13_ ON i12_ . sep_id = s13_ . id LEFT JOIN institutions_accreditation_type i14_ ON a1_ . institution_typology_id = i14_ . id LEFT JOIN institution_type i15_ ON i14_ . institution_type_id = i15_ . id LEFT JOIN institution_macro_type i16_ ON i15_ . institution_macro_type_id = i16_ . id LEFT JOIN institution_special_users i17_ ON a1_ . id = i17_ . accreditation_application_id LEFT JOIN special_users s18_ ON i17_ . special_users_id = s18_ . id LEFT JOIN job_service j19_ ON a1_ . id = j19_ . accreditation_application_id LEFT JOIN job_service_specialist j20_ ON a1_ . id = j20_ . accreditation_application_id WHERE i0_ . operating = ? AND a1_ . status IN (? ) AND i0_ . status IN (? , ? , ? ) ORDER BY i0_ . name ASC LIMIT 25
Parameters :
[
1
"DETERMINA_COMPLETATA "
"ACCREDITATO "
"SOSPESO "
"REVOCATO "
]
SELECT DISTINCT i0_ . name AS name_0 , i0_ . tax_code AS tax_code_1 , i0_ . fiscal_code AS fiscal_code_2 , i0_ . pec_address AS pec_address_3 , i0_ . email_address AS email_address_4 , i0_ . telephone AS telephone_5 , i0_ . telephone_mobile AS telephone_mobile_6 , i0_ . operating AS operating_7 , i0_ . status AS status_8 , i0_ . id AS id_9 , i0_ . active AS active_10 , i0_ . created_at AS created_at_11 , i0_ . updated_at AS updated_at_12 , i0_ . deleted_at AS deleted_at_13 , i0_ . legal_form_id AS legal_form_id_14 , i0_ . institution_size_id AS institution_size_id_15 , i0_ . ateco_code_version_id AS ateco_code_version_id_16 , i0_ . legal_owner_id AS legal_owner_id_17 FROM institutions i0_ INNER JOIN accreditation_application a1_ ON i0_ . id = a1_ . institution_id LEFT JOIN legal_owner l2_ ON i0_ . legal_owner_id = l2_ . id LEFT JOIN persons p3_ ON l2_ . person_id = p3_ . id LEFT JOIN institution_office i4_ ON i0_ . id = i4_ . institution_id LEFT JOIN cities c5_ ON i4_ . province = c5_ . id LEFT JOIN institution_office_status i6_ ON i4_ . id = i6_ . institution_office_id LEFT JOIN accreditation_office a7_ ON a1_ . id = a7_ . accreditation_application_id LEFT JOIN institutions_accreditation_tipologies i8_ ON a1_ . id = i8_ . accreditation_application_id LEFT JOIN accreditation_tipologies a9_ ON i8_ . tipology_id = a9_ . id LEFT JOIN institution_accreditation_macrotypes i10_ ON a1_ . id = i10_ . accreditation_application_id LEFT JOIN macrotypologies m11_ ON i10_ . macrotypologies_id = m11_ . id LEFT JOIN institutions_seps i12_ ON a1_ . id = i12_ . accreditation_application_id LEFT JOIN seps s13_ ON i12_ . sep_id = s13_ . id LEFT JOIN institutions_accreditation_type i14_ ON a1_ . institution_typology_id = i14_ . id LEFT JOIN institution_type i15_ ON i14_ . institution_type_id = i15_ . id LEFT JOIN institution_macro_type i16_ ON i15_ . institution_macro_type_id = i16_ . id LEFT JOIN institution_special_users i17_ ON a1_ . id = i17_ . accreditation_application_id LEFT JOIN special_users s18_ ON i17_ . special_users_id = s18_ . id LEFT JOIN job_service j19_ ON a1_ . id = j19_ . accreditation_application_id LEFT JOIN job_service_specialist j20_ ON a1_ . id = j20_ . accreditation_application_id WHERE i0_ . operating = 1 AND a1_ . status IN ('DETERMINA_COMPLETATA' ) AND i0_ . status IN ('ACCREDITATO' , 'SOSPESO' , 'REVOCATO' ) ORDER BY i0_ . name ASC LIMIT 25 ; Copy
9.66 ms
9
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 seps 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 seps t0 WHERE t0 . id = 25 ; Copy
9.24 ms
3
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 = 1 ; Copy
6.74 ms
6
SELECT t0 . code AS code_1 , t0 . context AS context_2 , t0 . description AS description_3 , t0 . id AS id_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 FROM macrotypologies t0 WHERE t0 . id = ?
SELECT t0 . code AS code_1 , t0 . context AS context_2 , t0 . description AS description_3 , t0 . id AS id_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 FROM macrotypologies t0 WHERE t0 . id = 1 ; Copy
4.47 ms
3
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 ; Copy
4.25 ms
3
SELECT t0 . id AS id_1 , t0 . description AS description_2 , t0 . accreditation_application_id AS accreditation_application_id_3 FROM job_service t0 WHERE t0 . accreditation_application_id = ?
SELECT t0 . id AS id_1 , t0 . description AS description_2 , t0 . accreditation_application_id AS accreditation_application_id_3 FROM job_service t0 WHERE t0 . accreditation_application_id = 1 ; Copy
4.15 ms
3
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 = 1 ; Copy
3.84 ms
3
SELECT t0 . id AS id_1 , t0 . description AS description_2 , t0 . accreditation_application_id AS accreditation_application_id_3 FROM job_service_specialist t0 WHERE t0 . accreditation_application_id = ?
SELECT t0 . id AS id_1 , t0 . description AS description_2 , t0 . accreditation_application_id AS accreditation_application_id_3 FROM job_service_specialist t0 WHERE t0 . accreditation_application_id = 1 ; Copy
3.69 ms
3
SELECT t0 . id AS id_1 , t0 . active AS active_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . accreditation_application_id AS accreditation_application_id_6 , t0 . macrotypologies_id AS macrotypologies_id_7 FROM institution_accreditation_macrotypes t0 WHERE t0 . accreditation_application_id = ?
SELECT t0 . id AS id_1 , t0 . active AS active_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . accreditation_application_id AS accreditation_application_id_6 , t0 . macrotypologies_id AS macrotypologies_id_7 FROM institution_accreditation_macrotypes t0 WHERE t0 . accreditation_application_id = 1 ; Copy
3.50 ms
3
SELECT t0 . description AS description_1 , t0 . context AS context_2 , t0 . legal_form AS legal_form_3 , t0 . id AS id_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . institution_macro_type_id AS institution_macro_type_id_9 FROM institution_type t0 WHERE t0 . id = ?
SELECT t0 . description AS description_1 , t0 . context AS context_2 , t0 . legal_form AS legal_form_3 , t0 . id AS id_4 , t0 . active AS active_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . deleted_at AS deleted_at_8 , t0 . institution_macro_type_id AS institution_macro_type_id_9 FROM institution_type t0 WHERE t0 . id = 4 ; Copy
3.37 ms
3
SELECT t0 . id AS id_1 , t0 . active AS active_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . accreditation_application_id AS accreditation_application_id_6 , t0 . special_users_id AS special_users_id_7 FROM institution_special_users t0 WHERE t0 . accreditation_application_id = ?
SELECT t0 . id AS id_1 , t0 . active AS active_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . accreditation_application_id AS accreditation_application_id_6 , t0 . special_users_id AS special_users_id_7 FROM institution_special_users t0 WHERE t0 . accreditation_application_id = 1 ; Copy
3.31 ms
3
SELECT t0 . id AS id_1 , t0 . active AS active_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . accreditation_application_id AS accreditation_application_id_6 , t0 . sep_id AS sep_id_7 FROM institutions_seps t0 WHERE t0 . accreditation_application_id = ?
SELECT t0 . id AS id_1 , t0 . active AS active_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . accreditation_application_id AS accreditation_application_id_6 , t0 . sep_id AS sep_id_7 FROM institutions_seps t0 WHERE t0 . accreditation_application_id = 1 ; Copy
2.86 ms
1
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 ); Copy
1.82 ms
1
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 ); Copy
1.57 ms
1
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 = ? Copy
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 ; Copy
1.55 ms
1
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . area AS area_3 , t0 . type AS type_4 , t0 . sub_type AS sub_type_5 , t0 . status AS status_6 , t0 . submitted_at AS submitted_at_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . is_documentary_investigation AS is_documentary_investigation_10 , t0 . viewed_by_instructor_l1 AS viewed_by_instructor_l1_11 , t0 . viewed_by_instructor_l2 AS viewed_by_instructor_l2_12 , t0 . viewed_by_instructor_l3 AS viewed_by_instructor_l3_13 , t0 . assignment_notification2_days_sent AS assignment_notification2_days_sent_14 , t0 . assignment_notification25_days_sent AS assignment_notification25_days_sent_15 , t0 . send_at AS send_at_16 , t0 . institution_id AS institution_id_17 , t18 . numero_determina AS numero_determina_19 , t18 . codice_protocollo AS codice_protocollo_20 , t18 . data_determina AS data_determina_21 , t18 . id AS id_22 , t18 . active AS active_23 , t18 . created_at AS created_at_24 , t18 . updated_at AS updated_at_25 , t18 . deleted_at AS deleted_at_26 , t18 . variation_investigation_l3_id AS variation_investigation_l3_id_27 , t18 . variation_request_id AS variation_request_id_28 , t18 . document_id AS document_id_29 FROM variation_request t0 LEFT JOIN variation_investigation_determina t18 ON t18 . variation_request_id = t0 . id WHERE t0 . institution_id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . area AS area_3 , t0 . type AS type_4 , t0 . sub_type AS sub_type_5 , t0 . status AS status_6 , t0 . submitted_at AS submitted_at_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . is_documentary_investigation AS is_documentary_investigation_10 , t0 . viewed_by_instructor_l1 AS viewed_by_instructor_l1_11 , t0 . viewed_by_instructor_l2 AS viewed_by_instructor_l2_12 , t0 . viewed_by_instructor_l3 AS viewed_by_instructor_l3_13 , t0 . assignment_notification2_days_sent AS assignment_notification2_days_sent_14 , t0 . assignment_notification25_days_sent AS assignment_notification25_days_sent_15 , t0 . send_at AS send_at_16 , t0 . institution_id AS institution_id_17 , t18 . numero_determina AS numero_determina_19 , t18 . codice_protocollo AS codice_protocollo_20 , t18 . data_determina AS data_determina_21 , t18 . id AS id_22 , t18 . active AS active_23 , t18 . created_at AS created_at_24 , t18 . updated_at AS updated_at_25 , t18 . deleted_at AS deleted_at_26 , t18 . variation_investigation_l3_id AS variation_investigation_l3_id_27 , t18 . variation_request_id AS variation_request_id_28 , t18 . document_id AS document_id_29 FROM variation_request t0 LEFT JOIN variation_investigation_determina t18 ON t18 . variation_request_id = t0 . id WHERE t0 . institution_id = 2 ; Copy
1.49 ms
1
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . maintenance_type AS maintenance_type_3 , t0 . accreditation_context AS accreditation_context_4 , t0 . status AS status_5 , t0 . send_at AS send_at_6 , t0 . reviewed_at AS reviewed_at_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . viewed_by_instructor_l1 AS viewed_by_instructor_l1_10 , t0 . viewed_by_instructor_l2 AS viewed_by_instructor_l2_11 , t0 . viewed_by_instructor_l3 AS viewed_by_instructor_l3_12 , t0 . is_admin_shadow AS is_admin_shadow_13 , t0 . assignment_notification2_days_sent AS assignment_notification2_days_sent_14 , t0 . assignment_notification25_days_sent AS assignment_notification25_days_sent_15 , t0 . determina_completed_at AS determina_completed_at_16 , t0 . integration_round AS integration_round_17 , t0 . institution_id AS institution_id_18 , t0 . accreditation_application_id AS accreditation_application_id_19 , t0 . office_id AS office_id_20 FROM maintenance_request t0 WHERE t0 . institution_id = ? ORDER BY t0 . send_at DESC
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . maintenance_type AS maintenance_type_3 , t0 . accreditation_context AS accreditation_context_4 , t0 . status AS status_5 , t0 . send_at AS send_at_6 , t0 . reviewed_at AS reviewed_at_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . viewed_by_instructor_l1 AS viewed_by_instructor_l1_10 , t0 . viewed_by_instructor_l2 AS viewed_by_instructor_l2_11 , t0 . viewed_by_instructor_l3 AS viewed_by_instructor_l3_12 , t0 . is_admin_shadow AS is_admin_shadow_13 , t0 . assignment_notification2_days_sent AS assignment_notification2_days_sent_14 , t0 . assignment_notification25_days_sent AS assignment_notification25_days_sent_15 , t0 . determina_completed_at AS determina_completed_at_16 , t0 . integration_round AS integration_round_17 , t0 . institution_id AS institution_id_18 , t0 . accreditation_application_id AS accreditation_application_id_19 , t0 . office_id AS office_id_20 FROM maintenance_request t0 WHERE t0 . institution_id = 2 ORDER BY t0 . send_at DESC ; Copy
1.41 ms
1
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 ; Copy
1.29 ms
1
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . sub_type AS sub_type_3 , t0 . context AS context_4 , t0 . status AS status_5 , t0 . tender_code AS tender_code_6 , t0 . temporary_validity_start_date AS temporary_validity_start_date_7 , t0 . temporary_validity_end_date AS temporary_validity_end_date_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . institution_office_id AS institution_office_id_11 FROM institution_office_status t0 WHERE t0 . institution_office_id = ?
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . sub_type AS sub_type_3 , t0 . context AS context_4 , t0 . status AS status_5 , t0 . tender_code AS tender_code_6 , t0 . temporary_validity_start_date AS temporary_validity_start_date_7 , t0 . temporary_validity_end_date AS temporary_validity_end_date_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . institution_office_id AS institution_office_id_11 FROM institution_office_status t0 WHERE t0 . institution_office_id = 2 ; Copy
1.25 ms
1
SELECT t0 . address AS address_1 , t0 . address_number AS address_number_2 , t0 . interior AS interior_3 , t0 . stair AS stair_4 , t0 . address_zip AS address_zip_5 , t0 . abroad AS abroad_6 , t0 . foreign_nation AS foreign_nation_7 , t0 . foreign_city AS foreign_city_8 , t0 . cadastral_sheet AS cadastral_sheet_9 , t0 . cadastral_parcel AS cadastral_parcel_10 , t0 . sub_unit AS sub_unit_11 , t0 . pec AS pec_12 , t0 . email AS email_13 , t0 . telephone AS telephone_14 , t0 . fax AS fax_15 , t0 . id AS id_16 , t0 . active AS active_17 , t0 . created_at AS created_at_18 , t0 . updated_at AS updated_at_19 , t0 . deleted_at AS deleted_at_20 , t0 . institution_id AS institution_id_21 , t0 . city AS city_22 , t0 . province AS province_23 FROM institution_office t0 WHERE t0 . institution_id = ?
SELECT t0 . address AS address_1 , t0 . address_number AS address_number_2 , t0 . interior AS interior_3 , t0 . stair AS stair_4 , t0 . address_zip AS address_zip_5 , t0 . abroad AS abroad_6 , t0 . foreign_nation AS foreign_nation_7 , t0 . foreign_city AS foreign_city_8 , t0 . cadastral_sheet AS cadastral_sheet_9 , t0 . cadastral_parcel AS cadastral_parcel_10 , t0 . sub_unit AS sub_unit_11 , t0 . pec AS pec_12 , t0 . email AS email_13 , t0 . telephone AS telephone_14 , t0 . fax AS fax_15 , t0 . id AS id_16 , t0 . active AS active_17 , t0 . created_at AS created_at_18 , t0 . updated_at AS updated_at_19 , t0 . deleted_at AS deleted_at_20 , t0 . institution_id AS institution_id_21 , t0 . city AS city_22 , t0 . province AS province_23 FROM institution_office t0 WHERE t0 . institution_id = 2 ; Copy
1.24 ms
1
SELECT t0 . name AS name_1 , t0 . capital AS capital_2 , t0 . inactive AS inactive_3 , t0 . istat_code AS istat_code_4 , t0 . cadastre_code AS cadastre_code_5 , t0 . region_code AS region_code_6 , t0 . province_code AS province_code_7 , t0 . region_name AS region_name_8 , t0 . province_name AS province_name_9 , t0 . biletteral_code AS biletteral_code_10 , t0 . 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 FROM cities t0 WHERE t0 . id = ?
SELECT t0 . name AS name_1 , t0 . capital AS capital_2 , t0 . inactive AS inactive_3 , t0 . istat_code AS istat_code_4 , t0 . cadastre_code AS cadastre_code_5 , t0 . region_code AS region_code_6 , t0 . province_code AS province_code_7 , t0 . region_name AS region_name_8 , t0 . province_name AS province_name_9 , t0 . biletteral_code AS biletteral_code_10 , t0 . 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 FROM cities t0 WHERE t0 . id = 16721 ; Copy
1.22 ms
1
SELECT t0 . signature_certificate_expires_on AS signature_certificate_expires_on_1 , t0 . signature_kit_notification_level AS signature_kit_notification_level_2 , t0 . id AS id_3 , t0 . active AS active_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . deleted_at AS deleted_at_7 , t0 . person_id AS person_id_8 , t0 . signature_certifier_id AS signature_certifier_id_9 FROM legal_owner t0 WHERE t0 . id = ?
SELECT t0 . signature_certificate_expires_on AS signature_certificate_expires_on_1 , t0 . signature_kit_notification_level AS signature_kit_notification_level_2 , t0 . id AS id_3 , t0 . active AS active_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . deleted_at AS deleted_at_7 , t0 . person_id AS person_id_8 , t0 . signature_certifier_id AS signature_certifier_id_9 FROM legal_owner t0 WHERE t0 . id = 1 ; Copy
1.15 ms
1
SELECT t0 . description AS description_1 , t0 . id AS id_2 , t0 . active AS active_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . deleted_at AS deleted_at_6 FROM institution_macro_type t0 WHERE t0 . id = ?
SELECT t0 . description AS description_1 , t0 . id AS id_2 , t0 . active AS active_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . deleted_at AS deleted_at_6 FROM institution_macro_type t0 WHERE t0 . id = 1 ; Copy
1.07 ms
1
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 special_users 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 special_users t0 WHERE t0 . id = 8 ; Copy