拔河有啥小技巧

页面:/news/view-3225442/ | 耗时:0.6543 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3225442 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3225442 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3225442 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1070752,1123855,1131905,1127641,1275371,1116709,1132603,1116201,1079542,1063731,1103827,1110758,1275232,1092329,1107281,1086828,1132405,1088510,1056310,1099189,1129385,1104085,1123215,1120165,1073708,1128273,1087861,1071313,1048508,1078146) ORDER BY field (ArticleID,1070752,1123855,1131905,1127641,1275371,1116709,1132603,1116201,1079542,1063731,1103827,1110758,1275232,1092329,1107281,1086828,1132405,1088510,1056310,1099189,1129385,1104085,1123215,1120165,1073708,1128273,1087861,1071313,1048508,1078146)