什么时候用on什么时候用in

页面:/news/view-1732334/ | 耗时:0.7322 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1732334 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1732334 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1732334 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(827453,646995,776906,834624,776738,440365,517192,503161,756029,1161935,681196,737308,2303527,866163,864629,663330,649798,690043,722072,81868,567021,526120,753147,743033,88190,766194,560457,695791,402823,1160217) ORDER BY field (ArticleID,827453,646995,776906,834624,776738,440365,517192,503161,756029,1161935,681196,737308,2303527,866163,864629,663330,649798,690043,722072,81868,567021,526120,753147,743033,88190,766194,560457,695791,402823,1160217)