Symfony Profiler

SELECT
  *
FROM
  sybot.wfl_schedule
WHERE
  schedule_id = :scheduleId

SELECT * FROM sybot.wfl_schedule WHERE schedule_id = 20;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.hidden AS hidden_3,
  t0.id AS id_4,
  t0.flag_send_webex AS flag_send_webex_5,
  t0.room_webex AS room_webex_6,
  t0.desc_webex AS desc_webex_7,
  t0.text_send_webex AS text_send_webex_8,
  t0.to_send_message AS to_send_message_9,
  t0.cc_send_message AS cc_send_message_10,
  t0.flag_send_mail AS flag_send_mail_11,
  t0.flag_type_checklist AS flag_type_checklist_12,
  t0.id_category AS id_category_13,
  t0.data_creazione AS data_creazione_14,
  t0.data_modifica AS data_modifica_15,
  t0.creato_da AS creato_da_16,
  t0.modificato_da AS modificato_da_17,
  t0.locked AS locked_18,
  t0.lock_session_user_id AS lock_session_user_id_19,
  t0.ko_mail_task AS ko_mail_task_20,
  t0.ok_mail_task AS ok_mail_task_21
FROM
  chklst_template t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.hidden AS hidden_3, t0.id AS id_4, t0.flag_send_webex AS flag_send_webex_5, t0.room_webex AS room_webex_6, t0.desc_webex AS desc_webex_7, t0.text_send_webex AS text_send_webex_8, t0.to_send_message AS to_send_message_9, t0.cc_send_message AS cc_send_message_10, t0.flag_send_mail AS flag_send_mail_11, t0.flag_type_checklist AS flag_type_checklist_12, t0.id_category AS id_category_13, t0.data_creazione AS data_creazione_14, t0.data_modifica AS data_modifica_15, t0.creato_da AS creato_da_16, t0.modificato_da AS modificato_da_17, t0.locked AS locked_18, t0.lock_session_user_id AS lock_session_user_id_19, t0.ko_mail_task AS ko_mail_task_20, t0.ok_mail_task AS ok_mail_task_21 FROM chklst_template t0 WHERE t0.id = '1283';

INSERT INTO chklst (
  name, description, run_start, run_result,
  run_end, run_user_id, ko_mail_task_id,
  ok_mail_task_id, from_template_id
)
VALUES
  (
    :name, :description, null, null, null,
    :run_user_id, null, null, :from_template_id
  ) ON CONFLICT (
    from_template_id, name, run_start
  ) DO NOTHING

INSERT INTO chklst (name, description, run_start, run_result, run_end, run_user_id, ko_mail_task_id, ok_mail_task_id, from_template_id)
			VALUES ('Main_MRP_M2','', null, null, null,1,null, null, '1283')
			ON CONFLICT (from_template_id, name, run_start)
			DO NOTHING;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.run_start AS run_start_3,
  t0.run_result AS run_result_4,
  t0.run_end AS run_end_5,
  t0.id AS id_6,
  t0.is_child AS is_child_7,
  t0.parameters_map AS parameters_map_8,
  t0.run_user_id AS run_user_id_9,
  t0.ko_mail_task_id AS ko_mail_task_id_10,
  t0.ok_mail_task_id AS ok_mail_task_id_11,
  t0.from_template_id AS from_template_id_12
FROM
  chklst t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.run_start AS run_start_3, t0.run_result AS run_result_4, t0.run_end AS run_end_5, t0.id AS id_6, t0.is_child AS is_child_7, t0.parameters_map AS parameters_map_8, t0.run_user_id AS run_user_id_9, t0.ko_mail_task_id AS ko_mail_task_id_10, t0.ok_mail_task_id AS ok_mail_task_id_11, t0.from_template_id AS from_template_id_12 FROM chklst t0 WHERE t0.id = '26637';

SELECT
  t0.task_order AS task_order_1,
  t0.slave AS slave_2,
  t0.flag_bitmask AS flag_bitmask_3,
  t0.run_bitmask AS run_bitmask_4,
  t0.id AS id_5,
  t0.task_id AS task_id_6,
  t0.ko_task AS ko_task_7,
  t0.task_id AS task_id_8,
  t0.task_id AS task_id_9,
  t0.chklsttmpl_id AS chklsttmpl_id_10
FROM
  chklsttmpl2task t0
WHERE
  t0.chklsttmpl_id = ?

