[ DB ] CONNECT:[ UseTime:0.018963s ] 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.001832s ]
[ SQL ] SELECT * FROM `app_zhifa_links` ORDER BY `order_sort` ASC [ RunTime:0.000712s ]
[ SQL ] SHOW COLUMNS FROM `app_hospitals` [ RunTime:0.001801s ]
[ SQL ] SELECT * FROM `app_hospitals` `hospital` WHERE `hospital`.`id` = '970' LIMIT 1 [ RunTime:0.000973s ]
[ SQL ] SHOW COLUMNS FROM `app_hospital_project` [ RunTime:0.001469s ]
[ 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=970 ) [ RunTime:0.000803s ]
[ 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=970 ) ORDER BY `doctor`.`id` DESC LIMIT 6 [ RunTime:0.002604s ]
[ SQL ] SHOW COLUMNS FROM `app_hospitals_related` [ RunTime:0.001574s ]
[ 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` = '970' AND `hr`.`types` = 2 LIMIT 5 [ RunTime:0.000958s ]
[ 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` = '970' AND `hr`.`types` = 1 LIMIT 5 [ RunTime:0.001185s ]
