******************** Script profiler ********************
Total time: 0.795389
Total SQL time: 0.134112
SQL count: 70 (selects: 43 | executes: 27)
Peak memory usage: 11.25M
Memory limit: 128M

1. user->checkAuthentication [class.cwebuser.php:80]
Parameters:
703d0d3587c969668de8daa31fdebd16
Result:
Array
(
    [userid] => 9909900000000001
    [alias] => Admin
    [name] => Zabbix
    [surname] => Administrator
    [url] => 
    [autologin] => 1
    [autologout] => 0
    [lang] => en_GB
    [refresh] => 30
    [type] => 3
    [theme] => default
    [attempt_failed] => 0
    [attempt_ip] => 
    [attempt_clock] => 0
    [rows_per_page] => 50
    [debug_mode] => 1
    [userip] => 10.0.2.2
    [node] => Array
        (
            [nodeid] => 99
            [name] => Local node
            [ip] => 127.0.0.1
            [port] => 10051
            [nodetype] => 1
            [masterid] => 0
        )

    [sessionid] => 703d0d3587c969668de8daa31fdebd16
    [gui_access] => 0
)
2. graph->get [graphs.php:139]
Parameters:
Array
(
    [nodeids] => Array
        (
            [99] => 99
        )

    [filter] => Array
        (
            [flags] => 0
        )

    [graphids] => Array
        (
            [0] => 9909900000000455
        )

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

)
3. graph->update [graphs.php:201]
Parameters:
Array
(
    [name] => MySQL bandwidth1
    [width] => 900
    [height] => 200
    [ymin_type] => 0
    [ymax_type] => 0
    [yaxismin] => 0.0000
    [yaxismax] => 100.0000
    [ymin_itemid] => 0
    [ymax_itemid] => 0
    [show_work_period] => 1
    [show_triggers] => 1
    [graphtype] => 0
    [show_legend] => 1
    [show_3d] => 0
    [percent_left] => 0
    [percent_right] => 0
    [gitems] => Array
        (
            [0] => Array
                (
                    [gitemid] => 9909900000001488
                    [graphid] => 9909900000000456
                    [itemid] => 9909900000022830
                    [sortorder] => 0
                    [flags] => 0
                    [type] => 0
                    [calc_fnc] => 2
                    [drawtype] => 5
                    [yaxisside] => 0
                    [color] => 00AA00
                )

            [1] => Array
                (
                    [gitemid] => 9909900000001488
                    [graphid] => 9909900000000456
                    [itemid] => 9909900000022828
                    [sortorder] => 1
                    [flags] => 0
                    [type] => 0
                    [calc_fnc] => 2
                    [drawtype] => 5
                    [yaxisside] => 0
                    [color] => 3333FF
                )

        )

    [graphid] => 9909900000000455
)
Result:
4. hostgroup->get [class.cpagefilter.php:342]
Parameters:
Array
(
    [nodeids] => 
    [output] => Array
        (
            [0] => groupid
            [1] => name
        )

    [not_proxy_hosts] => 1
    [editable] => 1
)
Result:
Array
(
    [0] => Array
        (
            [groupid] => 9909900000000001
            [name] => Templates
        )

    [1] => Array
        (
            [groupid] => 9909900000000004
            [name] => Zabbix servers
        )

    [2] => Array
        (
            [groupid] => 9909900000000006
            [name] => Test
        )

)
5. host->get [class.cpagefilter.php:408]
Parameters:
Array
(
    [nodeids] => 
    [output] => Array
        (
            [0] => hostid
            [1] => name
        )

    [groupids] => 
    [editable] => 1
    [templated_hosts] => 1
)
Result:
Array
(
    [0] => Array
        (
            [hostid] => 9909900000010001
            [name] => Template OS Linux
        )

    [1] => Array
        (
            [hostid] => 9909900000010047
            [name] => Template App Zabbix Server
        )

    [2] => Array
        (
            [hostid] => 9909900000010050
            [name] => Template App Zabbix Agent
        )

    [3] => Array
        (
            [hostid] => 9909900000010056
            [name] => Template App Agentless
        )

    [4] => Array
        (
            [hostid] => 9909900000010060
            [name] => Template SNMP Interfaces
        )

    [5] => Array
        (
            [hostid] => 9909900000010065
            [name] => Template SNMP Generic
        )

    [6] => Array
        (
            [hostid] => 9909900000010066
            [name] => Template SNMP Device
        )

    [7] => Array
        (
            [hostid] => 9909900000010067
            [name] => Template SNMP OS Windows
        )

    [8] => Array
        (
            [hostid] => 9909900000010068
            [name] => Template SNMP Disks
        )

    [9] => Array
        (
            [hostid] => 9909900000010069
            [name] => Template SNMP OS Linux
        )

    [10] => Array
        (
            [hostid] => 9909900000010070
            [name] => Template SNMP Processors
        )

    [11] => Array
        (
            [hostid] => 9909900000010071
            [name] => Template IPMI Intel SR1530
        )

    [12] => Array
        (
            [hostid] => 9909900000010072
            [name] => Template IPMI Intel SR1630
        )

    [13] => Array
        (
            [hostid] => 9909900000010073
            [name] => Template App MySQL
        )

    [14] => Array
        (
            [hostid] => 9909900000010074
            [name] => Template OS OpenBSD
        )

    [15] => Array
        (
            [hostid] => 9909900000010075
            [name] => Template OS FreeBSD
        )

    [16] => Array
        (
            [hostid] => 9909900000010076
            [name] => Template OS AIX
        )

    [17] => Array
        (
            [hostid] => 9909900000010077
            [name] => Template OS HP-UX
        )

    [18] => Array
        (
            [hostid] => 9909900000010078
            [name] => Template OS Solaris
        )

    [19] => Array
        (
            [hostid] => 9909900000010079
            [name] => Template OS Mac OS X
        )

    [20] => Array
        (
            [hostid] => 9909900000010081
            [name] => Template OS Windows
        )

    [21] => Array
        (
            [hostid] => 9909900000010082
            [name] => Template JMX Generic
        )

    [22] => Array
        (
            [hostid] => 9909900000010083
            [name] => Template JMX Tomcat
        )

    [23] => Array
        (
            [hostid] => 9909900000010084
            [name] => Zabbix server
        )

    [24] => Array
        (
            [hostid] => 9909900000010085
            [name] => Some template
        )

    [25] => Array
        (
            [hostid] => 9909900000010086
            [name] => Test
        )

)
6. host->get [html.inc.php:329]
Parameters:
Array
(
    [hostids] => 9909900000010073
    [output] => extend
    [templated_hosts] => 1
    [selectItems] => count
    [selectTriggers] => count
    [selectGraphs] => count
    [selectApplications] => count
    [selectScreens] => count
    [selectDiscoveries] => count
)
Result:
Array
(
    [0] => Array
        (
            [items] => 14
            [discoveries] => 0
            [triggers] => 1
            [graphs] => 2
            [applications] => 1
            [screens] => 1
            [maintenances] => Array
                (
                )

            [hostid] => 9909900000010073
            [proxy_hostid] => 0
            [host] => Template App MySQL
            [status] => 3
            [disable_until] => 0
            [error] => 
            [available] => 0
            [errors_from] => 0
            [lastaccess] => 0
            [ipmi_authtype] => 0
            [ipmi_privilege] => 2
            [ipmi_username] => 
            [ipmi_password] => 
            [ipmi_disable_until] => 0
            [ipmi_available] => 0
            [snmp_disable_until] => 0
            [snmp_available] => 0
            [maintenanceid] => 0
            [maintenance_status] => 0
            [maintenance_type] => 0
            [maintenance_from] => 0
            [ipmi_errors_from] => 0
            [snmp_errors_from] => 0
            [ipmi_error] => 
            [snmp_error] => 
            [jmx_disable_until] => 0
            [jmx_available] => 0
            [jmx_errors_from] => 0
            [jmx_error] => 
            [name] => Template App MySQL
        )

)

