***************** Script profiler ******************** Total time: 0.052281 Total SQL time: 0.004888 SQL count: 46 (selects: 40 | executes: 22) Peak memory usage: 6M Memory limit: 128M 1. role.get [CRoleHelper.php:195] 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] => 3 ) Result: Array ( [0] => Array ( [roleid] => 3 [name] => Super admin role [type] => 3 [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 ) [26] => Array ( [name] => reports.system_info [status] => 1 ) [27] => Array ( [name] => reports.audit [status] => 1 ) [28] => Array ( [name] => reports.action_log [status] => 1 ) [29] => Array ( [name] => configuration.event_correlation [status] => 1 ) [30] => Array ( [name] => administration.media_types [status] => 1 ) [31] => Array ( [name] => administration.scripts [status] => 1 ) [32] => Array ( [name] => administration.user_groups [status] => 1 ) [33] => Array ( [name] => administration.user_roles [status] => 1 ) [34] => Array ( [name] => administration.users [status] => 1 ) [35] => Array ( [name] => administration.api_tokens [status] => 1 ) [36] => Array ( [name] => administration.authentication [status] => 1 ) [37] => Array ( [name] => administration.general [status] => 1 ) [38] => Array ( [name] => administration.audit_log [status] => 1 ) [39] => Array ( [name] => administration.housekeeping [status] => 1 ) [40] => Array ( [name] => administration.proxies [status] => 1 ) [41] => Array ( [name] => administration.macros [status] => 1 ) [42] => Array ( [name] => administration.queue [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 ) ) [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. host.get [CControllerHostEdit.php:118] Parameters: Array ( [output] => Array ( ) [hostids] => 10816 [editable] => 1 [limit] => 1 ) Result: Array ( [0] => Array ( [hostid] => 10816 ) ) 3. host.get [CControllerHostEdit.php:154] Parameters: Array ( [output] => Array ( [0] => hostid [1] => host [2] => name [3] => status [4] => description [5] => proxy_hostid [6] => ipmi_authtype [7] => ipmi_privilege [8] => ipmi_username [9] => ipmi_password [10] => tls_connect [11] => tls_accept [12] => tls_issuer [13] => tls_subject [14] => flags [15] => inventory_mode ) [selectDiscoveryRule] => Array ( [0] => itemid [1] => name [2] => parent_hostid ) [selectHostGroups] => Array ( [0] => groupid ) [selectHostDiscovery] => Array ( [0] => parent_hostid ) [selectInterfaces] => Array ( [0] => interfaceid [1] => type [2] => main [3] => available [4] => error [5] => details [6] => ip [7] => dns [8] => port [9] => useip ) [selectInventory] => Array ( [0] => type [1] => type_full [2] => name [3] => alias [4] => os [5] => os_full [6] => os_short [7] => serialno_a [8] => serialno_b [9] => tag [10] => asset_tag [11] => macaddress_a [12] => macaddress_b [13] => hardware [14] => hardware_full [15] => software [16] => software_full [17] => software_app_a [18] => software_app_b [19] => software_app_c [20] => software_app_d [21] => software_app_e [22] => contact [23] => location [24] => location_lat [25] => location_lon [26] => notes [27] => chassis [28] => model [29] => hw_arch [30] => vendor [31] => contract_number [32] => installer_name [33] => deployment_status [34] => url_a [35] => url_b [36] => url_c [37] => host_networks [38] => host_netmask [39] => host_router [40] => oob_ip [41] => oob_netmask [42] => oob_router [43] => date_hw_purchase [44] => date_hw_install [45] => date_hw_expiry [46] => date_hw_decomm [47] => site_address_a [48] => site_address_b [49] => site_address_c [50] => site_city [51] => site_state [52] => site_country [53] => site_zip [54] => site_rack [55] => site_notes [56] => poc_1_name [57] => poc_1_email [58] => poc_1_phone_a [59] => poc_1_phone_b [60] => poc_1_cell [61] => poc_1_screen [62] => poc_1_notes [63] => poc_2_name [64] => poc_2_email [65] => poc_2_phone_a [66] => poc_2_phone_b [67] => poc_2_cell [68] => poc_2_screen [69] => poc_2_notes ) [selectMacros] => Array ( [0] => hostmacroid [1] => macro [2] => value [3] => description [4] => type [5] => automatic ) [selectParentTemplates] => Array ( [0] => templateid [1] => name [2] => link_type ) [selectTags] => Array ( [0] => tag [1] => value [2] => automatic ) [selectValueMaps] => Array ( [0] => valuemapid [1] => name [2] => mappings ) [hostids] => 10816 ) Result: Array ( [0] => Array ( [hostid] => 10816 [host] => exaltomail02.aqserver.com [name] => exaltomail02.aqserver.com [status] => 0 [description] => [proxy_hostid] => 0 [ipmi_authtype] => -1 [ipmi_privilege] => 2 [ipmi_username] => [ipmi_password] => [tls_connect] => 1 [tls_accept] => 1 [tls_issuer] => [tls_subject] => [flags] => 0 [inventory_mode] => 1 [macros] => Array ( ) [parentTemplates] => Array ( [0] => Array ( [templateid] => 10606 [name] => AA AQUEOS Email [link_type] => 0 ) [1] => Array ( [templateid] => 10617 [name] => AAA AQUEOS Aqueliav2 nomail [link_type] => 0 ) ) [valuemaps] => Array ( ) [hostgroups] => Array ( [0] => Array ( [groupid] => 5 ) [1] => Array ( [groupid] => 23 ) [2] => Array ( [groupid] => 25 ) [3] => Array ( [groupid] => 29 ) [4] => Array ( [groupid] => 30 ) ) [inventory] => Array ( [type] => [type_full] => [name] => exaltomail02.aqserver.com [alias] => [os] => [os_full] => [os_short] => Debian GNU/Linux 10 (buster) [serialno_a] => [serialno_b] => [tag] => [asset_tag] => [macaddress_a] => [macaddress_b] => [hardware] => [hardware_full] => [software] => [software_full] => [software_app_a] => [software_app_b] => [software_app_c] => [software_app_d] => [software_app_e] => [contact] => [location] => aqueos136.ikoula.biz [location_lat] => [location_lon] => [notes] => [chassis] => [model] => [hw_arch] => [vendor] => [contract_number] => [installer_name] => [deployment_status] => [url_a] => [url_b] => [url_c] => [host_networks] => [host_netmask] => [host_router] => [oob_ip] => [oob_netmask] => [oob_router] => [date_hw_purchase] => [date_hw_install] => [date_hw_expiry] => [date_hw_decomm] => [site_address_a] => [site_address_b] => [site_address_c] => [site_city] => [site_state] => [site_country] => [site_zip] => [site_rack] => [site_notes] => [poc_1_name] => [poc_1_email] => [poc_1_phone_a] => [poc_1_phone_b] => [poc_1_cell] => [poc_1_screen] => [poc_1_notes] => [poc_2_name] => [poc_2_email] => [poc_2_phone_a] => [poc_2_phone_b] => [poc_2_cell] => [poc_2_screen] => [poc_2_notes] => ) [interfaces] => Array ( [0] => Array ( [interfaceid] => 204 [type] => 1 [main] => 1 [available] => 1 [error] => [ip] => 80.93.93.69 [dns] => exaltomail02.aqserver.com [port] => 10052 [useip] => 0 [details] => Array ( ) ) ) [discoveryRule] => Array ( ) [hostDiscovery] => Array ( ) [tags] => Array ( ) ) ) 4. hostinterface.get [CControllerHostEdit.php:165] Parameters: Array ( [output] => Array ( ) [selectItems] => count [hostids] => Array ( [0] => 10816 ) [preservekeys] => 1 ) Result: Array ( [204] => Array ( [interfaceid] => 204 [items] => 29 ) ) 5. settings.get [CSettingsHelper.php:108] 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] => ha_failover_delay [55] => geomaps_tile_provider [56] => geomaps_tile_url [57] => geomaps_max_zoom [58] => geomaps_attribution [59] => vault_provider ) ) Result: Array ( [default_theme] => dark-theme [search_limit] => 1000 [max_in_table] => 50 [server_check_interval] => 10 [work_period] => 1-5,09:00-18:00 [show_technical_errors] => 1 [history_period] => 24h [period_default] => 1h [max_period] => 2y [severity_color_0] => 97AAB3 [severity_color_1] => 7499FF [severity_color_2] => FFC859 [severity_color_3] => FFA059 [severity_color_4] => E97659 [severity_color_5] => FF0080 [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] => 2m [blink_period] => 1m [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] => 5 [default_inventory_mode] => 1 [alert_usrgrpid] => 7 [snmptrap_logging] => 1 [default_lang] => fr_FR [default_timezone] => system [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] => https://surveillance.aqueos.net:444 [report_test_timeout] => 60s [auditlog_enabled] => 1 [ha_failover_delay] => 1m [geomaps_tile_provider] => OpenStreetMap.Mapnik [geomaps_tile_url] => [geomaps_max_zoom] => 0 [geomaps_attribution] => [vault_provider] => 0 ) 6. hostgroup.get [CControllerHostEdit.php:348] Parameters: Array ( [output] => Array ( [0] => name ) [groupids] => Array ( [0] => 5 [1] => 23 [2] => 25 [3] => 29 [4] => 30 ) [preservekeys] => 1 ) Result: Array ( [5] => Array ( [name] => Discovered hosts ) [23] => Array ( [name] => GUEST ) [25] => Array ( [name] => VS GUEST ) [29] => Array ( [name] => a configurer ) [30] => Array ( [name] => Ikoula ) ) 7. template.get [CControllerHostEdit.php:403] Parameters: Array ( [output] => Array ( [0] => templateid ) [templateids] => Array ( [0] => 10606 [1] => 10617 ) [editable] => 1 [preservekeys] => 1 ) Result: Array ( [10606] => Array ( [templateid] => 10606 ) [10617] => Array ( [templateid] => 10617 ) ) 8. proxy.get [CControllerHostEdit.php:430] Parameters: Array ( [output] => Array ( [0] => host [1] => proxyid ) [preservekeys] => 1 ) Result: Array ( ) 9. item.get [CControllerHostEdit.php:463] Parameters: Array ( [output] => Array ( [0] => inventory_link [1] => itemid [2] => name ) [hostids] => 10816 [filter] => Array ( [inventory_link] => Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 5 [5] => 6 [6] => 7 [7] => 8 [8] => 9 [9] => 10 [10] => 11 [11] => 12 [12] => 13 [13] => 14 [14] => 15 [15] => 16 [16] => 17 [17] => 18 [18] => 19 [19] => 20 [20] => 21 [21] => 22 [22] => 23 [23] => 24 [24] => 25 [25] => 26 [26] => 27 [27] => 28 [28] => 29 [29] => 30 [30] => 31 [31] => 32 [32] => 33 [33] => 34 [34] => 35 [35] => 36 [36] => 37 [37] => 38 [38] => 39 [39] => 40 [40] => 41 [41] => 42 [42] => 43 [43] => 44 [44] => 45 [45] => 46 [46] => 47 [47] => 48 [48] => 49 [49] => 50 [50] => 51 [51] => 52 [52] => 53 [53] => 54 [54] => 55 [55] => 56 [56] => 57 [57] => 58 [58] => 59 [59] => 60 [60] => 61 [61] => 62 [62] => 63 [63] => 64 [64] => 65 [65] => 66 [66] => 67 [67] => 68 [68] => 69 [69] => 70 ) ) ) Result: Array ( [0] => Array ( [itemid] => 93536 [inventory_link] => 7 [name] => distribution linux ) [1] => Array ( [itemid] => 93575 [inventory_link] => 3 [name] => Host name ) [2] => Array ( [itemid] => 93649 [inventory_link] => 24 [name] => Serveur HOST ) ) SQL (8.5E-5): COMMIT zabbix.php:22 → 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:179 SQL (3.3E-5): BEGIN zabbix.php:22 → 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:125 SQL (9.1E-5): SELECT r.roleid,r.name,r.type FROM role r WHERE r.roleid='3' zabbix.php:22 → 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:98 SQL (0.000126): SELECT role_ruleid,roleid,type,name,value_int,value_str,value_moduleid,value_serviceid FROM role_rule WHERE roleid=3 zabbix.php:22 → 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:1027 SQL (7.7E-5): SELECT md.moduleid FROM module md zabbix.php:22 → 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:77 SQL (3.2E-5): COMMIT zabbix.php:22 → 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:179 SQL (0.000156): SELECT md.moduleid,md.id,md.relative_path,md.config FROM module md WHERE md.status=1 ORDER BY md.relative_path zabbix.php:22 → require_once() → ZBase->run() → ZBase->initModuleManager() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:77 SQL (0.000111): SELECT NULL FROM users u WHERE u.userid=3 FOR UPDATE zabbix.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:37 SQL (0.00014): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.sidebar.mode' zabbix.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:183 SQL (4.0E-5): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->checkPermissions() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000118): SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10816 AND h.status IN (0,1) LIMIT 1 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->checkPermissions() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1168 SQL (3.2E-5): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->checkPermissions() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (2.4E-5): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000177): SELECT h.hostid,h.host,h.name,h.status,h.description,h.proxy_hostid,h.ipmi_authtype,h.ipmi_privilege,h.ipmi_username,h.ipmi_password,h.tls_connect,h.tls_accept,h.tls_issuer,h.tls_subject,h.flags,COALESCE(hinv.inventory_mode,-1) AS inventory_mode FROM hosts h LEFT JOIN host_inventory hinv ON h.hostid=hinv.hostid WHERE h.flags IN (0,4) AND h.hostid=10816 AND h.status IN (0,1) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1168 SQL (0.000117): SELECT hm.hostmacroid,hm.macro,hm.value,hm.description,hm.type,hm.automatic,hm.hostid FROM hostmacro hm WHERE hm.hostid=10816 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CHostBase->addRelatedObjects() → CUserMacro->get() → DBselect() in include/classes/api/services/CUserMacro.php:224 SQL (0.00011): SELECT ht.hostid,ht.templateid,ht.link_type FROM hosts_templates ht WHERE ht.hostid=10816 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CHostGeneral.php:1112 SQL (0.000133): SELECT h.hostid,h.templateid,h.name FROM hosts h WHERE h.status=3 AND h.hostid IN (10606,10617) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:265 SQL (0.000174): SELECT valuemapid,name,hostid FROM valuemap WHERE hostid=10816 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:1027 SQL (0.000108): SELECT t.hostgroupid,t.hostid,t.groupid FROM hosts_groups t WHERE t.hostid=10816 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHost->addRelatedGroups() → CApiService->createRelationMap() → DBselect() in include/classes/api/CApiService.php:320 SQL (0.000184): SELECT g.groupid FROM hstgrp g WHERE g.type=0 AND g.groupid IN (5,23,25,29,30) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHost->addRelatedGroups() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:348 SQL (0.000231): SELECT t.hostid,t.type,t.type_full,t.name,t.alias,t.os,t.os_full,t.os_short,t.serialno_a,t.serialno_b,t.tag,t.asset_tag,t.macaddress_a,t.macaddress_b,t.hardware,t.hardware_full,t.software,t.software_full,t.software_app_a,t.software_app_b,t.software_app_c,t.software_app_d,t.software_app_e,t.contact,t.location,t.location_lat,t.location_lon,t.notes,t.chassis,t.model,t.hw_arch,t.vendor,t.contract_number,t.installer_name,t.deployment_status,t.url_a,t.url_b,t.url_c,t.host_networks,t.host_netmask,t.host_router,t.oob_ip,t.oob_netmask,t.oob_router,t.date_hw_purchase,t.date_hw_install,t.date_hw_expiry,t.date_hw_decomm,t.site_address_a,t.site_address_b,t.site_address_c,t.site_city,t.site_state,t.site_country,t.site_zip,t.site_rack,t.site_notes,t.poc_1_name,t.poc_1_email,t.poc_1_phone_a,t.poc_1_phone_b,t.poc_1_cell,t.poc_1_screen,t.poc_1_notes,t.poc_2_name,t.poc_2_email,t.poc_2_phone_a,t.poc_2_phone_b,t.poc_2_cell,t.poc_2_screen,t.poc_2_notes FROM host_inventory t WHERE t.hostid=10816 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:353 SQL (0.000302): SELECT hi.interfaceid,hi.type,hi.main,hi.available,hi.error,hi.ip,hi.dns,hi.port,hi.useip,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=10816 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostInterface->get() → DBselect() in include/classes/api/services/CHostInterface.php:174 SQL (0.000163): SELECT hd.hostid,hd2.parent_itemid FROM host_discovery hd,host_discovery hd2 WHERE hd.hostid=10816 AND hd.parent_hostid=hd2.hostid zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → DBselect() in include/classes/api/services/CHost.php:1727 SQL (7.3E-5): SELECT i.itemid,i.name FROM items i WHERE i.flags=1 AND 1=0 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CDiscoveryRule->get() → DBselect() in include/classes/api/services/CDiscoveryRule.php:277 SQL (6.6E-5): SELECT t.hostid,t.parent_hostid FROM host_discovery t WHERE t.hostid=10816 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:353 SQL (0.000146): SELECT hosttagid,hostid,tag,value,automatic FROM host_tag WHERE hostid=10816 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → DBselect() in include/classes/api/services/CHost.php:1770 SQL (3.8E-5): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (2.4E-5): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (9.1E-5): SELECT hi.interfaceid FROM interface hi WHERE hi.hostid=10816 zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostInterface->get() → DBselect() in include/classes/api/services/CHostInterface.php:174 SQL (0.000226): SELECT COUNT(*) AS rowscount,i.interfaceid FROM items i WHERE i.type<>9 AND i.interfaceid=204 GROUP BY i.interfaceid zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostInterface->get() → CHostInterface->addRelatedObjects() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:416 SQL (3.5E-5): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (2.3E-5): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->getHostDefaultValues() → CSettingsHelper::get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000215): 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.ha_failover_delay,c.geomaps_tile_provider,c.geomaps_tile_url,c.geomaps_max_zoom,c.geomaps_attribution,c.vault_provider FROM config c zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->getHostDefaultValues() → CSettingsHelper::get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CSettings->get() → DBselect() in include/classes/api/services/CSettings.php:74 SQL (3.4E-5): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->getHostDefaultValues() → CSettingsHelper::get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (2.8E-5): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->hostGroupsForMultiselect() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.00013): SELECT g.groupid,g.name FROM hstgrp g WHERE g.type=0 AND g.groupid IN (5,23,25,29,30) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->hostGroupsForMultiselect() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:348 SQL (3.2E-5): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->hostGroupsForMultiselect() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (2.4E-5): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->extendLinkedTemplates() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000123): SELECT h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND h.hostid IN (10606,10617) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->extendLinkedTemplates() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:265 SQL (3.1E-5): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->extendLinkedTemplates() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (2.4E-5): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->extendProxies() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (9.9E-5): SELECT h.hostid,h.host FROM hosts h WHERE h.status IN (5,6) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->extendProxies() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProxy->get() → DBselect() in include/classes/api/services/CProxy.php:151 SQL (3.0E-5): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->extendProxies() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (2.4E-5): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->extendInventory() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000572): SELECT i.itemid,i.inventory_link,i.name FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid=10816 AND i.inventory_link IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->extendInventory() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:416 SQL (3.6E-5): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostEdit->doAction() → CControllerHostEdit->extendInventory() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179