[ SQL ] SHOW COLUMNS FROM `cmf_remote_doctor` [ RunTime:0.006029s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_remote_doctor` `a` LEFT JOIN `cmf_remote_hospital` `rh` ON `rh`.`id`=`a`.`hospital` WHERE `classId` = 4 LIMIT 1 [ RunTime:0.000966s ]
[ 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` = 4 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.001564s ]