The SQL statement took almost 20 seconds on the demo system:

Time:19.28558 LONG SQL: SELECT e.*,i.hostid FROM events e,functions f,items i WHERE (e.eventid div 100000000000000) in (0) AND (i.hostid IN (10017)) AND f.triggerid=e.objectid AND f.itemid=i.itemid AND e.object=0 AND e.clock>=1234445520 ORDER BY e.clock ASC LIMIT 1001 OFFSET 0