EXPLAIN SELECT * FROM `tcb_capital_log` WHERE id IN(66,79,47) EXPLAIN SELECT * FROM ( SELECT 66 AS id UNION ALL SELECT 79 AS id UNION ALL SELECT 47 AS id ) AS tmp , tcb_capital_log WHERE tcb_capital_log.id = tmp.id
原文：http://www.cnblogs.com/adtuu/p/6365768.html