穿珠子的小技巧

页面:/news/view-363903/ | 耗时:0.4686 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=363903 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=363903 LIMIT 0,1
select * from tbl_Articles_sphinx where id=363903 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1117069,1054232,1120404,1116956,1116171,1114026,1109487,1121000,1071175,1119554,1084091,1055217,1070010,1113199,1061728,1077611,1116731,1071933,1125050,1096877,1118655,1121400,1123791,1123667,1105878,1094525,1123479,1113191,1117582,1098301) ORDER BY field (ArticleID,1117069,1054232,1120404,1116956,1116171,1114026,1109487,1121000,1071175,1119554,1084091,1055217,1070010,1113199,1061728,1077611,1116731,1071933,1125050,1096877,1118655,1121400,1123791,1123667,1105878,1094525,1123479,1113191,1117582,1098301)