[ DB ] CONNECT:[ UseTime:0.002853s ] 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.001756s ]
[ SQL ] SELECT * FROM `app_zhifa_links` ORDER BY `order_sort` ASC [ RunTime:0.000721s ]
[ SQL ] SHOW COLUMNS FROM `app_hospitals` [ RunTime:0.001544s ]
[ SQL ] SELECT * FROM `app_hospitals` `hospital` WHERE `hospital`.`id` = '842' LIMIT 1 [ RunTime:0.000780s ]
[ SQL ] SHOW COLUMNS FROM `app_hospital_project` [ RunTime:0.001606s ]
[ 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=842 ) [ RunTime:0.001105s ]
[ 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=842 ) ORDER BY `doctor`.`id` DESC LIMIT 6 [ RunTime:0.003079s ]
[ SQL ] SHOW COLUMNS FROM `app_hospitals_related` [ RunTime:0.001285s ]
[ 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` = '842' AND `hr`.`types` = 2 LIMIT 5 [ RunTime:0.000840s ]
[ 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` = '842' AND `hr`.`types` = 1 LIMIT 5 [ RunTime:0.001033s ]
