[2025-07-31T23:37:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976221 AND `outtime` >= 1753974421 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000335s ] [2025-07-31T23:37:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001592s ] [2025-07-31T23:37:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:32:01' [ RunTime:0.000320s ] [2025-07-31T23:37:01+08:00][sql] CONNECT:[ UseTime:0.002276s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:37:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001447s ] [2025-07-31T23:37: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-07-31 23:36:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000487s ] [2025-07-31T23:37:01+08:00][sql] CONNECT:[ UseTime:0.002605s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:37:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001922s ] [2025-07-31T23:37: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.000480s ] [2025-07-31T23:37:01+08:00][sql] CONNECT:[ UseTime:0.002489s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:37:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001830s ] [2025-07-31T23:37:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001751s ] [2025-07-31T23:37:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976221 AND `outtime` >= 1753974421 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000354s ] [2025-07-31T23:37:01+08:00][sql] CONNECT:[ UseTime:0.002773s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:37:01+08:00][sql] CONNECT:[ UseTime:0.002330s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:37:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001790s ] [2025-07-31T23:37:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001647s ] [2025-07-31T23:37: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-07-31T23:37:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001598s ] [2025-07-31T23:37:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976221 AND `outtime` >= 1753974421 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000579s ] [2025-07-31T23:38:01+08:00][sql] CONNECT:[ UseTime:0.002627s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:38:01+08:00][sql] CONNECT:[ UseTime:0.002464s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002216s ] [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001815s ] [2025-07-31T23:38:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:33:01' [ RunTime:0.000351s ] [2025-07-31T23:38:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1753974481 LIMIT 100 [ RunTime:0.000434s ] [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001621s ] [2025-07-31T23:38:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:33:01' [ RunTime:0.000323s ] [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001639s ] [2025-07-31T23:38:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:33:01' [ RunTime:0.000324s ] [2025-07-31T23:38:01+08:00][sql] CONNECT:[ UseTime:0.002411s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001527s ] [2025-07-31T23:38:01+08:00][sql] CONNECT:[ UseTime:0.002272s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001691s ] [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001514s ] [2025-07-31T23:38:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976281 AND `outtime` >= 1753974481 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000336s ] [2025-07-31T23:38: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.000425s ] [2025-07-31T23:38:01+08:00][sql] CONNECT:[ UseTime:0.002544s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001771s ] [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001831s ] [2025-07-31T23:38:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976281 AND `outtime` >= 1753974481 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000357s ] [2025-07-31T23:38:01+08:00][sql] CONNECT:[ UseTime:0.002392s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001831s ] [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001735s ] [2025-07-31T23:38:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976281 AND `outtime` >= 1753974481 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000379s ] [2025-07-31T23:38:01+08:00][sql] CONNECT:[ UseTime:0.002387s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001795s ] [2025-07-31T23:38: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.000443s ] [2025-07-31T23:38:01+08:00][sql] CONNECT:[ UseTime:0.001988s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001391s ] [2025-07-31T23:38: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-07-31 23:37:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000418s ] [2025-07-31T23:39:01+08:00][sql] CONNECT:[ UseTime:0.002610s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001842s ] [2025-07-31T23:39: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-07-31T23:39:01+08:00][sql] CONNECT:[ UseTime:0.002486s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001769s ] [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001678s ] [2025-07-31T23:39:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976341 AND `outtime` >= 1753974541 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000325s ] [2025-07-31T23:39:01+08:00][sql] CONNECT:[ UseTime:0.002358s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001735s ] [2025-07-31T23:39:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1753974541 LIMIT 100 [ RunTime:0.000342s ] [2025-07-31T23:39:01+08:00][sql] CONNECT:[ UseTime:0.002369s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001634s ] [2025-07-31T23:39: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-07-31 23:38:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000496s ] [2025-07-31T23:39:01+08:00][sql] CONNECT:[ UseTime:0.002444s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001813s ] [2025-07-31T23:39: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.000449s ] [2025-07-31T23:39:01+08:00][sql] CONNECT:[ UseTime:0.002445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:39:01+08:00][sql] CONNECT:[ UseTime:0.002358s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001625s ] [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001474s ] [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001572s ] [2025-07-31T23:39:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976341 AND `outtime` >= 1753974541 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000363s ] [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001594s ] [2025-07-31T23:39:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976341 AND `outtime` >= 1753974541 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000335s ] [2025-07-31T23:39:01+08:00][sql] CONNECT:[ UseTime:0.002400s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001786s ] [2025-07-31T23:39:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:34:01' [ RunTime:0.000339s ] [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001440s ] [2025-07-31T23:39:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:34:01' [ RunTime:0.000299s ] [2025-07-31T23:39:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001216s ] [2025-07-31T23:39:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:34:01' [ RunTime:0.000346s ] [2025-07-31T23:40:01+08:00][sql] CONNECT:[ UseTime:0.002590s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001952s ] [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001887s ] [2025-07-31T23:40:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976401 AND `outtime` >= 1753974601 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000400s ] [2025-07-31T23:40:01+08:00][sql] CONNECT:[ UseTime:0.002546s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001802s ] [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001703s ] [2025-07-31T23:40:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976401 AND `outtime` >= 1753974601 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000328s ] [2025-07-31T23:40:01+08:00][sql] CONNECT:[ UseTime:0.002467s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001586s ] [2025-07-31T23:40: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-07-31 23:39:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000666s ] [2025-07-31T23:40:01+08:00][sql] CONNECT:[ UseTime:0.002459s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002002s ] [2025-07-31T23:40:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1753974601 LIMIT 100 [ RunTime:0.000389s ] [2025-07-31T23:40:01+08:00][sql] CONNECT:[ UseTime:0.002674s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:40:01+08:00][sql] CONNECT:[ UseTime:0.002516s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001869s ] [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001513s ] [2025-07-31T23:40: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.000458s ] [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001815s ] [2025-07-31T23:40:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976401 AND `outtime` >= 1753974601 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000322s ] [2025-07-31T23:40:01+08:00][sql] CONNECT:[ UseTime:0.002503s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:40:01+08:00][sql] CONNECT:[ UseTime:0.003420s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001749s ] [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001670s ] [2025-07-31T23:40: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.000481s ] [2025-07-31T23:40:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:35:01' [ RunTime:0.000406s ] [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001818s ] [2025-07-31T23:40:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:35:01' [ RunTime:0.000357s ] [2025-07-31T23:40:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001594s ] [2025-07-31T23:40:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:35:01' [ RunTime:0.000310s ] [2025-07-31T23:41:01+08:00][sql] CONNECT:[ UseTime:0.002610s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001859s ] [2025-07-31T23:41: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-07-31 23:40:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000506s ] [2025-07-31T23:41:01+08:00][sql] CONNECT:[ UseTime:0.002427s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001632s ] [2025-07-31T23:41:01+08:00][sql] CONNECT:[ UseTime:0.002349s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:41: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.000414s ] [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001528s ] [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001684s ] [2025-07-31T23:41:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976461 AND `outtime` >= 1753974661 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000489s ] [2025-07-31T23:41:01+08:00][sql] CONNECT:[ UseTime:0.002493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002004s ] [2025-07-31T23:41:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:36:01' [ RunTime:0.000351s ] [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001699s ] [2025-07-31T23:41:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:36:01' [ RunTime:0.000314s ] [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001636s ] [2025-07-31T23:41:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:36:01' [ RunTime:0.000302s ] [2025-07-31T23:41:01+08:00][sql] CONNECT:[ UseTime:0.002618s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001713s ] [2025-07-31T23:41:01+08:00][sql] CONNECT:[ UseTime:0.002422s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001805s ] [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001755s ] [2025-07-31T23:41:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976461 AND `outtime` >= 1753974661 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000404s ] [2025-07-31T23:41:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1753974661 LIMIT 100 [ RunTime:0.000346s ] [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001499s ] [2025-07-31T23:41: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.000410s ] [2025-07-31T23:41:01+08:00][sql] CONNECT:[ UseTime:0.002272s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001591s ] [2025-07-31T23:41:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001521s ] [2025-07-31T23:41:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976461 AND `outtime` >= 1753974661 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000322s ] [2025-07-31T23:42:01+08:00][sql] CONNECT:[ UseTime:0.002609s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001809s ] [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001742s ] [2025-07-31T23:42:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976521 AND `outtime` >= 1753974721 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000382s ] [2025-07-31T23:42:01+08:00][sql] CONNECT:[ UseTime:0.002669s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001671s ] [2025-07-31T23:42: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.000432s ] [2025-07-31T23:42:01+08:00][sql] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001523s ] [2025-07-31T23:42:01+08:00][sql] CONNECT:[ UseTime:0.002281s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:42: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-07-31 23:41:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000470s ] [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001722s ] [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001581s ] [2025-07-31T23:42:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976521 AND `outtime` >= 1753974721 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000330s ] [2025-07-31T23:42:01+08:00][sql] CONNECT:[ UseTime:0.002655s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001976s ] [2025-07-31T23:42:01+08:00][sql] CONNECT:[ UseTime:0.002380s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:42:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1753974721 LIMIT 100 [ RunTime:0.000384s ] [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001598s ] [2025-07-31T23:42: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.000430s ] [2025-07-31T23:42:01+08:00][sql] CONNECT:[ UseTime:0.002477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001738s ] [2025-07-31T23:42:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:37:01' [ RunTime:0.000359s ] [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001666s ] [2025-07-31T23:42:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:37:01' [ RunTime:0.000337s ] [2025-07-31T23:42:01+08:00][sql] CONNECT:[ UseTime:0.002307s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001508s ] [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001748s ] [2025-07-31T23:42:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:37:01' [ RunTime:0.000412s ] [2025-07-31T23:42:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001775s ] [2025-07-31T23:42:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976521 AND `outtime` >= 1753974721 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000349s ] [2025-07-31T23:43:01+08:00][sql] CONNECT:[ UseTime:0.002476s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.002200s ] [2025-07-31T23:43:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1753974781 LIMIT 100 [ RunTime:0.000420s ] [2025-07-31T23:43:01+08:00][sql] CONNECT:[ UseTime:0.002423s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001668s ] [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001719s ] [2025-07-31T23:43:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976581 AND `outtime` >= 1753974781 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000336s ] [2025-07-31T23:43:01+08:00][sql] CONNECT:[ UseTime:0.002405s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001659s ] [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001570s ] [2025-07-31T23:43:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976581 AND `outtime` >= 1753974781 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000342s ] [2025-07-31T23:43:01+08:00][sql] CONNECT:[ UseTime:0.002697s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001903s ] [2025-07-31T23:43:01+08:00][sql] CONNECT:[ UseTime:0.002348s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001562s ] [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001819s ] [2025-07-31T23:43: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-07-31 23:42:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000466s ] [2025-07-31T23:43:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976581 AND `outtime` >= 1753974781 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000396s ] [2025-07-31T23:43:01+08:00][sql] CONNECT:[ UseTime:0.002242s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001402s ] [2025-07-31T23:43: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.000487s ] [2025-07-31T23:43:01+08:00][sql] CONNECT:[ UseTime:0.002266s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001741s ] [2025-07-31T23:43:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:38:01' [ RunTime:0.000322s ] [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001555s ] [2025-07-31T23:43:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:38:01' [ RunTime:0.000452s ] [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001671s ] [2025-07-31T23:43:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:38:01' [ RunTime:0.000320s ] [2025-07-31T23:43:01+08:00][sql] CONNECT:[ UseTime:0.002353s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001571s ] [2025-07-31T23:43: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.000506s ] [2025-07-31T23:44:01+08:00][sql] CONNECT:[ UseTime:0.002712s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001833s ] [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001754s ] [2025-07-31T23:44:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976641 AND `outtime` >= 1753974841 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000354s ] [2025-07-31T23:44:01+08:00][sql] CONNECT:[ UseTime:0.002709s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001981s ] [2025-07-31T23:44:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1753974841 LIMIT 100 [ RunTime:0.000385s ] [2025-07-31T23:44:01+08:00][sql] CONNECT:[ UseTime:0.002562s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001777s ] [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001694s ] [2025-07-31T23:44:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976641 AND `outtime` >= 1753974841 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000340s ] [2025-07-31T23:44:01+08:00][sql] CONNECT:[ UseTime:0.002551s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:44:01+08:00][sql] CONNECT:[ UseTime:0.003010s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:44:01+08:00][sql] CONNECT:[ UseTime:0.018392s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001721s ] [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001482s ] [2025-07-31T23:44: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-07-31 23:43:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000450s ] [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001684s ] [2025-07-31T23:44: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.000400s ] [2025-07-31T23:44:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:39:01' [ RunTime:0.000348s ] [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001581s ] [2025-07-31T23:44:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:39:01' [ RunTime:0.000578s ] [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001541s ] [2025-07-31T23:44:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:39:01' [ RunTime:0.000305s ] [2025-07-31T23:44:01+08:00][sql] CONNECT:[ UseTime:0.002342s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:44:01+08:00][sql] CONNECT:[ UseTime:0.002152s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001850s ] [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001581s ] [2025-07-31T23:44: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.000414s ] [2025-07-31T23:44:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001628s ] [2025-07-31T23:44:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976641 AND `outtime` >= 1753974841 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000412s ] [2025-07-31T23:45:01+08:00][sql] CONNECT:[ UseTime:0.002995s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002026s ] [2025-07-31T23:45:01+08:00][sql] CONNECT:[ UseTime:0.002450s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:45:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:40:01' [ RunTime:0.000400s ] [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001605s ] [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001933s ] [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001621s ] [2025-07-31T23:45:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:40:01' [ RunTime:0.000319s ] [2025-07-31T23:45:01+08:00][sql] CONNECT:[ UseTime:0.002433s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:45:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976701 AND `outtime` >= 1753974901 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000338s ] [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001648s ] [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001482s ] [2025-07-31T23:45:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:40:01' [ RunTime:0.000297s ] [2025-07-31T23:45: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-07-31 23:44:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000460s ] [2025-07-31T23:45:01+08:00][sql] CONNECT:[ UseTime:0.002323s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001439s ] [2025-07-31T23:45: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.000430s ] [2025-07-31T23:45:01+08:00][sql] CONNECT:[ UseTime:0.002512s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001863s ] [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001809s ] [2025-07-31T23:45:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976701 AND `outtime` >= 1753974901 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000368s ] [2025-07-31T23:45:01+08:00][sql] CONNECT:[ UseTime:0.002518s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001712s ] [2025-07-31T23:45: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.000460s ] [2025-07-31T23:45:01+08:00][sql] CONNECT:[ UseTime:0.002154s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:45:01+08:00][sql] CONNECT:[ UseTime:0.002877s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001716s ] [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001283s ] [2025-07-31T23:45:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1753974901 LIMIT 100 [ RunTime:0.000414s ] [2025-07-31T23:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001408s ] [2025-07-31T23:45:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976701 AND `outtime` >= 1753974901 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000337s ] [2025-07-31T23:46:01+08:00][sql] CONNECT:[ UseTime:0.002546s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001842s ] [2025-07-31T23:46:01+08:00][sql] CONNECT:[ UseTime:0.002297s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001579s ] [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001917s ] [2025-07-31T23:46: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-07-31 23:45:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000487s ] [2025-07-31T23:46:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976761 AND `outtime` >= 1753974961 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000341s ] [2025-07-31T23:46:01+08:00][sql] CONNECT:[ UseTime:0.002482s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001732s ] [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001740s ] [2025-07-31T23:46:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976761 AND `outtime` >= 1753974961 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000344s ] [2025-07-31T23:46:01+08:00][sql] CONNECT:[ UseTime:0.002384s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001521s ] [2025-07-31T23:46: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.000440s ] [2025-07-31T23:46:01+08:00][sql] CONNECT:[ UseTime:0.002698s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001700s ] [2025-07-31T23:46:01+08:00][sql] CONNECT:[ UseTime:0.002500s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001731s ] [2025-07-31T23:46:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976761 AND `outtime` >= 1753974961 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000365s ] [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001698s ] [2025-07-31T23:46:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1753974961 LIMIT 100 [ RunTime:0.000347s ] [2025-07-31T23:46:01+08:00][sql] CONNECT:[ UseTime:0.002506s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001630s ] [2025-07-31T23:46: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.000432s ] [2025-07-31T23:46:01+08:00][sql] CONNECT:[ UseTime:0.002019s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001331s ] [2025-07-31T23:46:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:41:01' [ RunTime:0.000358s ] [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001169s ] [2025-07-31T23:46:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:41:01' [ RunTime:0.000257s ] [2025-07-31T23:46:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001138s ] [2025-07-31T23:46:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:41:01' [ RunTime:0.000243s ] [2025-07-31T23:47:01+08:00][sql] CONNECT:[ UseTime:0.002747s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001831s ] [2025-07-31T23:47:01+08:00][sql] CONNECT:[ UseTime:0.002443s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001844s ] [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001799s ] [2025-07-31T23:47:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976821 AND `outtime` >= 1753975021 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000515s ] [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001699s ] [2025-07-31T23:47:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976821 AND `outtime` >= 1753975021 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000337s ] [2025-07-31T23:47:01+08:00][sql] CONNECT:[ UseTime:0.002539s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:47:01+08:00][sql] CONNECT:[ UseTime:0.002384s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001790s ] [2025-07-31T23:47: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-07-31 23:46:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000465s ] [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001706s ] [2025-07-31T23:47:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1753975021 LIMIT 100 [ RunTime:0.000358s ] [2025-07-31T23:47:01+08:00][sql] CONNECT:[ UseTime:0.002522s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001762s ] [2025-07-31T23:47: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-07-31T23:47:01+08:00][sql] CONNECT:[ UseTime:0.002162s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:47:01+08:00][sql] CONNECT:[ UseTime:0.002249s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002183s ] [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001649s ] [2025-07-31T23:47:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:42:01' [ RunTime:0.000404s ] [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001728s ] [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001566s ] [2025-07-31T23:47:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:42:01' [ RunTime:0.000301s ] [2025-07-31T23:47:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976821 AND `outtime` >= 1753975021 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000380s ] [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001195s ] [2025-07-31T23:47:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:42:01' [ RunTime:0.000384s ] [2025-07-31T23:47:01+08:00][sql] CONNECT:[ UseTime:0.002071s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:47:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001474s ] [2025-07-31T23:47: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.000460s ] [2025-07-31T23:48:01+08:00][sql] CONNECT:[ UseTime:0.002561s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001835s ] [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001889s ] [2025-07-31T23:48:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976881 AND `outtime` >= 1753975081 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000355s ] [2025-07-31T23:48:01+08:00][sql] CONNECT:[ UseTime:0.002512s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001539s ] [2025-07-31T23:48: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.000424s ] [2025-07-31T23:48:01+08:00][sql] CONNECT:[ UseTime:0.002392s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:48:01+08:00][sql] CONNECT:[ UseTime:0.002274s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001790s ] [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001503s ] [2025-07-31T23:48:01+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1753975081 LIMIT 100 [ RunTime:0.000348s ] [2025-07-31T23:48: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.000479s ] [2025-07-31T23:48:01+08:00][sql] CONNECT:[ UseTime:0.002653s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002006s ] [2025-07-31T23:48:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:43:01' [ RunTime:0.000362s ] [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001714s ] [2025-07-31T23:48:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:43:01' [ RunTime:0.000320s ] [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001626s ] [2025-07-31T23:48:01+08:00][sql] CONNECT:[ UseTime:0.002681s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:48:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:43:01' [ RunTime:0.000335s ] [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001517s ] [2025-07-31T23:48:01+08:00][sql] CONNECT:[ UseTime:0.002313s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23: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-07-31 23:47:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000443s ] [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001505s ] [2025-07-31T23:48:01+08:00][sql] CONNECT:[ UseTime:0.002296s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001453s ] [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001713s ] [2025-07-31T23:48:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976881 AND `outtime` >= 1753975081 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000379s ] [2025-07-31T23:48:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001651s ] [2025-07-31T23:48:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976881 AND `outtime` >= 1753975081 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000334s ] [2025-07-31T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002570s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001834s ] [2025-07-31T23: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.000482s ] [2025-07-31T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002360s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001556s ] [2025-07-31T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002435s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001814s ] [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001742s ] [2025-07-31T23:49:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753976941 AND `outtime` >= 1753975141 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000351s ] [2025-07-31T23:49:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:44:01' [ RunTime:0.000336s ] [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001639s ] [2025-07-31T23:49:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:44:01' [ RunTime:0.000335s ] [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001697s ] [2025-07-31T23:49:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:44:01' [ RunTime:0.000305s ] [2025-07-31T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002511s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001501s ] [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001682s ] [2025-07-31T23:49:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753976941 AND `outtime` >= 1753975141 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000338s ] [2025-07-31T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002553s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:49:01+08:00][sql] CONNECT:[ UseTime:0.003160s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001699s ] [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001457s ] [2025-07-31T23: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-07-31 23:48:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000471s ] [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001672s ] [2025-07-31T23:49:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753976941 AND `outtime` >= 1753975141 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000340s ] [2025-07-31T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002382s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001874s ] [2025-07-31T23: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` < 1753975141 LIMIT 100 [ RunTime:0.000364s ] [2025-07-31T23:49:01+08:00][sql] CONNECT:[ UseTime:0.002227s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:49:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001634s ] [2025-07-31T23: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.000422s ] [2025-07-31T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002568s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001829s ] [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001815s ] [2025-07-31T23:50:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753977001 AND `outtime` >= 1753975201 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000387s ] [2025-07-31T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002439s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001551s ] [2025-07-31T23: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.000436s ] [2025-07-31T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002396s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:50:01+08:00][sql] CONNECT:[ UseTime:0.003299s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001563s ] [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001677s ] [2025-07-31T23: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-07-31 23:49:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000458s ] [2025-07-31T23: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.000397s ] [2025-07-31T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002554s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001817s ] [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001700s ] [2025-07-31T23:50:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753977001 AND `outtime` >= 1753975201 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000375s ] [2025-07-31T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002591s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001455s ] [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001631s ] [2025-07-31T23:50:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753977001 AND `outtime` >= 1753975201 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000335s ] [2025-07-31T23:50:01+08:00][sql] CONNECT:[ UseTime:0.001992s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001543s ] [2025-07-31T23: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` < 1753975201 LIMIT 100 [ RunTime:0.000353s ] [2025-07-31T23:50:01+08:00][sql] CONNECT:[ UseTime:0.002040s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001439s ] [2025-07-31T23:50:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:45:01' [ RunTime:0.000312s ] [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001196s ] [2025-07-31T23:50:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:45:01' [ RunTime:0.000242s ] [2025-07-31T23:50:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001144s ] [2025-07-31T23:50:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:45:01' [ RunTime:0.000230s ] [2025-07-31T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:51:01+08:00][sql] CONNECT:[ UseTime:0.003313s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001806s ] [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001699s ] [2025-07-31T23:51:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:46:01' [ RunTime:0.000372s ] [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001794s ] [2025-07-31T23:51:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753977061 AND `outtime` >= 1753975261 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000345s ] [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001644s ] [2025-07-31T23:51:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:46:01' [ RunTime:0.000337s ] [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001794s ] [2025-07-31T23:51:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:46:01' [ RunTime:0.000307s ] [2025-07-31T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002569s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001756s ] [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001690s ] [2025-07-31T23:51:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753977061 AND `outtime` >= 1753975261 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000342s ] [2025-07-31T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002472s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001592s ] [2025-07-31T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002206s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001718s ] [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001690s ] [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001472s ] [2025-07-31T23:51:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753977061 AND `outtime` >= 1753975261 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000346s ] [2025-07-31T23: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` < 1753975261 LIMIT 100 [ RunTime:0.000339s ] [2025-07-31T23: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.000428s ] [2025-07-31T23:51:01+08:00][sql] CONNECT:[ UseTime:0.012291s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001562s ] [2025-07-31T23: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.000453s ] [2025-07-31T23:51:01+08:00][sql] CONNECT:[ UseTime:0.002007s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:51:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001382s ] [2025-07-31T23: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-07-31 23:50:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000398s ] [2025-07-31T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002565s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001791s ] [2025-07-31T23: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.000474s ] [2025-07-31T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002449s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002403s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001651s ] [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001478s ] [2025-07-31T23: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-07-31 23:51:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000463s ] [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001709s ] [2025-07-31T23:52:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753977121 AND `outtime` >= 1753975321 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000321s ] [2025-07-31T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002275s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001531s ] [2025-07-31T23: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.000446s ] [2025-07-31T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002616s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001847s ] [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001674s ] [2025-07-31T23:52:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753977121 AND `outtime` >= 1753975321 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000334s ] [2025-07-31T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002380s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001760s ] [2025-07-31T23:52:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:47:01' [ RunTime:0.000328s ] [2025-07-31T23:52:01+08:00][sql] CONNECT:[ UseTime:0.003703s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001465s ] [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001660s ] [2025-07-31T23:52:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:47:01' [ RunTime:0.000360s ] [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001687s ] [2025-07-31T23:52:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753977121 AND `outtime` >= 1753975321 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000389s ] [2025-07-31T23:52:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:47:01' [ RunTime:0.000327s ] [2025-07-31T23:52:01+08:00][sql] CONNECT:[ UseTime:0.002076s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:52:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001423s ] [2025-07-31T23: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` < 1753975321 LIMIT 100 [ RunTime:0.000432s ] [2025-07-31T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002781s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:53:01+08:00][sql] CONNECT:[ UseTime:0.003630s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001770s ] [2025-07-31T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002288s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001640s ] [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001475s ] [2025-07-31T23: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` < 1753975381 LIMIT 100 [ RunTime:0.000348s ] [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001696s ] [2025-07-31T23: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.000435s ] [2025-07-31T23:53:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753977181 AND `outtime` >= 1753975381 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000349s ] [2025-07-31T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002392s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001568s ] [2025-07-31T23: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.000438s ] [2025-07-31T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002931s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:53:01+08:00][sql] CONNECT:[ UseTime:0.003191s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001854s ] [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001567s ] [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001701s ] [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001688s ] [2025-07-31T23:53:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753977181 AND `outtime` >= 1753975381 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000499s ] [2025-07-31T23:53:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753977181 AND `outtime` >= 1753975381 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000297s ] [2025-07-31T23:53:01+08:00][sql] CONNECT:[ UseTime:0.002402s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001647s ] [2025-07-31T23:53:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:48:01' [ RunTime:0.000407s ] [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001538s ] [2025-07-31T23:53:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:48:01' [ RunTime:0.000318s ] [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001685s ] [2025-07-31T23:53:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:48:01' [ RunTime:0.000321s ] [2025-07-31T23:53:01+08:00][sql] CONNECT:[ UseTime:0.001883s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:53:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001311s ] [2025-07-31T23: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-07-31 23:52:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000412s ] [2025-07-31T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002724s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001812s ] [2025-07-31T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002374s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23: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.000439s ] [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001514s ] [2025-07-31T23: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.000411s ] [2025-07-31T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002569s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001736s ] [2025-07-31T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002543s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001456s ] [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001767s ] [2025-07-31T23:54:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753977241 AND `outtime` >= 1753975441 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000345s ] [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001805s ] [2025-07-31T23:54:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753977241 AND `outtime` >= 1753975441 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000337s ] [2025-07-31T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002613s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001659s ] [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001726s ] [2025-07-31T23:54:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753977241 AND `outtime` >= 1753975441 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000371s ] [2025-07-31T23:54:01+08:00][sql] CONNECT:[ UseTime:0.001936s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001619s ] [2025-07-31T23:54:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:49:01' [ RunTime:0.000462s ] [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001374s ] [2025-07-31T23:54:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:49:01' [ RunTime:0.000314s ] [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001667s ] [2025-07-31T23:54:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:49:01' [ RunTime:0.000402s ] [2025-07-31T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002347s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001409s ] [2025-07-31T23: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` < 1753975441 LIMIT 100 [ RunTime:0.000365s ] [2025-07-31T23:54:01+08:00][sql] CONNECT:[ UseTime:0.002249s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001196s ] [2025-07-31T23: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-07-31 23:53:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000333s ] [2025-07-31T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002662s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001854s ] [2025-07-31T23: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-07-31 23:54:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000516s ] [2025-07-31T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002530s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001624s ] [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001697s ] [2025-07-31T23:55:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753977301 AND `outtime` >= 1753975501 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000352s ] [2025-07-31T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002516s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001794s ] [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001784s ] [2025-07-31T23:55:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753977301 AND `outtime` >= 1753975501 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000363s ] [2025-07-31T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002517s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001888s ] [2025-07-31T23: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.000510s ] [2025-07-31T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002925s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001947s ] [2025-07-31T23:55:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:50:01' [ RunTime:0.000379s ] [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001773s ] [2025-07-31T23:55:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:50:01' [ RunTime:0.000335s ] [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001816s ] [2025-07-31T23:55:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:50:01' [ RunTime:0.000312s ] [2025-07-31T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002776s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001812s ] [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001822s ] [2025-07-31T23:55:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753977301 AND `outtime` >= 1753975501 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000384s ] [2025-07-31T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002129s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001884s ] [2025-07-31T23:55:01+08:00][sql] CONNECT:[ UseTime:0.002261s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23: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` < 1753975501 LIMIT 100 [ RunTime:0.000383s ] [2025-07-31T23:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001367s ] [2025-07-31T23: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.000417s ] [2025-07-31T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002643s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001804s ] [2025-07-31T23: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-07-31 23:55:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000498s ] [2025-07-31T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002681s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.002144s ] [2025-07-31T23:56:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:51:01' [ RunTime:0.000462s ] [2025-07-31T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002332s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001613s ] [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001762s ] [2025-07-31T23: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.000448s ] [2025-07-31T23:56:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:51:01' [ RunTime:0.000337s ] [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001653s ] [2025-07-31T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002411s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:56:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:51:01' [ RunTime:0.000318s ] [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001468s ] [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001769s ] [2025-07-31T23:56:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753977361 AND `outtime` >= 1753975561 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000340s ] [2025-07-31T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002673s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001774s ] [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001721s ] [2025-07-31T23:56:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753977361 AND `outtime` >= 1753975561 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000339s ] [2025-07-31T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002598s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001820s ] [2025-07-31T23:56:01+08:00][sql] CONNECT:[ UseTime:0.001996s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001768s ] [2025-07-31T23:56:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753977361 AND `outtime` >= 1753975561 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000319s ] 20 [ RunTime:0.000470s ] [2025-07-31T23:56:01+08:00][sql] CONNECT:[ UseTime:0.002267s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:56:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001536s ] [2025-07-31T23: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` < 1753975561 LIMIT 100 [ RunTime:0.000428s ] [2025-07-31T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002644s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001892s ] [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001863s ] [2025-07-31T23:57:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753977421 AND `outtime` >= 1753975621 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000350s ] [2025-07-31T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002394s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001739s ] [2025-07-31T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002312s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23: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.000453s ] [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001716s ] [2025-07-31T23: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` < 1753975621 LIMIT 100 [ RunTime:0.000334s ] [2025-07-31T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002416s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001621s ] [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001682s ] [2025-07-31T23:57:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753977421 AND `outtime` >= 1753975621 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000336s ] [2025-07-31T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002314s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001544s ] [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001705s ] [2025-07-31T23:57:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753977421 AND `outtime` >= 1753975621 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000328s ] [2025-07-31T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002234s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001902s ] [2025-07-31T23: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-07-31 23:56:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000570s ] [2025-07-31T23:57:01+08:00][sql] CONNECT:[ UseTime:0.001944s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001874s ] [2025-07-31T23:57:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:52:01' [ RunTime:0.000369s ] [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001639s ] [2025-07-31T23:57:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:52:01' [ RunTime:0.000352s ] [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001415s ] [2025-07-31T23:57:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:52:01' [ RunTime:0.000399s ] [2025-07-31T23:57:01+08:00][sql] CONNECT:[ UseTime:0.002133s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:57:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001340s ] [2025-07-31T23: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.000371s ] [2025-07-31T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002583s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001895s ] [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001725s ] [2025-07-31T23:58:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753977481 AND `outtime` >= 1753975681 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000348s ] [2025-07-31T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002443s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:58:01+08:00][sql] CONNECT:[ UseTime:0.003389s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001655s ] [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001546s ] [2025-07-31T23: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-07-31 23:57:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000492s ] [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001706s ] [2025-07-31T23:58:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753977481 AND `outtime` >= 1753975681 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000319s ] [2025-07-31T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002597s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002307s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001851s ] [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001534s ] [2025-07-31T23:58:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:53:01' [ RunTime:0.000329s ] [2025-07-31T23: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.000414s ] [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001620s ] [2025-07-31T23:58:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:53:01' [ RunTime:0.000512s ] [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001636s ] [2025-07-31T23:58:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:53:01' [ RunTime:0.000314s ] [2025-07-31T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002325s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001969s ] [2025-07-31T23: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` < 1753975681 LIMIT 100 [ RunTime:0.000395s ] [2025-07-31T23:58:01+08:00][sql] CONNECT:[ UseTime:0.002323s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001564s ] [2025-07-31T23: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.000492s ] [2025-07-31T23:58:01+08:00][sql] CONNECT:[ UseTime:0.001878s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001426s ] [2025-07-31T23:58:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001406s ] [2025-07-31T23:58:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753977481 AND `outtime` >= 1753975681 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000279s ] [2025-07-31T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002733s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001840s ] [2025-07-31T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002360s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001795s ] [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001788s ] [2025-07-31T23:59:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1753977541 AND `outtime` >= 1753975741 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000347s ] [2025-07-31T23:59:01+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:54:01' [ RunTime:0.000328s ] [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001790s ] [2025-07-31T23:59:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:54:01' [ RunTime:0.000357s ] [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001578s ] [2025-07-31T23:59:01+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-31 23:54:01' [ RunTime:0.000303s ] [2025-07-31T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002372s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001534s ] [2025-07-31T23: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.000434s ] [2025-07-31T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002444s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001637s ] [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001668s ] [2025-07-31T23:59:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1753977541 AND `outtime` >= 1753975741 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000335s ] [2025-07-31T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002446s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001802s ] [2025-07-31T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002454s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001757s ] [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001444s ] [2025-07-31T23:59:01+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1753977541 AND `outtime` >= 1753975741 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000373s ] [2025-07-31T23: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.000437s ] [2025-07-31T23:59:01+08:00][sql] CONNECT:[ UseTime:0.002220s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001635s ] [2025-07-31T23: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-07-31 23:58:01' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000504s ] [2025-07-31T23:59:01+08:00][sql] CONNECT:[ UseTime:0.001880s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T23:59:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001421s ] [2025-07-31T23: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` < 1753975741 LIMIT 100 [ RunTime:0.000281s ]