Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.username_canonical AS username_canonical_3,
  t0.email AS email_4,
  t0.email_canonical AS email_canonical_5,
  t0.enabled AS enabled_6,
  t0.salt AS salt_7,
  t0.password AS password_8,
  t0.last_login AS last_login_9,
  t0.confirmation_token AS confirmation_token_10,
  t0.password_requested_at AS password_requested_at_11,
  t0.roles AS roles_12,
  t0.first_name AS first_name_13,
  t0.last_name AS last_name_14,
  t0.role AS role_15,
  t0.organisation_structure AS organisation_structure_16
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.roles AS roles_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.role AS role_15, t0.organisation_structure AS organisation_structure_16 FROM `user` t0 WHERE t0.id = 10;

SELECT
  DISTINCT n0_.id AS id_0,
  n0_.year AS year_1
FROM
  new_report n0_
  LEFT JOIN auditor a1_ ON n0_.auditor_id = a1_.id
  LEFT JOIN auditor_detail a2_ ON a1_.current_detail_id = a2_.id
WHERE
  n0_.is_locked = ?
  AND n0_.deleted IS NULL
ORDER BY
  n0_.year DESC
LIMIT
  50

SELECT DISTINCT n0_.id AS id_0, n0_.year AS year_1 FROM new_report n0_ LEFT JOIN auditor a1_ ON n0_.auditor_id = a1_.id LEFT JOIN auditor_detail a2_ ON a1_.current_detail_id = a2_.id WHERE n0_.is_locked = 1 AND n0_.deleted IS NULL ORDER BY n0_.year DESC LIMIT 50;

SELECT
  n0_.id AS id_0,
  n0_.year AS year_1,
  n0_.created AS created_2,
  n0_.updated AS updated_3,
  n0_.with_financial_activity_pie AS with_financial_activity_pie_4,
  n0_.with_financial_activity_nonpie AS with_financial_activity_nonpie_5,
  n0_.with_financial_activity_without_statutory_audit AS with_financial_activity_without_statutory_audit_6,
  n0_.with_financial_activity_durability AS with_financial_activity_durability_7,
  n0_.without_financial_activity_non_audit AS without_financial_activity_non_audit_8,
  n0_.without_financial_activity AS without_financial_activity_9,
  n0_.non_active AS non_active_10,
  n0_.user_browser AS user_browser_11,
  n0_.completed AS completed_12,
  n0_.evisa_request AS evisa_request_13,
  n0_.evisa_request_file AS evisa_request_file_14,
  n0_.good_reputation_declaration_file AS good_reputation_declaration_file_15,
  n0_.professional_declaration_file AS professional_declaration_file_16,
  n0_.self_declaration AS self_declaration_17,
  n0_.agreement_declaration AS agreement_declaration_18,
  n0_.collaboration_with_financial_activity_pie AS collaboration_with_financial_activity_pie_19,
  n0_.incompatibility_legal_law AS incompatibility_legal_law_20,
  n0_.incompatibility_proof_file AS incompatibility_proof_file_21,
  n0_.is_locked AS is_locked_22,
  n0_.is_visa_processing AS is_visa_processing_23,
  n0_.sent AS sent_24,
  n0_.sent_id AS sent_id_25,
  n0_.visa_date_issued AS visa_date_issued_26,
  n0_.visa_date_validity AS visa_date_validity_27,
  n0_.deleted AS deleted_28,
  n0_.message_sent_back AS message_sent_back_29,
  n0_.sent_back_date AS sent_back_date_30,
  n0_.report_type AS report_type_31,
  n0_.change_activity_reason AS change_activity_reason_32,
  n0_.visa_cancelled AS visa_cancelled_33,
  n0_.visa_cancelled_reason AS visa_cancelled_reason_34,
  a1_.id AS id_35,
  a1_.rpe_number AS rpe_number_36,
  a1_.company_cif AS company_cif_37,
  a1_.authorisation_document_name AS authorisation_document_name_38,
  a1_.authorisation_document_number AS authorisation_document_number_39,
  a1_.authorisation_document_date AS authorisation_document_date_40,
  a1_.cafr_registry_number AS cafr_registry_number_41,
  a1_.cafr_registry_date AS cafr_registry_date_42,
  a1_.date_updated AS date_updated_43,
  a1_.date_created AS date_created_44,
  a1_.access_token AS access_token_45,
  a1_.access_token_expire AS access_token_expire_46,
  a1_.person_cnp AS person_cnp_47,
  a1_.comment AS comment_48,
  a1_.is_company AS is_company_49,
  a1_.has_privacy AS has_privacy_50,
  a1_.mentor_number_decree AS mentor_number_decree_51,
  a1_.mentor_document_decree AS mentor_document_decree_52,
  a1_.is_mentor AS is_mentor_53,
  a1_.durability AS durability_54,
  a1_.register_date AS register_date_55,
  a2_.id AS id_56,
  a2_.company_fiscal_attribute AS company_fiscal_attribute_57,
  a2_.person_first_name AS person_first_name_58,
  a2_.person_last_name AS person_last_name_59,
  a2_.company_name AS company_name_60,
  a2_.company_administrators_number AS company_administrators_number_61,
  a2_.company_registry_number AS company_registry_number_62,
  a2_.website AS website_63,
  a2_.email AS email_64,
  a2_.phone_fixed AS phone_fixed_65,
  a2_.phone_mobile AS phone_mobile_66,
  a2_.fax AS fax_67,
  a2_.date_created AS date_created_68,
  a2_.email2 AS email2_69,
  a2_.email3 AS email3_70,
  a2_.phone_fixed2 AS phone_fixed2_71,
  a2_.phone_fixed3 AS phone_fixed3_72,
  a2_.phone_mobile2 AS phone_mobile2_73,
  a2_.phone_mobile3 AS phone_mobile3_74,
  n0_.auditor_id AS auditor_id_75,
  n0_.step_id AS step_id_76,
  n0_.deleted_by_id AS deleted_by_id_77,
  n0_.parent_id AS parent_id_78,
  n0_.visa_cancelled_by_id AS visa_cancelled_by_id_79,
  a1_.current_detail_id AS current_detail_id_80,
  a2_.auditor_id AS auditor_id_81,
  a2_.update_request_id AS update_request_id_82,
  a2_.network_id AS network_id_83
