[ SQL ] SHOW COLUMNS FROM `cmf_remote_doctor` [ RunTime:0.007915s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_remote_doctor` `a` LEFT JOIN `cmf_remote_hospital` `rh` ON `rh`.`id`=`a`.`hospital` WHERE `classId` = 2 LIMIT 1 [ RunTime:0.001022s ]
[ SQL ] SELECT `a`.*,rh.name as hosName,rh.description as hosDes FROM `cmf_remote_doctor` `a` LEFT JOIN `cmf_remote_hospital` `rh` ON `rh`.`id`=`a`.`hospital` WHERE `classId` = 2 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.001058s ]