[2025-12-02T17:26:05+08:00][sql] CONNECT:[ UseTime:0.001596s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-02T17:26:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001444s ]
[2025-12-02T17:26:05+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000262s ]
[2025-12-02T17:26:06+08:00][sql] CONNECT:[ UseTime:0.010833s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-02T17:26:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001430s ]
[2025-12-02T17:26:06+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.000553s ]
[2025-12-02T17:26:06+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-12-02T17:26:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001010s ]
[2025-12-02T17:26:06+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (143,139,138,137,136,135,134,133,132,131) [ RunTime:0.000278s ]
[2025-12-02T17:26:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001045s ]
[2025-12-02T17:29:51+08:00][sql] CONNECT:[ UseTime:0.001440s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-02T17:29:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001294s ]
[2025-12-02T17:29:51+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000269s ]
[2025-12-02T17:29:51+08:00][sql] CONNECT:[ UseTime:0.011064s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-02T17:29:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001453s ]
[2025-12-02T17:29:51+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.000554s ]
[2025-12-02T17:29:51+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.000357s ]
[2025-12-02T17:29:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001096s ]
[2025-12-02T17:29:51+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (143,139,138,137,136,135,134,133,132,131) [ RunTime:0.000294s ]
[2025-12-02T17:29:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001092s ]
[2025-12-02T17:29:53+08:00][sql] CONNECT:[ UseTime:0.001547s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-02T17:29:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001401s ]
[2025-12-02T17:29:53+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000269s ]
[2025-12-02T17:29:53+08:00][sql] CONNECT:[ UseTime:0.011244s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-12-02T17:29:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001322s ]
[2025-12-02T17:29: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.000523s ]
[2025-12-02T17:29: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-12-02T17:29:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000981s ]
[2025-12-02T17:29:53+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (143,139,138,137,136,135,134,133,132,131) [ RunTime:0.000298s ]
[2025-12-02T17:29:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001032s ]