******************** Script profiler ********************
Total time: 0.132098
Total SQL time: 0.123728
SQL count: 32 (selects: 29 | executes: 12)
Peak memory usage: 4M
Memory limit: 128M
1. hostgroup.get [CPageFilter.php:371]
Parameters:
Array
(
[output] => Array
(
[0] => groupid
[1] => name
)
[preservekeys] => 1
[with_monitored_triggers] => 1
)
| Result:
Array
(
)
|
SQL (0.000574): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
overview.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.000371): UPDATE ids SET nextid=2365246 WHERE table_name='auditlog' AND field_name='auditid'
overview.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.001708): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1781222529','216.73.216.184','3','0','','2365246')
overview.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.006146): COMMIT
overview.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.076381): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.layout.mode'
overview.php:33 → CView::getLayoutMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000793): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.menu.view.last'
overview.php:39 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000668): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.login.attempt.failed'
overview.php:39 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000404): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.overview.type'
overview.php:120 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.00045): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.overview.filter.show_triggers'
overview.php:127 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000352): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.view.groupid'
overview.php:141 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000303): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.view.hostid'
overview.php:141 → CPageFilter->__construct() → CPageFilter->_getProfiles() → 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.view.graphid'
overview.php:141 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000116): BEGIN
overview.php:141 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234
SQL (0.000104): SELECT usrgrpid FROM users_groups WHERE userid='2'
overview.php:141 → 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.004855): 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 items i,hosts h,functions f,triggers t,hosts_groups hg WHERE hg.hostid=i.hostid AND hg.hostid=h.hostid AND i.itemid=f.itemid AND f.triggerid=t.triggerid AND h.status=0 AND i.status=0 AND t.status=0 AND t.flags IN (0,4) AND g.groupid=hg.groupid)
overview.php:141 → 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.000168): COMMIT
overview.php:141 → 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.000408): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.latest.groupid'
overview.php:141 → CPageFilter->__construct() → CPageFilter->_initGroups() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000348): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.overview.view_style'
overview.php:146 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000313): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.overview.filter.active'
overview.php:152 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000353): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.overview.filter.ack_status'
overview.php:160 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000284): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.overview.filter.show_severity'
overview.php:161 → 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.overview.filter.status_change'
overview.php:162 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000196): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.overview.filter.status_change_days'
overview.php:163 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000183): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.overview.filter.txt_select'
overview.php:164 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000192): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.overview.filter.application'
overview.php:165 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000171): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.overview.filter.show_suppressed'
overview.php:166 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000186): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.overview.filter.inventory.field'
overview.php:169 → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (0.000358): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.paging.lastpage'
overview.php:232 → require_once() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164
SQL (7.4E-5): BEGIN
overview.php:232 → require_once() → DBstart() → DBexecute() in include/db.inc.php:234
SQL (0.000296): UPDATE profiles SET value_str='overview.php', type=3 WHERE userid=2 AND idx='web.menu.view.last' AND idx2='0'
overview.php:232 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338
SQL (0.0003): UPDATE profiles SET value_str='overview.php', type=3 WHERE userid=2 AND idx='web.paging.lastpage' AND idx2='0'
overview.php:232 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338
SQL (0.025734): COMMIT
overview.php:232 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291