******************** Script profiler ********************
Total time: 0.011916
Total SQL time: 0.005774
SQL count: 16 (selects: 20 | executes: 7)
Peak memory usage: 8M
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] => 3
)
Result:
Array
(
[0] => Array
(
[roleid] => 3
[name] => Super admin role
[type] => 3
[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
)
[22] => Array
(
[name] => administration.authentication
[status] => 1
)
[23] => Array
(
[name] => administration.general
[status] => 1
)
[24] => Array
(
[name] => administration.media_types
[status] => 1
)
[25] => Array
(
[name] => administration.proxies
[status] => 1
)
[26] => Array
(
[name] => administration.queue
[status] => 1
)
[27] => Array
(
[name] => administration.scripts
[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] => configuration.event_correlation
[status] => 1
)
[32] => Array
(
[name] => reports.action_log
[status] => 1
)
[33] => Array
(
[name] => reports.audit
[status] => 1
)
[34] => Array
(
[name] => reports.system_info
[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. 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,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] => 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 (4.4E-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 (5.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:105
SQL (0.000112): 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:1029
SQL (0.000103): 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:84
SQL (4.5E-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.00012): 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:84
SQL (0.000113): SELECT NULL FROM users u WHERE u.userid=10 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.000131): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=10 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 (6.4E-5): BEGIN
zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetSystemInfoView->doAction() → CSystemInfoHelper::getData() → CSystemInfoHelper::getServerStatus() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:125
SQL (0.000183): 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() → CController->run() → CControllerWidgetSystemInfoView->doAction() → CSystemInfoHelper::getData() → CSystemInfoHelper::getServerStatus() → 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 (4.5E-5): COMMIT
zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetSystemInfoView->doAction() → CSystemInfoHelper::getData() → CSystemInfoHelper::getServerStatus() → CConfigGeneralHelper::get() → CSettingsHelper::loadParams() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:179
SQL (0.000132): SELECT han.ha_nodeid,han.address,han.port,han.lastaccess FROM ha_node han WHERE han.status=3 ORDER BY han.lastaccess DESC LIMIT 1
zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetSystemInfoView->doAction() → CSystemInfoHelper::getData() → CSystemInfoHelper::getServerStatus() → CZabbixServer->isRunning() → CHaNode->get() → DBselect() in include/classes/api/services/CHaNode.php:74
SQL (0.000284): SELECT default_character_set_name db_charset FROM information_schema.schemata WHERE schema_name='zabbix'
zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetSystemInfoView->doAction() → CSystemInfoHelper::getData() → MysqlDbBackend->checkEncoding() → MysqlDbBackend->checkDatabaseEncoding() → DBselect() in include/classes/db/MysqlDbBackend.php:65
SQL (0.004137): SELECT table_name AS table_name FROM information_schema.columns WHERE table_schema='zabbix' AND (table_name IN ('role','users','maintenances','hosts','hstgrp','group_prototype','group_discovery','drules','dchecks','httptest','httpstep','interface','valuemap','items','httpstepitem','httptestitem','media_type','media_type_param','media_type_message','usrgrp','users_groups','scripts','script_param','actions','operations','opmessage','opmessage_grp','opmessage_usr','opcommand','opcommand_hst','opcommand_grp','opgroup','optemplate','opconditions','conditions','config','triggers','trigger_depends','functions','graphs','graphs_items','graph_theme','globalmacro','hostmacro','hosts_groups','hosts_templates','valuemap_mapping','media','rights','services','services_links','icon_map','icon_mapping','sysmaps','sysmaps_elements','sysmaps_links','sysmaps_link_triggers','sysmap_element_url','sysmap_url','sysmap_user','sysmap_usrgrp','maintenances_hosts','maintenances_groups','timeperiods','maintenances_windows','regexps','expressions','ids','alerts','history','history_uint','history_str','history_log','history_text','proxy_history','proxy_dhistory','events','trends','trends_uint','acknowledges','auditlog','service_alarms','autoreg_host','proxy_autoreg_host','dhosts','dservices','escalations','globalvars','graph_discovery','host_inventory','housekeeper','images','item_discovery','host_discovery','interface_discovery','profiles','sessions','trigger_discovery','item_condition','item_rtdata','opinventory','trigger_tag','event_tag','problem','problem_tag','tag_filter','event_recovery','correlation','corr_condition','corr_condition_tag','corr_condition_group','corr_condition_tagpair','corr_condition_tagvalue','corr_operation','task','task_close_problem','item_preproc','task_remote_command','task_remote_command_result','task_data','task_result','task_acknowledge','sysmap_shape','sysmap_element_trigger','httptest_field','httpstep_field','dashboard','dashboard_user','dashboard_usrgrp','dashboard_page','widget','widget_field','task_check_now','event_suppress','maintenance_tag','lld_macro_path','host_tag','config_autoreg_tls','module','interface_snmp','lld_override','lld_override_condition','lld_override_operation','lld_override_opstatus','lld_override_opdiscover','lld_override_opperiod','lld_override_ophistory','lld_override_optrends','lld_override_opseverity','lld_override_optag','lld_override_optemplate','lld_override_opinventory','trigger_queue','item_parameter','role_rule','token','item_tag','httptest_tag','sysmaps_element_tag','report','report_param','report_user','report_usrgrp','service_problem_tag','service_problem','service_tag','service_status_rule','ha_node','sla','sla_schedule','sla_excluded_downtime','sla_service_tag','dbversion')) AND (data_type IN ('text','varchar','longtext')) AND ((UPPER(character_set_name) NOT IN ('UTF8','UTF8MB3','UTF8MB4')) OR (collation_name NOT IN ('utf8_bin','utf8mb3_bin','utf8mb4_bin')))
zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetSystemInfoView->doAction() → CSystemInfoHelper::getData() → MysqlDbBackend->checkEncoding() → MysqlDbBackend->checkTablesEncoding() → DBselect() in include/classes/db/MysqlDbBackend.php:94
SQL (0.000117): SELECT han.ha_nodeid,han.name,han.address,han.port,han.lastaccess,han.status FROM ha_node han ORDER BY han.status DESC
zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerWidgetSystemInfoView->doAction() → CSystemInfoHelper::getData() → CHaNode->get() → DBselect() in include/classes/api/services/CHaNode.php:74
Comment