developing web applications with coldfusion express
The coldfusion web application sever provides the fastest way to integrate
browser sever ,and database technologies into powerful web applications and interactive
web sites.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.020713s ]
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.219406s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:1.103805s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.003359s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.164872s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.007264s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.042300s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.011461s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.021493s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001391s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 397668 [ RunTime:0.159412s ]