This an excellent collection of XML best practices: essential reading for any developer using XML. This book will help you avoid common pitfalls and ensure your XML applications remain practical and interoperable for as long as possible."
Edd Dumbill, Managing Editor, XML.com and Program Chair, XML Europe
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001138s ]
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.110712s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.003621s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.004700s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.004255s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004206s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.004298s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004134s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.026335s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001691s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 482246 [ RunTime:0.017102s ]