游标卡尺原理

页面:/news/view-1243327/ | 耗时:0.5081 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1243327 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1243327 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1243327 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1093369,98248,1013389,1103333,2819133,1229551,3175331,941532,1237283,1105435,1238255,1627671,1116389,1236778,2552829,1226176,2121920,1232491,1099787,98811,1084747,1175746,2483036,1255533,3098468,1243327,99066,1223453,2470702,1281388) ORDER BY field (ArticleID,1093369,98248,1013389,1103333,2819133,1229551,3175331,941532,1237283,1105435,1238255,1627671,1116389,1236778,2552829,1226176,2121920,1232491,1099787,98811,1084747,1175746,2483036,1255533,3098468,1243327,99066,1223453,2470702,1281388)