Original Submission As tracker administrator, have a selectbox bound to many statics values
Slow query
SELECT IF(v.original_value_id, v.original_value_id, v.id) AS id
FROM tracker_field_list_bind_static_value AS v
INNER JOIN tracker_changeset_value_list AS cvl ON (v.id = cvl.bindvalue_id)
INNER JOIN tracker_changeset_value AS cv ON (cv.id = cvl.changeset_value_id AND cv.field_id = v.field_id)
WHERE v.field_id = ?
UNION SELECT v.id AS id
FROM tracker_field_list_bind_static_value AS v
INNER JOIN tracker_changeset_value_openlist AS cvl ON (v.id = cvl.bindvalue_id)
INNER JOIN tracker_changeset_value AS cv ON (cv.id = cvl.changeset_value_id AND cv.field_id = v.field_id)
WHERE cv.field_id = ?
UNION
SELECT tracker_workflow_trigger_rule_static_value.value_id
FROM tracker_workflow_trigger_rule_static_value
WHERE tracker_workflow_trigger_rule_static_value.value_id = ?
UNION
SELECT tracker_workflow_trigger_rule_trg_field_static_value.value_id
FROM tracker_workflow_trigger_rule_trg_field_static_value
WHERE tracker_workflow_trigger_rule_trg_field_static_value.value_id = ?;
Associate handler:
Handler_read_first 1
Handler_read_key 7
Handler_read_last 0
Handler_read_next 213