[2025-09-23T10:26:19+08:00][sql] CONNECT:[ UseTime:0.010711s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001268s ]
[2025-09-23T10:26:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000265s ]
[2025-09-23T10:26:19+08:00][sql] CONNECT:[ UseTime:0.011085s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001419s ]
[2025-09-23T10:26:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000541s ]
[2025-09-23T10:26:19+08:00][sql] SELECT `tg`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000447s ]
[2025-09-23T10:26:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001104s ]
[2025-09-23T10:26:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001033s ]
[2025-09-23T10:26:23+08:00][sql] CONNECT:[ UseTime:0.010907s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001376s ]
[2025-09-23T10:26:23+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000319s ]
[2025-09-23T10:26:23+08:00][sql] CONNECT:[ UseTime:0.010669s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001280s ]
[2025-09-23T10:26:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000500s ]
[2025-09-23T10:26:23+08:00][sql] SELECT `tg`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000386s ]
[2025-09-23T10:26:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001145s ]
[2025-09-23T10:26:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000964s ]
[2025-09-23T10:26:24+08:00][sql] CONNECT:[ UseTime:0.010802s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001254s ]
[2025-09-23T10:26:24+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000262s ]
[2025-09-23T10:26:24+08:00][sql] CONNECT:[ UseTime:0.010368s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001336s ]
[2025-09-23T10:26:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000467s ]
[2025-09-23T10:26:24+08:00][sql] SELECT `tg`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000370s ]
[2025-09-23T10:26:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001068s ]
[2025-09-23T10:26:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000911s ]
[2025-09-23T10:26:26+08:00][sql] CONNECT:[ UseTime:0.010992s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001236s ]
[2025-09-23T10:26:26+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000261s ]
[2025-09-23T10:26:27+08:00][sql] CONNECT:[ UseTime:0.011036s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001292s ]
[2025-09-23T10:26:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000461s ]
[2025-09-23T10:26:27+08:00][sql] SELECT `tg`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000397s ]
[2025-09-23T10:26:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001137s ]
[2025-09-23T10:26:27+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001003s ]
[2025-09-23T10:26:28+08:00][sql] CONNECT:[ UseTime:0.001481s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001336s ]
[2025-09-23T10:26:28+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000331s ]
[2025-09-23T10:26:28+08:00][sql] CONNECT:[ UseTime:0.010604s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001349s ]
[2025-09-23T10:26:28+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.000536s ]
[2025-09-23T10:26:28+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.000360s ]
[2025-09-23T10:26:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000989s ]
[2025-09-23T10:26:28+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (109,107,104,102,93,92,91,90,89,87) [ RunTime:0.000294s ]
[2025-09-23T10:26:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001063s ]
[2025-09-23T10:26:31+08:00][sql] CONNECT:[ UseTime:0.010923s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001340s ]
[2025-09-23T10:26:31+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000264s ]
[2025-09-23T10:26:31+08:00][sql] CONNECT:[ UseTime:0.010654s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001391s ]
[2025-09-23T10:26:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000394s ]
[2025-09-23T10:26:31+08:00][sql] SELECT `tp`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000337s ]
[2025-09-23T10:26:31+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000994s ]
[2025-09-23T10:26:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001069s ]
[2025-09-23T10:26:34+08:00][sql] CONNECT:[ UseTime:0.011248s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001358s ]
[2025-09-23T10:26:34+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000263s ]
[2025-09-23T10:26:34+08:00][sql] CONNECT:[ UseTime:0.011263s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001359s ]
[2025-09-23T10:26:34+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.000370s ]
[2025-09-23T10:26:34+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.000402s ]
[2025-09-23T10:26:34+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.000321s ]
[2025-09-23T10:26:34+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.000409s ]
[2025-09-23T10:26:43+08:00][sql] CONNECT:[ UseTime:0.011133s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001351s ]
[2025-09-23T10:26:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000298s ]
[2025-09-23T10:26:44+08:00][sql] CONNECT:[ UseTime:0.001380s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001237s ]
[2025-09-23T10:26:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE  `game` IN ('shaiya','shaiya5')  AND `ordertype` = -1 LIMIT 1 [ RunTime:0.000382s ]
[2025-09-23T10:26:44+08:00][sql] SELECT * FROM `trade_stats` WHERE  `game` IN ('shaiya','shaiya5')  AND `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000364s ]
[2025-09-23T10:26:44+08:00][sql] SELECT IFNULL(SUM(total_price), '0.00') as total_price,IFNULL(SUM(total_withdraw), '0.00') as total_withdraw,IFNULL(SUM(total_charge), '0.00') as total_charge FROM `trade_stats` WHERE  `game` IN ('shaiya','shaiya5')  AND `ordertype` = -1 LIMIT 1 [ RunTime:0.000361s ]
[2025-09-23T10:26:45+08:00][sql] CONNECT:[ UseTime:0.010475s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001439s ]
[2025-09-23T10:26:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000260s ]
[2025-09-23T10:26:45+08:00][sql] CONNECT:[ UseTime:0.010814s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001259s ]
[2025-09-23T10:26:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE  `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000363s ]
[2025-09-23T10:26:45+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000348s ]
[2025-09-23T10:26:58+08:00][sql] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:26:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001473s ]
[2025-09-23T10:26:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE  `game` IN ('shaiya','shaiya5')  AND `username` = 'ctshaiya007' LIMIT 1 [ RunTime:0.000472s ]
[2025-09-23T10:26:58+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` IN ('shaiya','shaiya5')  AND `username` = 'ctshaiya007' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000416s ]
[2025-09-23T10:28:02+08:00][sql] CONNECT:[ UseTime:0.010953s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001449s ]
[2025-09-23T10:28:02+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000265s ]
[2025-09-23T10:28:02+08:00][sql] CONNECT:[ UseTime:0.011624s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001219s ]
[2025-09-23T10:28:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE  `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000370s ]
[2025-09-23T10:28:02+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000279s ]
[2025-09-23T10:28:05+08:00][sql] CONNECT:[ UseTime:0.011412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:28:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001448s ]
[2025-09-23T10:28:05+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000290s ]
[2025-09-23T10:28:05+08:00][sql] CONNECT:[ UseTime:0.011603s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:28:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001316s ]
[2025-09-23T10:28:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000501s ]
[2025-09-23T10:28:05+08:00][sql] SELECT `tg`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000498s ]
[2025-09-23T10:28:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001213s ]
[2025-09-23T10:28:05+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001035s ]
[2025-09-23T10:28:19+08:00][sql] CONNECT:[ UseTime:0.011321s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001369s ]
[2025-09-23T10:28:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000265s ]
[2025-09-23T10:28:19+08:00][sql] CONNECT:[ UseTime:0.011153s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001423s ]
[2025-09-23T10:28:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000465s ]
[2025-09-23T10:28:19+08:00][sql] SELECT `tg`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000387s ]
[2025-09-23T10:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001117s ]
[2025-09-23T10:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000978s ]
[2025-09-23T10:28:21+08:00][sql] CONNECT:[ UseTime:0.011071s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:28:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001315s ]
[2025-09-23T10:28:21+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000273s ]
[2025-09-23T10:28:21+08:00][sql] CONNECT:[ UseTime:0.011647s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T10:28:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001329s ]
[2025-09-23T10:28:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000470s ]
[2025-09-23T10:28:21+08:00][sql] SELECT `tg`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000397s ]
[2025-09-23T10:28:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001129s ]
[2025-09-23T10:28:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000971s ]
[2025-09-23T11:59:14+08:00][sql] CONNECT:[ UseTime:0.011286s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T11:59:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001337s ]
[2025-09-23T11:59:14+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000255s ]
[2025-09-23T11:59:14+08:00][sql] CONNECT:[ UseTime:0.001269s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T11:59:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001248s ]
[2025-09-23T11:59:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000428s ]
[2025-09-23T11:59:14+08:00][sql] SELECT `tg`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000442s ]
[2025-09-23T11:59:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001070s ]
[2025-09-23T11:59:14+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000941s ]
[2025-09-23T11:59:18+08:00][sql] CONNECT:[ UseTime:0.010979s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-23T11:59:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001359s ]
[2025-09-23T11:59:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5')  AND `to`.`pay_status` = '1' LIMIT 1 [ RunTime:0.000516s ]
[2025-09-23T11:59:18+08:00][sql] SELECT `tg`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5')  AND `to`.`pay_status` = '1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000431s ]
[2025-09-23T11:59:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001055s ]
[2025-09-23T11:59:18+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000955s ]