[2026-01-07T16:40:39+08:00][sql] CONNECT:[ UseTime:0.015568s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001317s ]
[2026-01-07T16:40:39+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000274s ]
[2026-01-07T16:40:39+08:00][sql] CONNECT:[ UseTime:0.015904s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001333s ]
[2026-01-07T16:40:39+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.000465s ]
[2026-01-07T16:40:39+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.000393s ]
[2026-01-07T16:40:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001064s ]
[2026-01-07T16:40:39+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000923s ]
[2026-01-07T16:40:40+08:00][sql] CONNECT:[ UseTime:0.007792s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001310s ]
[2026-01-07T16:40:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000267s ]
[2026-01-07T16:40:40+08:00][sql] CONNECT:[ UseTime:0.007044s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001363s ]
[2026-01-07T16:40:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000577s ]
[2026-01-07T16:40:40+08:00][sql] SELECT `tr`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_role` `tr` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tr`.`orderno` WHERE  `tr`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000374s ]
[2026-01-07T16:40:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001002s ]
[2026-01-07T16:40:40+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (152,151,150,149,148,147,143,139,138) [ RunTime:0.000294s ]
[2026-01-07T16:40:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001028s ]
[2026-01-07T16:40:41+08:00][sql] CONNECT:[ UseTime:0.007062s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001274s ]
[2026-01-07T16:40:41+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000278s ]
[2026-01-07T16:40:41+08:00][sql] CONNECT:[ UseTime:0.005992s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001470s ]
[2026-01-07T16:40:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000471s ]
[2026-01-07T16:40:41+08:00][sql] SELECT `tp`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000614s ]
[2026-01-07T16:40:41+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001088s ]
[2026-01-07T16:40:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001535s ]
[2026-01-07T16:40:42+08:00][sql] CONNECT:[ UseTime:0.004241s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001229s ]
[2026-01-07T16:40:42+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000249s ]
[2026-01-07T16:40:42+08:00][sql] CONNECT:[ UseTime:0.003887s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001220s ]
[2026-01-07T16:40:42+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.000395s ]
[2026-01-07T16:40:42+08:00][sql] SELECT `to`.`orderno`,`to`.`charge`,`to`.`price`,`to`.`amount`,`tw`.`id`,`tw`.`game`,`tw`.`serverid`,`tw`.`alitime`,`tw`.`withdrawtime`,`tw`.`username`,`tw`.`payuser`,`tw`.`aliname`,`tw`.`status`,`tw`.`ordertype`,`tw`.`relationid`,`tw`.`tid`,`to`.`paytime` FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` WHERE  `tw`.`game` IN ('shaiya','shaiya5') ORDER BY `tw`.`id` DESC LIMIT 0,10 [ RunTime:0.000377s ]
[2026-01-07T16:40:42+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.000306s ]
[2026-01-07T16:40:42+08:00][sql] SELECT `tw`.`status`,IFNULL(SUM(to.amount), 0) AS no_total_amount FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` WHERE  `tw`.`game` IN ('shaiya','shaiya5')  AND `tw`.`status` IN ('-1','3') GROUP BY `tw`.`status` [ RunTime:0.000375s ]
[2026-01-07T16:40:43+08:00][sql] CONNECT:[ UseTime:0.008956s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001223s ]
[2026-01-07T16:40:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000260s ]
[2026-01-07T16:40:43+08:00][sql] CONNECT:[ UseTime:0.005934s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001296s ]
[2026-01-07T16:40:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE  `game` IN ('shaiya','shaiya5')  AND `ordertype` = -1 LIMIT 1 [ RunTime:0.000372s ]
[2026-01-07T16:40:43+08:00][sql] SELECT * FROM `trade_stats` WHERE  `game` IN ('shaiya','shaiya5')  AND `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000376s ]
[2026-01-07T16:40:43+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.000384s ]
[2026-01-07T16:40:45+08:00][sql] CONNECT:[ UseTime:0.016308s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001221s ]
[2026-01-07T16:40:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000247s ]
[2026-01-07T16:40:45+08:00][sql] CONNECT:[ UseTime:0.004840s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001200s ]
[2026-01-07T16:40:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE  `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000336s ]
[2026-01-07T16:40:45+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000289s ]
[2026-01-07T16:40:55+08:00][sql] CONNECT:[ UseTime:0.012374s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001278s ]
[2026-01-07T16:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001154s ]
[2026-01-07T16:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001033s ]
[2026-01-07T16:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001011s ]
[2026-01-07T16:40:55+08:00][sql] SELECT * FROM `trade_role` WHERE  `id` = 85 LIMIT 1 [ RunTime:0.000285s ]
[2026-01-07T16:40:55+08:00][sql] SELECT `sync_status` FROM `trade` WHERE  `id` = 152 LIMIT 1 [ RunTime:0.000193s ]
[2026-01-07T16:40:55+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 152  AND `ordertype` = 1  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000326s ]
[2026-01-07T16:40:55+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 152 LIMIT 1 [ RunTime:0.000270s ]
[2026-01-07T16:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000871s ]
[2026-01-07T16:40:55+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000224s ]
[2026-01-07T16:41:02+08:00][sql] CONNECT:[ UseTime:0.001340s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-01-07T16:41:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001238s ]
[2026-01-07T16:41:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000261s ]
[2026-01-07T16:41:02+08:00][sql] SELECT * FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000234s ]