面试常见问题及回答

页面:/news/view-430333/ | 耗时:0.1440 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=430333 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=430333 LIMIT 0,1
select * from tbl_Articles_sphinx where id=430333 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1749450,130890,2171447,171021,2493763,2283478,123371,839214,1793128,136154,125598,187267,1565156,113398,118821,1489435,2210470,110925,3032526,132372,2196508,147377,137424,1072615,182036,166872,122308,159761,177933,179933) ORDER BY field (ArticleID,1749450,130890,2171447,171021,2493763,2283478,123371,839214,1793128,136154,125598,187267,1565156,113398,118821,1489435,2210470,110925,3032526,132372,2196508,147377,137424,1072615,182036,166872,122308,159761,177933,179933)