bjl各种打法技巧汇总

页面:/news/view-984347/ | 耗时:0.6164 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=984347 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=984347 LIMIT 0,1
select * from tbl_Articles_sphinx where id=984347 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(546724,2273690,707872,2055049,1178776,722680,2088440,741876,1388513,1681707,1146623,2037613,380665,551388,1456758,534716,887532,575617,1637362,595314,1042261,434166,509250,634447,976956,569239,710457,1791849,1112956,780160) ORDER BY field (ArticleID,546724,2273690,707872,2055049,1178776,722680,2088440,741876,1388513,1681707,1146623,2037613,380665,551388,1456758,534716,887532,575617,1637362,595314,1042261,434166,509250,634447,976956,569239,710457,1791849,1112956,780160)