[2025-11-29T14:39:22+08:00][sql] CONNECT:[ UseTime:0.010705s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-29T14:39:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001308s ]
[2025-11-29T14:39:22+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000295s ]
[2025-11-29T14:39:22+08:00][sql] CONNECT:[ UseTime:0.010857s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-29T14:39:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001691s ]
[2025-11-29T14:39:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE  `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.017312s ]
[2025-11-29T14:39:22+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000483s ]
[2025-11-29T14:39:28+08:00][sql] CONNECT:[ UseTime:0.010862s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-29T14:39:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001308s ]
[2025-11-29T14:39:28+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000299s ]
[2025-11-29T14:39:28+08:00][sql] CONNECT:[ UseTime:0.010832s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-29T14:39:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001426s ]
[2025-11-29T14:39:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000505s ]
[2025-11-29T14:39:28+08:00][sql] SELECT `tg`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_gold` `tg` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tg`.`orderno` WHERE  `tg`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000399s ]
[2025-11-29T14:39:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001165s ]
[2025-11-29T14:39:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001030s ]
[2025-11-29T14:39:30+08:00][sql] CONNECT:[ UseTime:0.010909s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-29T14:39:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001512s ]
[2025-11-29T14:39:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001192s ]
[2025-11-29T14:39:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001137s ]
[2025-11-29T14:39:30+08:00][sql] SELECT * FROM `trade_gold` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000267s ]
[2025-11-29T14:39:30+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 108  AND `ordertype` = 0  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000358s ]
[2025-11-29T14:39:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001076s ]
[2025-11-29T14:39:30+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 108 LIMIT 1 [ RunTime:0.000327s ]
[2025-11-29T14:39:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000908s ]
[2025-11-29T14:39:30+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000241s ]
[2025-11-29T14:39:47+08:00][sql] CONNECT:[ UseTime:0.001411s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-29T14:39:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001635s ]
[2025-11-29T14:39:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001270s ]
[2025-11-29T14:39:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001165s ]
[2025-11-29T14:39:47+08:00][sql] SELECT * FROM `trade_gold` WHERE  `id` = 34 LIMIT 1 [ RunTime:0.000272s ]
[2025-11-29T14:39:47+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 103  AND `ordertype` = 0  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000412s ]
[2025-11-29T14:39:47+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001025s ]
[2025-11-29T14:39:47+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 103 LIMIT 1 [ RunTime:0.000382s ]
[2025-11-29T14:39:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001018s ]
[2025-11-29T14:39:47+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000294s ]
[2025-11-29T14:39:59+08:00][sql] CONNECT:[ UseTime:0.010909s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-29T14:39:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001499s ]
[2025-11-29T14:39:59+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000342s ]
[2025-11-29T14:39:59+08:00][sql] CONNECT:[ UseTime:0.010772s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-29T14:39:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001195s ]
[2025-11-29T14:39:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE  `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000348s ]
[2025-11-29T14:39:59+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000305s ]
[2025-11-29T14:40:00+08:00][sql] CONNECT:[ UseTime:0.001487s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-29T14:40:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001418s ]
[2025-11-29T14:40:00+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000279s ]
[2025-11-29T14:40:00+08:00][sql] CONNECT:[ UseTime:0.011213s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-11-29T14:40:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001357s ]
[2025-11-29T14:40:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE  `game` IN ('shaiya','shaiya5')  AND `ordertype` = -1 LIMIT 1 [ RunTime:0.000383s ]
[2025-11-29T14:40:00+08:00][sql] SELECT * FROM `trade_stats` WHERE  `game` IN ('shaiya','shaiya5')  AND `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000389s ]
[2025-11-29T14:40:00+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  `game` IN ('shaiya','shaiya5')  AND `ordertype` = -1 LIMIT 1 [ RunTime:0.000370s ]