FROM
  new_report n0_
  LEFT JOIN auditor a1_ ON n0_.auditor_id = a1_.id
  LEFT JOIN auditor_detail a2_ ON a1_.current_detail_id = a2_.id
WHERE
  n0_.is_locked = ?
  AND n0_.deleted IS NULL
  AND n0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  n0_.year DESC

SELECT n0_.id AS id_0, n0_.year AS year_1, n0_.created AS created_2, n0_.updated AS updated_3, n0_.with_financial_activity_pie AS with_financial_activity_pie_4, n0_.with_financial_activity_nonpie AS with_financial_activity_nonpie_5, n0_.with_financial_activity_without_statutory_audit AS with_financial_activity_without_statutory_audit_6, n0_.with_financial_activity_durability AS with_financial_activity_durability_7, n0_.without_financial_activity_non_audit AS without_financial_activity_non_audit_8, n0_.without_financial_activity AS without_financial_activity_9, n0_.non_active AS non_active_10, n0_.user_browser AS user_browser_11, n0_.completed AS completed_12, n0_.evisa_request AS evisa_request_13, n0_.evisa_request_file AS evisa_request_file_14, n0_.good_reputation_declaration_file AS good_reputation_declaration_file_15, n0_.professional_declaration_file AS professional_declaration_file_16, n0_.self_declaration AS self_declaration_17, n0_.agreement_declaration AS agreement_declaration_18, n0_.collaboration_with_financial_activity_pie AS collaboration_with_financial_activity_pie_19, n0_.incompatibility_legal_law AS incompatibility_legal_law_20, n0_.incompatibility_proof_file AS incompatibility_proof_file_21, n0_.is_locked AS is_locked_22, n0_.is_visa_processing AS is_visa_processing_23, n0_.sent AS sent_24, n0_.sent_id AS sent_id_25, n0_.visa_date_issued AS visa_date_issued_26, n0_.visa_date_validity AS visa_date_validity_27, n0_.deleted AS deleted_28, n0_.message_sent_back AS message_sent_back_29, n0_.sent_back_date AS sent_back_date_30, n0_.report_type AS report_type_31, n0_.change_activity_reason AS change_activity_reason_32, n0_.visa_cancelled AS visa_cancelled_33, n0_.visa_cancelled_reason AS visa_cancelled_reason_34, a1_.id AS id_35, a1_.rpe_number AS rpe_number_36, a1_.company_cif AS company_cif_37, a1_.authorisation_document_name AS authorisation_document_name_38, a1_.authorisation_document_number AS authorisation_document_number_39, a1_.authorisation_document_date AS authorisation_document_date_40, a1_.cafr_registry_number AS cafr_registry_number_41, a1_.cafr_registry_date AS cafr_registry_date_42, a1_.date_updated AS date_updated_43, a1_.date_created AS date_created_44, a1_.access_token AS access_token_45, a1_.access_token_expire AS access_token_expire_46, a1_.person_cnp AS person_cnp_47, a1_.comment AS comment_48, a1_.is_company AS is_company_49, a1_.has_privacy AS has_privacy_50, a1_.mentor_number_decree AS mentor_number_decree_51, a1_.mentor_document_decree AS mentor_document_decree_52, a1_.is_mentor AS is_mentor_53, a1_.durability AS durability_54, a1_.register_date AS register_date_55, a2_.id AS id_56, a2_.company_fiscal_attribute AS company_fiscal_attribute_57, a2_.person_first_name AS person_first_name_58, a2_.person_last_name AS person_last_name_59, a2_.company_name AS company_name_60, a2_.company_administrators_number AS company_administrators_number_61, a2_.company_registry_number AS company_registry_number_62, a2_.website AS website_63, a2_.email AS email_64, a2_.phone_fixed AS phone_fixed_65, a2_.phone_mobile AS phone_mobile_66, a2_.fax AS fax_67, a2_.date_created AS date_created_68, a2_.email2 AS email2_69, a2_.email3 AS email3_70, a2_.phone_fixed2 AS phone_fixed2_71, a2_.phone_fixed3 AS phone_fixed3_72, a2_.phone_mobile2 AS phone_mobile2_73, a2_.phone_mobile3 AS phone_mobile3_74, n0_.auditor_id AS auditor_id_75, n0_.step_id AS step_id_76, n0_.deleted_by_id AS deleted_by_id_77, n0_.parent_id AS parent_id_78, n0_.visa_cancelled_by_id AS visa_cancelled_by_id_79, a1_.current_detail_id AS current_detail_id_80, a2_.auditor_id AS auditor_id_81, a2_.update_request_id AS update_request_id_82, a2_.network_id AS network_id_83 FROM new_report n0_ LEFT JOIN auditor a1_ ON n0_.auditor_id = a1_.id LEFT JOIN auditor_detail a2_ ON a1_.current_detail_id = a2_.id WHERE n0_.is_locked = 1 AND n0_.deleted IS NULL AND n0_.id IN (11562, 14924, 11480, 14922, 11483, 11922, 11855, 11851, 11850, 14899, 11848, 13602, 11845, 11931, 13529, 11501, 12232, 12722, 12723, 11511, 11938, 11940, 11942, 14847, 14831, 11951, 12384, 12204, 12201, 12200, 12199, 11960, 12753, 11963, 11799, 14746, 14743, 12188, 14736, 13642, 12182, 12023, 12559, 13778, 12120, 11635, 12927, 11624, 13678, 12008) ORDER BY n0_.year DESC;

