快速去鱼鳞最有效的方法

页面:/news/view-657964/ | 耗时:0.4291 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=657964 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=657964 LIMIT 0,1
select * from tbl_Articles_sphinx where id=657964 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1117209,1064363,1108930,1113676,1111830,1130840,1098307,1103668,1113433,1117069,1123104,1049284,1045464,1115436,1098587,1082369,1043830,1114596,1122879,1088558,1073786,1107190,1123613,1113976,1099189,1104827,1131897,1123364,1078334,1123683) ORDER BY field (ArticleID,1117209,1064363,1108930,1113676,1111830,1130840,1098307,1103668,1113433,1117069,1123104,1049284,1045464,1115436,1098587,1082369,1043830,1114596,1122879,1088558,1073786,1107190,1123613,1113976,1099189,1104827,1131897,1123364,1078334,1123683)