宾得kx使用技巧

页面:/news/view-564234/ | 耗时:0.5928 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=564234 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=564234 LIMIT 0,1
select * from tbl_Articles_sphinx where id=564234 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1041074,1203056,1061235,556921,2192840,1088896,1233678,3490096,2852076,673274,1058352,3041104,3332851,2726442,800785,571320,1127683,2293604,914090,3295126,523750,738778,803617,668373,906660,1002286,715598,2481078,1446775,2597217) ORDER BY field (ArticleID,1041074,1203056,1061235,556921,2192840,1088896,1233678,3490096,2852076,673274,1058352,3041104,3332851,2726442,800785,571320,1127683,2293604,914090,3295126,523750,738778,803617,668373,906660,1002286,715598,2481078,1446775,2597217)