SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'member' AND `part` = 'user' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'member' AND `part` = 'user' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'member' AND `part` = 'busi' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'member' AND `part` = 'busi' SELECT `pay_name` FROM `huoniao_site_payment` WHERE `pay_code` = 'huoniao_bonus' SELECT `pay_name` FROM `huoniao_site_payment` WHERE `pay_code` = 'huoniao_bonus' SELECT * FROM `huoniao_app_config` LIMIT 1 SELECT * FROM `huoniao_app_config` LIMIT 1 SELECT `children` FROM `huoniao_site_config` WHERE `type` = 'fabuPc' SELECT `children` FROM `huoniao_site_config` WHERE `type` = 'fabuPc' SELECT `name`, `title`, `subject`, `wx`, `bd`, `qm`, `dy`, `icon`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `state` = 0 AND `parentid` != 0 AND `type` = 0 ORDER BY `weight` ASC SELECT `name`, `title`, `subject`, `wx`, `bd`, `qm`, `dy`, `icon`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `state` = 0 AND `parentid` != 0 AND `type` = 0 ORDER BY `weight` ASC SELECT * FROM `huoniao_member_level` ORDER BY `id` ASC SELECT * FROM `huoniao_member_level` ORDER BY `id` ASC SELECT count(`id`) total FROM `huoniao_site_module` WHERE `state` = 0 AND `type` = 0 AND `name` != '' SELECT count(`id`) total FROM `huoniao_site_module` WHERE `state` = 0 AND `type` = 0 AND `name` != '' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'business' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'business' AND `part` = 'config' SELECT `icon`, `name` FROM `huoniao_site_module` WHERE `parentid` != 0 AND `state` = 0 AND `type` = 0 SELECT `icon`, `name` FROM `huoniao_site_module` WHERE `parentid` != 0 AND `state` = 0 AND `type` = 0 SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'house' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'house' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'waimai' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'waimai' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'shop' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'shop' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'renovation' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'renovation' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'tuan' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'tuan' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'live' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'live' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'dating' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'dating' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'travel' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'travel' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'education' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'education' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'homemaking' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'homemaking' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'car' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'car' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'marry' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'marry' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'huodong' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'huodong' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'pension' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'pension' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'website' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'website' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'awardlegou' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'awardlegou' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'paimai' SELECT `wx`, `bd`, `qm`, `dy`, `app`, `pc`, `h5` FROM `huoniao_site_module` WHERE `name` = 'paimai' SELECT * FROM `huoniao_domain` WHERE `domain` = 'sz' SELECT * FROM `huoniao_domain` WHERE `domain` = 'sz' SELECT `subject`, `name` FROM `huoniao_site_module` WHERE `state` = 0 AND `type` = 0 AND `name` != '' SELECT `subject`, `name` FROM `huoniao_site_module` WHERE `state` = 0 AND `type` = 0 AND `name` != '' SELECT count(`id`) totalCount FROM `huoniao_site_city` WHERE `state` = 1 SELECT count(`id`) totalCount FROM `huoniao_site_city` WHERE `state` = 1 SELECT `title`, `subject` FROM `huoniao_site_module` WHERE `name` = 'list' SELECT `title`, `subject` FROM `huoniao_site_module` WHERE `name` = 'list' SELECT `module` FROM `huoniao_domain` WHERE `domain` = 'business' SELECT `module` FROM `huoniao_domain` WHERE `domain` = 'business' SELECT * FROM `huoniao_domain` WHERE `domain` = 'business' SELECT * FROM `huoniao_domain` WHERE `domain` = 'business' SELECT `config` FROM `huoniao_site_city` WHERE `cid` = 166 SELECT `config` FROM `huoniao_site_city` WHERE `cid` = 166 SELECT `id` FROM `huoniao_site_module` WHERE `state` = 0 AND `type` = 0 AND `name` != '' SELECT `id` FROM `huoniao_site_module` WHERE `state` = 0 AND `type` = 0 AND `name` != '' SELECT `name` FROM `huoniao_site_module` WHERE `parentid` = 1 AND `state` = 0 SELECT `name` FROM `huoniao_site_module` WHERE `parentid` = 1 AND `state` = 0 SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'article' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'article' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'info' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'info' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'house' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'house' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'shop' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'shop' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'renovation' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'renovation' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'paper' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'paper' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'job' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'job' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'car' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'car' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'special' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'special' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'website' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'website' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'dating' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'dating' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'quanjing' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'quanjing' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'waimai' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'waimai' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'image' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'image' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'tieba' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'tieba' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'tuan' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'tuan' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'huodong' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'huodong' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'huangye' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'huangye' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'video' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'video' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'vote' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'vote' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'integral' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'integral' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'live' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'live' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'homemaking' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'homemaking' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'marry' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'marry' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'travel' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'travel' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'education' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'education' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'pension' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'pension' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'circle' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'circle' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'sfcar' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'sfcar' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'awardlegou' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'awardlegou' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'paimai' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'paimai' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'task' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'task' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'member' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'member' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'siteConfig' AND `part` = 'config' SELECT `domain`, `expires`, `note`, `state`, `refund` FROM `huoniao_domain` WHERE `module` = 'siteConfig' AND `part` = 'config' SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_addr` WHERE `id` = 2066 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_addr` WHERE `id` = 2066 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 37 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 37 SELECT COUNT(`id`) total FROM `huoniao_member` WHERE `mtype` = 1 AND `state` = 1 UNION SELECT COUNT(`id`) total FROM `huoniao_member` WHERE `mtype` = 2 AND `state` = 1 select COUNT(`id`) total from `huoniao_member` WHERE `mtype` = 1 AND `state` = 1 UNION select COUNT(`id`) total from `huoniao_member` WHERE `mtype` = 2 AND `state` = 1 SELECT COUNT(`id`) total FROM `huoniao_member` WHERE `online` > 0 AND `mtype` = 1 AND `state` = 1 UNION SELECT COUNT(`id`) total FROM `huoniao_member` WHERE `online` > 0 AND `mtype` = 2 AND `state` = 1 select COUNT(`id`) total from `huoniao_member` WHERE `online` > 0 AND `mtype` = 1 AND `state` = 1 UNION select COUNT(`id`) total from `huoniao_member` WHERE `online` > 0 AND `mtype` = 2 AND `state` = 1 SELECT count(`id`) total FROM `huoniao_business_list` WHERE `state` = 1 SELECT count(`id`) total FROM `huoniao_business_list` WHERE `state` = 1 生活服务-商家标题苏州测试专用
苏州测试专用 切换城市