SELECT t0.task_order AS task_order_1, t0.slave AS slave_2, t0.flag_bitmask AS flag_bitmask_3, t0.run_bitmask AS run_bitmask_4, t0.id AS id_5, t0.task_id AS task_id_6, t0.ko_task AS ko_task_7, t0.task_id AS task_id_8, t0.task_id AS task_id_9, t0.chklsttmpl_id AS chklsttmpl_id_10 FROM chklsttmpl2task t0 WHERE t0.chklsttmpl_id = 1283;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.cmd_type AS cmd_type_3,
  t0.cmd_text AS cmd_text_4,
  t0.return_type AS return_type_5,
  t0.match_operator AS match_operator_6,
  t0.match_value AS match_value_7,
  t0.grep_stdout_fail AS grep_stdout_fail_8,
  t0.grep_stderr_fail AS grep_stderr_fail_9,
  t0.cmd_max_retry AS cmd_max_retry_10,
  t0.cmd_time_retry AS cmd_time_retry_11,
  t0.ko_hint AS ko_hint_12,
  t0.id AS id_13,
  t0.type_db AS type_db_14,
  t0.ip_db AS ip_db_15,
  t0.user_db AS user_db_16,
  t0.pwd_db AS pwd_db_17,
  t0.port_db AS port_db_18,
  t0.name_db AS name_db_19,
  t0.service AS service_20,
  t0.flag_stop_checklist_task AS flag_stop_checklist_task_21,
  t0.flag_jump_task AS flag_jump_task_22,
  t0.next_task AS next_task_23,
  t0.connection_direct AS connection_direct_24,
  t0.statement_select AS statement_select_25,
  t0.auth_username AS auth_username_26,
  t0.auth_password AS auth_password_27,
  t0.auth_protocol AS auth_protocol_28,
  t0.auth_port AS auth_port_29,
  t0.auth_url AS auth_url_30,
  t0.auth_type AS auth_type_31,
  t0.auth_token AS auth_token_32,
  t0.flag_run_as AS flag_run_as_33,
  t0.run_as_user AS run_as_user_34,
  t0.flag_run_as_user_password AS flag_run_as_user_password_35,
  t0.run_as_password AS run_as_password_36,
  t0.flag_check_exit_status AS flag_check_exit_status_37,
  t0.flag_check_count_query AS flag_check_count_query_38,
  t0.flag_mail_attachment AS flag_mail_attachment_39,
  t0.mail_attachment AS mail_attachment_40,
  t0.send_to_mail AS send_to_mail_41,
  t0.send_cc_mail AS send_cc_mail_42,
  t0.send_text_mail AS send_text_mail_43,
  t0.send_object_mail AS send_object_mail_44,
  t0.spool_on_file AS spool_on_file_45,
  t0.filename_spool_query AS filename_spool_query_46,
  t0.ftp_anonymous AS ftp_anonymous_47,
  t0.ftp_hostname AS ftp_hostname_48,
  t0.ftp_port AS ftp_port_49,
  t0.ftp_user AS ftp_user_50,
  t0.ftp_password AS ftp_password_51,
  t0.ftp_directory AS ftp_directory_52,
  t0.ftp_filename AS ftp_filename_53,
  t0.configure_timeout AS configure_timeout_54,
  t0.server_check_email AS server_check_email_55,
  t0.port_check_email AS port_check_email_56,
  t0.user_check_email AS user_check_email_57,
  t0.pass_check_email AS pass_check_email_58,
  t0.from_check_email AS from_check_email_59,
  t0.subject_check_email AS subject_check_email_60,
  t0.body_check_email AS body_check_email_61,
  t0.attempt_check_email AS attempt_check_email_62,
  t0.polling_check_email AS polling_check_email_63,
  t0.id_user_nav_web AS id_user_nav_web_64,
  t0.id_pass_nav_web AS id_pass_nav_web_65,
  t0.ftp_in_all_directory AS ftp_in_all_directory_66,
  t0.type_check_email AS type_check_email_67,
  t0.save_attachments_email AS save_attachments_email_68,
  t0.object_type_nav_web AS object_type_nav_web_69,
  t0.information_text AS information_text_70,
  t0.call_flag_send AS call_flag_send_71,
  t0.text_to_speech_flag_call AS text_to_speech_flag_call_72,
  t0.text_to_speech_number_call AS text_to_speech_number_call_73,
  t0.text_to_speech_text_send_call AS text_to_speech_text_send_call_74,
  t0.uccx_flag_call AS uccx_flag_call_75,
  t0.uccx_number_call AS uccx_number_call_76,
  t0.uccx_prompt_message AS uccx_prompt_message_77,
  t0.uccx_confirm_message AS uccx_confirm_message_78,
  t0.sms_flag_send AS sms_flag_send_79,
  t0.sms_number AS sms_number_80,
  t0.sms_text_send AS sms_text_send_81,
  t0.telegram_flag_send AS telegram_flag_send_82,
  t0.telegram_chat AS telegram_chat_83,
  t0.telegram_text_send AS telegram_text_send_84,
  t0.config_json AS config_json_85,
  t0.url_nav_web AS url_nav_web_86,
  t0.user_nav_web AS user_nav_web_87,
  t0.pass_nav_web AS pass_nav_web_88,
  t0.object_name_nav_web AS object_name_nav_web_89,
  t0.nav_web_anonymous AS nav_web_anonymous_90,
  t0.spool_objectid_nav_web AS spool_objectid_nav_web_91,
  t0.tars_run_project_name AS tars_run_project_name_92,
  t0.tars_run_suite_name AS tars_run_suite_name_93,
  t0.tars_run_path_scenario AS tars_run_path_scenario_94,
  t0.tars_run_nome_scenario AS tars_run_nome_scenario_95,
  t0.tars_run_identificativo AS tars_run_identificativo_96,
  t0.tars_run_parametro_default AS tars_run_parametro_default_97,
  t0.tars_run_user AS tars_run_user_98,
  t0.tars_run_ipaddress AS tars_run_ipaddress_99,
  t0.tars_run_hostname AS tars_run_hostname_100,
  t0.tars_run_password AS tars_run_password_101,
  t0.tars_run_use_password AS tars_run_use_password_102,
  t0.use_certificate_db AS use_certificate_db_103