SQL (0.000708): SET NAMES utf8
require_once() -> DBconnect() -> DBexecute()

SQL (0.001247): SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid
require_once() -> DBselect()

SQL (0.00077): begin
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.002502): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='703d0d3587c969668de8daa31fdebd16' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1363474203) OR (u.autologout=0)) AND u.userid BETWEEN 9900000000000000 AND 9999999999999999
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBselect()

SQL (0.00107): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid=9909900000000001 AND g.usrgrpid=ug.usrgrpid AND g.users_status=1 LIMIT 1 OFFSET 0
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> check_perm2system() -> DBselect()

SQL (0.001247): UPDATE sessions SET lastaccess=1363474203 WHERE userid=9909900000000001 AND sessionid='703d0d3587c969668de8daa31fdebd16'
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBexecute()

SQL (0.0011): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=9909900000000001 AND g.usrgrpid=ug.usrgrpid
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBselect()

SQL (0.000871): SELECT u.userid,u.alias,u.name,u.surname,u.url,u.autologin,u.autologout,u.lang,u.refresh,u.type, u.theme,u.attempt_failed,u.attempt_ip,u.attempt_clock,u.rows_per_page FROM users u WHERE u.userid=9909900000000001
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect()

SQL (0.00073): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=9909900000000001 AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect()

