取虾线的小技巧

页面:/news/view-1372380/ | 耗时:0.5871 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1372380 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1372380 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1372380 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1108774,1123533,1120693,1122432,1122879,1079291,1074377,1110221,1052747,1121846,1049284,1132701,1105621,1111724,1118555,1106785,1107643,1123799,1043798,1106898,1043830,1113662,1089068,1105892,1124390,1114112,1114576,1090789,1111172,1123591) ORDER BY field (ArticleID,1108774,1123533,1120693,1122432,1122879,1079291,1074377,1110221,1052747,1121846,1049284,1132701,1105621,1111724,1118555,1106785,1107643,1123799,1043798,1106898,1043830,1113662,1089068,1105892,1124390,1114112,1114576,1090789,1111172,1123591)