Global view

******************** Script profiler ********************
Total time: 0.030364
Total SQL time: 0.023297
SQL count: 30 (selects: 23 | executes: 16)
Peak memory usage: 4M
Memory limit: 128M

1. dashboard.get [CControllerDashboardView.php:217]

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

    [selectWidgets] => Array
        (
            [0] => widgetid
            [1] => type
            [2] => name
            [3] => x
            [4] => y
            [5] => width
            [6] => height
            [7] => fields
        )

    [dashboardids] => 1
    [preservekeys] => 1
)
Result:
Array
(
    [1] => Array
        (
            [dashboardid] => 1
            [name] => Global view
            [userid] => 1
            [widgets] => Array
                (
                    [0] => Array
                        (
                            [widgetid] => 1
                            [type] => systeminfo
                            [name] => 
                            [x] => 0
                            [y] => 0
                            [width] => 4
                            [height] => 4
                            [fields] => Array
                                (
                                )

                        )

                    [1] => Array
                        (
                            [widgetid] => 2
                            [type] => problemsbysv
                            [name] => 
                            [x] => 4
                            [y] => 0
                            [width] => 6
                            [height] => 4
                            [fields] => Array
                                (
                                    [0] => Array
                                        (
                                            [type] => 0
                                            [name] => hide_empty_groups
                                            [value] => 1
                                        )

                                )

                        )

                    [2] => Array
                        (
                            [widgetid] => 3
                            [type] => clock
                            [name] => 
                            [x] => 10
                            [y] => 0
                            [width] => 2
                            [height] => 4
                            [fields] => Array
                                (
                                )

                        )

                    [3] => Array
                        (
                            [widgetid] => 4
                            [type] => problems
                            [name] => 
                            [x] => 0
                            [y] => 4
                            [width] => 10
                            [height] => 10
                            [fields] => Array
                                (
                                    [0] => Array
                                        (
                                            [type] => 0
                                            [name] => show
                                            [value] => 3
                                        )

                                    [1] => Array
                                        (
                                            [type] => 0
                                            [name] => show_tags
                                            [value] => 3
                                        )

                                )

                        )

                    [4] => Array
                        (
                            [widgetid] => 5
                            [type] => favmaps
                            [name] => 
                            [x] => 10
                            [y] => 4
                            [width] => 2
                            [height] => 5
                            [fields] => Array
                                (
                                )

                        )

                    [5] => Array
                        (
                            [widgetid] => 6
                            [type] => favgraphs
                            [name] => 
                            [x] => 10
                            [y] => 9
                            [width] => 2
                            [height] => 5
                            [fields] => Array
                                (
                                )

                        )

                )

        )

)


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

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

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

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


3. user.get [CControllerDashboardView.php:404]

Parameters:
Array
(
    [output] => Array
        (
            [0] => name
            [1] => surname
            [2] => alias
        )

    [userids] => 1
)
Result:
Array
(
)



SQL (0.000377): 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.000501): UPDATE ids SET nextid=2277959 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.000296): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1776049820','216.73.216.101','3','0','','2277959')
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.007362): 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.000528): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.dashbrd.dashboardid'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

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

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

SQL (0.000113): SELECT d.dashboardid,d.name,d.userid 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)) AND d.dashboardid=1
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → DBselect() in include/classes/api/services/CDashboard.php:133

SQL (0.000104): SELECT t.widgetid,t.type,t.name,t.x,t.y,t.width,t.height,t.dashboardid FROM widget t WHERE t.dashboardid=1
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → CDashboard->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:350

SQL (0.00012): SELECT widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid FROM widget_field WHERE widgetid IN (1,2,3,4,5,6)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → CDashboard->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:900

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

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

SQL (9.8E-5): 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() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CControllerDashboardAbstract->prepareEditableFlag() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → DBselect() in include/classes/api/services/CDashboard.php:133

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

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

SQL (9.6E-5): SELECT DISTINCT u.userid,u.name,u.surname,u.alias 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:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CControllerDashboardView::getOwnerData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->get() → DBselect() in include/classes/api/services/CUser.php:171

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

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

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

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

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

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

SQL (0.000282): SELECT i.nextid FROM ids i WHERE i.table_name='profiles' AND i.field_name='profileid'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CProfile::flush() → CProfile::insertDB() → get_dbid() → DBselect() in include/db.inc.php:625

SQL (0.000363): UPDATE ids SET nextid=nextid+1 WHERE table_name='profiles' AND field_name='profileid'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CProfile::flush() → CProfile::insertDB() → get_dbid() → DBexecute() in include/db.inc.php:649

SQL (0.000225): SELECT i.nextid FROM ids i WHERE i.table_name='profiles' AND i.field_name='profileid'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CProfile::flush() → CProfile::insertDB() → get_dbid() → DBselect() in include/db.inc.php:651

SQL (0.000299): INSERT INTO profiles (profileid, userid, idx, value_id, type, idx2) VALUES (1603, 2, 'web.dashbrd.dashboardid', '1', 1, '0')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CProfile::flush() → CProfile::insertDB() → DBexecute() in include/classes/user/CProfile.php:326

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

SQL (0.000612): 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.000571): 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.000436): 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


Debug