SQL (0.007147): commit
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.00106): SELECT DISTINCT n.nodeid,n.name,n.masterid FROM nodes n
require_once() -> init_nodes() -> DBselect()

SQL (0.000623): SELECT n.nodeid FROM nodes n
require_once() -> init_nodes() -> get_accessible_nodes_by_user() -> DBselect()

SQL (0.000856): SELECT n.nodeid FROM nodes n
require_once() -> init_nodes() -> get_viewed_nodes() -> get_accessible_nodes_by_user() -> DBselect()

SQL (0.000897): SELECT n.* FROM nodes n WHERE n.nodeid=99 ORDER BY n.name
require_once() -> init_nodes() -> get_viewed_nodes() -> get_accessible_nodes_by_user() -> DBselect()

SQL (0.001302): SELECT p.value_id FROM profiles p WHERE p.userid=9909900000000001 AND p.idx='web.nodes.selected'
require_once() -> init_nodes() -> get_viewed_nodes() -> get_node_profile() -> DBselect()

SQL (0.001767): SELECT p.* FROM profiles p WHERE p.userid=9909900000000001 AND p.profileid BETWEEN 9900000000000000 AND 9999999999999999 ORDER BY p.userid,p.profileid
require_once() -> init_nodes() -> get_viewed_nodes() -> CProfile::get() -> CProfile::init() -> DBselect()

SQL (0.001167): SELECT n.masterid FROM nodes n WHERE n.nodeid=99
require_once() -> init_nodes() -> DBselect()

SQL (0.001581): SELECT c.* FROM config c WHERE c.configid BETWEEN 9900000000000000 AND 9999999999999999
require_once() -> select_config() -> DBselect()

SQL (0.001314): SELECT uh.title1,uh.url1,uh.title2,uh.url2,uh.title3,uh.url3,uh.title4,uh.url4,uh.title5,uh.url5 FROM user_history uh WHERE uh.userid=9909900000000001
require_once() -> get_user_history() -> DBselect()

SQL (0.000941): begin
CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.001592): commit
CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.000791): begin
CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.001661): SELECT g.graphid FROM graphs g WHERE g.graphid='9909900000000455' AND g.flags='0'
CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraph->get() -> DBselect()

SQL (0.000651): commit
CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.000543): begin
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.000489): commit
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.000664): begin
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.001301): SELECT g.* FROM graphs g WHERE g.graphid='9909900000000455' AND g.flags IN ('0','4')
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraph->get() -> DBselect()

SQL (0.00213): SELECT DISTINCT gi.*,gi.graphid FROM graphs_items gi,graphs g WHERE gi.gitemid BETWEEN 9900000000000000 AND 9999999999999999 AND gi.graphid=g.graphid AND g.graphid='9909900000000455'
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraph->get() -> CGraphItem->get() -> DBselect()

SQL (0.001584): SELECT t.graphid,t.name FROM graphs t WHERE t.graphid='9909900000000455'
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraph->checkInput() -> CGraphGeneral->checkInput() -> CZBXAPI->extendObjects() -> CZBXAPI->select() -> DBselect()

