一个封装完善的数据库操作类,支持几乎所有数据库类型,包括打开,查询,编辑等操作,希望对大家有所帮助。-A package to improve the operation of the database category, support for almost all database types, including open, query, editing and other operations, would like to help everyone.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001654s ]
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.106896s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001123s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001536s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000950s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003174s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000772s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003658s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015114s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001132s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 187291 [ RunTime:0.023502s ]