代码实现了目前所使用的大部分手机上的英文单词的输入功能,可根据使用频率给出常用单词!-Realize the current code used by the majority of English words on the phone input function, frequency of use is given in accordance with commonly used word!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001270s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.088984s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001211s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001885s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001210s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003572s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001044s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003195s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014936s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001352s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 148870 [ RunTime:0.001198s ]