[ DB ] CONNECT:[ UseTime:0.007322s ] mysql:host=172.16.242.17;port=3306;dbname=bangivf;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `sgb_category` [ RunTime:0.006152s ]
[ SQL ] SELECT `id`,`name`,`image` FROM `sgb_category` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `isDel` = 0 AND `status` = 1 AND `objType` = 'HOMESH' AND `is_rec` = 1 ORDER BY `sort` DESC,`id` ASC LIMIT 0,1 [ RunTime:0.005016s ]
[ SQL ] SHOW COLUMNS FROM `sgb_tdks_cate` [ RunTime:0.005773s ]
[ SQL ] SHOW COLUMNS FROM `sgb_doctors` [ RunTime:0.006443s ]
[ SQL ] SELECT * FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `isDel` = 0 AND `id` = 105 AND `status` = 1 LIMIT 1 [ RunTime:0.005125s ]
[ SQL ] UPDATE `sgb_doctors` SET `browse_num`=`browse_num`+1 WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `isDel` = 0 AND `id` = 105 AND `status` = 1 [ RunTime:0.005610s ]
[ SQL ] SHOW COLUMNS FROM `sgb_logs_browses` [ RunTime:0.006082s ]
[ SQL ] SELECT * FROM `sgb_logs_browses` WHERE `objType` = 'DOC' AND `objId` = 105 AND `user_id` = 0 AND `click_time` = 20250922 AND `ip` = '216.73.216.11' LIMIT 1 [ RunTime:0.005228s ]
[ SQL ] SHOW COLUMNS FROM `sgb_comment` [ RunTime:0.006762s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 105 AND `topic_type` = 'DOC' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,5 [ RunTime:0.005197s ]
[ SQL ] SELECT AVG(lever) AS tp_avg FROM `sgb_comment` WHERE `topic_id` = 105 AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.004994s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sgb_comment` WHERE `status` = 1 AND `topic_id` = 105 AND `topic_type` = 'DOC' AND `parent_id` = 0 LIMIT 1 [ RunTime:0.004966s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sgb_comment` WHERE `status` = 1 AND `topic_id` = 105 AND `unsatisfied_evaluation` <> '' AND `topic_type` = 'DOC' AND `parent_id` = 0 LIMIT 1 [ RunTime:0.005083s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sgb_comment` WHERE `status` = 1 AND `topic_id` = 105 AND `satisfied_evaluation` <> '' AND `topic_type` = 'DOC' AND `parent_id` = 0 LIMIT 1 [ RunTime:0.005026s ]
[ SQL ] SHOW COLUMNS FROM `sgb_comment_praise` [ RunTime:0.006216s ]
[ SQL ] SELECT COUNT(*) as count,a.tag_id,b.`name` FROM `sgb_comment_praise` `a` INNER JOIN `sgb_category` `b` ON `a`.`tag_id`=`b`.`id` INNER JOIN `sgb_comment` `c` ON `a`.`cid`=`c`.`id` WHERE `b`.`display_setting` LIKE '%1%' AND `b`.`tenants` LIKE '%,1,%' AND `a`.`obj_id` = 105 AND `a`.`status` = 1 AND `b`.`isDel` = 0 AND `b`.`status` = 1 AND `a`.`obj_type` = 'DOC' AND `c`.`status` = 1 GROUP BY `a`.`tag_id` LIMIT 10 [ RunTime:0.006834s ]
[ SQL ] SHOW COLUMNS FROM `sgb_doctors_categorys` [ RunTime:0.006028s ]
[ SQL ] SELECT `b`.`name`,`b`.`id` FROM `sgb_doctors_categorys` `a` LEFT JOIN `sgb_category` `b` ON `a`.`cate_id`=`b`.`id` WHERE `b`.`display_setting` LIKE '%1%' AND `b`.`tenants` LIKE '%,1,%' AND `b`.`isDel` = 0 AND `a`.`doc_id` = '105' AND `b`.`objType` = 'DOCJBSC' [ RunTime:0.007019s ]
[ SQL ] SELECT `b`.`name`,`b`.`id` FROM `sgb_doctors_categorys` `a` LEFT JOIN `sgb_category` `b` ON `a`.`cate_id`=`b`.`id` WHERE `b`.`display_setting` LIKE '%1%' AND `b`.`tenants` LIKE '%,1,%' AND `b`.`isDel` = 0 AND `a`.`doc_id` = '105' AND `b`.`objType` = 'DOCZYSC' [ RunTime:0.005679s ]
[ SQL ] SHOW COLUMNS FROM `sgb_wikis_cates` [ RunTime:0.006777s ]
[ SQL ] SELECT `web_url` FROM `sgb_wikis_cates` WHERE ( name like '%女性不孕%' ) AND `display_setting` LIKE '%1%' AND `tenants` LIKE ',1,' LIMIT 1 [ RunTime:0.006759s ]
[ SQL ] SELECT `web_url` FROM `sgb_wikis_cates` WHERE ( name like '%男性不育%' ) AND `display_setting` LIKE '%1%' AND `tenants` LIKE ',1,' LIMIT 1 [ RunTime:0.006576s ]
[ SQL ] SELECT `web_url` FROM `sgb_wikis_cates` WHERE ( name like '%流产%' ) AND `display_setting` LIKE '%1%' AND `tenants` LIKE ',1,' LIMIT 1 [ RunTime:0.006519s ]
[ SQL ] SELECT `web_url` FROM `sgb_wikis_cates` WHERE ( name like '%疑难不孕%' ) AND `display_setting` LIKE '%1%' AND `tenants` LIKE ',1,' LIMIT 1 [ RunTime:0.020547s ]
[ SQL ] SELECT `web_url` FROM `sgb_wikis_cates` WHERE ( name like '%高龄不孕%' ) AND `display_setting` LIKE '%1%' AND `tenants` LIKE ',1,' LIMIT 1 [ RunTime:0.006789s ]
[ SQL ] SELECT `web_url` FROM `sgb_wikis_cates` WHERE ( name like '%性功能障碍%' ) AND `display_setting` LIKE '%1%' AND `tenants` LIKE ',1,' LIMIT 1 [ RunTime:0.006656s ]
[ SQL ] SELECT `web_url` FROM `sgb_wikis_cates` WHERE ( name like '%反复试管失败%' ) AND `display_setting` LIKE '%1%' AND `tenants` LIKE ',1,' LIMIT 1 [ RunTime:0.006719s ]
[ SQL ] SELECT `web_url` FROM `sgb_wikis_cates` WHERE ( name like '%不孕不育%' ) AND `display_setting` LIKE '%1%' AND `tenants` LIKE ',1,' LIMIT 1 [ RunTime:0.006723s ]
[ SQL ] SELECT `web_url` FROM `sgb_wikis_cates` WHERE ( name like '%辅助生殖%' ) AND `display_setting` LIKE '%1%' AND `tenants` LIKE ',1,' LIMIT 1 [ RunTime:0.006631s ]
[ SQL ] SELECT `web_url` FROM `sgb_wikis_cates` WHERE ( name like '%胚胎植入前基因诊断%' ) AND `display_setting` LIKE '%1%' AND `tenants` LIKE ',1,' LIMIT 1 [ RunTime:0.006583s ]
[ SQL ] SELECT `web_url` FROM `sgb_wikis_cates` WHERE ( name like '%胚胎培养%' ) AND `display_setting` LIKE '%1%' AND `tenants` LIKE ',1,' LIMIT 1 [ RunTime:0.006588s ]
[ SQL ] SHOW COLUMNS FROM `sgb_hospitals` [ RunTime:0.007962s ]
[ SQL ] SELECT * FROM `sgb_hospitals` WHERE `isDel` = 0 AND `id` = 61 AND `display_setting` LIKE '%1%' AND `tenants` LIKE '%1%' LIMIT 1 [ RunTime:0.005215s ]
[ SQL ] SHOW COLUMNS FROM `sgb_districts` [ RunTime:0.006363s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 96 LIMIT 1 [ RunTime:0.004914s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 96 LIMIT 1 [ RunTime:0.004958s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 96 LIMIT 1 [ RunTime:0.004971s ]
[ SQL ] SHOW COLUMNS FROM `sgb_users_message` [ RunTime:0.006489s ]
[ SQL ] SELECT * FROM `sgb_users_message` WHERE `isDel` = 0 AND `type_id` = 105 AND `user_id` = 0 AND `type` = 'DOC' AND `add_date` = 20250922 LIMIT 1 [ RunTime:0.005145s ]
[ SQL ] SHOW COLUMNS FROM `sgb_wikis` [ RunTime:0.006807s ]
[ SQL ] SELECT `title`,`id`,`content`,`agree_num` FROM `sgb_wikis` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `isDel` = 0 AND `status` = 1 AND `doctor_id` = 105 ORDER BY `add_time` DESC,`id` DESC LIMIT 0,3 [ RunTime:0.234598s ]
[ SQL ] SELECT `title`,`id`,`content`,`agree_num` FROM `sgb_wikis` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `isDel` = 0 AND `status` = 1 ORDER BY `add_time` DESC,`id` DESC LIMIT 0,3 [ RunTime:0.005173s ]
[ SQL ] SHOW COLUMNS FROM `sgb_asks` [ RunTime:0.006807s ]
[ SQL ] SELECT DISTINCT COUNT(*) AS tp_count FROM `sgb_asks` `a` INNER JOIN `sgb_comment` `b` ON `a`.`id`=`b`.`topic_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`isDel` = 0 AND `a`.`status` = 1 AND `b`.`topic_type` = 'ASK' AND `b`.`from_doctor` = 105 LIMIT 1 [ RunTime:0.125329s ]
[ SQL ] SELECT DISTINCT `a`.`title`,`a`.`id`,`a`.`user_id`,`a`.`is_hot`,`a`.`image`,`a`.`follow_num`,`a`.`content`,`a`.`add_time`,`a`.`browse_num`,`a`.`comment_num`,`a`.`agree_num`,`b`.`from_doctor` AS `doctor_id`,`b`.`create_time` FROM `sgb_asks` `a` INNER JOIN `sgb_comment` `b` ON `a`.`id`=`b`.`topic_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`isDel` = 0 AND `a`.`status` = 1 AND `b`.`topic_type` = 'ASK' AND `b`.`from_doctor` = 105 ORDER BY `b`.`create_time` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.135922s ]
[ SQL ] select * from sgb_comment where status=1 AND display_status=1 AND topic_id =6594 AND from_doctor =105 AND topic_type = 'ASK' AND parent_id =0 order by from_doctor > 0 desc,agree_num desc,comment_time desc limit 0,1 [ RunTime:0.005084s ]
[ SQL ] SELECT * FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `isDel` = 0 AND `id` = 105 LIMIT 1 [ RunTime:0.005120s ]
[ SQL ] SHOW COLUMNS FROM `sgb_community_category` [ RunTime:0.006647s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_community_category` `a` INNER JOIN `sgb_community_category_relation` `b` ON `a`.`id`=`b`.`cate_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`isDel` = 0 AND `a`.`status` = 1 AND `b`.`obj_id` = 6594 AND `a`.`objType` = 'ASK' AND `a`.`parent_id` = 0 GROUP BY `a`.`id` ORDER BY `a`.`id` ASC LIMIT 0,2 [ RunTime:0.005139s ]
[ SQL ] select * from sgb_comment where status=1 AND display_status=1 AND topic_id =4941 AND from_doctor =105 AND topic_type = 'ASK' AND parent_id =0 order by from_doctor > 0 desc,agree_num desc,comment_time desc limit 0,1 [ RunTime:0.005194s ]
[ SQL ] SELECT * FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `isDel` = 0 AND `id` = 105 LIMIT 1 [ RunTime:0.005105s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_community_category` `a` INNER JOIN `sgb_community_category_relation` `b` ON `a`.`id`=`b`.`cate_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`isDel` = 0 AND `a`.`status` = 1 AND `b`.`obj_id` = 4941 AND `a`.`objType` = 'ASK' AND `a`.`parent_id` = 0 GROUP BY `a`.`id` ORDER BY `a`.`id` ASC LIMIT 0,2 [ RunTime:0.005064s ]
[ SQL ] select * from sgb_comment where status=1 AND display_status=1 AND topic_id =4903 AND from_doctor =105 AND topic_type = 'ASK' AND parent_id =0 order by from_doctor > 0 desc,agree_num desc,comment_time desc limit 0,1 [ RunTime:0.005194s ]
[ SQL ] SELECT * FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `isDel` = 0 AND `id` = 105 LIMIT 1 [ RunTime:0.005119s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_community_category` `a` INNER JOIN `sgb_community_category_relation` `b` ON `a`.`id`=`b`.`cate_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`isDel` = 0 AND `a`.`status` = 1 AND `b`.`obj_id` = 4903 AND `a`.`objType` = 'ASK' AND `a`.`parent_id` = 0 GROUP BY `a`.`id` ORDER BY `a`.`id` ASC LIMIT 0,2 [ RunTime:0.005169s ]
[ SQL ] select * from sgb_comment where status=1 AND display_status=1 AND topic_id =4376 AND from_doctor =105 AND topic_type = 'ASK' AND parent_id =0 order by from_doctor > 0 desc,agree_num desc,comment_time desc limit 0,1 [ RunTime:0.005050s ]
[ SQL ] SHOW COLUMNS FROM `sgb_users` [ RunTime:0.007115s ]
[ SQL ] SELECT * FROM `sgb_users` WHERE `id` = 1685 AND `user_type` = 'MEM' LIMIT 1 [ RunTime:0.005160s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_community_category` `a` INNER JOIN `sgb_community_category_relation` `b` ON `a`.`id`=`b`.`cate_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`isDel` = 0 AND `a`.`status` = 1 AND `b`.`obj_id` = 4376 AND `a`.`objType` = 'ASK' AND `a`.`parent_id` = 0 GROUP BY `a`.`id` ORDER BY `a`.`id` ASC LIMIT 0,2 [ RunTime:0.005093s ]
[ SQL ] SHOW COLUMNS FROM `sgb_doctors_notice` [ RunTime:0.006240s ]
[ SQL ] SELECT * FROM `sgb_doctors_notice` WHERE `isDel` = 0 AND `create_time` >= 1750570693 AND `doc_id` = 105 ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.005001s ]
[ SQL ] SELECT `id`,`cn_shortname`,`image`,`disease`,`follow_num`,`doc_years`,`appoint_num`,`auth`,`doc_title` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `hospital_id` = 61 AND `id` <> 105 ORDER BY `browse_num` DESC LIMIT 0,4 [ RunTime:0.005048s ]
[ SQL ] SELECT `b`.`name`,`b`.`id` FROM `sgb_doctors_categorys` `a` LEFT JOIN `sgb_category` `b` ON `a`.`cate_id`=`b`.`id` WHERE `b`.`display_setting` LIKE '%1%' AND `b`.`tenants` LIKE '%,1,%' AND `b`.`isDel` = 0 AND `a`.`doc_id` = '106' AND `b`.`objType` = 'DOCJBSC' [ RunTime:0.006782s ]