******************** Профилировщик сценария ********************
Всего затрачено времени: 0.055222
Всего затрачено времени на SQL: 0.010021
SQL запросов: 22 (selects: 15 | executes: 7)
Пиковое использование памяти: 3.75M
Лимит памяти: 128M

1. trigger.get [CControllerProblemView.php:197]

Параметры:
Array
(
    [output] => Array
        (
            [0] => triggerid
            [1] => description
        )

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

    [expandDescription] => 1
    [triggerids] => Array
        (
            [0] => 12201
        )

    [monitored] => 1
)
Результат:
Array
(
    [0] => Array
        (
            [triggerid] => 12201
            [description] => icmpOutRedirects on *НЕИЗВЕСТНО* is too High
            [hosts] => Array
                (
                )

        )

)

2. problem.get [CScreenProblem.php:180]

Параметры:
Array
(
    [output] => Array
        (
            [0] => eventid
            [1] => objectid
            [2] => clock
            [3] => ns
        )

    [source] => 0
    [object] => 0
    [recent] => 1
    [groupids] =>
    [hostids] =>
    [applicationids] =>
    [objectids] => Array
        (
            [0] => 12201
        )

    [eventid_till] =>
    [sortfield] => Array
        (
            [0] => eventid
        )

    [sortorder] => DESC
    [limit] => 1001
    [preservekeys] => 1
)
Результат:
Array
(
)


SQL (0.000261): SET NAMES utf8
zabbix.php:21 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DBexecute() in include/db.inc.php:63

SQL (0.000575): SHOW TABLES LIKE 'dbversion'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->initDB() → DBconnect() → DbBackend->checkDbVersion() → MysqlDbBackend->checkDbVersionTable() → DBselect() in include/classes/db/MysqlDbBackend.php:32

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

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

SQL (0.00032): BEGIN
zabbix.php:21 → 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:262

SQL (0.00048): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='8c46837add3c1a5665436c62f1a51a03' AND s.status=0 AND s.userid=u.userid AND (s.lastaccess+u.autologout>1485165498 OR u.autologout=0)
zabbix.php:21 → 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() → DBselect() in include/classes/api/services/CUser.php:1196

SQL (0.000227): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid='20' AND g.usrgrpid=ug.usrgrpid
zabbix.php:21 → 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() → DBselect() in include/classes/api/services/CUser.php:1229

SQL (0.000263): 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='20'
zabbix.php:21 → 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->_getUserData() → DBselect() in include/classes/api/services/CUser.php:1253

SQL (0.000207): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid='20' AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1
zabbix.php:21 → 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->_getUserData() → DBselect() in include/classes/api/services/CUser.php:1261

SQL (0.000195): COMMIT
zabbix.php:21 → 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:323

SQL (0.002024): SELECT p.* FROM profiles p WHERE p.userid=20 ORDER BY p.userid,p.profileid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:42

SQL (0.00047): SELECT c.* FROM config c
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → select_config() → DBselect() in include/profiles.inc.php:33

SQL (0.000302): BEGIN
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:262

SQL (0.000733): SELECT   t.triggerid,t.description,t.expression FROM triggers t WHERE t.triggerid='12201' AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1026

SQL (0.000245): SELECT f.triggerid,i.hostid FROM functions f,items i WHERE f.triggerid='12201' AND f.itemid=i.itemid
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → DBselect() in include/classes/api/services/CTriggerGeneral.php:368

SQL (0.00034): SELECT   h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND 1=0 AND h.status IN (0,1,3)
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CTrigger->addRelatedObjects() → CTriggerGeneral->addRelatedObjects() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:432

SQL (0.000542): SELECT f.triggerid,f.functionid,h.hostid,h.host,h.name FROM functions f JOIN items i ON f.itemid=i.itemid JOIN hosts h ON i.hostid=h.hostid WHERE f.functionid='11201'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CTrigger->get() → CMacrosResolverHelper::resolveTriggerNames() → CMacrosResolver->resolveTriggerNames() → CMacrosResolverGeneral->getHostMacros() → DBselect() in include/classes/macros/CMacrosResolverGeneral.php:777

SQL (0.000344): COMMIT
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:323

SQL (0.000439): BEGIN
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem->getData() → CScreenProblem->getDataProblems() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:262

SQL (0.000459): SELECT   t.triggerid FROM triggers t WHERE t.triggerid='12201' AND t.flags IN ('0','4')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem->getData() → CScreenProblem->getDataProblems() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CProblem->get() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1026

SQL (0.000593): SELECT   p.eventid,p.objectid,p.clock,p.ns FROM problem p WHERE p.source='0' AND p.object='0' AND p.objectid='12201' AND (p.r_eventid IS NULL OR p.r_clock>1485163698) ORDER BY p.eventid DESC LIMIT 1001 OFFSET 0
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem->getData() → CScreenProblem->getDataProblems() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CProblem->get() → DBselect() in include/classes/api/services/CProblem.php:351

SQL (0.000423): COMMIT
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem->getData() → CScreenProblem->getDataProblems() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:323