点读机原理

页面:/news/view-1257469/ | 耗时:0.3186 s | 内存:1.89 MB | 查询:5 | 缓存读取:4 写入:1 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1257469 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1257469 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1257469 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1123151,938679,852017,1232491,2553037,1123335,3492579,2644802,3196366,1237283,2271374,1029388,705012,1100219,1187723,1097075,1117235,1204041,1191780,1255533,1009665,1103016,3518430,3450338,789667,1102923,1687742,2607788,2704555,1098835) ORDER BY field (ArticleID,1123151,938679,852017,1232491,2553037,1123335,3492579,2644802,3196366,1237283,2271374,1029388,705012,1100219,1187723,1097075,1117235,1204041,1191780,1255533,1009665,1103016,3518430,3450338,789667,1102923,1687742,2607788,2704555,1098835)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90004 ORDER BY ArticleID DESC LIMIT 20