SQL (0.002191): SELECT DISTINCT h.hostid FROM hosts h,items i WHERE i.itemid IN ('9909900000022830','9909900000022828') AND h.hostid=i.hostid AND h.status IN (0,1,3)
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraph->checkInput() -> CGraphGeneral->checkInput() -> CHost->get() -> DBselect()

SQL (0.002648): SELECT DISTINCT g.graphid FROM graphs g,graphs_items gi,items i WHERE i.hostid='9909900000010073' AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.name='MySQL bandwidth1' LIMIT 1 OFFSET 0
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraph->checkInput() -> CGraphGeneral->checkInput() -> CGraph->get() -> DBselect()

SQL (0.002466): SELECT DISTINCT h.*,i.itemid FROM hosts h,items i WHERE i.itemid IN ('9909900000022830','9909900000022828') AND h.hostid=i.hostid AND h.status IN (0,1,3)
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CHost->get() -> DBselect()

SQL (0.002476): UPDATE graphs SET name='MySQL bandwidth1', width='900', height='200', ymin_type='0', ymax_type='0', yaxismin='0.0000', yaxismax='100.0000', ymin_itemid=NULL, ymax_itemid=NULL, show_work_period='1', show_triggers='1', graphtype='0', show_legend='1', show_3d='0', percent_left='0', percent_right='0', graphid='9909900000000455' WHERE graphid='9909900000000455'
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraphGeneral->updateReal() -> DB::updateByPk() -> DB::update() -> DBexecute()

SQL (0.0025): UPDATE graphs_items SET gitemid='9909900000001488', graphid='9909900000000456', itemid='9909900000022830', sortorder='0', type='0', calc_fnc='2', drawtype='5', yaxisside='0', color='00AA00' WHERE gitemid='9909900000001488'
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraphGeneral->updateReal() -> DB::updateByPk() -> DB::update() -> DBexecute()

SQL (0.000927): DELETE FROM graphs_items WHERE gitemid='9909900000001487'
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraphGeneral->updateReal() -> DB::delete() -> DBexecute()

SQL (0.001902): SELECT DISTINCT h.hostid FROM hosts h,items i WHERE h.status=3 AND i.itemid IN ('9909900000022830','9909900000022828') AND h.hostid=i.hostid AND i.itemid BETWEEN 9900000000000000 AND 9999999999999999
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraph->inherit() -> CTemplate->get() -> DBselect()

SQL (0.001875): SELECT DISTINCT h.hostid,h.host,ht.templateid FROM hosts h,hosts_templates ht WHERE ht.templateid='9909900000010073' AND h.hostid=ht.hostid AND h.status IN (0,1,3)
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraph->inherit() -> CHost->get() -> DBselect()

SQL (0.004993): SELECT g.* FROM graphs g WHERE g.graphid='9909900000000455' AND g.flags IN ('0','4')
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraph->inherit() -> CGraph->get() -> DBselect()

SQL (0.00214): SELECT DISTINCT gi.*,gi.graphid FROM graphs_items gi,graphs g WHERE gi.gitemid BETWEEN 9900000000000000 AND 9999999999999999 AND gi.graphid=g.graphid AND g.graphid='9909900000000455'
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraph->inherit() -> CGraph->get() -> CGraphItem->get() -> DBselect()

SQL (0.004009): SELECT DISTINCT i.*,gi.graphid FROM items i,graphs_items gi WHERE i.flags IN (0,4) AND gi.graphid='9909900000000455' AND i.itemid=gi.itemid
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CGraphGeneral->update() -> CGraph->inherit() -> CGraph->get() -> CItem->get() -> DBselect()

SQL (0.011691): rollback
CAPIObject->update() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBrollback() -> DBexecute()

SQL (0.000754): begin
CPageFilter->__construct() -> CPageFilter->_initGroups() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.0016): commit
CPageFilter->__construct() -> CPageFilter->_initGroups() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.000649): begin
CPageFilter->__construct() -> CPageFilter->_initGroups() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.012818): SELECT DISTINCT g.groupid,g.name FROM groups g,hosts_groups hg,hosts h WHERE hg.groupid=g.groupid AND h.hostid=hg.hostid AND h.status NOT IN (5,6) AND g.groupid BETWEEN 9900000000000000 AND 9999999999999999
CPageFilter->__construct() -> CPageFilter->_initGroups() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHostGroup->get() -> DBselect()

