[2026-01-14T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002323s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:54:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:49:02' [ RunTime:0.000346s ] [2026-01-14T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001435s ] [2026-01-14T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001690s ] [2026-01-14T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768406042 AND `outtime` >= 1768404242 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000362s ] [2026-01-14T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002461s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001705s ] [2026-01-14T23:54: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` <= '2026-01-14 23:53:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000771s ] [2026-01-14T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002403s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001827s ] [2026-01-14T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002238s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001757s ] [2026-01-14T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768406042 AND `outtime` >= 1768404242 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000470s ] [2026-01-14T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001755s ] [2026-01-14T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768404242 LIMIT 100 [ RunTime:0.000414s ] [2026-01-14T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002370s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001492s ] [2026-01-14T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001582s ] [2026-01-14T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768406042 AND `outtime` >= 1768404242 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000436s ] [2026-01-14T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002608s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002016s ] [2026-01-14T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002300s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768404302 LIMIT 100 [ RunTime:0.000456s ] [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001552s ] [2026-01-14T23:55: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` <= '2026-01-14 23:54:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000640s ] [2026-01-14T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002289s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001550s ] [2026-01-14T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002387s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:55: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.000635s ] [2026-01-14T23:55:02+08:00][sql] CONNECT:[ UseTime:0.003251s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001509s ] [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001490s ] [2026-01-14T23:55: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.000616s ] [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001757s ] [2026-01-14T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768406102 AND `outtime` >= 1768404302 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000500s ] [2026-01-14T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002338s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001633s ] [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002243s ] [2026-01-14T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768406102 AND `outtime` >= 1768404302 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000411s ] [2026-01-14T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002450s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001612s ] [2026-01-14T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002346s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001824s ] [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001540s ] [2026-01-14T23:55:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:50:02' [ RunTime:0.000405s ] [2026-01-14T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768406102 AND `outtime` >= 1768404302 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000456s ] [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001326s ] [2026-01-14T23:55:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:50:02' [ RunTime:0.000488s ] [2026-01-14T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001296s ] [2026-01-14T23:55:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:50:02' [ RunTime:0.000316s ] [2026-01-14T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002560s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001866s ] [2026-01-14T23:56: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.000637s ] [2026-01-14T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002476s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001921s ] [2026-01-14T23:56:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:51:02' [ RunTime:0.000473s ] [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001738s ] [2026-01-14T23:56:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:51:02' [ RunTime:0.000559s ] [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001666s ] [2026-01-14T23:56:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:51:02' [ RunTime:0.000349s ] [2026-01-14T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002420s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001541s ] [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001683s ] [2026-01-14T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768406162 AND `outtime` >= 1768404362 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000362s ] [2026-01-14T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002522s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001631s ] [2026-01-14T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002301s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001501s ] [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001978s ] [2026-01-14T23:56: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` <= '2026-01-14 23:55:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000659s ] [2026-01-14T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002267s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001404s ] [2026-01-14T23:56: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.000601s ] [2026-01-14T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768406162 AND `outtime` >= 1768404362 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000478s ] [2026-01-14T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002248s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001815s ] [2026-01-14T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768404362 LIMIT 100 [ RunTime:0.000454s ] [2026-01-14T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002331s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001485s ] [2026-01-14T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001749s ] [2026-01-14T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768406162 AND `outtime` >= 1768404362 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000369s ] [2026-01-14T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002569s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001803s ] [2026-01-14T23:57: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.000651s ] [2026-01-14T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002527s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001591s ] [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001710s ] [2026-01-14T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768406222 AND `outtime` >= 1768404422 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000377s ] [2026-01-14T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002405s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002190s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001633s ] [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001462s ] [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001684s ] [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001636s ] [2026-01-14T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768406222 AND `outtime` >= 1768404422 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000455s ] [2026-01-14T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768406222 AND `outtime` >= 1768404422 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000358s ] [2026-01-14T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002298s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001514s ] [2026-01-14T23: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` <= '2026-01-14 23:56:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000663s ] [2026-01-14T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002393s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001619s ] [2026-01-14T23:57: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.000588s ] [2026-01-14T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002300s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001901s ] [2026-01-14T23:57:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:52:02' [ RunTime:0.000406s ] [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001631s ] [2026-01-14T23:57:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:52:02' [ RunTime:0.000648s ] [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001494s ] [2026-01-14T23:57:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:52:02' [ RunTime:0.000370s ] [2026-01-14T23:57:02+08:00][sql] CONNECT:[ UseTime:0.001825s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001357s ] [2026-01-14T23: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` < 1768404422 LIMIT 100 [ RunTime:0.000338s ] [2026-01-14T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002677s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001905s ] [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001863s ] [2026-01-14T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768406282 AND `outtime` >= 1768404482 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000539s ] [2026-01-14T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002326s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001883s ] [2026-01-14T23:58:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:53:02' [ RunTime:0.000435s ] [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001602s ] [2026-01-14T23:58:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:53:02' [ RunTime:0.000555s ] [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001628s ] [2026-01-14T23:58:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:53:02' [ RunTime:0.000346s ] [2026-01-14T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002364s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001500s ] [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001677s ] [2026-01-14T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768406282 AND `outtime` >= 1768404482 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000341s ] [2026-01-14T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002359s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001543s ] [2026-01-14T23: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` <= '2026-01-14 23:57:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000666s ] [2026-01-14T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002323s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001550s ] [2026-01-14T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002282s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001489s ] [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001669s ] [2026-01-14T23: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.000614s ] [2026-01-14T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002449s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001619s ] [2026-01-14T23: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` < 1768404482 LIMIT 100 [ RunTime:0.000598s ] [2026-01-14T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002002s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001551s ] [2026-01-14T23: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.000551s ] [2026-01-14T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002602s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001837s ] [2026-01-14T23: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.000655s ] [2026-01-14T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002308s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001566s ] [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001673s ] [2026-01-14T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768406342 AND `outtime` >= 1768404542 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000387s ] [2026-01-14T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002306s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002577s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001543s ] [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001766s ] [2026-01-14T23: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` < 1768404542 LIMIT 100 [ RunTime:0.000405s ] [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001641s ] [2026-01-14T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768406342 AND `outtime` >= 1768404542 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000424s ] [2026-01-14T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002285s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001522s ] [2026-01-14T23: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` <= '2026-01-14 23:58:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000671s ] [2026-01-14T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002675s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001742s ] [2026-01-14T23: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.000619s ] [2026-01-14T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002225s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001558s ] [2026-01-14T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002170s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001871s ] [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001638s ] [2026-01-14T23:59:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:54:02' [ RunTime:0.000463s ] [2026-01-14T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768406342 AND `outtime` >= 1768404542 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000500s ] [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001663s ] [2026-01-14T23:59:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:54:02' [ RunTime:0.000601s ] [2026-01-14T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001486s ] [2026-01-14T23:59:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-14 23:54:02' [ RunTime:0.000325s ]