FROM
  task t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.cmd_type AS cmd_type_3, t0.cmd_text AS cmd_text_4, t0.return_type AS return_type_5, t0.match_operator AS match_operator_6, t0.match_value AS match_value_7, t0.grep_stdout_fail AS grep_stdout_fail_8, t0.grep_stderr_fail AS grep_stderr_fail_9, t0.cmd_max_retry AS cmd_max_retry_10, t0.cmd_time_retry AS cmd_time_retry_11, t0.ko_hint AS ko_hint_12, t0.id AS id_13, t0.type_db AS type_db_14, t0.ip_db AS ip_db_15, t0.user_db AS user_db_16, t0.pwd_db AS pwd_db_17, t0.port_db AS port_db_18, t0.name_db AS name_db_19, t0.service AS service_20, t0.flag_stop_checklist_task AS flag_stop_checklist_task_21, t0.flag_jump_task AS flag_jump_task_22, t0.next_task AS next_task_23, t0.connection_direct AS connection_direct_24, t0.statement_select AS statement_select_25, t0.auth_username AS auth_username_26, t0.auth_password AS auth_password_27, t0.auth_protocol AS auth_protocol_28, t0.auth_port AS auth_port_29, t0.auth_url AS auth_url_30, t0.auth_type AS auth_type_31, t0.auth_token AS auth_token_32, t0.flag_run_as AS flag_run_as_33, t0.run_as_user AS run_as_user_34, t0.flag_run_as_user_password AS flag_run_as_user_password_35, t0.run_as_password AS run_as_password_36, t0.flag_check_exit_status AS flag_check_exit_status_37, t0.flag_check_count_query AS flag_check_count_query_38, t0.flag_mail_attachment AS flag_mail_attachment_39, t0.mail_attachment AS mail_attachment_40, t0.send_to_mail AS send_to_mail_41, t0.send_cc_mail AS send_cc_mail_42, t0.send_text_mail AS send_text_mail_43, t0.send_object_mail AS send_object_mail_44, t0.spool_on_file AS spool_on_file_45, t0.filename_spool_query AS filename_spool_query_46, t0.ftp_anonymous AS ftp_anonymous_47, t0.ftp_hostname AS ftp_hostname_48, t0.ftp_port AS ftp_port_49, t0.ftp_user AS ftp_user_50, t0.ftp_password AS ftp_password_51, t0.ftp_directory AS ftp_directory_52, t0.ftp_filename AS ftp_filename_53, t0.configure_timeout AS configure_timeout_54, t0.server_check_email AS server_check_email_55, t0.port_check_email AS port_check_email_56, t0.user_check_email AS user_check_email_57, t0.pass_check_email AS pass_check_email_58, t0.from_check_email AS from_check_email_59, t0.subject_check_email AS subject_check_email_60, t0.body_check_email AS body_check_email_61, t0.attempt_check_email AS attempt_check_email_62, t0.polling_check_email AS polling_check_email_63, t0.id_user_nav_web AS id_user_nav_web_64, t0.id_pass_nav_web AS id_pass_nav_web_65, t0.ftp_in_all_directory AS ftp_in_all_directory_66, t0.type_check_email AS type_check_email_67, t0.save_attachments_email AS save_attachments_email_68, t0.object_type_nav_web AS object_type_nav_web_69, t0.information_text AS information_text_70, t0.call_flag_send AS call_flag_send_71, t0.text_to_speech_flag_call AS text_to_speech_flag_call_72, t0.text_to_speech_number_call AS text_to_speech_number_call_73, t0.text_to_speech_text_send_call AS text_to_speech_text_send_call_74, t0.uccx_flag_call AS uccx_flag_call_75, t0.uccx_number_call AS uccx_number_call_76, t0.uccx_prompt_message AS uccx_prompt_message_77, t0.uccx_confirm_message AS uccx_confirm_message_78, t0.sms_flag_send AS sms_flag_send_79, t0.sms_number AS sms_number_80, t0.sms_text_send AS sms_text_send_81, t0.telegram_flag_send AS telegram_flag_send_82, t0.telegram_chat AS telegram_chat_83, t0.telegram_text_send AS telegram_text_send_84, t0.config_json AS config_json_85, t0.url_nav_web AS url_nav_web_86, t0.user_nav_web AS user_nav_web_87, t0.pass_nav_web AS pass_nav_web_88, t0.object_name_nav_web AS object_name_nav_web_89, t0.nav_web_anonymous AS nav_web_anonymous_90, t0.spool_objectid_nav_web AS spool_objectid_nav_web_91, t0.tars_run_project_name AS tars_run_project_name_92, t0.tars_run_suite_name AS tars_run_suite_name_93, t0.tars_run_path_scenario AS tars_run_path_scenario_94, t0.tars_run_nome_scenario AS tars_run_nome_scenario_95, t0.tars_run_identificativo AS tars_run_identificativo_96, t0.tars_run_parametro_default AS tars_run_parametro_default_97, t0.tars_run_user AS tars_run_user_98, t0.tars_run_ipaddress AS tars_run_ipaddress_99, t0.tars_run_hostname AS tars_run_hostname_100, t0.tars_run_password AS tars_run_password_101, t0.tars_run_use_password AS tars_run_use_password_102, t0.use_certificate_db AS use_certificate_db_103 FROM task t0 WHERE t0.id = 6756;

