32107:20151117:175309.124 slow query: 0.155889 sec, "select i.itemid,i.hostid,i.status,i.type,i.data_type,i.va lue_type,i.key_,i.snmp_community,i.snmp_oid,i.port ,i.snmpv3_securityname,i.snmpv3_securitylevel,i.sn mpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi _sensor,i.delay,i.delay_flex,i.trapper_hosts,i.log timefmt,i.params,i.state,i.authtype,i.username,i.p assword,i.publickey,i.privatekey,i.flags,i.interfa ceid,i.snmpv3_authprotocol,i.snmpv3_privprotocol,i .snmpv3_contextname,i.lastlogsize,i.mtime,i.delta, i.multiplier,i.formula,i.history,i.trends,i.invent ory_link,i.valuemapid,i.units,i.error from items i,hosts h where i.hostid=h.hostid and h.status in (0,1) and i.flags<>2"
32107:20151117:175309.459 slow query: 0.334838 sec, "select distinct t.triggerid,t.description,t.expression,t.error,t.p riority,t.type,t.value,t.state,t.lastchange,t.stat us from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0,1) and t.flags<>2"
32107:20151117:175309.459 slow query: 0.334838 sec, "select distinct t.triggerid,t.description,t.expression,t.error,t.p riority,t.type,t.value,t.state,t.lastchange,t.stat us from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0,1) and t.flags<>2"
Comment