透视表如何制作

页面:/news/view-1308842/ | 耗时:0.8279 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1308842 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1308842 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1308842 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(183929,1490433,1095928,1076478,1881260,1504691,1460040,805039,794311,200500,109637,1605561,639935,241151,368134,1347939,673021,1481703,1131669,1068094,1643985,359447,335651,1910365,540338,1461732,1902848,1297117,1491437,693256) ORDER BY field (ArticleID,183929,1490433,1095928,1076478,1881260,1504691,1460040,805039,794311,200500,109637,1605561,639935,241151,368134,1347939,673021,1481703,1131669,1068094,1643985,359447,335651,1910365,540338,1461732,1902848,1297117,1491437,693256)