面试star原则

页面:/news/view-426803/ | 耗时:0.4460 s | 内存:1.89 MB | 查询:6 | 缓存读取:4 写入:2 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=426803 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=426803 LIMIT 0,1
SELECT * FROM tbl_categories where CategoryID=90010 LIMIT 0,1
select * from tbl_Articles_sphinx where id=426803 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(661554,786916,1134838,510783,2534695,426803,3503362,2152685,477103,1307022,920914,1214837,663682,1740218,1047953,1416852,1039810,2504926,651340,2080868,3210727,3143527,1538439,1510134,411837,819771,3160206,2301773,2924955,2352820) ORDER BY field (ArticleID,661554,786916,1134838,510783,2534695,426803,3503362,2152685,477103,1307022,920914,1214837,663682,1740218,1047953,1416852,1039810,2504926,651340,2080868,3210727,3143527,1538439,1510134,411837,819771,3160206,2301773,2924955,2352820)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90010 ORDER BY ArticleID DESC LIMIT 20