实现数据库中实体到类的动态映射,通过映射可方便的实现数据库记录的增删改查等操作.-Database entities to realize the dynamic type of mapping, through the mapping may facilitate the realization of the database records, such as additions and deletions to check operation.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001344s ]
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.094764s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001247s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001905s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001238s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005196s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001167s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005135s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.026949s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001996s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 243732 [ RunTime:0.001451s ]