两个节水小技巧

页面:/news/view-3492331/ | 耗时:0.4582 s | 内存:1.89 MB | 查询:5 | 缓存读取:4 写入:1 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3492331 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3492331 LIMIT 0,1
SELECT * FROM tbl_categories where CategoryID=90007 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3492331 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1116825,785997,1275377,802256,746779,1757351,1045507,1204247,1066264,376390,1132107,827439,748943,1077254,1544051,455963,510339,723218,1082307,747507,401438,402535,940474,543686,1507323,1056172,1174122,558635,392401,820373) ORDER BY field (ArticleID,1116825,785997,1275377,802256,746779,1757351,1045507,1204247,1066264,376390,1132107,827439,748943,1077254,1544051,455963,510339,723218,1082307,747507,401438,402535,940474,543686,1507323,1056172,1174122,558635,392401,820373)