[2025-07-04T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001543s ] [2025-07-04T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1751642642 LIMIT 100 [ RunTime:0.000605s ] [2025-07-04T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1751644442 AND `outtime` >= 1751642642 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000402s ] [2025-07-04T23:54:02+08:00][sql] CONNECT:[ UseTime:0.026210s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001439s ] [2025-07-04T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001803s ] [2025-07-04T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1751644442 AND `outtime` >= 1751642642 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000336s ] [2025-07-04T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002499s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001731s ] [2025-07-04T23:54:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:49:02' [ RunTime:0.000348s ] [2025-07-04T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001666s ] [2025-07-04T23:54:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:49:02' [ RunTime:0.000352s ] [2025-07-04T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001552s ] [2025-07-04T23:54:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:49:02' [ RunTime:0.000338s ] [2025-07-04T23:54:02+08:00][sql] CONNECT:[ UseTime:0.002217s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:54:02+08:00][sql] CONNECT:[ UseTime:0.003025s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001348s ] [2025-07-04T23:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001347s ] [2025-07-04T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 2 AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000472s ] [2025-07-04T23:54:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 1 AND `sync_status` IN (0,3) AND `created_at` <= '2025-07-04 23:53:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000380s ] [2025-07-04T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002694s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001817s ] [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001802s ] [2025-07-04T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1751644502 AND `outtime` >= 1751642702 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000336s ] [2025-07-04T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002540s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001792s ] [2025-07-04T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 1 AND `sync_status` IN (0,3) AND `created_at` <= '2025-07-04 23:54:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000485s ] [2025-07-04T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002448s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001632s ] [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001741s ] [2025-07-04T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1751644502 AND `outtime` >= 1751642702 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000354s ] [2025-07-04T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002528s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001816s ] [2025-07-04T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 0 AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000456s ] [2025-07-04T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002712s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001618s ] [2025-07-04T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 2 AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000456s ] [2025-07-04T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001701s ] [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001777s ] [2025-07-04T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1751644502 AND `outtime` >= 1751642702 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000409s ] [2025-07-04T23:55:02+08:00][sql] CONNECT:[ UseTime:0.002412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001796s ] [2025-07-04T23:55:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1751642702 LIMIT 100 [ RunTime:0.000397s ] [2025-07-04T23:55:02+08:00][sql] CONNECT:[ UseTime:0.001951s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001403s ] [2025-07-04T23:55:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:50:02' [ RunTime:0.000293s ] [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001131s ] [2025-07-04T23:55:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:50:02' [ RunTime:0.000240s ] [2025-07-04T23:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001454s ] [2025-07-04T23:55:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:50:02' [ RunTime:0.000249s ] [2025-07-04T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002871s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001800s ] [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001703s ] [2025-07-04T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1751644562 AND `outtime` >= 1751642762 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000343s ] [2025-07-04T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002528s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001775s ] [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001750s ] [2025-07-04T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1751644562 AND `outtime` >= 1751642762 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000345s ] [2025-07-04T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002429s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:56:02+08:00][sql] CONNECT:[ UseTime:0.003204s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001577s ] [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001533s ] [2025-07-04T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 0 AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000407s ] [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001699s ] [2025-07-04T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002334s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1751644562 AND `outtime` >= 1751642762 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000465s ] [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001763s ] [2025-07-04T23:56:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:51:02' [ RunTime:0.000336s ] [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001636s ] [2025-07-04T23:56:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:51:02' [ RunTime:0.000326s ] [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001608s ] [2025-07-04T23:56:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:51:02' [ RunTime:0.000300s ] [2025-07-04T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002398s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001783s ] [2025-07-04T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002381s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 2 AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000445s ] [2025-07-04T23:56:02+08:00][sql] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001839s ] [2025-07-04T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 1 AND `sync_status` IN (0,3) AND `created_at` <= '2025-07-04 23:55:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000424s ] [2025-07-04T23:56:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001585s ] [2025-07-04T23:56:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1751642762 LIMIT 100 [ RunTime:0.000346s ] [2025-07-04T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002697s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002641s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001830s ] [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001722s ] [2025-07-04T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 0 AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000452s ] [2025-07-04T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1751642822 LIMIT 100 [ RunTime:0.000360s ] [2025-07-04T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002570s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001686s ] [2025-07-04T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 2 AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000441s ] [2025-07-04T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002416s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001639s ] [2025-07-04T23:57:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:52:02' [ RunTime:0.000333s ] [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001651s ] [2025-07-04T23:57:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:52:02' [ RunTime:0.000299s ] [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001447s ] [2025-07-04T23:57:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:52:02' [ RunTime:0.000262s ] [2025-07-04T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002745s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001798s ] [2025-07-04T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002326s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002503s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001761s ] [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001494s ] [2025-07-04T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1751644622 AND `outtime` >= 1751642822 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000348s ] [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001485s ] [2025-07-04T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 1 AND `sync_status` IN (0,3) AND `created_at` <= '2025-07-04 23:56:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000587s ] [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001624s ] [2025-07-04T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1751644622 AND `outtime` >= 1751642822 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000358s ] [2025-07-04T23:57:02+08:00][sql] CONNECT:[ UseTime:0.002560s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001529s ] [2025-07-04T23:57:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001778s ] [2025-07-04T23:57:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1751644622 AND `outtime` >= 1751642822 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000314s ] [2025-07-04T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002646s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001860s ] [2025-07-04T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 1 AND `sync_status` IN (0,3) AND `created_at` <= '2025-07-04 23:57:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000498s ] [2025-07-04T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001931s ] [2025-07-04T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1751642882 LIMIT 100 [ RunTime:0.000379s ] [2025-07-04T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002408s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001604s ] [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001730s ] [2025-07-04T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1751644682 AND `outtime` >= 1751642882 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000369s ] [2025-07-04T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002341s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001737s ] [2025-07-04T23:58:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:53:02' [ RunTime:0.000352s ] [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001648s ] [2025-07-04T23:58:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:53:02' [ RunTime:0.000314s ] [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001707s ] [2025-07-04T23:58:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:53:02' [ RunTime:0.000298s ] [2025-07-04T23:58:02+08:00][sql] CONNECT:[ UseTime:0.003592s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001491s ] [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001631s ] [2025-07-04T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1751644682 AND `outtime` >= 1751642882 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000319s ] [2025-07-04T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002502s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001537s ] [2025-07-04T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 2 AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000443s ] [2025-07-04T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002411s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001452s ] [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001687s ] [2025-07-04T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1751644682 AND `outtime` >= 1751642882 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000347s ] [2025-07-04T23:58:02+08:00][sql] CONNECT:[ UseTime:0.002341s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:58:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001490s ] [2025-07-04T23:58:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 0 AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000439s ] [2025-07-04T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002712s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001794s ] [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001735s ] [2025-07-04T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_prop` WHERE `outtime` <= 1751644742 AND `outtime` >= 1751642942 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000345s ] [2025-07-04T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002379s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:59:02+08:00][sql] CONNECT:[ UseTime:0.003230s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001548s ] [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001495s ] [2025-07-04T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 1 AND `sync_status` IN (0,3) AND `created_at` <= '2025-07-04 23:58:02' ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000477s ] [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001686s ] [2025-07-04T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_role` WHERE `outtime` <= 1751644742 AND `outtime` >= 1751642942 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000332s ] [2025-07-04T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002353s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001624s ] [2025-07-04T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`ordertype`,`orderno`,`relationid`,`tid`,`tousername`,`order_details` FROM `trade_order` WHERE `pay_status` = 0 AND `addtime` < 1751642942 LIMIT 100 [ RunTime:0.000349s ] [2025-07-04T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002386s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001694s ] [2025-07-04T23:59:02+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:54:02' [ RunTime:0.000350s ] [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001624s ] [2025-07-04T23:59:02+08:00][sql] UPDATE `trade_role` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:54:02' [ RunTime:0.000322s ] [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001579s ] [2025-07-04T23:59:02+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 2 WHERE `trade_status` = 1 AND `created_at` <= '2025-07-04 23:54:02' [ RunTime:0.000304s ] [2025-07-04T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002621s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001682s ] [2025-07-04T23:59:02+08:00][sql] CONNECT:[ UseTime:0.002339s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 2 AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000624s ] [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001530s ] [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001702s ] [2025-07-04T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`username`,`trade_status` FROM `trade_gold` WHERE `outtime` <= 1751644742 AND `outtime` >= 1751642942 AND `trade_status` = 2 LIMIT 100 [ RunTime:0.000389s ] [2025-07-04T23:59:02+08:00][sql] CONNECT:[ UseTime:0.001970s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T23:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001373s ] [2025-07-04T23:59:02+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_tradeno`,`sync_status`,`step_status`,`created_at` FROM `trade` WHERE `type` = 0 AND `sync_status` IN (0,3) ORDER BY `sync_status` DESC LIMIT 20 [ RunTime:0.000336s ]