******************** Script profiler ********************
Total time: 0.02076
Total SQL time: 0.017205
SQL count: 21 (selects: 19 | executes: 11)
Peak memory usage: 4M
Memory limit: 512M

1. item.get [history.php:82]

Parameters:
Array
(
    [output] => Array
        (
            [0] => itemid
            [1] => key_
            [2] => name
            [3] => value_type
            [4] => hostid
            [5] => valuemapid
            [6] => history
            [7] => trends
        )

    [selectHosts] => Array
        (
            [0] => name
        )

    [itemids] => Array
        (
            [0] => 91191
        )

    [preservekeys] => 1
    [templated] => 
    [webitems] => 1
)
Result:
Array
(
    [91191] => Array
        (
            [itemid] => 91191
            [key_] => mongodb.status[connections,available]
            [name] => MongoDB Connections available
            [value_type] => 3
            [hostid] => 10603
            [valuemapid] => 0
            [history] => 90d
            [trends] => 365d
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10603
                            [name] => capl-attrib01
                        )

                )

        )

)

2. item.get [CScreenHistory.php:131]

Parameters:
Array
(
    [output] => Array
        (
            [0] => itemid
            [1] => hostid
            [2] => name
            [3] => key_
            [4] => value_type
            [5] => valuemapid
            [6] => history
            [7] => trends
        )

    [selectHosts] => Array
        (
            [0] => name
        )

    [itemids] => Array
        (
            [0] => 91191
        )

    [webitems] => 1
    [preservekeys] => 1
)
Result:
Array
(
    [91191] => Array
        (
            [itemid] => 91191
            [hostid] => 10603
            [name] => MongoDB Connections available
            [key_] => mongodb.status[connections,available]
            [value_type] => 3
            [valuemapid] => 0
            [history] => 90d
            [trends] => 365d
            [hosts] => Array
                (
                    [0] => Array
                        (
                            [hostid] => 10603
                            [name] => capl-attrib01
                        )

                )

        )

)


SQL (0.00256): COMMIT
history.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.000287): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.layout.mode'
history.php:32 → CView::getLayoutMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000264): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.menu.view.last'
history.php:39 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000178): SELECT c.* FROM config c
history.php:39 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33

SQL (0.000114): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.login.attempt.failed'
history.php:39 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.00044): BEGIN
history.php:82 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000303): SELECT DISTINCT i.itemid,i.key_,i.name,i.value_type,i.hostid,i.valuemapid,i.history,i.trends FROM items i,hosts h WHERE i.flags IN (0,4) AND i.itemid=91191 AND h.hostid=i.hostid AND h.status<>3
history.php:82 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:364

SQL (0.000209): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10603 AND h.status IN (0,1,3)
history.php:82 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → CItem->addRelatedObjects() → CItemGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:429

SQL (0.000818): COMMIT
history.php:82 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.00022): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.item.graph.filter.active'
history.php:114 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.00082): SELECT p.value_id,p.source FROM profiles p WHERE p.userid=3 AND p.idx='web.favorite.graphids' ORDER BY p.profileid
history.php:130 → CView->render() → include() → get_icon() → CFavorite::exists() → CFavorite::get() → DBselect() in include/classes/user/CFavorite.php:55

SQL (0.002114): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.item.graph.filter.from'
history.php:130 → CView->render() → include() → CScreenBuilder::getScreen() → CScreenHistory->__construct() → CScreenBase->__construct() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.001937): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.item.graph.filter.to'
history.php:130 → CView->render() → include() → CScreenBuilder::getScreen() → CScreenHistory->__construct() → CScreenBase->__construct() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.00072): BEGIN
history.php:130 → CView->render() → include() → CScreenHistory->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000249): SELECT i.itemid,i.hostid,i.name,i.key_,i.value_type,i.valuemapid,i.history,i.trends FROM items i WHERE i.flags IN (0,4) AND i.itemid=91191
history.php:130 → CView->render() → include() → CScreenHistory->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() in include/classes/api/services/CItem.php:364

SQL (0.000105): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND h.hostid=10603 AND h.status IN (0,1,3)
history.php:130 → CView->render() → include() → CScreenHistory->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → CItem->addRelatedObjects() → CItemGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:429

SQL (0.000679): COMMIT
history.php:130 → CView->render() → include() → CScreenHistory->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000114): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=3 AND idx='web.paging.lastpage'
history.php:133 → require_once() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000546): BEGIN
history.php:133 → require_once() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.00122): UPDATE profiles SET value_str='history.php', type=3 WHERE userid=3 AND idx='web.paging.lastpage' AND idx2='0'
history.php:133 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338

SQL (0.003308): COMMIT
history.php:133 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291