[2025-11-17T10:22:19+08:00][sql] CONNECT:[ UseTime:0.010918s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001308s ]
[2025-11-17T10:22:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000273s ]
[2025-11-17T10:22:19+08:00][sql] CONNECT:[ UseTime:0.010973s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001536s ]
[2025-11-17T10:22: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.000569s ]
[2025-11-17T10:22: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.000370s ]
[2025-11-17T10:22:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001039s ]
[2025-11-17T10:22:19+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000342s ]
[2025-11-17T10:22:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001115s ]
[2025-11-17T10:22:26+08:00][sql] CONNECT:[ UseTime:0.011222s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001233s ]
[2025-11-17T10:22:26+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000254s ]
[2025-11-17T10:22:26+08:00][sql] CONNECT:[ UseTime:0.010968s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001577s ]
[2025-11-17T10:22: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.000591s ]
[2025-11-17T10:22: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.000450s ]
[2025-11-17T10:22:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001113s ]
[2025-11-17T10:22:26+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000377s ]
[2025-11-17T10:22:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001144s ]
[2025-11-17T10:22:30+08:00][sql] CONNECT:[ UseTime:0.010389s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001344s ]
[2025-11-17T10:22:30+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000263s ]
[2025-11-17T10:22:30+08:00][sql] CONNECT:[ UseTime:0.011529s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001357s ]
[2025-11-17T10:22: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') LIMIT 1 [ RunTime:0.000535s ]
[2025-11-17T10:22: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') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000386s ]
[2025-11-17T10:22:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000987s ]
[2025-11-17T10:22:30+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000300s ]
[2025-11-17T10:22:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001085s ]
[2025-11-17T10:22:33+08:00][sql] CONNECT:[ UseTime:0.011444s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001326s ]
[2025-11-17T10:22:33+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000267s ]
[2025-11-17T10:22:33+08:00][sql] CONNECT:[ UseTime:0.011063s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001446s ]
[2025-11-17T10:22: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.000557s ]
[2025-11-17T10:22: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.000358s ]
[2025-11-17T10:22:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001098s ]
[2025-11-17T10:22:33+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000288s ]
[2025-11-17T10:22:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001164s ]
[2025-11-17T10:22:53+08:00][sql] CONNECT:[ UseTime:0.001349s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001276s ]
[2025-11-17T10:22:53+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000324s ]
[2025-11-17T10:22:53+08:00][sql] CONNECT:[ UseTime:0.010671s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001529s ]
[2025-11-17T10:22:53+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.000590s ]
[2025-11-17T10:22:53+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-11-17T10:22:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001096s ]
[2025-11-17T10:22:53+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000276s ]
[2025-11-17T10:22:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001133s ]
[2025-11-17T10:22:56+08:00][sql] CONNECT:[ UseTime:0.010957s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001437s ]
[2025-11-17T10:22:56+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000274s ]
[2025-11-17T10:22:56+08:00][sql] CONNECT:[ UseTime:0.010800s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001519s ]
[2025-11-17T10:22:56+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.000605s ]
[2025-11-17T10:22:56+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.000347s ]
[2025-11-17T10:22:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001084s ]
[2025-11-17T10:22:56+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000270s ]
[2025-11-17T10:22:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001187s ]
[2025-11-17T10:22:56+08:00][sql] CONNECT:[ UseTime:0.011052s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001328s ]
[2025-11-17T10:22:56+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000275s ]
[2025-11-17T10:22:56+08:00][sql] CONNECT:[ UseTime:0.011392s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001440s ]
[2025-11-17T10:22:56+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.000539s ]
[2025-11-17T10:22:56+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-17T10:22:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001037s ]
[2025-11-17T10:22:56+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000271s ]
[2025-11-17T10:22:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001108s ]
[2025-11-17T10:22:56+08:00][sql] CONNECT:[ UseTime:0.010887s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001324s ]
[2025-11-17T10:22:56+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000259s ]
[2025-11-17T10:22:57+08:00][sql] CONNECT:[ UseTime:0.001294s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001396s ]
[2025-11-17T10:22:57+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.000559s ]
[2025-11-17T10:22:57+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-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001009s ]
[2025-11-17T10:22:57+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000301s ]
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001033s ]
[2025-11-17T10:22:57+08:00][sql] CONNECT:[ UseTime:0.010339s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001183s ]
[2025-11-17T10:22:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000273s ]
[2025-11-17T10:22:57+08:00][sql] CONNECT:[ UseTime:0.011304s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001264s ]
[2025-11-17T10:22:57+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.000525s ]
[2025-11-17T10:22:57+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-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000981s ]
[2025-11-17T10:22:57+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000290s ]
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001030s ]
[2025-11-17T10:22:57+08:00][sql] CONNECT:[ UseTime:0.010953s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001244s ]
[2025-11-17T10:22:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000301s ]
[2025-11-17T10:22:57+08:00][sql] CONNECT:[ UseTime:0.011031s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001343s ]
[2025-11-17T10:22:57+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-17T10:22:57+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-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001146s ]
[2025-11-17T10:22:57+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000268s ]
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001134s ]
[2025-11-17T10:22:57+08:00][sql] CONNECT:[ UseTime:0.011617s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001306s ]
[2025-11-17T10:22:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000258s ]
[2025-11-17T10:22:57+08:00][sql] CONNECT:[ UseTime:0.011469s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001480s ]
[2025-11-17T10:22:57+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-17T10:22:57+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-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001096s ]
[2025-11-17T10:22:57+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000346s ]
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001179s ]
[2025-11-17T10:22:57+08:00][sql] CONNECT:[ UseTime:0.010670s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001150s ]
[2025-11-17T10:22:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000257s ]
[2025-11-17T10:22:57+08:00][sql] CONNECT:[ UseTime:0.001283s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001350s ]
[2025-11-17T10:22:57+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-11-17T10:22:57+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-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001047s ]
[2025-11-17T10:22:57+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000270s ]
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001054s ]
[2025-11-17T10:22:57+08:00][sql] CONNECT:[ UseTime:0.001304s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001097s ]
[2025-11-17T10:22:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000250s ]
[2025-11-17T10:22:57+08:00][sql] CONNECT:[ UseTime:0.010794s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001311s ]
[2025-11-17T10:22:57+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.000544s ]
[2025-11-17T10:22:57+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.000422s ]
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001015s ]
[2025-11-17T10:22:57+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000272s ]
[2025-11-17T10:22:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001123s ]
[2025-11-17T10:22:58+08:00][sql] CONNECT:[ UseTime:0.010482s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001293s ]
[2025-11-17T10:22:58+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000286s ]
[2025-11-17T10:22:58+08:00][sql] CONNECT:[ UseTime:0.010546s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001474s ]
[2025-11-17T10:22:58+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.000613s ]
[2025-11-17T10:22:58+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.000421s ]
[2025-11-17T10:22:58+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001041s ]
[2025-11-17T10:22:58+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000333s ]
[2025-11-17T10:22:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001113s ]
[2025-11-17T10:22:59+08:00][sql] CONNECT:[ UseTime:0.001417s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001329s ]
[2025-11-17T10:22:59+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000286s ]
[2025-11-17T10:22:59+08:00][sql] CONNECT:[ UseTime:0.011436s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:22:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001429s ]
[2025-11-17T10:22:59+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.000576s ]
[2025-11-17T10:22:59+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.000356s ]
[2025-11-17T10:22:59+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001058s ]
[2025-11-17T10:22:59+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000335s ]
[2025-11-17T10:22:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001103s ]
[2025-11-17T10:23:00+08:00][sql] CONNECT:[ UseTime:0.010892s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001308s ]
[2025-11-17T10:23:00+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000281s ]
[2025-11-17T10:23:00+08:00][sql] CONNECT:[ UseTime:0.010924s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001311s ]
[2025-11-17T10:23: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.000570s ]
[2025-11-17T10:23: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.000378s ]
[2025-11-17T10:23:00+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001023s ]
[2025-11-17T10:23:00+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (138,137,136,135,134,133,132,131,130,129) [ RunTime:0.000276s ]
[2025-11-17T10:23:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001032s ]
[2025-11-17T10:23:12+08:00][sql] CONNECT:[ UseTime:0.010762s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001345s ]
[2025-11-17T10:23:12+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000264s ]
[2025-11-17T10:23:12+08:00][sql] CONNECT:[ UseTime:0.011100s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001479s ]
[2025-11-17T10:23:12+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.000600s ]
[2025-11-17T10:23:12+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.000427s ]
[2025-11-17T10:23:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001036s ]
[2025-11-17T10:23:12+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (139,138,137,136,135,134,133,132,131,130) [ RunTime:0.000355s ]
[2025-11-17T10:23:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001106s ]
[2025-11-17T10:23:13+08:00][sql] CONNECT:[ UseTime:0.010589s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001339s ]
[2025-11-17T10:23:13+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000265s ]
[2025-11-17T10:23:13+08:00][sql] CONNECT:[ UseTime:0.011070s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001461s ]
[2025-11-17T10:23:13+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.000543s ]
[2025-11-17T10:23:13+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.000362s ]
[2025-11-17T10:23:13+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001104s ]
[2025-11-17T10:23:13+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (139,138,137,136,135,134,133,132,131,130) [ RunTime:0.000334s ]
[2025-11-17T10:23:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001096s ]
[2025-11-17T10:23:14+08:00][sql] CONNECT:[ UseTime:0.011407s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001257s ]
[2025-11-17T10:23:14+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000286s ]
[2025-11-17T10:23:14+08:00][sql] CONNECT:[ UseTime:0.011524s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001345s ]
[2025-11-17T10:23:14+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-17T10:23:14+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-17T10:23:14+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001001s ]
[2025-11-17T10:23:14+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (139,138,137,136,135,134,133,132,131,130) [ RunTime:0.000285s ]
[2025-11-17T10:23:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001016s ]
[2025-11-17T10:23:16+08:00][sql] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001617s ]
[2025-11-17T10:23:16+08:00][sql] SELECT `id`,`game`,`username`,`serverid`,`tid`,`trade_status` FROM `trade_role` WHERE  `id` = 77 LIMIT 1 [ RunTime:0.000281s ]
[2025-11-17T10:23:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001101s ]
[2025-11-17T10:23:16+08:00][sql] SELECT * FROM `trade_game` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000324s ]
[2025-11-17T10:23:16+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001025s ]
[2025-11-17T10:23:16+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_status`,`sync_tradeno` FROM `trade` WHERE  `id` = 139  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000251s ]
[2025-11-17T10:23:16+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 7  WHERE  `id` = 77 [ RunTime:0.000241s ]
[2025-11-17T10:23:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000994s ]
[2025-11-17T10:23:16+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 139 , `username` = 'ctshaiya008' , `orderno` = '' , `trade_type` = 1 , `type` = 0 , `content` = '%s未通过公示期%s，商品已退回游戏，请前往游戏内角色列表/角色邮箱查收。如有疑问可联系官方客服咨询%s' [ RunTime:0.000379s ]
[2025-11-17T10:23:18+08:00][sql] CONNECT:[ UseTime:0.011443s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001540s ]
[2025-11-17T10:23:18+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.000676s ]
[2025-11-17T10:23:18+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.000444s ]
[2025-11-17T10:23:18+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001050s ]
[2025-11-17T10:23:18+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (139,138,137,136,135,134,133,132,131,130) [ RunTime:0.000311s ]
[2025-11-17T10:23:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001052s ]
[2025-11-17T10:23:20+08:00][sql] CONNECT:[ UseTime:0.011543s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001291s ]
[2025-11-17T10:23:20+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000274s ]
[2025-11-17T10:23:20+08:00][sql] CONNECT:[ UseTime:0.011741s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-17T10:23:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001341s ]
[2025-11-17T10:23: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.000560s ]
[2025-11-17T10:23: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.000363s ]
[2025-11-17T10:23:20+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000979s ]
[2025-11-17T10:23:20+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (139,138,137,136,135,134,133,132,131,130) [ RunTime:0.000289s ]
[2025-11-17T10:23:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001047s ]