挖竹笋最简单的方法

页面:/news/view-1098484/ | 耗时:0.3213 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1098484 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1098484 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1098484 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1073614,1124360,1114288,1053400,1108500,1074568,1099189,1123030,1111480,1110696,1123535,1047419,1079291,1094525,1122747,1066240,1105787,1103815,1499326,1104337,1114758,1124350,1108187,1123723,1067579,1117582,1110626,1120376,1073451,1068314) ORDER BY field (ArticleID,1073614,1124360,1114288,1053400,1108500,1074568,1099189,1123030,1111480,1110696,1123535,1047419,1079291,1094525,1122747,1066240,1105787,1103815,1499326,1104337,1114758,1124350,1108187,1123723,1067579,1117582,1110626,1120376,1073451,1068314)