[ DB ] CONNECT:[ UseTime:0.007369s ] mysql:host=172.16.242.17;port=3306;dbname=bangivf;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `sgb_category` [ RunTime:0.006215s ]
[ 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.005063s ]
[ SQL ] SHOW COLUMNS FROM `sgb_tdks_cate` [ RunTime:0.005824s ]
[ 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` = 'HOSTS' ORDER BY `sort` DESC,`id` ASC [ RunTime:0.005182s ]
[ SQL ] SHOW COLUMNS FROM `sgb_districts` [ RunTime:0.005973s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `parent_id` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.005168s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `web_url` = 'zhongguo' LIMIT 1 [ RunTime:0.004902s ]
[ SQL ] SELECT `a`.*,b.web_url as pweb_url FROM `sgb_districts` `a` INNER JOIN `sgb_districts` `b` ON `a`.`parent_id`=`b`.`id` WHERE `a`.`parent_id` = 95 ORDER BY `a`.`sort` DESC,`a`.`id` ASC [ RunTime:0.005205s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `web_url` = 'hebei' LIMIT 1 [ RunTime:0.004904s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `parent_id` = 118 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.005075s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `web_url` = 'shijiazhuang' LIMIT 1 [ RunTime:0.004918s ]
[ SQL ] SHOW COLUMNS FROM `sgb_hospitals` [ RunTime:0.006497s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 248 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005352s ]
[ SQL ] SELECT `a`.`id` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 248 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005226s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 248 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005373s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 249 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005289s ]
[ SQL ] SELECT `a`.`id` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 249 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005248s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 249 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005322s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 250 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005257s ]
[ SQL ] SELECT `a`.`id` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 250 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005246s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 250 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005325s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 252 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005361s ]
[ SQL ] SELECT `a`.`id` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 252 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005272s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 252 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005295s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 253 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005207s ]
[ SQL ] SELECT `a`.`id` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 253 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005235s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 253 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005276s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 254 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005315s ]
[ SQL ] SELECT `a`.`id` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 254 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005243s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `b`.`cate_id` = 254 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005217s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 0 AND 49999 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005140s ]
[ SQL ] SELECT `a`.`id` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 0 AND 49999 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005117s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 0 AND 49999 AND `a`.`city_id` = 172 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005094s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 50000 AND 99999 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005022s ]
[ SQL ] SELECT `a`.`id` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 50000 AND 99999 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.004987s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 50000 AND 99999 AND `a`.`city_id` = 172 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.004965s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 100000 AND 149999 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005022s ]
[ SQL ] SELECT `a`.`id` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 100000 AND 149999 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.004958s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 100000 AND 149999 AND `a`.`city_id` = 172 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005027s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 150000 AND 199999 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005050s ]
[ SQL ] SELECT `a`.`id` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 150000 AND 199999 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005038s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 150000 AND 199999 AND `a`.`city_id` = 172 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005043s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 200000 AND 999999 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.004965s ]
[ SQL ] SELECT `a`.`id` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 200000 AND 999999 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.004951s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`price` BETWEEN 200000 AND 999999 AND `a`.`city_id` = 172 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.004936s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005027s ]
[ SQL ] SELECT `a`.`id`,`a`.`image`,`a`.`yx_name`,`a`.`cn_name`,`a`.`honorary_title`,`a`.`disease`,`a`.`price`,`a`.`appoint_num`,`a`.`special_auth`,`a`.`video_url`,`a`.`satisfaction_num`,`a`.`lever`,`a`.`active_img`,`a`.`auth`,`a`.`success_num`,`a`.`city_id`,`a`.`comment_num`,`a`.`introduction`,`a`.`dengji_desc`,`a`.`ys_desc` FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' AND `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005314s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `sgb_hospitals` `a` LEFT JOIN `sgb_hospitals_categorys` `b` ON `a`.`id`=`b`.`hos_id` WHERE `a`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 172 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005088s ]
[ SQL ] SHOW COLUMNS FROM `sgb_doctors` [ RunTime:0.006477s ]
[ SQL ] SELECT `doc_title`,`cn_name`,`appoint_num`,`id`,`image` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,187,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.007877s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 187 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005047s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 187 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005131s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 187 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005092s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 187 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005125s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 187 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005170s ]
[ SQL ] SELECT `a`.`name`,`a`.`id`,`a`.`description` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 187 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.008254s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 172 LIMIT 1 [ RunTime:0.004918s ]
[ SQL ] SHOW COLUMNS FROM `sgb_pictures` [ RunTime:0.005984s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 187 ORDER BY `sort` ASC [ RunTime:0.004974s ]
[ SQL ] SELECT `id` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,187,%' [ RunTime:0.007455s ]
[ SQL ] SHOW COLUMNS FROM `sgb_comment` [ RunTime:0.006222s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (450,452,453,457) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 187 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005209s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 187 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005120s ]
[ SQL ] SELECT `doc_title`,`cn_name`,`appoint_num`,`id`,`image` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,1403,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.010983s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1403 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005138s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1403 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005020s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1403 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005060s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1403 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005100s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1403 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005140s ]
[ SQL ] SELECT `a`.`name`,`a`.`id`,`a`.`description` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1403 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005216s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 172 LIMIT 1 [ RunTime:0.004860s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 1403 ORDER BY `sort` ASC [ RunTime:0.005031s ]
[ SQL ] SELECT `id` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,1403,%' [ RunTime:0.008440s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (0) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 1403 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005102s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 1403 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005045s ]
[ SQL ] SELECT `doc_title`,`cn_name`,`appoint_num`,`id`,`image` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,470,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.007934s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 470 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005122s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 470 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005013s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 470 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005058s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 470 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005086s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 470 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005135s ]
[ SQL ] SELECT `a`.`name`,`a`.`id`,`a`.`description` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 470 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005240s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 172 LIMIT 1 [ RunTime:0.004855s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 470 ORDER BY `sort` ASC [ RunTime:0.004959s ]
[ SQL ] SELECT `id` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,470,%' [ RunTime:0.007412s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (1365,1366,1367,1368,2104,2176) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 470 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005226s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 470 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005095s ]
[ SQL ] SELECT `doc_title`,`cn_name`,`appoint_num`,`id`,`image` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,1407,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.008631s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1407 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005119s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1407 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.004998s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1407 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005010s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1407 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005126s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1407 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005022s ]
[ SQL ] SELECT `a`.`name`,`a`.`id`,`a`.`description` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1407 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005247s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 172 LIMIT 1 [ RunTime:0.004900s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 1407 ORDER BY `sort` ASC [ RunTime:0.004902s ]
[ SQL ] SELECT `id` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,1407,%' [ RunTime:0.007354s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (2301) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 1407 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005088s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 1407 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005100s ]
[ SQL ] SELECT `doc_title`,`cn_name`,`appoint_num`,`id`,`image` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,1253,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.009105s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1253 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005064s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1253 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.004982s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1253 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005027s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1253 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005276s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1253 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005094s ]
[ SQL ] SELECT `a`.`name`,`a`.`id`,`a`.`description` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1253 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005119s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 172 LIMIT 1 [ RunTime:0.004869s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 1253 ORDER BY `sort` ASC [ RunTime:0.005134s ]
[ SQL ] SELECT `id` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,1253,%' [ RunTime:0.007506s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (1766,1767,1768,2280,2315) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 1253 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005294s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 1253 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005076s ]
[ SQL ] SELECT `doc_title`,`cn_name`,`appoint_num`,`id`,`image` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,1252,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.007971s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1252 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005153s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1252 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005024s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1252 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005106s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1252 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005117s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1252 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005159s ]
[ SQL ] SELECT `a`.`name`,`a`.`id`,`a`.`description` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 1252 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005211s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 172 LIMIT 1 [ RunTime:0.004861s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 1252 ORDER BY `sort` ASC [ RunTime:0.004889s ]
[ SQL ] SELECT `id` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,1252,%' [ RunTime:0.007456s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (1763,1764,1765,1772,1773,1774) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 1252 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005319s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 1252 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005106s ]
[ SQL ] SELECT `doc_title`,`cn_name`,`appoint_num`,`id`,`image` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,603,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.007783s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 603 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005019s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 603 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005095s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 603 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005037s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 603 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005001s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 603 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005055s ]
[ SQL ] SELECT `a`.`name`,`a`.`id`,`a`.`description` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 603 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005099s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 172 LIMIT 1 [ RunTime:0.009261s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 603 ORDER BY `sort` ASC [ RunTime:0.004946s ]
[ SQL ] SELECT `id` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,603,%' [ RunTime:0.007865s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (0) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 603 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005196s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 603 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005014s ]
[ SQL ] SELECT `doc_title`,`cn_name`,`appoint_num`,`id`,`image` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,341,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.007846s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 341 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005225s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 341 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005057s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 341 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.008345s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 341 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005228s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 341 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005265s ]
[ SQL ] SELECT `a`.`name`,`a`.`id`,`a`.`description` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 341 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005245s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 172 LIMIT 1 [ RunTime:0.004861s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 341 ORDER BY `sort` ASC [ RunTime:0.005089s ]
[ SQL ] SELECT `id` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,341,%' [ RunTime:0.007730s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (1949,1950,1951,1952,1953,2129) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 341 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005279s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 341 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005030s ]
[ SQL ] SELECT `doc_title`,`cn_name`,`appoint_num`,`id`,`image` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,186,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.007763s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 186 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005167s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 186 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005094s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 186 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005106s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 186 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005270s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 186 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005150s ]
[ SQL ] SELECT `a`.`name`,`a`.`id`,`a`.`description` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 186 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005218s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 172 LIMIT 1 [ RunTime:0.004931s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 186 ORDER BY `sort` ASC [ RunTime:0.004978s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (593,594) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 186 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005261s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 186 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005087s ]
[ SQL ] SELECT `doc_title`,`cn_name`,`appoint_num`,`id`,`image` FROM `sgb_doctors` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 AND `other_hospotal_ids` LIKE '%,147,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.007782s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 147 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005180s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 147 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005094s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 147 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005207s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 147 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005256s ]
[ SQL ] SELECT `a`.`name` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 147 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005134s ]
[ SQL ] SELECT `a`.`name`,`a`.`id`,`a`.`description` FROM `sgb_category` `a` INNER JOIN `sgb_hospitals_categorys` `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`.`hos_id` = 147 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005246s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 172 LIMIT 1 [ RunTime:0.004915s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 147 ORDER BY `sort` ASC [ RunTime:0.005081s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (447,448,449,451,456) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 147 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005284s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 147 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005167s ]
[ 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` = 'HOSFW' ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004954s ]
[ SQL ] SELECT `id`,`image`,`auth`,`yx_name`,`appoint_num`,`cn_name`,`price`,`lever`,`success_num`,`introduction`,`satisfaction_num` FROM `sgb_hospitals` WHERE `display_setting` LIKE '%1%' AND `tenants` LIKE '%,1,%' AND `status` = 1 AND `isDel` = 0 ORDER BY `appoint_num` DESC,`sort` DESC,`create_time` DESC LIMIT 0,10 [ RunTime:0.008150s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (0) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 758 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005083s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (38,39,40,145,146,148,2361) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 81 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005201s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (36,37,137,138) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 53 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005085s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (69,74,78,211,212,213,214) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 87 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005210s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (98,100,226,227,228,237,238,2261) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 107 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005236s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (143,144,217,218,1989) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 85 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005189s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (0) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 254 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005069s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (0) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 121 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.020539s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (1990,1991,1992,1993,1994) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 1303 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.006425s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (156,158,161,215,216) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 86 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005252s ]
[ SQL ] SHOW COLUMNS FROM `sgb_ad_banner` [ RunTime:0.006071s ]
[ SQL ] SELECT `pic`,`url` FROM `sgb_ad_banner` WHERE `status` = 1 AND `position_id` = 16 ORDER BY `sort` DESC,`id` ASC LIMIT 0,4 [ RunTime:0.004921s ]