钓活虾的几种方法

页面:/news/view-2891611/ | 耗时:0.1649 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2891611 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2891611 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2891611 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1085701,1501591,1109549,1121860,1120729,1106898,1099749,1103463,1017717,1121920,1106868,1071933,1077154,1106132,1090881,1109170,1103879,1100693,1070576,1103436,1103670,1093825,1118168,1099201,1119762,1066580,1078334,1109503,1114500,1105673) ORDER BY field (ArticleID,1085701,1501591,1109549,1121860,1120729,1106898,1099749,1103463,1017717,1121920,1106868,1071933,1077154,1106132,1090881,1109170,1103879,1100693,1070576,1103436,1103670,1093825,1118168,1099201,1119762,1066580,1078334,1109503,1114500,1105673)