[2025-11-04T09:30:53+08:00][sql] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-04T09:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001342s ]
[2025-11-04T09:30:53+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000264s ]
[2025-11-04T09:30:53+08:00][sql] CONNECT:[ UseTime:0.004515s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-04T09:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001433s ]
[2025-11-04T09:30: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.000532s ]
[2025-11-04T09:30: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.000363s ]
[2025-11-04T09:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001014s ]
[2025-11-04T09:30:53+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (119,118,109,107,104,102,93,92,91,90) [ RunTime:0.000286s ]
[2025-11-04T09:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001023s ]
[2025-11-04T09:30:59+08:00][sql] CONNECT:[ UseTime:0.014721s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-04T09:30:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001363s ]
[2025-11-04T09:30:59+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000267s ]
[2025-11-04T09:30:59+08:00][sql] CONNECT:[ UseTime:0.001996s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-04T09:30:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001287s ]
[2025-11-04T09:30: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.000497s ]
[2025-11-04T09:30: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.000358s ]
[2025-11-04T09:30:59+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000968s ]
[2025-11-04T09:30:59+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (119,118,109,107,104,102,93,92,91,90) [ RunTime:0.000287s ]
[2025-11-04T09:30:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001065s ]
[2025-11-04T09:38:24+08:00][sql] CONNECT:[ UseTime:0.013160s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-04T09:38:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001328s ]
[2025-11-04T09:38:24+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000298s ]
[2025-11-04T09:38:24+08:00][sql] CONNECT:[ UseTime:0.014449s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-04T09:38:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001450s ]
[2025-11-04T09:38: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.000601s ]
[2025-11-04T09:38: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.000394s ]
[2025-11-04T09:38:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001050s ]
[2025-11-04T09:38:24+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (120,119,118,109,107,104,102,93,92,91) [ RunTime:0.000312s ]
[2025-11-04T09:38:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001114s ]