除掉蟑螂的快速方法

页面:/news/view-3125944/ | 耗时:0.5702 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3125944 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3125944 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3125944 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1054232,1052119,1098663,1118689,1117169,1127691,1089786,1111984,1132937,1080177,1108678,1061384,1048298,1115525,1117335,1087243,1106028,1043963,1107699,1105673,1122859,1054312,1122954,1074728,1110145,1122893,1118068,1108325,1123376,1093076) ORDER BY field (ArticleID,1054232,1052119,1098663,1118689,1117169,1127691,1089786,1111984,1132937,1080177,1108678,1061384,1048298,1115525,1117335,1087243,1106028,1043963,1107699,1105673,1122859,1054312,1122954,1074728,1110145,1122893,1118068,1108325,1123376,1093076)