SELECT t3.*,h.id as hid,h.shortname,h.tel as htel,h.addr,h.qq as qq3,h.qq1 as qq4,h.nickname as nickname2,h.nickname1 as nickname3 FROM ( SELECT t2.*,count(g.id) as ccount,count(IF(g.sj <>0,g.id,null)) as newcount,count(IF(g.sj =0,g.id,null)) as oldcount,count(IF(g.count>=9 and g.sj = 0,g.count,null)) as oldgood,count(IF(g.sj>=9 and g.fw>=9 and g.sg >=9,g.id,null)) as good,avg(IF(g.sj<>0,g.sj,null)) avgsj,avg(IF(g.fw<>0,g.fw,null)) avgfw,avg(IF(g.sg<>0,g.sg,null)) avgsg,avg(IF(g.sj=0,g.count,null)) avgcount FROM ( SELECT t1.*,0 as dcount FROM ( SELECT t.id,t.on,t.chengli,t.cs,t.qc,t.jc,t.kouhao,t.img_host,t.img,t.logo,t.video,t.pv,t.jianjie,t.jiawei,t.fake,t.nickname,t.nickname1,t.hengfu,t.qq,t.qq1,t.cal,t.cals,t.dz,t.tel,t.casecount,GROUP_CONCAT(DISTINCT c.qz_area ORDER BY c.qz_areaid) as area,GROUP_CONCAT(DISTINCT d.name order by d.sort DESC) as fw,GROUP_CONCAT(DISTINCT e.name order by e.sort ) as fg,f.name as gm,t.cooperate_mode FROM ( SELECT a.id,a.on,a.cs,a.qc,a.jc,a.kouhao,a.logo,a.pv,a.video,a.qq,a.qq1,a.cal,a.cals,a.dz,a.tel,a.case_count as casecount,b.text as jianjie,b.jiawei,b.fuwu,b.fengge,b.quyu,b.fake,b.nickname,b.nickname1,b.hengfu,b.guimo,b.chengli,b.img_host,b.img,b.cooperate_mode FROM qz_user a left join qz_user_company as b on a.id = b.userid WHERE a.id = '245247' AND a.classid IN (3,6) AND a.cs = '500151' ) t LEFT JOIN qz_area as c on FIND_IN_SET(c.qz_areaid,t.quyu) LEFT JOIN qz_base_deco_config as d on FIND_IN_SET(d.biz_id,t.fuwu) and d.type = 'leixing' LEFT JOIN qz_base_deco_config as e on FIND_IN_SET(e.biz_id,t.fengge) and e.type = 'fengge' LEFT JOIN qz_base_deco_config as f on f.biz_id = t.guimo and f.type = 'guimo' GROUP BY t.id ) t1 ) t2 LEFT JOIN qz_comment as g on g.comid = t2.id ) t3 LEFT JOIN qz_company_branchstore as h on h.comid = t3.id [ RunTime:0.0267s ]
SELECT `is_show` FROM qz_user user INNER JOIN qz_user_company as company on company.userid = user.id WHERE user.id = '245247' LIMIT 1 [ RunTime:0.0005s ]
SELECT t3.*,h.id as hid,h.shortname,h.tel as htel,h.addr,h.qq as qq3,h.qq1 as qq4,h.nickname as nickname2,h.nickname1 as nickname3 FROM ( SELECT t2.*,count(g.id) as ccount,count(IF(g.sj <>0,g.id,null)) as newcount,count(IF(g.sj =0,g.id,null)) as oldcount,count(IF(g.count>=9 and g.sj = 0,g.count,null)) as oldgood,count(IF(g.sj>=9 and g.fw>=9 and g.sg >=9,g.id,null)) as good,avg(IF(g.sj<>0,g.sj,null)) avgsj,avg(IF(g.fw<>0,g.fw,null)) avgfw,avg(IF(g.sg<>0,g.sg,null)) avgsg,avg(IF(g.sj=0,g.count,null)) avgcount FROM ( SELECT t1.*,0 as dcount FROM ( SELECT t.id,t.on,t.chengli,t.cs,t.qc,t.jc,t.kouhao,t.img_host,t.img,t.logo,t.video,t.pv,t.jianjie,t.jiawei,t.fake,t.nickname,t.nickname1,t.hengfu,t.qq,t.qq1,t.cal,t.cals,t.dz,t.tel,t.casecount,GROUP_CONCAT(DISTINCT c.qz_area ORDER BY c.qz_areaid) as area,GROUP_CONCAT(DISTINCT d.name order by d.sort DESC) as fw,GROUP_CONCAT(DISTINCT e.name order by e.sort ) as fg,f.name as gm,t.cooperate_mode FROM ( SELECT a.id,a.on,a.cs,a.qc,a.jc,a.kouhao,a.logo,a.pv,a.video,a.qq,a.qq1,a.cal,a.cals,a.dz,a.tel,a.case_count as casecount,b.text as jianjie,b.jiawei,b.fuwu,b.fengge,b.quyu,b.fake,b.nickname,b.nickname1,b.hengfu,b.guimo,b.chengli,b.img_host,b.img,b.cooperate_mode FROM qz_user a left join qz_user_company as b on a.id = b.userid WHERE a.id = '245247' AND a.classid IN (3,6) AND a.cs = '500151' ) t LEFT JOIN qz_area as c on FIND_IN_SET(c.qz_areaid,t.quyu) LEFT JOIN qz_base_deco_config as d on FIND_IN_SET(d.biz_id,t.fuwu) and d.type = 'leixing' LEFT JOIN qz_base_deco_config as e on FIND_IN_SET(e.biz_id,t.fengge) and e.type = 'fengge' LEFT JOIN qz_base_deco_config as f on f.biz_id = t.guimo and f.type = 'guimo' GROUP BY t.id ) t1 ) t2 LEFT JOIN qz_comment as g on g.comid = t2.id ) t3 LEFT JOIN qz_company_branchstore as h on h.comid = t3.id [ RunTime:0.0260s ]
SELECT t.*,c.img,c.img_host FROM ( SELECT t.id,t.on,t.luxian,t.chengli,t.cs,t.qc,t.kouhao,t.logo,t.video,t.pv,t.jianjie,t.jiawei,t.fake,t.nickname,t.nickname1,t.hengfu,t.qq,t.qq1,t.cal,t.cals,t.dz,t.tel,t.casecount,GROUP_CONCAT(DISTINCT c.qz_area ORDER BY c.qz_areaid) as area,GROUP_CONCAT(DISTINCT d.name order by d.sort DESC) as fw,GROUP_CONCAT(DISTINCT e.name order by e.sort ) as fg,f.name as gm FROM ( SELECT a.id,a.on,a.cs,a.qc,a.kouhao,a.logo,a.pv,a.video,a.qq,a.qq1,a.cal,a.cals,a.dz,a.tel,a.case_count as casecount,b.text as jianjie,b.jiawei,b.fuwu,b.fengge,b.quyu,b.fake,b.nickname,b.nickname1,b.hengfu,b.guimo,b.chengli,b.luxian FROM qz_user a inner join qz_user_company as b on a.id = b.userid WHERE a.id = '245247' AND a.cs = '500151' ) t LEFT JOIN qz_area as c on FIND_IN_SET(c.qz_areaid,t.quyu) LEFT JOIN qz_base_deco_config as d on FIND_IN_SET(d.biz_id,t.fuwu) and d.type = 'leixing' LEFT JOIN qz_base_deco_config as e on FIND_IN_SET(e.biz_id,t.fengge) and e.type = 'fengge' LEFT JOIN qz_base_deco_config as f on f.biz_id = t.guimo and f.type = 'guimo' GROUP BY t.id ) t LEFT JOIN qz_company_img as c on c.userid = t.id [ RunTime:0.0257s ]
SELECT r.tag FROM qz_company_tags t INNER JOIN qz_company_relation_tag as r on r.id = t.tag WHERE t.company_id = '245247' AND r.tag_mode = 1 ORDER BY r.id DESC [ RunTime:0.0004s ]
服务器主机名 : 390228c59823
服务器系统 : Linux 390228c59823 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64