SQL (28.896063): SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN (11,414) WHERE t.triggerid=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 i.hostid IN (10499,10500,10706,10710,10712,10726,10732,10734,10737,10739,10741,10743,10745,10747,10749,10752,10755,10757,10761,10763,10767,10769,10771,10779,10781,10783,10785,10963,10964,11117,11141,11241,11274,11279,11336,11607,11608,11895,11900,13274,13275,13278,13279,13602,13679,13686,13759,13944,14105,15948,15951,17739,21624,24410,25645,27034,27036,27495,27769,28740,29578,29579,30394,32598,39814,42765,42822,51187) AND f.triggerid=t.triggerid AND f.itemid=i.itemid 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:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostView->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1136

SQL (50.258577): SELECT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN (11,414) WHERE g.graphid=gi.graphid AND gi.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 i.hostid IN (10499,10500,10706,10710,10712,10726,10732,10734,10737,10739,10741,10743,10745,10747,10749,10752,10755,10757,10761,10763,10767,10769,10771,10779,10781,10783,10785,10963,10964,11117,11141,11241,11274,11279,11336,11607,11608,11895,11900,13274,13275,13278,13279,13602,13679,13686,13759,13944,14105,15948,15951,17739,21624,24410,25645,27034,27036,27495,27769,28740,29578,29579,30394,32598,39814,42765,42822,51187) AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN (0,4) GROUP BY i.hostid
zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostView->doAction() → CControllerHost->getData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CGraph->get() → DBselect() in include/classes/api/services/CGraph.php:264