The next query is very slow:

SQL (45.793777): SELECT DISTINCT s.*,hg.hostid FROM scripts s,hosts_groups hg
WHERE (hg.groupid IN (17,20,113,9,8,41,18,16,10,13,73,14,11,15,12,7,19,6,51,22,4)
AND hg.groupid=s.groupid) OR (s.groupid IS NULL AND scriptid BETWEEN 000000000000000 AND 099999999999999)
ORDER BY s.name
make_latest_issues() > CAPIObject>getScriptsByHosts() -> CAPIObject
->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func()
> CScript>getScriptsByHosts() > CScript>get() -> DBselect()

Look comment.