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
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
转载于:https://www.cnblogs.com/adtuu/p/6365768.html