贴出 explain select .... 及 show index from ... 以供分析。
试试这个 SELECT * FROM t_pj_schedulelx s inner join ( SELECT id FROM t_pj_schedulelx WHERE (state='6' OR state='11' OR state='15') AND (source_type='15' OR source_type='16') GROUP BY source_id,source_type HAVING COUNT(id) > 1 ) t on s.id = t.id WHERE ((OWNER = '8a8a8aed46d609e10146d612d37e0004' AND s.state = '6' AND s.update_Time IS NOT NULL) OR (s.state='11' AND s.update_Time IS NOT NULL) OR (s.state='15' AND s.update_Time IS NOT NULL)) AND s.create_Time >= '2014-10-26 00:00:00' AND s.create_Time <= '2014-11-02 23:59:59' ORDER BY s.classes, s.project_Num+0 ASC;
及 show index from ...
以供分析。
SELECT * FROM t_pj_schedulelx s
inner join (
SELECT id FROM t_pj_schedulelx
WHERE (state='6' OR state='11' OR state='15')
AND (source_type='15' OR source_type='16')
GROUP BY source_id,source_type HAVING COUNT(id) > 1
) t
on s.id = t.id
WHERE ((OWNER = '8a8a8aed46d609e10146d612d37e0004' AND s.state = '6' AND s.update_Time IS NOT NULL)
OR (s.state='11' AND s.update_Time IS NOT NULL)
OR (s.state='15' AND s.update_Time IS NOT NULL))
AND s.create_Time >= '2014-10-26 00:00:00' AND s.create_Time <= '2014-11-02 23:59:59'
ORDER BY s.classes, s.project_Num+0 ASC;