[ DB ] CONNECT:[ UseTime:0.000583s ] mysql:host=192.168.192.212;dbname=offcn_zwk2019;charset=utf8
[ SQL ] SHOW COLUMNS FROM `offcn_gj2023` [ RunTime:0.001238s ]
[ SQL ] SELECT `type` FROM `offcn_gj2023` WHERE `areaname` = '黑龙江' GROUP BY `type` [ RunTime:0.003286s ]
[ SQL ] SHOW COLUMNS FROM `offcn_zhiwei_gk` [ RunTime:0.000877s ]
[ SQL ] SELECT `zwval` FROM `offcn_zhiwei_gk` WHERE `zwkey` = 'gj2023_jzb_zwtongjibm' LIMIT 1 [ RunTime:0.000438s ]
[ SQL ] SELECT * FROM `offcn_gj2023` WHERE `areaname` = '黑龙江' GROUP BY `bumen_name` [ RunTime:0.006860s ]
[ 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_gj2023` WHERE `areaname` = '黑龙江' GROUP BY `bumen_name` ORDER BY (sum(hgrs)+0.00)/sum(zkrs) desc LIMIT 15,15 [ RunTime:0.006461s ]
京公网安备 11010802020593号 出版物经营许可证新出发京批字第直130052号
