******************** Script profiler ********************
Total time: 0.064621
Total SQL time: 0.068494
SQL count: 35 (selects: 24 | executes: 11)
Peak memory usage: 3M
Memory limit: 512M

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

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

    [preservekeys] => 1
    [real_hosts] => 1
    [editable] => 1
)
	Result:
Array
(
)

2. host.get [hosts.php:1142]

Parameters:
Array
(
    [hostids] => Array
        (
        )

    [output] => extend
    [selectParentTemplates] => Array
        (
            [0] => hostid
            [1] => name
        )

    [selectInterfaces] => extend
    [selectItems] => count
    [selectDiscoveries] => count
    [selectTriggers] => count
    [selectGraphs] => count
    [selectApplications] => count
    [selectHttpTests] => count
    [selectDiscoveryRule] => Array
        (
            [0] => itemid
            [1] => name
        )

    [selectHostDiscovery] => Array
        (
            [0] => ts_delete
        )

)
	Result:
Array
(
)

3. template.get [hosts.php:1159]

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

    [templateids] => Array
        (
        )

    [selectParentTemplates] => Array
        (
            [0] => hostid
            [1] => name
        )

    [preservekeys] => 1
)
	Result:
Array
(
)


SQL (0.000505): SET search_path = 'public'
hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:84

SQL (0.000409): SET bytea_output = escape
hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:95

SQL (0.007843): SELECT 1 FROM information_schema.tables WHERE table_catalog='zabbix' AND table_schema='public' AND table_name='dbversion'
hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → PostgresqlDbBackend->checkDbVersionTable() → DBselect() in include/classes/db/PostgresqlDbBackend.php:41

SQL (0.001024): SELECT dv.mandatory,dv.optional FROM dbversion dv
hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → DBselect() in include/classes/db/DbBackend.php:46

SQL (0.001152): SELECT NULL FROM config c
hosts.php:22 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkConfig() → DBselect() in include/classes/db/DbBackend.php:62

SQL (0.000428): BEGIN
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:237

SQL (0.00179): SELECT sessionid,userid,lastaccess FROM sessions WHERE sessionid='f090d60cd6497605abb0b4e4ec239753' AND status=0
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DB::select() → DBselect() in include/classes/db/DB.php:918

SQL (0.001289): SELECT userid,alias,name,surname,url,autologin,autologout,lang,refresh,type,theme,attempt_failed,attempt_ip,attempt_clock,rows_per_page FROM users WHERE userid=25
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DB::select() → DBselect() in include/classes/db/DB.php:918

SQL (0.001623): SELECT g.debug_mode,g.users_status,g.gui_access FROM usrgrp g,users_groups ug WHERE g.usrgrpid=ug.usrgrpid AND ug.userid=25
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → CUser->getUserGroupsData() → DBselect() in include/classes/api/services/CUser.php:1576

SQL (0.000715): UPDATE sessions SET lastaccess='1529497598' WHERE sessionid='f090d60cd6497605abb0b4e4ec239753'
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CUser->checkAuthentication() → DB::update() → DBexecute() in include/classes/db/DB.php:573

SQL (0.006231): COMMIT
hosts.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CFrontendApiWrapper->checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:294

SQL (0.001322): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.menu.config.last'
hosts.php:41 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.001539): SELECT c.* FROM config c
hosts.php:41 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33

SQL (0.000982): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.login.attempt.failed'
hosts.php:41 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.001576): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.hosts.filter_ip'
hosts.php:179 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.000774): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.hosts.filter_dns'
hosts.php:180 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.000747): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.hosts.filter_host'
hosts.php:181 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.000702): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.hosts.filter_port'
hosts.php:182 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.000353): BEGIN
hosts.php:774 → CPageFilter->__construct() → CPageFilter->_initGroups() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:237

SQL (0.003758): SELECT usrgrpid FROM users_groups WHERE userid='25'
hosts.php:774 → CPageFilter->__construct() → CPageFilter->_initGroups() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHostGroup->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:304

SQL (0.013723): SELECT g.groupid,g.name FROM groups g WHERE EXISTS (SELECT NULL FROM rights r WHERE g.groupid=r.id AND r.groupid IN ('11','29') GROUP BY r.id HAVING MIN(r.permission)>0 AND MAX(r.permission)>='3') 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)
hosts.php:774 → CPageFilter->__construct() → CPageFilter->_initGroups() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:315

SQL (0.000955): COMMIT
hosts.php:774 → CPageFilter->__construct() → CPageFilter->_initGroups() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:294

SQL (0.003951): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.config.groupid'
hosts.php:774 → CPageFilter->__construct() → CPageFilter->_initGroups() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.000827): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.latest.groupid'
hosts.php:774 → CPageFilter->__construct() → CPageFilter->_initGroups() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.000595): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.hosts.php.sort'
hosts.php:1097 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.000582): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.hosts.php.sortorder'
hosts.php:1098 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.000991): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.paging.lastpage'
hosts.php:1127 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.00104): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.paging.page'
hosts.php:1127 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165

SQL (0.000356): BEGIN
hosts.php:1142 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:237

SQL (0.001994): SELECT h.* 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 IN ('11','29') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND 1=0 AND h.status IN (0,1)
hosts.php:1142 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:429

SQL (0.001616): COMMIT
hosts.php:1142 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:294

SQL (0.000315): BEGIN
hosts.php:1159 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:237

SQL (0.005352): SELECT h.hostid,h.templateid,h.name FROM hosts h WHERE h.status=3 AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('11','29') WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND 1=0
hosts.php:1159 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTemplate->get() → DBselect() in include/classes/api/services/CTemplate.php:256

SQL (0.00059): COMMIT
hosts.php:1159 → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:294

SQL (0.000845): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=25 AND idx='web.hosts.filter.state'
hosts.php:1216 → CView->render() → include() → CFilter->__construct() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:165