Dashboards

******************** Script profiler ********************
Total time: 0.029495
Total SQL time: 0.023795
SQL count: 22 (selects: 17 | executes: 14)
Peak memory usage: 2M
Memory limit: 128M

1. dashboard.get [CControllerDashboardList.php:72]

Parameters:
Array
(
    [output] => Array
        (
            [0] => dashboardid
            [1] => name
        )

    [limit] => 1001
    [preservekeys] => 1
)
Result:
Array
(
    [1] => Array
        (
            [dashboardid] => 1
            [name] => Global view
        )

)

2. dashboard.get [CControllerDashboardAbstract.php:34]

Parameters:
Array
(
    [output] => Array
        (
        )

    [dashboardids] => Array
        (
            [0] => 1
        )

    [editable] => 1
    [preservekeys] => 1
)
Result:
Array
(
)


SQL (0.000302): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:107

SQL (0.000236): UPDATE ids SET nextid=2277746 WHERE table_name='auditlog' AND field_name='auditid'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:121

SQL (0.000213): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1776044249','216.73.216.101','3','0','','2277746')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DBexecute() in include/classes/db/DB.php:467

SQL (0.008974): COMMIT
zabbix.php:21 → 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:291

SQL (0.000467): DELETE FROM profiles WHERE idx='web.dashbrd.dashboardid' AND idx2='0' AND userid='2'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → CProfile::delete() → CProfile::deleteValues() → DB::delete() → DBexecute() in include/classes/db/DB.php:846

SQL (0.000437): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.dashbrd.list_was_opened'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000452): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.dashbrd.list.sort'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000357): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.dashbrd.list.sortorder'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000148): BEGIN
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.00013): SELECT usrgrpid FROM users_groups WHERE userid='2'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:283

SQL (0.000128): SELECT d.dashboardid,d.name FROM dashboard d WHERE (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=8 AND dug.permission>=2)) LIMIT 1001
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → DBselect() in include/classes/api/services/CDashboard.php:133

SQL (0.000109): COMMIT
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000361): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.paging.lastpage'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000152): BEGIN
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → CControllerDashboardAbstract->prepareEditableFlag() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000153): SELECT d.dashboardid FROM dashboard d WHERE (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=8 AND dug.permission>=3)) AND d.dashboardid=1
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → CControllerDashboardAbstract->prepareEditableFlag() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → DBselect() in include/classes/api/services/CDashboard.php:133

SQL (0.000122): COMMIT
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardList->doAction() → CControllerDashboardAbstract->prepareEditableFlag() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (9.7E-5): BEGIN
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000602): UPDATE profiles SET value_str='ASC', type=3 WHERE userid=2 AND idx='web.dashbrd.list.sortorder' AND idx2='0'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338

SQL (0.008794): COMMIT
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000451): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.layout.mode'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CView::getLayoutMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000595): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.menu.view.last'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → local_generateHeader() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000515): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.login.attempt.failed'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → local_generateHeader() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164