[2025-11-01T17:16:24+08:00][sql] CONNECT:[ UseTime:0.001482s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-01T17:16:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001329s ]
[2025-11-01T17:16:24+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000260s ]
[2025-11-01T17:16:24+08:00][sql] CONNECT:[ UseTime:0.002546s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-01T17:16:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001408s ]
[2025-11-01T17:16:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` WHERE  `tw`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000409s ]
[2025-11-01T17:16:24+08:00][sql] SELECT `to`.`orderno`,`to`.`charge`,`to`.`price`,`to`.`amount`,`tw`.`id`,`tw`.`game`,`tw`.`serverid`,`tw`.`alitime`,`tw`.`withdrawtime`,`tw`.`username`,`tw`.`payuser`,`tw`.`aliname`,`tw`.`status`,`tw`.`ordertype`,`tw`.`relationid`,`tw`.`tid`,`to`.`paytime` FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` WHERE  `tw`.`game` IN ('shaiya','shaiya5') ORDER BY `tw`.`id` DESC LIMIT 0,10 [ RunTime:0.000349s ]
[2025-11-01T17:16:24+08:00][sql] SELECT IFNULL(SUM(to.price), 0) AS total_price,IFNULL(SUM(to.amount), 0) AS total_amount,IFNULL(SUM(to.charge), 0) AS total_charge FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` WHERE  `tw`.`game` IN ('shaiya','shaiya5') [ RunTime:0.000334s ]
[2025-11-01T17:16:24+08:00][sql] SELECT `tw`.`status`,IFNULL(SUM(to.amount), 0) AS no_total_amount FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` WHERE  `tw`.`game` IN ('shaiya','shaiya5')  AND `tw`.`status` IN ('-1','3') GROUP BY `tw`.`status` [ RunTime:0.000404s ]