[ DB ] CONNECT:[ UseTime:0.014904s ] mysql:host=rm-2vc43t1s91j7l21v9.mysql.cn-chengdu.rds.aliyuncs.com;port=3306;dbname=tg_sgcognac;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `app_zhifa_links` [ RunTime:0.001830s ]
[ SQL ] SELECT * FROM `app_zhifa_links` ORDER BY `order_sort` ASC [ RunTime:0.000652s ]
[ SQL ] SHOW COLUMNS FROM `app_hospitals` [ RunTime:0.001571s ]
[ SQL ] SELECT * FROM `app_hospitals` `hospital` WHERE `hospital`.`id` = '587' LIMIT 1 [ RunTime:0.000805s ]
[ SQL ] SHOW COLUMNS FROM `app_hospital_project` [ RunTime:0.001245s ]
[ SQL ] SELECT `dp`.`project_id`,p.name project_name,`dp`.`hospital_id` FROM `app_hospital_project` `dp` INNER JOIN `sys_project` `p` ON `dp`.`project_id`=`p`.`id` WHERE ( dp.hospital_id=587 ) [ RunTime:0.000689s ]
[ SQL ] SELECT `doctor`.*,hospital.name as hospital_name FROM `app_hospitals` `hospital` INNER JOIN `sys_doctor` `doctor` ON `doctor`.`hospital_id`=`hospital`.`id` WHERE ( doctor.hospital_id=587 ) ORDER BY `doctor`.`id` DESC LIMIT 6 [ RunTime:0.002653s ]
[ SQL ] SHOW COLUMNS FROM `app_hospitals_related` [ RunTime:0.002035s ]
[ SQL ] SELECT `hospital`.`id`,`hospital`.`name`,`hospital`.`city`,`hospital`.`state_hospital`,`hospital`.`logo`,`hospital`.`hospital_create_time` FROM `app_hospitals_related` `hr` INNER JOIN `app_hospitals` `hospital` ON `hr`.`object_id`=`hospital`.`id` WHERE `hospital`.`status` = 1 AND `hr`.`owner_id` = '587' AND `hr`.`types` = 2 LIMIT 5 [ RunTime:0.000832s ]
[ SQL ] SELECT `news`.`id`,`news`.`title`,`news`.`title_img`,`news`.`open_time`,`news`.`view_num`,`news`.`contents` FROM `app_hospitals_related` `hr` INNER JOIN `sys_consult` `news` ON `hr`.`object_id`=`news`.`id` WHERE `news`.`is_show` = 1 AND `hr`.`owner_id` = '587' AND `hr`.`types` = 1 LIMIT 5 [ RunTime:0.001068s ]
