monitoring -> latest data, group selected, all hosts from that group. two sql queries take very long to execute :

Time:19.599714 LONG SQL: SELECT DISTINCT h.host,h.hostid FROM hosts h,hosts_groups hg , items i LEFT JOIN items_applications ia ON ia.itemid=i.itemid WHERE ia.itemid is NULL AND hg.hostid=h.hostid AND hg.groupid=10 AND h.hostid=i.hostid AND h.status=0 AND i.status=0 AND (h.hostid IN (0,10117,10118,10119,10120,10124,10123,10125,10331,10121,10330,10122,10126,10127,10328,10128,10129,10130,10131,10329,10332,10132,10133,10134,10135,10136,10137,10138,10139,10140,10141,10142,10143,10144,10145,10146)) ORDER BY h.host
Time:12.807102 LONG SQL: SELECT DISTINCT h.host,h.hostid,i.* FROM hosts h,hosts_groups hg , items i LEFT JOIN items_applications ia ON ia.itemid=i.itemid WHERE ia.itemid is NULL AND hg.hostid=h.hostid AND hg.groupid=10 AND h.hostid=i.hostid AND h.status=0 AND i.status=0 AND (h.hostid IN (10117,10118,10119,10120,10124,10123,10125,10331,10121,10330,10122,10126,10127,10328,10128,10129,10130,10131,10329,10332,10132,10133,10134,10135,10136,10137,10138,10139,10140,10141,10142,10143,10144,10145,10146)) ORDER BY i.description,i.itemid