运行时,需要人工交互输入数据,按照界面给出的提示完成输入即可。
结果显示从初始状态到目标状态的整个过程。-Run-time, the need for manual interaction input data, in accordance with the interface are given prompts to complete the input. The results showed that from the initial state to target state of the whole process.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002253s ]
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.086517s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002018s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002023s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002306s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003781s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002147s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003308s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014825s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002642s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 177186 [ RunTime:0.001280s ]