这是我在中嵌学习的时候的课程资料,对于刚刚接触嵌入式的人来说会有定的帮助,有兴趣的人可以拿去看哈!-This is my time of learning embedded in the course materials, for just contact with people who will be embedded help those who are interested to see is unspeakable Ha!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001357s ]
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.088695s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001267s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001937s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001247s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003604s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001072s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003218s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018837s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001589s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 173271 [ RunTime:0.001378s ]