一款ADO处理数据库的软件,例子处理数据库在源码内,对数据处理后对数据进行树状分类,点击后可以在右边看到数据库信息,是某个项目的一部分-ADO a deal with the database software, for example, deal with the database in the source, the treatment of data after the data classification tree, click on the right can see the database information, is a part of the project
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002032s ]
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.090588s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001968s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002006s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002138s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003653s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002090s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003478s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016588s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002704s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 188979 [ RunTime:0.001230s ]