弯道起跑的技巧

页面:/news/view-2556584/ | 耗时:0.2485 s | 内存:1.89 MB | 查询:5 | 缓存读取:4 写入:1 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2556584 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2556584 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2556584 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(96105,890867,607116,607196,815778,847219,782863,853244,597658,641149,835564,411137,826737,1999222,762489,706423,2765795,454544,883276,3473623,627292,840775,700666,412982,2460660,1165635,680654,730272,483312,730526) ORDER BY field (ArticleID,96105,890867,607116,607196,815778,847219,782863,853244,597658,641149,835564,411137,826737,1999222,762489,706423,2765795,454544,883276,3473623,627292,840775,700666,412982,2460660,1165635,680654,730272,483312,730526)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90024 ORDER BY ArticleID DESC LIMIT 20