SELECT
  t0.server_order AS server_order_1,
  t0.id AS id_2,
  t0.task_id AS task_id_3,
  t0.task_id AS task_id_4,
  t0.server_id AS server_id_5
FROM
  task2server t0
WHERE
  t0.task_id = ?

SELECT t0.server_order AS server_order_1, t0.id AS id_2, t0.task_id AS task_id_3, t0.task_id AS task_id_4, t0.server_id AS server_id_5 FROM task2server t0 WHERE t0.task_id = 6756;

SELECT
  t0.hostname AS hostname_1,
  t0.ip_address AS ip_address_2,
  t0.username AS username_3,
  t0.group_name AS group_name_4,
  t0.id AS id_5
FROM
  server t0
WHERE
  t0.id = ?

SELECT t0.hostname AS hostname_1, t0.ip_address AS ip_address_2, t0.username AS username_3, t0.group_name AS group_name_4, t0.id AS id_5 FROM server t0 WHERE t0.id = 1;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.cmd_type AS cmd_type_3,
  t0.cmd_text AS cmd_text_4,
  t0.return_type AS return_type_5,
  t0.match_operator AS match_operator_6,
  t0.match_value AS match_value_7,
  t0.grep_stdout_fail AS grep_stdout_fail_8,
  t0.grep_stderr_fail AS grep_stderr_fail_9,
  t0.cmd_max_retry AS cmd_max_retry_10,
  t0.cmd_time_retry AS cmd_time_retry_11,
  t0.ko_hint AS ko_hint_12,
  t0.id AS id_13,
  t0.type_db AS type_db_14,
  t0.ip_db AS ip_db_15,
  t0.user_db AS user_db_16,
  t0.pwd_db AS pwd_db_17,
  t0.port_db AS port_db_18,
  t0.name_db AS name_db_19,
  t0.service AS service_20,
  t0.flag_stop_checklist_task AS flag_stop_checklist_task_21,
  t0.flag_jump_task AS flag_jump_task_22,
  t0.next_task AS next_task_23,
  t0.connection_direct AS connection_direct_24,
  t0.statement_select AS statement_select_25,
  t0.auth_username AS auth_username_26,
  t0.auth_password AS auth_password_27,
  t0.auth_protocol AS auth_protocol_28,
  t0.auth_port AS auth_port_29,
  t0.auth_url AS auth_url_30,
  t0.auth_type AS auth_type_31,
  t0.auth_token AS auth_token_32,
  t0.flag_run_as AS flag_run_as_33,
  t0.run_as_user AS run_as_user_34,
  t0.flag_run_as_user_password AS flag_run_as_user_password_35,
  t0.run_as_password AS run_as_password_36,
  t0.flag_check_exit_status AS flag_check_exit_status_37,
  t0.flag_check_count_query AS flag_check_count_query_38,
  t0.flag_mail_attachment AS flag_mail_attachment_39,
  t0.mail_attachment AS mail_attachment_40,
  t0.send_to_mail AS send_to_mail_41,
  t0.send_cc_mail AS send_cc_mail_42,
  t0.send_text_mail AS send_text_mail_43,
  t0.send_object_mail AS send_object_mail_44,
  t0.spool_on_file AS spool_on_file_45,
  t0.filename_spool_query AS filename_spool_query_46,
  t0.ftp_anonymous AS ftp_anonymous_47,
  t0.ftp_hostname AS ftp_hostname_48,
  t0.ftp_port AS ftp_port_49,
  t0.ftp_user AS ftp_user_50,
  t0.ftp_password AS ftp_password_51,
  t0.ftp_directory AS ftp_directory_52,
  t0.ftp_filename AS ftp_filename_53,
  t0.configure_timeout AS configure_timeout_54,
  t0.server_check_email AS server_check_email_55,
  t0.port_check_email AS port_check_email_56,
  t0.user_check_email AS user_check_email_57,
  t0.pass_check_email AS pass_check_email_58,
  t0.from_check_email AS from_check_email_59,
  t0.subject_check_email AS subject_check_email_60,
  t0.body_check_email AS body_check_email_61,
  t0.attempt_check_email AS attempt_check_email_62,
  t0.polling_check_email AS polling_check_email_63,
  t0.id_user_nav_web AS id_user_nav_web_64,
  t0.id_pass_nav_web AS id_pass_nav_web_65,
  t0.ftp_in_all_directory AS ftp_in_all_directory_66,
  t0.type_check_email AS type_check_email_67,
  t0.save_attachments_email AS save_attachments_email_68,
  t0.object_type_nav_web AS object_type_nav_web_69,
  t0.information_text AS information_text_70,
  t0.call_flag_send AS call_flag_send_71,
  t0.text_to_speech_flag_call AS text_to_speech_flag_call_72,
  t0.text_to_speech_number_call AS text_to_speech_number_call_73,
  t0.text_to_speech_text_send_call AS text_to_speech_text_send_call_74,
  t0.uccx_flag_call AS uccx_flag_call_75,
  t0.uccx_number_call AS uccx_number_call_76,
  t0.uccx_prompt_message AS uccx_prompt_message_77,
  t0.uccx_confirm_message AS uccx_confirm_message_78,
  t0.sms_flag_send AS sms_flag_send_79,
  t0.sms_number AS sms_number_80,
  t0.sms_text_send AS sms_text_send_81,
  t0.telegram_flag_send AS telegram_flag_send_82,
  t0.telegram_chat AS telegram_chat_83,
  t0.telegram_text_send AS telegram_text_send_84,
  t0.config_json AS config_json_85,
  t0.url_nav_web AS url_nav_web_86,
  t0.user_nav_web AS user_nav_web_87,
  t0.pass_nav_web AS pass_nav_web_88,
  t0.object_name_nav_web AS object_name_nav_web_89,
  t0.nav_web_anonymous AS nav_web_anonymous_90,
  t0.spool_objectid_nav_web AS spool_objectid_nav_web_91,
  t0.tars_run_project_name AS tars_run_project_name_92,
  t0.tars_run_suite_name AS tars_run_suite_name_93,
  t0.tars_run_path_scenario AS tars_run_path_scenario_94,
  t0.tars_run_nome_scenario AS tars_run_nome_scenario_95,
  t0.tars_run_identificativo AS tars_run_identificativo_96,
  t0.tars_run_parametro_default AS tars_run_parametro_default_97,
  t0.tars_run_user AS tars_run_user_98,
  t0.tars_run_ipaddress AS tars_run_ipaddress_99,
  t0.tars_run_hostname AS tars_run_hostname_100,
  t0.tars_run_password AS tars_run_password_101,
  t0.tars_run_use_password AS tars_run_use_password_102,
  t0.use_certificate_db AS use_certificate_db_103
