Problems

TimeSeverityRecovery timeStatusInfoHostProblemDurationAckActionsTags
No data found.
Displaying 0 of 0 found
0 selected
******************** Script profiler ********************
Total time: 0.053048
Total SQL time: 0.047131
SQL count: 41 (selects: 40 | executes: 10)
Peak memory usage: 4M
Memory limit: 128M

1. hostgroup.get [hostgroups.inc.php:202]

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

    [groupids] => Array
        (
            [0] => 2
        )

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


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

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

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

    [sortorder] => DESC
    [preservekeys] => 1
    [groupids] => 
    [hostids] => 
    [applicationids] => 
    [objectids] => 
    [eventid_till] => 
    [suppressed] => 
    [limit] => 1001
    [recent] => 1
    [evaltype] => 0
)
Result:
Array
(
)



SQL (0.000321): 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.000323): UPDATE ids SET nextid=2277738 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.00029): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1776044149','216.73.216.101','3','0','','2277738')
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.014455): 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.000527): 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.000446): 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.000335): 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.000388): 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.000324): 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.00036): 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.000143): BEGIN
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → getSubGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000127): SELECT usrgrpid FROM users_groups WHERE userid='2'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → getSubGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:283

SQL (0.00129): SELECT g.groupid,g.name FROM hstgrp g WHERE EXISTS (SELECT NULL FROM rights r WHERE g.groupid=r.id AND r.groupid=8 GROUP BY r.id HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND g.groupid=2
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerProblemView->doAction() → getSubGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:315

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

SQL (0.000389): 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.000359): 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.000328): 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.000514): 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.000318): 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.000258): 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.000259): 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.000291): 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.000254): 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.000266): 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.000342): 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.000281): 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.000259): 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.000272): 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.000362): 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.000253): 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.000273): 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.000271): 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.000274): 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.000185): 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 (9.9E-5): BEGIN
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000485): 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::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → CProblem::addTagFilterSqlParts() → CEvent::getTagFilters() → DB::select() → DBselect() in include/classes/db/DB.php:900

SQL (0.020481): SELECT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity FROM problem p WHERE p.source='0' AND p.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 p.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 NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND (p.r_eventid IS NULL OR p.r_clock>1776043849) ORDER BY p.eventid DESC LIMIT 1001
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem::getData() → CScreenProblem::getDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → DBselect() in include/classes/api/services/CProblem.php:337

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

SQL (9.9E-5): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.paging.lastpage'
zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000199): 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.000193): 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


Debug