[2025-09-10T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001931s ]
[2025-09-10T23:57:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-09-10 23:52:02' [ RunTime:0.000463s ]
[2025-09-10T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002351s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001798s ]
[2025-09-10T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001749s ]
[2025-09-10T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE  `pay_status` = 0  AND `addtime` < 1757518022 LIMIT 100 [ RunTime:0.000479s ]
[2025-09-10T23:57:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-09-10 23:52:02' [ RunTime:0.000447s ]
[2025-09-10T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001580s ]
[2025-09-10T23:57:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-09-10 23:52:02' [ RunTime:0.000315s ]
[2025-09-10T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001691s ]
[2025-09-10T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 1  AND `sync_status` IN (0,3)  AND `created_at` <= '2025-09-10 23:56:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000647s ]
[2025-09-10T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002480s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001450s ]
[2025-09-10T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001336s ]
[2025-09-10T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1757519822  AND `outtime` >= 1757518022  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000419s ]
[2025-09-10T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002221s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001163s ]
[2025-09-10T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001515s ]
[2025-09-10T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1757519822  AND `outtime` >= 1757518022  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000401s ]
[2025-09-10T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002088s ]
[2025-09-10T23:58:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-09-10 23:53:02' [ RunTime:0.000433s ]
[2025-09-10T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002237s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001671s ]
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001488s ]
[2025-09-10T23:58:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-09-10 23:53:02' [ RunTime:0.000481s ]
[2025-09-10T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 2  AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000563s ]
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001609s ]
6;dbname=zbg;charset=utf8
[2025-09-10T23:58:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-09-10 23:53:02' [ RunTime:0.000301s ]
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001412s ]
[2025-09-10T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 1  AND `sync_status` IN (0,3)  AND `created_at` <= '2025-09-10 23:57:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000589s ]
[2025-09-10T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002298s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001737s ]
[2025-09-10T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE  `pay_status` = 0  AND `addtime` < 1757518082 LIMIT 100 [ RunTime:0.000411s ]
[2025-09-10T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002378s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001602s ]
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001718s ]
[2025-09-10T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1757519882  AND `outtime` >= 1757518082  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000399s ]
[2025-09-10T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002687s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001672s ]
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001575s ]
[2025-09-10T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1757519882  AND `outtime` >= 1757518082  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000381s ]
[2025-09-10T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001592s ]
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001252s ]
[2025-09-10T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1757519882  AND `outtime` >= 1757518082  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000322s ]
[2025-09-10T23:58:02+08:00][sql] CONNECT:[ UseTime:0.001900s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001147s ]
[2025-09-10T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 0  AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000439s ]
[2025-09-10T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002599s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002076s ]
[2025-09-10T23:59:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-09-10 23:54:02' [ RunTime:0.000462s ]
[2025-09-10T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002278s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001539s ]
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001526s ]
[2025-09-10T23:59:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-09-10 23:54:02' [ RunTime:0.000499s ]
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001772s ]
[2025-09-10T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1757519942  AND `outtime` >= 1757518142  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000382s ]
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001589s ]
[2025-09-10T23:59:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-09-10 23:54:02' [ RunTime:0.000310s ]
[2025-09-10T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002267s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002455s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001497s ]
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001654s ]
[2025-09-10T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 1  AND `sync_status` IN (0,3)  AND `created_at` <= '2025-09-10 23:58:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000588s ]
[2025-09-10T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE  `pay_status` = 0  AND `addtime` < 1757518142 LIMIT 100 [ RunTime:0.000414s ]
[2025-09-10T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002507s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001758s ]
[2025-09-10T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 2  AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000608s ]
[2025-09-10T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002327s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001536s ]
[2025-09-10T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002203s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 0  AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000554s ]
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001470s ]
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001702s ]
[2025-09-10T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1757519942  AND `outtime` >= 1757518142  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000369s ]
[2025-09-10T23:59:02+08:00][sql] CONNECT:[ UseTime:0.001925s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001253s ]
[2025-09-10T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001194s ]
[2025-09-10T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1757519942  AND `outtime` >= 1757518142  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000453s ]