SELECT
  t0.id AS id_1,
  t0.auditor_company_name AS auditor_company_name_2,
  t0.auditor_name AS auditor_name_3,
  t0.auditor_company_type AS auditor_company_type_4,
  t0.auditor_company_cui AS auditor_company_cui_5,
  t0.auditor_cif AS auditor_cif_6,
  t0.cui_document_file AS cui_document_file_7,
  t0.rpe_nr AS rpe_nr_8,
  t0.rpe_document_file AS rpe_document_file_9,
  t0.cafr_nr AS cafr_nr_10,
  t0.cafr_document_file AS cafr_document_file_11,
  t0.auditor_identity_document_file AS auditor_identity_document_file_12,
  t0.auditor_website AS auditor_website_13,
  t0.auditor_photo_file AS auditor_photo_file_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.auditor_company_name_is_changed AS auditor_company_name_is_changed_17,
  t0.auditor_name_is_changed AS auditor_name_is_changed_18,
  t0.auditor_company_cui_is_changed AS auditor_company_cui_is_changed_19,
  t0.rpe_nr_is_changed AS rpe_nr_is_changed_20,
  t0.report_id AS report_id_21
FROM
  new_report_general_informations t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.auditor_company_name AS auditor_company_name_2, t0.auditor_name AS auditor_name_3, t0.auditor_company_type AS auditor_company_type_4, t0.auditor_company_cui AS auditor_company_cui_5, t0.auditor_cif AS auditor_cif_6, t0.cui_document_file AS cui_document_file_7, t0.rpe_nr AS rpe_nr_8, t0.rpe_document_file AS rpe_document_file_9, t0.cafr_nr AS cafr_nr_10, t0.cafr_document_file AS cafr_document_file_11, t0.auditor_identity_document_file AS auditor_identity_document_file_12, t0.auditor_website AS auditor_website_13, t0.auditor_photo_file AS auditor_photo_file_14, t0.created AS created_15, t0.updated AS updated_16, t0.auditor_company_name_is_changed AS auditor_company_name_is_changed_17, t0.auditor_name_is_changed AS auditor_name_is_changed_18, t0.auditor_company_cui_is_changed AS auditor_company_cui_is_changed_19, t0.rpe_nr_is_changed AS rpe_nr_is_changed_20, t0.report_id AS report_id_21 FROM new_report_general_informations t0 WHERE t0.report_id = 13602;

SELECT
  t0.id AS id_1,
  t0.is_authorised_in_eu AS is_authorised_in_eu_2,
  t0.eu_authority_name AS eu_authority_name_3,
  t0.eu_authorisation_nr AS eu_authorisation_nr_4,
  t0.eu_authorisation_date AS eu_authorisation_date_5,
  t0.is_authorised_in_non_eu AS is_authorised_in_non_eu_6,
  t0.non_eu_authority_name AS non_eu_authority_name_7,
  t0.non_eu_authorisation_nr AS non_eu_authorisation_nr_8,
  t0.non_eu_authorisation_date AS non_eu_authorisation_date_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.non_eu_registered_in_ro AS non_eu_registered_in_ro_12,
  t0.report_id AS report_id_13,
  t0.eu_country_id AS eu_country_id_14,
  t0.non_eu_country_id AS non_eu_country_id_15
FROM
  new_report_authorisations t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.is_authorised_in_eu AS is_authorised_in_eu_2, t0.eu_authority_name AS eu_authority_name_3, t0.eu_authorisation_nr AS eu_authorisation_nr_4, t0.eu_authorisation_date AS eu_authorisation_date_5, t0.is_authorised_in_non_eu AS is_authorised_in_non_eu_6, t0.non_eu_authority_name AS non_eu_authority_name_7, t0.non_eu_authorisation_nr AS non_eu_authorisation_nr_8, t0.non_eu_authorisation_date AS non_eu_authorisation_date_9, t0.created AS created_10, t0.updated AS updated_11, t0.non_eu_registered_in_ro AS non_eu_registered_in_ro_12, t0.report_id AS report_id_13, t0.eu_country_id AS eu_country_id_14, t0.non_eu_country_id AS non_eu_country_id_15 FROM new_report_authorisations t0 WHERE t0.report_id = 13602;

SELECT
  t0.id AS id_1,
  t0.is_part_of_ceccar AS is_part_of_ceccar_2,
  t0.ceccar_nr AS ceccar_nr_3,
  t0.is_part_of_ccf AS is_part_of_ccf_4,
  t0.ccf_nr AS ccf_nr_5,
  t0.is_part_of_anevar AS is_part_of_anevar_6,
  t0.anevar_nr AS anevar_nr_7,
  t0.is_part_of_unpir AS is_part_of_unpir_8,
  t0.unpir_nr AS unpir_nr_9,
  t0.is_part_of_other_organisations AS is_part_of_other_organisations_10,
  t0.other_organisation_name_1 AS other_organisation_name_1_11,
  t0.other_organisation_nr_1 AS other_organisation_nr_1_12,
  t0.other_organisation_name_2 AS other_organisation_name_2_13,
  t0.other_organisation_nr_2 AS other_organisation_nr_2_14,
  t0.other_organisation_name_3 AS other_organisation_name_3_15,
  t0.other_organisation_nr_3 AS other_organisation_nr_3_16,
  t0.created AS created_17,
  t0.updated AS updated_18,
  t0.report_id AS report_id_19
FROM
  new_report_other_organisations t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.is_part_of_ceccar AS is_part_of_ceccar_2, t0.ceccar_nr AS ceccar_nr_3, t0.is_part_of_ccf AS is_part_of_ccf_4, t0.ccf_nr AS ccf_nr_5, t0.is_part_of_anevar AS is_part_of_anevar_6, t0.anevar_nr AS anevar_nr_7, t0.is_part_of_unpir AS is_part_of_unpir_8, t0.unpir_nr AS unpir_nr_9, t0.is_part_of_other_organisations AS is_part_of_other_organisations_10, t0.other_organisation_name_1 AS other_organisation_name_1_11, t0.other_organisation_nr_1 AS other_organisation_nr_1_12, t0.other_organisation_name_2 AS other_organisation_name_2_13, t0.other_organisation_nr_2 AS other_organisation_nr_2_14, t0.other_organisation_name_3 AS other_organisation_name_3_15, t0.other_organisation_nr_3 AS other_organisation_nr_3_16, t0.created AS created_17, t0.updated AS updated_18, t0.report_id AS report_id_19 FROM new_report_other_organisations t0 WHERE t0.report_id = 13602;

SELECT
  t0.id AS id_1,
  t0.assoc_total AS assoc_total_2,
  t0.assoc_authorised_in_romania AS assoc_authorised_in_romania_3,
  t0.assoc_authorised_in_other_country AS assoc_authorised_in_other_country_4,
  t0.assoc_percentage AS assoc_percentage_5,
  t0.admins_total AS admins_total_6,
  t0.admins_authorised_in_romania AS admins_authorised_in_romania_7,
  t0.admins_authorised_in_other_country AS admins_authorised_in_other_country_8,
  t0.admins_percentage AS admins_percentage_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.assoc_are_changed AS assoc_are_changed_12,
  t0.admins_are_changed AS admins_are_changed_13,
  t0.report_id AS report_id_14
FROM
  new_report_auditors_structure t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.assoc_total AS assoc_total_2, t0.assoc_authorised_in_romania AS assoc_authorised_in_romania_3, t0.assoc_authorised_in_other_country AS assoc_authorised_in_other_country_4, t0.assoc_percentage AS assoc_percentage_5, t0.admins_total AS admins_total_6, t0.admins_authorised_in_romania AS admins_authorised_in_romania_7, t0.admins_authorised_in_other_country AS admins_authorised_in_other_country_8, t0.admins_percentage AS admins_percentage_9, t0.created AS created_10, t0.updated AS updated_11, t0.assoc_are_changed AS assoc_are_changed_12, t0.admins_are_changed AS admins_are_changed_13, t0.report_id AS report_id_14 FROM new_report_auditors_structure t0 WHERE t0.report_id = 13602;

SELECT
  t0.id AS id_1,
  t0.employees_total AS employees_total_2,
  t0.employees_works_in_audit AS employees_works_in_audit_3,
  t0.employees_auditors AS employees_auditors_4,
  t0.employees_audit_partners AS employees_audit_partners_5,
  t0.created AS created_6,
  t0.updated AS updated_7,
  t0.employees_are_changed AS employees_are_changed_8,
  t0.report_id AS report_id_9
FROM
  new_report_employees t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.employees_total AS employees_total_2, t0.employees_works_in_audit AS employees_works_in_audit_3, t0.employees_auditors AS employees_auditors_4, t0.employees_audit_partners AS employees_audit_partners_5, t0.created AS created_6, t0.updated AS updated_7, t0.employees_are_changed AS employees_are_changed_8, t0.report_id AS report_id_9 FROM new_report_employees t0 WHERE t0.report_id = 13602;

SELECT
  t0.id AS id_1,
  t0.has_collaboration_with_subcontractors AS has_collaboration_with_subcontractors_2,
  t0.collaboration_with_subcontractors_total AS collaboration_with_subcontractors_total_3,
  t0.collaboration_with_subcontractors_statutar_audit AS collaboration_with_subcontractors_statutar_audit_4,
  t0.collaboration_with_subcontractors_auditors AS collaboration_with_subcontractors_auditors_5,
  t0.has_collaboration_as_subcontractor AS has_collaboration_as_subcontractor_6,
  t0.collaboration_as_subcontractor_total AS collaboration_as_subcontractor_total_7,
  t0.has_collaboration_with_common_contracts AS has_collaboration_with_common_contracts_8,
  t0.collaboration_with_common_contracts_total AS collaboration_with_common_contracts_total_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.report_id AS report_id_12
FROM
  new_report_collaborations t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.has_collaboration_with_subcontractors AS has_collaboration_with_subcontractors_2, t0.collaboration_with_subcontractors_total AS collaboration_with_subcontractors_total_3, t0.collaboration_with_subcontractors_statutar_audit AS collaboration_with_subcontractors_statutar_audit_4, t0.collaboration_with_subcontractors_auditors AS collaboration_with_subcontractors_auditors_5, t0.has_collaboration_as_subcontractor AS has_collaboration_as_subcontractor_6, t0.collaboration_as_subcontractor_total AS collaboration_as_subcontractor_total_7, t0.has_collaboration_with_common_contracts AS has_collaboration_with_common_contracts_8, t0.collaboration_with_common_contracts_total AS collaboration_with_common_contracts_total_9, t0.created AS created_10, t0.updated AS updated_11, t0.report_id AS report_id_12 FROM new_report_collaborations t0 WHERE t0.report_id = 13602;

SELECT
  t0.id AS id_1,
  t0.structure_description_file AS structure_description_file_2,
  t0.system_description_file AS system_description_file_3,
  t0.last_verification_date AS last_verification_date_4,
  t0.institution_name AS institution_name_5,
  t0.declaration_file AS declaration_file_6,
  t0.payment_info_file AS payment_info_file_7,
  t0.politics_description_file AS politics_description_file_8,
  t0.last_quality_assurance_rating AS last_quality_assurance_rating_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.report_id AS report_id_12
FROM
  new_report_isqc_form t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.structure_description_file AS structure_description_file_2, t0.system_description_file AS system_description_file_3, t0.last_verification_date AS last_verification_date_4, t0.institution_name AS institution_name_5, t0.declaration_file AS declaration_file_6, t0.payment_info_file AS payment_info_file_7, t0.politics_description_file AS politics_description_file_8, t0.last_quality_assurance_rating AS last_quality_assurance_rating_9, t0.created AS created_10, t0.updated AS updated_11, t0.report_id AS report_id_12 FROM new_report_isqc_form t0 WHERE t0.report_id = 13602;

SELECT
  t0.id AS id_1,
  t0.eip1_total AS eip1_total_2,
  t0.eip2_total AS eip2_total_3,
  t0.eip3_total AS eip3_total_4,
  t0.eip4_total AS eip4_total_5,
  t0.eip5_total AS eip5_total_6,
  t0.eip6_total AS eip6_total_7,
  t0.subcontractor_total AS subcontractor_total_8,
  t0.eip_total AS eip_total_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.report_id AS report_id_12
FROM
  new_report_appendix2 t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.eip1_total AS eip1_total_2, t0.eip2_total AS eip2_total_3, t0.eip3_total AS eip3_total_4, t0.eip4_total AS eip4_total_5, t0.eip5_total AS eip5_total_6, t0.eip6_total AS eip6_total_7, t0.subcontractor_total AS subcontractor_total_8, t0.eip_total AS eip_total_9, t0.created AS created_10, t0.updated AS updated_11, t0.report_id AS report_id_12 FROM new_report_appendix2 t0 WHERE t0.report_id = 13602;

SELECT
  t0.id AS id_1,
  t0.auditor_company_name AS auditor_company_name_2,
  t0.auditor_name AS auditor_name_3,
  t0.auditor_company_type AS auditor_company_type_4,
  t0.auditor_company_cui AS auditor_company_cui_5,
  t0.auditor_cif AS auditor_cif_6,
  t0.cui_document_file AS cui_document_file_7,
  t0.rpe_nr AS rpe_nr_8,
  t0.rpe_document_file AS rpe_document_file_9,
  t0.cafr_nr AS cafr_nr_10,
  t0.cafr_document_file AS cafr_document_file_11,
  t0.auditor_identity_document_file AS auditor_identity_document_file_12,
  t0.auditor_website AS auditor_website_13,
  t0.auditor_photo_file AS auditor_photo_file_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.auditor_company_name_is_changed AS auditor_company_name_is_changed_17,
  t0.auditor_name_is_changed AS auditor_name_is_changed_18,
  t0.auditor_company_cui_is_changed AS auditor_company_cui_is_changed_19,
  t0.rpe_nr_is_changed AS rpe_nr_is_changed_20,
  t0.report_id AS report_id_21
FROM
  new_report_general_informations t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.auditor_company_name AS auditor_company_name_2, t0.auditor_name AS auditor_name_3, t0.auditor_company_type AS auditor_company_type_4, t0.auditor_company_cui AS auditor_company_cui_5, t0.auditor_cif AS auditor_cif_6, t0.cui_document_file AS cui_document_file_7, t0.rpe_nr AS rpe_nr_8, t0.rpe_document_file AS rpe_document_file_9, t0.cafr_nr AS cafr_nr_10, t0.cafr_document_file AS cafr_document_file_11, t0.auditor_identity_document_file AS auditor_identity_document_file_12, t0.auditor_website AS auditor_website_13, t0.auditor_photo_file AS auditor_photo_file_14, t0.created AS created_15, t0.updated AS updated_16, t0.auditor_company_name_is_changed AS auditor_company_name_is_changed_17, t0.auditor_name_is_changed AS auditor_name_is_changed_18, t0.auditor_company_cui_is_changed AS auditor_company_cui_is_changed_19, t0.rpe_nr_is_changed AS rpe_nr_is_changed_20, t0.report_id AS report_id_21 FROM new_report_general_informations t0 WHERE t0.report_id = 12199;

SELECT
  t0.id AS id_1,
  t0.is_authorised_in_eu AS is_authorised_in_eu_2,
  t0.eu_authority_name AS eu_authority_name_3,
  t0.eu_authorisation_nr AS eu_authorisation_nr_4,
  t0.eu_authorisation_date AS eu_authorisation_date_5,
  t0.is_authorised_in_non_eu AS is_authorised_in_non_eu_6,
  t0.non_eu_authority_name AS non_eu_authority_name_7,
  t0.non_eu_authorisation_nr AS non_eu_authorisation_nr_8,
  t0.non_eu_authorisation_date AS non_eu_authorisation_date_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.non_eu_registered_in_ro AS non_eu_registered_in_ro_12,
  t0.report_id AS report_id_13,
  t0.eu_country_id AS eu_country_id_14,
  t0.non_eu_country_id AS non_eu_country_id_15
FROM
  new_report_authorisations t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.is_authorised_in_eu AS is_authorised_in_eu_2, t0.eu_authority_name AS eu_authority_name_3, t0.eu_authorisation_nr AS eu_authorisation_nr_4, t0.eu_authorisation_date AS eu_authorisation_date_5, t0.is_authorised_in_non_eu AS is_authorised_in_non_eu_6, t0.non_eu_authority_name AS non_eu_authority_name_7, t0.non_eu_authorisation_nr AS non_eu_authorisation_nr_8, t0.non_eu_authorisation_date AS non_eu_authorisation_date_9, t0.created AS created_10, t0.updated AS updated_11, t0.non_eu_registered_in_ro AS non_eu_registered_in_ro_12, t0.report_id AS report_id_13, t0.eu_country_id AS eu_country_id_14, t0.non_eu_country_id AS non_eu_country_id_15 FROM new_report_authorisations t0 WHERE t0.report_id = 12199;

