一年级补砖题技巧

页面:/news/view-2012845/ | 耗时:0.9113 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2012845 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2012845 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2012845 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1725019,370947,1092081,362063,378272,1896741,3137682,1105669,1205263,440649,1096981,1089036,1216670,1110245,750356,1044965,1029055,631443,3181934,1108962,406777,1999104,3456547,1106674,3491192,1094597,407334,407186,369153,1711588) ORDER BY field (ArticleID,1725019,370947,1092081,362063,378272,1896741,3137682,1105669,1205263,440649,1096981,1089036,1216670,1110245,750356,1044965,1029055,631443,3181934,1108962,406777,1999104,3456547,1106674,3491192,1094597,407334,407186,369153,1711588)