商务bd面试技巧

页面:/news/view-208420/ | 耗时:0.7311 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=208420 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=208420 LIMIT 0,1
select * from tbl_Articles_sphinx where id=208420 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(354064,108799,190191,153616,333937,241563,340565,251628,3255666,244909,649989,314637,3258933,294738,245882,738085,170663,225145,256355,167192,302360,240294,384362,240891,336686,241397,112905,224324,235330,289179) ORDER BY field (ArticleID,354064,108799,190191,153616,333937,241563,340565,251628,3255666,244909,649989,314637,3258933,294738,245882,738085,170663,225145,256355,167192,302360,240294,384362,240891,336686,241397,112905,224324,235330,289179)