SELECT
  t0.id AS id_1,
  t0.is_part_of_ceccar AS is_part_of_ceccar_2,
  t0.ceccar_nr AS ceccar_nr_3,
  t0.is_part_of_ccf AS is_part_of_ccf_4,
  t0.ccf_nr AS ccf_nr_5,
  t0.is_part_of_anevar AS is_part_of_anevar_6,
  t0.anevar_nr AS anevar_nr_7,
  t0.is_part_of_unpir AS is_part_of_unpir_8,
  t0.unpir_nr AS unpir_nr_9,
  t0.is_part_of_other_organisations AS is_part_of_other_organisations_10,
  t0.other_organisation_name_1 AS other_organisation_name_1_11,
  t0.other_organisation_nr_1 AS other_organisation_nr_1_12,
  t0.other_organisation_name_2 AS other_organisation_name_2_13,
  t0.other_organisation_nr_2 AS other_organisation_nr_2_14,
  t0.other_organisation_name_3 AS other_organisation_name_3_15,
  t0.other_organisation_nr_3 AS other_organisation_nr_3_16,
  t0.created AS created_17,
  t0.updated AS updated_18,
  t0.report_id AS report_id_19
FROM
  new_report_other_organisations t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.is_part_of_ceccar AS is_part_of_ceccar_2, t0.ceccar_nr AS ceccar_nr_3, t0.is_part_of_ccf AS is_part_of_ccf_4, t0.ccf_nr AS ccf_nr_5, t0.is_part_of_anevar AS is_part_of_anevar_6, t0.anevar_nr AS anevar_nr_7, t0.is_part_of_unpir AS is_part_of_unpir_8, t0.unpir_nr AS unpir_nr_9, t0.is_part_of_other_organisations AS is_part_of_other_organisations_10, t0.other_organisation_name_1 AS other_organisation_name_1_11, t0.other_organisation_nr_1 AS other_organisation_nr_1_12, t0.other_organisation_name_2 AS other_organisation_name_2_13, t0.other_organisation_nr_2 AS other_organisation_nr_2_14, t0.other_organisation_name_3 AS other_organisation_name_3_15, t0.other_organisation_nr_3 AS other_organisation_nr_3_16, t0.created AS created_17, t0.updated AS updated_18, t0.report_id AS report_id_19 FROM new_report_other_organisations t0 WHERE t0.report_id = 12199;

SELECT
  t0.id AS id_1,
  t0.assoc_total AS assoc_total_2,
  t0.assoc_authorised_in_romania AS assoc_authorised_in_romania_3,
  t0.assoc_authorised_in_other_country AS assoc_authorised_in_other_country_4,
  t0.assoc_percentage AS assoc_percentage_5,
  t0.admins_total AS admins_total_6,
  t0.admins_authorised_in_romania AS admins_authorised_in_romania_7,
  t0.admins_authorised_in_other_country AS admins_authorised_in_other_country_8,
  t0.admins_percentage AS admins_percentage_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.assoc_are_changed AS assoc_are_changed_12,
  t0.admins_are_changed AS admins_are_changed_13,
  t0.report_id AS report_id_14
FROM
  new_report_auditors_structure t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.assoc_total AS assoc_total_2, t0.assoc_authorised_in_romania AS assoc_authorised_in_romania_3, t0.assoc_authorised_in_other_country AS assoc_authorised_in_other_country_4, t0.assoc_percentage AS assoc_percentage_5, t0.admins_total AS admins_total_6, t0.admins_authorised_in_romania AS admins_authorised_in_romania_7, t0.admins_authorised_in_other_country AS admins_authorised_in_other_country_8, t0.admins_percentage AS admins_percentage_9, t0.created AS created_10, t0.updated AS updated_11, t0.assoc_are_changed AS assoc_are_changed_12, t0.admins_are_changed AS admins_are_changed_13, t0.report_id AS report_id_14 FROM new_report_auditors_structure t0 WHERE t0.report_id = 12199;

SELECT
  t0.id AS id_1,
  t0.employees_total AS employees_total_2,
  t0.employees_works_in_audit AS employees_works_in_audit_3,
  t0.employees_auditors AS employees_auditors_4,
  t0.employees_audit_partners AS employees_audit_partners_5,
  t0.created AS created_6,
  t0.updated AS updated_7,
  t0.employees_are_changed AS employees_are_changed_8,
  t0.report_id AS report_id_9
FROM
  new_report_employees t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.employees_total AS employees_total_2, t0.employees_works_in_audit AS employees_works_in_audit_3, t0.employees_auditors AS employees_auditors_4, t0.employees_audit_partners AS employees_audit_partners_5, t0.created AS created_6, t0.updated AS updated_7, t0.employees_are_changed AS employees_are_changed_8, t0.report_id AS report_id_9 FROM new_report_employees t0 WHERE t0.report_id = 12199;