FROM
  task t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.cmd_type AS cmd_type_3, t0.cmd_text AS cmd_text_4, t0.return_type AS return_type_5, t0.match_operator AS match_operator_6, t0.match_value AS match_value_7, t0.grep_stdout_fail AS grep_stdout_fail_8, t0.grep_stderr_fail AS grep_stderr_fail_9, t0.cmd_max_retry AS cmd_max_retry_10, t0.cmd_time_retry AS cmd_time_retry_11, t0.ko_hint AS ko_hint_12, t0.id AS id_13, t0.type_db AS type_db_14, t0.ip_db AS ip_db_15, t0.user_db AS user_db_16, t0.pwd_db AS pwd_db_17, t0.port_db AS port_db_18, t0.name_db AS name_db_19, t0.service AS service_20, t0.flag_stop_checklist_task AS flag_stop_checklist_task_21, t0.flag_jump_task AS flag_jump_task_22, t0.next_task AS next_task_23, t0.connection_direct AS connection_direct_24, t0.statement_select AS statement_select_25, t0.auth_username AS auth_username_26, t0.auth_password AS auth_password_27, t0.auth_protocol AS auth_protocol_28, t0.auth_port AS auth_port_29, t0.auth_url AS auth_url_30, t0.auth_type AS auth_type_31, t0.auth_token AS auth_token_32, t0.flag_run_as AS flag_run_as_33, t0.run_as_user AS run_as_user_34, t0.flag_run_as_user_password AS flag_run_as_user_password_35, t0.run_as_password AS run_as_password_36, t0.flag_check_exit_status AS flag_check_exit_status_37, t0.flag_check_count_query AS flag_check_count_query_38, t0.flag_mail_attachment AS flag_mail_attachment_39, t0.mail_attachment AS mail_attachment_40, t0.send_to_mail AS send_to_mail_41, t0.send_cc_mail AS send_cc_mail_42, t0.send_text_mail AS send_text_mail_43, t0.send_object_mail AS send_object_mail_44, t0.spool_on_file AS spool_on_file_45, t0.filename_spool_query AS filename_spool_query_46, t0.ftp_anonymous AS ftp_anonymous_47, t0.ftp_hostname AS ftp_hostname_48, t0.ftp_port AS ftp_port_49, t0.ftp_user AS ftp_user_50, t0.ftp_password AS ftp_password_51, t0.ftp_directory AS ftp_directory_52, t0.ftp_filename AS ftp_filename_53, t0.configure_timeout AS configure_timeout_54, t0.server_check_email AS server_check_email_55, t0.port_check_email AS port_check_email_56, t0.user_check_email AS user_check_email_57, t0.pass_check_email AS pass_check_email_58, t0.from_check_email AS from_check_email_59, t0.subject_check_email AS subject_check_email_60, t0.body_check_email AS body_check_email_61, t0.attempt_check_email AS attempt_check_email_62, t0.polling_check_email AS polling_check_email_63, t0.id_user_nav_web AS id_user_nav_web_64, t0.id_pass_nav_web AS id_pass_nav_web_65, t0.ftp_in_all_directory AS ftp_in_all_directory_66, t0.type_check_email AS type_check_email_67, t0.save_attachments_email AS save_attachments_email_68, t0.object_type_nav_web AS object_type_nav_web_69, t0.information_text AS information_text_70, t0.call_flag_send AS call_flag_send_71, t0.text_to_speech_flag_call AS text_to_speech_flag_call_72, t0.text_to_speech_number_call AS text_to_speech_number_call_73, t0.text_to_speech_text_send_call AS text_to_speech_text_send_call_74, t0.uccx_flag_call AS uccx_flag_call_75, t0.uccx_number_call AS uccx_number_call_76, t0.uccx_prompt_message AS uccx_prompt_message_77, t0.uccx_confirm_message AS uccx_confirm_message_78, t0.sms_flag_send AS sms_flag_send_79, t0.sms_number AS sms_number_80, t0.sms_text_send AS sms_text_send_81, t0.telegram_flag_send AS telegram_flag_send_82, t0.telegram_chat AS telegram_chat_83, t0.telegram_text_send AS telegram_text_send_84, t0.config_json AS config_json_85, t0.url_nav_web AS url_nav_web_86, t0.user_nav_web AS user_nav_web_87, t0.pass_nav_web AS pass_nav_web_88, t0.object_name_nav_web AS object_name_nav_web_89, t0.nav_web_anonymous AS nav_web_anonymous_90, t0.spool_objectid_nav_web AS spool_objectid_nav_web_91, t0.tars_run_project_name AS tars_run_project_name_92, t0.tars_run_suite_name AS tars_run_suite_name_93, t0.tars_run_path_scenario AS tars_run_path_scenario_94, t0.tars_run_nome_scenario AS tars_run_nome_scenario_95, t0.tars_run_identificativo AS tars_run_identificativo_96, t0.tars_run_parametro_default AS tars_run_parametro_default_97, t0.tars_run_user AS tars_run_user_98, t0.tars_run_ipaddress AS tars_run_ipaddress_99, t0.tars_run_hostname AS tars_run_hostname_100, t0.tars_run_password AS tars_run_password_101, t0.tars_run_use_password AS tars_run_use_password_102, t0.use_certificate_db AS use_certificate_db_103 FROM task t0 WHERE t0.id = 6758;

