Query Metrics
47
Database Queries
17
Different statements
41.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.00 ms (0.00%) |
8 |
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 = ?
Parameters:
[
6756
]
|
|
7.73 ms (0.00%) |
8 |
INSERT INTO chklst_task (name, chklst_id, task_id, task_order, description, cmd_type, cmd_text, return_type, match_operator, match_text, cmd_max_retry, cmd_time_retry, run_start, run_result, run_end, ko_task, ko_hint, slave, flag_bitmask, run_bitmask, type_db, ip_db, user_db, pwd_db, port_db, name_db, service, set_timeout, flag_stop_checklist_task, flag_jump_task, next_task, flag_jump_task_act, next_task_act, flag_jump_ko_act, next_task_ko_act, connection_direct, statement_select, auth_username, auth_password, auth_protocol, auth_port, auth_url, auth_type, auth_token, flag_run_as, run_as_user, flag_run_as_user_password, run_as_password, flag_check_exit_status, flag_check_count_query, flag_mail_attachment, mail_attachment, send_to_mail, send_cc_mail, send_text_mail, send_object_mail, spool_on_file, filename_spool_query, ftp_anonymous, ftp_hostname, ftp_port, ftp_user, ftp_password, ftp_directory, ftp_filename, configure_timeout, server_check_email, port_check_email, user_check_email, pass_check_email, from_check_email, subject_check_email, body_check_email, attempt_check_email, polling_check_email, type_check_email, save_attachments_email, config_json, url_nav_web, user_nav_web, pass_nav_web, object_name_nav_web, nav_web_anonymous, spool_objectid_nav_web, id_user_nav_web, id_pass_nav_web, ftp_in_all_directory, object_type_nav_web, tars_run_project_name, tars_run_suite_name, tars_run_path_scenario, tars_run_nome_scenario, tars_run_identificativo, tars_run_parametro_default, tars_run_user, tars_run_ipaddress, tars_run_hostname, tars_run_password, tars_run_use_password, use_certificate_db, information_text, call_flag_send, text_to_speech_flag_call, text_to_speech_number_call, text_to_speech_text_send_call, uccx_flag_call, uccx_number_call, uccx_prompt_message, uccx_confirm_message, sms_flag_send, sms_number, sms_text_send, telegram_flag_send, telegram_chat, telegram_text_send) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "Get month parameters" 2 => 26637 3 => 6756 4 => 0 5 => "" 6 => "db" 7 => """ SELECT \r\n folder_name as "folder_name", \r\n concat('/mnt/MRP/',folder_name,'_M2') as "folder_path", \r\n mrp_mese as "mrp_mese" \r\n FROM ts_v_mrp_sent \r\n where mrp_month is not null\r\n limit 1 """ 8 => "number" 9 => "=" 10 => "0" 11 => 1 12 => null 13 => null 14 => null 15 => null 16 => null 17 => null 18 => null 19 => true 20 => 0 21 => "mariadb" 22 => "212.237.40.108" 23 => "ts" 24 => "ndIiORhaPiWJr5IxGyUFYof3TJbRCyOZCd47hN7xZ4Q=" 25 => "3306" 26 => "timesheet" 27 => "0" 28 => null 29 => "N" 30 => null 31 => null 32 => null 33 => null 34 => null 35 => null 36 => null 37 => "Y" 38 => null 39 => null 40 => null 41 => null 42 => null 43 => null 44 => null 45 => "N" 46 => null 47 => "N" 48 => null 49 => "N" 50 => "N" 51 => null 52 => null 53 => null 54 => null 55 => null 56 => null 57 => "Y" 58 => "TASK_Get month parameters_queryspool_1776094758.csv" 59 => "Y" 60 => null 61 => "22" 62 => "Anonymous" 63 => null 64 => null 65 => null 66 => null 67 => null 68 => "993" 69 => null 70 => null 71 => null 72 => null 73 => null 74 => null 75 => null 76 => "IMAP" 77 => "N" 78 => "{"connection":{"connection_mode":"manual","env_connection_name":"---","db_type":"mariadb","use_ssl":"N","db_host":"212.237.40.108","db_port":"3306","db_name":"timesheet","oracle_db_name_type":"","db_user":"ts","db_password":"ndIiORhaPiWJr5IxGyUFYof3TJbRCyOZCd47hN7xZ4Q=","hidden_task_pwd":"0"},"tablestructure":[{"field_name":"folder_name","field_value":"folder_name","field_type":"expression","field_precision":"100","field_format":"","field_nullable":"Y"},{"field_name":"folder_path","field_value":"concat('\/mnt\/MRP\/',folder_name,'_M2')","field_type":"expression","field_precision":"100","field_format":"","field_nullable":"Y"},{"field_name":"mrp_mese","field_value":"mrp_mese","field_type":"expression","field_precision":"100","field_format":"","field_nullable":"Y"}]}" 79 => null 80 => null 81 => null 82 => null 83 => "Y" 84 => "N" 85 => null 86 => null 87 => "Y" 88 => null 89 => null 90 => null 91 => null 92 => null 93 => null 94 => null 95 => null 96 => null 97 => null 98 => null 99 => null 100 => "N" 101 => null 102 => null 103 => null 104 => null 105 => null 106 => null 107 => null 108 => null 109 => null 110 => null 111 => null 112 => null 113 => null 114 => null 115 => null ] |
|
6.65 ms (0.00%) |
1 |
SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type != 'VIEW'
Parameters:
[] |
|
2.98 ms (0.00%) |
8 |
INSERT INTO task_server (hostname, ip_address, username, group_name, server_order, run_result, result_text, full_result, task_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "" 2 => "" 3 => "" 4 => null 5 => 0 6 => null 7 => null 8 => null 9 => 188957 ] |
|
2.60 ms (0.00%) |
1 |
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
Parameters:
[ "name" => "Main_MRP_M2" "description" => "" "run_user_id" => 1 "from_template_id" => "1283" ] |
|
2.46 ms (0.00%) |
8 |
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 = ?
Parameters:
[
6756
]
|
|
2.34 ms (0.00%) |
1 |
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 = ?
Parameters:
[
1283
]
|
|
1.84 ms (0.00%) |
1 |
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 = ?
Parameters:
[
"1283"
]
|
|
1.83 ms (0.00%) |
1 |
SELECT * FROM sybot.wfl_schedule WHERE schedule_id = :scheduleId
Parameters:
[ "scheduleId" => 20 ] |
|
1.12 ms (0.00%) |
3 |
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 = ?
Parameters:
[
1
]
|
|
0.76 ms (0.00%) |
1 |
INSERT INTO queue (run_start, id_schedule, schedule_date, sycore_instance_uuid, chklst_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 => null 2 => null 3 => null 4 => "228865ff-4d49-4461-be29-f8495f07b825" 5 => 26637 ] |
|
0.75 ms (0.00%) |
1 |
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 = ?
Parameters:
[
"26637"
]
|
|
0.69 ms (0.00%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.56 ms (0.00%) |
1 |
select param_name, param_value , param_type from chklst_template_parameters where chklst_id = :template_id
Parameters:
[ "template_id" => "1283" ] |
|
0.56 ms (0.00%) |
1 |
SELECT nspname FROM pg_namespace WHERE nspname !~ '^pg_.*' AND nspname != 'information_schema'
Parameters:
[] |
|
0.21 ms (0.00%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.16 ms (0.00%) |
1 |
SHOW search_path
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ChklstTemplate | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\Chklst | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ChklstTask | No errors. |
| App\Entity\Chklsttmpl2task | No errors. |
| App\Entity\Action | No errors. |
| App\Entity\Task2server | No errors. |
| App\Entity\Server | No errors. |
| App\Entity\TaskServer | No errors. |
| App\Entity\Queue | No errors. |