This book is written for all developers writing code for the ARM. It assumes that you
are an experienced software developer, and that you are familiar with the ARM
development tools as described in ADS Getting Started.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001215s ]
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.109112s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001185s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001930s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001171s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003613s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000971s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003172s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015084s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001341s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 415403 [ RunTime:0.001409s ]
