[2025-12-10T11:51:48+08:00][sql] CONNECT:[ UseTime:0.010423s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:51:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001414s ]
[2025-12-10T11:51:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000318s ]
[2025-12-10T11:51:48+08:00][sql] SELECT * FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000259s ]
[2025-12-10T11:51:53+08:00][sql] CONNECT:[ UseTime:0.010964s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:51:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001404s ]
[2025-12-10T11:51:53+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000327s ]
[2025-12-10T11:51:53+08:00][sql] CONNECT:[ UseTime:0.011242s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:51:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001417s ]
[2025-12-10T11:51:53+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.000432s ]
[2025-12-10T11:51:53+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.000436s ]
[2025-12-10T11:51:53+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.000331s ]
[2025-12-10T11:51:53+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.000444s ]
[2025-12-10T11:52:00+08:00][sql] CONNECT:[ UseTime:0.010918s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:52:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001395s ]
[2025-12-10T11:52:00+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000261s ]
[2025-12-10T11:52:00+08:00][sql] CONNECT:[ UseTime:0.010958s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:52:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001401s ]
[2025-12-10T11:52:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000571s ]
[2025-12-10T11:52:00+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000354s ]
[2025-12-10T11:52:00+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001001s ]
[2025-12-10T11:52:00+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (149,148,147,143,139,138,137,136,135) [ RunTime:0.000275s ]
[2025-12-10T11:52:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001056s ]
[2025-12-10T11:52:39+08:00][sql] CONNECT:[ UseTime:0.001483s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:52:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001604s ]
[2025-12-10T11:52:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000579s ]
[2025-12-10T11:52:39+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000404s ]
[2025-12-10T11:52:39+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001132s ]
[2025-12-10T11:52:39+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (149,148,147,143,139,138,137,136,135) [ RunTime:0.000367s ]
[2025-12-10T11:52:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001147s ]
[2025-12-10T11:52:40+08:00][sql] CONNECT:[ UseTime:0.010843s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:52:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001447s ]
[2025-12-10T11:52:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000567s ]
[2025-12-10T11:52:40+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000359s ]
[2025-12-10T11:52:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001040s ]
[2025-12-10T11:52:40+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (149,148,147,143,139,138,137,136,135) [ RunTime:0.000317s ]
[2025-12-10T11:52:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001005s ]
[2025-12-10T11:52:42+08:00][sql] CONNECT:[ UseTime:0.011137s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:52:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001354s ]
[2025-12-10T11:52:42+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000266s ]
[2025-12-10T11:52:42+08:00][sql] CONNECT:[ UseTime:0.010961s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:52:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001349s ]
[2025-12-10T11:52:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000566s ]
[2025-12-10T11:52:42+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000372s ]
[2025-12-10T11:52:42+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001010s ]
[2025-12-10T11:52:42+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (149,148,147,143,139,138,137,136,135) [ RunTime:0.000285s ]
[2025-12-10T11:52:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001009s ]
[2025-12-10T11:52:54+08:00][sql] CONNECT:[ UseTime:0.011041s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:52:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001462s ]
[2025-12-10T11:52:54+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000333s ]
[2025-12-10T11:52:54+08:00][sql] CONNECT:[ UseTime:0.011519s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:52:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001463s ]
[2025-12-10T11:52:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000564s ]
[2025-12-10T11:52:54+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000369s ]
[2025-12-10T11:52:54+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001088s ]
[2025-12-10T11:52:54+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (149,148,147,143,139,138,137,136,135) [ RunTime:0.000275s ]
[2025-12-10T11:52:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001127s ]
[2025-12-10T11:52:57+08:00][sql] CONNECT:[ UseTime:0.010964s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:52:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001309s ]
[2025-12-10T11:52:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001214s ]
[2025-12-10T11:52:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001064s ]
[2025-12-10T11:52:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001066s ]
[2025-12-10T11:52:57+08:00][sql] SELECT * FROM `trade_role` WHERE  `id` = 80 LIMIT 1 [ RunTime:0.000318s ]
[2025-12-10T11:52:57+08:00][sql] SELECT `sync_status` FROM `trade` WHERE  `id` = 148 LIMIT 1 [ RunTime:0.000216s ]
[2025-12-10T11:52:57+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 148  AND `ordertype` = 1  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000333s ]
[2025-12-10T11:52:57+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 148 LIMIT 1 [ RunTime:0.000440s ]
[2025-12-10T11:52:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001039s ]
[2025-12-10T11:52:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000232s ]
[2025-12-10T11:53:34+08:00][sql] CONNECT:[ UseTime:0.011618s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:53:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001394s ]
[2025-12-10T11:53:34+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000272s ]
[2025-12-10T11:53:34+08:00][sql] CONNECT:[ UseTime:0.010957s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:53:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001441s ]
[2025-12-10T11:53:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000550s ]
[2025-12-10T11:53:34+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000378s ]
[2025-12-10T11:53:34+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000993s ]
[2025-12-10T11:53:34+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (149,148,147,143,139,138,137,136,135) [ RunTime:0.000277s ]
[2025-12-10T11:53:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001061s ]
[2025-12-10T11:53:42+08:00][sql] CONNECT:[ UseTime:0.011527s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:53:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001541s ]
[2025-12-10T11:53:42+08:00][sql] SELECT `id`,`game`,`username`,`serverid`,`tid`,`trade_status` FROM `trade_role` WHERE  `id` = 81 LIMIT 1 [ RunTime:0.000309s ]
[2025-12-10T11:53:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001029s ]
[2025-12-10T11:53:42+08:00][sql] SELECT * FROM `trade_game` WHERE  `game` = 'shaiya'  AND `serverid` = 6  AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000306s ]
[2025-12-10T11:53:48+08:00][sql] CONNECT:[ UseTime:0.010747s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:53:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001490s ]
[2025-12-10T11:53:48+08:00][sql] SELECT `id`,`game`,`username`,`serverid`,`tid`,`trade_status` FROM `trade_role` WHERE  `id` = 81 LIMIT 1 [ RunTime:0.000371s ]
[2025-12-10T11:53:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001014s ]
[2025-12-10T11:53:48+08:00][sql] SELECT * FROM `trade_game` WHERE  `game` = 'shaiya'  AND `serverid` = 6  AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000324s ]
[2025-12-10T11:57:33+08:00][sql] CONNECT:[ UseTime:0.001507s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:57:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001359s ]
[2025-12-10T11:57:33+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000280s ]
[2025-12-10T11:57:33+08:00][sql] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:57:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001526s ]
[2025-12-10T11:57:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000579s ]
[2025-12-10T11:57:33+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000483s ]
[2025-12-10T11:57:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001034s ]
[2025-12-10T11:57:33+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (149,148,147,143,139,138,137,136,135) [ RunTime:0.000325s ]
[2025-12-10T11:57:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001055s ]
[2025-12-10T11:57:38+08:00][sql] CONNECT:[ UseTime:0.011499s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:57:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001329s ]
[2025-12-10T11:57:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001207s ]
[2025-12-10T11:57:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001100s ]
[2025-12-10T11:57:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001060s ]
[2025-12-10T11:57:38+08:00][sql] SELECT * FROM `trade_role` WHERE  `id` = 82 LIMIT 1 [ RunTime:0.000305s ]
[2025-12-10T11:57:38+08:00][sql] SELECT `sync_status` FROM `trade` WHERE  `id` = 149 LIMIT 1 [ RunTime:0.000221s ]
[2025-12-10T11:57:38+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 149  AND `ordertype` = 1  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000354s ]
[2025-12-10T11:57:38+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 149 LIMIT 1 [ RunTime:0.000279s ]
[2025-12-10T11:57:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000961s ]
[2025-12-10T11:57:38+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000213s ]
[2025-12-10T11:57:44+08:00][sql] CONNECT:[ UseTime:0.011594s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001502s ]
[2025-12-10T11:57:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5')  AND `to`.`pay_status` = '1' LIMIT 1 [ RunTime:0.000628s ]
[2025-12-10T11:57:44+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5')  AND `to`.`pay_status` = '1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000605s ]
[2025-12-10T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001049s ]
[2025-12-10T11:57:44+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (148,130,129,128,91,76,75,74,73,58) [ RunTime:0.000308s ]
[2025-12-10T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001059s ]
[2025-12-10T11:57:48+08:00][sql] CONNECT:[ UseTime:0.010945s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:57:48+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001321s ]
[2025-12-10T11:57:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001228s ]
[2025-12-10T11:57:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001126s ]
[2025-12-10T11:57:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001056s ]
[2025-12-10T11:57:48+08:00][sql] SELECT * FROM `trade_role` WHERE  `id` = 80 LIMIT 1 [ RunTime:0.000290s ]
[2025-12-10T11:57:48+08:00][sql] SELECT `sync_status` FROM `trade` WHERE  `id` = 148 LIMIT 1 [ RunTime:0.000204s ]
[2025-12-10T11:57:48+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 148  AND `ordertype` = 1  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000314s ]
[2025-12-10T11:57:48+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 148 LIMIT 1 [ RunTime:0.000290s ]
[2025-12-10T11:57:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001009s ]
[2025-12-10T11:57:48+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000214s ]
[2025-12-10T11:59:36+08:00][sql] CONNECT:[ UseTime:0.010581s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:59:36+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001273s ]
[2025-12-10T11:59:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001226s ]
[2025-12-10T11:59:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001041s ]
[2025-12-10T11:59:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001001s ]
[2025-12-10T11:59:36+08:00][sql] SELECT * FROM `trade_role` WHERE  `id` = 80 LIMIT 1 [ RunTime:0.000347s ]
[2025-12-10T11:59:36+08:00][sql] SELECT `sync_status` FROM `trade` WHERE  `id` = 148 LIMIT 1 [ RunTime:0.000285s ]
[2025-12-10T11:59:36+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 148  AND `ordertype` = 1  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000311s ]
[2025-12-10T11:59:36+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 148 LIMIT 1 [ RunTime:0.000279s ]
[2025-12-10T11:59:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000929s ]
[2025-12-10T11:59:36+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000226s ]
[2025-12-10T11:59:39+08:00][sql] CONNECT:[ UseTime:0.010866s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T11:59:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001445s ]
[2025-12-10T11:59:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5')  AND `to`.`pay_status` = '1' LIMIT 1 [ RunTime:0.000573s ]
[2025-12-10T11:59:39+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5')  AND `to`.`pay_status` = '1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000559s ]
[2025-12-10T11:59:39+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000978s ]
[2025-12-10T11:59:39+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (148,130,129,128,91,76,75,74,73,58) [ RunTime:0.000271s ]
[2025-12-10T11:59:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001015s ]
[2025-12-10T12:00:36+08:00][sql] CONNECT:[ UseTime:0.011272s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T12:00:36+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001640s ]
[2025-12-10T12:00:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001362s ]
[2025-12-10T12:00:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001111s ]
[2025-12-10T12:00:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001052s ]
[2025-12-10T12:00:36+08:00][sql] SELECT * FROM `trade_role` WHERE  `id` = 80 LIMIT 1 [ RunTime:0.000304s ]
[2025-12-10T12:00:36+08:00][sql] SELECT `sync_status` FROM `trade` WHERE  `id` = 148 LIMIT 1 [ RunTime:0.000214s ]
[2025-12-10T12:00:36+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 148  AND `ordertype` = 1  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000352s ]
[2025-12-10T12:00:36+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 148 LIMIT 1 [ RunTime:0.000279s ]
[2025-12-10T12:00:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000946s ]
[2025-12-10T12:00:36+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000235s ]
[2025-12-10T12:03:25+08:00][sql] CONNECT:[ UseTime:0.001421s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T12:03:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001313s ]
[2025-12-10T12:03:25+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000279s ]
[2025-12-10T12:03:25+08:00][sql] CONNECT:[ UseTime:0.010728s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T12:03:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001458s ]
[2025-12-10T12:03:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000561s ]
[2025-12-10T12:03:25+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000363s ]
[2025-12-10T12:03:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001050s ]
[2025-12-10T12:03:25+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (149,148,147,143,139,138,137,136,135) [ RunTime:0.000347s ]
[2025-12-10T12:03:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001124s ]
[2025-12-10T12:03:26+08:00][sql] CONNECT:[ UseTime:0.010892s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T12:03:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001378s ]
[2025-12-10T12:03:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001374s ]
[2025-12-10T12:03:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001229s ]
[2025-12-10T12:03:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001159s ]
[2025-12-10T12:03:26+08:00][sql] SELECT * FROM `trade_role` WHERE  `id` = 80 LIMIT 1 [ RunTime:0.000346s ]
[2025-12-10T12:03:26+08:00][sql] SELECT `sync_status` FROM `trade` WHERE  `id` = 148 LIMIT 1 [ RunTime:0.000211s ]
[2025-12-10T12:03:26+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 148  AND `ordertype` = 1  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000333s ]
[2025-12-10T12:03:26+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 148 LIMIT 1 [ RunTime:0.000317s ]
[2025-12-10T12:03:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001119s ]
[2025-12-10T12:03:26+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000217s ]
[2025-12-10T13:32:26+08:00][sql] CONNECT:[ UseTime:0.001479s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T13:32:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001331s ]
[2025-12-10T13:32:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001222s ]
[2025-12-10T13:32:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001090s ]
[2025-12-10T13:32:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001039s ]
[2025-12-10T13:32:26+08:00][sql] SELECT * FROM `trade_role` WHERE  `id` = 80 LIMIT 1 [ RunTime:0.000301s ]
[2025-12-10T13:32:26+08:00][sql] SELECT `sync_status` FROM `trade` WHERE  `id` = 148 LIMIT 1 [ RunTime:0.000222s ]
[2025-12-10T13:32:26+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 148  AND `ordertype` = 1  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000363s ]
[2025-12-10T13:32:26+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 148 LIMIT 1 [ RunTime:0.000271s ]
[2025-12-10T13:32:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000932s ]
[2025-12-10T13:32:26+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000234s ]
[2025-12-10T13:32:30+08:00][sql] CONNECT:[ UseTime:0.001401s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T13:32:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001414s ]
[2025-12-10T13:32:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5')  AND `to`.`pay_status` = '1' LIMIT 1 [ RunTime:0.000630s ]
[2025-12-10T13:32:30+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5')  AND `to`.`pay_status` = '1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000587s ]
[2025-12-10T13:32:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001149s ]
[2025-12-10T13:32:30+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (148,130,129,128,91,76,75,74,73,58) [ RunTime:0.000371s ]
[2025-12-10T13:32:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001171s ]
[2025-12-10T13:32:33+08:00][sql] CONNECT:[ UseTime:0.010961s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-10T13:32:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001379s ]
[2025-12-10T13:32:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001240s ]
[2025-12-10T13:32:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001083s ]
[2025-12-10T13:32:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001054s ]
[2025-12-10T13:32:33+08:00][sql] SELECT * FROM `trade_role` WHERE  `id` = 80 LIMIT 1 [ RunTime:0.000316s ]
[2025-12-10T13:32:33+08:00][sql] SELECT `sync_status` FROM `trade` WHERE  `id` = 148 LIMIT 1 [ RunTime:0.000218s ]
[2025-12-10T13:32:33+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 148  AND `ordertype` = 1  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000345s ]
[2025-12-10T13:32:33+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 148 LIMIT 1 [ RunTime:0.000285s ]
[2025-12-10T13:32:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000962s ]
[2025-12-10T13:32:33+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000220s ]