SQL (157.802031): SELECT t.triggerid,t.lastchange FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='100100000000041' WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY f.triggerid HAVING MIN(r.permission)>=2) 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') AND ((t.value=1) OR ((t.value=0) AND (t.lastchange>1372322468))) AND t.triggerid BETWEEN 100000000000000 AND 199999999999999
CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CTrigger->get() -> DBselect()

______ Sub-Part 1 ______  ____________ Sub-Part 2 ____________  _________ Sub-Part 2 __________
Select Type: PRIMARY      Select Type: DEPENDENT SUBQUERY       Select Type: DEPENDENT SUBQUERY
      Table: t                  Table: f                              Table: i
 Partitions:               Partitions:                           Partitions:
       Type: range               Type: ref                             Type: eq_ref
 Poss. Keys: PRIMARY       Poss. Keys: functions_1,functions_2   Poss. Keys: PRIMARY,items_1
      Index: PRIMARY            Index: functions_1                    Index: PRIMARY
 Key Length: 8             Key Length: 8                         Key Length: 8
  Index Ref:                Index Ref: zabbix.t.triggerid         Index Ref: zabbix.f.itemid
  Row Count: 289498         Row Count: 1                          Row Count: 1
    Special: Using where      Special: Using where                  Special:

_______________ Sub-Part 2 _______________  _________ Sub-Part 2 __________
Select Type: DEPENDENT SUBQUERY             Select Type: DEPENDENT SUBQUERY
      Table: hgg                                  Table: r
 Partitions:                                 Partitions:
       Type: ref                                   Type: ref
 Poss. Keys: hosts_groups_1,hosts_groups_2   Poss. Keys: rights_1,rights_2
      Index: hosts_groups_1                       Index: rights_2
 Key Length: 8                               Key Length: 8
  Index Ref: zabbix.i.hostid                  Index Ref: zabbix.hgg.groupid
  Row Count: 1                                Row Count: 1
    Special: Using index                        Special: Using where

alter table triggers drop index triggers_2, add index triggers_2(value,lastchange);