透视表如何筛选

页面:/news/view-615149/ | 耗时:0.1617 s | 内存:1.89 MB | 查询:5 | 缓存读取:4 写入:1 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=615149 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=615149 LIMIT 0,1
SELECT * FROM tbl_categories where CategoryID=90015 LIMIT 0,1
select * from tbl_Articles_sphinx where id=615149 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(3910473,869833,3509596,2988334,3500277,2734012,1490358,1031202,2011381,556104,1315675,3486471,3780642,2437433,3037690,2106672,1069646,3245362,1821858,759437,489550,598579,3302232,925048,2924399,2035974,3217431,1096345,1623377,860751) ORDER BY field (ArticleID,3910473,869833,3509596,2988334,3500277,2734012,1490358,1031202,2011381,556104,1315675,3486471,3780642,2437433,3037690,2106672,1069646,3245362,1821858,759437,489550,598579,3302232,925048,2924399,2035974,3217431,1096345,1623377,860751)