速写中的透视技巧

页面:/news/view-361731/ | 耗时:0.9004 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=361731 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=361731 LIMIT 0,1
select * from tbl_Articles_sphinx where id=361731 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(996134,496263,863290,724792,1115209,634067,3010834,1085580,500918,1471041,2615841,2594450,1841121,1104676,677474,1096631,1095900,369976,797362,3218051,610890,2894517,761081,1156486,515238,1096969,1877350,406447,805993,645431) ORDER BY field (ArticleID,996134,496263,863290,724792,1115209,634067,3010834,1085580,500918,1471041,2615841,2594450,1841121,1104676,677474,1096631,1095900,369976,797362,3218051,610890,2894517,761081,1156486,515238,1096969,1877350,406447,805993,645431)