[ DB ] CONNECT:[ UseTime:0.000496s ] mysql:host=192.168.192.212;dbname=offcn_zwk2019;charset=utf8
[ SQL ] SHOW COLUMNS FROM `offcn_gj2021` [ RunTime:0.000728s ]
[ SQL ] SELECT `type` FROM `offcn_gj2021` WHERE `areaname` = '广西' GROUP BY `type` [ RunTime:0.002186s ]
[ SQL ] SHOW COLUMNS FROM `offcn_zhiwei_gk` [ RunTime:0.000700s ]
[ SQL ] SELECT `zwval` FROM `offcn_zhiwei_gk` WHERE `zwkey` = 'gj2021_jzb_zwtongjibm' LIMIT 1 [ RunTime:0.000627s ]
[ SQL ] SELECT id,department_id,areaname,yrsj,zhiwei_name,bumen_name,bumen_code,count(id) total,sum(zkrs) zkrs,sum(bkrs) bkrs,sum(hgrs) hgrs,sum(jzb) jzb,sum(click) click FROM `offcn_gj2021` WHERE `areaname` = '广西' GROUP BY `bumen_name` ORDER BY (sum(hgrs)+0.00)/sum(zkrs) asc LIMIT 15,15 [ RunTime:0.003603s ]
京公网安备 11010802020593号 出版物经营许可证新出发京批字第直130052号
