[2025-08-25T17:27:05+08:00][sql] CONNECT:[ UseTime:0.011049s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001345s ] [2025-08-25T17:27:05+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000260s ] [2025-08-25T17:27:05+08:00][sql] CONNECT:[ UseTime:0.001499s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001584s ] [2025-08-25T17:27:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000350s ] [2025-08-25T17:27:05+08:00][sql] SELECT * FROM `trade_role` WHERE `game` = 'shaiya' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000355s ] [2025-08-25T17:27:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001212s ] [2025-08-25T17:27:05+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (79,78,39,32,25,24,23,20,18,17) AND `pay_status` IN (0,1) [ RunTime:0.000366s ] [2025-08-25T17:27:05+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001002s ] [2025-08-25T17:27:05+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (79,78,39,32,25,24,23,20,18,17) [ RunTime:0.000279s ] [2025-08-25T17:27:07+08:00][sql] CONNECT:[ UseTime:0.012434s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001247s ] [2025-08-25T17:27:07+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000297s ] [2025-08-25T17:27:07+08:00][sql] CONNECT:[ UseTime:0.001502s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001552s ] [2025-08-25T17:27:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000272s ] [2025-08-25T17:27:12+08:00][sql] CONNECT:[ UseTime:0.011136s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001624s ] [2025-08-25T17:27:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000289s ] [2025-08-25T17:27:13+08:00][sql] CONNECT:[ UseTime:0.011034s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001452s ] [2025-08-25T17:27:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000292s ] [2025-08-25T17:27:14+08:00][sql] CONNECT:[ UseTime:0.011057s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001537s ] [2025-08-25T17:27:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000312s ] [2025-08-25T17:27:40+08:00][sql] CONNECT:[ UseTime:0.011560s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001262s ] [2025-08-25T17:27:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000253s ] [2025-08-25T17:27:40+08:00][sql] CONNECT:[ UseTime:0.011155s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001531s ] [2025-08-25T17:27:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` WHERE `tw`.`game` = 'shaiya' LIMIT 1 [ RunTime:0.000342s ] [2025-08-25T17:27:40+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` WHERE `tw`.`game` = 'shaiya' [ RunTime:0.000731s ] [2025-08-25T17:27:41+08:00][sql] CONNECT:[ UseTime:0.001533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001445s ] [2025-08-25T17:27:41+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000253s ] [2025-08-25T17:27:41+08:00][sql] CONNECT:[ UseTime:0.010819s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001312s ] [2025-08-25T17:27:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE `game` = 'shaiya' AND `ordertype` = -1 LIMIT 1 [ RunTime:0.000339s ] [2025-08-25T17:27:41+08:00][sql] SELECT * FROM `trade_stats` WHERE `game` = 'shaiya' AND `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000316s ] [2025-08-25T17:27:41+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` = 'shaiya' AND `ordertype` = -1 LIMIT 1 [ RunTime:0.000385s ] [2025-08-25T17:27:43+08:00][sql] CONNECT:[ UseTime:0.010367s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001408s ] [2025-08-25T17:27:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000256s ] [2025-08-25T17:27:43+08:00][sql] CONNECT:[ UseTime:0.001415s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:27:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001379s ] [2025-08-25T17:27:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000364s ] [2025-08-25T17:27:43+08:00][sql] SELECT * FROM `trade_gold` WHERE `game` = 'shaiya' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000344s ] [2025-08-25T17:27:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001242s ] [2025-08-25T17:27:43+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (61,22,21,19,16,15,14,12,11,9) AND `pay_status` IN (0,1) [ RunTime:0.000313s ] [2025-08-25T17:27:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001023s ] [2025-08-25T17:28:05+08:00][sql] CONNECT:[ UseTime:0.010961s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:28:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001553s ] [2025-08-25T17:28:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000281s ] [2025-08-25T17:28:17+08:00][sql] CONNECT:[ UseTime:0.010878s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:28:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001390s ] [2025-08-25T17:28:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000266s ] [2025-08-25T17:28:17+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000216s ] [2025-08-25T17:28:19+08:00][sql] CONNECT:[ UseTime:0.011576s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001328s ] [2025-08-25T17:28:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000255s ] [2025-08-25T17:28:19+08:00][sql] CONNECT:[ UseTime:0.010838s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001458s ] [2025-08-25T17:28:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000340s ] [2025-08-25T17:28:19+08:00][sql] CONNECT:[ UseTime:0.001511s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001384s ] [2025-08-25T17:28:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000284s ] [2025-08-25T17:28:19+08:00][sql] CONNECT:[ UseTime:0.010996s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001403s ] [2025-08-25T17:28:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000277s ] [2025-08-25T17:28:19+08:00][sql] SELECT * FROM `trade_gold` WHERE `game` = 'shaiya' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000306s ] [2025-08-25T17:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001160s ] [2025-08-25T17:28:19+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (61,22,21,19,16,15,14,12,11,9) AND `pay_status` IN (0,1) [ RunTime:0.000297s ] [2025-08-25T17:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001003s ] [2025-08-25T17:28:23+08:00][sql] CONNECT:[ UseTime:0.011023s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:28:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001531s ] [2025-08-25T17:28:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000295s ] [2025-08-25T17:28:23+08:00][sql] SELECT * FROM `trade_gold` WHERE `game` = 'shaiya' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000328s ] [2025-08-25T17:28:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001121s ] [2025-08-25T17:28:23+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (61,22,21,19,16,15,14,12,11,9) AND `pay_status` IN (0,1) [ RunTime:0.000365s ] [2025-08-25T17:28:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000953s ] [2025-08-25T17:28:30+08:00][sql] CONNECT:[ UseTime:0.010932s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:28:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001298s ] [2025-08-25T17:28:30+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000261s ] [2025-08-25T17:28:30+08:00][sql] CONNECT:[ UseTime:0.010933s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:28:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001414s ] [2025-08-25T17:28:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000293s ] [2025-08-25T17:28:30+08:00][sql] SELECT * FROM `trade_role` WHERE `game` = 'shaiya' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000372s ] [2025-08-25T17:28:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001129s ] [2025-08-25T17:28:30+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (79,78,39,32,25,24,23,20,18,17) AND `pay_status` IN (0,1) [ RunTime:0.000321s ] [2025-08-25T17:28:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000937s ] [2025-08-25T17:28:30+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (79,78,39,32,25,24,23,20,18,17) [ RunTime:0.000337s ] [2025-08-25T17:29:51+08:00][sql] CONNECT:[ UseTime:0.001492s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:29:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001326s ] [2025-08-25T17:29:51+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000263s ] [2025-08-25T17:29:51+08:00][sql] CONNECT:[ UseTime:0.010332s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:29:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001424s ] [2025-08-25T17:29:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000289s ] [2025-08-25T17:29:59+08:00][sql] CONNECT:[ UseTime:0.001523s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:29:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001330s ] [2025-08-25T17:29:59+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000325s ] [2025-08-25T17:30:00+08:00][sql] CONNECT:[ UseTime:0.011128s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:30:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001448s ] [2025-08-25T17:30:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000290s ] [2025-08-25T17:32:50+08:00][sql] CONNECT:[ UseTime:0.011163s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:32:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001344s ] [2025-08-25T17:32:50+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000249s ] [2025-08-25T17:32:50+08:00][sql] CONNECT:[ UseTime:0.001394s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:32:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001377s ] [2025-08-25T17:32:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000299s ] [2025-08-25T17:47:52+08:00][sql] CONNECT:[ UseTime:0.001436s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:47:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001322s ] [2025-08-25T17:47:52+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000270s ] [2025-08-25T17:47:52+08:00][sql] CONNECT:[ UseTime:0.010912s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:47:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001465s ] [2025-08-25T17:47:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000292s ] [2025-08-25T17:52:17+08:00][sql] CONNECT:[ UseTime:0.010983s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:52:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001325s ] [2025-08-25T17:52:17+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000267s ] [2025-08-25T17:52:17+08:00][sql] CONNECT:[ UseTime:0.010534s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:52:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001470s ] [2025-08-25T17:52:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000327s ] [2025-08-25T17:52:21+08:00][sql] CONNECT:[ UseTime:0.011489s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:52:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001573s ] [2025-08-25T17:52:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000287s ] [2025-08-25T17:56:21+08:00][sql] CONNECT:[ UseTime:0.001485s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:56:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001371s ] [2025-08-25T17:56:21+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000257s ] [2025-08-25T17:56:22+08:00][sql] CONNECT:[ UseTime:0.010738s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:56:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001440s ] [2025-08-25T17:56:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.010367s ] [2025-08-25T17:56:22+08:00][sql] SELECT * FROM `trade_items` WHERE `game` = 'shaiya' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.026215s ] [2025-08-25T17:56:26+08:00][sql] CONNECT:[ UseTime:0.011188s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:56:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001318s ] [2025-08-25T17:56:26+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000271s ] [2025-08-25T17:56:26+08:00][sql] CONNECT:[ UseTime:0.001339s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:56:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001451s ] [2025-08-25T17:56:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.010221s ] [2025-08-25T17:56:26+08:00][sql] SELECT * FROM `trade_items` WHERE `game` = 'shaiya' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.024062s ] [2025-08-25T17:56:35+08:00][sql] CONNECT:[ UseTime:0.001534s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:56:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001454s ] [2025-08-25T17:56:35+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000352s ] [2025-08-25T17:56:35+08:00][sql] CONNECT:[ UseTime:0.001384s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:56:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001447s ] [2025-08-25T17:56:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.015971s ] [2025-08-25T17:56:35+08:00][sql] SELECT * FROM `trade_items` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000446s ] [2025-08-25T17:57:00+08:00][sql] CONNECT:[ UseTime:0.010511s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001463s ] [2025-08-25T17:57:00+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000259s ] [2025-08-25T17:57:00+08:00][sql] CONNECT:[ UseTime:0.001411s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001348s ] [2025-08-25T17:57:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000316s ] [2025-08-25T17:57:00+08:00][sql] SELECT * FROM `trade_gold` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000310s ] [2025-08-25T17:57:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001111s ] [2025-08-25T17:57:00+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (68,65,64,63,61,60,55,50,48,41) AND `pay_status` IN (0,1) [ RunTime:0.000319s ] [2025-08-25T17:57:00+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000967s ] [2025-08-25T17:57:03+08:00][sql] CONNECT:[ UseTime:0.010650s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001315s ] [2025-08-25T17:57:03+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000258s ] [2025-08-25T17:57:03+08:00][sql] CONNECT:[ UseTime:0.010941s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001476s ] [2025-08-25T17:57:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000400s ] [2025-08-25T17:57:03+08:00][sql] SELECT * FROM `trade_role` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000370s ] [2025-08-25T17:57:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001192s ] [2025-08-25T17:57:03+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (80,79,78,76,75,74,73,72,71,70) AND `pay_status` IN (0,1) [ RunTime:0.000392s ] [2025-08-25T17:57:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001022s ] [2025-08-25T17:57:03+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (80,79,78,76,75,74,73,72,71,70) [ RunTime:0.000395s ] [2025-08-25T17:57:05+08:00][sql] CONNECT:[ UseTime:0.001549s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001491s ] [2025-08-25T17:57:05+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000255s ] [2025-08-25T17:57:05+08:00][sql] CONNECT:[ UseTime:0.011034s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001499s ] [2025-08-25T17:57:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000301s ] [2025-08-25T17:57:05+08:00][sql] SELECT * FROM `trade_prop` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000264s ] [2025-08-25T17:57:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001275s ] [2025-08-25T17:57:05+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (83,82,81) AND `pay_status` IN (0,1) [ RunTime:0.000289s ] [2025-08-25T17:57:05+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001052s ] [2025-08-25T17:57:19+08:00][sql] CONNECT:[ UseTime:0.010861s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001353s ] [2025-08-25T17:57:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000262s ] [2025-08-25T17:57:19+08:00][sql] CONNECT:[ UseTime:0.010344s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001484s ] [2025-08-25T17:57:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000348s ] [2025-08-25T17:57:30+08:00][sql] CONNECT:[ UseTime:0.010791s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001386s ] [2025-08-25T17:57:30+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` = 'shaiya' [ RunTime:0.000253s ] [2025-08-25T17:57:30+08:00][sql] CONNECT:[ UseTime:0.011293s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001439s ] [2025-08-25T17:57:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000291s ] [2025-08-25T17:57:30+08:00][sql] SELECT * FROM `trade_role` WHERE `game` = 'shaiya' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000362s ] [2025-08-25T17:57:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001105s ] [2025-08-25T17:57:30+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (79,78,39,32,25,24,23,20,18,17) AND `pay_status` IN (0,1) [ RunTime:0.000341s ] [2025-08-25T17:57:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000933s ] [2025-08-25T17:57:30+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (79,78,39,32,25,24,23,20,18,17) [ RunTime:0.000287s ] [2025-08-25T17:57:40+08:00][sql] CONNECT:[ UseTime:0.001451s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001402s ] [2025-08-25T17:57:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000257s ] [2025-08-25T17:57:40+08:00][sql] CONNECT:[ UseTime:0.010407s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001455s ] [2025-08-25T17:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.015822s ] [2025-08-25T17:57:40+08:00][sql] SELECT * FROM `trade_items` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000395s ] [2025-08-25T17:57:41+08:00][sql] CONNECT:[ UseTime:0.001482s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001433s ] [2025-08-25T17:57:41+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000257s ] [2025-08-25T17:57:41+08:00][sql] CONNECT:[ UseTime:0.010311s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001363s ] [2025-08-25T17:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000303s ] [2025-08-25T17:57:41+08:00][sql] SELECT * FROM `trade_gold` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000292s ] [2025-08-25T17:57:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001127s ] [2025-08-25T17:57:41+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (68,65,64,63,61,60,55,50,48,41) AND `pay_status` IN (0,1) [ RunTime:0.000319s ] [2025-08-25T17:57:41+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000926s ] [2025-08-25T17:57:55+08:00][sql] CONNECT:[ UseTime:0.001533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001464s ] [2025-08-25T17:57:55+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000250s ] [2025-08-25T17:57:55+08:00][sql] CONNECT:[ UseTime:0.010814s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001418s ] [2025-08-25T17:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000334s ] [2025-08-25T17:57:55+08:00][sql] SELECT * FROM `trade_role` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000361s ] [2025-08-25T17:57:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001177s ] [2025-08-25T17:57:55+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (80,79,78,76,75,74,73,72,71,70) AND `pay_status` IN (0,1) [ RunTime:0.000334s ] [2025-08-25T17:57:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000989s ] [2025-08-25T17:57:55+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (80,79,78,76,75,74,73,72,71,70) [ RunTime:0.000294s ] [2025-08-25T17:57:55+08:00][sql] CONNECT:[ UseTime:0.011433s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001343s ] [2025-08-25T17:57:55+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000265s ] [2025-08-25T17:57:55+08:00][sql] CONNECT:[ UseTime:0.010920s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:57:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001467s ] [2025-08-25T17:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000294s ] [2025-08-25T17:57:55+08:00][sql] SELECT * FROM `trade_prop` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000276s ] [2025-08-25T17:57:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001243s ] [2025-08-25T17:57:55+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (83,82,81) AND `pay_status` IN (0,1) [ RunTime:0.000340s ] [2025-08-25T17:57:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001046s ] [2025-08-25T17:58:09+08:00][sql] CONNECT:[ UseTime:0.001506s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:58:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001455s ] [2025-08-25T17:58:09+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000253s ] [2025-08-25T17:58:09+08:00][sql] CONNECT:[ UseTime:0.011450s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:58:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001312s ] [2025-08-25T17:58:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` WHERE `tw`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000320s ] [2025-08-25T17:58:09+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` WHERE `tw`.`game` IN ('shaiya','shaiya5') [ RunTime:0.000286s ] [2025-08-25T17:58:11+08:00][sql] CONNECT:[ UseTime:0.001452s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:58:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001330s ] [2025-08-25T17:58:11+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000301s ] [2025-08-25T17:58:11+08:00][sql] CONNECT:[ UseTime:0.011322s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:58:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001325s ] [2025-08-25T17:58:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000335s ] [2025-08-25T17:58:11+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000278s ] [2025-08-25T17:58:12+08:00][sql] CONNECT:[ UseTime:0.011647s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:58:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001372s ] [2025-08-25T17:58:12+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000261s ] [2025-08-25T17:58:12+08:00][sql] CONNECT:[ UseTime:0.010999s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:58:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001319s ] [2025-08-25T17:58:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE `game` IN ('shaiya','shaiya5') AND `ordertype` = -1 LIMIT 1 [ RunTime:0.000537s ] [2025-08-25T17:58:12+08:00][sql] SELECT * FROM `trade_stats` WHERE `game` IN ('shaiya','shaiya5') AND `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000342s ] [2025-08-25T17:58:12+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.000353s ] [2025-08-25T17:59:52+08:00][sql] CONNECT:[ UseTime:0.010965s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-25T17:59:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001441s ] [2025-08-25T17:59:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000308s ] [2025-08-25T17:59:52+08:00][sql] SELECT * FROM `trade_gold` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000318s ] [2025-08-25T17:59:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001048s ] [2025-08-25T17:59:52+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (68,65,64,63,61,60,55,50,48,41) AND `pay_status` IN (0,1) [ RunTime:0.000296s ] [2025-08-25T17:59:52+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000904s ]