快速做烧麦的方法

页面:/news/view-1515143/ | 耗时:0.0984 s | 内存:1.89 MB | 查询:5 | 缓存读取:4 写入:1 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1515143 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1515143 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1515143 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1097571,1082284,1111786,1093621,1089884,1104559,1110077,1111648,1109222,1105299,1110341,1100424,1105271,1073726,1067205,1089546,1087565,1065865,1056328,1105389,1107979,1087451,1093282,1046230,1108772,1101975,1103374,1103917,1086452,1121423) ORDER BY field (ArticleID,1097571,1082284,1111786,1093621,1089884,1104559,1110077,1111648,1109222,1105299,1110341,1100424,1105271,1073726,1067205,1089546,1087565,1065865,1056328,1105389,1107979,1087451,1093282,1046230,1108772,1101975,1103374,1103917,1086452,1121423)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90002 ORDER BY ArticleID DESC LIMIT 20