[2025-08-04T09:34:17+08:00][sql] CONNECT:[ UseTime:0.010737s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:34:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001485s ]
[2025-08-04T09:34:17+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000368s ]
[2025-08-04T09:34:17+08:00][sql] CONNECT:[ UseTime:0.010961s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:34:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001641s ]
[2025-08-04T09:34:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.011970s ]
[2025-08-04T09:34:17+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.081987s ]
[2025-08-04T09:34:23+08:00][sql] CONNECT:[ UseTime:0.001535s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:34:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001565s ]
[2025-08-04T09:34:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.005666s ]
[2025-08-04T09:34:23+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.047062s ]
[2025-08-04T09:34:26+08:00][sql] CONNECT:[ UseTime:0.001522s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:34:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001626s ]
[2025-08-04T09:34:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.005716s ]
[2025-08-04T09:34:26+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5 ORDER BY `itemid` DESC LIMIT 18340,10 [ RunTime:0.062838s ]
[2025-08-04T09:35:24+08:00][sql] CONNECT:[ UseTime:0.010934s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:35:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001548s ]
[2025-08-04T09:35:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.005415s ]
[2025-08-04T09:35:24+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5 ORDER BY `itemid` DESC LIMIT 18330,10 [ RunTime:0.058424s ]
[2025-08-04T09:57:27+08:00][sql] CONNECT:[ UseTime:0.011597s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:57:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001332s ]
[2025-08-04T09:57:27+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000272s ]
[2025-08-04T09:57:28+08:00][sql] CONNECT:[ UseTime:0.011569s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:57:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001491s ]
[2025-08-04T09:57:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000862s ]
[2025-08-04T09:57:28+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000311s ]
[2025-08-04T09:57:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001209s ]
[2025-08-04T09:57:28+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000289s ]
[2025-08-04T09:57:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000991s ]
[2025-08-04T09:57:28+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000297s ]
[2025-08-04T09:58:38+08:00][sql] CONNECT:[ UseTime:0.001501s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:58:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001475s ]
[2025-08-04T09:58:38+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000277s ]
[2025-08-04T09:58:38+08:00][sql] CONNECT:[ UseTime:0.001428s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:58:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001484s ]
[2025-08-04T09:58:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000891s ]
[2025-08-04T09:58:38+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000297s ]
[2025-08-04T09:58:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001195s ]
[2025-08-04T09:58:38+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000303s ]
[2025-08-04T09:58:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000931s ]
[2025-08-04T09:58:38+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000293s ]
[2025-08-04T09:58:44+08:00][sql] CONNECT:[ UseTime:0.010794s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:58:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001592s ]
[2025-08-04T09:58:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE  `game` = 'shaiya5' LIMIT 1 [ RunTime:0.000316s ]
[2025-08-04T09:58:45+08:00][sql] CONNECT:[ UseTime:0.010970s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:58:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001598s ]
[2025-08-04T09:58:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE  `game` = 'shaiya5' LIMIT 1 [ RunTime:0.000337s ]
[2025-08-04T09:58:48+08:00][sql] CONNECT:[ UseTime:0.010736s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:58:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001455s ]
[2025-08-04T09:58:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000818s ]
[2025-08-04T09:58:48+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000278s ]
[2025-08-04T09:58:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001100s ]
[2025-08-04T09:58:48+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000339s ]
[2025-08-04T09:58:48+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000912s ]
[2025-08-04T09:58:48+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000271s ]
[2025-08-04T09:58:48+08:00][sql] CONNECT:[ UseTime:0.011373s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T09:58:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001543s ]
[2025-08-04T09:58:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000880s ]
[2025-08-04T09:58:48+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000294s ]
[2025-08-04T09:58:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001157s ]
[2025-08-04T09:58:48+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000290s ]
[2025-08-04T09:58:48+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000972s ]
[2025-08-04T09:58:48+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000277s ]
[2025-08-04T10:01:12+08:00][sql] CONNECT:[ UseTime:0.010918s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001430s ]
[2025-08-04T10:01:12+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000335s ]
[2025-08-04T10:01:12+08:00][sql] CONNECT:[ UseTime:0.011041s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001387s ]
[2025-08-04T10:01:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000862s ]
[2025-08-04T10:01:12+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000320s ]
[2025-08-04T10:01:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001286s ]
[2025-08-04T10:01:12+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000348s ]
[2025-08-04T10:01:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001037s ]
[2025-08-04T10:01:12+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000340s ]
[2025-08-04T10:01:14+08:00][sql] CONNECT:[ UseTime:0.001522s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001389s ]
[2025-08-04T10:01:14+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000318s ]
[2025-08-04T10:01:14+08:00][sql] CONNECT:[ UseTime:0.011415s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001399s ]
[2025-08-04T10:01:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000806s ]
[2025-08-04T10:01:14+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000290s ]
[2025-08-04T10:01:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001148s ]
[2025-08-04T10:01:14+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000313s ]
[2025-08-04T10:01:14+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000930s ]
[2025-08-04T10:01:16+08:00][sql] CONNECT:[ UseTime:0.011132s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001472s ]
[2025-08-04T10:01:16+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000366s ]
[2025-08-04T10:01:16+08:00][sql] CONNECT:[ UseTime:0.011000s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001368s ]
[2025-08-04T10:01:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000237s ]
[2025-08-04T10:01:22+08:00][sql] CONNECT:[ UseTime:0.010424s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001494s ]
[2025-08-04T10:01:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000847s ]
[2025-08-04T10:01:22+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000344s ]
[2025-08-04T10:01:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001256s ]
[2025-08-04T10:01:22+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000306s ]
[2025-08-04T10:01:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001004s ]
[2025-08-04T10:01:24+08:00][sql] CONNECT:[ UseTime:0.010937s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001539s ]
[2025-08-04T10:01:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000879s ]
[2025-08-04T10:01:24+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000329s ]
[2025-08-04T10:01:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001192s ]
[2025-08-04T10:01:24+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000349s ]
[2025-08-04T10:01:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000953s ]
[2025-08-04T10:01:24+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000267s ]
[2025-08-04T10:01:24+08:00][sql] CONNECT:[ UseTime:0.011457s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001594s ]
[2025-08-04T10:01:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000944s ]
[2025-08-04T10:01:24+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000293s ]
[2025-08-04T10:01:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001248s ]
[2025-08-04T10:01:24+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000293s ]
[2025-08-04T10:01:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001051s ]
[2025-08-04T10:01:24+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000355s ]
[2025-08-04T10:01:24+08:00][sql] CONNECT:[ UseTime:0.001564s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001628s ]
[2025-08-04T10:01:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000908s ]
[2025-08-04T10:01:24+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000265s ]
[2025-08-04T10:01:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001251s ]
[2025-08-04T10:01:24+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000325s ]
[2025-08-04T10:01:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001094s ]
[2025-08-04T10:01:24+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000292s ]
[2025-08-04T10:01:26+08:00][sql] CONNECT:[ UseTime:0.011911s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001733s ]
[2025-08-04T10:01:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000241s ]
[2025-08-04T10:01:26+08:00][sql] CONNECT:[ UseTime:0.010877s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:01:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001501s ]
[2025-08-04T10:01:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000250s ]
[2025-08-04T10:10:00+08:00][sql] CONNECT:[ UseTime:0.001552s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001324s ]
[2025-08-04T10:10:00+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000307s ]
[2025-08-04T10:10:00+08:00][sql] CONNECT:[ UseTime:0.011020s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001596s ]
[2025-08-04T10:10:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000957s ]
[2025-08-04T10:10:00+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000327s ]
[2025-08-04T10:10:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001317s ]
[2025-08-04T10:10:00+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000296s ]
[2025-08-04T10:10:00+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001116s ]
[2025-08-04T10:10:00+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000265s ]
[2025-08-04T10:10:02+08:00][sql] CONNECT:[ UseTime:0.010882s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001340s ]
[2025-08-04T10:10:02+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000275s ]
[2025-08-04T10:10:02+08:00][sql] CONNECT:[ UseTime:0.011294s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001363s ]
[2025-08-04T10:10:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000851s ]
[2025-08-04T10:10:02+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000335s ]
[2025-08-04T10:10:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001263s ]
[2025-08-04T10:10:02+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000364s ]
[2025-08-04T10:10:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001076s ]
[2025-08-04T10:10:02+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000362s ]
[2025-08-04T10:10:08+08:00][sql] CONNECT:[ UseTime:0.001512s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001322s ]
[2025-08-04T10:10:08+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000292s ]
[2025-08-04T10:10:08+08:00][sql] CONNECT:[ UseTime:0.001492s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001536s ]
[2025-08-04T10:10:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000810s ]
[2025-08-04T10:10:08+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000268s ]
[2025-08-04T10:10:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001204s ]
[2025-08-04T10:10:08+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000286s ]
[2025-08-04T10:10:08+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001002s ]
[2025-08-04T10:10:09+08:00][sql] CONNECT:[ UseTime:0.011534s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001325s ]
[2025-08-04T10:10:09+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000295s ]
[2025-08-04T10:10:09+08:00][sql] CONNECT:[ UseTime:0.010859s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001466s ]
[2025-08-04T10:10:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000249s ]
[2025-08-04T10:10:10+08:00][sql] CONNECT:[ UseTime:0.001537s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001440s ]
[2025-08-04T10:10:10+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000274s ]
[2025-08-04T10:10:10+08:00][sql] CONNECT:[ UseTime:0.011417s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001410s ]
[2025-08-04T10:10:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` LIMIT 1 [ RunTime:0.000415s ]
[2025-08-04T10:10:10+08:00][sql] SELECT IFNULL(SUM(to.price), 0) AS total_price,IFNULL(SUM(to.amount), 0) AS total_amount,IFNULL(SUM(to.charge), 0) AS total_charge FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` [ RunTime:0.000234s ]
[2025-08-04T10:10:11+08:00][sql] CONNECT:[ UseTime:0.001471s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001416s ]
[2025-08-04T10:10:11+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000288s ]
[2025-08-04T10:10:11+08:00][sql] CONNECT:[ UseTime:0.010950s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001389s ]
[2025-08-04T10:10:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE  `ordertype` = -1 LIMIT 1 [ RunTime:0.000294s ]
[2025-08-04T10:10:11+08:00][sql] SELECT * FROM `trade_stats` WHERE  `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000239s ]
[2025-08-04T10:10:11+08:00][sql] SELECT IFNULL(SUM(total_price), '0.00') as total_price,IFNULL(SUM(total_withdraw), '0.00') as total_withdraw,IFNULL(SUM(total_charge), '0.00') as total_charge FROM `trade_stats` WHERE  `ordertype` = -1 LIMIT 1 [ RunTime:0.000246s ]
[2025-08-04T10:10:12+08:00][sql] CONNECT:[ UseTime:0.011411s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001326s ]
[2025-08-04T10:10:12+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000296s ]
[2025-08-04T10:10:12+08:00][sql] CONNECT:[ UseTime:0.011570s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:10:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001286s ]
[2025-08-04T10:10:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000795s ]
[2025-08-04T10:10:12+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000269s ]
[2025-08-04T10:18:41+08:00][sql] CONNECT:[ UseTime:0.001407s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001328s ]
[2025-08-04T10:18:41+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000274s ]
[2025-08-04T10:18:41+08:00][sql] CONNECT:[ UseTime:0.010929s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001385s ]
[2025-08-04T10:18:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000910s ]
[2025-08-04T10:18:41+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000381s ]
[2025-08-04T10:18:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001350s ]
[2025-08-04T10:18:41+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000292s ]
[2025-08-04T10:18:41+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001062s ]
[2025-08-04T10:18:42+08:00][sql] CONNECT:[ UseTime:0.011461s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001448s ]
[2025-08-04T10:18:42+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000284s ]
[2025-08-04T10:18:42+08:00][sql] CONNECT:[ UseTime:0.001415s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001602s ]
[2025-08-04T10:18:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000908s ]
[2025-08-04T10:18:42+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000375s ]
[2025-08-04T10:18:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001320s ]
[2025-08-04T10:18:42+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000285s ]
[2025-08-04T10:18:42+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001051s ]
[2025-08-04T10:18:42+08:00][sql] CONNECT:[ UseTime:0.011509s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001300s ]
[2025-08-04T10:18:42+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000309s ]
[2025-08-04T10:18:43+08:00][sql] CONNECT:[ UseTime:0.010688s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001643s ]
[2025-08-04T10:18:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.001051s ]
[2025-08-04T10:18:43+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000326s ]
[2025-08-04T10:18:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001381s ]
[2025-08-04T10:18:43+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000354s ]
[2025-08-04T10:18:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001034s ]
[2025-08-04T10:18:43+08:00][sql] CONNECT:[ UseTime:0.011541s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001449s ]
[2025-08-04T10:18:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000284s ]
[2025-08-04T10:18:43+08:00][sql] CONNECT:[ UseTime:0.011559s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001551s ]
[2025-08-04T10:18:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000872s ]
[2025-08-04T10:18:43+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000359s ]
[2025-08-04T10:18:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001200s ]
[2025-08-04T10:18:43+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000287s ]
[2025-08-04T10:18:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001010s ]
[2025-08-04T10:18:43+08:00][sql] CONNECT:[ UseTime:0.011524s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001457s ]
[2025-08-04T10:18:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000298s ]
[2025-08-04T10:18:43+08:00][sql] CONNECT:[ UseTime:0.010833s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001365s ]
[2025-08-04T10:18:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000812s ]
[2025-08-04T10:18:43+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000262s ]
[2025-08-04T10:18:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001316s ]
[2025-08-04T10:18:43+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000287s ]
[2025-08-04T10:18:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001047s ]
[2025-08-04T10:18:44+08:00][sql] CONNECT:[ UseTime:0.011031s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001297s ]
[2025-08-04T10:18:44+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000279s ]
[2025-08-04T10:18:44+08:00][sql] CONNECT:[ UseTime:0.011893s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001359s ]
[2025-08-04T10:18:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000836s ]
[2025-08-04T10:18:44+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000361s ]
[2025-08-04T10:18:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001322s ]
[2025-08-04T10:18:44+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000295s ]
[2025-08-04T10:18:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001068s ]
[2025-08-04T10:18:45+08:00][sql] CONNECT:[ UseTime:0.011241s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001399s ]
[2025-08-04T10:18:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000293s ]
[2025-08-04T10:18:45+08:00][sql] CONNECT:[ UseTime:0.011188s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001480s ]
[2025-08-04T10:18:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000878s ]
[2025-08-04T10:18:45+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000325s ]
[2025-08-04T10:18:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001088s ]
[2025-08-04T10:18:45+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000364s ]
[2025-08-04T10:18:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000907s ]
[2025-08-04T10:18:45+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000266s ]
[2025-08-04T10:18:45+08:00][sql] CONNECT:[ UseTime:0.011667s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001591s ]
[2025-08-04T10:18:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000969s ]
[2025-08-04T10:18:45+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000285s ]
[2025-08-04T10:18:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001112s ]
[2025-08-04T10:18:45+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000312s ]
[2025-08-04T10:18:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000869s ]
[2025-08-04T10:18:45+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000266s ]
[2025-08-04T10:18:46+08:00][sql] CONNECT:[ UseTime:0.010926s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001492s ]
[2025-08-04T10:18:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000851s ]
[2025-08-04T10:18:46+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000390s ]
[2025-08-04T10:18:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001259s ]
[2025-08-04T10:18:46+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000299s ]
[2025-08-04T10:18:46+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001011s ]
[2025-08-04T10:18:46+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000268s ]
[2025-08-04T10:18:46+08:00][sql] CONNECT:[ UseTime:0.011431s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001469s ]
[2025-08-04T10:18:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000871s ]
[2025-08-04T10:18:46+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000296s ]
[2025-08-04T10:18:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001160s ]
[2025-08-04T10:18:46+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000339s ]
[2025-08-04T10:18:46+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000935s ]
[2025-08-04T10:18:46+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000308s ]
[2025-08-04T10:18:46+08:00][sql] CONNECT:[ UseTime:0.001489s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001497s ]
[2025-08-04T10:18:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000773s ]
[2025-08-04T10:18:46+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000257s ]
[2025-08-04T10:18:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001169s ]
[2025-08-04T10:18:46+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000289s ]
[2025-08-04T10:18:46+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001057s ]
[2025-08-04T10:18:46+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000263s ]
[2025-08-04T10:18:48+08:00][sql] CONNECT:[ UseTime:0.001446s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001384s ]
[2025-08-04T10:18:48+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000343s ]
[2025-08-04T10:18:48+08:00][sql] CONNECT:[ UseTime:0.011014s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001523s ]
[2025-08-04T10:18:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000865s ]
[2025-08-04T10:18:48+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000293s ]
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001192s ]
[2025-08-04T10:18:48+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000349s ]
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000949s ]
[2025-08-04T10:18:48+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000298s ]
[2025-08-04T10:18:48+08:00][sql] CONNECT:[ UseTime:0.010399s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001449s ]
[2025-08-04T10:18:48+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000276s ]
[2025-08-04T10:18:48+08:00][sql] CONNECT:[ UseTime:0.011197s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001536s ]
[2025-08-04T10:18:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000875s ]
[2025-08-04T10:18:48+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000439s ]
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001567s ]
[2025-08-04T10:18:48+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000380s ]
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001187s ]
[2025-08-04T10:18:48+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000443s ]
[2025-08-04T10:18:48+08:00][sql] CONNECT:[ UseTime:0.011395s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001278s ]
[2025-08-04T10:18:48+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000300s ]
[2025-08-04T10:18:48+08:00][sql] CONNECT:[ UseTime:0.001409s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001430s ]
[2025-08-04T10:18:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000836s ]
[2025-08-04T10:18:48+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000264s ]
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001148s ]
[2025-08-04T10:18:48+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000283s ]
[2025-08-04T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000959s ]
[2025-08-04T10:18:48+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000291s ]
[2025-08-04T10:18:49+08:00][sql] CONNECT:[ UseTime:0.011516s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001325s ]
[2025-08-04T10:18:49+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000285s ]
[2025-08-04T10:18:49+08:00][sql] CONNECT:[ UseTime:0.011220s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001404s ]
[2025-08-04T10:18:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000804s ]
[2025-08-04T10:18:49+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000302s ]
[2025-08-04T10:18:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001349s ]
[2025-08-04T10:18:49+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000285s ]
[2025-08-04T10:18:49+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001060s ]
[2025-08-04T10:18:49+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000290s ]
[2025-08-04T10:18:49+08:00][sql] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001480s ]
[2025-08-04T10:18:49+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000276s ]
[2025-08-04T10:18:49+08:00][sql] CONNECT:[ UseTime:0.010623s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001596s ]
[2025-08-04T10:18:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000862s ]
[2025-08-04T10:18:49+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000357s ]
[2025-08-04T10:18:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001222s ]
[2025-08-04T10:18:49+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000373s ]
[2025-08-04T10:18:49+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001025s ]
[2025-08-04T10:18:49+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000359s ]
[2025-08-04T10:18:50+08:00][sql] CONNECT:[ UseTime:0.011327s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001346s ]
[2025-08-04T10:18:50+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000277s ]
[2025-08-04T10:18:50+08:00][sql] CONNECT:[ UseTime:0.011404s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001470s ]
[2025-08-04T10:18:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000810s ]
[2025-08-04T10:18:50+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000355s ]
[2025-08-04T10:18:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001229s ]
[2025-08-04T10:18:50+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000367s ]
[2025-08-04T10:18:50+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001004s ]
[2025-08-04T10:18:50+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000351s ]
[2025-08-04T10:18:51+08:00][sql] CONNECT:[ UseTime:0.010890s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001498s ]
[2025-08-04T10:18:51+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000373s ]
[2025-08-04T10:18:51+08:00][sql] CONNECT:[ UseTime:0.011135s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:18:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001558s ]
[2025-08-04T10:18:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000866s ]
[2025-08-04T10:18:51+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000374s ]
[2025-08-04T10:18:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001193s ]
[2025-08-04T10:18:51+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000294s ]
[2025-08-04T10:18:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000945s ]
[2025-08-04T10:18:51+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000267s ]
[2025-08-04T10:27:38+08:00][sql] CONNECT:[ UseTime:0.011016s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:27:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001240s ]
[2025-08-04T10:27:38+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000278s ]
[2025-08-04T10:27:38+08:00][sql] CONNECT:[ UseTime:0.011449s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:27:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001381s ]
[2025-08-04T10:27:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000912s ]
[2025-08-04T10:27:38+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000326s ]
[2025-08-04T10:27:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001305s ]
[2025-08-04T10:27:38+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000295s ]
[2025-08-04T10:27:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001058s ]
[2025-08-04T10:27:38+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000355s ]
[2025-08-04T10:33:47+08:00][sql] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:33:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001598s ]
[2025-08-04T10:33:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000931s ]
[2025-08-04T10:33:47+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000342s ]
[2025-08-04T10:33:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001155s ]
[2025-08-04T10:33:47+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000321s ]
[2025-08-04T10:33:47+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000938s ]
[2025-08-04T10:33:47+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000276s ]
[2025-08-04T10:37:51+08:00][sql] CONNECT:[ UseTime:0.011723s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:37:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001486s ]
[2025-08-04T10:37:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE  `game` = 'shaiya'  AND `serverid` = 6 LIMIT 1 [ RunTime:0.000316s ]
[2025-08-04T10:37:51+08:00][sql] SELECT * FROM `trade_role` WHERE  `game` = 'shaiya'  AND `serverid` = 6 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000307s ]
[2025-08-04T10:37:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001180s ]
[2025-08-04T10:37:51+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000339s ]
[2025-08-04T10:37:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001030s ]
[2025-08-04T10:37:51+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000327s ]
[2025-08-04T10:37:53+08:00][sql] CONNECT:[ UseTime:0.010962s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:37:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001522s ]
[2025-08-04T10:37:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE  `game` = 'shaiya'  AND `serverid` = 6 LIMIT 1 [ RunTime:0.000328s ]
[2025-08-04T10:37:53+08:00][sql] SELECT * FROM `trade_role` WHERE  `game` = 'shaiya'  AND `serverid` = 6 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000331s ]
[2025-08-04T10:37:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001204s ]
[2025-08-04T10:37:53+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000281s ]
[2025-08-04T10:37:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000996s ]
[2025-08-04T10:37:53+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000261s ]
[2025-08-04T10:37:53+08:00][sql] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:37:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001480s ]
[2025-08-04T10:37:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE  `game` = 'shaiya'  AND `serverid` = 6 LIMIT 1 [ RunTime:0.000338s ]
[2025-08-04T10:37:53+08:00][sql] SELECT * FROM `trade_role` WHERE  `game` = 'shaiya'  AND `serverid` = 6 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000306s ]
[2025-08-04T10:37:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001256s ]
[2025-08-04T10:37:53+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (25,24,23,20,18,17,13,10,6,5)  AND `pay_status` IN (0,1) [ RunTime:0.000317s ]
[2025-08-04T10:37:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000965s ]
[2025-08-04T10:37:53+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (25,24,23,20,18,17,13,10,6,5) [ RunTime:0.000266s ]
[2025-08-04T10:37:56+08:00][sql] CONNECT:[ UseTime:0.010613s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:37:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001490s ]
[2025-08-04T10:37:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE  `game` = 'shaiya'  AND `serverid` = 1 LIMIT 1 [ RunTime:0.000325s ]
[2025-08-04T10:38:01+08:00][sql] CONNECT:[ UseTime:0.001561s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001702s ]
[2025-08-04T10:38:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE  `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000396s ]
[2025-08-04T10:38:01+08:00][sql] SELECT * FROM `trade_role` WHERE  `game` = 'shaiya5'  AND `serverid` = 5 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000290s ]
[2025-08-04T10:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001226s ]
[2025-08-04T10:38:01+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` = 27  AND `pay_status` IN (0,1) [ RunTime:0.000276s ]
[2025-08-04T10:38:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000994s ]
[2025-08-04T10:38:01+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 27 [ RunTime:0.000231s ]
[2025-08-04T10:38:03+08:00][sql] CONNECT:[ UseTime:0.010888s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:38:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001298s ]
[2025-08-04T10:38:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001270s ]
[2025-08-04T10:38:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001097s ]
[2025-08-04T10:38:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001070s ]
[2025-08-04T10:38:03+08:00][sql] SELECT * FROM `trade_role` WHERE  `id` = 15 LIMIT 1 [ RunTime:0.000311s ]
[2025-08-04T10:38:03+08:00][sql] SELECT `sync_status` FROM `trade` WHERE  `id` = 27 LIMIT 1 [ RunTime:0.000202s ]
[2025-08-04T10:38:03+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 27  AND `ordertype` = 1  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000291s ]
[2025-08-04T10:38:03+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 27 LIMIT 1 [ RunTime:0.000224s ]
[2025-08-04T10:38:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000947s ]
[2025-08-04T10:38:03+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000271s ]
[2025-08-04T10:38:20+08:00][sql] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:38:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001346s ]
[2025-08-04T10:38:20+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000361s ]
[2025-08-04T10:38:20+08:00][sql] CONNECT:[ UseTime:0.010292s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:38:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001217s ]
[2025-08-04T10:38:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE  `ordertype` = -1 LIMIT 1 [ RunTime:0.000313s ]
[2025-08-04T10:38:20+08:00][sql] SELECT * FROM `trade_stats` WHERE  `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000282s ]
[2025-08-04T10:38:20+08:00][sql] SELECT IFNULL(SUM(total_price), '0.00') as total_price,IFNULL(SUM(total_withdraw), '0.00') as total_withdraw,IFNULL(SUM(total_charge), '0.00') as total_charge FROM `trade_stats` WHERE  `ordertype` = -1 LIMIT 1 [ RunTime:0.000269s ]
[2025-08-04T10:38:31+08:00][sql] CONNECT:[ UseTime:0.011052s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:38:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001407s ]
[2025-08-04T10:38:31+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000326s ]
[2025-08-04T10:38:31+08:00][sql] CONNECT:[ UseTime:0.011011s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:38:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001419s ]
[2025-08-04T10:38:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000894s ]
[2025-08-04T10:38:31+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000236s ]
[2025-08-04T10:38:46+08:00][sql] CONNECT:[ UseTime:0.011206s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:38:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001401s ]
[2025-08-04T10:38:46+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000288s ]
[2025-08-04T10:38:46+08:00][sql] CONNECT:[ UseTime:0.001332s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:38:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001319s ]
[2025-08-04T10:38:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` LIMIT 1 [ RunTime:0.000294s ]
[2025-08-04T10:38:46+08:00][sql] SELECT IFNULL(SUM(to.price), 0) AS total_price,IFNULL(SUM(to.amount), 0) AS total_amount,IFNULL(SUM(to.charge), 0) AS total_charge FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` [ RunTime:0.000273s ]
[2025-08-04T10:39:08+08:00][sql] CONNECT:[ UseTime:0.010943s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001326s ]
[2025-08-04T10:39:08+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000301s ]
[2025-08-04T10:39:08+08:00][sql] CONNECT:[ UseTime:0.010938s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001722s ]
[2025-08-04T10:39:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000876s ]
[2025-08-04T10:39:08+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000281s ]
[2025-08-04T10:39:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001161s ]
[2025-08-04T10:39:08+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000303s ]
[2025-08-04T10:39:08+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001058s ]
[2025-08-04T10:39:08+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000320s ]
[2025-08-04T10:39:09+08:00][sql] CONNECT:[ UseTime:0.011130s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001344s ]
[2025-08-04T10:39:09+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000284s ]
[2025-08-04T10:39:09+08:00][sql] CONNECT:[ UseTime:0.011216s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001413s ]
[2025-08-04T10:39:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000821s ]
[2025-08-04T10:39:09+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000275s ]
[2025-08-04T10:39:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001167s ]
[2025-08-04T10:39:09+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000322s ]
[2025-08-04T10:39:09+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000951s ]
[2025-08-04T10:39:09+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000274s ]
[2025-08-04T10:39:11+08:00][sql] CONNECT:[ UseTime:0.010423s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001271s ]
[2025-08-04T10:39:11+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000270s ]
[2025-08-04T10:39:11+08:00][sql] CONNECT:[ UseTime:0.010970s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001600s ]
[2025-08-04T10:39:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000902s ]
[2025-08-04T10:39:11+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000296s ]
[2025-08-04T10:39:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001200s ]
[2025-08-04T10:39:11+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000374s ]
[2025-08-04T10:39:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001000s ]
[2025-08-04T10:39:11+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000387s ]
[2025-08-04T10:39:11+08:00][sql] CONNECT:[ UseTime:0.011746s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001270s ]
[2025-08-04T10:39:11+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000301s ]
[2025-08-04T10:39:11+08:00][sql] CONNECT:[ UseTime:0.001346s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001379s ]
[2025-08-04T10:39:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000879s ]
[2025-08-04T10:39:11+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000367s ]
[2025-08-04T10:39:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001271s ]
[2025-08-04T10:39:11+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000377s ]
[2025-08-04T10:39:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001007s ]
[2025-08-04T10:39:11+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000273s ]
[2025-08-04T10:39:32+08:00][sql] CONNECT:[ UseTime:0.001485s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001262s ]
[2025-08-04T10:39:32+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000271s ]
[2025-08-04T10:39:32+08:00][sql] CONNECT:[ UseTime:0.011082s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001643s ]
[2025-08-04T10:39:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000934s ]
[2025-08-04T10:39:32+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000270s ]
[2025-08-04T10:39:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001179s ]
[2025-08-04T10:39:32+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000310s ]
[2025-08-04T10:39:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000920s ]
[2025-08-04T10:39:32+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000334s ]
[2025-08-04T10:39:33+08:00][sql] CONNECT:[ UseTime:0.010964s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001362s ]
[2025-08-04T10:39:33+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000283s ]
[2025-08-04T10:39:33+08:00][sql] CONNECT:[ UseTime:0.010425s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:39:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001475s ]
[2025-08-04T10:39:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000858s ]
[2025-08-04T10:39:33+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000340s ]
[2025-08-04T10:39:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001162s ]
[2025-08-04T10:39:33+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000321s ]
[2025-08-04T10:39:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000941s ]
[2025-08-04T10:39:33+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000311s ]
[2025-08-04T10:47:32+08:00][sql] CONNECT:[ UseTime:0.010702s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:47:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001255s ]
[2025-08-04T10:47:32+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000353s ]
[2025-08-04T10:47:32+08:00][sql] CONNECT:[ UseTime:0.001548s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:47:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001665s ]
[2025-08-04T10:47:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000933s ]
[2025-08-04T10:47:32+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000262s ]
[2025-08-04T10:47:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001234s ]
[2025-08-04T10:47:32+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000326s ]
[2025-08-04T10:47:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001049s ]
[2025-08-04T10:47:32+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000279s ]
[2025-08-04T10:48:11+08:00][sql] CONNECT:[ UseTime:0.011391s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001470s ]
[2025-08-04T10:48:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000871s ]
[2025-08-04T10:48:11+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000275s ]
[2025-08-04T10:48:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001147s ]
[2025-08-04T10:48:11+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (5,4,3,2,1)  AND `pay_status` IN (0,1) [ RunTime:0.000286s ]
[2025-08-04T10:48:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000914s ]
[2025-08-04T10:48:11+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (5,4,3,2,1) [ RunTime:0.000254s ]
[2025-08-04T10:48:20+08:00][sql] CONNECT:[ UseTime:0.010632s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001533s ]
[2025-08-04T10:48:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000949s ]
[2025-08-04T10:48:20+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000311s ]
[2025-08-04T10:48:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001251s ]
[2025-08-04T10:48:20+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000293s ]
[2025-08-04T10:48:20+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001033s ]
[2025-08-04T10:48:20+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000277s ]
[2025-08-04T10:48:44+08:00][sql] CONNECT:[ UseTime:0.011042s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001471s ]
[2025-08-04T10:48:44+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000359s ]
[2025-08-04T10:48:44+08:00][sql] CONNECT:[ UseTime:0.010920s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001426s ]
[2025-08-04T10:48:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000244s ]
[2025-08-04T10:48:45+08:00][sql] CONNECT:[ UseTime:0.011411s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001448s ]
[2025-08-04T10:48:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000284s ]
[2025-08-04T10:48:45+08:00][sql] CONNECT:[ UseTime:0.001519s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001506s ]
[2025-08-04T10:48:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` LIMIT 1 [ RunTime:0.000374s ]
[2025-08-04T10:48:45+08:00][sql] SELECT IFNULL(SUM(to.price), 0) AS total_price,IFNULL(SUM(to.amount), 0) AS total_amount,IFNULL(SUM(to.charge), 0) AS total_charge FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` [ RunTime:0.000271s ]
[2025-08-04T10:48:46+08:00][sql] CONNECT:[ UseTime:0.011113s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001309s ]
[2025-08-04T10:48:46+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000298s ]
[2025-08-04T10:48:46+08:00][sql] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001306s ]
[2025-08-04T10:48:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE  `ordertype` = -1 LIMIT 1 [ RunTime:0.000298s ]
[2025-08-04T10:48:46+08:00][sql] SELECT * FROM `trade_stats` WHERE  `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000328s ]
[2025-08-04T10:48:46+08:00][sql] SELECT IFNULL(SUM(total_price), '0.00') as total_price,IFNULL(SUM(total_withdraw), '0.00') as total_withdraw,IFNULL(SUM(total_charge), '0.00') as total_charge FROM `trade_stats` WHERE  `ordertype` = -1 LIMIT 1 [ RunTime:0.000304s ]
[2025-08-04T10:48:53+08:00][sql] CONNECT:[ UseTime:0.011219s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001354s ]
[2025-08-04T10:48:53+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000281s ]
[2025-08-04T10:48:53+08:00][sql] CONNECT:[ UseTime:0.011535s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001284s ]
[2025-08-04T10:48:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000831s ]
[2025-08-04T10:48:53+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000258s ]
[2025-08-04T10:48:58+08:00][sql] CONNECT:[ UseTime:0.010978s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001437s ]
[2025-08-04T10:48:58+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000291s ]
[2025-08-04T10:48:58+08:00][sql] CONNECT:[ UseTime:0.011514s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:48:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001619s ]
[2025-08-04T10:48:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000879s ]
[2025-08-04T10:48:58+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000279s ]
[2025-08-04T10:48:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001214s ]
[2025-08-04T10:48:58+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000297s ]
[2025-08-04T10:48:58+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000989s ]
[2025-08-04T10:49:05+08:00][sql] CONNECT:[ UseTime:0.010883s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:49:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001362s ]
[2025-08-04T10:49:05+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000279s ]
[2025-08-04T10:49:05+08:00][sql] CONNECT:[ UseTime:0.010394s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:49:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001517s ]
[2025-08-04T10:49:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000891s ]
[2025-08-04T10:49:05+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000313s ]
[2025-08-04T10:49:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001226s ]
[2025-08-04T10:49:05+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000301s ]
[2025-08-04T10:49:05+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000967s ]
[2025-08-04T10:49:27+08:00][sql] CONNECT:[ UseTime:0.010869s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:49:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001345s ]
[2025-08-04T10:49:27+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000268s ]
[2025-08-04T10:49:27+08:00][sql] CONNECT:[ UseTime:0.011270s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T10:49:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001475s ]
[2025-08-04T10:49:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000874s ]
[2025-08-04T10:49:27+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000319s ]
[2025-08-04T10:49:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001161s ]
[2025-08-04T10:49:27+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000386s ]
[2025-08-04T10:49:27+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001002s ]
[2025-08-04T10:49:27+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000290s ]
[2025-08-04T11:12:00+08:00][sql] CONNECT:[ UseTime:0.001665s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:12:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001455s ]
[2025-08-04T11:12:00+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000284s ]
[2025-08-04T11:12:01+08:00][sql] CONNECT:[ UseTime:0.001475s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:12:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001461s ]
[2025-08-04T11:12:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000884s ]
[2025-08-04T11:12:01+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000299s ]
[2025-08-04T11:12:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001167s ]
[2025-08-04T11:12:01+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000305s ]
[2025-08-04T11:12:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000953s ]
[2025-08-04T11:12:01+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000264s ]
[2025-08-04T11:12:53+08:00][sql] CONNECT:[ UseTime:0.011417s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:12:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001336s ]
[2025-08-04T11:12:53+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000289s ]
[2025-08-04T11:12:53+08:00][sql] CONNECT:[ UseTime:0.010796s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:12:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001441s ]
[2025-08-04T11:12:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000818s ]
[2025-08-04T11:12:53+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000331s ]
[2025-08-04T11:12:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001171s ]
[2025-08-04T11:12:53+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000285s ]
[2025-08-04T11:12:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000961s ]
[2025-08-04T11:12:53+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000333s ]
[2025-08-04T11:19:39+08:00][sql] CONNECT:[ UseTime:0.010931s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:19:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001419s ]
[2025-08-04T11:19:39+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000328s ]
[2025-08-04T11:19:39+08:00][sql] CONNECT:[ UseTime:0.011331s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:19:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001579s ]
[2025-08-04T11:19:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000909s ]
[2025-08-04T11:19:39+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000283s ]
[2025-08-04T11:19:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001207s ]
[2025-08-04T11:19:39+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000285s ]
[2025-08-04T11:19:39+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000992s ]
[2025-08-04T11:19:39+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000285s ]
[2025-08-04T11:23:16+08:00][sql] CONNECT:[ UseTime:0.011011s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:23:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001242s ]
[2025-08-04T11:23:16+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000281s ]
[2025-08-04T11:23:16+08:00][sql] CONNECT:[ UseTime:0.010888s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:23:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001389s ]
[2025-08-04T11:23:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000850s ]
[2025-08-04T11:23:16+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000280s ]
[2025-08-04T11:23:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001208s ]
[2025-08-04T11:23:16+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000314s ]
[2025-08-04T11:23:16+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000966s ]
[2025-08-04T11:23:16+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000271s ]
[2025-08-04T11:45:51+08:00][sql] CONNECT:[ UseTime:0.001561s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001316s ]
[2025-08-04T11:45:51+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000288s ]
[2025-08-04T11:45:51+08:00][sql] CONNECT:[ UseTime:0.011279s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001570s ]
[2025-08-04T11:45:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000905s ]
[2025-08-04T11:45:51+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000286s ]
[2025-08-04T11:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001179s ]
[2025-08-04T11:45:51+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000297s ]
[2025-08-04T11:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000972s ]
[2025-08-04T11:46:02+08:00][sql] CONNECT:[ UseTime:0.011320s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001510s ]
[2025-08-04T11:46:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000863s ]
[2025-08-04T11:46:02+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000285s ]
[2025-08-04T11:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001219s ]
[2025-08-04T11:46:02+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` = 7  AND `pay_status` IN (0,1) [ RunTime:0.000295s ]
[2025-08-04T11:46:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001031s ]
[2025-08-04T11:46:03+08:00][sql] CONNECT:[ UseTime:0.011561s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T11:46:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001499s ]
[2025-08-04T11:46:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000827s ]
[2025-08-04T11:46:03+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000307s ]
[2025-08-04T11:46:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001160s ]
[2025-08-04T11:46:03+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (22,21,19,16,15,14,12,11,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000296s ]
[2025-08-04T11:46:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000947s ]
[2025-08-04T12:00:41+08:00][sql] CONNECT:[ UseTime:0.010903s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T12:00:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001252s ]
[2025-08-04T12:00:41+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000282s ]
[2025-08-04T12:00:41+08:00][sql] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T12:00:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001442s ]
[2025-08-04T12:00:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000950s ]
[2025-08-04T12:00:41+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000266s ]
[2025-08-04T12:00:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001129s ]
[2025-08-04T12:00:41+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (28,22,21,19,16,15,14,12,11,9)  AND `pay_status` IN (0,1) [ RunTime:0.000309s ]
[2025-08-04T12:00:41+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000968s ]
[2025-08-04T13:35:51+08:00][sql] CONNECT:[ UseTime:0.001580s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:35:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001447s ]
[2025-08-04T13:35:51+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000346s ]
[2025-08-04T13:35:51+08:00][sql] CONNECT:[ UseTime:0.011483s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:35:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001423s ]
[2025-08-04T13:35:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000847s ]
[2025-08-04T13:35:51+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000303s ]
[2025-08-04T13:35:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001106s ]
[2025-08-04T13:35:51+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (28,22,21,19,16,15,14,12,11,9)  AND `pay_status` IN (0,1) [ RunTime:0.000355s ]
[2025-08-04T13:35:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000931s ]
[2025-08-04T13:35:55+08:00][sql] CONNECT:[ UseTime:0.011147s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:35:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001434s ]
[2025-08-04T13:35:55+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000309s ]
[2025-08-04T13:35:55+08:00][sql] CONNECT:[ UseTime:0.011220s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:35:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001458s ]
[2025-08-04T13:35:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000880s ]
[2025-08-04T13:35:55+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000335s ]
[2025-08-04T13:35:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001265s ]
[2025-08-04T13:35:55+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (27,25,24,23,20,18,17,13,10,6)  AND `pay_status` IN (0,1) [ RunTime:0.000381s ]
[2025-08-04T13:35:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001028s ]
[2025-08-04T13:35:55+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (27,25,24,23,20,18,17,13,10,6) [ RunTime:0.000355s ]
[2025-08-04T13:35:58+08:00][sql] CONNECT:[ UseTime:0.001490s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:35:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001419s ]
[2025-08-04T13:35:58+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000285s ]
[2025-08-04T13:35:59+08:00][sql] CONNECT:[ UseTime:0.010550s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:35:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001543s ]
[2025-08-04T13:35:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000297s ]
[2025-08-04T13:36:00+08:00][sql] CONNECT:[ UseTime:0.001526s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:36:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001419s ]
[2025-08-04T13:36:00+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000347s ]
[2025-08-04T13:36:00+08:00][sql] CONNECT:[ UseTime:0.001481s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:36:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001377s ]
[2025-08-04T13:36:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` LIMIT 1 [ RunTime:0.000333s ]
[2025-08-04T13:36:00+08:00][sql] SELECT IFNULL(SUM(to.price), 0) AS total_price,IFNULL(SUM(to.amount), 0) AS total_amount,IFNULL(SUM(to.charge), 0) AS total_charge FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` [ RunTime:0.000285s ]
[2025-08-04T13:36:08+08:00][sql] CONNECT:[ UseTime:0.011028s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:36:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001551s ]
[2025-08-04T13:36:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001240s ]
[2025-08-04T13:36:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001188s ]
[2025-08-04T13:36:08+08:00][sql] SELECT * FROM `trade_gold` WHERE  `id` = 12 LIMIT 1 [ RunTime:0.000344s ]
[2025-08-04T13:36:08+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 28  AND `ordertype` = 0  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000287s ]
[2025-08-04T13:36:08+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001143s ]
[2025-08-04T13:36:08+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 28 LIMIT 1 [ RunTime:0.000394s ]
[2025-08-04T13:36:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000940s ]
[2025-08-04T13:36:08+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000244s ]
[2025-08-04T13:36:17+08:00][sql] CONNECT:[ UseTime:0.011132s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:36:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001427s ]
[2025-08-04T13:36:17+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000313s ]
[2025-08-04T13:36:17+08:00][sql] CONNECT:[ UseTime:0.001507s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:36:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001267s ]
[2025-08-04T13:36:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000832s ]
[2025-08-04T13:36:17+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000270s ]
[2025-08-04T13:36:22+08:00][sql] CONNECT:[ UseTime:0.010933s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:36:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001395s ]
[2025-08-04T13:36:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000314s ]
[2025-08-04T13:36:22+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000281s ]
[2025-08-04T13:41:58+08:00][sql] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:41:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001343s ]
[2025-08-04T13:41:58+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000538s ]
[2025-08-04T13:41:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001080s ]
[2025-08-04T13:41:58+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000247s ]
[2025-08-04T13:41:58+08:00][sql] CONNECT:[ UseTime:0.011445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:41:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001357s ]
[2025-08-04T13:41:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000934s ]
[2025-08-04T13:41:58+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000520s ]
[2025-08-04T13:42:11+08:00][sql] CONNECT:[ UseTime:0.011077s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001288s ]
[2025-08-04T13:42:11+08:00][sql] UPDATE `trade_help_article`  SET `game` = 'shaiya5' , `title` = '怎样购买' , `cate_id` = 1 , `sort` = 89 , `status` = 1 , `class` = 'icon_v_02' , `content` = '<p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\"><strong style=\"box-sizing: border-box;\">如何购买角色</strong></p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\"><strong style=\"box-sizing: border-box;\">步骤一：</strong><span style=\"box-sizing: border-box; padding: 0px;\">登录想要购买角色的游戏账号，点击“我是买家”，选择角色商品分类进行浏览，查看在售商品详情。</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\"><strong style=\"box-sizing: border-box;\">步骤二：</strong><span style=\"box-sizing: border-box; padding: 0px;\">选择想要购买的角色点击</span>“购买”，确认商品及订单信息后进行支付。</p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\">　<strong style=\"box-sizing: border-box;\"></strong><strong>请注意：</strong></p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1、接收角色的账号必须在被购买角色所属游戏区服登录过。</p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2、用来接收购买角色的账号下已有的游戏角色不得超出可建角色限制（单阵营最多创建5个角色）。</p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3、用于购买角色的账号账号安全信息最好不为空，且绑定了手机及完善身份证信息。我们再次提醒大家，共享账号将可能给你带来不可预估的损失和伤害。</p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\">&nbsp; &nbsp; &nbsp; &nbsp; 4、挑中自己满意的角色后，查看其相关数据信息，一一确认了之后，支付即可。</p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\"><span style=\"box-sizing: border-box; padding: 0px;\">&nbsp; &nbsp; &nbsp; &nbsp; 5、购买成功后，可在</span>“我的珍宝阁→我的订单”中查看。</p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\"><strong style=\"box-sizing: border-box;\">步骤三：</strong>购买发货成功后，使用购买账号登录游戏即可看到购买的角色。</p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\">　<strong style=\"box-sizing: border-box;\">请注意：</strong></p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255);\">　　角色购买成功后，则在游戏角色界面增加所购买的角色，并可正常游戏。也即购买的角色成功转入到执行购买操作的通行证账号下。</p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255);\"><br/></p><hr style=\"text-wrap-mode: wrap;\"/><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\"><strong style=\"box-sizing: border-box;\">如何购买金币/道具</strong></p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\"><strong style=\"box-sizing: border-box;\">步骤一：</strong><span style=\"box-sizing: border-box; padding: 0px;\">登录想要购买角色的游戏账号，点击“我是买家”，选择金币/道具商品分类进行浏览，查看在售商品详情。</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\"><strong style=\"box-sizing: border-box;\">步骤二：</strong><span style=\"box-sizing: border-box; padding: 0px;\">选择想要购买的商品点击</span>“购买”。</p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\"><strong style=\"box-sizing: border-box;\">步骤三：</strong>在订单界面选择收货角色，确认商品及订单信息后进行支付。</p><p style=\"margin-top: 0px; margin-bottom: 0px; text-wrap-mode: wrap; box-sizing: border-box; padding: 0px; color: rgb(31, 22, 22); font-family: 微软雅黑; font-size: 14px; background-color: rgb(255, 255, 255); vertical-align: baseline;\"><strong style=\"box-sizing: border-box;\">步骤四：</strong>购买成功后，登录游戏收货角色，前往邮箱查收商品。</p><p><br/></p>'  WHERE  `id` = 12 [ RunTime:0.003142s ]
[2025-08-04T13:42:13+08:00][sql] CONNECT:[ UseTime:0.001517s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T13:42:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001338s ]
[2025-08-04T13:42:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000966s ]
[2025-08-04T13:42:13+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000559s ]
[2025-08-04T17:24:57+08:00][sql] CONNECT:[ UseTime:0.011226s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T17:24:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001298s ]
[2025-08-04T17:24:57+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000305s ]
[2025-08-04T17:24:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001301s ]
[2025-08-04T17:24:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000395s ]
[2025-08-04T17:24:57+08:00][sql] CONNECT:[ UseTime:0.011466s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T17:24:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001377s ]
[2025-08-04T17:24:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000933s ]
[2025-08-04T17:24:57+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000785s ]
[2025-08-04T17:25:01+08:00][sql] CONNECT:[ UseTime:0.016494s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T17:25:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001812s ]
[2025-08-04T17:25:01+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000382s ]
[2025-08-04T17:25:01+08:00][sql] CONNECT:[ UseTime:0.001793s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T17:25:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001907s ]
[2025-08-04T17:25:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.001146s ]
[2025-08-04T17:25:01+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000365s ]
[2025-08-04T17:25:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001712s ]
[2025-08-04T17:25:01+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (29,28,22,21,19,16,15,14,12,11)  AND `pay_status` IN (0,1) [ RunTime:0.000427s ]
[2025-08-04T17:25:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001363s ]
[2025-08-04T17:25:03+08:00][sql] CONNECT:[ UseTime:0.010993s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T17:25:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001304s ]
[2025-08-04T17:25:03+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000299s ]
[2025-08-04T17:25:03+08:00][sql] CONNECT:[ UseTime:0.011284s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T17:25:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001442s ]
[2025-08-04T17:25:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000820s ]
[2025-08-04T17:25:03+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000302s ]
[2025-08-04T17:25:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001210s ]
[2025-08-04T17:25:03+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (29,28,22,21,19,16,15,14,12,11)  AND `pay_status` IN (0,1) [ RunTime:0.000365s ]
[2025-08-04T17:25:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000990s ]
[2025-08-04T17:25:09+08:00][sql] CONNECT:[ UseTime:0.001426s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T17:25:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001353s ]
[2025-08-04T17:25:09+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000281s ]
[2025-08-04T17:25:09+08:00][sql] CONNECT:[ UseTime:0.001406s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T17:25:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001575s ]
[2025-08-04T17:25:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000858s ]
[2025-08-04T17:25:09+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000430s ]
[2025-08-04T17:25:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001188s ]
[2025-08-04T17:25:09+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (33,32,31,30,27,25,24,23,20,18)  AND `pay_status` IN (0,1) [ RunTime:0.000316s ]
[2025-08-04T17:25:09+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000958s ]
[2025-08-04T17:25:09+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (33,32,31,30,27,25,24,23,20,18) [ RunTime:0.000274s ]
[2025-08-04T18:16:00+08:00][sql] CONNECT:[ UseTime:0.001453s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T18:16:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001311s ]
[2025-08-04T18:16:00+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000291s ]
[2025-08-04T18:16:00+08:00][sql] CONNECT:[ UseTime:0.010571s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T18:16:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001521s ]
[2025-08-04T18:16:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000903s ]
[2025-08-04T18:16:00+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000352s ]
[2025-08-04T18:16:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001197s ]
[2025-08-04T18:16:00+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (33,32,31,30,27,25,24,23,20,18)  AND `pay_status` IN (0,1) [ RunTime:0.000310s ]
[2025-08-04T18:16:00+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000959s ]
[2025-08-04T18:16:00+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (33,32,31,30,27,25,24,23,20,18) [ RunTime:0.000276s ]
[2025-08-04T18:28:00+08:00][sql] CONNECT:[ UseTime:0.011355s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T18:28:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001279s ]
[2025-08-04T18:28:00+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000281s ]
[2025-08-04T18:28:00+08:00][sql] CONNECT:[ UseTime:0.011590s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T18:28:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001624s ]
[2025-08-04T18:28:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000926s ]
[2025-08-04T18:28:00+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000317s ]
[2025-08-04T18:28:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001099s ]
[2025-08-04T18:28:00+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (33,32,31,30,27,25,24,23,20,18)  AND `pay_status` IN (0,1) [ RunTime:0.000280s ]
[2025-08-04T18:28:00+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000926s ]
[2025-08-04T18:28:00+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (33,32,31,30,27,25,24,23,20,18) [ RunTime:0.000318s ]
[2025-08-04T18:28:02+08:00][sql] CONNECT:[ UseTime:0.011350s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T18:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001493s ]
[2025-08-04T18:28:02+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000289s ]
[2025-08-04T18:28:02+08:00][sql] CONNECT:[ UseTime:0.010404s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T18:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001438s ]
[2025-08-04T18:28:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000849s ]
[2025-08-04T18:28:02+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000374s ]
[2025-08-04T18:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001114s ]
[2025-08-04T18:28:02+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (33,32,31,30,27,25,24,23,20,18)  AND `pay_status` IN (0,1) [ RunTime:0.000285s ]
[2025-08-04T18:28:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000956s ]
[2025-08-04T18:28:02+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (33,32,31,30,27,25,24,23,20,18) [ RunTime:0.000269s ]
[2025-08-04T18:28:03+08:00][sql] CONNECT:[ UseTime:0.001477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T18:28:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001438s ]
[2025-08-04T18:28:03+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000335s ]
[2025-08-04T18:28:03+08:00][sql] CONNECT:[ UseTime:0.010905s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-04T18:28:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001465s ]
[2025-08-04T18:28:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000842s ]
[2025-08-04T18:28:03+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000293s ]
[2025-08-04T18:28:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001219s ]
[2025-08-04T18:28:03+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (33,32,31,30,27,25,24,23,20,18)  AND `pay_status` IN (0,1) [ RunTime:0.000325s ]
[2025-08-04T18:28:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000952s ]
[2025-08-04T18:28:03+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (33,32,31,30,27,25,24,23,20,18) [ RunTime:0.000266s ]