透视表如何筛选

页面:/news/view-308601/ | 耗时:0.7229 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=308601 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=308601 LIMIT 0,1
select * from tbl_Articles_sphinx where id=308601 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(4152573,4077911,4072632,3996448,3972645,3972643,3972641,3972638,3972637,3972634,3972581,3916443,3906091,3906090,3875095,3848074,3847886,3847880,3844544,3844384,3843912,3843870,3829628,3829620,3829584,3829583,3824863,3824862,3824861,3774857) ORDER BY field (ArticleID,4152573,4077911,4072632,3996448,3972645,3972643,3972641,3972638,3972637,3972634,3972581,3916443,3906091,3906090,3875095,3848074,3847886,3847880,3844544,3844384,3843912,3843870,3829628,3829620,3829584,3829583,3824863,3824862,3824861,3774857)