医院管理系统,使用的PowerBuilder开发的管理系统,主要的是使用PB的数据窗口来完成对后台数据库的操作,非常方便。-hospital management system, using the PowerBuilder development of the management system, the main use of PB is the data window to the completion of background database, the operation is very easy.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.012629s ]
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.093709s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002468s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001916s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002384s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.009415s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002265s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003480s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.017263s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002536s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 287268 [ RunTime:0.001325s ]