******************** Script profiler ********************
Total time: 0.035206
Total SQL time: 0.031953
SQL count: 26 (selects: 22 | executes: 13)
Peak memory usage: 2M
Memory limit: 128M
1. hostgroup.get [CPageFilter.php:371]
Parameters:
Array
(
[output] => Array
(
[0] => groupid
[1] => name
)
[preservekeys] => 1
[real_hosts] => 1
)
| Result:
Array
(
)
|
SQL (0.000627): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
hostinventories.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.000352): UPDATE ids SET nextid=2365299 WHERE table_name='auditlog' AND field_name='auditid'
hostinventories.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.001294): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1781231444','216.73.216.184','3','0','','2365299')
hostinventories.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.008711): COMMIT
hostinventories.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.001295): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.menu.cm.last'
hostinventories.php:37 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000605): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.login.attempt.failed'
hostinventories.php:37 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000418): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.hostinventories.php.sort'
hostinventories.php:68 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000386): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.hostinventories.php.sortorder'
hostinventories.php:69 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.00038): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.hostinventories.filter.active'
hostinventories.php:143 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000375): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.cm.groupid'
hostinventories.php:151 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000334): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.cm.hostid'
hostinventories.php:151 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000339): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.cm.graphid'
hostinventories.php:151 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000128): BEGIN
hostinventories.php:151 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234
SQL (0.000128): SELECT usrgrpid FROM users_groups WHERE userid='2'
hostinventories.php:151 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:283
SQL (0.0019): SELECT g.groupid,g.name 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 EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status IN (0,1) AND g.groupid=hg.groupid)
hostinventories.php:151 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:315
SQL (0.000148): COMMIT
hostinventories.php:151 → CPageFilter->__construct() → CPageFilter->_initGroups() → 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.latest.groupid'
hostinventories.php:151 → CPageFilter->__construct() → CPageFilter->_initGroups() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.00063): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.hostinventories.filter_field'
hostinventories.php:171 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000364): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.hostinventories.filter_field_value'
hostinventories.php:172 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000356): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.hostinventories.filter_exact'
hostinventories.php:173 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000323): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.paging.lastpage'
hostinventories.php:263 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000226): BEGIN
hostinventories.php:270 → require_once() → DBstart() → DBexecute() in include/db.inc.php:234
SQL (0.000567): UPDATE profiles SET value_str='DESC', type=3 WHERE userid=2 AND idx='web.hostinventories.php.sortorder' AND idx2='0'
hostinventories.php:270 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338
SQL (0.000298): UPDATE profiles SET value_str='hostinventories.php', type=3 WHERE userid=2 AND idx='web.menu.cm.last' AND idx2='0'
hostinventories.php:270 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338
SQL (0.000255): UPDATE profiles SET value_str='hostinventories.php', type=3 WHERE userid=2 AND idx='web.paging.lastpage' AND idx2='0'
hostinventories.php:270 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338
SQL (0.010986): COMMIT
hostinventories.php:270 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291