钓海鲈鱼的三种实用方法

页面:/news/view-986047/ | 耗时:0.7352 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=986047 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=986047 LIMIT 0,1
select * from tbl_Articles_sphinx where id=986047 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(2727148,3530489,1140015,2495470,1064041,1051371,2596923,1393280,3528964,1062910,1074910,2981378,2615454,3530001,1886189,1810106,1000587,3221822,2017835,3154467,2411788,2532435,2692825,1929622,3019075,2893091,2120546,1882921,1653775,2687857) ORDER BY field (ArticleID,2727148,3530489,1140015,2495470,1064041,1051371,2596923,1393280,3528964,1062910,1074910,2981378,2615454,3530001,1886189,1810106,1000587,3221822,2017835,3154467,2411788,2532435,2692825,1929622,3019075,2893091,2120546,1882921,1653775,2687857)