SELECT COUNT(*) AS think_count FROM `mk_doctor` `d` LEFT JOIN `mk_hospital` `h` ON `d`.`hospital_id`=`h`.`id` WHERE `d`.`status` = 'passed' AND `h`.`status` = 'passed' AND `h`.`area_province_id` = '430000' AND `d`.`adept` = '眼部' AND `d`.`since` < '2002' LIMIT 1 [ RunTime:0.002410s ]
SELECT `d`.`id`,`d`.`main_image`,`d`.`name`,`d`.`intro`,`d`.`hospital_id`,`d`.`position`,`d`.`adept`,`d`.`since`,h.name as hospital_name FROM `mk_doctor` `d` LEFT JOIN `mk_hospital` `h` ON `d`.`hospital_id`=`h`.`id` WHERE `d`.`status` = 'passed' AND `h`.`status` = 'passed' AND `h`.`area_province_id` = '430000' AND `d`.`adept` = '眼部' AND `d`.`since` < '2002' ORDER BY `d`.`weigh` DESC LIMIT 0,10 [ RunTime:0.001916s ]
