换表带扣技巧分享

页面:/news/view-3104474/ | 耗时:0.0314 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3104474 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3104474 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3104474 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(3105845,992177,1965826,2673928,912310,3123581,1373682,662407,1090235,3515123,3125415,1740782,1030666,2172299,1089329,561018,3150118,3019465,3347712,879920,3072190,2975929,1074181,2361448,651718,1366909,2301349,974883,928801,891777) ORDER BY field (ArticleID,3105845,992177,1965826,2673928,912310,3123581,1373682,662407,1090235,3515123,3125415,1740782,1030666,2172299,1089329,561018,3150118,3019465,3347712,879920,3072190,2975929,1074181,2361448,651718,1366909,2301349,974883,928801,891777)