SELECT
  t0.server_order AS server_order_1,
  t0.id AS id_2,
  t0.task_id AS task_id_3,
  t0.task_id AS task_id_4,
  t0.server_id AS server_id_5
FROM
  task2server t0
WHERE
  t0.task_id = ?

SELECT t0.server_order AS server_order_1, t0.id AS id_2, t0.task_id AS task_id_3, t0.task_id AS task_id_4, t0.server_id AS server_id_5 FROM task2server t0 WHERE t0.task_id = 6758;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.cmd_type AS cmd_type_3,
  t0.cmd_text AS cmd_text_4,
  t0.return_type AS return_type_5,
  t0.match_operator AS match_operator_6,
  t0.match_value AS match_value_7,
  t0.grep_stdout_fail AS grep_stdout_fail_8,
  t0.grep_stderr_fail AS grep_stderr_fail_9,
  t0.cmd_max_retry AS cmd_max_retry_10,
  t0.cmd_time_retry AS cmd_time_retry_11,
  t0.ko_hint AS ko_hint_12,
  t0.id AS id_13,
  t0.type_db AS type_db_14,
  t0.ip_db AS ip_db_15,
  t0.user_db AS user_db_16,
  t0.pwd_db AS pwd_db_17,
  t0.port_db AS port_db_18,
  t0.name_db AS name_db_19,
  t0.service AS service_20,
  t0.flag_stop_checklist_task AS flag_stop_checklist_task_21,
  t0.flag_jump_task AS flag_jump_task_22,
  t0.next_task AS next_task_23,
  t0.connection_direct AS connection_direct_24,
  t0.statement_select AS statement_select_25,
  t0.auth_username AS auth_username_26,
  t0.auth_password AS auth_password_27,
  t0.auth_protocol AS auth_protocol_28,
  t0.auth_port AS auth_port_29,
  t0.auth_url AS auth_url_30,
  t0.auth_type AS auth_type_31,
  t0.auth_token AS auth_token_32,
  t0.flag_run_as AS flag_run_as_33,
  t0.run_as_user AS run_as_user_34,
  t0.flag_run_as_user_password AS flag_run_as_user_password_35,
  t0.run_as_password AS run_as_password_36,
  t0.flag_check_exit_status AS flag_check_exit_status_37,
  t0.flag_check_count_query AS flag_check_count_query_38,
  t0.flag_mail_attachment AS flag_mail_attachment_39,
  t0.mail_attachment AS mail_attachment_40,
  t0.send_to_mail AS send_to_mail_41,
  t0.send_cc_mail AS send_cc_mail_42,
  t0.send_text_mail AS send_text_mail_43,
  t0.send_object_mail AS send_object_mail_44,
  t0.spool_on_file AS spool_on_file_45,
  t0.filename_spool_query AS filename_spool_query_46,
  t0.ftp_anonymous AS ftp_anonymous_47,
  t0.ftp_hostname AS ftp_hostname_48,
  t0.ftp_port AS ftp_port_49,
  t0.ftp_user AS ftp_user_50,
  t0.ftp_password AS ftp_password_51,
  t0.ftp_directory AS ftp_directory_52,
  t0.ftp_filename AS ftp_filename_53,
  t0.configure_timeout AS configure_timeout_54,
  t0.server_check_email AS server_check_email_55,
  t0.port_check_email AS port_check_email_56,
  t0.user_check_email AS user_check_email_57,
  t0.pass_check_email AS pass_check_email_58,
  t0.from_check_email AS from_check_email_59,
  t0.subject_check_email AS subject_check_email_60,
  t0.body_check_email AS body_check_email_61,
  t0.attempt_check_email AS attempt_check_email_62,
  t0.polling_check_email AS polling_check_email_63,
  t0.id_user_nav_web AS id_user_nav_web_64,
  t0.id_pass_nav_web AS id_pass_nav_web_65,
  t0.ftp_in_all_directory AS ftp_in_all_directory_66,
  t0.type_check_email AS type_check_email_67,
  t0.save_attachments_email AS save_attachments_email_68,
  t0.object_type_nav_web AS object_type_nav_web_69,
  t0.information_text AS information_text_70,
  t0.call_flag_send AS call_flag_send_71,
  t0.text_to_speech_flag_call AS text_to_speech_flag_call_72,
  t0.text_to_speech_number_call AS text_to_speech_number_call_73,
  t0.text_to_speech_text_send_call AS text_to_speech_text_send_call_74,
  t0.uccx_flag_call AS uccx_flag_call_75,
  t0.uccx_number_call AS uccx_number_call_76,
  t0.uccx_prompt_message AS uccx_prompt_message_77,
  t0.uccx_confirm_message AS uccx_confirm_message_78,
  t0.sms_flag_send AS sms_flag_send_79,
  t0.sms_number AS sms_number_80,
  t0.sms_text_send AS sms_text_send_81,
  t0.telegram_flag_send AS telegram_flag_send_82,
  t0.telegram_chat AS telegram_chat_83,
  t0.telegram_text_send AS telegram_text_send_84,
  t0.config_json AS config_json_85,
  t0.url_nav_web AS url_nav_web_86,
  t0.user_nav_web AS user_nav_web_87,
  t0.pass_nav_web AS pass_nav_web_88,
  t0.object_name_nav_web AS object_name_nav_web_89,
  t0.nav_web_anonymous AS nav_web_anonymous_90,
  t0.spool_objectid_nav_web AS spool_objectid_nav_web_91,
  t0.tars_run_project_name AS tars_run_project_name_92,
  t0.tars_run_suite_name AS tars_run_suite_name_93,
  t0.tars_run_path_scenario AS tars_run_path_scenario_94,
  t0.tars_run_nome_scenario AS tars_run_nome_scenario_95,
  t0.tars_run_identificativo AS tars_run_identificativo_96,
  t0.tars_run_parametro_default AS tars_run_parametro_default_97,
  t0.tars_run_user AS tars_run_user_98,
  t0.tars_run_ipaddress AS tars_run_ipaddress_99,
  t0.tars_run_hostname AS tars_run_hostname_100,
  t0.tars_run_password AS tars_run_password_101,
  t0.tars_run_use_password AS tars_run_use_password_102,
  t0.use_certificate_db AS use_certificate_db_103
