[ DB ] CONNECT:[ UseTime:0.007659s ] mysql:host=172.16.242.17;port=3306;dbname=bangivf;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `sgb_category` [ RunTime:0.006744s ]
[ 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.005282s ]
[ SQL ] SHOW COLUMNS FROM `sgb_tdks_cate` [ RunTime:0.006087s ]
[ 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.005186s ]
[ SQL ] SHOW COLUMNS FROM `sgb_districts` [ RunTime:0.005872s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `parent_id` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.005374s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `web_url` = 'zhongguo' LIMIT 1 [ RunTime:0.005078s ]
[ 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.005324s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `web_url` = 'guangxi' LIMIT 1 [ RunTime:0.005049s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `parent_id` = 109 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.005247s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `web_url` = 'beihai' LIMIT 1 [ RunTime:0.005124s ]
[ SQL ] SHOW COLUMNS FROM `sgb_hospitals` [ RunTime:0.006820s ]
[ 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` = 203 AND `b`.`cate_id` = 248 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005321s ]
[ 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` = 203 AND `b`.`cate_id` = 248 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005313s ]
[ 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` = 203 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.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`.`city_id` = 203 AND `b`.`cate_id` = 249 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005188s ]
[ 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` = 203 AND `b`.`cate_id` = 249 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` = 203 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.005212s ]
[ 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` = 203 AND `b`.`cate_id` = 250 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005071s ]
[ 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` = 203 AND `b`.`cate_id` = 250 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005103s ]
[ 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` = 203 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.005206s ]
[ 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` = 203 AND `b`.`cate_id` = 252 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005172s ]
[ 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` = 203 AND `b`.`cate_id` = 252 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005161s ]
[ 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` = 203 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.005234s ]
[ 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` = 203 AND `b`.`cate_id` = 253 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005202s ]
[ 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` = 203 AND `b`.`cate_id` = 253 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005182s ]
[ 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` = 203 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.005214s ]
[ 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` = 203 AND `b`.`cate_id` = 254 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005162s ]
[ 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` = 203 AND `b`.`cate_id` = 254 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005169s ]
[ 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` = 203 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.005253s ]
[ 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` = 203 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005189s ]
[ 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` = 203 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005190s ]
[ 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` = 203 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005177s ]
[ 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` = 203 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`.`price` BETWEEN 50000 AND 99999 AND `a`.`city_id` = 203 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005137s ]
[ 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` = 203 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005108s ]
[ 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` = 203 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005087s ]
[ 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` = 203 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005112s ]
[ 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` = 203 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005071s ]
[ 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` = 203 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005104s ]
[ 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` = 203 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005087s ]
[ 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` = 203 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005173s ]
[ 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` = 203 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005192s ]
[ 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` = 203 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005123s ]
[ 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` = 203 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005115s ]
[ 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` = 203 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005270s ]
[ 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` = 203 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005287s ]
[ 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` = 203 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005217s ]
[ SQL ] SHOW COLUMNS FROM `sgb_doctors` [ RunTime:0.006798s ]
[ 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 '%,1249,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.008088s ]
[ 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` = 1249 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005218s ]
[ 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` = 1249 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005156s ]
[ 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` = 1249 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005166s ]
[ 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` = 1249 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005250s ]
[ 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` = 1249 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005143s ]
[ 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` = 1249 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005263s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 203 LIMIT 1 [ RunTime:0.005048s ]
[ SQL ] SHOW COLUMNS FROM `sgb_pictures` [ RunTime:0.005970s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 1249 ORDER BY `sort` ASC [ RunTime:0.005190s ]
[ 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 '%,1249,%' [ RunTime:0.007988s ]
[ SQL ] SHOW COLUMNS FROM `sgb_comment` [ RunTime:0.006473s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (1769,1770,1771) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 1249 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005429s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 1249 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005190s ]
[ 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 '%,1041,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.008293s ]
[ 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` = 1041 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005368s ]
[ 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` = 1041 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005199s ]
[ 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` = 1041 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005130s ]
[ 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` = 1041 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005279s ]
[ 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` = 1041 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005158s ]
[ 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` = 1041 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005258s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 203 LIMIT 1 [ RunTime:0.005070s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 1041 ORDER BY `sort` ASC [ RunTime:0.005097s ]
[ 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 '%,1041,%' [ RunTime:0.007708s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (1752,1753,1754,1755,1756) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 1041 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.007784s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 1041 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005182s ]
[ 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 '%,1040,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.008132s ]
[ 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` = 1040 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005241s ]
[ 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` = 1040 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005231s ]
[ 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` = 1040 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005192s ]
[ 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` = 1040 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005251s ]
[ 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` = 1040 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005174s ]
[ 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` = 1040 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005430s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 203 LIMIT 1 [ RunTime:0.005096s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 1040 ORDER BY `sort` ASC [ RunTime:0.005012s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (1928,1929,1930) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 1040 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005313s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 1040 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005172s ]
[ 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.005158s ]
[ 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.011552s ]
[ 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.005278s ]
[ 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.005401s ]
[ 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.005306s ]
[ 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.005934s ]
[ 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.005383s ]
[ 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.005398s ]
[ 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.005180s ]
[ 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.005221s ]
[ 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.005247s ]
[ 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.005428s ]
[ SQL ] SHOW COLUMNS FROM `sgb_ad_banner` [ RunTime:0.006319s ]
[ 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.005072s ]