在SCO UNIX制定界面程序 可根据文件配制菜单,而不必修改源程序,非常方便- Formulation contact surface procedure may act according to the
document configuration menu in SCO the UNIX, but does not need to
revise the source program, extremely facilitates
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000878s ]
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.131121s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001675s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001696s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001354s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003240s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000791s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006778s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.029522s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.010132s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 112502 [ RunTime:0.055104s ]