请选择您所在的城市:

    热门
    城市

    请先登录/注册

    为保护您的隐私,验证手机号登录后将为您使用虚拟号码拨出

    为保护您的隐私,请先绑定手机

    验证后将为您使用虚拟号码拨出

    验证手机号

    为保护您的隐私,请先验证手机号,我们将为您使用虚拟号码拨出

    请使用{{userPhone}}

    为保护用户隐私,当前仅可通过{{userRealPhone}}拨打对方号码,其他手机将无法拨通

    使用其他手机号拨打
    拨打 我们将为您使用虚拟号码拨出

    为保护用户隐私,当前仅可通过{{userRealPhone}}拨打对方号码,其他手机将无法拨通

    使用其他手机号拨打

    您还可以扫码一键拨打 ,免输入

    热门搜索: SELECT `privilege` FROM `huoniao_member_level` ORDER BY `id` ASC limit 0,1 SELECT `privilege` FROM `huoniao_member_level` ORDER BY `id` ASC limit 0,1 SELECT `keyword`, `color`, `href`, `blod`, `module`, `target` FROM `huoniao_site_hotkeywords` WHERE `state` = 0 AND `module` = 'index' AND `cityid` = 166 ORDER BY `weight` DESC, `id` DESC SELECT `keyword`, `color`, `href`, `blod`, `module`, `target` FROM `huoniao_site_hotkeywords` WHERE `state` = 0 AND `module` = 'index' AND `cityid` = 166 ORDER BY `weight` DESC, `id` DESC 实习生 二手 咖啡 大牌美食

    客服热线

    0512-67581578
      SELECT count(`id`) FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' AND l.`addrid` in (2066,14220,14235,14234,14233,14232,14231,14230,14229,14228,14227,14226,14225,14224,14223,14222,14221,14236) AND l.`typeid` in (37,38,39,40,41,42,43,44,45,127,128,129,130,175) SELECT count(`id`) FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' AND l.`addrid` in (2066,14220,14235,14234,14233,14232,14231,14230,14229,14228,14227,14226,14225,14224,14223,14222,14221,14236) AND l.`typeid` in (37,38,39,40,41,42,43,44,45,127,128,129,130,175) SELECT l.`id`, l.`uid`, l.`isbid`, l.`title`, l.`logo`, l.`typeid`, l.`addrid`, l.`address`, l.`lng`, l.`lat`, l.`wechatname`, l.`wechatcode`, l.`wechatqr`, l.`tel`, l.`qq`,l.`landmark`, l.`email`, l.`pics`, l.`license`, l.`opentime`, l.`openweek`, l.`opentimes`, l.`amount`, l.`parking`, l.`authattr`, l.`pubdate`, l.`type`, l.`qj_file`, l.`video`, l.`banner`, (SELECT COUNT(`id`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1) AS popularity, (SELECT avg(`sco1`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1 AND `pid` = 0) AS praise FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' AND l.`addrid` in (2066,14220,14235,14234,14233,14232,14231,14230,14229,14228,14227,14226,14225,14224,14223,14222,14221,14236) AND l.`typeid` in (37,38,39,40,41,42,43,44,45,127,128,129,130,175) ORDER BY l.isbid DESC, l.`id` DESC LIMIT 0, 10 SELECT l.`id`, l.`uid`, l.`isbid`, l.`title`, l.`logo`, l.`typeid`, l.`addrid`, l.`address`, l.`lng`, l.`lat`, l.`wechatname`, l.`wechatcode`, l.`wechatqr`, l.`tel`, l.`qq`,l.`landmark`, l.`email`, l.`pics`, l.`license`, l.`opentime`, l.`openweek`, l.`opentimes`, l.`amount`, l.`parking`, l.`authattr`, l.`pubdate`, l.`type`, l.`qj_file`, l.`video`, l.`banner`, (SELECT COUNT(`id`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1) AS popularity, (SELECT avg(`sco1`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1 AND `pid` = 0) AS praise FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' AND l.`addrid` in (2066,14220,14235,14234,14233,14232,14231,14230,14229,14228,14227,14226,14225,14224,14223,14222,14221,14236) AND l.`typeid` in (37,38,39,40,41,42,43,44,45,127,128,129,130,175) ORDER BY l.isbid DESC, l.`id` DESC LIMIT 0, 10 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125807 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125807 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 41 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 41 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14230 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14230 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 2066 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 2066 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 166 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 166 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 10 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 10 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 27 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 27 SELECT `jc`, `typename` FROM `huoniao_business_authattr` WHERE `id` = 1 SELECT `jc`, `typename` FROM `huoniao_business_authattr` WHERE `id` = 1 SELECT `jc`, `typename` FROM `huoniao_business_authattr` WHERE `id` = 2 SELECT `jc`, `typename` FROM `huoniao_business_authattr` WHERE `id` = 2 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 27 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 27 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 27 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 27 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 5 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 5 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125901 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125901 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125904 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125904 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125902 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125902 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125903 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125903 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 27 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 27 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 27 AND `sco1` = 5 AND `pid` = 0 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125795 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125795 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14223 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14223 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 22 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 22 SELECT `jc`, `typename` FROM `huoniao_business_authattr` WHERE `id` = 3 SELECT `jc`, `typename` FROM `huoniao_business_authattr` WHERE `id` = 3 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 22 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 22 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 22 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 22 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 10 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 10 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125883 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125883 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125881 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125881 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125882 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125882 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125884 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125884 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 22 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 22 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 22 AND `sco1` = 5 AND `pid` = 0
    热门推荐
    SELECT count(`id`) FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' SELECT count(`id`) FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' SELECT l.`id`, l.`uid`, l.`isbid`, l.`title`, l.`logo`, l.`typeid`, l.`addrid`, l.`address`, l.`lng`, l.`lat`, l.`wechatname`, l.`wechatcode`, l.`wechatqr`, l.`tel`, l.`qq`,l.`landmark`, l.`email`, l.`pics`, l.`license`, l.`opentime`, l.`openweek`, l.`opentimes`, l.`amount`, l.`parking`, l.`authattr`, l.`pubdate`, l.`type`, l.`qj_file`, l.`video`, l.`banner`, (SELECT COUNT(`id`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1) AS popularity, (SELECT avg(`sco1`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1 AND `pid` = 0) AS praise FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' ORDER BY popularity DESC, l.isbid DESC, l.`id` DESC LIMIT 0, 5 SELECT l.`id`, l.`uid`, l.`isbid`, l.`title`, l.`logo`, l.`typeid`, l.`addrid`, l.`address`, l.`lng`, l.`lat`, l.`wechatname`, l.`wechatcode`, l.`wechatqr`, l.`tel`, l.`qq`,l.`landmark`, l.`email`, l.`pics`, l.`license`, l.`opentime`, l.`openweek`, l.`opentimes`, l.`amount`, l.`parking`, l.`authattr`, l.`pubdate`, l.`type`, l.`qj_file`, l.`video`, l.`banner`, (SELECT COUNT(`id`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1) AS popularity, (SELECT avg(`sco1`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1 AND `pid` = 0) AS praise FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' ORDER BY popularity DESC, l.isbid DESC, l.`id` DESC LIMIT 0, 5 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 2 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 2 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 1 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 1 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14300 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14300 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 2074 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 2074 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 3 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 3 SELECT `jc`, `typename` FROM `huoniao_business_authattr` WHERE `id` = 4 SELECT `jc`, `typename` FROM `huoniao_business_authattr` WHERE `id` = 4 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 3 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 3 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 3 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 3 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 29 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 29 SELECT `litpic` FROM `huoniao_business_albums` WHERE `uid` = 3 ORDER BY `id` DESC LIMIT 0, 5 SELECT `litpic` FROM `huoniao_business_albums` WHERE `uid` = 3 ORDER BY `id` DESC LIMIT 0, 5 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 237488 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 237488 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 237487 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 237487 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 234618 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 234618 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 202327 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 202327 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 3 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 3 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 3 AND `sco1` = 5 AND `pid` = 0 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125784 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125784 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 38 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 38 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14272 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14272 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 2071 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 2071 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 11 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 11 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 11 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 11 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 11 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 11 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 21 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 21 SELECT `litpic` FROM `huoniao_business_albums` WHERE `uid` = 11 ORDER BY `id` DESC LIMIT 0, 5 SELECT `litpic` FROM `huoniao_business_albums` WHERE `uid` = 11 ORDER BY `id` DESC LIMIT 0, 5 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 11 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 11 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 5 AND `pid` = 0 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125767 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125767 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 68 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 68 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 67 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 67 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14277 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14277 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 9 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 9 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 9 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 9 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 9 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 9 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 23 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 23 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125752 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125752 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125751 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125751 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125753 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125753 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125754 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125754 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 9 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 9 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 5 AND `pid` = 0 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 3 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 3 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 235242 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 235242 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 1107 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 1107 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 1107 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 1107 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 1107 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 1107 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 15575 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 15575 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 238286 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 238286 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 238285 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 238285 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 238287 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 238287 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 1107 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 1107 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 1107 AND `sco1` = 5 AND `pid` = 0 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 238410 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 238410 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 48 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 48 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 46 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 46 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14268 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14268 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 2070 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 2070 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 4 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 4 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 4 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 4 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 4 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 4 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 28 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 28 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125733 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125733 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125731 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125731 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125732 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125732 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125734 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125734 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 4 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 4 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 4 AND `sco1` = 5 AND `pid` = 0
    1

    随行付

    相城 渭塘镇

    2

    衣衣大亿装饰

    张家港 凤凰镇

    3

    ROCKY家山东御科

    张家港 杨舍镇

    4

    秋风簌簌晨风嘶菊残幽忧傲霜枝

    江苏 苏州测试专用

    5

    苏州雅圣尼都市花乡

    平江 桃花坞

    SELECT `id` FROM `huoniao_advlist` WHERE `title` = '商家_模板四_电脑端_广告六' ORDER BY `id` DESC LIMIT 1 SELECT `id` FROM `huoniao_advlist` WHERE `title` = '商家_模板四_电脑端_广告六' ORDER BY `id` DESC LIMIT 1 SELECT `class`, `title`, `starttime`, `endtime`, `body`, `state` FROM `huoniao_advlist` WHERE `id` = 570 SELECT `class`, `title`, `starttime`, `endtime`, `body`, `state` FROM `huoniao_advlist` WHERE `id` = 570 SELECT `body` FROM `huoniao_advlist_city` WHERE `aid` = 570 AND `cityid` = 166 SELECT `body` FROM `huoniao_advlist_city` WHERE `aid` = 570 AND `cityid` = 166
    广告
    最新入驻
    SELECT count(`id`) FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' SELECT count(`id`) FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' SELECT l.`id`, l.`uid`, l.`isbid`, l.`title`, l.`logo`, l.`typeid`, l.`addrid`, l.`address`, l.`lng`, l.`lat`, l.`wechatname`, l.`wechatcode`, l.`wechatqr`, l.`tel`, l.`qq`,l.`landmark`, l.`email`, l.`pics`, l.`license`, l.`opentime`, l.`openweek`, l.`opentimes`, l.`amount`, l.`parking`, l.`authattr`, l.`pubdate`, l.`type`, l.`qj_file`, l.`video`, l.`banner`, (SELECT COUNT(`id`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1) AS popularity, (SELECT avg(`sco1`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1 AND `pid` = 0) AS praise FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' ORDER BY l.isbid DESC, l.`id` DESC LIMIT 0, 5 SELECT l.`id`, l.`uid`, l.`isbid`, l.`title`, l.`logo`, l.`typeid`, l.`addrid`, l.`address`, l.`lng`, l.`lat`, l.`wechatname`, l.`wechatcode`, l.`wechatqr`, l.`tel`, l.`qq`,l.`landmark`, l.`email`, l.`pics`, l.`license`, l.`opentime`, l.`openweek`, l.`opentimes`, l.`amount`, l.`parking`, l.`authattr`, l.`pubdate`, l.`type`, l.`qj_file`, l.`video`, l.`banner`, (SELECT COUNT(`id`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1) AS popularity, (SELECT avg(`sco1`) FROM `huoniao_public_comment_all` c WHERE c.`aid` = l.`id` AND c.`type` = 'business' AND `ischeck` = 1 AND `pid` = 0) AS praise FROM `huoniao_business_list` l WHERE l.`state` = 1 AND (l.`expired` = 0 || l.`expired` > 1738993798) AND l.`cityid` = 166 AND l.`cityid` != 0 AND l.`pstate` = 1 AND l.`title` != '' ORDER BY l.isbid DESC, l.`id` DESC LIMIT 0, 5 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 32 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 32 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 31 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 31 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 2859 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 2859 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 2859 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 2859 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 2859 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 2859 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 37095 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 37095 SELECT `litpic` FROM `huoniao_business_albums` WHERE `uid` = 2859 ORDER BY `id` DESC LIMIT 0, 5 SELECT `litpic` FROM `huoniao_business_albums` WHERE `uid` = 2859 ORDER BY `id` DESC LIMIT 0, 5 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 2859 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 2859 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 2859 AND `sco1` = 5 AND `pid` = 0 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125785 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125785 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 44 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 44 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14270 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14270 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 12 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 12 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 12 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 12 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 12 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 12 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 20 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 20 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125841 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125841 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125843 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125843 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125842 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125842 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125844 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125844 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 12 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 12 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 12 AND `sco1` = 5 AND `pid` = 0 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 21 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 21 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 11 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 11 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 11 AND `sco1` = 5 AND `pid` = 0 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 23 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 23 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 9 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 9 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 9 AND `sco1` = 5 AND `pid` = 0 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125766 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125766 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 62 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 62 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 61 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_business_type` WHERE `id` = 61 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14316 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 14316 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 2077 SELECT `id`, `parentid`, `typename`, `weight` FROM `huoniao_site_area` WHERE `id` = 2077 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 8 SELECT `id` FROM `huoniao_site_pay_phone` WHERE `module` = 'business' AND `temp` = 'detail' AND `uid` = '-1' AND `aid` = 8 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 8 SELECT `id` FROM `huoniao_business_panor` WHERE `uid` = 8 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 8 SELECT `id` FROM `huoniao_business_video` WHERE `uid` = 8 SELECT * FROM `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 24 select CONVERT(AES_DECRYPT(UNHEX(realname), 'huoniao_kumanyun') USING utf8mb4) as `realname`,CONVERT(AES_DECRYPT(UNHEX(idcard), 'huoniao_kumanyun') USING utf8mb4) as `idcard`,CONVERT(AES_DECRYPT(UNHEX(email), 'huoniao_kumanyun') USING utf8mb4) as `email`,CONVERT(AES_DECRYPT(UNHEX(phone), 'huoniao_kumanyun') USING utf8mb4) as `phone`,CONVERT(AES_DECRYPT(UNHEX(address), 'huoniao_kumanyun') USING utf8mb4) as `address` ,`id`,`mtype`,`username`,`password`,`level`,`expired`,`last_level`,`last_expired`,`discount`,`nickname`,`nickname_audit`,`nickname_state`,`idcardFront`,`idcardBack`,`certifyState`,`certifyInfo`,`emailCheck`,`sendEmail`,`areaCode`,`phoneCheck`,`phoneBindTime`,`sendPhone`,`paypwd`,`paypwdCheck`,`qq`,`photo`,`photo_audit`,`photo_state`,`sex`,`birthday`,`mgroupid`,`company`,`cityid`,`addr`,`license`,`licenseState`,`licenseInfo`,`regtime`,`regip`,`regipaddr`,`money`,`freeze`,`point`,`bonus`,`promotion`,`recid`,`recfan`,`rectime`,`online`,`tempbg`,`pctempbg`,`mtempbgurl`,`state`,`stateinfo`,`regfrom`,`logincount`,`lastlogintime`,`lastloginip`,`lastloginipaddr`,`qq_conn`,`sina_conn`,`baidu_conn`,`alipay_conn`,`tqq_conn`,`renren_conn`,`douban_conn`,`facebook_conn`,`wechat_conn`,`wechat_openid`,`wechat_mini_openid`,`wechat_mini_session`,`douyin_conn`,`douyin_openid`,`expired_notify_day`,`expired_notify_week`,`expired_notify_month`,`purviews`,`sourceclient`,`from_uid`,`alicard`,`notice`,`lng`,`lat`,`wechat_subscribe`,`delivery_count`,`is_cancellation`,`description`,`is_editname`,`noawardlegoutime`,`is_noawardlegou`,`hidePackage`,`sortPackage`,`lock_cityid`,`im_unread_count`,`robot`,`access_token_wxmini`,`refresh_token_wxmini`,`access_token_android`,`refresh_token_android`,`access_token_ios`,`refresh_token_ios`,`access_token_harmony`,`refresh_token_harmony`,`nation`,`admin_common_module`,`admin_common_function`,`admin_collection_function`,`access_token_dymini`,`refresh_token_dymini`,`zhaopin_company`,`zhaopin_resume` from `huoniao_member` WHERE `state` = 1 AND `mtype` != 0 AND `mtype` != 3 AND `id` = 24 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125749 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125749 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125748 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125748 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125747 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125747 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125750 SELECT `id`, `path` FROM `huoniao_attachment` WHERE `id` = 125750 SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 8 AND `pid` = 0 AND `type` = 'business' SELECT avg(`rating`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `aid` = 8 AND `pid` = 0 AND `type` = 'business' SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `pid` = 0 SELECT avg(`sco1`) r, count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `sco1` = 1 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `sco1` = 2 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `sco1` = 3 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `sco1` = 4 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `sco1` = 5 AND `pid` = 0 SELECT count(`id`) c FROM `huoniao_public_comment_all` WHERE `ischeck` = 1 AND `type` = 'business' AND `aid` = 8 AND `sco1` = 5 AND `pid` = 0

    随行付

    0.0

    衣品居元素

    5.0

    衣衣大亿装饰

    4.7

    ROCKY家山东御科

    4.0

    小胡子新华保险

    0.0

    收银台

    订单总价0.00

    剩余支付时间:000000

    手机扫码支付

    使用支付宝、微信扫码支付

    余额(可用: ¥)
    为了您的账户安全,请尽快设置支付密码 去设置
    SELECT `id`, `pay_code`, `pay_name`, `pay_desc` FROM `huoniao_site_payment` WHERE `state` = 1 ORDER BY `weight`, `id` DESC SELECT `id`, `pay_code`, `pay_name`, `pay_desc` FROM `huoniao_site_payment` WHERE `state` = 1 ORDER BY `weight`, `id` DESC
    其他支付方式