******************** Script profiler ********************
Total time: 0.025177
Total SQL time: 0.026015
SQL count: 29 (selects: 27 | executes: 11)
Peak memory usage: 2M
Memory limit: 128M
1. map.get [sysmaps.php:410]
Parameters:
Array
(
[output] => Array
(
[0] => sysmapid
[1] => name
[2] => width
[3] => height
)
[sortfield] => width
[limit] => 1001
[search] => Array
(
[name] =>
)
[preservekeys] => 1
)
| Result:
Array
(
)
|
2. map.get [sysmaps.php:426]
Parameters:
Array
(
[output] => Array
(
)
[sysmapids] => Array
(
)
[editable] => 1
[preservekeys] => 1
)
| Result:
Array
(
)
|
SQL (0.000729): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
sysmaps.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.000485): UPDATE ids SET nextid=2613825 WHERE table_name='auditlog' AND field_name='auditid'
sysmaps.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.001388): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1791611642','216.73.216.30','3','0','','2613825')
sysmaps.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.014071): COMMIT
sysmaps.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.000229): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.menu.view.last'
sysmaps.php:32 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000195): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.login.attempt.failed'
sysmaps.php:32 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.001348): DELETE FROM profiles WHERE idx='web.maps.sysmapid' AND idx2='0' AND userid='2'
sysmaps.php:379 → CProfile::delete() → CProfile::deleteValues() → DB::delete() → DBexecute() in include/classes/db/DB.php:846
SQL (0.000969): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.sysmaps.php.sort'
sysmaps.php:381 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000562): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.sysmaps.php.sortorder'
sysmaps.php:382 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000463): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.sysmapconf.filter_name'
sysmaps.php:400 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000519): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.sysmapconf.filter.active'
sysmaps.php:405 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000181): BEGIN
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234
SQL (0.00015): SELECT usrgrpid FROM users_groups WHERE userid='2'
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->getMaps() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:283
SQL (0.000302): SELECT s.sysmapid,s.name,s.width,s.height FROM sysmaps s WHERE (EXISTS (SELECT NULL FROM sysmap_user su WHERE s.sysmapid=su.sysmapid AND su.userid=2 AND su.permission>=2) OR EXISTS (SELECT NULL FROM sysmap_usrgrp sg WHERE s.sysmapid=sg.sysmapid AND sg.usrgrpid=8 AND sg.permission>=2) OR s.userid=2 OR s.private=0) ORDER BY s.width
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->getMaps() → DBselect() in include/classes/api/services/CMap.php:222
SQL (0.000158): SELECT se.sysmapid,se.elementid FROM sysmaps_elements se WHERE se.sysmapid=1 AND se.elementtype=1
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->checkPermissions() → CMap::getSelements() → DBselect() in include/classes/api/services/CMap.php:406
SQL (0.000118): SELECT se.sysmapid,0 AS elementid FROM sysmaps_elements se WHERE se.sysmapid=1 AND se.elementtype=4
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->checkPermissions() → CMap::getSelements() → DBselect() in include/classes/api/services/CMap.php:406
SQL (0.000123): SELECT se.sysmapid,se.elementid FROM sysmaps_elements se WHERE se.sysmapid=1 AND se.elementtype=3
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->checkPermissions() → CMap::getSelements() → DBselect() in include/classes/api/services/CMap.php:406
SQL (0.000124): SELECT g.groupid FROM hstgrp g WHERE EXISTS (SELECT NULL FROM rights r WHERE g.groupid=r.id AND r.groupid=8 GROUP BY r.id HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND 1=0
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->checkPermissions() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:315
SQL (0.000115): SELECT se.sysmapid,se.elementid FROM sysmaps_elements se WHERE se.sysmapid=1 AND se.elementtype=0
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->checkPermissions() → CMap::getSelements() → DBselect() in include/classes/api/services/CMap.php:406
SQL (0.001175): SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.hostid=10084 AND h.status IN (0,1)
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->checkPermissions() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:439
SQL (0.000138): SELECT se.sysmapid,st.triggerid AS elementid FROM sysmaps_elements se,sysmap_element_trigger st WHERE se.selementid=st.selementid AND se.sysmapid=1 AND se.elementtype=2
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->checkPermissions() → CMap::getSelements() → DBselect() in include/classes/api/services/CMap.php:406
SQL (0.000119): SELECT sl.sysmapid,slt.triggerid FROM sysmaps_links sl,sysmaps_link_triggers slt WHERE sl.linkid=slt.linkid AND sl.sysmapid=1
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->checkPermissions() → CMap::getLinkTriggers() → DBselect() in include/classes/api/services/CMap.php:425
SQL (0.000887): SELECT t.triggerid FROM triggers t WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE t.triggerid=f.triggerid AND f.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 1=0 AND t.flags IN (0,4)
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->checkPermissions() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1068
SQL (0.000122): COMMIT
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291
SQL (0.000429): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.paging.lastpage'
sysmaps.php:422 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000586): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.paging.page'
sysmaps.php:422 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (9.9E-5): BEGIN
sysmaps.php:426 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234
SQL (0.000116): SELECT s.sysmapid FROM sysmaps s WHERE (EXISTS (SELECT NULL FROM sysmap_user su WHERE s.sysmapid=su.sysmapid AND su.userid=2 AND su.permission>=3) OR EXISTS (SELECT NULL FROM sysmap_usrgrp sg WHERE s.sysmapid=sg.sysmapid AND sg.usrgrpid=8 AND sg.permission>=3) OR s.userid=2) AND 1=0
sysmaps.php:426 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMap->get() → CMap->getMaps() → DBselect() in include/classes/api/services/CMap.php:222
SQL (0.000115): COMMIT
sysmaps.php:426 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291