******************** Script profiler ********************
Total time: 0.033128
Total SQL time: 0.029094
SQL count: 25 (selects: 19 | executes: 15)
Peak memory usage: 2M
Memory limit: 128M
1. screen.get [screenconf.php:408]
Parameters:
Array
(
[output] => Array
(
[0] => screenid
[1] => name
[2] => hsize
[3] => vsize
)
[sortfield] => name
[limit] => 1001
[search] => Array
(
[name] =>
)
[preservekeys] => 1
)
| Result:
Array
(
)
|
2. screen.get [screenconf.php:421]
Parameters:
Array
(
[output] => Array
(
)
[screenids] => Array
(
)
[editable] => 1
[preservekeys] => 1
)
| Result:
Array
(
)
|
SQL (0.000332): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
screenconf.php:22 → 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.000467): UPDATE ids SET nextid=2278224 WHERE table_name='auditlog' AND field_name='auditid'
screenconf.php:22 → 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.00031): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1776056337','216.73.216.101','3','0','','2278224')
screenconf.php:22 → 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.010477): COMMIT
screenconf.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:291
SQL (0.000149): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.menu.view.last'
screenconf.php:33 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000166): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.login.attempt.failed'
screenconf.php:33 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.001138): DELETE FROM profiles WHERE idx='web.screens.elementid' AND idx2='0' AND userid='2'
screenconf.php:367 → CProfile::delete() → CProfile::deleteValues() → DB::delete() → DBexecute() in include/classes/db/DB.php:846
SQL (0.000752): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.screenconf.php.sort'
screenconf.php:369 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000398): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.screenconf.php.sortorder'
screenconf.php:370 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000307): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.screenconf.filter_name'
screenconf.php:404 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000126): BEGIN
screenconf.php:408 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234
SQL (0.000158): SELECT usrgrpid FROM users_groups WHERE userid='2'
screenconf.php:408 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CScreen->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:283
SQL (0.000192): SELECT s.screenid,s.name,s.hsize,s.vsize FROM screens s WHERE s.templateid IS NULL AND (EXISTS (SELECT NULL FROM screen_user su WHERE s.screenid=su.screenid AND su.userid=2 AND su.permission>=2) OR EXISTS (SELECT NULL FROM screen_usrgrp sg WHERE s.screenid=sg.screenid AND sg.usrgrpid=8 AND sg.permission>=2) OR s.userid=2 OR s.private=0) ORDER BY s.name LIMIT 1001
screenconf.php:408 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CScreen->get() → DBselect() in include/classes/api/services/CScreen.php:167
SQL (0.000197): SELECT si.screenid,si.resourcetype,si.resourceid,si.style FROM screens_items si WHERE si.screenid=16 AND si.resourcetype IN (0,1,2,3,4,5,7,8,9,10,14,16) AND si.resourceid<>0
screenconf.php:408 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CScreen->get() → DBselect() in include/classes/api/services/CScreen.php:185
SQL (0.002457): SELECT g.graphid FROM graphs g WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE g.graphid=gi.graphid AND gi.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND NOT EXISTS (SELECT NULL FROM items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE g.ymin_type=2 AND g.ymin_itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND NOT EXISTS (SELECT NULL FROM items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE g.ymax_type=2 AND g.ymax_itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND g.graphid IN (524,525) AND g.flags IN (0,4)
screenconf.php:408 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CScreen->get() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:290
SQL (0.000258): COMMIT
screenconf.php:408 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291
SQL (0.000204): BEGIN
screenconf.php:421 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234
SQL (0.000237): SELECT s.screenid FROM screens s WHERE s.templateid IS NULL AND (EXISTS (SELECT NULL FROM screen_user su WHERE s.screenid=su.screenid AND su.userid=2 AND su.permission>=3) OR EXISTS (SELECT NULL FROM screen_usrgrp sg WHERE s.screenid=sg.screenid AND sg.usrgrpid=8 AND sg.permission>=3) OR s.userid=2) AND 1=0
screenconf.php:421 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CScreen->get() → DBselect() in include/classes/api/services/CScreen.php:167
SQL (0.000183): COMMIT
screenconf.php:421 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291
SQL (0.000741): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.screenconf.filter.active'
screenconf.php:435 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000625): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.paging.lastpage'
screenconf.php:441 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000112): BEGIN
screenconf.php:449 → require_once() → DBstart() → DBexecute() in include/db.inc.php:234
SQL (0.000476): UPDATE profiles SET value_str='screens.php', type=3 WHERE userid=2 AND idx='web.menu.view.last' AND idx2='0'
screenconf.php:449 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338
SQL (0.000212): UPDATE profiles SET value_str='screenconf.php', type=3 WHERE userid=2 AND idx='web.paging.lastpage' AND idx2='0'
screenconf.php:449 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338
SQL (0.00842): COMMIT
screenconf.php:449 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291