透视法分几种

页面:/news/view-2414393/ | 耗时:0.6977 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2414393 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2414393 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2414393 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1126902,2804408,1122895,2730326,1611417,2279103,1121413,1621283,2611277,133380,122176,331781,1123130,2374797,650524,1401271,2306376,2571055,3071816,2576094,210167,2391944,1107240,1128753,2738265,3010683,936526,1129763,1099373,2389086) ORDER BY field (ArticleID,1126902,2804408,1122895,2730326,1611417,2279103,1121413,1621283,2611277,133380,122176,331781,1123130,2374797,650524,1401271,2306376,2571055,3071816,2576094,210167,2391944,1107240,1128753,2738265,3010683,936526,1129763,1099373,2389086)