******************** Script profiler ******************** Total time: 0.011839 Total SQL time: 0.0089 SQL count: 20 (selects: 20 | executes: 11) Peak memory usage: 2M Memory limit: 128M 1. role.get [CRoleHelper.php:172] 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] => inventory.hosts [status] => 1 ) [1] => Array ( [name] => inventory.overview [status] => 1 ) [2] => Array ( [name] => monitoring.dashboard [status] => 1 ) [3] => Array ( [name] => monitoring.hosts [status] => 1 ) [4] => Array ( [name] => monitoring.latest_data [status] => 1 ) [5] => Array ( [name] => monitoring.maps [status] => 1 ) [6] => Array ( [name] => monitoring.problems [status] => 1 ) [7] => Array ( [name] => reports.availability_report [status] => 1 ) [8] => Array ( [name] => reports.top_triggers [status] => 1 ) [9] => Array ( [name] => services.services [status] => 1 ) [10] => Array ( [name] => services.sla_report [status] => 1 ) [11] => Array ( [name] => configuration.actions [status] => 1 ) [12] => Array ( [name] => configuration.discovery [status] => 1 ) [13] => Array ( [name] => configuration.host_groups [status] => 1 ) [14] => Array ( [name] => configuration.hosts [status] => 1 ) [15] => Array ( [name] => configuration.maintenance [status] => 1 ) [16] => Array ( [name] => configuration.templates [status] => 1 ) [17] => Array ( [name] => monitoring.discovery [status] => 1 ) [18] => Array ( [name] => reports.notifications [status] => 1 ) [19] => Array ( [name] => reports.scheduled_reports [status] => 1 ) [20] => Array ( [name] => services.actions [status] => 1 ) [21] => Array ( [name] => services.sla [status] => 1 ) ) [ui.default_access] => 1 [modules] => Array ( ) [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] => close_problems [status] => 1 ) [4] => Array ( [name] => change_severity [status] => 1 ) [5] => Array ( [name] => add_problem_comments [status] => 1 ) [6] => Array ( [name] => execute_scripts [status] => 1 ) [7] => Array ( [name] => manage_api_tokens [status] => 1 ) [8] => Array ( [name] => edit_maintenance [status] => 1 ) [9] => Array ( [name] => manage_scheduled_reports [status] => 1 ) [10] => Array ( [name] => manage_sla [status] => 1 ) ) [actions.default_access] => 1 ) ) ) 2. host.get [CControllerWidgetGraphView.php:127] Parameters: Array ( [output] => Array ( [0] => hostid [1] => host [2] => name ) [hostids] => 10296 ) Result: Array ( [0] => Array ( [hostid] => 10296 [host] => xxxx.xxxx-db4.mysqld2 [name] => xxxx-db4.mysqld2 ) ) 3. graph.get [CControllerWidgetGraphView.php:136] Parameters: Array ( [output] => extend [selectGraphItems] => extend [selectHosts] => Array ( ) [graphids] => 723 ) Result: Array ( ) 4. settings.get [CSettingsHelper.php:108] Parameters: Array ( [output] => extend ) Result: Array ( [default_theme] => blue-theme [search_limit] => 1000 [max_in_table] => 50 [server_check_interval] => 10 [work_period] => 1-5,00:00-24:00 [show_technical_errors] => 0 [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] => 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] => 30m [blink_period] => 30m [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] => en_GB [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] => [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] => ) SQL (0.00017): 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 (0.000213): 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 (0.000489): SELECT r.roleid,r.name,r.type FROM role r WHERE r.roleid='2' 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.00052): SELECT role_ruleid,roleid,type,name,value_int,value_str,value_moduleid,value_serviceid FROM role_rule WHERE roleid=2 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:1062 SQL (0.000537): SELECT md.moduleid FROM module md WHERE md.status=1 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::getEnabledModuleIds() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:77 SQL (0.000225): 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.00054): 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.000458): SELECT NULL FROM users u WHERE u.userid=67 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.000498): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=67 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 (0.000923): SELECT MAX(g.graphtype) AS graphtype,MIN(gi.yaxisside) AS yaxissidel,MAX(gi.yaxisside) AS yaxissider,MAX(g.height) AS height FROM graphs g,graphs_items gi WHERE g.graphid='723' AND gi.graphid=g.graphid zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → getGraphDims() → DBselect() in include/graphs.inc.php:117 SQL (0.000188): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000405): SELECT usrgrpid FROM users_groups WHERE userid='67' zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:80 SQL (0.000804): SELECT h.hostid,h.host,h.name FROM hosts h WHERE h.flags IN (0,4) AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=49 WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid=10296 AND h.status IN (0,1) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->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.00026): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.00015): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.001251): SELECT g.* FROM graphs g WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=49 WHERE g.graphid=gi.graphid AND gi.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND g.graphid=723 AND g.flags IN (0,4) zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:262 SQL (0.000175): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetGraphView->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179 SQL (0.000137): BEGIN zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125 SQL (0.000792): 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 FROM config c zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CSettings->get() → DBselect() in include/classes/api/services/CSettings.php:74 SQL (0.000165): COMMIT zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179