教资面试不紧张的小技巧

页面:/news/view-549798/ | 耗时:0.3310 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=549798 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=549798 LIMIT 0,1
select * from tbl_Articles_sphinx where id=549798 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(3511208,789265,998755,1119710,389003,951955,1120379,100695,1100006,1112980,3263903,2759135,924097,1135202,2301221,1880098,955493,687755,1212136,2526517,2548474,1119852,1102570,1120213,1975833,1114256,1094597,926260,853078,2575554) ORDER BY field (ArticleID,3511208,789265,998755,1119710,389003,951955,1120379,100695,1100006,1112980,3263903,2759135,924097,1135202,2301221,1880098,955493,687755,1212136,2526517,2548474,1119852,1102570,1120213,1975833,1114256,1094597,926260,853078,2575554)