去鱼鳞的好方法

页面:/news/view-2738686/ | 耗时:0.7050 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2738686 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2738686 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2738686 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1068562,1122855,1114872,1119808,1118935,1103031,1120376,1101477,1071667,1123356,1113690,1120322,1108047,1070010,1043963,1106090,1121192,1105331,1072433,1108359,1056892,1115843,1113199,1087789,1077326,1122869,1105673,1098885,1117830,1119454) ORDER BY field (ArticleID,1068562,1122855,1114872,1119808,1118935,1103031,1120376,1101477,1071667,1123356,1113690,1120322,1108047,1070010,1043963,1106090,1121192,1105331,1072433,1108359,1056892,1115843,1113199,1087789,1077326,1122869,1105673,1098885,1117830,1119454)