******************** Script profiler ******************** Total time: 5.625996 Total SQL time: 5.584592 SQL count: 56 (selects: 48 | executes: 24) Peak memory usage: 14M Memory limit: 1G 1. role.get [CRoleHelper.php:178] Parameters: Array ( [output] => Array ( [0] => roleid [1] => name [2] => type ) [selectRules] => Array ( [0] => ui [1] => ui.default_access [2] => modules [3] => modules.default_access [4] => api.access [5] => api.mode [6] => api [7] => actions [8] => actions.default_access ) [roleids] => 2 ) Result: Array ( [0] => Array ( [roleid] => 2 [name] => Admin role [type] => 2 [rules] => Array ( [ui] => Array ( [0] => Array ( [name] => monitoring.dashboard [status] => 1 ) [1] => Array ( [name] => monitoring.problems [status] => 1 ) [2] => Array ( [name] => monitoring.hosts [status] => 1 ) [3] => Array ( [name] => monitoring.latest_data [status] => 1 ) [4] => Array ( [name] => monitoring.maps [status] => 1 ) [5] => Array ( [name] => services.services [status] => 1 ) [6] => Array ( [name] => services.sla_report [status] => 1 ) [7] => Array ( [name] => inventory.overview [status] => 1 ) [8] => Array ( [name] => inventory.hosts [status] => 1 ) [9] => Array ( [name] => reports.availability_report [status] => 1 ) [10] => Array ( [name] => reports.top_triggers [status] => 1 ) [11] => Array ( [name] => monitoring.discovery [status] => 1 ) [12] => Array ( [name] => services.sla [status] => 1 ) [13] => Array ( [name] => reports.scheduled_reports [status] => 1 ) [14] => Array ( [name] => reports.notifications [status] => 1 ) [15] => Array ( [name] => configuration.template_groups [status] => 1 ) [16] => Array ( [name] => configuration.host_groups [status] => 1 ) [17] => Array ( [name] => configuration.templates [status] => 1 ) [18] => Array ( [name] => configuration.hosts [status] => 1 ) [19] => Array ( [name] => configuration.maintenance [status] => 1 ) [20] => Array ( [name] => configuration.discovery [status] => 1 ) [21] => Array ( [name] => configuration.trigger_actions [status] => 1 ) [22] => Array ( [name] => configuration.service_actions [status] => 1 ) [23] => Array ( [name] => configuration.discovery_actions [status] => 1 ) [24] => Array ( [name] => configuration.autoregistration_actions [status] => 1 ) [25] => Array ( [name] => configuration.internal_actions [status] => 1 ) ) [ui.default_access] => 1 [modules] => Array ( [0] => Array ( [moduleid] => 1 [status] => 1 ) [1] => Array ( [moduleid] => 2 [status] => 1 ) [2] => Array ( [moduleid] => 3 [status] => 1 ) [3] => Array ( [moduleid] => 4 [status] => 1 ) [4] => Array ( [moduleid] => 5 [status] => 1 ) [5] => Array ( [moduleid] => 6 [status] => 1 ) [6] => Array ( [moduleid] => 7 [status] => 1 ) [7] => Array ( [moduleid] => 8 [status] => 1 ) [8] => Array ( [moduleid] => 9 [status] => 1 ) [9] => Array ( [moduleid] => 10 [status] => 1 ) [10] => Array ( [moduleid] => 11 [status] => 1 ) [11] => Array ( [moduleid] => 12 [status] => 1 ) [12] => Array ( [moduleid] => 13 [status] => 1 ) [13] => Array ( [moduleid] => 14 [status] => 1 ) [14] => Array ( [moduleid] => 15 [status] => 1 ) [15] => Array ( [moduleid] => 16 [status] => 1 ) [16] => Array ( [moduleid] => 17 [status] => 1 ) [17] => Array ( [moduleid] => 18 [status] => 1 ) [18] => Array ( [moduleid] => 19 [status] => 1 ) [19] => Array ( [moduleid] => 20 [status] => 1 ) [20] => Array ( [moduleid] => 21 [status] => 1 ) [21] => Array ( [moduleid] => 22 [status] => 1 ) [22] => Array ( [moduleid] => 23 [status] => 1 ) [23] => Array ( [moduleid] => 24 [status] => 1 ) [24] => Array ( [moduleid] => 25 [status] => 1 ) [25] => Array ( [moduleid] => 26 [status] => 1 ) [26] => Array ( [moduleid] => 27 [status] => 1 ) [27] => Array ( [moduleid] => 28 [status] => 1 ) [28] => Array ( [moduleid] => 29 [status] => 1 ) [29] => Array ( [moduleid] => 30 [status] => 1 ) ) [modules.default_access] => 1 [api.access] => 1 [api.mode] => 0 [api] => Array ( ) [actions] => Array ( [0] => Array ( [name] => edit_dashboards [status] => 1 ) [1] => Array ( [name] => edit_maps [status] => 1 ) [2] => Array ( [name] => acknowledge_problems [status] => 1 ) [3] => Array ( [name] => suppress_problems [status] => 1 ) [4] => Array ( [name] => close_problems [status] => 1 ) [5] => Array ( [name] => change_severity [status] => 1 ) [6] => Array ( [name] => add_problem_comments [status] => 1 ) [7] => Array ( [name] => execute_scripts [status] => 1 ) [8] => Array ( [name] => manage_api_tokens [status] => 1 ) [9] => Array ( [name] => edit_maintenance [status] => 1 ) [10] => Array ( [name] => manage_scheduled_reports [status] => 1 ) [11] => Array ( [name] => manage_sla [status] => 1 ) [12] => Array ( [name] => invoke_execute_now [status] => 1 ) [13] => Array ( [name] => change_problem_ranking [status] => 1 ) ) [actions.default_access] => 1 ) ) ) 2. settings.get [CSettingsHelper.php:114] Parameters: Array ( [output] => Array ( [0] => default_theme [1] => search_limit [2] => max_in_table [3] => server_check_interval [4] => work_period [5] => show_technical_errors [6] => history_period [7] => period_default [8] => max_period [9] => severity_color_0 [10] => severity_color_1 [11] => severity_color_2 [12] => severity_color_3 [13] => severity_color_4 [14] => severity_color_5 [15] => severity_name_0 [16] => severity_name_1 [17] => severity_name_2 [18] => severity_name_3 [19] => severity_name_4 [20] => severity_name_5 [21] => custom_color [22] => ok_period [23] => blink_period [24] => problem_unack_color [25] => problem_ack_color [26] => ok_unack_color [27] => ok_ack_color [28] => problem_unack_style [29] => problem_ack_style [30] => ok_unack_style [31] => ok_ack_style [32] => discovery_groupid [33] => default_inventory_mode [34] => alert_usrgrpid [35] => snmptrap_logging [36] => default_lang [37] => default_timezone [38] => login_attempts [39] => login_block [40] => validate_uri_schemes [41] => uri_valid_schemes [42] => x_frame_options [43] => iframe_sandboxing_enabled [44] => iframe_sandboxing_exceptions [45] => max_overview_table_size [46] => connect_timeout [47] => socket_timeout [48] => media_type_test_timeout [49] => script_timeout [50] => item_test_timeout [51] => url [52] => report_test_timeout [53] => auditlog_enabled [54] => auditlog_mode [55] => ha_failover_delay [56] => geomaps_tile_provider [57] => geomaps_tile_url [58] => geomaps_max_zoom [59] => geomaps_attribution [60] => vault_provider [61] => timeout_zabbix_agent [62] => timeout_simple_check [63] => timeout_snmp_agent [64] => timeout_external_check [65] => timeout_db_monitor [66] => timeout_http_agent [67] => timeout_ssh_agent [68] => timeout_telnet_agent [69] => timeout_script [70] => timeout_browser ) ) Result: Array ( [default_theme] => blue-theme [search_limit] => 5000 [max_in_table] => 50 [server_check_interval] => 10 [work_period] => 1-5,09:00-18:00 [show_technical_errors] => 0 [history_period] => 24h [period_default] => 1h [max_period] => 1y [severity_color_0] => 97AAB3 [severity_color_1] => 7499FF [severity_color_2] => FFC859 [severity_color_3] => FFA059 [severity_color_4] => E97659 [severity_color_5] => E45959 [severity_name_0] => Not classified [severity_name_1] => Information [severity_name_2] => Warning [severity_name_3] => Average [severity_name_4] => High [severity_name_5] => Disaster [custom_color] => 0 [ok_period] => 5m [blink_period] => 2m [problem_unack_color] => CC0000 [problem_ack_color] => CC0000 [ok_unack_color] => 009900 [ok_ack_color] => 009900 [problem_unack_style] => 1 [problem_ack_style] => 1 [ok_unack_style] => 1 [ok_ack_style] => 1 [discovery_groupid] => 26 [default_inventory_mode] => -1 [alert_usrgrpid] => 7 [snmptrap_logging] => 1 [default_lang] => en_GB [default_timezone] => Europe/Stockholm [login_attempts] => 5 [login_block] => 30s [validate_uri_schemes] => 1 [uri_valid_schemes] => http,https,ftp,file,mailto,tel,ssh [x_frame_options] => SAMEORIGIN [iframe_sandboxing_enabled] => 1 [iframe_sandboxing_exceptions] => [max_overview_table_size] => 50 [connect_timeout] => 3s [socket_timeout] => 3s [media_type_test_timeout] => 65s [script_timeout] => 60s [item_test_timeout] => 60s [url] => [report_test_timeout] => 60s [auditlog_enabled] => 1 [auditlog_mode] => 1 [ha_failover_delay] => 1m [geomaps_tile_provider] => OpenStreetMap.Mapnik [geomaps_tile_url] => [geomaps_max_zoom] => 0 [geomaps_attribution] => [vault_provider] => 0 [timeout_zabbix_agent] => 3s [timeout_simple_check] => 3s [timeout_snmp_agent] => 3s [timeout_external_check] => 3s [timeout_db_monitor] => 3s [timeout_http_agent] => 3s [timeout_ssh_agent] => 3s [timeout_telnet_agent] => 3s [timeout_script] => 3s [timeout_browser] => 60s ) 3. host.get [CControllerHost.php:114] Parameters: Array ( [output] => Array ( [0] => hostid [1] => name [2] => status ) [evaltype] => 0 [tags] => Array ( ) [inheritedTags] => 1 [groupids] => [severities] => [withProblemsSuppressed] => [search] => Array ( [name] => [ip] => [dns] => ) [filter] => Array ( [status] => [port] => [maintenance_status] => ) [sortfield] => name [limit] => 5001 [preservekeys] => 1 ) Result: Array ( [10084] => Array ( [hostid] => 10084 [name] => Zabbix server [status] => 0 ) ) 4. host.get [CControllerHost.php:152] Parameters: Array ( [output] => Array ( [0] => hostid [1] => name [2] => status [3] => maintenance_status [4] => maintenanceid [5] => maintenance_type [6] => active_available ) [selectInterfaces] => Array ( [0] => interfaceid [1] => ip [2] => dns [3] => port [4] => main [5] => type [6] => useip [7] => available [8] => error [9] => details ) [selectGraphs] => count [selectHttpTests] => count [selectTags] => Array ( [0] => tag [1] => value ) [selectInheritedTags] => Array ( [0] => tag [1] => value ) [hostids] => Array ( [0] => 10084 ) [preservekeys] => 1 ) Result: Array ( [10084] => Array ( [hostid] => 10084 [name] => Zabbix server [status] => 0 [maintenance_status] => 0 [maintenanceid] => 0 [maintenance_type] => 0 [active_available] => 0 [graphs] => 40 [httpTests] => 0 [interfaces] => Array ( [0] => Array ( [interfaceid] => 1 [ip] => 127.0.0.1 [dns] => [port] => 11050 [main] => 1 [type] => 1 [useip] => 1 [available] => 1 [error] => [details] => Array ( ) ) ) [tags] => Array ( ) [inheritedTags] => Array ( [0] => Array ( [tag] => class [value] => software ) [1] => Array ( [tag] => target [value] => server ) [2] => Array ( [tag] => target [value] => zabbix ) [3] => Array ( [tag] => class [value] => os ) [4] => Array ( [tag] => target [value] => linux ) ) ) ) 5. item.get [items.inc.php:2696] Parameters: Array ( [countOutput] => 1 [groupCount] => 1 [interfaceids] => Array ( [0] => 1 ) [filter] => Array ( [status] => 0 ) ) Result: Array ( [0] => Array ( [rowscount] => 52 [interfaceid] => 1 ) ) 6. item.get [items.inc.php:2676] Parameters: Array ( [countOutput] => 1 [groupCount] => 1 [hostids] => Array ( [0] => 10084 ) [filter] => Array ( [type] => 7 [status] => 0 ) ) Result: Array ( ) 7. trigger.get [CControllerHost.php:183] Parameters: Array ( [output] => Array ( ) [selectHosts] => Array ( [0] => hostid ) [hostids] => Array ( [0] => 10084 ) [skipDependent] => 1 [monitored] => 1 [preservekeys] => 1 ) Result: Array ( [13075] => Array ( [triggerid] => 13075 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13467] => Array ( [triggerid] => 13467 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13468] => Array ( [triggerid] => 13468 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13471] => Array ( [triggerid] => 13471 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13472] => Array ( [triggerid] => 13472 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13473] => Array ( [triggerid] => 13473 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13475] => Array ( [triggerid] => 13475 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13479] => Array ( [triggerid] => 13479 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13480] => Array ( [triggerid] => 13480 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13481] => Array ( [triggerid] => 13481 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13483] => Array ( [triggerid] => 13483 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13484] => Array ( [triggerid] => 13484 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13485] => Array ( [triggerid] => 13485 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13486] => Array ( [triggerid] => 13486 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13487] => Array ( [triggerid] => 13487 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13488] => Array ( [triggerid] => 13488 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13489] => Array ( [triggerid] => 13489 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13490] => Array ( [triggerid] => 13490 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13558] => Array ( [triggerid] => 13558 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13560] => Array ( [triggerid] => 13560 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13567] => Array ( [triggerid] => 13567 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13570] => Array ( [triggerid] => 13570 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [13571] => Array ( [triggerid] => 13571 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [15854] => Array ( [triggerid] => 15854 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [15856] => Array ( [triggerid] => 15856 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [16274] => Array ( [triggerid] => 16274 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [17537] => Array ( [triggerid] => 17537 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [17538] => Array ( [triggerid] => 17538 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [18981] => Array ( [triggerid] => 18981 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [18982] => Array ( [triggerid] => 18982 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [18983] => Array ( [triggerid] => 18983 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [21198] => Array ( [triggerid] => 21198 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22382] => Array ( [triggerid] => 22382 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22383] => Array ( [triggerid] => 22383 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22384] => Array ( [triggerid] => 22384 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22385] => Array ( [triggerid] => 22385 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22386] => Array ( [triggerid] => 22386 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22387] => Array ( [triggerid] => 22387 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22388] => Array ( [triggerid] => 22388 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22389] => Array ( [triggerid] => 22389 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22390] => Array ( [triggerid] => 22390 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22391] => Array ( [triggerid] => 22391 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22392] => Array ( [triggerid] => 22392 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22393] => Array ( [triggerid] => 22393 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22394] => Array ( [triggerid] => 22394 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [22395] => Array ( [triggerid] => 22395 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23162] => Array ( [triggerid] => 23162 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23288] => Array ( [triggerid] => 23288 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23289] => Array ( [triggerid] => 23289 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23299] => Array ( [triggerid] => 23299 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23300] => Array ( [triggerid] => 23300 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23396] => Array ( [triggerid] => 23396 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23732] => Array ( [triggerid] => 23732 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23733] => Array ( [triggerid] => 23733 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23734] => Array ( [triggerid] => 23734 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23735] => Array ( [triggerid] => 23735 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23944] => Array ( [triggerid] => 23944 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23945] => Array ( [triggerid] => 23945 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23946] => Array ( [triggerid] => 23946 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23947] => Array ( [triggerid] => 23947 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23948] => Array ( [triggerid] => 23948 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23949] => Array ( [triggerid] => 23949 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23950] => Array ( [triggerid] => 23950 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23951] => Array ( [triggerid] => 23951 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23952] => Array ( [triggerid] => 23952 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23953] => Array ( [triggerid] => 23953 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23954] => Array ( [triggerid] => 23954 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23955] => Array ( [triggerid] => 23955 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23956] => Array ( [triggerid] => 23956 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23957] => Array ( [triggerid] => 23957 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23958] => Array ( [triggerid] => 23958 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23959] => Array ( [triggerid] => 23959 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23960] => Array ( [triggerid] => 23960 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23961] => Array ( [triggerid] => 23961 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23962] => Array ( [triggerid] => 23962 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23963] => Array ( [triggerid] => 23963 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23964] => Array ( [triggerid] => 23964 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23965] => Array ( [triggerid] => 23965 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23966] => Array ( [triggerid] => 23966 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23967] => Array ( [triggerid] => 23967 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23968] => Array ( [triggerid] => 23968 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23969] => Array ( [triggerid] => 23969 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23970] => Array ( [triggerid] => 23970 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23971] => Array ( [triggerid] => 23971 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23972] => Array ( [triggerid] => 23972 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23973] => Array ( [triggerid] => 23973 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23974] => Array ( [triggerid] => 23974 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23975] => Array ( [triggerid] => 23975 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23976] => Array ( [triggerid] => 23976 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23977] => Array ( [triggerid] => 23977 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23978] => Array ( [triggerid] => 23978 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23979] => Array ( [triggerid] => 23979 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23980] => Array ( [triggerid] => 23980 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23981] => Array ( [triggerid] => 23981 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23982] => Array ( [triggerid] => 23982 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23983] => Array ( [triggerid] => 23983 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23984] => Array ( [triggerid] => 23984 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23985] => Array ( [triggerid] => 23985 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23986] => Array ( [triggerid] => 23986 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23987] => Array ( [triggerid] => 23987 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23988] => Array ( [triggerid] => 23988 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23989] => Array ( [triggerid] => 23989 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23990] => Array ( [triggerid] => 23990 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23991] => Array ( [triggerid] => 23991 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23992] => Array ( [triggerid] => 23992 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23993] => Array ( [triggerid] => 23993 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23994] => Array ( [triggerid] => 23994 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23995] => Array ( [triggerid] => 23995 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23996] => Array ( [triggerid] => 23996 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23997] => Array ( [triggerid] => 23997 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23998] => Array ( [triggerid] => 23998 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [23999] => Array ( [triggerid] => 23999 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24000] => Array ( [triggerid] => 24000 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24008] => Array ( [triggerid] => 24008 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24009] => Array ( [triggerid] => 24009 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24010] => Array ( [triggerid] => 24010 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24011] => Array ( [triggerid] => 24011 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24012] => Array ( [triggerid] => 24012 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24013] => Array ( [triggerid] => 24013 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24014] => Array ( [triggerid] => 24014 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24015] => Array ( [triggerid] => 24015 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24330] => Array ( [triggerid] => 24330 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24331] => Array ( [triggerid] => 24331 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24332] => Array ( [triggerid] => 24332 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24333] => Array ( [triggerid] => 24333 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24334] => Array ( [triggerid] => 24334 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24335] => Array ( [triggerid] => 24335 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) [24336] => Array ( [triggerid] => 24336 [hosts] => Array ( [0] => Array ( [hostid] => 10084 ) ) ) ) 8. problem.get [CControllerHost.php:192] Parameters: Array ( [output] => Array ( [0] => eventid [1] => objectid [2] => severity ) [source] => 0 [object] => 0 [objectids] => Array ( [0] => 13075 [1] => 13467 [2] => 13468 [3] => 13471 [4] => 13472 [5] => 13473 [6] => 13475 [7] => 13479 [8] => 13480 [9] => 13481 [10] => 13483 [11] => 13484 [12] => 13485 [13] => 13486 [14] => 13487 [15] => 13488 [16] => 13489 [17] => 13490 [18] => 13558 [19] => 13560 [20] => 13567 [21] => 13570 [22] => 13571 [23] => 15854 [24] => 15856 [25] => 16274 [26] => 17537 [27] => 17538 [28] => 18981 [29] => 18982 [30] => 18983 [31] => 21198 [32] => 22382 [33] => 22383 [34] => 22384 [35] => 22385 [36] => 22386 [37] => 22387 [38] => 22388 [39] => 22389 [40] => 22390 [41] => 22391 [42] => 22392 [43] => 22393 [44] => 22394 [45] => 22395 [46] => 23162 [47] => 23288 [48] => 23289 [49] => 23299 [50] => 23300 [51] => 23396 [52] => 23732 [53] => 23733 [54] => 23734 [55] => 23735 [56] => 23944 [57] => 23945 [58] => 23946 [59] => 23947 [60] => 23948 [61] => 23949 [62] => 23950 [63] => 23951 [64] => 23952 [65] => 23953 [66] => 23954 [67] => 23955 [68] => 23956 [69] => 23957 [70] => 23958 [71] => 23959 [72] => 23960 [73] => 23961 [74] => 23962 [75] => 23963 [76] => 23964 [77] => 23965 [78] => 23966 [79] => 23967 [80] => 23968 [81] => 23969 [82] => 23970 [83] => 23971 [84] => 23972 [85] => 23973 [86] => 23974 [87] => 23975 [88] => 23976 [89] => 23977 [90] => 23978 [91] => 23979 [92] => 23980 [93] => 23981 [94] => 23982 [95] => 23983 [96] => 23984 [97] => 23985 [98] => 23986 [99] => 23987 [100] => 23988 [101] => 23989 [102] => 23990 [103] => 23991 [104] => 23992 [105] => 23993 [106] => 23994 [107] => 23995 [108] => 23996 [109] => 23997 [110] => 23998 [111] => 23999 [112] => 24000 [113] => 24008 [114] => 24009 [115] => 24010 [116] => 24011 [117] => 24012 [118] => 24013 [119] => 24014 [120] => 24015 [121] => 24330 [122] => 24331 [123] => 24332 [124] => 24333 [125] => 24334 [126] => 24335 [127] => 24336 ) [suppressed] => [symptom] => ) Result: Array ( ) 9. item.get [CControllerHost.php:201] Parameters: Array ( [countOutput] => 1 [groupCount] => 1 [hostids] => Array ( [0] => 10084 ) [webitems] => 1 [monitored] => 1 ) Result: Array ( [0] => Array ( [rowscount] => 250 [hostid] => 10084 ) ) 10. templatedashboard.get [hosts.inc.php:1212] Parameters: Array ( [output] => Array ( [0] => dashboardid ) [templateids] => Array ( [0] => 10047 [1] => 10001 ) [preservekeys] => 1 ) Result: Array ( [17] => Array ( [dashboardid] => 17 ) [36] => Array ( [dashboardid] => 36 ) [140] => Array ( [dashboardid] => 140 ) [331] => Array ( [dashboardid] => 331 ) ) SQL (0.003474): COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:177 SQL (0.003808): BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:123 SQL (0.003797): SELECT DISTINCT r.roleid,r.name,r.type FROM role r,users u WHERE r.roleid='2' AND r.roleid=u.roleid AND u.userid=3946 zabbix.php:17 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → DBselect() in include/classes/api/services/CRole.php:99 SQL (0.003288): SELECT role_ruleid,roleid,type,name,value_int,value_str,value_moduleid,value_serviceid FROM role_rule WHERE roleid=2 zabbix.php:17 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:911 SQL (0.00294): SELECT md.moduleid FROM module md zabbix.php:17 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → CRole->getRelatedModulesRules() → CRole::getModuleIds() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:72 SQL (0.003269): COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:177 SQL (0.002631): SELECT md.moduleid,md.id,md.relative_path,md.config FROM module md WHERE md.status=1 ORDER BY md.relative_path zabbix.php:17 → require_once() → ZBase->run() → ZBase->initModuleManager() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:72 SQL (0.010138): SELECT NULL FROM users u WHERE u.userid=3946 FOR UPDATE zabbix.php:17 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:31 SQL (0.003458): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3946 AND idx='web.sidebar.mode' zabbix.php:17 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:174 SQL (0.003265): BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CSettingsHelper::get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:123 SQL (0.003957): SELECT c.configid,c.default_theme,c.search_limit,c.max_in_table,c.server_check_interval,c.work_period,c.show_technical_errors,c.history_period,c.period_default,c.max_period,c.severity_color_0,c.severity_color_1,c.severity_color_2,c.severity_color_3,c.severity_color_4,c.severity_color_5,c.severity_name_0,c.severity_name_1,c.severity_name_2,c.severity_name_3,c.severity_name_4,c.severity_name_5,c.custom_color,c.ok_period,c.blink_period,c.problem_unack_color,c.problem_ack_color,c.ok_unack_color,c.ok_ack_color,c.problem_unack_style,c.problem_ack_style,c.ok_unack_style,c.ok_ack_style,c.discovery_groupid,c.default_inventory_mode,c.alert_usrgrpid,c.snmptrap_logging,c.default_lang,c.default_timezone,c.login_attempts,c.login_block,c.validate_uri_schemes,c.uri_valid_schemes,c.x_frame_options,c.iframe_sandboxing_enabled,c.iframe_sandboxing_exceptions,c.max_overview_table_size,c.connect_timeout,c.socket_timeout,c.media_type_test_timeout,c.script_timeout,c.item_test_timeout,c.url,c.report_test_timeout,c.auditlog_enabled,c.auditlog_mode,c.ha_failover_delay,c.geomaps_tile_provider,c.geomaps_tile_url,c.geomaps_max_zoom,c.geomaps_attribution,c.vault_provider,c.timeout_zabbix_agent,c.timeout_simple_check,c.timeout_snmp_agent,c.timeout_external_check,c.timeout_db_monitor,c.timeout_http_agent,c.timeout_ssh_agent,c.timeout_telnet_agent,c.timeout_script,c.timeout_browser FROM config c zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CSettingsHelper::get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CSettings->get() → DBselect() in include/classes/api/services/CSettings.php:68 SQL (0.003846): COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CSettingsHelper::get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:177 SQL (0.002986): BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:123 SQL (0.005733): SELECT DISTINCT h.hostid,h.name,h.status FROM hosts h,host_hgset hh,permission p1 WHERE h.flags IN (0,4) AND h.hostid=hh.hostid AND hh.hgsetid=p1.hgsetid AND p1.ugsetid=1100 AND h.status IN (0,1) ORDER BY h.name LIMIT 5001 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1273 SQL (0.003441): COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:177 SQL (0.003626): BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:123 SQL (0.004484): SELECT DISTINCT h.hostid,h.name,h.status,h.maintenance_status,h.maintenanceid,h.maintenance_type,hr.active_available FROM host_hgset hh,permission p1,hosts h LEFT JOIN host_rtdata hr ON h.hostid=hr.hostid WHERE h.flags IN (0,4) AND h.hostid=hh.hostid AND hh.hgsetid=p1.hgsetid AND p1.ugsetid=1100 AND h.hostid=10084 AND h.status IN (0,1) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1273 SQL (1.666003): SELECT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i,host_hgset hh,permission p WHERE gi.graphid=g.graphid AND i.itemid=gi.itemid AND i.hostid=hh.hostid AND hh.hgsetid=p.hgsetid AND p.ugsetid=1100 AND NOT EXISTS (SELECT NULL FROM graphs_items gi1 JOIN items i1 ON gi1.itemid=i1.itemid JOIN host_hgset hh1 ON i1.hostid=hh1.hostid LEFT JOIN permission p1 ON hh1.hgsetid=p1.hgsetid AND p1.ugsetid=p.ugsetid WHERE g.graphid=gi1.graphid AND p1.permission IS NULL) AND i.hostid=10084 AND g.flags IN (0,4) GROUP BY i.hostid zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:271 SQL (0.004796): SELECT COUNT(*) AS rowscount,ht.hostid FROM httptest ht WHERE ht.hostid=10084 GROUP BY ht.hostid zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CHttpTest->get() → DBselect() in include/classes/api/services/CHttpTest.php:205 SQL (0.003046): SELECT hi.interfaceid,hi.ip,hi.dns,hi.port,hi.main,hi.type,hi.useip,hi.available,hi.error,hi.hostid,COALESCE(his.version,2) AS version,COALESCE(his.bulk,1) AS bulk,COALESCE(his.community,'') AS community,COALESCE(his.max_repetitions,'10') AS max_repetitions,COALESCE(his.securityname,'') AS securityname,COALESCE(his.securitylevel,0) AS securitylevel,COALESCE(his.authpassphrase,'') AS authpassphrase,COALESCE(his.privpassphrase,'') AS privpassphrase,COALESCE(his.authprotocol,0) AS authprotocol,COALESCE(his.privprotocol,0) AS privprotocol,COALESCE(his.contextname,'') AS contextname FROM interface hi LEFT JOIN interface_snmp his ON hi.interfaceid=his.interfaceid WHERE hi.hostid=10084 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostInterface->get() → DBselect() in include/classes/api/services/CHostInterface.php:168 SQL (0.00317): SELECT hosttagid,hostid,tag,value FROM host_tag WHERE hostid=10084 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → DBselect() in include/classes/api/services/CHost.php:1936 SQL (0.003062): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid=10084 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CApiHostHelper::getParentTemplates() → DBselect() in include/classes/api/helpers/CApiHostHelper.php:43 SQL (0.003567): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10001,10047) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CApiHostHelper::getParentTemplates() → DBselect() in include/classes/api/helpers/CApiHostHelper.php:43 SQL (0.003292): SELECT h.hostid FROM hosts h WHERE h.status=3 AND h.hostid IN (10001,10047) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:259 SQL (0.00346): SELECT hosttagid,hostid,tag,value FROM host_tag WHERE hostid IN (10001,10047) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CTemplate->get() → CTemplate->addRelatedObjects() → DBselect() in include/classes/api/services/CTemplate.php:1206 SQL (0.002517): COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:177 SQL (0.004243): BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getEnabledItemsCountByInterfaceIds() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:123 SQL (0.004501): SELECT COUNT(DISTINCT i.itemid) AS rowscount,i.interfaceid FROM items i,host_hgset hh,permission p WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid=hh.hostid AND hh.hgsetid=p.hgsetid AND p.ugsetid=1100 AND i.interfaceid=1 AND i.status=0 GROUP BY i.interfaceid zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getEnabledItemsCountByInterfaceIds() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:410 SQL (0.003588): COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getEnabledItemsCountByInterfaceIds() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:177 SQL (0.003161): BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getEnabledItemTypeCountByHostId() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:123 SQL (0.004506): SELECT COUNT(DISTINCT i.itemid) AS rowscount,i.hostid FROM items i,host_hgset hh,permission p WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid=hh.hostid AND hh.hgsetid=p.hgsetid AND p.ugsetid=1100 AND i.hostid=10084 AND i.type=7 AND i.status=0 GROUP BY i.hostid zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getEnabledItemTypeCountByHostId() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:410 SQL (0.003388): COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getEnabledItemTypeCountByHostId() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:177 SQL (0.003678): BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:123 SQL (3.70797): SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i,host_hgset hh,permission p WHERE f.triggerid=t.triggerid AND f.itemid=i.itemid AND i.hostid=hh.hostid AND hh.hgsetid=p.hgsetid AND p.ugsetid=1100 AND NOT EXISTS (SELECT NULL FROM functions f1 JOIN items i1 ON f1.itemid=i1.itemid JOIN host_hgset hh1 ON i1.hostid=hh1.hostid LEFT JOIN permission p1 ON hh1.hgsetid=p1.hgsetid AND p1.ugsetid=p.ugsetid WHERE t.triggerid=f1.triggerid AND p1.permission IS NULL) AND i.hostid=10084 AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN (0,4) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1241 SQL (0.006568): SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_up=t.triggerid AND d.triggerid_down IN (13075,13467,13468,13471,13472,13473,13475,13479,13480,13481,13483,13484,13485,13486,13487,13488,13489,13490,13558,13560,13567,13570,13571,15854,15856,16274,17537,17538,18981,18982,18983,21198,22382,22383,22384,22385,22386,22387,22388,22389,22390,22391,22392,22393,22394,22395,23162,23288,23289,23299,23300,23396,23732,23733,23734,23735,23944,23945,23946,23947,23948,23949,23950,23951,23952,23953,23954,23955,23956,23957,23958,23959,23960,23961,23962,23963,23964,23965,23966,23967,23968,23969,23970,23971,23972,23973,23974,23975,23976,23977,23978,23979,23980,23981,23982,23983,23984,23985,23986,23987,23988,23989,23990,23991,23992,23993,23994,23995,23996,23997,23998,23999,24000,24008,24009,24010,24011,24012,24013,24014,24015,24330,24331,24332,24333,24334,24335,24336) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:952 SQL (0.004145): SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_up=t.triggerid AND d.triggerid_down IN (22385,22387,22390,22392,22394,22395,23946,23947,23948,23949,23950,23951,23952,23953,23954,23955,23956,23968,23969,23970,23971,23972,23973,23974,23975,23976,23977,23978,24332) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:952 SQL (0.004459): SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_up=t.triggerid AND d.triggerid_down IN (22385,22394) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:952 SQL (0.004659): SELECT t.triggerid FROM triggers t,functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status=1 OR h.status=1 OR t.status=1) AND t.triggerid IN (22385,22387,22390,22392,22394,22395,23946,23947,23948,23949,23950,23951,23952,23953,23954,23955,23956,23968,23969,23970,23971,23972,23973,23974,23975,23976,23977,23978,24332) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → CTrigger->applyPostSqlFiltering() → DBselect() in include/classes/api/services/CTrigger.php:986 SQL (0.004237): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid IN (13075,13467,13468,13471,13472,13473,13475,13479,13480,13481,13483,13484,13485,13486,13487,13488,13489,13490,13558,13560,13567,13570,13571,15854,15856,16274,17537,17538,18981,18982,18983,21198,22382,22383,22384,22385,22386,22387,22388,22389,22390,22391,22392,22393,22394,22395,23162,23288,23289,23299,23300,23396,23732,23733,23734,23735,23944,23945,23946,23947,23948,23949,23950,23951,23952,23953,23954,23955,23956,23957,23958,23959,23960,23961,23962,23963,23964,23965,23966,23967,23968,23969,23970,23971,23972,23973,23974,23975,23976,23977,23978,23979,23980,23981,23982,23983,23984,23985,23986,23987,23988,23989,23990,23991,23992,23993,23994,23995,23996,23997,23998,23999,24000,24008,24009,24010,24011,24012,24013,24014,24015,24330,24331,24332,24333,24334,24335,24336) AND f.itemid=i.itemid zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:767 SQL (0.002876): SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10084 AND h.status IN (0,1,3) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1273 SQL (0.003114): COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:177 SQL (0.003385): BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:123 SQL (0.002766): SELECT usrgrpid FROM users_groups WHERE userid='3946' zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → CApiService->createSelectQuery() → CApiService->createSelectQueryParts() → CProblem->applyQueryFilterOptions() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:75 SQL (0.004878): SELECT tag_filterid,groupid,tag,value FROM tag_filter WHERE usrgrpid=473 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → CApiService->createSelectQuery() → CApiService->createSelectQueryParts() → CProblem->applyQueryFilterOptions() → CProblem::addTagFilterSqlParts() → CEvent::getTagFilters() → DB::select() → DBselect() in include/classes/db/DB.php:911 SQL (0.00711): SELECT DISTINCT p.eventid,p.objectid,p.severity FROM problem p,functions f,items i,host_hgset hh,permission pp WHERE p.source=0 AND p.object=0 AND p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hh.hostid AND hh.hgsetid=pp.hgsetid AND pp.ugsetid=1100 AND NOT EXISTS (SELECT NULL FROM functions f1 JOIN items i1 ON f1.itemid=i1.itemid JOIN host_hgset hh1 ON i1.hostid=hh1.hostid LEFT JOIN permission pp1 ON hh1.hgsetid=pp1.hgsetid AND pp1.ugsetid=pp.ugsetid WHERE p.objectid=f1.triggerid AND pp1.permission IS NULL) AND p.objectid IN (13075,13467,13468,13471,13472,13473,13475,13479,13480,13481,13483,13484,13485,13486,13487,13488,13489,13490,13558,13560,13567,13570,13571,15854,15856,16274,17537,17538,18981,18982,18983,21198,22382,22383,22384,22385,22386,22387,22388,22389,22390,22391,22392,22393,22394,22395,23162,23288,23289,23299,23300,23396,23732,23733,23734,23735,23944,23945,23946,23947,23948,23949,23950,23951,23952,23953,23954,23955,23956,23957,23958,23959,23960,23961,23962,23963,23964,23965,23966,23967,23968,23969,23970,23971,23972,23973,23974,23975,23976,23977,23978,23979,23980,23981,23982,23983,23984,23985,23986,23987,23988,23989,23990,23991,23992,23993,23994,23995,23996,23997,23998,23999,24000,24008,24009,24010,24011,24012,24013,24014,24015,24330,24331,24332,24333,24334,24335,24336) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND p.cause_eventid IS NULL AND p.r_eventid IS NULL zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → DBselect() in include/classes/api/services/CProblem.php:93 SQL (0.003497): COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:177 SQL (0.003294): BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:123 SQL (0.003235): SELECT COUNT(DISTINCT i.itemid) AS rowscount,i.hostid FROM items i,host_hgset hh,permission p,hosts h WHERE i.flags IN (0,4) AND i.hostid=hh.hostid AND hh.hgsetid=p.hgsetid AND p.ugsetid=1100 AND i.hostid=10084 AND h.hostid=i.hostid AND h.status=0 AND i.status=0 GROUP BY i.hostid zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:410 SQL (0.003346): COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:177 SQL (0.003446): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid=10084 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getHostDashboards() → CApiHostHelper::getParentTemplates() → DBselect() in include/classes/api/helpers/CApiHostHelper.php:43 SQL (0.003678): SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10001,10047) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getHostDashboards() → CApiHostHelper::getParentTemplates() → DBselect() in include/classes/api/helpers/CApiHostHelper.php:43 SQL (0.004091): BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getHostDashboards() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:123 SQL (0.004222): SELECT DISTINCT ht.templateid FROM hosts h JOIN host_hgset hh ON h.hostid=hh.hostid JOIN permission p ON hh.hgsetid=p.hgsetid AND p.ugsetid=1100 JOIN hosts_templates ht ON h.hostid=ht.hostid WHERE h.status IN (0,1) AND h.flags IN (0,4) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getHostDashboards() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTemplateDashboard->get() → DBselect() in include/classes/api/services/CTemplateDashboard.php:96 SQL (0.003625): SELECT ht.templateid FROM hosts_templates ht WHERE ht.hostid IN (10001,10047) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getHostDashboards() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTemplateDashboard->get() → DBselect() in include/classes/api/services/CTemplateDashboard.php:118 SQL (0.004301): SELECT d.dashboardid FROM dashboard d WHERE d.templateid IN (10001,10047) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getHostDashboards() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTemplateDashboard->get() → DBselect() in include/classes/api/services/CTemplateDashboard.php:164 SQL (0.003571): COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostViewRefresh->doAction() → CControllerHost->getData() → getHostDashboards() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:177