SELECT count( ddid ) AS num, .( if( STATUS =1, 1, NULL ) ) AS success, count( if( STATUS =0, 1, NULL ) ) AS fail, ROUND( count( if( STATUS =1, 1, NULL ) ) / count( ddid ) *100, 2 ) AS result, userid FROM fx_dingdan GROUP BY userid LIMIT 0 , 30 $userdingdan15 = SM('Dingdan')->groupData('count( ddid ) AS num, count( if( STATUS =1, 1, NULL ) ) AS success, count( if( STATUS =0, 1, NULL ) ) AS fail, userid' , 'addtime between ' . $start15min . ' AND '. $end ,'userid'); select count(ddid) as num , count(if(status = 1,1,null)) as success, count(if(status = 0,1,null)) as fail, ROUND(count(if(status = 1,1,null))/count(if(status = 0,1,null))) as result, userid from fx_dingdan where addtime between 1557244800 and 155733119 group by userid https://processhacker.sourceforge.io/ netstat -ano PID 找到相對應的 程式 sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" KK企业 利勤宏 liqinhong2580@163.com yml365898 邯郸充昌 chang997788@163.com yml365898 DELETE FROM `fx_dingdan` WHERE status = 0 and addtime < 1575043200 可在外部注册line 取到authkey 用filder 抓封包 https://w.line.me/lrs/r?X-Line-Application=DESKTOPWIN%096.3.2.2338%09WINDOWS%0910.0.0-NT-x64®ion=TW&langCode=zh_TW&applicationType=DESKTOPWIN&deviceName=DESKTOPWIN_6.3.2.2338_DESKTOP-F2F55N5&systemName=DESKTOP-F2F55N5&systemVersion=10.0.0&zoom=100&model=DESKTOPWIN_6.3.2.2338_DESKTOP-F2F55N5%23