[2026-01-09T09:35:37+08:00][sql] CONNECT:[ UseTime:0.011488s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T09:35:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001409s ] [2026-01-09T09:35:37+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000276s ] [2026-01-09T09:35:38+08:00][sql] CONNECT:[ UseTime:0.010844s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T09:35:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001328s ] [2026-01-09T09:35:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000381s ] [2026-01-09T09:35:38+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000321s ] [2026-01-09T09:35:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001043s ] [2026-01-09T09:35:38+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000236s ] [2026-01-09T13:41:17+08:00][sql] CONNECT:[ UseTime:0.001466s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T13:41:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001330s ] [2026-01-09T13:41:17+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000277s ] [2026-01-09T13:41:17+08:00][sql] CONNECT:[ UseTime:0.010530s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T13:41:17+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001352s ] [2026-01-09T13:41:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000368s ] [2026-01-09T13:41:17+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000290s ] [2026-01-09T13:41:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001027s ] [2026-01-09T13:41:17+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000233s ] [2026-01-09T16:46:21+08:00][sql] CONNECT:[ UseTime:0.011596s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001420s ] [2026-01-09T16:46:21+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000264s ] [2026-01-09T16:46:21+08:00][sql] CONNECT:[ UseTime:0.001409s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001534s ] [2026-01-09T16:46:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.015825s ] [2026-01-09T16:46:21+08:00][sql] SELECT * FROM `trade_items` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000427s ] [2026-01-09T16:46:22+08:00][sql] CONNECT:[ UseTime:0.011404s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:46:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001293s ] [2026-01-09T16:46:22+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000263s ] [2026-01-09T16:46:22+08:00][sql] CONNECT:[ UseTime:0.010729s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:46:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001255s ] [2026-01-09T16:46:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000400s ] [2026-01-09T16:46:22+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000321s ] [2026-01-09T16:46:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001099s ] [2026-01-09T16:46:22+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000231s ] [2026-01-09T16:46:25+08:00][sql] CONNECT:[ UseTime:0.001437s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:46:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001336s ] [2026-01-09T16:46:25+08:00][sql] SELECT * FROM `trade` WHERE `id` = 156 LIMIT 1 [ RunTime:0.000358s ] [2026-01-09T16:47:42+08:00][sql] CONNECT:[ UseTime:0.011008s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:47:42+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001316s ] [2026-01-09T16:47:42+08:00][sql] SELECT * FROM `trade` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000317s ] [2026-01-09T16:47:44+08:00][sql] CONNECT:[ UseTime:0.001728s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:47:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001328s ] [2026-01-09T16:47:44+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000442s ] [2026-01-09T16:47:44+08:00][sql] CONNECT:[ UseTime:0.012390s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:47:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001947s ] [2026-01-09T16:47:44+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.000820s ] [2026-01-09T16:47:44+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.000513s ] [2026-01-09T16:47:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001633s ] [2026-01-09T16:47:44+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (156,155,154,152,151,150,149,148,147) [ RunTime:0.000486s ] [2026-01-09T16:47:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001429s ] [2026-01-09T16:47:53+08:00][sql] CONNECT:[ UseTime:0.010957s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:47:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001370s ] [2026-01-09T16:47:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001258s ] [2026-01-09T16:47:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001151s ] [2026-01-09T16:47:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001119s ] [2026-01-09T16:47:53+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 88 LIMIT 1 [ RunTime:0.000294s ] [2026-01-09T16:47:53+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 156 LIMIT 1 [ RunTime:0.000212s ] [2026-01-09T16:47:53+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 156 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000348s ] [2026-01-09T16:47:53+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 156 LIMIT 1 [ RunTime:0.000330s ] [2026-01-09T16:47:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000997s ] [2026-01-09T16:47:53+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000219s ] [2026-01-09T16:48:10+08:00][sql] CONNECT:[ UseTime:0.011347s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:48:10+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001476s ] [2026-01-09T16:48:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001337s ] [2026-01-09T16:48:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001181s ] [2026-01-09T16:48:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001164s ] [2026-01-09T16:48:10+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 86 LIMIT 1 [ RunTime:0.000380s ] [2026-01-09T16:48:10+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 154 LIMIT 1 [ RunTime:0.000274s ] [2026-01-09T16:48:10+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 154 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000401s ] [2026-01-09T16:48:10+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 154 LIMIT 1 [ RunTime:0.000329s ] [2026-01-09T16:48:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001036s ] [2026-01-09T16:48:10+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000227s ] [2026-01-09T16:48:23+08:00][sql] CONNECT:[ UseTime:0.011356s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:48:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001318s ] [2026-01-09T16:48:23+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000278s ] [2026-01-09T16:48:23+08:00][sql] CONNECT:[ UseTime:0.011561s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:48:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001312s ] [2026-01-09T16:48:23+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.000366s ] [2026-01-09T16:48:23+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.000383s ] [2026-01-09T16:48:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001076s ] [2026-01-09T16:48:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001159s ] [2026-01-09T16:48:24+08:00][sql] CONNECT:[ UseTime:0.011532s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:48:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001455s ] [2026-01-09T16:48:24+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000265s ] [2026-01-09T16:48:24+08:00][sql] CONNECT:[ UseTime:0.010857s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:48:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001432s ] [2026-01-09T16:48:24+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.000490s ] [2026-01-09T16:48:24+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.000447s ] [2026-01-09T16:48:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001236s ] [2026-01-09T16:48:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001159s ] [2026-01-09T16:48:25+08:00][sql] CONNECT:[ UseTime:0.011438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:48:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001460s ] [2026-01-09T16:48:25+08:00][sql] SELECT * FROM `trade` WHERE `id` = 156 LIMIT 1 [ RunTime:0.000285s ]