一个用来查询成语词条及内容的小程序,利用了字符操作方法.包括源代码和程序.-a proverb can be used to query the contents of the entries and small procedures, the use of the methods of operation of the characters. Including source code and procedures.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001378s ]
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.093801s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001295s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001916s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001370s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003616s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001138s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003338s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014906s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001440s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 300615 [ RunTime:0.001193s ]