Symfony Profiler

Query Metrics

57 Database Queries

25 Different statements

137.19 ms Query time

4 Invalid entities

85 Managed entities

Queries


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

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\InstitutionSep	9
App\Entity\Sep	9
App\Entity\InstitutionAccreditationMacrotype	6
App\Entity\Macrotypologies	6
App\Entity\City	5
App\Entity\JobService	4
App\Entity\InstitutionOfficeStatus	4
App\Entity\AccreditationApplication	3
App\Entity\InstitutionAccreditationType	3
App\Entity\InstitutionAccreditationTipology	3
App\Entity\InstitutionType	3
App\Entity\AccreditationInvestigationL3	3
App\Entity\InvestigationDetermina	3
App\Entity\Document	3
App\Entity\JobServiceSpecialist	3
App\Entity\AccreditationOffice	3
App\Entity\User	2
App\Entity\Institution	1
App\Entity\LegalForms	1
App\Entity\InstitutionSize	1
App\Entity\AtecoCodeVersion	1
App\Entity\LegalOwner	1
App\Entity\AccreditationTipologies	1
App\Entity\Person	1
App\Entity\SignatureCertifier	1
App\Entity\Nation	1
App\Entity\InstitutionSpecialUser	1
App\Entity\SpecialUsers	1
App\Entity\InstitutionMacroType	1
App\Entity\InstitutionOffice	1

Entities Mapping

Class	Mapping errors
App\Entity\Institution	The field App\Entity\Institution#accreditationApplications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AccreditationApplication#institution does not contain the required 'inversedBy: "accreditationApplications"' attribute. The field App\Entity\Institution#institutionAccreditationTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\InstitutionAccreditationType#institution does not contain the required 'inversedBy: "institutionAccreditationTypes"' attribute.
App\Entity\AccreditationApplication	The field App\Entity\AccreditationApplication#institutionAccreditationTipology is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\InstitutionAccreditationTipology#accreditationApplication does not contain the required 'inversedBy: "institutionAccreditationTipology"' attribute. The mappings App\Entity\AccreditationApplication#jobServicesSpecialists and App\Entity\JobServiceSpecialist#accreditationApplication are inconsistent with each other.
App\Entity\LegalOwner	No errors.
App\Entity\Person	The mappings App\Entity\Person#personDocuments and App\Entity\PersonDocument#person are inconsistent with each other.
App\Entity\InstitutionOffice	No errors.
App\Entity\City	No errors.
App\Entity\InstitutionOfficeStatus	No errors.
App\Entity\AccreditationOffice	No errors.
App\Entity\InstitutionAccreditationTipology	No errors.
App\Entity\AccreditationTipologies	No errors.
App\Entity\InstitutionAccreditationMacrotype	No errors.
App\Entity\Macrotypologies	No errors.
App\Entity\InstitutionSep	No errors.
App\Entity\Sep	No errors.
App\Entity\InstitutionAccreditationType	No errors.
App\Entity\InstitutionType	No errors.
App\Entity\InstitutionMacroType	No errors.
App\Entity\InstitutionSpecialUser	No errors.
App\Entity\SpecialUsers	No errors.
App\Entity\JobService	No errors.
App\Entity\JobServiceSpecialist	No errors.
App\Entity\LegalForms	No errors.
App\Entity\InstitutionSize	No errors.
App\Entity\AtecoCodeVersion	No errors.
App\Entity\VariationRequest	No errors.
App\Entity\SuspensionRevocation	No errors.
App\Entity\InstitutionAccreditationTabs	No errors.
App\Entity\Document	No errors.
App\Entity\AccreditationInvestigationL1	No errors.
App\Entity\AccreditationInvestigationL2	No errors.
App\Entity\AccreditationInvestigationL3	No errors.
App\Entity\SignedApplicationDocument	No errors.
App\Entity\SignatureCertifier	No errors.
App\Entity\User	The field App\Entity\User#notificheRicevute is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Notification#utente does not contain the required 'inversedBy: "notificheRicevute"' attribute. The field App\Entity\User#notificheCreate is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Notification#creatore does not contain the required 'inversedBy: "notificheCreate"' attribute.
App\Entity\Nation	No errors.
App\Entity\IdentityDocument	No errors.
App\Entity\PersonDocument	No errors.
App\Entity\Role	No errors.
App\Entity\Notification	No errors.
App\Entity\TemporaryOfficeValidityHistory	No errors.
App\Entity\InvestigationDetermina	No errors.
App\Entity\InvestigationNoteHistory	No errors.
App\Entity\AccreditationDocumentReviewL3	No errors.
App\Entity\AccreditationMetadataReviewL3	No errors.
App\Entity\VariationInvestigationDetermina	No errors.
App\Entity\VariationInvestigationL3	No errors.
App\Entity\MaintenanceRequest	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping