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
  t0.id AS id_1,
  t0.year AS year_2,
  t0.created AS created_3,
  t0.updated AS updated_4,
  t0.with_financial_activity_pie AS with_financial_activity_pie_5,
  t0.with_financial_activity_nonpie AS with_financial_activity_nonpie_6,
  t0.with_financial_activity_without_statutory_audit AS with_financial_activity_without_statutory_audit_7,
  t0.with_financial_activity_durability AS with_financial_activity_durability_8,
  t0.without_financial_activity_non_audit AS without_financial_activity_non_audit_9,
  t0.without_financial_activity AS without_financial_activity_10,
  t0.non_active AS non_active_11,
  t0.user_browser AS user_browser_12,
  t0.completed AS completed_13,
  t0.evisa_request AS evisa_request_14,
  t0.evisa_request_file AS evisa_request_file_15,
  t0.good_reputation_declaration_file AS good_reputation_declaration_file_16,
  t0.professional_declaration_file AS professional_declaration_file_17,
  t0.self_declaration AS self_declaration_18,
  t0.agreement_declaration AS agreement_declaration_19,
  t0.collaboration_with_financial_activity_pie AS collaboration_with_financial_activity_pie_20,
  t0.incompatibility_legal_law AS incompatibility_legal_law_21,
  t0.incompatibility_proof_file AS incompatibility_proof_file_22,
  t0.is_locked AS is_locked_23,
  t0.is_visa_processing AS is_visa_processing_24,
  t0.sent AS sent_25,
  t0.sent_id AS sent_id_26,
  t0.visa_date_issued AS visa_date_issued_27,
  t0.visa_date_validity AS visa_date_validity_28,
  t0.deleted AS deleted_29,
  t0.message_sent_back AS message_sent_back_30,
  t0.sent_back_date AS sent_back_date_31,
  t0.report_type AS report_type_32,
  t0.change_activity_reason AS change_activity_reason_33,
  t0.visa_cancelled AS visa_cancelled_34,
  t0.visa_cancelled_reason AS visa_cancelled_reason_35,
  t0.auditor_id AS auditor_id_36,
  t0.step_id AS step_id_37,
  t38.id AS id_39,
  t38.auditor_company_name AS auditor_company_name_40,
  t38.auditor_name AS auditor_name_41,
  t38.auditor_company_type AS auditor_company_type_42,
  t38.auditor_company_cui AS auditor_company_cui_43,
  t38.auditor_cif AS auditor_cif_44,
  t38.cui_document_file AS cui_document_file_45,
  t38.rpe_nr AS rpe_nr_46,
  t38.rpe_document_file AS rpe_document_file_47,
  t38.cafr_nr AS cafr_nr_48,
  t38.cafr_document_file AS cafr_document_file_49,
  t38.auditor_identity_document_file AS auditor_identity_document_file_50,
  t38.auditor_website AS auditor_website_51,
  t38.auditor_photo_file AS auditor_photo_file_52,
  t38.created AS created_53,
  t38.updated AS updated_54,
  t38.auditor_company_name_is_changed AS auditor_company_name_is_changed_55,
  t38.auditor_name_is_changed AS auditor_name_is_changed_56,
  t38.auditor_company_cui_is_changed AS auditor_company_cui_is_changed_57,
  t38.rpe_nr_is_changed AS rpe_nr_is_changed_58,
  t38.report_id AS report_id_59,
  t60.id AS id_61,
  t60.is_authorised_in_eu AS is_authorised_in_eu_62,
  t60.eu_authority_name AS eu_authority_name_63,
  t60.eu_authorisation_nr AS eu_authorisation_nr_64,
  t60.eu_authorisation_date AS eu_authorisation_date_65,
  t60.is_authorised_in_non_eu AS is_authorised_in_non_eu_66,
  t60.non_eu_authority_name AS non_eu_authority_name_67,
  t60.non_eu_authorisation_nr AS non_eu_authorisation_nr_68,
  t60.non_eu_authorisation_date AS non_eu_authorisation_date_69,
  t60.created AS created_70,
  t60.updated AS updated_71,
  t60.non_eu_registered_in_ro AS non_eu_registered_in_ro_72,
  t60.report_id AS report_id_73,
  t60.eu_country_id AS eu_country_id_74,
  t60.non_eu_country_id AS non_eu_country_id_75,
  t76.id AS id_77,
  t76.is_part_of_ceccar AS is_part_of_ceccar_78,
  t76.ceccar_nr AS ceccar_nr_79,
  t76.is_part_of_ccf AS is_part_of_ccf_80,
  t76.ccf_nr AS ccf_nr_81,
  t76.is_part_of_anevar AS is_part_of_anevar_82,
  t76.anevar_nr AS anevar_nr_83,
  t76.is_part_of_unpir AS is_part_of_unpir_84,
  t76.unpir_nr AS unpir_nr_85,
  t76.is_part_of_other_organisations AS is_part_of_other_organisations_86,
  t76.other_organisation_name_1 AS other_organisation_name_1_87,
  t76.other_organisation_nr_1 AS other_organisation_nr_1_88,
  t76.other_organisation_name_2 AS other_organisation_name_2_89,
  t76.other_organisation_nr_2 AS other_organisation_nr_2_90,
  t76.other_organisation_name_3 AS other_organisation_name_3_91,
  t76.other_organisation_nr_3 AS other_organisation_nr_3_92,
  t76.created AS created_93,
  t76.updated AS updated_94,
  t76.report_id AS report_id_95,
  t96.id AS id_97,
  t96.assoc_total AS assoc_total_98,
  t96.assoc_authorised_in_romania AS assoc_authorised_in_romania_99,
  t96.assoc_authorised_in_other_country AS assoc_authorised_in_other_country_100,
  t96.assoc_percentage AS assoc_percentage_101,
  t96.admins_total AS admins_total_102,
  t96.admins_authorised_in_romania AS admins_authorised_in_romania_103,
  t96.admins_authorised_in_other_country AS admins_authorised_in_other_country_104,
  t96.admins_percentage AS admins_percentage_105,
  t96.created AS created_106,
  t96.updated AS updated_107,
  t96.assoc_are_changed AS assoc_are_changed_108,
  t96.admins_are_changed AS admins_are_changed_109,
  t96.report_id AS report_id_110,
  t111.id AS id_112,
  t111.employees_total AS employees_total_113,
  t111.employees_works_in_audit AS employees_works_in_audit_114,
  t111.employees_auditors AS employees_auditors_115,
  t111.employees_audit_partners AS employees_audit_partners_116,
  t111.created AS created_117,
  t111.updated AS updated_118,
  t111.employees_are_changed AS employees_are_changed_119,
  t111.report_id AS report_id_120,
  t121.id AS id_122,
  t121.has_collaboration_with_subcontractors AS has_collaboration_with_subcontractors_123,
  t121.collaboration_with_subcontractors_total AS collaboration_with_subcontractors_total_124,
  t121.collaboration_with_subcontractors_statutar_audit AS collaboration_with_subcontractors_statutar_audit_125,
  t121.collaboration_with_subcontractors_auditors AS collaboration_with_subcontractors_auditors_126,
  t121.has_collaboration_as_subcontractor AS has_collaboration_as_subcontractor_127,
  t121.collaboration_as_subcontractor_total AS collaboration_as_subcontractor_total_128,
  t121.has_collaboration_with_common_contracts AS has_collaboration_with_common_contracts_129,
  t121.collaboration_with_common_contracts_total AS collaboration_with_common_contracts_total_130,
  t121.created AS created_131,
  t121.updated AS updated_132,
  t121.report_id AS report_id_133,
  t134.id AS id_135,
  t134.structure_description_file AS structure_description_file_136,
  t134.system_description_file AS system_description_file_137,
  t134.last_verification_date AS last_verification_date_138,
  t134.institution_name AS institution_name_139,
  t134.declaration_file AS declaration_file_140,
  t134.payment_info_file AS payment_info_file_141,
  t134.politics_description_file AS politics_description_file_142,
  t134.last_quality_assurance_rating AS last_quality_assurance_rating_143,
  t134.created AS created_144,
  t134.updated AS updated_145,
  t134.report_id AS report_id_146,
  t147.id AS id_148,
  t147.eip1_total AS eip1_total_149,
  t147.eip2_total AS eip2_total_150,
  t147.eip3_total AS eip3_total_151,
  t147.eip4_total AS eip4_total_152,
  t147.eip5_total AS eip5_total_153,
  t147.eip6_total AS eip6_total_154,
  t147.subcontractor_total AS subcontractor_total_155,
  t147.eip_total AS eip_total_156,
  t147.created AS created_157,
  t147.updated AS updated_158,
  t147.report_id AS report_id_159,
  t0.deleted_by_id AS deleted_by_id_160,
  t0.parent_id AS parent_id_161,
  t0.visa_cancelled_by_id AS visa_cancelled_by_id_162
FROM
  new_report t0
  LEFT JOIN new_report_general_informations t38 ON t38.report_id = t0.id
  LEFT JOIN new_report_authorisations t60 ON t60.report_id = t0.id
  LEFT JOIN new_report_other_organisations t76 ON t76.report_id = t0.id
  LEFT JOIN new_report_auditors_structure t96 ON t96.report_id = t0.id
  LEFT JOIN new_report_employees t111 ON t111.report_id = t0.id
  LEFT JOIN new_report_collaborations t121 ON t121.report_id = t0.id
  LEFT JOIN new_report_isqc_form t134 ON t134.report_id = t0.id
  LEFT JOIN new_report_appendix2 t147 ON t147.report_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.year AS year_2, t0.created AS created_3, t0.updated AS updated_4, t0.with_financial_activity_pie AS with_financial_activity_pie_5, t0.with_financial_activity_nonpie AS with_financial_activity_nonpie_6, t0.with_financial_activity_without_statutory_audit AS with_financial_activity_without_statutory_audit_7, t0.with_financial_activity_durability AS with_financial_activity_durability_8, t0.without_financial_activity_non_audit AS without_financial_activity_non_audit_9, t0.without_financial_activity AS without_financial_activity_10, t0.non_active AS non_active_11, t0.user_browser AS user_browser_12, t0.completed AS completed_13, t0.evisa_request AS evisa_request_14, t0.evisa_request_file AS evisa_request_file_15, t0.good_reputation_declaration_file AS good_reputation_declaration_file_16, t0.professional_declaration_file AS professional_declaration_file_17, t0.self_declaration AS self_declaration_18, t0.agreement_declaration AS agreement_declaration_19, t0.collaboration_with_financial_activity_pie AS collaboration_with_financial_activity_pie_20, t0.incompatibility_legal_law AS incompatibility_legal_law_21, t0.incompatibility_proof_file AS incompatibility_proof_file_22, t0.is_locked AS is_locked_23, t0.is_visa_processing AS is_visa_processing_24, t0.sent AS sent_25, t0.sent_id AS sent_id_26, t0.visa_date_issued AS visa_date_issued_27, t0.visa_date_validity AS visa_date_validity_28, t0.deleted AS deleted_29, t0.message_sent_back AS message_sent_back_30, t0.sent_back_date AS sent_back_date_31, t0.report_type AS report_type_32, t0.change_activity_reason AS change_activity_reason_33, t0.visa_cancelled AS visa_cancelled_34, t0.visa_cancelled_reason AS visa_cancelled_reason_35, t0.auditor_id AS auditor_id_36, t0.step_id AS step_id_37, t38.id AS id_39, t38.auditor_company_name AS auditor_company_name_40, t38.auditor_name AS auditor_name_41, t38.auditor_company_type AS auditor_company_type_42, t38.auditor_company_cui AS auditor_company_cui_43, t38.auditor_cif AS auditor_cif_44, t38.cui_document_file AS cui_document_file_45, t38.rpe_nr AS rpe_nr_46, t38.rpe_document_file AS rpe_document_file_47, t38.cafr_nr AS cafr_nr_48, t38.cafr_document_file AS cafr_document_file_49, t38.auditor_identity_document_file AS auditor_identity_document_file_50, t38.auditor_website AS auditor_website_51, t38.auditor_photo_file AS auditor_photo_file_52, t38.created AS created_53, t38.updated AS updated_54, t38.auditor_company_name_is_changed AS auditor_company_name_is_changed_55, t38.auditor_name_is_changed AS auditor_name_is_changed_56, t38.auditor_company_cui_is_changed AS auditor_company_cui_is_changed_57, t38.rpe_nr_is_changed AS rpe_nr_is_changed_58, t38.report_id AS report_id_59, t60.id AS id_61, t60.is_authorised_in_eu AS is_authorised_in_eu_62, t60.eu_authority_name AS eu_authority_name_63, t60.eu_authorisation_nr AS eu_authorisation_nr_64, t60.eu_authorisation_date AS eu_authorisation_date_65, t60.is_authorised_in_non_eu AS is_authorised_in_non_eu_66, t60.non_eu_authority_name AS non_eu_authority_name_67, t60.non_eu_authorisation_nr AS non_eu_authorisation_nr_68, t60.non_eu_authorisation_date AS non_eu_authorisation_date_69, t60.created AS created_70, t60.updated AS updated_71, t60.non_eu_registered_in_ro AS non_eu_registered_in_ro_72, t60.report_id AS report_id_73, t60.eu_country_id AS eu_country_id_74, t60.non_eu_country_id AS non_eu_country_id_75, t76.id AS id_77, t76.is_part_of_ceccar AS is_part_of_ceccar_78, t76.ceccar_nr AS ceccar_nr_79, t76.is_part_of_ccf AS is_part_of_ccf_80, t76.ccf_nr AS ccf_nr_81, t76.is_part_of_anevar AS is_part_of_anevar_82, t76.anevar_nr AS anevar_nr_83, t76.is_part_of_unpir AS is_part_of_unpir_84, t76.unpir_nr AS unpir_nr_85, t76.is_part_of_other_organisations AS is_part_of_other_organisations_86, t76.other_organisation_name_1 AS other_organisation_name_1_87, t76.other_organisation_nr_1 AS other_organisation_nr_1_88, t76.other_organisation_name_2 AS other_organisation_name_2_89, t76.other_organisation_nr_2 AS other_organisation_nr_2_90, t76.other_organisation_name_3 AS other_organisation_name_3_91, t76.other_organisation_nr_3 AS other_organisation_nr_3_92, t76.created AS created_93, t76.updated AS updated_94, t76.report_id AS report_id_95, t96.id AS id_97, t96.assoc_total AS assoc_total_98, t96.assoc_authorised_in_romania AS assoc_authorised_in_romania_99, t96.assoc_authorised_in_other_country AS assoc_authorised_in_other_country_100, t96.assoc_percentage AS assoc_percentage_101, t96.admins_total AS admins_total_102, t96.admins_authorised_in_romania AS admins_authorised_in_romania_103, t96.admins_authorised_in_other_country AS admins_authorised_in_other_country_104, t96.admins_percentage AS admins_percentage_105, t96.created AS created_106, t96.updated AS updated_107, t96.assoc_are_changed AS assoc_are_changed_108, t96.admins_are_changed AS admins_are_changed_109, t96.report_id AS report_id_110, t111.id AS id_112, t111.employees_total AS employees_total_113, t111.employees_works_in_audit AS employees_works_in_audit_114, t111.employees_auditors AS employees_auditors_115, t111.employees_audit_partners AS employees_audit_partners_116, t111.created AS created_117, t111.updated AS updated_118, t111.employees_are_changed AS employees_are_changed_119, t111.report_id AS report_id_120, t121.id AS id_122, t121.has_collaboration_with_subcontractors AS has_collaboration_with_subcontractors_123, t121.collaboration_with_subcontractors_total AS collaboration_with_subcontractors_total_124, t121.collaboration_with_subcontractors_statutar_audit AS collaboration_with_subcontractors_statutar_audit_125, t121.collaboration_with_subcontractors_auditors AS collaboration_with_subcontractors_auditors_126, t121.has_collaboration_as_subcontractor AS has_collaboration_as_subcontractor_127, t121.collaboration_as_subcontractor_total AS collaboration_as_subcontractor_total_128, t121.has_collaboration_with_common_contracts AS has_collaboration_with_common_contracts_129, t121.collaboration_with_common_contracts_total AS collaboration_with_common_contracts_total_130, t121.created AS created_131, t121.updated AS updated_132, t121.report_id AS report_id_133, t134.id AS id_135, t134.structure_description_file AS structure_description_file_136, t134.system_description_file AS system_description_file_137, t134.last_verification_date AS last_verification_date_138, t134.institution_name AS institution_name_139, t134.declaration_file AS declaration_file_140, t134.payment_info_file AS payment_info_file_141, t134.politics_description_file AS politics_description_file_142, t134.last_quality_assurance_rating AS last_quality_assurance_rating_143, t134.created AS created_144, t134.updated AS updated_145, t134.report_id AS report_id_146, t147.id AS id_148, t147.eip1_total AS eip1_total_149, t147.eip2_total AS eip2_total_150, t147.eip3_total AS eip3_total_151, t147.eip4_total AS eip4_total_152, t147.eip5_total AS eip5_total_153, t147.eip6_total AS eip6_total_154, t147.subcontractor_total AS subcontractor_total_155, t147.eip_total AS eip_total_156, t147.created AS created_157, t147.updated AS updated_158, t147.report_id AS report_id_159, t0.deleted_by_id AS deleted_by_id_160, t0.parent_id AS parent_id_161, t0.visa_cancelled_by_id AS visa_cancelled_by_id_162 FROM new_report t0 LEFT JOIN new_report_general_informations t38 ON t38.report_id = t0.id LEFT JOIN new_report_authorisations t60 ON t60.report_id = t0.id LEFT JOIN new_report_other_organisations t76 ON t76.report_id = t0.id LEFT JOIN new_report_auditors_structure t96 ON t96.report_id = t0.id LEFT JOIN new_report_employees t111 ON t111.report_id = t0.id LEFT JOIN new_report_collaborations t121 ON t121.report_id = t0.id LEFT JOIN new_report_isqc_form t134 ON t134.report_id = t0.id LEFT JOIN new_report_appendix2 t147 ON t147.report_id = t0.id WHERE t0.id = '15096';

SELECT
  t0.id AS id_1,
  t0.step_name AS step_name_2,
  t0.audit_company AS audit_company_3,
  t0.financial_auditor AS financial_auditor_4,
  t0.with_financial_activity_pie AS with_financial_activity_pie_5,
  t0.with_financial_activity_nonpie AS with_financial_activity_nonpie_6,
  t0.with_financial_activity_without_statutory_audit AS with_financial_activity_without_statutory_audit_7,
  t0.with_financial_activity_durability AS with_financial_activity_durability_8,
  t0.without_financial_activity_non_audit AS without_financial_activity_non_audit_9,
  t0.without_financial_activity AS without_financial_activity_10,
  t0.deleted_at AS deleted_at_11,
  t0.non_active AS non_active_12,
  t0.step_unique AS step_unique_13,
  t0.position AS position_14
FROM
  new_report_steps t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.step_name AS step_name_2, t0.audit_company AS audit_company_3, t0.financial_auditor AS financial_auditor_4, t0.with_financial_activity_pie AS with_financial_activity_pie_5, t0.with_financial_activity_nonpie AS with_financial_activity_nonpie_6, t0.with_financial_activity_without_statutory_audit AS with_financial_activity_without_statutory_audit_7, t0.with_financial_activity_durability AS with_financial_activity_durability_8, t0.without_financial_activity_non_audit AS without_financial_activity_non_audit_9, t0.without_financial_activity AS without_financial_activity_10, t0.deleted_at AS deleted_at_11, t0.non_active AS non_active_12, t0.step_unique AS step_unique_13, t0.position AS position_14 FROM new_report_steps t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.rpe AS rpe_3,
  t0.cafr AS cafr_4,
  t0.price AS price_5,
  t0.created AS created_6,
  t0.auditor_type AS auditor_type_7,
  t0.report_id AS report_id_8,
  t0.auditor_id AS auditor_id_9,
  t0.audit_mission_type_id AS audit_mission_type_id_10
FROM
  new_report_collaborations_list t0
WHERE
  t0.report_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.rpe AS rpe_3, t0.cafr AS cafr_4, t0.price AS price_5, t0.created AS created_6, t0.auditor_type AS auditor_type_7, t0.report_id AS report_id_8, t0.auditor_id AS auditor_id_9, t0.audit_mission_type_id AS audit_mission_type_id_10 FROM new_report_collaborations_list t0 WHERE t0.report_id = 15096;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO new_report_collaborations (
  has_collaboration_with_subcontractors,
  collaboration_with_subcontractors_total,
  collaboration_with_subcontractors_statutar_audit,
  collaboration_with_subcontractors_auditors,
  has_collaboration_as_subcontractor,
  collaboration_as_subcontractor_total,
  has_collaboration_with_common_contracts,
  collaboration_with_common_contracts_total,
  created, updated, report_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO new_report_collaborations (has_collaboration_with_subcontractors, collaboration_with_subcontractors_total, collaboration_with_subcontractors_statutar_audit, collaboration_with_subcontractors_auditors, has_collaboration_as_subcontractor, collaboration_as_subcontractor_total, has_collaboration_with_common_contracts, collaboration_with_common_contracts_total, created, updated, report_id) VALUES (0, NULL, NULL, NULL, 0, NULL, 0, NULL, '2025-12-11 16:05:17', NULL, 15096);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  new_report
SET
  updated = ?
WHERE
  id = ?

UPDATE new_report SET updated = '2025-12-11 16:05:17' WHERE id = 15096;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.rpe_number AS rpe_number_2,
  t0.company_cif AS company_cif_3,
  t0.authorisation_document_name AS authorisation_document_name_4,
  t0.authorisation_document_number AS authorisation_document_number_5,
  t0.authorisation_document_date AS authorisation_document_date_6,
  t0.cafr_registry_number AS cafr_registry_number_7,
  t0.cafr_registry_date AS cafr_registry_date_8,
  t0.date_updated AS date_updated_9,
  t0.date_created AS date_created_10,
  t0.access_token AS access_token_11,
  t0.access_token_expire AS access_token_expire_12,
  t0.person_cnp AS person_cnp_13,
  t0.comment AS comment_14,
  t0.is_company AS is_company_15,
  t0.has_privacy AS has_privacy_16,
  t0.mentor_number_decree AS mentor_number_decree_17,
  t0.mentor_document_decree AS mentor_document_decree_18,
  t0.is_mentor AS is_mentor_19,
  t0.durability AS durability_20,
  t0.register_date AS register_date_21,
  t0.current_detail_id AS current_detail_id_22
FROM
  auditor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.rpe_number AS rpe_number_2, t0.company_cif AS company_cif_3, t0.authorisation_document_name AS authorisation_document_name_4, t0.authorisation_document_number AS authorisation_document_number_5, t0.authorisation_document_date AS authorisation_document_date_6, t0.cafr_registry_number AS cafr_registry_number_7, t0.cafr_registry_date AS cafr_registry_date_8, t0.date_updated AS date_updated_9, t0.date_created AS date_created_10, t0.access_token AS access_token_11, t0.access_token_expire AS access_token_expire_12, t0.person_cnp AS person_cnp_13, t0.comment AS comment_14, t0.is_company AS is_company_15, t0.has_privacy AS has_privacy_16, t0.mentor_number_decree AS mentor_number_decree_17, t0.mentor_document_decree AS mentor_document_decree_18, t0.is_mentor AS is_mentor_19, t0.durability AS durability_20, t0.register_date AS register_date_21, t0.current_detail_id AS current_detail_id_22 FROM auditor t0 WHERE t0.id = 5362;

SELECT
  n0_.id AS id_0,
  n0_.step_name AS step_name_1,
  n0_.audit_company AS audit_company_2,
  n0_.financial_auditor AS financial_auditor_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_.deleted_at AS deleted_at_10,
  n0_.non_active AS non_active_11,
  n0_.step_unique AS step_unique_12,
  n0_.position AS position_13
FROM
  new_report_steps n0_
WHERE
  n0_.position > 7
  AND n0_.audit_company = 1
  AND (
    n0_.with_financial_activity_without_statutory_audit = 1
    OR n0_.with_financial_activity_durability = 1
  )
  AND n0_.deleted_at IS NULL
ORDER BY
  n0_.position ASC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.step_name AS step_name_1, n0_.audit_company AS audit_company_2, n0_.financial_auditor AS financial_auditor_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_.deleted_at AS deleted_at_10, n0_.non_active AS non_active_11, n0_.step_unique AS step_unique_12, n0_.position AS position_13 FROM new_report_steps n0_ WHERE n0_.position > 7 AND n0_.audit_company = 1 AND (n0_.with_financial_activity_without_statutory_audit = 1 OR n0_.with_financial_activity_durability = 1) AND n0_.deleted_at IS NULL ORDER BY n0_.position ASC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  new_report
SET
  step_id = ?
WHERE
  id = ?

UPDATE new_report SET step_id = 8 WHERE id = 15096;

"COMMIT"

"COMMIT";