******************** Script profiler ********************
Total time: 0.030998
Total SQL time: 0.01687
SQL count: 21 (selects: 17 | executes: 12)
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] => 11
)
[preservekeys] => 1
)
| Result:
Array
(
)
|
2. map.get [sysmaps.php:426]
Parameters:
Array
(
[output] => Array
(
)
[sysmapids] => Array
(
)
[editable] => 1
[preservekeys] => 1
)
| Result:
Array
(
)
|
SQL (0.000133): 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.000365): 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.00051): SELECT c.* FROM config c
sysmaps.php:32 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33
SQL (0.000436): 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.000178): 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.000204): 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.000176): 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.000175): 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.000163): 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 (7.6E-5): BEGIN
sysmaps.php:410 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234
SQL (7.4E-5): 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.003338): 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) AND ( ( UPPER(s.name) LIKE '%11%' ESCAPE '!' ) ) 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.0001): 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.000291): 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 (8.5E-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.000343): 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 (8.5E-5): COMMIT
sysmaps.php:426 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291
SQL (0.000141): BEGIN
sysmaps.php:444 → require_once() → DBstart() → DBexecute() in include/db.inc.php:234
SQL (0.000515): UPDATE profiles SET value_str='zabbix.php', type=3 WHERE userid=2 AND idx='web.menu.view.last' AND idx2='0'
sysmaps.php:444 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338
SQL (0.00021): UPDATE profiles SET value_str='sysmaps.php', type=3 WHERE userid=2 AND idx='web.paging.lastpage' AND idx2='0'
sysmaps.php:444 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338
SQL (0.009272): COMMIT
sysmaps.php:444 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291