SQL (0.000539): commit
CPageFilter->__construct() -> CPageFilter->_initGroups() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.000438): begin
CPageFilter->__construct() -> CPageFilter->_initHosts() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.000462): commit
CPageFilter->__construct() -> CPageFilter->_initHosts() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.00048): begin
CPageFilter->__construct() -> CPageFilter->_initHosts() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.001932): SELECT h.hostid,h.name FROM hosts h WHERE h.status IN (0,1,3) AND h.hostid BETWEEN 9900000000000000 AND 9999999999999999
CPageFilter->__construct() -> CPageFilter->_initHosts() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> DBselect()

SQL (0.000664): commit
CPageFilter->__construct() -> CPageFilter->_initHosts() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.001269): SELECT h.status FROM hosts h WHERE h.hostid=9909900000010073
isTemplate() -> DBselect()

SQL (0.000513): begin
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.000417): commit
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.000636): begin
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.001896): SELECT h.* FROM hosts h WHERE h.hostid='9909900000010073' AND h.status IN (0,1,3)
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> DBselect()

SQL (0.004437): SELECT COUNT(DISTINCT i.itemid) AS rowscount,i.hostid FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid='9909900000010073' GROUP BY i.hostid
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> CItem->get() -> DBselect()

SQL (0.002804): SELECT count(DISTINCT i.itemid) as rowscount,i.hostid FROM items i WHERE i.itemid BETWEEN 9900000000000000 AND 9999999999999999 AND i.flags=1 AND i.hostid='9909900000010073' GROUP BY i.hostid
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> CDiscoveryRule->get() -> DBselect()

SQL (0.001605): SELECT DISTINCT COUNT(DISTINCT t.triggerid) as rowscount,i.hostid FROM triggers t,functions f,items i WHERE i.hostid='9909900000010073' AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN ('0','4') GROUP BY i.hostid
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> CTrigger->get() -> DBselect()

SQL (0.002578): SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE i.hostid='9909900000010073' AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN ('0','4') GROUP BY i.hostid
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> CGraph->get() -> DBselect()

SQL (0.002066): SELECT count(DISTINCT a.applicationid) as rowscount,a.hostid FROM applications a WHERE a.applicationid BETWEEN 9900000000000000 AND 9999999999999999 AND a.hostid='9909900000010073' GROUP BY a.hostid
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> CApplication->get() -> DBselect()

SQL (0.001117): SELECT ht.* FROM hosts_templates ht WHERE hostid='9909900000010073'
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> CTemplateScreen->get() -> DBselect()

SQL (0.004293): SELECT count(DISTINCT s.screenid) as rowscount,s.templateid FROM screens s WHERE s.screenid BETWEEN 9900000000000000 AND 9999999999999999 AND s.templateid IS NOT NULL AND s.templateid='9909900000010073' GROUP BY s.templateid
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CHost->get() -> CTemplateScreen->get() -> DBselect()

SQL (0.000801): commit
CView->render() -> include() -> get_header_host_table() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.001591): SELECT i.itemid,h.* FROM hosts h,items i WHERE i.hostid=h.hostid AND i.itemid='9909900000022830'
CView->render() -> include() -> get_host_by_itemid() -> DBselect()

SQL (0.001556): SELECT i.* FROM items i WHERE i.itemid=9909900000022830
CView->render() -> include() -> get_item_by_itemid() -> DBselect()

SQL (0.001998): SELECT i.itemid,h.* FROM hosts h,items i WHERE i.hostid=h.hostid AND i.itemid='9909900000022828'
CView->render() -> include() -> get_host_by_itemid() -> DBselect()

SQL (0.00267): SELECT i.* FROM items i WHERE i.itemid=9909900000022828
CView->render() -> include() -> get_item_by_itemid() -> DBselect()

SQL (0.001405): SELECT uh.title5,uh.url5 FROM user_history uh WHERE uh.userid=9909900000000001
require_once() -> add_user_history() -> DBselect()