插花的基本技巧

页面:/news/view-3456473/ | 耗时:0.0241 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3456473 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3456473 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3456473 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1111086,1042446,1119670,1073453,1047257,1110283,1120719,1126318,1105787,1115410,1060867,1064179,1123020,1095443,1107693,1105217,1089068,1062388,1092996,1122936,1102883,1122042,1126260,1067145,1106571,1124350,1111502,1113670,1112646,1108235) ORDER BY field (ArticleID,1111086,1042446,1119670,1073453,1047257,1110283,1120719,1126318,1105787,1115410,1060867,1064179,1123020,1095443,1107693,1105217,1089068,1062388,1092996,1122936,1102883,1122042,1126260,1067145,1106571,1124350,1111502,1113670,1112646,1108235)