SELECT
  t0.id AS id_1,
  t0.has_collaboration_with_subcontractors AS has_collaboration_with_subcontractors_2,
  t0.collaboration_with_subcontractors_total AS collaboration_with_subcontractors_total_3,
  t0.collaboration_with_subcontractors_statutar_audit AS collaboration_with_subcontractors_statutar_audit_4,
  t0.collaboration_with_subcontractors_auditors AS collaboration_with_subcontractors_auditors_5,
  t0.has_collaboration_as_subcontractor AS has_collaboration_as_subcontractor_6,
  t0.collaboration_as_subcontractor_total AS collaboration_as_subcontractor_total_7,
  t0.has_collaboration_with_common_contracts AS has_collaboration_with_common_contracts_8,
  t0.collaboration_with_common_contracts_total AS collaboration_with_common_contracts_total_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.report_id AS report_id_12
FROM
  new_report_collaborations t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.has_collaboration_with_subcontractors AS has_collaboration_with_subcontractors_2, t0.collaboration_with_subcontractors_total AS collaboration_with_subcontractors_total_3, t0.collaboration_with_subcontractors_statutar_audit AS collaboration_with_subcontractors_statutar_audit_4, t0.collaboration_with_subcontractors_auditors AS collaboration_with_subcontractors_auditors_5, t0.has_collaboration_as_subcontractor AS has_collaboration_as_subcontractor_6, t0.collaboration_as_subcontractor_total AS collaboration_as_subcontractor_total_7, t0.has_collaboration_with_common_contracts AS has_collaboration_with_common_contracts_8, t0.collaboration_with_common_contracts_total AS collaboration_with_common_contracts_total_9, t0.created AS created_10, t0.updated AS updated_11, t0.report_id AS report_id_12 FROM new_report_collaborations t0 WHERE t0.report_id = 12199;

SELECT
  t0.id AS id_1,
  t0.structure_description_file AS structure_description_file_2,
  t0.system_description_file AS system_description_file_3,
  t0.last_verification_date AS last_verification_date_4,
  t0.institution_name AS institution_name_5,
  t0.declaration_file AS declaration_file_6,
  t0.payment_info_file AS payment_info_file_7,
  t0.politics_description_file AS politics_description_file_8,
  t0.last_quality_assurance_rating AS last_quality_assurance_rating_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.report_id AS report_id_12
FROM
  new_report_isqc_form t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.structure_description_file AS structure_description_file_2, t0.system_description_file AS system_description_file_3, t0.last_verification_date AS last_verification_date_4, t0.institution_name AS institution_name_5, t0.declaration_file AS declaration_file_6, t0.payment_info_file AS payment_info_file_7, t0.politics_description_file AS politics_description_file_8, t0.last_quality_assurance_rating AS last_quality_assurance_rating_9, t0.created AS created_10, t0.updated AS updated_11, t0.report_id AS report_id_12 FROM new_report_isqc_form t0 WHERE t0.report_id = 12199;

SELECT
  t0.id AS id_1,
  t0.eip1_total AS eip1_total_2,
  t0.eip2_total AS eip2_total_3,
  t0.eip3_total AS eip3_total_4,
  t0.eip4_total AS eip4_total_5,
  t0.eip5_total AS eip5_total_6,
  t0.eip6_total AS eip6_total_7,
  t0.subcontractor_total AS subcontractor_total_8,
  t0.eip_total AS eip_total_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.report_id AS report_id_12
FROM
  new_report_appendix2 t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.eip1_total AS eip1_total_2, t0.eip2_total AS eip2_total_3, t0.eip3_total AS eip3_total_4, t0.eip4_total AS eip4_total_5, t0.eip5_total AS eip5_total_6, t0.eip6_total AS eip6_total_7, t0.subcontractor_total AS subcontractor_total_8, t0.eip_total AS eip_total_9, t0.created AS created_10, t0.updated AS updated_11, t0.report_id AS report_id_12 FROM new_report_appendix2 t0 WHERE t0.report_id = 12199;

SELECT
  t0.id AS id_1,
  t0.auditor_company_name AS auditor_company_name_2,
  t0.auditor_name AS auditor_name_3,
  t0.auditor_company_type AS auditor_company_type_4,
  t0.auditor_company_cui AS auditor_company_cui_5,
  t0.auditor_cif AS auditor_cif_6,
  t0.cui_document_file AS cui_document_file_7,
  t0.rpe_nr AS rpe_nr_8,
  t0.rpe_document_file AS rpe_document_file_9,
  t0.cafr_nr AS cafr_nr_10,
  t0.cafr_document_file AS cafr_document_file_11,
  t0.auditor_identity_document_file AS auditor_identity_document_file_12,
  t0.auditor_website AS auditor_website_13,
  t0.auditor_photo_file AS auditor_photo_file_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.auditor_company_name_is_changed AS auditor_company_name_is_changed_17,
  t0.auditor_name_is_changed AS auditor_name_is_changed_18,
  t0.auditor_company_cui_is_changed AS auditor_company_cui_is_changed_19,
  t0.rpe_nr_is_changed AS rpe_nr_is_changed_20,
  t0.report_id AS report_id_21
FROM
  new_report_general_informations t0
WHERE
  t0.report_id = ?