[8] Undefined variable: var /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/8c7a6aec22ddf3e7d26e4cea2a949046.php 第 727 行.
SELECT user.id,user.user,user.logo,user.jc,user.qc,user.case_count,company.comment_score,company.is_show,q.bm,company.text as jianjie,a.qz_area FROM qz_user user INNER JOIN qz_user_company as company on company.userid = user.id left join qz_quyu q ON q.cid = user.cs left join qz_area a ON a.qz_areaid = user.qx WHERE user.id = '305314' LIMIT 1 [ RunTime:0.0006s ]
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 tt.*,count(ce.id) as dcount2,case when count(ce.id) > 0 or tt.cooperate_mode2 = 2 then 2 else 1 end as cooperate_mode FROM ( SELECT t.id,t.classid,t.on,t.chengli,t.cs,t.qx,t.cityname,t.area_name,t.qc,t.jc,t.kouhao,t.img_host,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_mode2 FROM ( SELECT a.id,a.classid,a.on,a.cs,a.qx,e.cname as cityname,z.qz_area as area_name,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.cooperate_mode as cooperate_mode2 FROM qz_user a left join qz_user_company as b on a.id = b.userid inner join qz_quyu as e on e.cid = a.cs left join qz_area as z on a.qx = z.qz_areaid WHERE a.id = '305314' AND a.classid IN (3,6) AND a.cs = '532503' ) 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 ) tt LEFT JOIN qz_user_company_employee ce on ce.company_id = tt.id and ce.state = 1 and ce.position in (2,3,4) ) t2 LEFT JOIN qz_comment as g on g.comid = t2.id and g.isveritfy = 0 [ RunTime:0.0158s ]
SHOW COLUMNS FROM `qz_company_branchstore` [ RunTime:0.0010s ]
SELECT id as hid,`shortname`,tel as htel,`addr`,qq as qq3,qq1 as qq4,nickname as nickname2,nickname1 as nickname3 FROM qz_company_branchstore WHERE `comid` = '305314' LIMIT 1 [ RunTime:0.0020s ]
SHOW COLUMNS FROM `qz_user_company_rank` [ RunTime:0.0010s ]
SELECT `ping`,`haoping` FROM qz_user_company_rank WHERE `comid` = '305314' AND `day` BETWEEN '2025-07-06' AND '2025-08-06' ORDER BY day desc LIMIT 1 [ RunTime:0.0003s ]
SELECT biz_id as id,`name` FROM qz_base_deco_config WHERE `biz_id` BETWEEN '10' AND '15' AND `is_delete` = '0' AND `type` = 'huxing' ORDER BY sort [ RunTime:0.0003s ]
SELECT biz_id as id,`name` FROM qz_base_deco_config WHERE `is_delete` = '0' AND `type` = 'leixing' ORDER BY sort [ RunTime:0.0003s ]
SELECT COUNT(*) AS tp_count FROM qz_cases WHERE `cs` = '532503' AND `uid` = '305314' AND `status` = 2 AND `isdelete` IN (1,3) AND `on` = 1 AND `classid` IN ('1') AND `huxing` = '11' LIMIT 1 [ RunTime:0.0023s ]
服务器主机名 : 9e01f7eb2f03
服务器系统 : Linux 9e01f7eb2f03 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64