钓雅鱼的方法和技巧

页面:/news/view-395974/ | 耗时:0.7467 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=395974 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=395974 LIMIT 0,1
select * from tbl_Articles_sphinx where id=395974 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1119646,1100693,1117872,1111928,1065409,1078196,1108205,1092974,1057623,1127393,1064171,1073714,1107070,1017717,1092223,1106402,1108624,1073892,1112386,1112959,1121316,1123897,1299616,1098167,1123122,1108678,1072184,1108842,1501591,1077154) ORDER BY field (ArticleID,1119646,1100693,1117872,1111928,1065409,1078196,1108205,1092974,1057623,1127393,1064171,1073714,1107070,1017717,1092223,1106402,1108624,1073892,1112386,1112959,1121316,1123897,1299616,1098167,1123122,1108678,1072184,1108842,1501591,1077154)