******************** Script profiler ******************** Total time: 0.009809 Total SQL time: 0.007832 SQL count: 12 (selects: 15 | executes: 8) Peak memory usage: 4M Memory limit: 128M 1. role.get [CRoleHelper.php:219] 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.overview [status] => 1 ) [4] => Array ( [name] => monitoring.latest_data [status] => 1 ) [5] => Array ( [name] => monitoring.maps [status] => 1 ) [6] => Array ( [name] => monitoring.services [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] => reports.notifications [status] => 1 ) [13] => Array ( [name] => reports.scheduled_reports [status] => 1 ) [14] => Array ( [name] => configuration.host_groups [status] => 1 ) [15] => Array ( [name] => configuration.templates [status] => 1 ) [16] => Array ( [name] => configuration.hosts [status] => 1 ) [17] => Array ( [name] => configuration.maintenance [status] => 1 ) [18] => Array ( [name] => configuration.actions [status] => 1 ) [19] => Array ( [name] => configuration.discovery [status] => 1 ) [20] => Array ( [name] => configuration.services [status] => 1 ) [21] => Array ( [name] => reports.system_info [status] => 1 ) [22] => Array ( [name] => reports.audit [status] => 1 ) [23] => Array ( [name] => reports.action_log [status] => 1 ) [24] => Array ( [name] => configuration.event_correlation [status] => 1 ) [25] => Array ( [name] => administration.general [status] => 1 ) [26] => Array ( [name] => administration.proxies [status] => 1 ) [27] => Array ( [name] => administration.authentication [status] => 1 ) [28] => Array ( [name] => administration.user_groups [status] => 1 ) [29] => Array ( [name] => administration.user_roles [status] => 1 ) [30] => Array ( [name] => administration.users [status] => 1 ) [31] => Array ( [name] => administration.media_types [status] => 1 ) [32] => Array ( [name] => administration.scripts [status] => 1 ) [33] => Array ( [name] => administration.queue [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 ) ) [actions.default_access] => 1 ) ) ) 2. settings.get [CSettingsHelper.php:102] Parameters: Array ( [output] => extend ) 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] => 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] => 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] => 5 [default_inventory_mode] => 1 [alert_usrgrpid] => 13 [snmptrap_logging] => 1 [default_lang] => en_GB [default_timezone] => Australia/Perth [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] => 0 [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://zabbix.redacted.int.local [report_test_timeout] => 60s ) SQL (0.006797): 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:180 SQL (7.0E-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:126 SQL (0.000108): 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:170 SQL (8.0E-5): SELECT moduleid FROM module WHERE 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() → DBselect() in include/classes/api/services/CRole.php:841 SQL (0.000106): SELECT roleid,type,name,value_int,value_str,value_moduleid 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() → DBselect() in include/classes/api/services/CRole.php:847 SQL (3.8E-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:180 SQL (0.000117): 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:111 SQL (9.8E-5): SELECT NULL FROM users u WHERE u.userid=4 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.00013): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=4 AND idx='web.sidebar.mode' zabbix.php:22 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:179 SQL (4.9E-5): 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:126 SQL (0.000203): 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 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:81 SQL (3.6E-5): 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:180