Starting from the cms and blog app (Coltrane) as it is done in Practical Django Projects by James Bennett the goal is to make easy to set up and easy to customize web site package.
文 件 列 表
snake-cms media markdown README tagging filebrowser akismet.py db sorl snakelog grappelli templates cms snake-cms.wsgi
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001954s ]
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.092753s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002048s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001978s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002271s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003768s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002434s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003507s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015728s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002783s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 308484 [ RunTime:0.001134s ]