[ DB ] CONNECT:[ UseTime:0.003393s ] mysql:host=mysql;port=3306;dbname=www.iximei.cn;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `mr_doctors` [ RunTime:0.002109s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `mr_doctors` `d` LEFT JOIN `mr_hospital` `h` ON `d`.`hospital_id`=`h`.`id` LEFT JOIN `mr_region` `r` ON `h`.`province`=`r`.`area_id` WHERE ( `d`.`name` LIKE '%熙爱美网%' ) [ RunTime:0.310218s ]
[ SQL ] SELECT `d`.*,`h`.`province`,`h`.`city`,`h`.`district`,`r`.`area_name` FROM `mr_doctors` `d` LEFT JOIN `mr_hospital` `h` ON `d`.`hospital_id`=`h`.`id` LEFT JOIN `mr_region` `r` ON `h`.`province`=`r`.`area_id` WHERE ( `d`.`name` LIKE '%熙爱美网%' ) ORDER BY `id` DESC LIMIT 0,18 [ RunTime:2.554263s ]
