[2025-08-01T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001502s ] [2025-08-01T23:48:01+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-08-01 23:47:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000527s ] [2025-08-01T23:48:01+08:00][sql] CONNECT:[ UseTime:0.002413s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001317s ] [2025-08-01T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001551s ] [2025-08-01T23:48:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063281 AND `outtime` >= 1754061481 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000339s ] [2025-08-01T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002844s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002007s ] [2025-08-01T23:49:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1754061541 LIMIT 100 [ RunTime:0.000377s ] [2025-08-01T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002449s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001662s ] [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001675s ] [2025-08-01T23:49:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1754063341 AND `outtime` >= 1754061541 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000365s ] [2025-08-01T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002372s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001678s ] [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001724s ] [2025-08-01T23:49:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1754063341 AND `outtime` >= 1754061541 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000345s ] [2025-08-01T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002488s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001724s ] [2025-08-01T23:49:01+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.000470s ] [2025-08-01T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002373s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001506s ] [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001656s ] [2025-08-01T23:49:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063341 AND `outtime` >= 1754061541 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000353s ] [2025-08-01T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002297s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001674s ] [2025-08-01T23:49:01+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.000540s ] [2025-08-01T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002566s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002079s ] [2025-08-01T23:49:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:44:01' [ RunTime:0.000349s ] [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001309s ] [2025-08-01T23:49:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:44:01' [ RunTime:0.000300s ] [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001311s ] [2025-08-01T23:49:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:44:01' [ RunTime:0.000287s ] [2025-08-01T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002151s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001188s ] [2025-08-01T23:49:01+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-08-01 23:48:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000483s ] [2025-08-01T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002729s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:50:01+08:00][sql] CONNECT:[ UseTime:0.003120s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001834s ] [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001591s ] [2025-08-01T23:50:01+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-08-01 23:49:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000496s ] [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001671s ] [2025-08-01T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002376s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:50:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1754063401 AND `outtime` >= 1754061601 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000320s ] [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001824s ] [2025-08-01T23:50:01+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.000454s ] [2025-08-01T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002336s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001513s ] [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001649s ] [2025-08-01T23:50:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1754063401 AND `outtime` >= 1754061601 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000339s ] [2025-08-01T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002492s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001746s ] [2025-08-01T23:50:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1754061601 LIMIT 100 [ RunTime:0.000353s ] [2025-08-01T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002569s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001912s ] [2025-08-01T23:50:01+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.000579s ] [2025-08-01T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002609s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001753s ] [2025-08-01T23:50:01+08:00][sql] CONNECT:[ UseTime:0.001939s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:50:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:45:01' [ RunTime:0.000403s ] [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001730s ] [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001393s ] [2025-08-01T23:50:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:45:01' [ RunTime:0.000319s ] [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001457s ] [2025-08-01T23:50:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063401 AND `outtime` >= 1754061601 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000369s ] [2025-08-01T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001546s ] [2025-08-01T23:50:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:45:01' [ RunTime:0.000291s ] [2025-08-01T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002888s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:51:01+08:00][sql] CONNECT:[ UseTime:0.003088s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002161s ] [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001597s ] [2025-08-01T23:51:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:46:01' [ RunTime:0.000360s ] [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001642s ] [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001664s ] [2025-08-01T23:51:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1754063461 AND `outtime` >= 1754061661 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000522s ] [2025-08-01T23:51:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:46:01' [ RunTime:0.000326s ] [2025-08-01T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002345s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001547s ] [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001515s ] [2025-08-01T23:51:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:46:01' [ RunTime:0.000305s ] [2025-08-01T23:51:01+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-08-01 23:50:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000466s ] [2025-08-01T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002644s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001651s ] [2025-08-01T23:51:01+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.000475s ] [2025-08-01T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002232s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001512s ] [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001790s ] [2025-08-01T23:51:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063461 AND `outtime` >= 1754061661 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000349s ] [2025-08-01T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002382s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002142s ] [2025-08-01T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002369s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:51:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1754061661 LIMIT 100 [ RunTime:0.000412s ] [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001708s ] [2025-08-01T23:51:01+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-08-01T23:51:01+08:00][sql] CONNECT:[ UseTime:0.012244s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001483s ] [2025-08-01T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001483s ] [2025-08-01T23:51:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1754063461 AND `outtime` >= 1754061661 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000265s ] [2025-08-01T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002516s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002995s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002035s ] [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001573s ] [2025-08-01T23:52:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:47:01' [ RunTime:0.000364s ] [2025-08-01T23:52:01+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-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001630s ] [2025-08-01T23:52:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:47:01' [ RunTime:0.000341s ] [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001581s ] [2025-08-01T23:52:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:47:01' [ RunTime:0.000325s ] [2025-08-01T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002436s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001526s ] [2025-08-01T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002305s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001496s ] [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001698s ] [2025-08-01T23:52:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1754063521 AND `outtime` >= 1754061721 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000346s ] [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001655s ] [2025-08-01T23:52:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1754063521 AND `outtime` >= 1754061721 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000340s ] [2025-08-01T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002351s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:52:01+08:00][sql] CONNECT:[ UseTime:0.003673s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001789s ] [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001490s ] [2025-08-01T23:52:01+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-08-01 23:51:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000484s ] [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001682s ] [2025-08-01T23:52:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063521 AND `outtime` >= 1754061721 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000355s ] [2025-08-01T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002671s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001436s ] [2025-08-01T23:52:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1754061721 LIMIT 100 [ RunTime:0.000323s ] [2025-08-01T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002153s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001284s ] [2025-08-01T23:52:01+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.000386s ] [2025-08-01T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002524s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002056s ] [2025-08-01T23:53:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1754061781 LIMIT 100 [ RunTime:0.000382s ] [2025-08-01T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002446s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001679s ] [2025-08-01T23:53:01+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.000502s ] [2025-08-01T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002458s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001833s ] [2025-08-01T23:53:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:48:01' [ RunTime:0.000357s ] [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001649s ] [2025-08-01T23:53:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:48:01' [ RunTime:0.000340s ] [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001763s ] [2025-08-01T23:53:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:48:01' [ RunTime:0.000316s ] [2025-08-01T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002528s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001599s ] [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001679s ] [2025-08-01T23:53:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1754063581 AND `outtime` >= 1754061781 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000351s ] [2025-08-01T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002353s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001555s ] [2025-08-01T23:53:01+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-08-01 23:52:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000488s ] [2025-08-01T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002365s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001544s ] [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001757s ] [2025-08-01T23:53:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1754063581 AND `outtime` >= 1754061781 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000349s ] [2025-08-01T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002694s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002413s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001438s ] [2025-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001609s ] [2025-08-01T23:53:01+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-08-01T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001767s ] [2025-08-01T23:53:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063581 AND `outtime` >= 1754061781 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000498s ] [2025-08-01T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002738s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001797s ] [2025-08-01T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001731s ] [2025-08-01T23:54:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1754063641 AND `outtime` >= 1754061841 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000387s ] [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001509s ] [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001768s ] [2025-08-01T23:54:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063641 AND `outtime` >= 1754061841 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000364s ] [2025-08-01T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002489s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001641s ] [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001721s ] [2025-08-01T23:54:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1754063641 AND `outtime` >= 1754061841 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000333s ] [2025-08-01T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001529s ] [2025-08-01T23:54:01+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.000444s ] [2025-08-01T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002436s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001578s ] [2025-08-01T23:54:01+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-08-01T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002544s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001989s ] [2025-08-01T23:54:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1754061841 LIMIT 100 [ RunTime:0.000355s ] [2025-08-01T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002363s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001585s ] [2025-08-01T23:54:01+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-08-01 23:53:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000467s ] [2025-08-01T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002330s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001507s ] [2025-08-01T23:54:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:49:01' [ RunTime:0.000362s ] [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001323s ] [2025-08-01T23:54:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:49:01' [ RunTime:0.000329s ] [2025-08-01T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001265s ] [2025-08-01T23:54:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:49:01' [ RunTime:0.000246s ] [2025-08-01T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002633s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001730s ] [2025-08-01T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002323s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:55:01+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.000476s ] [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001553s ] [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001629s ] [2025-08-01T23:55:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1754063701 AND `outtime` >= 1754061901 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000347s ] [2025-08-01T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002326s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001847s ] [2025-08-01T23:55:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:50:01' [ RunTime:0.000537s ] [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001693s ] [2025-08-01T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:55:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:50:01' [ RunTime:0.000331s ] [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001473s ] [2025-08-01T23:55:01+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-08-01 23:54:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000446s ] [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001627s ] [2025-08-01T23:55:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:50:01' [ RunTime:0.000315s ] [2025-08-01T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001896s ] [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001778s ] [2025-08-01T23:55:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063701 AND `outtime` >= 1754061901 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000355s ] [2025-08-01T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002456s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001674s ] [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001645s ] [2025-08-01T23:55:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1754063701 AND `outtime` >= 1754061901 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000366s ] [2025-08-01T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002620s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002193s ] [2025-08-01T23:55:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1754061901 LIMIT 100 [ RunTime:0.000415s ] [2025-08-01T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002149s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001392s ] [2025-08-01T23:55:01+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-08-01T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002546s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001926s ] [2025-08-01T23:56:01+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.000514s ] [2025-08-01T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002456s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002453s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002102s ] [2025-08-01T23:56:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:51:01' [ RunTime:0.000366s ] [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001569s ] [2025-08-01T23:56:01+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-08-01 23:55:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000513s ] [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001620s ] [2025-08-01T23:56:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:51:01' [ RunTime:0.000352s ] [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001586s ] [2025-08-01T23:56:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:51:01' [ RunTime:0.000315s ] [2025-08-01T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002294s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001556s ] [2025-08-01T23:56:01+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.000471s ] [2025-08-01T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002363s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001482s ] [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001692s ] [2025-08-01T23:56:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1754063761 AND `outtime` >= 1754061961 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000356s ] [2025-08-01T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002609s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002033s ] [2025-08-01T23:56:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1754061961 LIMIT 100 [ RunTime:0.000356s ] [2025-08-01T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002121s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001608s ] [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001736s ] [2025-08-01T23:56:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1754063761 AND `outtime` >= 1754061961 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000326s ] [2025-08-01T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002088s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001394s ] [2025-08-01T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001334s ] [2025-08-01T23:56:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063761 AND `outtime` >= 1754061961 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000275s ] [2025-08-01T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002513s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001817s ] [2025-08-01T23:57:01+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.000486s ] [2025-08-01T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002693s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001820s ] [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001741s ] [2025-08-01T23:57:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1754063821 AND `outtime` >= 1754062021 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000353s ] [2025-08-01T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002489s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001566s ] [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001858s ] [2025-08-01T23:57:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1754063821 AND `outtime` >= 1754062021 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000336s ] [2025-08-01T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002310s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001517s ] [2025-08-01T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002294s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001690s ] [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001608s ] [2025-08-01T23:57:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:52:01' [ RunTime:0.000349s ] [2025-08-01T23:57:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063821 AND `outtime` >= 1754062021 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000435s ] [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001778s ] [2025-08-01T23:57:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:52:01' [ RunTime:0.000335s ] [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001493s ] [2025-08-01T23:57:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:52:01' [ RunTime:0.000318s ] [2025-08-01T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002357s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001617s ] [2025-08-01T23:57:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1754062021 LIMIT 100 [ RunTime:0.000345s ] [2025-08-01T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002397s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001325s ] [2025-08-01T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002396s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:57:01+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-08-01 23:56:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000562s ] [2025-08-01T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001627s ] [2025-08-01T23:57:01+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.000442s ] [2025-08-01T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002866s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002082s ] [2025-08-01T23:58:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:53:01' [ RunTime:0.000388s ] [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001770s ] [2025-08-01T23:58:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:53:01' [ RunTime:0.000355s ] [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001636s ] [2025-08-01T23:58:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:53:01' [ RunTime:0.000309s ] [2025-08-01T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002764s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001888s ] [2025-08-01T23:58:01+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.000560s ] [2025-08-01T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002508s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001734s ] [2025-08-01T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002370s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001988s ] [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001803s ] [2025-08-01T23:58:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1754063881 AND `outtime` >= 1754062081 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000351s ] [2025-08-01T23:58:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1754062081 LIMIT 100 [ RunTime:0.000323s ] [2025-08-01T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002444s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001516s ] [2025-08-01T23:58:01+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-08-01 23:57:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000485s ] [2025-08-01T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002286s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001564s ] [2025-08-01T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002282s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001478s ] [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001643s ] [2025-08-01T23:58:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1754063881 AND `outtime` >= 1754062081 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000348s ] [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001663s ] [2025-08-01T23:58:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063881 AND `outtime` >= 1754062081 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000346s ] [2025-08-01T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002097s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001471s ] [2025-08-01T23:58:01+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.000352s ] [2025-08-01T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002616s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001819s ] [2025-08-01T23:59:01+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-08-01T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002435s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001838s ] [2025-08-01T23:59:01+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.000434s ] [2025-08-01T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002443s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001546s ] [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001595s ] [2025-08-01T23:59:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1754063941 AND `outtime` >= 1754062141 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000335s ] [2025-08-01T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002395s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001680s ] [2025-08-01T23:59:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1754062141 LIMIT 100 [ RunTime:0.000337s ] [2025-08-01T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002553s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001496s ] [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001711s ] [2025-08-01T23:59:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1754063941 AND `outtime` >= 1754062141 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000356s ] [2025-08-01T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002328s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001885s ] [2025-08-01T23:59:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:54:01' [ RunTime:0.000368s ] [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001588s ] [2025-08-01T23:59:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:54:01' [ RunTime:0.000317s ] [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001428s ] [2025-08-01T23:59:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-08-01 23:54:01' [ RunTime:0.000339s ] [2025-08-01T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002316s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002070s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001394s ] [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001349s ] [2025-08-01T23:59:01+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-08-01 23:58:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000453s ] [2025-08-01T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001676s ] [2025-08-01T23:59:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1754063941 AND `outtime` >= 1754062141 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000426s ]