注册 / 登录
SELECT `id`, `code`, `name` FROM `huoniao_site_loginconnect` WHERE `state` = 1 ORDER BY `weight`, `id`
SELECT `id`, `code`, `name` FROM `huoniao_site_loginconnect` WHERE `state` = 1 ORDER BY `weight`, `id`
热门搜索:
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
实习生二手咖啡大牌美食
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
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
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