Symfony Profiler

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;

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;

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;

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;

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);

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);

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;

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;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.is_selectable AS is_selectable_3,
  t0.is_active AS is_active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.ateco_code_id AS ateco_code_id_7,
  t0.ateco_version_id AS ateco_version_id_8
FROM
  ateco_code_version t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.is_selectable AS is_selectable_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.ateco_code_id AS ateco_code_id_7, t0.ateco_version_id AS ateco_version_id_8 FROM ateco_code_version t0 WHERE t0.id = 1148;

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
  legal_forms 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 legal_forms t0 WHERE t0.id = 101;

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_size 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_size t0 WHERE t0.id = 2;

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;

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;

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