做螃蟹最好的方法

页面:/news/view-431705/ | 耗时:0.0873 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=431705 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=431705 LIMIT 0,1
select * from tbl_Articles_sphinx where id=431705 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1096418,1111302,1113540,1102728,1082061,1067547,1104791,1088566,1083574,1090404,1108820,1109959,1103857,1096360,1091673,1062124,1090128,1062574,1104173,1105896,1107096,1101415,1100991,1100869,1119724,1107461,1084491,1110856,1070736,1103921) ORDER BY field (ArticleID,1096418,1111302,1113540,1102728,1082061,1067547,1104791,1088566,1083574,1090404,1108820,1109959,1103857,1096360,1091673,1062124,1090128,1062574,1104173,1105896,1107096,1101415,1100991,1100869,1119724,1107461,1084491,1110856,1070736,1103921)