[ DB ] CONNECT:[ UseTime:0.000569s ] mysql:host=192.168.192.212;dbname=offcn_zwk2019;charset=utf8
[ SQL ] SHOW COLUMNS FROM `offcn_gj2024` [ RunTime:0.000991s ]
[ SQL ] SELECT `type` FROM `offcn_gj2024` WHERE `areaname` = '江西' GROUP BY `type` [ RunTime:0.002284s ]
[ SQL ] SHOW COLUMNS FROM `offcn_zhiwei_gk` [ RunTime:0.000754s ]
[ SQL ] SELECT `zwval` FROM `offcn_zhiwei_gk` WHERE `zwkey` = 'gj2024_zkrs_zwtongjibm' LIMIT 1 [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `offcn_gj2024` WHERE `areaname` = '江西' AND `type` = '中央党群机关' GROUP BY `bumen_name` [ RunTime:0.001642s ]
[ 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_gj2024` WHERE `areaname` = '江西' AND `type` = '中央党群机关' GROUP BY `bumen_name` ORDER BY `zkrs` DESC LIMIT 0,15 [ RunTime:0.001478s ]