切萝卜丝小技巧

页面:/news/view-2924366/ | 耗时:0.3050 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2924366 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2924366 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2924366 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(372134,409367,455947,458295,1120950,1101241,1065939,3340089,544486,459896,463573,414582,419479,368571,2628380,423607,408336,440329,379646,392487,1107297,360088,405352,439098,1753034,402069,389073,1035744,444999,85521) ORDER BY field (ArticleID,372134,409367,455947,458295,1120950,1101241,1065939,3340089,544486,459896,463573,414582,419479,368571,2628380,423607,408336,440329,379646,392487,1107297,360088,405352,439098,1753034,402069,389073,1035744,444999,85521)