[2025-07-22T23:28:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198082  AND `outtime` >= 1753196282  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000345s ]
[2025-07-22T23:28:02+08:00][sql] CONNECT:[ UseTime:0.002651s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002069s ]
[2025-07-22T23:28:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:23:02' [ RunTime:0.000378s ]
[2025-07-22T23:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001686s ]
[2025-07-22T23:28:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:23:02' [ RunTime:0.000352s ]
[2025-07-22T23:28:02+08:00][sql] CONNECT:[ UseTime:0.002406s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001682s ]
[2025-07-22T23:28:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:23:02' [ RunTime:0.000311s ]
[2025-07-22T23:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001580s ]
[2025-07-22T23:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001680s ]
[2025-07-22T23:28:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198082  AND `outtime` >= 1753196282  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000319s ]
[2025-07-22T23:28:02+08:00][sql] CONNECT:[ UseTime:0.002786s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001409s ]
[2025-07-22T23:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001654s ]
[2025-07-22T23:28:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198082  AND `outtime` >= 1753196282  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000349s ]
[2025-07-22T23:28:02+08:00][sql] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001645s ]
[2025-07-22T23:28:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 1  AND `sync_status` IN (0,3)  AND `created_at` <= '2025-07-22 23:27:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000492s ]
[2025-07-22T23:28:02+08:00][sql] CONNECT:[ UseTime:0.001901s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001276s ]
[2025-07-22T23:28: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.000380s ]
[2025-07-22T23:29:02+08:00][sql] CONNECT:[ UseTime:0.002705s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001837s ]
[2025-07-22T23:29: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.000501s ]
[2025-07-22T23:29:02+08:00][sql] CONNECT:[ UseTime:0.002430s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:29:02+08:00][sql] CONNECT:[ UseTime:0.002395s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001602s ]
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001738s ]
[2025-07-22T23:29:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE  `pay_status` = 0  AND `addtime` < 1753196342 LIMIT 100 [ RunTime:0.000387s ]
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001693s ]
[2025-07-22T23:29:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198142  AND `outtime` >= 1753196342  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000459s ]
[2025-07-22T23:29:02+08:00][sql] CONNECT:[ UseTime:0.002275s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001455s ]
[2025-07-22T23:29:02+08:00][sql] CONNECT:[ UseTime:0.002311s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001665s ]
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001729s ]
[2025-07-22T23:29:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198142  AND `outtime` >= 1753196342  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000342s ]
[2025-07-22T23:29:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:24:02' [ RunTime:0.000359s ]
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001666s ]
[2025-07-22T23:29:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:24:02' [ RunTime:0.000349s ]
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001609s ]
[2025-07-22T23:29:02+08:00][sql] CONNECT:[ UseTime:0.002321s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:29:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:24:02' [ RunTime:0.000317s ]
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001538s ]
[2025-07-22T23:29: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.000422s ]
[2025-07-22T23:29:02+08:00][sql] CONNECT:[ UseTime:0.002427s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001411s ]
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001546s ]
[2025-07-22T23:29:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198142  AND `outtime` >= 1753196342  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000325s ]
[2025-07-22T23:29:02+08:00][sql] CONNECT:[ UseTime:0.002563s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:29:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001431s ]
[2025-07-22T23:29:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 1  AND `sync_status` IN (0,3)  AND `created_at` <= '2025-07-22 23:28:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000468s ]
[2025-07-22T23:30:02+08:00][sql] CONNECT:[ UseTime:0.002682s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001816s ]
[2025-07-22T23: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.000499s ]
[2025-07-22T23:30:02+08:00][sql] CONNECT:[ UseTime:0.002403s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001841s ]
[2025-07-22T23:30:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE  `pay_status` = 0  AND `addtime` < 1753196402 LIMIT 100 [ RunTime:0.000380s ]
[2025-07-22T23:30:02+08:00][sql] CONNECT:[ UseTime:0.002485s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002057s ]
[2025-07-22T23:30:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:25:02' [ RunTime:0.000372s ]
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001717s ]
[2025-07-22T23:30:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:25:02' [ RunTime:0.000355s ]
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001627s ]
[2025-07-22T23:30:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:25:02' [ RunTime:0.000298s ]
[2025-07-22T23:30:02+08:00][sql] CONNECT:[ UseTime:0.002452s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001587s ]
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001735s ]
[2025-07-22T23:30:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198202  AND `outtime` >= 1753196402  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000339s ]
[2025-07-22T23:30:02+08:00][sql] CONNECT:[ UseTime:0.002402s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001581s ]
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001692s ]
[2025-07-22T23:30:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198202  AND `outtime` >= 1753196402  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000439s ]
[2025-07-22T23:30:02+08:00][sql] CONNECT:[ UseTime:0.002346s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:30:02+08:00][sql] CONNECT:[ UseTime:0.003421s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001742s ]
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001439s ]
[2025-07-22T23: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.000487s ]
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001660s ]
[2025-07-22T23:30:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198202  AND `outtime` >= 1753196402  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000527s ]
[2025-07-22T23:30:02+08:00][sql] CONNECT:[ UseTime:0.001912s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001280s ]
[2025-07-22T23:30:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 1  AND `sync_status` IN (0,3)  AND `created_at` <= '2025-07-22 23:29:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000381s ]
[2025-07-22T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002792s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001835s ]
[2025-07-22T23: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` <= '2025-07-22 23:30:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000546s ]
[2025-07-22T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002832s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001699s ]
[2025-07-22T23: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.000487s ]
[2025-07-22T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002558s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002411s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001589s ]
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001620s ]
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001648s ]
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001726s ]
s` FROM `trade_role` WHERE  `outtime` <= 1753198262  AND `outtime` >= 1753196462  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000347s ]
[2025-07-22T23:31:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198262  AND `outtime` >= 1753196462  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000348s ]
[2025-07-22T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002283s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001750s ]
[2025-07-22T23:31:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:26:02' [ RunTime:0.000352s ]
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001637s ]
[2025-07-22T23:31:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:26:02' [ RunTime:0.000361s ]
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001651s ]
[2025-07-22T23:31:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:26:02' [ RunTime:0.000301s ]
[2025-07-22T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002665s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002371s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001806s ]
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001745s ]
[2025-07-22T23: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` < 1753196462 LIMIT 100 [ RunTime:0.000465s ]
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001637s ]
[2025-07-22T23:31:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198262  AND `outtime` >= 1753196462  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000331s ]
[2025-07-22T23:31:02+08:00][sql] CONNECT:[ UseTime:0.002439s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:31:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001476s ]
[2025-07-22T23: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.000465s ]
[2025-07-22T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002708s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001828s ]
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001765s ]
[2025-07-22T23:32:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198322  AND `outtime` >= 1753196522  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000343s ]
[2025-07-22T23:32:02+08:00][sql] CONNECT:[ UseTime:0.003880s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001671s ]
[2025-07-22T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002395s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23: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.000450s ]
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001533s ]
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001685s ]
[2025-07-22T23:32:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198322  AND `outtime` >= 1753196522  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000370s ]
[2025-07-22T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002629s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001684s ]
[2025-07-22T23: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.000452s ]
[2025-07-22T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002479s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001856s ]
[2025-07-22T23:32:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:27:02' [ RunTime:0.000366s ]
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001661s ]
[2025-07-22T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002309s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:32:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:27:02' [ RunTime:0.000361s ]
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001661s ]
[2025-07-22T23: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` < 1753196522 LIMIT 100 [ RunTime:0.000534s ]
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001568s ]
[2025-07-22T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:32:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:27:02' [ RunTime:0.000290s ]
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001656s ]
[2025-07-22T23: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` <= '2025-07-22 23:31:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000497s ]
[2025-07-22T23:32:02+08:00][sql] CONNECT:[ UseTime:0.002055s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001357s ]
[2025-07-22T23:32:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001312s ]
[2025-07-22T23:32:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198322  AND `outtime` >= 1753196522  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000349s ]
[2025-07-22T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002812s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002007s ]
[2025-07-22T23: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` < 1753196582 LIMIT 100 [ RunTime:0.000420s ]
[2025-07-22T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002555s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001683s ]
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001726s ]
[2025-07-22T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002548s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:33:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198382  AND `outtime` >= 1753196582  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000364s ]
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001947s ]
[2025-07-22T23:33:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:28:02' [ RunTime:0.000344s ]
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001681s ]
[2025-07-22T23:33:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:28:02' [ RunTime:0.000348s ]
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001602s ]
[2025-07-22T23:33:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:28:02' [ RunTime:0.000308s ]
[2025-07-22T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002437s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001553s ]
[2025-07-22T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002461s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23: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.000422s ]
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001436s ]
[2025-07-22T23: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.000431s ]
[2025-07-22T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002571s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001791s ]
[2025-07-22T23: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` <= '2025-07-22 23:32:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000604s ]
[2025-07-22T23:33:02+08:00][sql] CONNECT:[ UseTime:0.002057s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001319s ]
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001275s ]
[2025-07-22T23:33:02+08:00][sql] CONNECT:[ UseTime:0.001937s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:33:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198382  AND `outtime` >= 1753196582  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000316s ]
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001243s ]
[2025-07-22T23:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001406s ]
[2025-07-22T23:33:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198382  AND `outtime` >= 1753196582  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000355s ]
[2025-07-22T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002578s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:34:02+08:00][sql] CONNECT:[ UseTime:0.003374s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001820s ]
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001583s ]
[2025-07-22T23: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` <= '2025-07-22 23:33:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000498s ]
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001708s ]
[2025-07-22T23:34:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198442  AND `outtime` >= 1753196642  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000351s ]
[2025-07-22T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002530s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001686s ]
[2025-07-22T23:34:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:29:02' [ RunTime:0.000342s ]
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001672s ]
[2025-07-22T23:34:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:29:02' [ RunTime:0.000361s ]
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001670s ]
[2025-07-22T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002538s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:34:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:29:02' [ RunTime:0.000299s ]
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001621s ]
[2025-07-22T23: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` < 1753196642 LIMIT 100 [ RunTime:0.000361s ]
[2025-07-22T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002669s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002365s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001828s ]
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001563s ]
[2025-07-22T23: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.000433s ]
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001749s ]
[2025-07-22T23:34:02+08:00][sql] CONNECT:[ UseTime:0.002387s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:34:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198442  AND `outtime` >= 1753196642  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000319s ]
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001452s ]
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001686s ]
[2025-07-22T23:34:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198442  AND `outtime` >= 1753196642  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000447s ]
[2025-07-22T23:34:02+08:00][sql] CONNECT:[ UseTime:0.001947s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:34:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001199s ]
[2025-07-22T23: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.000397s ]
[2025-07-22T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002565s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001968s ]
[2025-07-22T23: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` < 1753196702 LIMIT 100 [ RunTime:0.000408s ]
[2025-07-22T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002501s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001780s ]
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001684s ]
[2025-07-22T23:35:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198502  AND `outtime` >= 1753196702  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000354s ]
[2025-07-22T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002549s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001769s ]
[2025-07-22T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002407s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23: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.000479s ]
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001556s ]
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001706s ]
[2025-07-22T23:35:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198502  AND `outtime` >= 1753196702  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000332s ]
[2025-07-22T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002566s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002091s ]
[2025-07-22T23:35:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:30:02' [ RunTime:0.000418s ]
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001600s ]
[2025-07-22T23:35:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:30:02' [ RunTime:0.000386s ]
[2025-07-22T23:35:02+08:00][sql] CONNECT:[ UseTime:0.003120s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001606s ]
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001667s ]
[2025-07-22T23:35:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:30:02' [ RunTime:0.000304s ]
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001569s ]
[2025-07-22T23:35:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198502  AND `outtime` >= 1753196702  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000363s ]
[2025-07-22T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002341s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001698s ]
[2025-07-22T23:35:02+08:00][sql] CONNECT:[ UseTime:0.002344s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23: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` <= '2025-07-22 23:34:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000524s ]
[2025-07-22T23:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001378s ]
[2025-07-22T23: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.000445s ]
[2025-07-22T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002649s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001817s ]
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001707s ]
[2025-07-22T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002513s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:36:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198562  AND `outtime` >= 1753196762  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000393s ]
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001683s ]
[2025-07-22T23: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` < 1753196762 LIMIT 100 [ RunTime:0.000366s ]
[2025-07-22T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002604s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001802s ]
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001737s ]
[2025-07-22T23:36:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198562  AND `outtime` >= 1753196762  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000340s ]
[2025-07-22T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002446s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001556s ]
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001749s ]
[2025-07-22T23:36:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198562  AND `outtime` >= 1753196762  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000543s ]
[2025-07-22T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001497s ]
[2025-07-22T23: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` <= '2025-07-22 23:35:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000476s ]
[2025-07-22T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002555s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001476s ]
[2025-07-22T23: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.000450s ]
[2025-07-22T23:36:02+08:00][sql] CONNECT:[ UseTime:0.002449s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001631s ]
[2025-07-22T23: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.000458s ]
[2025-07-22T23:36:02+08:00][sql] CONNECT:[ UseTime:0.001958s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001449s ]
[2025-07-22T23:36:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:31:02' [ RunTime:0.000287s ]
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001196s ]
[2025-07-22T23:36:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:31:02' [ RunTime:0.000286s ]
[2025-07-22T23:36:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001096s ]
[2025-07-22T23:36:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:31:02' [ RunTime:0.000249s ]
[2025-07-22T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002702s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001806s ]
[2025-07-22T23: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` <= '2025-07-22 23:36:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000516s ]
[2025-07-22T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002433s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001614s ]
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001811s ]
[2025-07-22T23:37:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198622  AND `outtime` >= 1753196822  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000365s ]
[2025-07-22T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002469s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001433s ]
[2025-07-22T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002376s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23: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.000435s ]
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001465s ]
[2025-07-22T23: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.000455s ]
[2025-07-22T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002672s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001821s ]
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001851s ]
[2025-07-22T23:37:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198622  AND `outtime` >= 1753196822  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000365s ]
[2025-07-22T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001716s ]
[2025-07-22T23: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` < 1753196822 LIMIT 100 [ RunTime:0.000358s ]
[2025-07-22T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:37:02+08:00][sql] CONNECT:[ UseTime:0.002338s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001898s ]
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001435s ]
[2025-07-22T23:37:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:32:02' [ RunTime:0.000407s ]
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001504s ]
[2025-07-22T23:37:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:32:02' [ RunTime:0.000356s ]
[2025-07-22T23:37:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198622  AND `outtime` >= 1753196822  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000343s ]
[2025-07-22T23:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001593s ]
[2025-07-22T23:37:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:32:02' [ RunTime:0.000297s ]
[2025-07-22T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002719s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002113s ]
[2025-07-22T23:38:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:33:02' [ RunTime:0.000427s ]
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001790s ]
[2025-07-22T23:38:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:33:02' [ RunTime:0.000427s ]
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001685s ]
[2025-07-22T23:38:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:33:02' [ RunTime:0.000383s ]
[2025-07-22T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002692s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002017s ]
[2025-07-22T23: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` < 1753196882 LIMIT 100 [ RunTime:0.000489s ]
[2025-07-22T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002549s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001793s ]
[2025-07-22T23: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.000470s ]
[2025-07-22T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002381s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001723s ]
[2025-07-22T23: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` <= '2025-07-22 23:37:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000481s ]
[2025-07-22T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002333s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001582s ]
[2025-07-22T23: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.000547s ]
[2025-07-22T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002375s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001525s ]
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001641s ]
[2025-07-22T23:38:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198682  AND `outtime` >= 1753196882  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000356s ]
[2025-07-22T23:38:02+08:00][sql] CONNECT:[ UseTime:0.002380s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001575s ]
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001683s ]
[2025-07-22T23:38:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198682  AND `outtime` >= 1753196882  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000348s ]
[2025-07-22T23:38:02+08:00][sql] CONNECT:[ UseTime:0.001985s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001264s ]
[2025-07-22T23:38:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001191s ]
[2025-07-22T23:38:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198682  AND `outtime` >= 1753196882  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000302s ]
[2025-07-22T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002663s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001944s ]
[2025-07-22T23: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.000504s ]
[2025-07-22T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002560s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001765s ]
[2025-07-22T23: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` < 1753196942 LIMIT 100 [ RunTime:0.000381s ]
[2025-07-22T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002527s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001560s ]
[2025-07-22T23: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` <= '2025-07-22 23:38:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000475s ]
[2025-07-22T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002453s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002403s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001521s ]
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001812s ]
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001675s ]
[2025-07-22T23:39:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:34:02' [ RunTime:0.000448s ]
[2025-07-22T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002291s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:39:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198742  AND `outtime` >= 1753196942  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000351s ]
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001504s ]
[2025-07-22T23:39:02+08:00][sql] CONNECT:[ UseTime:0.002273s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001758s ]
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001651s ]
[2025-07-22T23:39:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:34:02' [ RunTime:0.000446s ]
[2025-07-22T23:39:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198742  AND `outtime` >= 1753196942  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000416s ]
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001679s ]
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001807s ]
[2025-07-22T23:39:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:34:02' [ RunTime:0.000440s ]
[2025-07-22T23:39:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198742  AND `outtime` >= 1753196942  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000292s ]
[2025-07-22T23:39:02+08:00][sql] CONNECT:[ UseTime:0.001919s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:39:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001259s ]
[2025-07-22T23: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.000366s ]
[2025-07-22T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002643s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001810s ]
[2025-07-22T23: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.000497s ]
[2025-07-22T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002545s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001724s ]
[2025-07-22T23: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` <= '2025-07-22 23:39:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000504s ]
[2025-07-22T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002470s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001692s ]
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.002070s ]
[2025-07-22T23:40:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198802  AND `outtime` >= 1753197002  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000375s ]
[2025-07-22T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002517s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001855s ]
[2025-07-22T23: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` < 1753197002 LIMIT 100 [ RunTime:0.000373s ]
[2025-07-22T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002556s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001572s ]
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001752s ]
[2025-07-22T23:40:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198802  AND `outtime` >= 1753197002  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000343s ]
[2025-07-22T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002568s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001569s ]
[2025-07-22T23:40:02+08:00][sql] CONNECT:[ UseTime:0.002305s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001670s ]
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001831s ]
[2025-07-22T23:40:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:35:02' [ RunTime:0.000361s ]
[2025-07-22T23:40:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198802  AND `outtime` >= 1753197002  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000333s ]
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001736s ]
[2025-07-22T23:40:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:35:02' [ RunTime:0.000424s ]
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001573s ]
[2025-07-22T23:40:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:35:02' [ RunTime:0.000310s ]
[2025-07-22T23:40:02+08:00][sql] CONNECT:[ UseTime:0.001873s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:40:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001253s ]
[2025-07-22T23: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.000416s ]
[2025-07-22T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002655s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001807s ]
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001786s ]
[2025-07-22T23:41:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198862  AND `outtime` >= 1753197062  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000471s ]
[2025-07-22T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002690s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001695s ]
[2025-07-22T23: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` < 1753197062 LIMIT 100 [ RunTime:0.000386s ]
[2025-07-22T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002418s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001485s ]
[2025-07-22T23: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.000462s ]
[2025-07-22T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002368s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001748s ]
[2025-07-22T23:41:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:36:02' [ RunTime:0.000356s ]
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001624s ]
[2025-07-22T23:41:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:36:02' [ RunTime:0.000341s ]
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001635s ]
[2025-07-22T23:41:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:36:02' [ RunTime:0.000298s ]
[2025-07-22T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002639s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001782s ]
[2025-07-22T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002358s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001748s ]
[2025-07-22T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002397s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001449s ]
[2025-07-22T23:41:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198862  AND `outtime` >= 1753197062  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000309s ]
[2025-07-22T23: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.000406s ]
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001470s ]
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001643s ]
[2025-07-22T23:41:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198862  AND `outtime` >= 1753197062  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000328s ]
[2025-07-22T23:41:02+08:00][sql] CONNECT:[ UseTime:0.002429s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001594s ]
[2025-07-22T23:41:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 1  AND `sync_status` IN (0,3)  AND `created_at` <= '2025-07-22 23:40:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000439s ]
[2025-07-22T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002714s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002030s ]
[2025-07-22T23: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` < 1753197122 LIMIT 100 [ RunTime:0.000417s ]
[2025-07-22T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002484s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001696s ]
[2025-07-22T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002362s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001760s ]
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001509s ]
[2025-07-22T23:42:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198922  AND `outtime` >= 1753197122  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000416s ]
[2025-07-22T23: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.000445s ]
[2025-07-22T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002363s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001652s ]
[2025-07-22T23: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.000452s ]
[2025-07-22T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002358s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001688s ]
[2025-07-22T23: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` <= '2025-07-22 23:41:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000479s ]
[2025-07-22T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002506s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001552s ]
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001718s ]
[2025-07-22T23:42:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198922  AND `outtime` >= 1753197122  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000379s ]
[2025-07-22T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002361s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001511s ]
[2025-07-22T23:42:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:37:02' [ RunTime:0.000344s ]
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001453s ]
[2025-07-22T23:42:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:37:02' [ RunTime:0.000343s ]
[2025-07-22T23:42:02+08:00][sql] CONNECT:[ UseTime:0.002274s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001546s ]
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001450s ]
[2025-07-22T23:42:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:37:02' [ RunTime:0.000360s ]
[2025-07-22T23:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001540s ]
[2025-07-22T23:42:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198922  AND `outtime` >= 1753197122  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000314s ]
[2025-07-22T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002687s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001846s ]
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001771s ]
[2025-07-22T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002446s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:43:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753198982  AND `outtime` >= 1753197182  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000360s ]
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001518s ]
[2025-07-22T23: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.000447s ]
[2025-07-22T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001870s ]
[2025-07-22T23:43:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:38:02' [ RunTime:0.000357s ]
[2025-07-22T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002305s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001683s ]
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001506s ]
[2025-07-22T23:43:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:38:02' [ RunTime:0.000354s ]
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001688s ]
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001569s ]
[2025-07-22T23:43:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753198982  AND `outtime` >= 1753197182  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000357s ]
[2025-07-22T23:43:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:38:02' [ RunTime:0.000305s ]
[2025-07-22T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002623s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001831s ]
[2025-07-22T23: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` <= '2025-07-22 23:42:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000512s ]
[2025-07-22T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002529s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001922s ]
[2025-07-22T23: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` < 1753197182 LIMIT 100 [ RunTime:0.000452s ]
[2025-07-22T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002510s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001708s ]
[2025-07-22T23:43:02+08:00][sql] CONNECT:[ UseTime:0.002192s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001720s ]
[2025-07-22T23:43:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001567s ]
[2025-07-22T23:43:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753198982  AND `outtime` >= 1753197182  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000356s ]
[2025-07-22T23: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.000469s ]
[2025-07-22T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002790s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:44:02+08:00][sql] CONNECT:[ UseTime:0.003025s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001846s ]
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001575s ]
[2025-07-22T23: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.000456s ]
[2025-07-22T23: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.000413s ]
[2025-07-22T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002815s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001848s ]
[2025-07-22T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002377s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:44:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:39:02' [ RunTime:0.000358s ]
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001503s ]
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001688s ]
[2025-07-22T23:44:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:39:02' [ RunTime:0.000354s ]
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001698s ]
[2025-07-22T23:44:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199042  AND `outtime` >= 1753197242  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000305s ]
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001575s ]
[2025-07-22T23:44:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:39:02' [ RunTime:0.000291s ]
[2025-07-22T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002661s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002220s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001678s ]
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001640s ]
[2025-07-22T23: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` < 1753197242 LIMIT 100 [ RunTime:0.000396s ]
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001800s ]
[2025-07-22T23:44:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199042  AND `outtime` >= 1753197242  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000378s ]
[2025-07-22T23:44:02+08:00][sql] CONNECT:[ UseTime:0.002308s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001487s ]
[2025-07-22T23: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` <= '2025-07-22 23:43:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000547s ]
[2025-07-22T23:44:02+08:00][sql] CONNECT:[ UseTime:0.001948s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001315s ]
[2025-07-22T23:44:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001281s ]
[2025-07-22T23:44:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199042  AND `outtime` >= 1753197242  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000283s ]
[2025-07-22T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002577s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002104s ]
[2025-07-22T23:45:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:40:02' [ RunTime:0.000399s ]
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001721s ]
[2025-07-22T23:45:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:40:02' [ RunTime:0.000363s ]
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001575s ]
[2025-07-22T23:45:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:40:02' [ RunTime:0.000305s ]
[2025-07-22T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001538s ]
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001725s ]
[2025-07-22T23:45:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199102  AND `outtime` >= 1753197302  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000367s ]
[2025-07-22T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002373s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001498s ]
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001687s ]
[2025-07-22T23:45:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199102  AND `outtime` >= 1753197302  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000327s ]
[2025-07-22T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002347s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001519s ]
[2025-07-22T23: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.000461s ]
[2025-07-22T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002716s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001899s ]
[2025-07-22T23: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.000516s ]
[2025-07-22T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002451s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001723s ]
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001766s ]
[2025-07-22T23:45:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199102  AND `outtime` >= 1753197302  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000327s ]
[2025-07-22T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002345s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001770s ]
[2025-07-22T23: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` < 1753197302 LIMIT 100 [ RunTime:0.000409s ]
[2025-07-22T23:45:02+08:00][sql] CONNECT:[ UseTime:0.002477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:45:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001197s ]
[2025-07-22T23: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` <= '2025-07-22 23:44:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000426s ]
[2025-07-22T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002663s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002027s ]
[2025-07-22T23: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` < 1753197362 LIMIT 100 [ RunTime:0.000406s ]
[2025-07-22T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002662s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001755s ]
[2025-07-22T23: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.000564s ]
[2025-07-22T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002335s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001647s ]
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001734s ]
[2025-07-22T23:46:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199162  AND `outtime` >= 1753197362  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000349s ]
[2025-07-22T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002315s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001601s ]
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001660s ]
[2025-07-22T23:46:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199162  AND `outtime` >= 1753197362  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000340s ]
[2025-07-22T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002554s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001568s ]
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001693s ]
[2025-07-22T23:46:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199162  AND `outtime` >= 1753197362  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000374s ]
[2025-07-22T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002575s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001737s ]
[2025-07-22T23: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` <= '2025-07-22 23:45:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000523s ]
[2025-07-22T23:46:02+08:00][sql] CONNECT:[ UseTime:0.002826s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001723s ]
[2025-07-22T23: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.000457s ]
[2025-07-22T23:46:02+08:00][sql] CONNECT:[ UseTime:0.001933s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001413s ]
[2025-07-22T23:46:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:41:02' [ RunTime:0.000299s ]
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001226s ]
[2025-07-22T23:46:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:41:02' [ RunTime:0.000279s ]
[2025-07-22T23:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001111s ]
[2025-07-22T23:46:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:41:02' [ RunTime:0.000246s ]
[2025-07-22T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002699s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001806s ]
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001907s ]
[2025-07-22T23:47:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199222  AND `outtime` >= 1753197422  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000372s ]
[2025-07-22T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002433s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001492s ]
[2025-07-22T23: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.000463s ]
[2025-07-22T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002426s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001636s ]
[2025-07-22T23: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` < 1753197422 LIMIT 100 [ RunTime:0.000386s ]
[2025-07-22T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002465s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002373s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001839s ]
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001537s ]
[2025-07-22T23:47:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:42:02' [ RunTime:0.000333s ]
[2025-07-22T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002355s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001674s ]
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001739s ]
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001430s ]
[2025-07-22T23:47:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199222  AND `outtime` >= 1753197422  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000333s ]
[2025-07-22T23:47:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:42:02' [ RunTime:0.000386s ]
[2025-07-22T23: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.000525s ]
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001675s ]
[2025-07-22T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002614s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:47:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:42:02' [ RunTime:0.000304s ]
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001789s ]
[2025-07-22T23: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` <= '2025-07-22 23:46:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000461s ]
[2025-07-22T23:47:02+08:00][sql] CONNECT:[ UseTime:0.002432s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001674s ]
[2025-07-22T23:47:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001710s ]
[2025-07-22T23:47:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199222  AND `outtime` >= 1753197422  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000433s ]
[2025-07-22T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002588s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001835s ]
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001793s ]
[2025-07-22T23:48:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199282  AND `outtime` >= 1753197482  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000385s ]
[2025-07-22T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002452s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001828s ]
[2025-07-22T23: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` < 1753197482 LIMIT 100 [ RunTime:0.000406s ]
[2025-07-22T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002626s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001793s ]
[2025-07-22T23: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` <= '2025-07-22 23:47:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000527s ]
[2025-07-22T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002734s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:48:02+08:00][sql] CONNECT:[ UseTime:0.003659s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001772s ]
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001435s ]
[2025-07-22T23: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.000459s ]
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001660s ]
[2025-07-22T23:48:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199282  AND `outtime` >= 1753197482  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000345s ]
[2025-07-22T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002460s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001721s ]
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001794s ]
[2025-07-22T23:48:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199282  AND `outtime` >= 1753197482  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000375s ]
[2025-07-22T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002064s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:48:02+08:00][sql] CONNECT:[ UseTime:0.002272s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001478s ]
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001498s ]
[2025-07-22T23:48:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:43:02' [ RunTime:0.000311s ]
[2025-07-22T23: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.000430s ]
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001273s ]
[2025-07-22T23:48:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:43:02' [ RunTime:0.000321s ]
[2025-07-22T23:48:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001306s ]
[2025-07-22T23:48:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:43:02' [ RunTime:0.000295s ]
[2025-07-22T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002534s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001790s ]
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001496s ]
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001731s ]
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001682s ]
[2025-07-22T23:49:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199342  AND `outtime` >= 1753197542  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000338s ]
[2025-07-22T23:49:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199342  AND `outtime` >= 1753197542  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000318s ]
[2025-07-22T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002409s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001853s ]
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001524s ]
[2025-07-22T23:49:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:44:02' [ RunTime:0.000348s ]
[2025-07-22T23: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` <= '2025-07-22 23:48:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000562s ]
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001626s ]
[2025-07-22T23:49:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:44:02' [ RunTime:0.000357s ]
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001678s ]
[2025-07-22T23:49:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:44:02' [ RunTime:0.000326s ]
[2025-07-22T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002601s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001763s ]
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001704s ]
[2025-07-22T23:49:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199342  AND `outtime` >= 1753197542  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000366s ]
[2025-07-22T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002553s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001851s ]
[2025-07-22T23:49:02+08:00][sql] CONNECT:[ UseTime:0.002395s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23: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` < 1753197542 LIMIT 100 [ RunTime:0.000368s ]
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001517s ]
[2025-07-22T23: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.000614s ]
[2025-07-22T23:49:02+08:00][sql] CONNECT:[ UseTime:0.001945s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:49:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001289s ]
[2025-07-22T23: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.000365s ]
[2025-07-22T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002712s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002012s ]
[2025-07-22T23: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` < 1753197602 LIMIT 100 [ RunTime:0.000403s ]
[2025-07-22T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002371s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001627s ]
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001782s ]
[2025-07-22T23:50:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199402  AND `outtime` >= 1753197602  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000323s ]
[2025-07-22T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002668s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001571s ]
[2025-07-22T23: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` <= '2025-07-22 23:49:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000492s ]
[2025-07-22T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002470s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001575s ]
[2025-07-22T23: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.000449s ]
[2025-07-22T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002771s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002081s ]
[2025-07-22T23:50:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:45:02' [ RunTime:0.000380s ]
[2025-07-22T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002971s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001596s ]
[2025-07-22T23:50:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:45:02' [ RunTime:0.000338s ]
[2025-07-22T23:50:02+08:00][sql] CONNECT:[ UseTime:0.005328s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001653s ]
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001656s ]
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001589s ]
[2025-07-22T23:50:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199402  AND `outtime` >= 1753197602  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000330s ]
[2025-07-22T23:50:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:45:02' [ RunTime:0.000292s ]
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001784s ]
[2025-07-22T23:50:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199402  AND `outtime` >= 1753197602  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000329s ]
[2025-07-22T23:50:02+08:00][sql] CONNECT:[ UseTime:0.002329s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:50:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001501s ]
[2025-07-22T23: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.000587s ]
[2025-07-22T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002643s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001814s ]
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001817s ]
[2025-07-22T23:51:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199462  AND `outtime` >= 1753197662  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000451s ]
[2025-07-22T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002617s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001653s ]
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001718s ]
[2025-07-22T23:51:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199462  AND `outtime` >= 1753197662  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000338s ]
[2025-07-22T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002424s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002428s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001556s ]
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001465s ]
[2025-07-22T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002308s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23: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.000501s ]
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001768s ]
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001423s ]
[2025-07-22T23:51:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199462  AND `outtime` >= 1753197662  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000338s ]
[2025-07-22T23: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` <= '2025-07-22 23:50:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000439s ]
[2025-07-22T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002439s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001678s ]
[2025-07-22T23: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.000479s ]
[2025-07-22T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002582s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001757s ]
[2025-07-22T23: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` < 1753197662 LIMIT 100 [ RunTime:0.000425s ]
[2025-07-22T23:51:02+08:00][sql] CONNECT:[ UseTime:0.002026s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001483s ]
[2025-07-22T23:51:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:46:02' [ RunTime:0.000308s ]
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001175s ]
[2025-07-22T23:51:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:46:02' [ RunTime:0.000276s ]
[2025-07-22T23:51:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001089s ]
[2025-07-22T23:51:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:46:02' [ RunTime:0.000232s ]
[2025-07-22T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002579s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001803s ]
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001700s ]
[2025-07-22T23:52:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199522  AND `outtime` >= 1753197722  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000399s ]
[2025-07-22T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002388s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001604s ]
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001675s ]
[2025-07-22T23:52:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199522  AND `outtime` >= 1753197722  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000323s ]
[2025-07-22T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002427s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001573s ]
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001808s ]
[2025-07-22T23:52:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199522  AND `outtime` >= 1753197722  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000374s ]
[2025-07-22T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002548s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001912s ]
[2025-07-22T23:52:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:47:02' [ RunTime:0.000445s ]
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001759s ]
[2025-07-22T23:52:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:47:02' [ RunTime:0.000426s ]
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001681s ]
[2025-07-22T23:52:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:47:02' [ RunTime:0.000379s ]
[2025-07-22T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002713s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002299s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001946s ]
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001535s ]
[2025-07-22T23: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` < 1753197722 LIMIT 100 [ RunTime:0.000373s ]
[2025-07-22T23: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` <= '2025-07-22 23:51:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000489s ]
[2025-07-22T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002466s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001889s ]
[2025-07-22T23: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.000473s ]
[2025-07-22T23:52:02+08:00][sql] CONNECT:[ UseTime:0.002053s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001289s ]
[2025-07-22T23: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.000389s ]
[2025-07-22T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002770s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001817s ]
[2025-07-22T23: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` <= '2025-07-22 23:52:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000531s ]
[2025-07-22T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002473s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001809s ]
[2025-07-22T23: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` < 1753197782 LIMIT 100 [ RunTime:0.000390s ]
[2025-07-22T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002516s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001975s ]
[2025-07-22T23:53:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:48:02' [ RunTime:0.000376s ]
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001683s ]
[2025-07-22T23:53:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:48:02' [ RunTime:0.000373s ]
[2025-07-22T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002503s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001532s ]
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001666s ]
[2025-07-22T23:53:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:48:02' [ RunTime:0.000486s ]
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001557s ]
[2025-07-22T23:53:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199582  AND `outtime` >= 1753197782  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000343s ]
[2025-07-22T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002361s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001581s ]
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001689s ]
[2025-07-22T23:53:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199582  AND `outtime` >= 1753197782  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000340s ]
[2025-07-22T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001815s ]
[2025-07-22T23: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.000513s ]
[2025-07-22T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002358s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001685s ]
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001604s ]
[2025-07-22T23:53:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199582  AND `outtime` >= 1753197782  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000419s ]
[2025-07-22T23:53:02+08:00][sql] CONNECT:[ UseTime:0.002207s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:53:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001239s ]
[2025-07-22T23: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.000402s ]
[2025-07-22T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002698s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002604s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001911s ]
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001571s ]
[2025-07-22T23: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` <= '2025-07-22 23:53:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000471s ]
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001772s ]
[2025-07-22T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199642  AND `outtime` >= 1753197842  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000614s ]
[2025-07-22T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002674s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001675s ]
[2025-07-22T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002425s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001705s ]
[2025-07-22T23:54:02+08:00][sql] CONNECT:[ UseTime:0.003146s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001677s ]
[2025-07-22T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199642  AND `outtime` >= 1753197842  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000327s ]
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001501s ]
[2025-07-22T23:54:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:49:02' [ RunTime:0.000342s ]
[2025-07-22T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002397s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001727s ]
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001557s ]
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001487s ]
[2025-07-22T23:54:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:49:02' [ RunTime:0.000357s ]
[2025-07-22T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199642  AND `outtime` >= 1753197842  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000358s ]
[2025-07-22T23: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.000417s ]
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001588s ]
[2025-07-22T23:54:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:49:02' [ RunTime:0.000300s ]
[2025-07-22T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002424s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001850s ]
[2025-07-22T23: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.000494s ]
[2025-07-22T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002029s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001514s ]
[2025-07-22T23: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` < 1753197842 LIMIT 100 [ RunTime:0.000337s ]
[2025-07-22T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002715s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001817s ]
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001794s ]
[2025-07-22T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199702  AND `outtime` >= 1753197902  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000368s ]
[2025-07-22T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001475s ]
[2025-07-22T23: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` <= '2025-07-22 23:54:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000498s ]
[2025-07-22T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002658s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001856s ]
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001837s ]
[2025-07-22T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199702  AND `outtime` >= 1753197902  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000453s ]
[2025-07-22T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002544s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002073s ]
[2025-07-22T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002442s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002295s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:55:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:50:02' [ RunTime:0.000350s ]
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001648s ]
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001664s ]
[2025-07-22T23: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.000571s ]
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001642s ]
[2025-07-22T23: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` < 1753197902 LIMIT 100 [ RunTime:0.000363s ]
[2025-07-22T23:55:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:50:02' [ RunTime:0.000361s ]
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001610s ]
[2025-07-22T23:55:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:50:02' [ RunTime:0.000297s ]
[2025-07-22T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002664s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001421s ]
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001568s ]
[2025-07-22T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199702  AND `outtime` >= 1753197902  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000475s ]
[2025-07-22T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002351s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001502s ]
[2025-07-22T23: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.000431s ]
[2025-07-22T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002682s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001811s ]
[2025-07-22T23: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` <= '2025-07-22 23:55:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000511s ]
[2025-07-22T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002581s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001641s ]
[2025-07-22T23: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.000528s ]
[2025-07-22T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002251s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001742s ]
[2025-07-22T23:56:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:51:02' [ RunTime:0.000346s ]
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001633s ]
[2025-07-22T23:56:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:51:02' [ RunTime:0.000353s ]
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001599s ]
[2025-07-22T23:56:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:51:02' [ RunTime:0.000304s ]
[2025-07-22T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002328s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001434s ]
[2025-07-22T23: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.000644s ]
[2025-07-22T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002495s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001657s ]
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001663s ]
[2025-07-22T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199762  AND `outtime` >= 1753197962  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000357s ]
[2025-07-22T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002673s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001763s ]
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001749s ]
[2025-07-22T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199762  AND `outtime` >= 1753197962  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000340s ]
[2025-07-22T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002571s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001655s ]
[2025-07-22T23: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` < 1753197962 LIMIT 100 [ RunTime:0.000421s ]
[2025-07-22T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002317s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001491s ]
[2025-07-22T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001475s ]
[2025-07-22T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199762  AND `outtime` >= 1753197962  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000317s ]
[2025-07-22T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002712s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001810s ]
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001750s ]
[2025-07-22T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199822  AND `outtime` >= 1753198022  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000362s ]
[2025-07-22T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002483s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001754s ]
[2025-07-22T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002364s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001530s ]
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001720s ]
[2025-07-22T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199822  AND `outtime` >= 1753198022  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000339s ]
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001668s ]
[2025-07-22T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199822  AND `outtime` >= 1753198022  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000325s ]
[2025-07-22T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002382s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001804s ]
[2025-07-22T23: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` < 1753198022 LIMIT 100 [ RunTime:0.000364s ]
[2025-07-22T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002518s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001795s ]
[2025-07-22T23: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.000484s ]
[2025-07-22T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002907s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.002062s ]
[2025-07-22T23: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.000591s ]
[2025-07-22T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002288s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001415s ]
[2025-07-22T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 1  AND `sync_status` IN (0,3)  AND `created_at` <= '2025-07-22 23:56:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000490s ]
[2025-07-22T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002287s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001675s ]
[2025-07-22T23:57:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:52:02' [ RunTime:0.000346s ]
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001357s ]
[2025-07-22T23:57:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:52:02' [ RunTime:0.000329s ]
[2025-07-22T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001564s ]
[2025-07-22T23:57:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:52:02' [ RunTime:0.000266s ]
[2025-07-22T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002592s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001852s ]
[2025-07-22T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001579s ]
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001718s ]
[2025-07-22T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199882  AND `outtime` >= 1753198082  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000356s ]
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001705s ]
[2025-07-22T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199882  AND `outtime` >= 1753198082  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000357s ]
[2025-07-22T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002967s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001810s ]
[2025-07-22T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 1  AND `sync_status` IN (0,3)  AND `created_at` <= '2025-07-22 23:57:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000526s ]
[2025-07-22T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002611s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002009s ]
[2025-07-22T23:58:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:53:02' [ RunTime:0.000355s ]
[2025-07-22T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002488s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002404s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001626s ]
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001832s ]
[2025-07-22T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002633s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001472s ]
[2025-07-22T23: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.000447s ]
[2025-07-22T23:58:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:53:02' [ RunTime:0.000486s ]
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001493s ]
[2025-07-22T23: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.000468s ]
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001699s ]
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001864s ]
[2025-07-22T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199882  AND `outtime` >= 1753198082  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000370s ]
[2025-07-22T23:58:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:53:02' [ RunTime:0.000530s ]
[2025-07-22T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002510s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001985s ]
[2025-07-22T23: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` < 1753198082 LIMIT 100 [ RunTime:0.000399s ]
[2025-07-22T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002657s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001824s ]
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001798s ]
[2025-07-22T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002506s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE  `outtime` <= 1753199942  AND `outtime` >= 1753198142  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000340s ]
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001692s ]
[2025-07-22T23: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` < 1753198142 LIMIT 100 [ RunTime:0.000364s ]
[2025-07-22T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002545s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001575s ]
[2025-07-22T23: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.000443s ]
[2025-07-22T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002546s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001866s ]
[2025-07-22T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE  `type` = 1  AND `sync_status` IN (0,3)  AND `created_at` <= '2025-07-22 23:58:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000533s ]
[2025-07-22T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002579s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001737s ]
[2025-07-22T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001786s ]
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001770s ]
[2025-07-22T23:59:02+08:00][sql] UPDATE `trade_gold`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:54:02' [ RunTime:0.000362s ]
[2025-07-22T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE  `outtime` <= 1753199942  AND `outtime` >= 1753198142  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000384s ]
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001651s ]
[2025-07-22T23:59:02+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:54:02' [ RunTime:0.000345s ]
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001601s ]
[2025-07-22T23:59:02+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 2  WHERE  `trade_status` = 1  AND `created_at` <= '2025-07-22 23:54:02' [ RunTime:0.000303s ]
[2025-07-22T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002451s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001482s ]
[2025-07-22T23: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.000492s ]
[2025-07-22T23:59:02+08:00][sql] CONNECT:[ UseTime:0.001934s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001219s ]
[2025-07-22T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001295s ]
[2025-07-22T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE  `outtime` <= 1753199942  AND `outtime` >= 1753198142  AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000298s ]