Problems

******************** Script profiler ********************
Total time: 0.048193
Total SQL time: 0.033018
SQL count: 46 (selects: 42 | executes: 13)
Peak memory usage: 4M
Memory limit: 128M

1. host.get [CScreenProblem.php:228]

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

    [groupids] => 
    [hostids] => 
    [preservekeys] => 1
    [searchInventory] => Array
        (
            [name] => Array
                (
                    [0] => a
                )

        )

)
Result:
Array
(
)

2. event.get [CScreenProblem.php:102]

Parameters:
Array
(
    [output] => Array
        (
            [0] => eventid
            [1] => objectid
            [2] => clock
            [3] => ns
            [4] => name
            [5] => severity
        )

    [source] => 0
    [object] => 0
    [value] => 1
    [sortfield] => Array
        (
            [0] => eventid
        )

    [sortorder] => DESC
    [preservekeys] => 1
    [groupids] => 
    [hostids] => Array
        (
        )

    [applicationids] => 
    [objectids] => 
    [eventid_till] => 
    [suppressed] => 
    [limit] => 1001
    [time_from] => 1786412962
    [time_till] => 1786416562
    [evaltype] => 0
)
Result:
Array
(
)


SQL (0.00037): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:107

SQL (0.000504): UPDATE ids SET nextid=2489474 WHERE table_name='auditlog' AND field_name='auditid'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:121

SQL (0.000295): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1786416562','216.73.216.248','3','0','','2489474')
zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DBexecute() in include/classes/db/DB.php:467

SQL (0.008084): COMMIT
zabbix.php:21 → 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.000642): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.sort'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000515): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.sortorder'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000473): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.active'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.00044): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.groupids'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000395): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.hostids'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000313): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.triggerids'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000491): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.inventory.field'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000494): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.inventory.value'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000426): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.tags.tag'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::getArray() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000522): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.show'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000349): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.application'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000312): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.name'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000384): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.severity'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000339): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.age_state'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000315): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.age'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000417): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.evaltype'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000343): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.show_tags'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000358): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.tag_name_format'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000331): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.tag_priority'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.00038): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.show_suppressed'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000441): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.unacknowledged'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000342): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.compact_view'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000466): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.show_timeline'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000408): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.details'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.00042): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.highlight_row'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000397): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.show_latest_values'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000117): BEGIN
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000746): UPDATE profiles SET value_str='ASC', type=3 WHERE userid=2 AND idx='web.problem.sortorder' AND idx2='0'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338

SQL (0.007864): COMMIT
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000394): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.from'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenBuilder::getScreen() → CScreenProblem->__construct() → CScreenBase->__construct() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000263): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.problem.filter.to'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenBuilder::getScreen() → CScreenProblem->__construct() → CScreenBase->__construct() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000602): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.layout.mode'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CView::getLayoutMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

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

SQL (0.000122): SELECT usrgrpid FROM users_groups WHERE userid='2'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:283

SQL (0.000782): SELECT DISTINCT h.hostid FROM hosts h,host_inventory hii 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=8 WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.status IN (0,1) AND h.hostid=hii.hostid AND ( (  UPPER(hii.name)  LIKE '%A%' ESCAPE '!' ) )
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:439

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

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

SQL (0.000115): SELECT tag_filterid,groupid,tag,value FROM tag_filter WHERE usrgrpid=8
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataEvents() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CEvent->get() → CEvent->getEvents() → CEvent::addTagFilterSqlParts() → CEvent::getTagFilters() → DB::select() → DBselect() in include/classes/db/DB.php:900

SQL (0.000782): SELECT DISTINCT e.eventid,e.objectid,e.clock,e.ns,e.name,e.severity FROM events e,functions f,items i WHERE e.source='0' AND e.object='0' AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE e.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<2 OR MIN(permission) IS NULL OR MIN(permission)=0) AND e.objectid=f.triggerid AND f.itemid=i.itemid AND 1=0 AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=e.eventid) AND e.clock>='1786412962' AND e.clock<='1786416562' AND e.value=1 ORDER BY e.eventid DESC LIMIT 1001
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataEvents() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CEvent->get() → CEvent->getEvents() → DBselect() in include/classes/api/services/CEvent.php:478

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

SQL (0.000372): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.menu.view.last'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → local_generateHeader() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000382): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.login.attempt.failed'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → local_generateHeader() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164