[2025-11-11T13:50:54+08:00][sql] CONNECT:[ UseTime:0.015583s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T13:50:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001281s ]
[2025-11-11T13:50:54+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000274s ]
[2025-11-11T13:50:55+08:00][sql] CONNECT:[ UseTime:0.003804s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T13:50:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001450s ]
[2025-11-11T13:50:55+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.000534s ]
[2025-11-11T13:50:55+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.000342s ]
[2025-11-11T13:50:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000995s ]
[2025-11-11T13:50:55+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000296s ]
[2025-11-11T13:50:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001031s ]
[2025-11-11T13:56:24+08:00][sql] CONNECT:[ UseTime:0.014098s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T13:56:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001294s ]
[2025-11-11T13:56:24+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000266s ]
[2025-11-11T13:56:24+08:00][sql] CONNECT:[ UseTime:0.010331s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T13:56:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001401s ]
[2025-11-11T13:56:24+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.000552s ]
[2025-11-11T13:56:24+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-11-11T13:56:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000988s ]
[2025-11-11T13:56:24+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000263s ]
[2025-11-11T13:56:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000991s ]
[2025-11-11T14:04:47+08:00][sql] CONNECT:[ UseTime:0.001545s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:04:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001396s ]
[2025-11-11T14:04:47+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000365s ]
[2025-11-11T14:04:47+08:00][sql] CONNECT:[ UseTime:0.007988s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:04:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001570s ]
[2025-11-11T14:04:47+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.000771s ]
[2025-11-11T14:04:47+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.000555s ]
[2025-11-11T14:04:47+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001162s ]
[2025-11-11T14:04:47+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000344s ]
[2025-11-11T14:04:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001100s ]
[2025-11-11T14:06:47+08:00][sql] CONNECT:[ UseTime:0.011917s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:06:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001340s ]
[2025-11-11T14:06:47+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000259s ]
[2025-11-11T14:06:47+08:00][sql] CONNECT:[ UseTime:0.003201s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:06:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001424s ]
[2025-11-11T14:06:47+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.000524s ]
[2025-11-11T14:06:47+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.000379s ]
[2025-11-11T14:06:47+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000986s ]
[2025-11-11T14:06:47+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000283s ]
[2025-11-11T14:06:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001071s ]
[2025-11-11T14:06:54+08:00][sql] CONNECT:[ UseTime:0.009271s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:06:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001231s ]
[2025-11-11T14:06:54+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000256s ]
[2025-11-11T14:06:55+08:00][sql] CONNECT:[ UseTime:0.009608s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:06:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001428s ]
[2025-11-11T14:06:55+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-11-11T14:06:55+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.000376s ]
[2025-11-11T14:06:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001043s ]
[2025-11-11T14:06:55+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000280s ]
[2025-11-11T14:06:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001098s ]
[2025-11-11T14:09:42+08:00][sql] CONNECT:[ UseTime:0.003041s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:09:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001371s ]
[2025-11-11T14:09:42+08:00][sql] SELECT `id`,`game`,`serverid`,`orderno`,`tid`,`pay_status`,`ordertype`,`relationid`,`tousername`,`tochaid`,`tochaname`,`api_status`,`order_details` FROM `trade_order` WHERE  `orderno` = 'R2025111113545512740371' LIMIT 1 [ RunTime:0.000285s ]
[2025-11-11T14:09:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001097s ]
[2025-11-11T14:09:42+08:00][sql] UPDATE `trade_order`  SET `api_status` = 1 , `totime` = 1762841382  WHERE  `id` = 40 [ RunTime:0.000444s ]
[2025-11-11T14:09:42+08:00][sql] UPDATE `trade_role`  SET `api_status` = 1  WHERE  `id` = 66 [ RunTime:0.000239s ]
[2025-11-11T14:09:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001224s ]
[2025-11-11T14:09:42+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 128 , `username` = 'ctshaiya001' , `orderno` = 'R2025111113545512740371' , `trade_type` = 1 , `type` = 1 , `content` = '%s出售成功%s！如有疑问可联系官方客服咨询%s' [ RunTime:0.000271s ]
[2025-11-11T14:09:44+08:00][sql] CONNECT:[ UseTime:0.001444s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:09:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001504s ]
[2025-11-11T14:09: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') LIMIT 1 [ RunTime:0.000564s ]
[2025-11-11T14:09: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') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000383s ]
[2025-11-11T14:09:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001060s ]
[2025-11-11T14:09:44+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000286s ]
[2025-11-11T14:09:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001097s ]
[2025-11-11T14:09:46+08:00][sql] CONNECT:[ UseTime:0.012591s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:09:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001309s ]
[2025-11-11T14:09:46+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000270s ]
[2025-11-11T14:09:46+08:00][sql] CONNECT:[ UseTime:0.010948s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:09:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001389s ]
[2025-11-11T14:09:46+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.000521s ]
[2025-11-11T14:09:46+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.000344s ]
[2025-11-11T14:09:46+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001015s ]
[2025-11-11T14:09:46+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000299s ]
[2025-11-11T14:09:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001044s ]
[2025-11-11T14:14:33+08:00][sql] CONNECT:[ UseTime:0.010962s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:14:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001362s ]
[2025-11-11T14:14:33+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000271s ]
[2025-11-11T14:14:33+08:00][sql] CONNECT:[ UseTime:0.002226s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:14:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001371s ]
[2025-11-11T14:14: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.000513s ]
[2025-11-11T14:14: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.000365s ]
[2025-11-11T14:14:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000965s ]
[2025-11-11T14:14:33+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000285s ]
[2025-11-11T14:14:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001002s ]
[2025-11-11T14:14:35+08:00][sql] CONNECT:[ UseTime:0.001394s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:14:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001320s ]
[2025-11-11T14:14:35+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000260s ]
[2025-11-11T14:14:35+08:00][sql] CONNECT:[ UseTime:0.013591s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:14:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001397s ]
[2025-11-11T14:14:35+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.000516s ]
[2025-11-11T14:14:35+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.000365s ]
[2025-11-11T14:14:35+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000984s ]
[2025-11-11T14:14:35+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000313s ]
[2025-11-11T14:14:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001039s ]
[2025-11-11T14:14:36+08:00][sql] CONNECT:[ UseTime:0.012628s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:14:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001276s ]
[2025-11-11T14:14:36+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000261s ]
[2025-11-11T14:14:36+08:00][sql] CONNECT:[ UseTime:0.011812s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:14:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001320s ]
[2025-11-11T14:14:36+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.000569s ]
[2025-11-11T14:14:36+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-11-11T14:14:36+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001000s ]
[2025-11-11T14:14:36+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000308s ]
[2025-11-11T14:14:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001027s ]
[2025-11-11T14:14:36+08:00][sql] CONNECT:[ UseTime:0.010856s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:14:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001315s ]
[2025-11-11T14:14:36+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000263s ]
[2025-11-11T14:14:36+08:00][sql] CONNECT:[ UseTime:0.002496s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:14:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001336s ]
[2025-11-11T14:14:36+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.000503s ]
[2025-11-11T14:14:36+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.000351s ]
[2025-11-11T14:14:36+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000993s ]
[2025-11-11T14:14:36+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000302s ]
[2025-11-11T14:14:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001057s ]
[2025-11-11T14:15:18+08:00][sql] CONNECT:[ UseTime:0.005565s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001321s ]
[2025-11-11T14:15:18+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000280s ]
[2025-11-11T14:15:19+08:00][sql] CONNECT:[ UseTime:0.001971s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001435s ]
[2025-11-11T14:15:19+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.000528s ]
[2025-11-11T14:15:19+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-11-11T14:15:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001022s ]
[2025-11-11T14:15:19+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000284s ]
[2025-11-11T14:15:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001075s ]
[2025-11-11T14:15:20+08:00][sql] CONNECT:[ UseTime:0.008449s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001330s ]
[2025-11-11T14:15:20+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000260s ]
[2025-11-11T14:15:20+08:00][sql] CONNECT:[ UseTime:0.013542s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001348s ]
[2025-11-11T14:15:20+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.000508s ]
[2025-11-11T14:15:20+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.000341s ]
[2025-11-11T14:15:20+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000992s ]
[2025-11-11T14:15:20+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000296s ]
[2025-11-11T14:15:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001049s ]
[2025-11-11T14:15:21+08:00][sql] CONNECT:[ UseTime:0.015922s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001307s ]
[2025-11-11T14:15:21+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000268s ]
[2025-11-11T14:15:21+08:00][sql] CONNECT:[ UseTime:0.012469s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001451s ]
[2025-11-11T14:15:21+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.000551s ]
[2025-11-11T14:15:21+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.000367s ]
[2025-11-11T14:15:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001014s ]
[2025-11-11T14:15:21+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000268s ]
[2025-11-11T14:15:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001054s ]
[2025-11-11T14:15:21+08:00][sql] CONNECT:[ UseTime:0.012664s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001215s ]
[2025-11-11T14:15:21+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000251s ]
[2025-11-11T14:15:21+08:00][sql] CONNECT:[ UseTime:0.008025s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001453s ]
[2025-11-11T14:15:21+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.000523s ]
[2025-11-11T14:15:21+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.000345s ]
[2025-11-11T14:15:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001029s ]
[2025-11-11T14:15:21+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000273s ]
[2025-11-11T14:15:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001107s ]
[2025-11-11T14:15:21+08:00][sql] CONNECT:[ UseTime:0.004452s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001137s ]
[2025-11-11T14:15:21+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000291s ]
[2025-11-11T14:15:21+08:00][sql] CONNECT:[ UseTime:0.013522s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001253s ]
[2025-11-11T14:15:21+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000282s ]
[2025-11-11T14:15:22+08:00][sql] CONNECT:[ UseTime:0.010131s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001354s ]
[2025-11-11T14:15:22+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.000521s ]
[2025-11-11T14:15:22+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.000345s ]
[2025-11-11T14:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000988s ]
[2025-11-11T14:15:22+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000271s ]
[2025-11-11T14:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001024s ]
[2025-11-11T14:15:22+08:00][sql] CONNECT:[ UseTime:0.001313s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001221s ]
[2025-11-11T14:15:22+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000280s ]
[2025-11-11T14:15:22+08:00][sql] CONNECT:[ UseTime:0.001389s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001274s ]
[2025-11-11T14:15:22+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000264s ]
[2025-11-11T14:15:22+08:00][sql] CONNECT:[ UseTime:0.013714s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001468s ]
[2025-11-11T14:15:22+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.000545s ]
[2025-11-11T14:15:22+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.000376s ]
[2025-11-11T14:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001055s ]
[2025-11-11T14:15:22+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000270s ]
[2025-11-11T14:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001136s ]
[2025-11-11T14:15:42+08:00][sql] CONNECT:[ UseTime:0.008383s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001222s ]
[2025-11-11T14:15:42+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000257s ]
[2025-11-11T14:15:42+08:00][sql] CONNECT:[ UseTime:0.013229s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001476s ]
[2025-11-11T14:15: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.000529s ]
[2025-11-11T14:15: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.000390s ]
[2025-11-11T14:15:42+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000985s ]
[2025-11-11T14:15:42+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000308s ]
[2025-11-11T14:15:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001094s ]
[2025-11-11T14:15:42+08:00][sql] CONNECT:[ UseTime:0.001366s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001278s ]
[2025-11-11T14:15:42+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000264s ]
[2025-11-11T14:15:43+08:00][sql] CONNECT:[ UseTime:0.007321s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001359s ]
[2025-11-11T14:15:43+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.000510s ]
[2025-11-11T14:15:43+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.000345s ]
[2025-11-11T14:15:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000999s ]
[2025-11-11T14:15:43+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000298s ]
[2025-11-11T14:15:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001052s ]
[2025-11-11T14:15:43+08:00][sql] CONNECT:[ UseTime:0.001369s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001399s ]
[2025-11-11T14:15:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000256s ]
[2025-11-11T14:15:43+08:00][sql] CONNECT:[ UseTime:0.006270s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001511s ]
[2025-11-11T14:15:43+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.000593s ]
[2025-11-11T14:15:43+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.000491s ]
[2025-11-11T14:15:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001111s ]
[2025-11-11T14:15:43+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000384s ]
[2025-11-11T14:15:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001141s ]
[2025-11-11T14:15:43+08:00][sql] CONNECT:[ UseTime:0.003452s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001275s ]
[2025-11-11T14:15:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000267s ]
[2025-11-11T14:15:43+08:00][sql] CONNECT:[ UseTime:0.012476s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001283s ]
[2025-11-11T14:15:43+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.000484s ]
[2025-11-11T14:15:43+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.000339s ]
[2025-11-11T14:15:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000944s ]
[2025-11-11T14:15:43+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000267s ]
[2025-11-11T14:15:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000962s ]
[2025-11-11T14:15:45+08:00][sql] CONNECT:[ UseTime:0.002998s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001429s ]
[2025-11-11T14:15:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000284s ]
[2025-11-11T14:15:45+08:00][sql] CONNECT:[ UseTime:0.002811s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:15:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001374s ]
[2025-11-11T14:15:45+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.000496s ]
[2025-11-11T14:15:45+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.000355s ]
[2025-11-11T14:15:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000982s ]
[2025-11-11T14:15:45+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000271s ]
[2025-11-11T14:15:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000997s ]
[2025-11-11T14:16:24+08:00][sql] CONNECT:[ UseTime:0.004092s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001229s ]
[2025-11-11T14:16:24+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000260s ]
[2025-11-11T14:16:24+08:00][sql] CONNECT:[ UseTime:0.010128s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001370s ]
[2025-11-11T14:16:24+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.000507s ]
[2025-11-11T14:16:24+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.000345s ]
[2025-11-11T14:16:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000939s ]
[2025-11-11T14:16:24+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000276s ]
[2025-11-11T14:16:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000973s ]
[2025-11-11T14:16:24+08:00][sql] CONNECT:[ UseTime:0.006768s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001334s ]
[2025-11-11T14:16:24+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000284s ]
[2025-11-11T14:16:24+08:00][sql] CONNECT:[ UseTime:0.010014s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001344s ]
[2025-11-11T14:16:24+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.000489s ]
[2025-11-11T14:16:24+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-11-11T14:16:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000987s ]
[2025-11-11T14:16:24+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000291s ]
[2025-11-11T14:16:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001018s ]
[2025-11-11T14:16:25+08:00][sql] CONNECT:[ UseTime:0.012817s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001090s ]
[2025-11-11T14:16:25+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000258s ]
[2025-11-11T14:16:25+08:00][sql] CONNECT:[ UseTime:0.011887s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001325s ]
[2025-11-11T14:16: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.000532s ]
[2025-11-11T14:16: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.000344s ]
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000988s ]
[2025-11-11T14:16:25+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000301s ]
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001045s ]
[2025-11-11T14:16:25+08:00][sql] CONNECT:[ UseTime:0.012367s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001218s ]
[2025-11-11T14:16:25+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000251s ]
[2025-11-11T14:16:25+08:00][sql] CONNECT:[ UseTime:0.013916s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001398s ]
[2025-11-11T14:16: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.000557s ]
[2025-11-11T14:16: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.000366s ]
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001026s ]
[2025-11-11T14:16:25+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000267s ]
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001059s ]
[2025-11-11T14:16:25+08:00][sql] CONNECT:[ UseTime:0.008438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001322s ]
[2025-11-11T14:16:25+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000260s ]
[2025-11-11T14:16:25+08:00][sql] CONNECT:[ UseTime:0.008360s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001181s ]
[2025-11-11T14:16:25+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000274s ]
[2025-11-11T14:16:25+08:00][sql] CONNECT:[ UseTime:0.011327s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001499s ]
[2025-11-11T14:16: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.000556s ]
[2025-11-11T14:16: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.000371s ]
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001059s ]
[2025-11-11T14:16:25+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000300s ]
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001089s ]
[2025-11-11T14:16:25+08:00][sql] CONNECT:[ UseTime:0.003402s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001239s ]
[2025-11-11T14:16:25+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000267s ]
[2025-11-11T14:16:25+08:00][sql] CONNECT:[ UseTime:0.002875s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001189s ]
[2025-11-11T14:16:25+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000277s ]
[2025-11-11T14:16:26+08:00][sql] CONNECT:[ UseTime:0.003143s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001358s ]
[2025-11-11T14:16:26+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000251s ]
[2025-11-11T14:16:26+08:00][sql] CONNECT:[ UseTime:0.009633s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001439s ]
[2025-11-11T14:16:26+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.000541s ]
[2025-11-11T14:16:26+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.000373s ]
[2025-11-11T14:16:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001021s ]
[2025-11-11T14:16:26+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000295s ]
[2025-11-11T14:16:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001073s ]
[2025-11-11T14:16:29+08:00][sql] CONNECT:[ UseTime:0.016040s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001316s ]
[2025-11-11T14:16:29+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000270s ]
[2025-11-11T14:16:29+08:00][sql] CONNECT:[ UseTime:0.010335s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:16:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001435s ]
[2025-11-11T14:16:29+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.000522s ]
[2025-11-11T14:16:29+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.000370s ]
[2025-11-11T14:16:29+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001016s ]
[2025-11-11T14:16:29+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (128,120,119,118,109,107,104,102,93,92) [ RunTime:0.000272s ]
[2025-11-11T14:16:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001117s ]
[2025-11-11T14:17:10+08:00][sql] CONNECT:[ UseTime:0.001500s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:17:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001234s ]
[2025-11-11T14:17:10+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000251s ]
[2025-11-11T14:17:10+08:00][sql] CONNECT:[ UseTime:0.008241s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:17:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001438s ]
[2025-11-11T14:17:10+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.000549s ]
[2025-11-11T14:17:10+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.000379s ]
[2025-11-11T14:17:10+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001036s ]
[2025-11-11T14:17:10+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (129,128,120,119,118,109,107,104,102,93) [ RunTime:0.000311s ]
[2025-11-11T14:17:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001121s ]
[2025-11-11T14:23:31+08:00][sql] CONNECT:[ UseTime:0.001427s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:23:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001346s ]
[2025-11-11T14:23:31+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000273s ]
[2025-11-11T14:23:31+08:00][sql] CONNECT:[ UseTime:0.001317s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-11T14:23:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001451s ]
[2025-11-11T14:23:31+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.000542s ]
[2025-11-11T14:23:31+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.000351s ]
[2025-11-11T14:23:31+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001115s ]
[2025-11-11T14:23:31+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (129,128,120,119,118,109,107,104,102,93) [ RunTime:0.000278s ]
[2025-11-11T14:23:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001084s ]