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