[2026-01-13T23:30:02+08:00][sql] CONNECT:[ UseTime:0.002294s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001597s ] [2026-01-13T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001695s ] [2026-01-13T23:30:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318202 AND `outtime` >= 1768316402 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000439s ] [2026-01-13T23:30:02+08:00][sql] CONNECT:[ UseTime:0.002388s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001821s ] [2026-01-13T23:30:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:25:02' [ RunTime:0.000440s ] [2026-01-13T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001590s ] [2026-01-13T23:30:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:25:02' [ RunTime:0.000548s ] [2026-01-13T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001583s ] [2026-01-13T23:30:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:25:02' [ RunTime:0.000344s ] [2026-01-13T23:30:02+08:00][sql] CONNECT:[ UseTime:0.002434s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001530s ] [2026-01-13T23:30: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.000643s ] [2026-01-13T23:30:02+08:00][sql] CONNECT:[ UseTime:0.002211s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001462s ] [2026-01-13T23:30: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.000625s ] [2026-01-13T23:30:02+08:00][sql] CONNECT:[ UseTime:0.002264s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001570s ] [2026-01-13T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001808s ] [2026-01-13T23:30:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318202 AND `outtime` >= 1768316402 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000411s ] [2026-01-13T23:30:02+08:00][sql] CONNECT:[ UseTime:0.001741s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001050s ] [2026-01-13T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001140s ] [2026-01-13T23:30:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318202 AND `outtime` >= 1768316402 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000302s ] [2026-01-13T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002551s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002022s ] [2026-01-13T23:31:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768316462 LIMIT 100 [ RunTime:0.000459s ] [2026-01-13T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002612s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001675s ] [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001750s ] [2026-01-13T23:31:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318262 AND `outtime` >= 1768316462 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000454s ] [2026-01-13T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002353s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001585s ] [2026-01-13T23:31: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-13 23:30:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000664s ] [2026-01-13T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002365s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001858s ] [2026-01-13T23:31:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:26:02' [ RunTime:0.000445s ] [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001687s ] [2026-01-13T23:31:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:26:02' [ RunTime:0.000552s ] [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001614s ] [2026-01-13T23:31:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:26:02' [ RunTime:0.000327s ] [2026-01-13T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002313s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001476s ] [2026-01-13T23:31: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.000638s ] [2026-01-13T23:31:02+08:00][sql] CONNECT:[ UseTime:0.004843s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001588s ] [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002027s ] [2026-01-13T23:31:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318262 AND `outtime` >= 1768316462 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000376s ] [2026-01-13T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002294s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001471s ] [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001622s ] [2026-01-13T23:31:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318262 AND `outtime` >= 1768316462 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000385s ] [2026-01-13T23:31:02+08:00][sql] CONNECT:[ UseTime:0.001825s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001434s ] [2026-01-13T23:31: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.000712s ] [2026-01-13T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002549s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001835s ] [2026-01-13T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002436s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:32: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.000639s ] [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001814s ] [2026-01-13T23:32:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:27:02' [ RunTime:0.000427s ] [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001637s ] [2026-01-13T23:32:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:27:02' [ RunTime:0.000657s ] [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001611s ] [2026-01-13T23:32:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:27:02' [ RunTime:0.000345s ] [2026-01-13T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002310s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001490s ] [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001660s ] [2026-01-13T23:32:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318322 AND `outtime` >= 1768316522 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000471s ] [2026-01-13T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002386s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001692s ] [2026-01-13T23:32: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-13 23:31:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000673s ] [2026-01-13T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002406s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001782s ] [2026-01-13T23:32:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768316522 LIMIT 100 [ RunTime:0.000439s ] [2026-01-13T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002284s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001584s ] [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001677s ] [2026-01-13T23:32:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318322 AND `outtime` >= 1768316522 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000405s ] [2026-01-13T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002306s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001331s ] [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001302s ] [2026-01-13T23:32:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318322 AND `outtime` >= 1768316522 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000439s ] [2026-01-13T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002344s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001463s ] [2026-01-13T23:32: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.000583s ] [2026-01-13T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002560s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001794s ] [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001680s ] [2026-01-13T23:33:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318382 AND `outtime` >= 1768316582 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000418s ] [2026-01-13T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002342s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001760s ] [2026-01-13T23:33:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:28:02' [ RunTime:0.000428s ] [2026-01-13T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002334s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001673s ] [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001534s ] [2026-01-13T23:33:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:28:02' [ RunTime:0.000547s ] [2026-01-13T23:33: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.000597s ] [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001657s ] [2026-01-13T23:33:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:28:02' [ RunTime:0.000327s ] [2026-01-13T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002255s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001464s ] [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001654s ] [2026-01-13T23:33:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318382 AND `outtime` >= 1768316582 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000425s ] [2026-01-13T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002240s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001508s ] [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001690s ] [2026-01-13T23:33:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318382 AND `outtime` >= 1768316582 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000335s ] [2026-01-13T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002536s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001824s ] [2026-01-13T23:33:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768316582 LIMIT 100 [ RunTime:0.000476s ] [2026-01-13T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002343s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002548s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001523s ] [2026-01-13T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001549s ] [2026-01-13T23:33: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-13 23:32:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000729s ] [2026-01-13T23:33: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.000634s ] [2026-01-13T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002627s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001846s ] [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001724s ] [2026-01-13T23:34:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318442 AND `outtime` >= 1768316642 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000484s ] [2026-01-13T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002336s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001502s ] [2026-01-13T23:34: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-13 23:33:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000677s ] [2026-01-13T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002406s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001488s ] [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001677s ] [2026-01-13T23:34:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318442 AND `outtime` >= 1768316642 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000342s ] [2026-01-13T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002538s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002908s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001779s ] [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001547s ] [2026-01-13T23:34: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.000653s ] [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001660s ] [2026-01-13T23:34:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318442 AND `outtime` >= 1768316642 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000381s ] [2026-01-13T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002365s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002116s ] [2026-01-13T23:34:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768316642 LIMIT 100 [ RunTime:0.000575s ] [2026-01-13T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002557s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001766s ] [2026-01-13T23:34:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:29:02' [ RunTime:0.000499s ] [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001429s ] [2026-01-13T23:34:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:29:02' [ RunTime:0.000667s ] [2026-01-13T23:34:02+08:00][sql] CONNECT:[ UseTime:0.001892s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001593s ] [2026-01-13T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001577s ] [2026-01-13T23:34:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:29:02' [ RunTime:0.000338s ] [2026-01-13T23:34: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.000459s ] [2026-01-13T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002565s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001966s ] [2026-01-13T23:35: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.000675s ] [2026-01-13T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002451s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:35:02+08:00][sql] CONNECT:[ UseTime:0.003093s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001692s ] [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001720s ] [2026-01-13T23:35:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768316702 LIMIT 100 [ RunTime:0.000472s ] [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001737s ] [2026-01-13T23:35:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318502 AND `outtime` >= 1768316702 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000474s ] [2026-01-13T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002443s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001738s ] [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001720s ] [2026-01-13T23:35:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318502 AND `outtime` >= 1768316702 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000375s ] [2026-01-13T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002497s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001776s ] [2026-01-13T23:35:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:30:02' [ RunTime:0.000460s ] [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001620s ] [2026-01-13T23:35:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:30:02' [ RunTime:0.000530s ] [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001619s ] [2026-01-13T23:35:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:30:02' [ RunTime:0.000341s ] [2026-01-13T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002394s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001449s ] [2026-01-13T23:35: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-13 23:34:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000672s ] [2026-01-13T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002265s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002285s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001447s ] [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001511s ] [2026-01-13T23:35: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.000606s ] [2026-01-13T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001607s ] [2026-01-13T23:35:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318502 AND `outtime` >= 1768316702 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000376s ] [2026-01-13T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002512s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001805s ] [2026-01-13T23:36: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.000664s ] [2026-01-13T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002334s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002264s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001641s ] [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001468s ] [2026-01-13T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001676s ] [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001589s ] [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001670s ] [2026-01-13T23:36:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318562 AND `outtime` >= 1768316762 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000421s ] [2026-01-13T23:36:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768316762 LIMIT 100 [ RunTime:0.000387s ] [2026-01-13T23:36:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318562 AND `outtime` >= 1768316762 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000439s ] [2026-01-13T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002495s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002050s ] [2026-01-13T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002287s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:36:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:31:02' [ RunTime:0.000433s ] [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001516s ] [2026-01-13T23:36: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.000656s ] [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001681s ] [2026-01-13T23:36:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:31:02' [ RunTime:0.000575s ] [2026-01-13T23:36:02+08:00][sql] CONNECT:[ UseTime:0.003910s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001608s ] [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001520s ] [2026-01-13T23:36:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:31:02' [ RunTime:0.000310s ] [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001639s ] [2026-01-13T23:36:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318562 AND `outtime` >= 1768316762 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000366s ] [2026-01-13T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002017s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001234s ] [2026-01-13T23:36: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-13 23:35:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000528s ] [2026-01-13T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002556s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001816s ] [2026-01-13T23:37: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-13 23:36:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000686s ] [2026-01-13T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001919s ] [2026-01-13T23:37:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:32:02' [ RunTime:0.000472s ] [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001683s ] [2026-01-13T23:37:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:32:02' [ RunTime:0.000560s ] [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001619s ] [2026-01-13T23:37:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:32:02' [ RunTime:0.000338s ] [2026-01-13T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001424s ] [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001862s ] [2026-01-13T23:37:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318622 AND `outtime` >= 1768316822 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000362s ] [2026-01-13T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002255s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001936s ] [2026-01-13T23:37:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768316822 LIMIT 100 [ RunTime:0.000425s ] [2026-01-13T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002254s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001642s ] [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001681s ] [2026-01-13T23:37:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318622 AND `outtime` >= 1768316822 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000452s ] [2026-01-13T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002745s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001768s ] [2026-01-13T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002223s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001575s ] [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001755s ] [2026-01-13T23:37: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.000716s ] [2026-01-13T23:37:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318622 AND `outtime` >= 1768316822 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000434s ] [2026-01-13T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002080s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001450s ] [2026-01-13T23:37: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.000658s ] [2026-01-13T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002631s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001776s ] [2026-01-13T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002265s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:38: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.000701s ] [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001555s ] [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001836s ] [2026-01-13T23:38:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318682 AND `outtime` >= 1768316882 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000542s ] [2026-01-13T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002558s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001610s ] [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001701s ] [2026-01-13T23:38:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318682 AND `outtime` >= 1768316882 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000364s ] [2026-01-13T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002295s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001485s ] [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001778s ] [2026-01-13T23:38:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318682 AND `outtime` >= 1768316882 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000411s ] [2026-01-13T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002386s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001834s ] [2026-01-13T23:38:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768316882 LIMIT 100 [ RunTime:0.000417s ] [2026-01-13T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002418s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001710s ] [2026-01-13T23:38: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.000714s ] [2026-01-13T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002003s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001762s ] [2026-01-13T23:38:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:33:02' [ RunTime:0.000384s ] [2026-01-13T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002123s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001695s ] [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001601s ] [2026-01-13T23:38: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-13 23:37:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000663s ] [2026-01-13T23:38:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:33:02' [ RunTime:0.000597s ] [2026-01-13T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001474s ] [2026-01-13T23:38:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:33:02' [ RunTime:0.000343s ] [2026-01-13T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002702s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001832s ] [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001732s ] [2026-01-13T23:39:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318742 AND `outtime` >= 1768316942 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000371s ] [2026-01-13T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002407s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001856s ] [2026-01-13T23:39:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:34:02' [ RunTime:0.000448s ] [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001633s ] [2026-01-13T23:39:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:34:02' [ RunTime:0.000540s ] [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001598s ] [2026-01-13T23:39:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:34:02' [ RunTime:0.000354s ] [2026-01-13T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002486s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001515s ] [2026-01-13T23:39: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.000621s ] [2026-01-13T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002178s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001618s ] [2026-01-13T23:39: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.000609s ] [2026-01-13T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002318s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001712s ] [2026-01-13T23:39:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768316942 LIMIT 100 [ RunTime:0.000422s ] [2026-01-13T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002253s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001616s ] [2026-01-13T23:39: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-13 23:38:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000711s ] [2026-01-13T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002146s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001496s ] [2026-01-13T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002358s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001480s ] [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001557s ] [2026-01-13T23:39:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318742 AND `outtime` >= 1768316942 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000378s ] [2026-01-13T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001604s ] [2026-01-13T23:39:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318742 AND `outtime` >= 1768316942 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000485s ] [2026-01-13T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002494s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001795s ] [2026-01-13T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002343s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001777s ] [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001816s ] [2026-01-13T23:40:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318802 AND `outtime` >= 1768317002 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000419s ] [2026-01-13T23:40:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317002 LIMIT 100 [ RunTime:0.000395s ] [2026-01-13T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002347s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001587s ] [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001742s ] [2026-01-13T23:40:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318802 AND `outtime` >= 1768317002 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000356s ] [2026-01-13T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002343s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001558s ] [2026-01-13T23:40: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.000639s ] [2026-01-13T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002503s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001805s ] [2026-01-13T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002437s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:40: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-13 23:39:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000740s ] [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001568s ] [2026-01-13T23:40: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.000627s ] [2026-01-13T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002271s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001796s ] [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001631s ] [2026-01-13T23:40:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318802 AND `outtime` >= 1768317002 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000514s ] [2026-01-13T23:40:02+08:00][sql] CONNECT:[ UseTime:0.001992s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001637s ] [2026-01-13T23:40:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:35:02' [ RunTime:0.000482s ] [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001603s ] [2026-01-13T23:40:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:35:02' [ RunTime:0.000534s ] [2026-01-13T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001527s ] [2026-01-13T23:40:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:35:02' [ RunTime:0.000382s ] [2026-01-13T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002268s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001760s ] [2026-01-13T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002173s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001721s ] [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001779s ] [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001683s ] no`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 1 AND `sync_status` IN (0,3) AND `created_at` <= '2026-01-13 23:40:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000639s ] [2026-01-13T23:41:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:36:02' [ RunTime:0.000444s ] [2026-01-13T23:41:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318862 AND `outtime` >= 1768317062 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000556s ] [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001520s ] [2026-01-13T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002254s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:41:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:36:02' [ RunTime:0.000540s ] [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001443s ] [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001708s ] [2026-01-13T23:41:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:36:02' [ RunTime:0.000350s ] [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001674s ] [2026-01-13T23:41:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318862 AND `outtime` >= 1768317062 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000395s ] [2026-01-13T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002545s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002432s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001612s ] [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001795s ] [2026-01-13T23:41: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.000657s ] [2026-01-13T23:41: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-13T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002232s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001592s ] [2026-01-13T23:41:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317062 LIMIT 100 [ RunTime:0.000423s ] [2026-01-13T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002217s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001373s ] [2026-01-13T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001275s ] [2026-01-13T23:41:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318862 AND `outtime` >= 1768317062 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000313s ] [2026-01-13T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002584s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001840s ] [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001775s ] [2026-01-13T23:42:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318922 AND `outtime` >= 1768317122 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000356s ] [2026-01-13T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002459s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001591s ] [2026-01-13T23:42: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-13 23:41:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000673s ] [2026-01-13T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002556s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001777s ] [2026-01-13T23:42:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317122 LIMIT 100 [ RunTime:0.000557s ] [2026-01-13T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002318s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001516s ] [2026-01-13T23:42: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.000606s ] [2026-01-13T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002394s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001565s ] [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001787s ] [2026-01-13T23:42:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318922 AND `outtime` >= 1768317122 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000394s ] [2026-01-13T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002501s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002295s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001732s ] [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001909s ] [2026-01-13T23:42: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.000600s ] [2026-01-13T23:42:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:37:02' [ RunTime:0.000417s ] [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001634s ] [2026-01-13T23:42:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:37:02' [ RunTime:0.000564s ] [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001592s ] [2026-01-13T23:42:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:37:02' [ RunTime:0.000372s ] [2026-01-13T23:42:02+08:00][sql] CONNECT:[ UseTime:0.001958s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001266s ] [2026-01-13T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001308s ] [2026-01-13T23:42:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318922 AND `outtime` >= 1768317122 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000327s ] [2026-01-13T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002635s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001934s ] [2026-01-13T23:43: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-13 23:42:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000808s ] [2026-01-13T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001893s ] [2026-01-13T23:43:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:38:02' [ RunTime:0.000462s ] [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001819s ] [2026-01-13T23:43:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:38:02' [ RunTime:0.000555s ] [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001644s ] [2026-01-13T23:43:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:38:02' [ RunTime:0.000326s ] [2026-01-13T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002375s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001538s ] [2026-01-13T23:43: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.000623s ] [2026-01-13T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002441s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001501s ] [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001681s ] [2026-01-13T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002157s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:43:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768318982 AND `outtime` >= 1768317182 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000485s ] [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001452s ] [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001673s ] [2026-01-13T23:43:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768318982 AND `outtime` >= 1768317182 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000342s ] [2026-01-13T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002250s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001543s ] [2026-01-13T23:43: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.000626s ] [2026-01-13T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002089s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001570s ] [2026-01-13T23:43:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317182 LIMIT 100 [ RunTime:0.000437s ] [2026-01-13T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002163s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001270s ] [2026-01-13T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001805s ] [2026-01-13T23:43:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768318982 AND `outtime` >= 1768317182 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000504s ] [2026-01-13T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002632s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002017s ] [2026-01-13T23:44:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:39:02' [ RunTime:0.000487s ] [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001829s ] [2026-01-13T23:44:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:39:02' [ RunTime:0.000551s ] [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001616s ] [2026-01-13T23:44:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:39:02' [ RunTime:0.000350s ] [2026-01-13T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002567s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001620s ] [2026-01-13T23:44: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-13 23:43:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000757s ] [2026-01-13T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002288s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001478s ] [2026-01-13T23:44: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.000620s ] [2026-01-13T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002567s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001495s ] [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001630s ] [2026-01-13T23:44:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319042 AND `outtime` >= 1768317242 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000366s ] [2026-01-13T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002390s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001448s ] [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001567s ] [2026-01-13T23:44:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319042 AND `outtime` >= 1768317242 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000417s ] [2026-01-13T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002615s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001814s ] [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001888s ] [2026-01-13T23:44:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319042 AND `outtime` >= 1768317242 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000450s ] [2026-01-13T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002193s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001615s ] [2026-01-13T23:44:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317242 LIMIT 100 [ RunTime:0.000512s ] [2026-01-13T23:44:02+08:00][sql] CONNECT:[ UseTime:0.001858s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001127s ] [2026-01-13T23:44: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.000446s ] [2026-01-13T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002525s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001785s ] [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001974s ] [2026-01-13T23:45:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319102 AND `outtime` >= 1768317302 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000401s ] [2026-01-13T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002377s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001730s ] [2026-01-13T23:45:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317302 LIMIT 100 [ RunTime:0.000419s ] [2026-01-13T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002298s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001540s ] [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001696s ] [2026-01-13T23:45:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319102 AND `outtime` >= 1768317302 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000445s ] [2026-01-13T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002249s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001688s ] [2026-01-13T23:45: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.000610s ] [2026-01-13T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002494s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001815s ] [2026-01-13T23:45: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.000667s ] [2026-01-13T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002208s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001496s ] [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001696s ] [2026-01-13T23:45:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319102 AND `outtime` >= 1768317302 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000379s ] [2026-01-13T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002279s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001523s ] [2026-01-13T23:45: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-13 23:44:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000681s ] [2026-01-13T23:45:02+08:00][sql] CONNECT:[ UseTime:0.001775s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001376s ] [2026-01-13T23:45:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:40:02' [ RunTime:0.000348s ] [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001200s ] [2026-01-13T23:45:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:40:02' [ RunTime:0.000375s ] [2026-01-13T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001139s ] [2026-01-13T23:45:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:40:02' [ RunTime:0.000260s ] [2026-01-13T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002529s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001856s ] [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001886s ] [2026-01-13T23:46:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319162 AND `outtime` >= 1768317362 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000405s ] [2026-01-13T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002465s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001740s ] [2026-01-13T23:46: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-13 23:45:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000662s ] [2026-01-13T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002217s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001471s ] [2026-01-13T23:46: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.000622s ] [2026-01-13T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002291s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:46:02+08:00][sql] CONNECT:[ UseTime:0.003147s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001511s ] [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001527s ] [2026-01-13T23:46: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.000579s ] [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001667s ] [2026-01-13T23:46:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319162 AND `outtime` >= 1768317362 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000492s ] [2026-01-13T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002728s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001620s ] [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001383s ] [2026-01-13T23:46:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319162 AND `outtime` >= 1768317362 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000326s ] [2026-01-13T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002361s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002258s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001686s ] [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001746s ] [2026-01-13T23:46:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:41:02' [ RunTime:0.000426s ] [2026-01-13T23:46:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317362 LIMIT 100 [ RunTime:0.000420s ] [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001471s ] [2026-01-13T23:46:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:41:02' [ RunTime:0.000527s ] [2026-01-13T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001289s ] [2026-01-13T23:46:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:41:02' [ RunTime:0.000303s ] [2026-01-13T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002554s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001854s ] [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001695s ] [2026-01-13T23:47:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319222 AND `outtime` >= 1768317422 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000359s ] [2026-01-13T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002451s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001582s ] [2026-01-13T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002252s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:47: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-13 23:46:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000728s ] [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001512s ] [2026-01-13T23:47: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.000614s ] [2026-01-13T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002267s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001523s ] [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001692s ] [2026-01-13T23:47:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319222 AND `outtime` >= 1768317422 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000421s ] [2026-01-13T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002352s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001637s ] [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001660s ] [2026-01-13T23:47:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319222 AND `outtime` >= 1768317422 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000390s ] [2026-01-13T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002307s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001702s ] [2026-01-13T23:47:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:42:02' [ RunTime:0.000443s ] [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001587s ] [2026-01-13T23:47:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:42:02' [ RunTime:0.000656s ] [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001580s ] [2026-01-13T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002579s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:47:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:42:02' [ RunTime:0.000351s ] [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001513s ] [2026-01-13T23:47: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-13T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002265s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001764s ] [2026-01-13T23:47:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317422 LIMIT 100 [ RunTime:0.000500s ] [2026-01-13T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002650s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001836s ] [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001695s ] [2026-01-13T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002402s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:48:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319282 AND `outtime` >= 1768317482 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000466s ] [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001731s ] [2026-01-13T23:48:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:43:02' [ RunTime:0.000436s ] [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001628s ] [2026-01-13T23:48:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:43:02' [ RunTime:0.000534s ] [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001645s ] [2026-01-13T23:48:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:43:02' [ RunTime:0.000329s ] [2026-01-13T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002476s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001519s ] [2026-01-13T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002217s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:48: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-13 23:47:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000741s ] [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001459s ] [2026-01-13T23:48: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.000596s ] [2026-01-13T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002623s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001732s ] [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001694s ] [2026-01-13T23:48:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319282 AND `outtime` >= 1768317482 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000425s ] [2026-01-13T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002294s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001521s ] [2026-01-13T23:48: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 ] [2026-01-13T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002401s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001710s ] [2026-01-13T23:48:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317482 LIMIT 100 [ RunTime:0.000437s ] [2026-01-13T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002332s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001580s ] [2026-01-13T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001815s ] [2026-01-13T23:48:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319282 AND `outtime` >= 1768317482 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000374s ] [2026-01-13T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002599s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001826s ] [2026-01-13T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002239s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001742s ] [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001562s ] [2026-01-13T23:49:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319342 AND `outtime` >= 1768317542 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000411s ] [2026-01-13T23:49: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-13 23:48:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000653s ] [2026-01-13T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002476s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001483s ] [2026-01-13T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002242s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001474s ] [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001713s ] [2026-01-13T23:49:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319342 AND `outtime` >= 1768317542 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000426s ] [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001683s ] [2026-01-13T23:49:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319342 AND `outtime` >= 1768317542 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000348s ] [2026-01-13T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002549s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001783s ] [2026-01-13T23:49: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.000638s ] [2026-01-13T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001803s ] [2026-01-13T23:49: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.000622s ] [2026-01-13T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002373s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001935s ] [2026-01-13T23:49:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317542 LIMIT 100 [ RunTime:0.000428s ] [2026-01-13T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002173s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001793s ] [2026-01-13T23:49:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:44:02' [ RunTime:0.000487s ] [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001256s ] [2026-01-13T23:49:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:44:02' [ RunTime:0.000424s ] [2026-01-13T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001203s ] [2026-01-13T23:49:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:44:02' [ RunTime:0.000309s ] [2026-01-13T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002643s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001798s ] [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001759s ] [2026-01-13T23:50:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319402 AND `outtime` >= 1768317602 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000456s ] [2026-01-13T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002374s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002775s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001534s ] [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001739s ] [2026-01-13T23:50:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317602 LIMIT 100 [ RunTime:0.000431s ] [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001663s ] [2026-01-13T23:50:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319402 AND `outtime` >= 1768317602 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000352s ] [2026-01-13T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002206s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001427s ] [2026-01-13T23:50: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.000597s ] [2026-01-13T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002452s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001714s ] [2026-01-13T23:50:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:45:02' [ RunTime:0.000426s ] [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001610s ] [2026-01-13T23:50:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:45:02' [ RunTime:0.000562s ] [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001785s ] [2026-01-13T23:50:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:45:02' [ RunTime:0.000322s ] [2026-01-13T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002099s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001544s ] [2026-01-13T23:50: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-13 23:49:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000752s ] [2026-01-13T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002797s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001698s ] [2026-01-13T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002325s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:50: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.000783s ] [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001384s ] [2026-01-13T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001872s ] [2026-01-13T23:50:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319402 AND `outtime` >= 1768317602 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000389s ] [2026-01-13T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002554s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001800s ] [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001710s ] [2026-01-13T23:51:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319462 AND `outtime` >= 1768317662 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000421s ] [2026-01-13T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002365s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001780s ] [2026-01-13T23:51:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:46:02' [ RunTime:0.000440s ] [2026-01-13T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002349s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001619s ] [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001518s ] [2026-01-13T23:51:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:46:02' [ RunTime:0.000542s ] [2026-01-13T23:51: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.000645s ] [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001579s ] [2026-01-13T23:51:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:46:02' [ RunTime:0.000310s ] [2026-01-13T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002293s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001690s ] [2026-01-13T23:51:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317662 LIMIT 100 [ RunTime:0.000428s ] [2026-01-13T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002416s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002419s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001727s ] [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001492s ] [2026-01-13T23:51: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.000638s ] [2026-01-13T23:51: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-13 23:50:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000640s ] [2026-01-13T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002296s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001664s ] [2026-01-13T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002237s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001584s ] [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001424s ] [2026-01-13T23:51:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319462 AND `outtime` >= 1768317662 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000669s ] [2026-01-13T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001424s ] [2026-01-13T23:51:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319462 AND `outtime` >= 1768317662 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000343s ] [2026-01-13T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002632s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002323s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001995s ] [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001594s ] [2026-01-13T23:52:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317722 LIMIT 100 [ RunTime:0.000435s ] [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001728s ] [2026-01-13T23:52:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319522 AND `outtime` >= 1768317722 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000481s ] [2026-01-13T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002317s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001496s ] [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001689s ] [2026-01-13T23:52:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319522 AND `outtime` >= 1768317722 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000312s ] [2026-01-13T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002262s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001431s ] [2026-01-13T23:52: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.000589s ] [2026-01-13T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002368s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001598s ] [2026-01-13T23:52:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:47:02' [ RunTime:0.000558s ] [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001605s ] [2026-01-13T23:52:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:47:02' [ RunTime:0.000542s ] [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001587s ] [2026-01-13T23:52:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:47:02' [ RunTime:0.000340s ] [2026-01-13T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002329s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001853s ] [2026-01-13T23:52: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-13 23:51:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000705s ] [2026-01-13T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002399s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001677s ] [2026-01-13T23:52: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.000674s ] [2026-01-13T23:52:02+08:00][sql] CONNECT:[ UseTime:0.001787s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001186s ] [2026-01-13T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001146s ] [2026-01-13T23:52:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319522 AND `outtime` >= 1768317722 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000337s ] [2026-01-13T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002530s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002059s ] [2026-01-13T23:53:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:48:02' [ RunTime:0.000472s ] [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001650s ] [2026-01-13T23:53:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:48:02' [ RunTime:0.000568s ] [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001593s ] [2026-01-13T23:53:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:48:02' [ RunTime:0.000350s ] [2026-01-13T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002400s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001730s ] [2026-01-13T23:53:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1768317782 LIMIT 100 [ RunTime:0.000437s ] [2026-01-13T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002367s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001508s ] [2026-01-13T23:53: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-13 23:52:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000680s ] [2026-01-13T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002495s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001550s ] [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001497s ] [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001642s ] [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001752s ] [2026-01-13T23:53:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319582 AND `outtime` >= 1768317782 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000367s ] [2026-01-13T23:53:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319582 AND `outtime` >= 1768317782 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000327s ] [2026-01-13T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002330s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001384s ] [2026-01-13T23:53: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.000624s ] [2026-01-13T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002077s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:53:02+08:00][sql] CONNECT:[ UseTime:0.001767s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001778s ] [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001429s ] [2026-01-13T23:53: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.000504s ] [2026-01-13T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001347s ] [2026-01-13T23:53:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319582 AND `outtime` >= 1768317782 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000556s ] [2026-01-13T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002757s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001817s ] [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001765s ] [2026-01-13T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319642 AND `outtime` >= 1768317842 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000392s ] [2026-01-13T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002343s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001719s ] [2026-01-13T23:54:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:49:02' [ RunTime:0.000443s ] [2026-01-13T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002454s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001663s ] [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001854s ] [2026-01-13T23:54:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:49:02' [ RunTime:0.000554s ] [2026-01-13T23: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` < 1768317842 LIMIT 100 [ RunTime:0.000476s ] [2026-01-13T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002226s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001625s ] [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001429s ] [2026-01-13T23:54:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:49:02' [ RunTime:0.000321s ] [2026-01-13T23: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-13 23:53:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000599s ] [2026-01-13T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002678s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001750s ] t=3306;dbname=zbg;charset=utf8 [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001551s ] [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001719s ] [2026-01-13T23:54: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.000629s ] [2026-01-13T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319642 AND `outtime` >= 1768317842 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000367s ] [2026-01-13T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002363s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001650s ] [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001706s ] [2026-01-13T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319642 AND `outtime` >= 1768317842 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000427s ] [2026-01-13T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002271s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001620s ] [2026-01-13T23:54: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-13T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002568s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002205s ] [2026-01-13T23:55:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:50:02' [ RunTime:0.000470s ] [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001629s ] [2026-01-13T23:55:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:50:02' [ RunTime:0.000574s ] [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001629s ] [2026-01-13T23:55:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:50:02' [ RunTime:0.000354s ] [2026-01-13T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002496s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001615s ] [2026-01-13T23: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-13 23:54:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000761s ] [2026-01-13T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001495s ] [2026-01-13T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002235s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001515s ] [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001714s ] [2026-01-13T23: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.000943s ] [2026-01-13T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319702 AND `outtime` >= 1768317902 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000645s ] [2026-01-13T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002364s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001663s ] [2026-01-13T23: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` < 1768317902 LIMIT 100 [ RunTime:0.000434s ] [2026-01-13T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002786s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001749s ] [2026-01-13T23: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.000613s ] [2026-01-13T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002283s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001385s ] [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001396s ] [2026-01-13T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319702 AND `outtime` >= 1768317902 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000322s ] [2026-01-13T23:55:02+08:00][sql] CONNECT:[ UseTime:0.001905s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001253s ] [2026-01-13T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001295s ] [2026-01-13T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319702 AND `outtime` >= 1768317902 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000446s ] [2026-01-13T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002559s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001873s ] [2026-01-13T23: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.000647s ] [2026-01-13T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002399s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:56:02+08:00][sql] CONNECT:[ UseTime:0.003290s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001584s ] [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001706s ] [2026-01-13T23: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-13 23:55:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000661s ] [2026-01-13T23: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` < 1768317962 LIMIT 100 [ RunTime:0.000430s ] [2026-01-13T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002369s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001477s ] [2026-01-13T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002775s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001610s ] [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001508s ] [2026-01-13T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319762 AND `outtime` >= 1768317962 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000634s ] [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001673s ] [2026-01-13T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319762 AND `outtime` >= 1768317962 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000435s ] [2026-01-13T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002311s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001979s ] [2026-01-13T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002366s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001757s ] [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001621s ] [2026-01-13T23:56:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:51:02' [ RunTime:0.000516s ] [2026-01-13T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319762 AND `outtime` >= 1768317962 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000302s ] [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001561s ] [2026-01-13T23:56:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:51:02' [ RunTime:0.000558s ] [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001497s ] [2026-01-13T23:56:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:51:02' [ RunTime:0.000369s ] [2026-01-13T23:56:02+08:00][sql] CONNECT:[ UseTime:0.001882s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001188s ] [2026-01-13T23: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.000539s ] [2026-01-13T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002836s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002047s ] [2026-01-13T23: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` < 1768318022 LIMIT 100 [ RunTime:0.000454s ] [2026-01-13T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002454s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001768s ] [2026-01-13T23: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-13T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002494s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001654s ] [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001716s ] [2026-01-13T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319822 AND `outtime` >= 1768318022 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000360s ] [2026-01-13T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002369s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001842s ] [2026-01-13T23:57:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:52:02' [ RunTime:0.000453s ] [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001980s ] [2026-01-13T23:57:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:52:02' [ RunTime:0.000551s ] [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001596s ] [2026-01-13T23:57:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:52:02' [ RunTime:0.000342s ] [2026-01-13T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001656s ] [2026-01-13T23: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-13 23:56:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000659s ] [2026-01-13T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002376s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001540s ] [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001696s ] [2026-01-13T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319822 AND `outtime` >= 1768318022 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000430s ] [2026-01-13T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002417s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001490s ] [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001693s ] [2026-01-13T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319822 AND `outtime` >= 1768318022 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000377s ] [2026-01-13T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002268s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001455s ] [2026-01-13T23: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.000628s ] [2026-01-13T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002636s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002038s ] [2026-01-13T23:58:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:53:02' [ RunTime:0.000473s ] [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001713s ] [2026-01-13T23:58:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:53:02' [ RunTime:0.000563s ] [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001597s ] [2026-01-13T23:58:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:53:02' [ RunTime:0.000341s ] [2026-01-13T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002370s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001453s ] [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001699s ] [2026-01-13T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319882 AND `outtime` >= 1768318082 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000328s ] [2026-01-13T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002293s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:58:02+08:00][sql] CONNECT:[ UseTime:0.003013s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001736s ] [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001525s ] [2026-01-13T23: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-13 23:57:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000634s ] [2026-01-13T23: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.000616s ] [2026-01-13T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002495s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002003s ] [2026-01-13T23: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` < 1768318082 LIMIT 100 [ RunTime:0.000438s ] [2026-01-13T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002554s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001681s ] [2026-01-13T23: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.000667s ] [2026-01-13T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002435s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001705s ] [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001220s ] [2026-01-13T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319882 AND `outtime` >= 1768318082 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000431s ] [2026-01-13T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002114s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001452s ] [2026-01-13T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001591s ] [2026-01-13T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319882 AND `outtime` >= 1768318082 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000354s ] [2026-01-13T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002687s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001865s ] [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001814s ] [2026-01-13T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1768319942 AND `outtime` >= 1768318142 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000385s ] [2026-01-13T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002368s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001498s ] [2026-01-13T23: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.000762s ] [2026-01-13T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002397s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002243s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001775s ] [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001729s ] [2026-01-13T23: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.000634s ] [2026-01-13T23:59:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:54:02' [ RunTime:0.000419s ] [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001606s ] [2026-01-13T23:59:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:54:02' [ RunTime:0.000551s ] [2026-01-13T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002252s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001635s ] [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001551s ] [2026-01-13T23:59:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2026-01-13 23:54:02' [ RunTime:0.000326s ] [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001531s ] [2026-01-13T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1768319942 AND `outtime` >= 1768318142 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000427s ] [2026-01-13T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002472s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002232s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001734s ] [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001791s ] [2026-01-13T23: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` < 1768318142 LIMIT 100 [ RunTime:0.000532s ] [2026-01-13T23: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-13 23:58:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000686s ] [2026-01-13T23:59:02+08:00][sql] CONNECT:[ UseTime:0.001821s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001280s ] [2026-01-13T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001313s ] [2026-01-13T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1768319942 AND `outtime` >= 1768318142 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000288s ]