Sick of Hibernate and HQL yet? Having database persistence layer performance issues? Want to get back to your roots and feel one with your database again? Fauxjo may be just what you have been looking for.
Visit the Fauxjo product homepage for more details.
Visit the Jextra team homepage for other great developer tools.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002216s ]
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.092023s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002589s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002076s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002481s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003890s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.008732s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003717s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016609s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002723s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 271517 [ RunTime:0.001465s ]