刨胡萝卜技巧

页面:/news/view-1210404/ | 耗时:0.5255 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1210404 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1210404 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1210404 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1140333,1523943,1158100,482080,1056743,898186,1160657,671467,904756,495131,1431216,1143287,599675,745095,506244,1148185,895172,696305,449257,585670,761215,1086537,1216706,867135,998735,1198570,1125322,357981,568153,743293) ORDER BY field (ArticleID,1140333,1523943,1158100,482080,1056743,898186,1160657,671467,904756,495131,1431216,1143287,599675,745095,506244,1148185,895172,696305,449257,585670,761215,1086537,1216706,867135,998735,1198570,1125322,357981,568153,743293)