在什么时候用in在什么时候用on在什么时候用at

页面:/news/view-929005/ | 耗时:0.4123 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=929005 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=929005 LIMIT 0,1
select * from tbl_Articles_sphinx where id=929005 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1100923,3338266,620614,505289,837870,435396,559925,1174775,553319,3439095,377693,962289,454410,392005,1121677,405712,2475883,461699,451852,433830,1071297,433418,390219,522235,1066434,851285,1109342,445125,467198,619516) ORDER BY field (ArticleID,1100923,3338266,620614,505289,837870,435396,559925,1174775,553319,3439095,377693,962289,454410,392005,1121677,405712,2475883,461699,451852,433830,1071297,433418,390219,522235,1066434,851285,1109342,445125,467198,619516)