******************** Script profiler ********************
Total time: 0.012199
Total SQL time: 0.008326
SQL count: 19 (selects: 18 | executes: 10)
Peak memory usage: 2M
Memory limit: 128M

1. hostgroup.get [CPageFilter.php:376]

Parameters:
Array
(
    [output] => Array
        (
            [0] => groupid
            [1] => name
        )

    [preservekeys] => 1
    [real_hosts] => 1
)
	Result:
Array
(
    [8] => Array
        (
            [groupid] => 8
            [name] => CNS_Intranet
        )

    [13] => Array
        (
            [groupid] => 13
            [name] => File Server
        )

    [4] => Array
        (
            [groupid] => 4
            [name] => Zabbix servers
        )

)


SQL (0.003713): COMMIT
hostinventoriesoverview.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.000197): SELECT NULL FROM users u WHERE u.userid=1 FOR UPDATE
hostinventoriesoverview.php:29 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:37

SQL (0.000188): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.menu.cm.last'
hostinventoriesoverview.php:29 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167

SQL (0.000208): SELECT c.* FROM config c
hostinventoriesoverview.php:29 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33

SQL (7.8E-5): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.login.attempt.failed'
hostinventoriesoverview.php:29 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167

SQL (0.000201): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.hostinventoriesoverview.php.sort'
hostinventoriesoverview.php:41 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167

SQL (0.000192): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.hostinventoriesoverview.php.sortorder'
hostinventoriesoverview.php:42 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167

SQL (0.000153): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.cm.groupid'
hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167

SQL (0.000136): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.cm.hostid'
hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167

SQL (0.000155): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.cm.graphid'
hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167

SQL (7.0E-5): BEGIN
hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (7.1E-5): SELECT g.groupid,g.name FROM hstgrp g WHERE 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)
hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:358

SQL (5.3E-5): COMMIT
hostinventoriesoverview.php:65 → 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.000131): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.latest.groupid'
hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_initGroups() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167

SQL (0.000202): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.paging.lastpage'
hostinventoriesoverview.php:162 → require_once() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167

SQL (8.9E-5): BEGIN
hostinventoriesoverview.php:162 → require_once() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.00018): UPDATE profiles SET value_str='hostinventoriesoverview.php', type=3 WHERE userid=1 AND idx='web.menu.cm.last' AND idx2='0'
hostinventoriesoverview.php:162 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:341

SQL (0.00018): UPDATE profiles SET value_str='hostinventoriesoverview.php', type=3 WHERE userid=1 AND idx='web.paging.lastpage' AND idx2='0'
hostinventoriesoverview.php:162 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:341

SQL (0.002129): COMMIT
hostinventoriesoverview.php:162 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291