拼魔方的两种方法

页面:/news/view-700045/ | 耗时:1.0031 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=700045 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=700045 LIMIT 0,1
select * from tbl_Articles_sphinx where id=700045 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1118447,1064403,1117544,1107364,1123951,1103943,1110776,1070010,1087789,1066580,1111198,1123723,1106529,1115935,1131341,1108740,1114004,1121118,1127785,1122429,1132471,1065371,1063923,1109312,1112863,1065669,1118058,1082938,1103154,1116327) ORDER BY field (ArticleID,1118447,1064403,1117544,1107364,1123951,1103943,1110776,1070010,1087789,1066580,1111198,1123723,1106529,1115935,1131341,1108740,1114004,1121118,1127785,1122429,1132471,1065371,1063923,1109312,1112863,1065669,1118058,1082938,1103154,1116327)