笔试答题的技巧

页面:/news/view-631599/ | 耗时:0.9264 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=631599 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=631599 LIMIT 0,1
select * from tbl_Articles_sphinx where id=631599 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(86861,1108211,1171068,937198,1091009,3105763,699741,3449373,2094279,998343,358539,422090,994099,100771,1093961,85991,1725019,1072287,85995,100672,1166268,797681,1102675,3298384,2002502,3093950,526956,2452902,101051,1806007) ORDER BY field (ArticleID,86861,1108211,1171068,937198,1091009,3105763,699741,3449373,2094279,998343,358539,422090,994099,100771,1093961,85991,1725019,1072287,85995,100672,1166268,797681,1102675,3298384,2002502,3093950,526956,2452902,101051,1806007)