PB9.0生成的患者入院管理系统,能完成一般病人从入院到出院遇到的一般手续操作。后缀为db的是数据库文件,注意看readme文本-Generated PB9.0 patients admitted to hospital management systems, to complete the average patient was discharged from the hospital to face the general operating procedures. Db suffix to the database file, pay attention to see readme text
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001913s ]
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.087552s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002212s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001937s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002147s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003637s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002307s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003274s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014953s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002534s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 205420 [ RunTime:0.001235s ]