自己做的一个企业站点源码,前台Flex,后台php,其数据交互利用xml。-An enterprise site source code developed by myself. Front site is based on Flex, the manage site is writeen by php. Xml is the medium for php and flex to communicate.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001330s ]
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.088306s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001242s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001896s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001361s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003543s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001043s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003167s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015011s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001455s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 36844 [ RunTime:0.001602s ]