[ DB ] CONNECT:[ UseTime:0.007993s ] mysql:host=172.16.242.17;port=3306;dbname=bangivf;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `sgb_category` [ RunTime:0.006442s ]
[ 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.005151s ]
[ SQL ] SHOW COLUMNS FROM `sgb_tdks_cate` [ RunTime:0.005810s ]
[ 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.005248s ]
[ SQL ] SHOW COLUMNS FROM `sgb_districts` [ RunTime:0.006227s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `parent_id` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.005335s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `web_url` = 'zhongguo' LIMIT 1 [ RunTime:0.005084s ]
[ 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.005347s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `web_url` = 'guangxi' LIMIT 1 [ RunTime:0.005043s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `parent_id` = 109 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.005254s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `web_url` = 'yulin' LIMIT 1 [ RunTime:0.005079s ]
[ SQL ] SHOW COLUMNS FROM `sgb_hospitals` [ RunTime:0.006957s ]
[ 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` = 235 AND `b`.`cate_id` = 248 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005328s ]
[ 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` = 235 AND `b`.`cate_id` = 248 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005250s ]
[ 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` = 235 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.005213s ]
[ 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` = 235 AND `b`.`cate_id` = 249 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005294s ]
[ 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` = 235 AND `b`.`cate_id` = 249 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005239s ]
[ 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` = 235 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.005273s ]
[ 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` = 235 AND `b`.`cate_id` = 250 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005166s ]
[ 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` = 235 AND `b`.`cate_id` = 250 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005150s ]
[ 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` = 235 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.005152s ]
[ 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` = 235 AND `b`.`cate_id` = 252 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005216s ]
[ 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` = 235 AND `b`.`cate_id` = 252 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005260s ]
[ 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` = 235 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.005283s ]
[ 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` = 235 AND `b`.`cate_id` = 253 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005239s ]
[ 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` = 235 AND `b`.`cate_id` = 253 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005171s ]
[ 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` = 235 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.005192s ]
[ 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` = 235 AND `b`.`cate_id` = 254 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005260s ]
[ 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` = 235 AND `b`.`cate_id` = 254 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005236s ]
[ 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` = 235 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.005277s ]
[ 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` = 235 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005154s ]
[ 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` = 235 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005191s ]
[ 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` = 235 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005153s ]
[ 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` = 235 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005054s ]
[ 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` = 235 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005185s ]
[ 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` = 235 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`.`price` BETWEEN 100000 AND 149999 AND `a`.`city_id` = 235 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005164s ]
[ 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` = 235 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005080s ]
[ 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` = 235 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005129s ]
[ 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` = 235 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005127s ]
[ 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` = 235 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005233s ]
[ 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` = 235 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005147s ]
[ 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` = 235 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005178s ]
[ 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` = 235 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.005129s ]
[ 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` = 235 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005100s ]
[ 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` = 235 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005136s ]
[ 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` = 235 GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,10 [ 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`.`status` = 1 AND `a`.`isDel` = 0 AND `a`.`city_id` = 235 AND `a`.`display_setting` LIKE '%1%' AND `a`.`tenants` LIKE '%,1,%' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.005163s ]
[ SQL ] SHOW COLUMNS FROM `sgb_doctors` [ RunTime:0.006686s ]
[ 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 '%,328,%' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.008130s ]
[ 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` = 328 AND `a`.`objType` = 'HOSTJ' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005305s ]
[ 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` = 328 AND `a`.`objType` = 'HOSACTIVE' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,1 [ RunTime:0.005172s ]
[ 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` = 328 AND `a`.`objType` = 'HOSFW' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.005200s ]
[ 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` = 328 AND `a`.`objType` = 'HOSTS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,2 [ RunTime:0.005249s ]
[ 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` = 328 AND `a`.`objType` = 'HOSJS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,4 [ RunTime:0.005242s ]
[ 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` = 328 AND `a`.`objType` = 'HOSYS' GROUP BY `a`.`id` ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.005396s ]
[ SQL ] SELECT * FROM `sgb_districts` WHERE `id` = 235 LIMIT 1 [ RunTime:0.005025s ]
[ SQL ] SHOW COLUMNS FROM `sgb_pictures` [ RunTime:0.005969s ]
[ SQL ] SELECT `image` FROM `sgb_pictures` WHERE `obj_type` = 3 AND `obj_id` = 328 ORDER BY `sort` ASC [ RunTime:0.005158s ]
[ 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 '%,328,%' [ RunTime:0.007619s ]
[ SQL ] SHOW COLUMNS FROM `sgb_comment` [ RunTime:0.006161s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE ( ( `topic_id` IN (1337,1338) AND `topic_type` = 'DOC' AND `parent_id` = 0 AND `status` = 1 ) OR ( `topic_id` = 328 AND `topic_type` = 'HOS' AND `parent_id` = 0 AND `status` = 1 ) ) ORDER BY `agree_num` DESC,`comment_time` DESC [ RunTime:0.005346s ]
[ SQL ] SELECT * FROM `sgb_comment` WHERE `status` = 1 AND `display_status` = 1 AND `topic_id` = 328 AND `topic_type` = 'HOS' AND `parent_id` = 0 ORDER BY agree_num desc,comment_time desc LIMIT 0,4 [ RunTime:0.005241s ]
[ 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.005153s ]
[ 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.008692s ]
[ 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.005301s ]
[ 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.005483s ]
[ 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.005428s ]
[ 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.005395s ]
[ 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.006024s ]
[ 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.005503s ]
[ 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.005284s ]
[ 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.005261s ]
[ 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.005230s ]
[ 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.005434s ]
[ SQL ] SHOW COLUMNS FROM `sgb_ad_banner` [ RunTime:0.006247s ]
[ 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.005192s ]