******************** Script profiler ******************** Total time: 0.022272 Total SQL time: 0.014906 SQL count: 37 (selects: 37 | executes: 15) Peak memory usage: 4M Memory limit: 128M 1. role.get [CRoleHelper.php:183]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] => 4
)
Result: Array
(
[0] => Array
(
[roleid] => 4
[name] => Guest role
[type] => 1
[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
)
)
[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
)
[30] => Array
(
[moduleid] => 31
[status] => 1
)
)
[modules.default_access] => 1
[api.access] => 0
[api.mode] => 0
[api] => Array
(
)
[actions] => Array
(
[0] => Array
(
[name] => edit_dashboards
[status] => 0
)
[1] => Array
(
[name] => edit_maps
[status] => 0
)
[2] => Array
(
[name] => acknowledge_problems
[status] => 0
)
[3] => Array
(
[name] => suppress_problems
[status] => 0
)
[4] => Array
(
[name] => close_problems
[status] => 0
)
[5] => Array
(
[name] => change_severity
[status] => 0
)
[6] => Array
(
[name] => add_problem_comments
[status] => 0
)
[7] => Array
(
[name] => execute_scripts
[status] => 0
)
[8] => Array
(
[name] => manage_api_tokens
[status] => 0
)
[9] => Array
(
[name] => invoke_execute_now
[status] => 0
)
[10] => Array
(
[name] => change_problem_ranking
[status] => 0
)
)
[actions.default_access] => 0
)
)
)
2.
dashboard.get [CControllerDashboardView.php:252]
Parameters: Array
(
[output] => Array
(
[0] => dashboardid
[1] => name
[2] => userid
[3] => display_period
[4] => auto_start
)
[selectPages] => Array
(
[0] => dashboard_pageid
[1] => name
[2] => display_period
[3] => widgets
)
[dashboardids] => 1
[preservekeys] => 1
)
Result: Array
(
[1] => Array
(
[dashboardid] => 1
[name] => Global view
[userid] => 1
[display_period] => 30
[auto_start] => 1
[pages] => Array
(
[0] => Array
(
[dashboard_pageid] => 1
[name] =>
[display_period] => 0
[widgets] => Array
(
[0] => Array
(
[widgetid] => 1
[type] => tophosts
[name] => Top hosts by CPU utilization
[x] => 0
[y] => 0
[width] => 33
[height] => 4
[view_mode] => 0
[fields] => Array
(
[0] => Array
(
[type] => 1
[name] => columns.0.name
[value] => Host name
)
[1] => Array
(
[type] => 0
[name] => columns.0.data
[value] => 2
)
[2] => Array
(
[type] => 1
[name] => columns.0.item
[value] => System name
)
[3] => Array
(
[type] => 1
[name] => columns.1.name
[value] => Utilization
)
[4] => Array
(
[type] => 0
[name] => columns.1.data
[value] => 1
)
[5] => Array
(
[type] => 1
[name] => columns.1.item
[value] => CPU utilization
)
[6] => Array
(
[type] => 1
[name] => columns.1.min
[value] => 0
)
[7] => Array
(
[type] => 1
[name] => columns.1.max
[value] => 100
)
[8] => Array
(
[type] => 0
[name] => columns.1.display
[value] => 3
)
[9] => Array
(
[type] => 1
[name] => columns.1.base_color
[value] => 4CAF50
)
[10] => Array
(
[type] => 1
[name] => columnsthresholds.1.color.0
[value] => FFFF00
)
[11] => Array
(
[type] => 1
[name] => columnsthresholds.1.threshold.0
[value] => 50
)
[12] => Array
(
[type] => 1
[name] => columnsthresholds.1.color.1
[value] => FF8000
)
[13] => Array
(
[type] => 1
[name] => columnsthresholds.1.threshold.1
[value] => 80
)
[14] => Array
(
[type] => 1
[name] => columnsthresholds.1.color.2
[value] => FF4000
)
[15] => Array
(
[type] => 1
[name] => columnsthresholds.1.threshold.2
[value] => 90
)
[16] => Array
(
[type] => 1
[name] => columns.2.name
[value] => 1m avg
)
[17] => Array
(
[type] => 0
[name] => columns.2.data
[value] => 1
)
[18] => Array
(
[type] => 1
[name] => columns.2.item
[value] => Load average (1m avg)
)
[19] => Array
(
[type] => 1
[name] => columns.3.name
[value] => 5m avg
)
[20] => Array
(
[type] => 0
[name] => columns.3.data
[value] => 1
)
[21] => Array
(
[type] => 1
[name] => columns.3.item
[value] => Load average (5m avg)
)
[22] => Array
(
[type] => 1
[name] => columns.4.name
[value] => 15m avg
)
[23] => Array
(
[type] => 0
[name] => columns.4.data
[value] => 1
)
[24] => Array
(
[type] => 1
[name] => columns.4.item
[value] => Load average (15m avg)
)
[25] => Array
(
[type] => 1
[name] => columns.5.name
[value] => Processes
)
[26] => Array
(
[type] => 0
[name] => columns.5.data
[value] => 1
)
[27] => Array
(
[type] => 1
[name] => columns.5.item
[value] => Number of processes
)
[28] => Array
(
[type] => 0
[name] => columns.5.decimal_places
[value] => 0
)
[29] => Array
(
[type] => 0
[name] => column
[value] => 1
)
[30] => Array
(
[type] => 1
[name] => reference
[value] => NLVMO
)
)
)
[1] => Array
(
[widgetid] => 3
[type] => systeminfo
[name] =>
[x] => 33
[y] => 0
[width] => 39
[height] => 4
[view_mode] => 0
[fields] => Array
(
)
)
[2] => Array
(
[widgetid] => 6
[type] => hostavail
[name] =>
[x] => 0
[y] => 4
[width] => 22
[height] => 2
[view_mode] => 0
[fields] => Array
(
[0] => Array
(
[type] => 0
[name] => interface_type.0
[value] => 1
)
[1] => Array
(
[type] => 0
[name] => rf_rate
[value] => 30
)
)
)
[3] => Array
(
[widgetid] => 7
[type] => problemsbysv
[name] =>
[x] => 22
[y] => 4
[width] => 27
[height] => 2
[view_mode] => 0
[fields] => Array
(
[0] => Array
(
[type] => 0
[name] => show_type
[value] => 1
)
[1] => Array
(
[type] => 1
[name] => reference
[value] => VAGMD
)
)
)
[4] => Array
(
[widgetid] => 9
[type] => problems
[name] => Current problems
[x] => 0
[y] => 6
[width] => 72
[height] => 5
[view_mode] => 0
[fields] => Array
(
[0] => Array
(
[type] => 0
[name] => show_tags
[value] => 3
)
[1] => Array
(
[type] => 1
[name] => reference
[value] => BRUQE
)
[2] => Array
(
[type] => 0
[name] => rf_rate
[value] => 10
)
[3] => Array
(
[type] => 0
[name] => severities.0
[value] => 3
)
[4] => Array
(
[type] => 0
[name] => severities.1
[value] => 4
)
[5] => Array
(
[type] => 0
[name] => severities.2
[value] => 5
)
[6] => Array
(
[type] => 0
[name] => show
[value] => 3
)
)
)
[5] => Array
(
[widgetid] => 38862
[type] => web
[name] =>
[x] => 49
[y] => 4
[width] => 23
[height] => 2
[view_mode] => 0
[fields] => Array
(
[0] => Array
(
[type] => 0
[name] => rf_rate
[value] => 30
)
[1] => Array
(
[type] => 3
[name] => hostids.0
[value] => 11020
)
[2] => Array
(
[type] => 1
[name] => reference
[value] => BDMRX
)
[3] => Array
(
[type] => 0
[name] => maintenance
[value] => 0
)
)
)
)
)
)
)
)
3.
dashboard.get [CDashboardHelper.php:45]
Parameters: Array
(
[output] => Array
(
)
[dashboardids] => Array
(
[0] => 1
)
[editable] => 1
[preservekeys] => 1
)
Result: Array
(
)
4.
user.get [CDashboardHelper.php:32]
Parameters: Array
(
[output] => Array
(
[0] => name
[1] => surname
[2] => username
)
[userids] => 1
)
Result: Array
(
)
5.
report.get [CControllerDashboardView.php:278]
Parameters: Array
(
[output] => Array
(
)
[filter] => Array
(
[dashboardid] => 1
)
[limit] => 1
)
Result: Array
(
)
6.
settings.get [CSettingsHelper.php:116]
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] => 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] => 7
[snmptrap_logging] => 1
[default_lang] => en_US
[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
[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
)
SQL (5.9E-5):
COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:153
SQL (5.1E-5):
BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:114
SQL (0.000131):
SELECT DISTINCT r.roleid,r.name,r.type FROM role r,users u WHERE r.roleid='4' AND r.roleid=u.roleid AND u.userid=2 zabbix.php:17 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → DBselect() in include/classes/api/services/CRole.php:99
SQL (0.000146):
SELECT role_ruleid,roleid,type,name,value_int,value_str,value_moduleid,value_serviceid FROM role_rule WHERE roleid=4 zabbix.php:17 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:821
SQL (0.000101):
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() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CRole->get() → CRole->addRelatedObjects() → CRole->getRelatedModulesRules() → CRole::getModuleIds() → CModule->get() → DBselect() in include/classes/api/services/CModule.php:72
SQL (5.1E-5):
COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->initComponents() → CMenuHelper::getMainMenu() → CWebUser::checkAccess() → CRoleHelper::checkAccess() → CRoleHelper::loadRoleRules() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:153
SQL (0.000179):
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.000149):
SELECT NULL FROM users u WHERE u.userid=2 FOR UPDATE zabbix.php:17 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:32
SQL (0.00175):
SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.sidebar.mode' zabbix.php:17 → require_once() → ZBase->run() → CViewHelper::loadSidebarMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:178
SQL (0.000215):
SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.dashboard.dashboardid' zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:178
SQL (6.7E-5):
BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:114
SQL (0.000128):
SELECT usrgrpid FROM users_groups WHERE userid='2' zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:75
SQL (0.001288):
SELECT d.dashboardid,d.name,d.userid,d.display_period,d.auto_start FROM dashboard d WHERE d.templateid IS NULL AND (d.userid=2 OR d.private=0 OR EXISTS (SELECT NULL FROM dashboard_user du WHERE d.dashboardid=du.dashboardid AND du.userid=2 AND du.permission>=2) OR EXISTS (SELECT NULL FROM dashboard_usrgrp dug WHERE d.dashboardid=dug.dashboardid AND dug.usrgrpid IN (8,14) AND dug.permission>=2)) AND d.dashboardid=1 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → DBselect() in include/classes/api/services/CDashboard.php:125
SQL (0.001452):
SELECT t.dashboard_pageid,t.name,t.display_period,t.dashboardid,t.sortorder FROM dashboard_page t WHERE t.dashboardid=1 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → CDashboard->addRelatedObjects() → CDashboardGeneral->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:349
SQL (0.000219):
SELECT widgetid,type,name,x,y,width,height,view_mode,dashboard_pageid FROM widget WHERE dashboard_pageid=1 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → CDashboard->addRelatedObjects() → CDashboardGeneral->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:821
SQL (0.000532):
SELECT widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_serviceid,value_slaid,value_userid,value_actionid,value_mediatypeid,value_sysmapid FROM widget_field WHERE widgetid IN (1,3,6,7,9,38862) AND type IN (0,1,2,3,4,5,6,7,8,9,10,11,12,13) zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → CDashboard->addRelatedObjects() → CDashboardGeneral->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:821
SQL (6.6E-5):
COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:153
SQL (4.2E-5):
BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CDashboardHelper::updateEditableFlag() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:114
SQL (0.000969):
SELECT d.dashboardid FROM dashboard d WHERE d.templateid IS NULL AND (d.userid=2 OR EXISTS (SELECT NULL FROM dashboard_user du WHERE d.dashboardid=du.dashboardid AND du.userid=2 AND du.permission>=3) OR EXISTS (SELECT NULL FROM dashboard_usrgrp dug WHERE d.dashboardid=dug.dashboardid AND dug.usrgrpid IN (8,14) AND dug.permission>=3)) AND d.dashboardid=1 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CDashboardHelper::updateEditableFlag() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → DBselect() in include/classes/api/services/CDashboard.php:125
SQL (0.000513):
COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CDashboardHelper::updateEditableFlag() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:153
SQL (0.000182):
SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.dashboard.widget.rf_rate' zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CDashboardHelper::preparePages() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:178
SQL (7.3E-5):
BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CDashboardHelper::getOwnerName() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:114
SQL (0.00024):
SELECT DISTINCT u.userid,u.name,u.surname,u.username FROM users u,users_groups ug WHERE u.userid=ug.userid AND ug.usrgrpid IN ( SELECT uug.usrgrpid FROM users_groups uug WHERE uug.userid=2) AND u.userid=1 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CDashboardHelper::getOwnerName() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->get() → DBselect() in include/classes/api/services/CUser.php:320
SQL (5.6E-5):
COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CDashboardHelper::getOwnerName() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:153
SQL (4.2E-5):
BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:114
SQL (0.004675):
SELECT r.reportid FROM report r WHERE r.dashboardid=1 LIMIT 1 zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CReport->get() → DBselect() in include/classes/api/services/CReport.php:94
SQL (6.3E-5):
COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:153
SQL (0.000155):
SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.dashboard.hostid' zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:178
SQL (4.8E-5):
BEGIN zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → getTimeSelectorPeriod() → CSettingsHelper::get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:114
SQL (0.000299):
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() → CControllerDashboardView->doAction() → getTimeSelectorPeriod() → CSettingsHelper::get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CSettings->get() → DBselect() in include/classes/api/services/CSettings.php:68
SQL (5.3E-5):
COMMIT zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → getTimeSelectorPeriod() → CSettingsHelper::get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:153
SQL (0.000176):
SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.dashboard.filter.from' zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:178
SQL (0.000147):
SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.dashboard.filter.to' zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:178
SQL (0.000158):
SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.dashboard.last_widget_type' zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CDashboardHelper::getWidgetLastType() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:178
SQL (0.000121):
SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.dashboard.filter.active' zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:178
SQL (0.000144):
SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.layout.mode' zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CView->getLayoutMode() → CViewHelper::loadLayoutMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:178
SQL (0.000166):
SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.login.attempt.failed' zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → ZBase->processResponseFinal() → CView->getOutput() → include() → CHtmlPage->show() → CHtmlPage->toString() → get_prepared_messages() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:178