FROM
  task t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.cmd_type AS cmd_type_3, t0.cmd_text AS cmd_text_4, t0.return_type AS return_type_5, t0.match_operator AS match_operator_6, t0.match_value AS match_value_7, t0.grep_stdout_fail AS grep_stdout_fail_8, t0.grep_stderr_fail AS grep_stderr_fail_9, t0.cmd_max_retry AS cmd_max_retry_10, t0.cmd_time_retry AS cmd_time_retry_11, t0.ko_hint AS ko_hint_12, t0.id AS id_13, t0.type_db AS type_db_14, t0.ip_db AS ip_db_15, t0.user_db AS user_db_16, t0.pwd_db AS pwd_db_17, t0.port_db AS port_db_18, t0.name_db AS name_db_19, t0.service AS service_20, t0.flag_stop_checklist_task AS flag_stop_checklist_task_21, t0.flag_jump_task AS flag_jump_task_22, t0.next_task AS next_task_23, t0.connection_direct AS connection_direct_24, t0.statement_select AS statement_select_25, t0.auth_username AS auth_username_26, t0.auth_password AS auth_password_27, t0.auth_protocol AS auth_protocol_28, t0.auth_port AS auth_port_29, t0.auth_url AS auth_url_30, t0.auth_type AS auth_type_31, t0.auth_token AS auth_token_32, t0.flag_run_as AS flag_run_as_33, t0.run_as_user AS run_as_user_34, t0.flag_run_as_user_password AS flag_run_as_user_password_35, t0.run_as_password AS run_as_password_36, t0.flag_check_exit_status AS flag_check_exit_status_37, t0.flag_check_count_query AS flag_check_count_query_38, t0.flag_mail_attachment AS flag_mail_attachment_39, t0.mail_attachment AS mail_attachment_40, t0.send_to_mail AS send_to_mail_41, t0.send_cc_mail AS send_cc_mail_42, t0.send_text_mail AS send_text_mail_43, t0.send_object_mail AS send_object_mail_44, t0.spool_on_file AS spool_on_file_45, t0.filename_spool_query AS filename_spool_query_46, t0.ftp_anonymous AS ftp_anonymous_47, t0.ftp_hostname AS ftp_hostname_48, t0.ftp_port AS ftp_port_49, t0.ftp_user AS ftp_user_50, t0.ftp_password AS ftp_password_51, t0.ftp_directory AS ftp_directory_52, t0.ftp_filename AS ftp_filename_53, t0.configure_timeout AS configure_timeout_54, t0.server_check_email AS server_check_email_55, t0.port_check_email AS port_check_email_56, t0.user_check_email AS user_check_email_57, t0.pass_check_email AS pass_check_email_58, t0.from_check_email AS from_check_email_59, t0.subject_check_email AS subject_check_email_60, t0.body_check_email AS body_check_email_61, t0.attempt_check_email AS attempt_check_email_62, t0.polling_check_email AS polling_check_email_63, t0.id_user_nav_web AS id_user_nav_web_64, t0.id_pass_nav_web AS id_pass_nav_web_65, t0.ftp_in_all_directory AS ftp_in_all_directory_66, t0.type_check_email AS type_check_email_67, t0.save_attachments_email AS save_attachments_email_68, t0.object_type_nav_web AS object_type_nav_web_69, t0.information_text AS information_text_70, t0.call_flag_send AS call_flag_send_71, t0.text_to_speech_flag_call AS text_to_speech_flag_call_72, t0.text_to_speech_number_call AS text_to_speech_number_call_73, t0.text_to_speech_text_send_call AS text_to_speech_text_send_call_74, t0.uccx_flag_call AS uccx_flag_call_75, t0.uccx_number_call AS uccx_number_call_76, t0.uccx_prompt_message AS uccx_prompt_message_77, t0.uccx_confirm_message AS uccx_confirm_message_78, t0.sms_flag_send AS sms_flag_send_79, t0.sms_number AS sms_number_80, t0.sms_text_send AS sms_text_send_81, t0.telegram_flag_send AS telegram_flag_send_82, t0.telegram_chat AS telegram_chat_83, t0.telegram_text_send AS telegram_text_send_84, t0.config_json AS config_json_85, t0.url_nav_web AS url_nav_web_86, t0.user_nav_web AS user_nav_web_87, t0.pass_nav_web AS pass_nav_web_88, t0.object_name_nav_web AS object_name_nav_web_89, t0.nav_web_anonymous AS nav_web_anonymous_90, t0.spool_objectid_nav_web AS spool_objectid_nav_web_91, t0.tars_run_project_name AS tars_run_project_name_92, t0.tars_run_suite_name AS tars_run_suite_name_93, t0.tars_run_path_scenario AS tars_run_path_scenario_94, t0.tars_run_nome_scenario AS tars_run_nome_scenario_95, t0.tars_run_identificativo AS tars_run_identificativo_96, t0.tars_run_parametro_default AS tars_run_parametro_default_97, t0.tars_run_user AS tars_run_user_98, t0.tars_run_ipaddress AS tars_run_ipaddress_99, t0.tars_run_hostname AS tars_run_hostname_100, t0.tars_run_password AS tars_run_password_101, t0.tars_run_use_password AS tars_run_use_password_102, t0.use_certificate_db AS use_certificate_db_103 FROM task t0 WHERE t0.id = 6760;

SELECT
  t0.server_order AS server_order_1,
  t0.id AS id_2,
  t0.task_id AS task_id_3,
  t0.task_id AS task_id_4,
  t0.server_id AS server_id_5
FROM
  task2server t0
WHERE
  t0.task_id = ?

SELECT t0.server_order AS server_order_1, t0.id AS id_2, t0.task_id AS task_id_3, t0.task_id AS task_id_4, t0.server_id AS server_id_5 FROM task2server t0 WHERE t0.task_id = 6760;

SELECT
  t0.hostname AS hostname_1,
  t0.ip_address AS ip_address_2,
  t0.username AS username_3,
  t0.group_name AS group_name_4,
  t0.id AS id_5
FROM
  server t0
WHERE
  t0.id = ?

SELECT t0.hostname AS hostname_1, t0.ip_address AS ip_address_2, t0.username AS username_3, t0.group_name AS group_name_4, t0.id AS id_5 FROM server t0 WHERE t0.id = 148;