sumproduct多条件求和

页面:/news/view-3230065/ | 耗时:0.2435 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3230065 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3230065 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3230065 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1274047,559002,2156727,1370241,1105721,3444070,1908748,2866400,1030713,1139233,963354,1199461,3428784,1400596,1263298,1144777,3118208,3277594,1191674,2973158,4002506,670730,2116078,1001277,1388358,3281614,1463226,2481728,1171129,2416934) ORDER BY field (ArticleID,1274047,559002,2156727,1370241,1105721,3444070,1908748,2866400,1030713,1139233,963354,1199461,3428784,1400596,1263298,1144777,3118208,3277594,1191674,2973158,4002506,670730,2116078,1001277,1388358,3281614,1463226,2481728,1171129,2416934)