[2026-01-08T10:11:11+08:00][sql] CONNECT:[ UseTime:0.011393s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:11:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001363s ] [2026-01-08T10:11:11+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000336s ] [2026-01-08T10:11:11+08:00][sql] CONNECT:[ UseTime:0.001432s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:11:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001402s ] [2026-01-08T10:11:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000339s ] [2026-01-08T10:11:11+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000313s ] [2026-01-08T10:11:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001129s ] [2026-01-08T10:11:11+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000241s ] [2026-01-08T10:11:14+08:00][sql] CONNECT:[ UseTime:0.011414s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:11:14+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001284s ] [2026-01-08T10:11:14+08:00][sql] SELECT * FROM `trade` WHERE `id` = 152 LIMIT 1 [ RunTime:0.000295s ] [2026-01-08T10:11:25+08:00][sql] CONNECT:[ UseTime:0.010437s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:11:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001321s ] [2026-01-08T10:11:25+08:00][sql] SELECT * FROM `trade` WHERE `id` = 147 LIMIT 1 [ RunTime:0.000281s ] [2026-01-08T10:11:30+08:00][sql] CONNECT:[ UseTime:0.001410s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:11:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001285s ] [2026-01-08T10:11:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000361s ] [2026-01-08T10:11:30+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000325s ] [2026-01-08T10:11:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001013s ] [2026-01-08T10:11:30+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000250s ] [2026-01-08T10:11:31+08:00][sql] CONNECT:[ UseTime:0.010974s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:11:31+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001304s ] [2026-01-08T10:11:31+08:00][sql] SELECT * FROM `trade` WHERE `id` = 130 LIMIT 1 [ RunTime:0.000316s ] [2026-01-08T10:19:40+08:00][sql] CONNECT:[ UseTime:0.011289s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:19:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001311s ] [2026-01-08T10:19:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000278s ] [2026-01-08T10:19:40+08:00][sql] CONNECT:[ UseTime:0.011392s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:19:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001228s ] [2026-01-08T10:19:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000395s ] [2026-01-08T10:19:40+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000332s ] [2026-01-08T10:19:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001149s ] [2026-01-08T10:19:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000216s ] [2026-01-08T10:19:45+08:00][sql] CONNECT:[ UseTime:0.001443s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:19:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001241s ] [2026-01-08T10:19:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000367s ] [2026-01-08T10:19:45+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000355s ] [2026-01-08T10:19:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001006s ] [2026-01-08T10:19:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000239s ] [2026-01-08T10:19:54+08:00][sql] CONNECT:[ UseTime:0.001515s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:19:54+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001407s ] [2026-01-08T10:19:54+08:00][sql] SELECT * FROM `trade` WHERE `id` = 137 LIMIT 1 [ RunTime:0.000275s ] [2026-01-08T10:20:09+08:00][sql] CONNECT:[ UseTime:0.010412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:20:09+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001432s ] [2026-01-08T10:20:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') AND `type` = 2 LIMIT 1 [ RunTime:0.000608s ] [2026-01-08T10:20:09+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') AND `type` = 2 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000439s ] [2026-01-08T10:20:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001064s ] [2026-01-08T10:20:09+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000236s ] [2026-01-08T10:20:10+08:00][sql] CONNECT:[ UseTime:0.010868s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:20:10+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001281s ] [2026-01-08T10:20:10+08:00][sql] SELECT * FROM `trade` WHERE `id` = 114 LIMIT 1 [ RunTime:0.000290s ] [2026-01-08T10:20:21+08:00][sql] CONNECT:[ UseTime:0.001428s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:20:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001407s ] [2026-01-08T10:20:21+08:00][sql] SELECT * FROM `trade` WHERE `id` = 114 LIMIT 1 [ RunTime:0.000358s ] [2026-01-08T10:20:33+08:00][sql] CONNECT:[ UseTime:0.011385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:20:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001298s ] [2026-01-08T10:20:33+08:00][sql] SELECT * FROM `trade` WHERE `id` = 111 LIMIT 1 [ RunTime:0.000284s ] [2026-01-08T10:20:37+08:00][sql] CONNECT:[ UseTime:0.011411s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:20:37+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001328s ] [2026-01-08T10:20:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') AND `type` = 1 LIMIT 1 [ RunTime:0.000603s ] [2026-01-08T10:20:37+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') AND `type` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000333s ] [2026-01-08T10:20:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001028s ] [2026-01-08T10:20:37+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000241s ] [2026-01-08T10:20:38+08:00][sql] CONNECT:[ UseTime:0.011092s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:20:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001401s ] [2026-01-08T10:20:38+08:00][sql] SELECT * FROM `trade` WHERE `id` = 151 LIMIT 1 [ RunTime:0.000282s ] [2026-01-08T10:21:41+08:00][sql] CONNECT:[ UseTime:0.011164s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:21:41+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001288s ] [2026-01-08T10:21:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `type` = 1 LIMIT 1 [ RunTime:0.000444s ] [2026-01-08T10:21:41+08:00][sql] SELECT * FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `type` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000345s ] [2026-01-08T10:21:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000994s ] [2026-01-08T10:21:41+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000228s ] [2026-01-08T10:21:43+08:00][sql] CONNECT:[ UseTime:0.001528s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:21:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001424s ] [2026-01-08T10:21:43+08:00][sql] SELECT * FROM `trade` WHERE `id` = 152 LIMIT 1 [ RunTime:0.000354s ] [2026-01-08T10:25:29+08:00][sql] CONNECT:[ UseTime:0.001427s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:25:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001311s ] [2026-01-08T10:25:29+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000307s ] [2026-01-08T10:25:29+08:00][sql] CONNECT:[ UseTime:0.010933s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:25:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001481s ] [2026-01-08T10:25:29+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.000616s ] [2026-01-08T10:25:29+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.000426s ] [2026-01-08T10:25:29+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001073s ] [2026-01-08T10:25:29+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (152,151,150,149,148,147,143,139,138) [ RunTime:0.000345s ] [2026-01-08T10:25:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001111s ] [2026-01-08T10:25:34+08:00][sql] CONNECT:[ UseTime:0.001528s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:25:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001451s ] [2026-01-08T10:25:34+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` = 'shaiya' AND `tr`.`serverid` = '6' LIMIT 1 [ RunTime:0.000437s ] [2026-01-08T10:25:34+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` = 'shaiya' AND `tr`.`serverid` = '6' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000458s ] [2026-01-08T10:25:34+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001009s ] [2026-01-08T10:25:34+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (149,148,138,137,136,135,134,109,102) [ RunTime:0.000321s ] [2026-01-08T10:25:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001060s ] [2026-01-08T10:25:52+08:00][sql] CONNECT:[ UseTime:0.011486s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001269s ] [2026-01-08T10:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001254s ] [2026-01-08T10:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001026s ] [2026-01-08T10:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001005s ] [2026-01-08T10:25:52+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 82 LIMIT 1 [ RunTime:0.000365s ] [2026-01-08T10:25:52+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 149 LIMIT 1 [ RunTime:0.000213s ] [2026-01-08T10:25:52+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 149 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000314s ] [2026-01-08T10:25:52+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 149 LIMIT 1 [ RunTime:0.000359s ] [2026-01-08T10:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001006s ] [2026-01-08T10:25:52+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000224s ] [2026-01-08T10:26:06+08:00][sql] CONNECT:[ UseTime:0.001458s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:26:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001503s ] [2026-01-08T10:26:06+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` = 'shaiya' AND `tr`.`serverid` = '1' LIMIT 1 [ RunTime:0.000372s ] [2026-01-08T10:26:06+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` = 'shaiya' AND `tr`.`serverid` = '1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000360s ] [2026-01-08T10:26:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001027s ] [2026-01-08T10:26:06+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (93,92,39,32) [ RunTime:0.000274s ] [2026-01-08T10:26:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001054s ] [2026-01-08T10:35:32+08:00][sql] CONNECT:[ UseTime:0.001524s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:35:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001344s ] [2026-01-08T10:35:32+08:00][sql] SELECT * FROM `trade` WHERE `id` = 152 LIMIT 1 [ RunTime:0.000291s ] [2026-01-08T10:35:37+08:00][sql] CONNECT:[ UseTime:0.001412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:35:37+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001294s ] [2026-01-08T10:35:37+08:00][sql] SELECT * FROM `trade` WHERE `id` = 130 LIMIT 1 [ RunTime:0.000298s ] [2026-01-08T10:35:41+08:00][sql] CONNECT:[ UseTime:0.001462s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:35:41+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001388s ] [2026-01-08T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `type` = 1 LIMIT 1 [ RunTime:0.000468s ] [2026-01-08T10:35:41+08:00][sql] SELECT * FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `type` = 1 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000418s ] [2026-01-08T10:35:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001072s ] [2026-01-08T10:35:41+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000294s ] [2026-01-08T10:35:43+08:00][sql] CONNECT:[ UseTime:0.010968s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:35:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001360s ] [2026-01-08T10:35:43+08:00][sql] SELECT * FROM `trade` WHERE `id` = 107 LIMIT 1 [ RunTime:0.000275s ] [2026-01-08T10:36:34+08:00][sql] CONNECT:[ UseTime:0.010858s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:36:34+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001312s ] [2026-01-08T10:36:34+08:00][sql] SELECT * FROM `trade` WHERE `id` = 118 LIMIT 1 [ RunTime:0.000300s ] [2026-01-08T10:44:03+08:00][sql] CONNECT:[ UseTime:0.011902s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:44:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001413s ] [2026-01-08T10:44:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `type` = 1 LIMIT 1 [ RunTime:0.000440s ] [2026-01-08T10:44:03+08:00][sql] SELECT * FROM `trade` WHERE `game` = 'shaiya5' AND `type` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000494s ] [2026-01-08T10:44:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001097s ] [2026-01-08T10:44:03+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000246s ] [2026-01-08T10:44:08+08:00][sql] CONNECT:[ UseTime:0.010536s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:44:08+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001383s ] [2026-01-08T10:44:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') AND `type` = 1 LIMIT 1 [ RunTime:0.000612s ] [2026-01-08T10:44:08+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') AND `type` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000321s ] [2026-01-08T10:44:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001067s ] [2026-01-08T10:44:08+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000251s ] [2026-01-08T10:44:12+08:00][sql] CONNECT:[ UseTime:0.001466s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T10:44:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001327s ] [2026-01-08T10:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000445s ] [2026-01-08T10:44:12+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000327s ] [2026-01-08T10:44:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001044s ] [2026-01-08T10:44:12+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000236s ] [2026-01-08T11:32:43+08:00][sql] CONNECT:[ UseTime:0.001428s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001283s ] [2026-01-08T11:32:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000403s ] [2026-01-08T11:32:43+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000306s ] [2026-01-08T11:32:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001137s ] [2026-01-08T11:32:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000245s ] [2026-01-08T11:32:43+08:00][sql] CONNECT:[ UseTime:0.001457s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001298s ] [2026-01-08T11:32:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000356s ] [2026-01-08T11:32:43+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000297s ] [2026-01-08T11:32:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001021s ] [2026-01-08T11:32:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000241s ] [2026-01-08T11:32:44+08:00][sql] CONNECT:[ UseTime:0.011000s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001417s ] [2026-01-08T11:32:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000398s ] [2026-01-08T11:32:44+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000340s ] [2026-01-08T11:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001059s ] [2026-01-08T11:32:44+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000216s ] [2026-01-08T11:32:44+08:00][sql] CONNECT:[ UseTime:0.010832s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001155s ] [2026-01-08T11:32:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000357s ] [2026-01-08T11:32:44+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000324s ] [2026-01-08T11:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000988s ] [2026-01-08T11:32:44+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000228s ] [2026-01-08T11:32:45+08:00][sql] CONNECT:[ UseTime:0.011800s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001339s ] [2026-01-08T11:32:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000259s ] [2026-01-08T11:32:45+08:00][sql] CONNECT:[ UseTime:0.010656s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001344s ] [2026-01-08T11:32:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000335s ] [2026-01-08T11:32:45+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000296s ] [2026-01-08T11:32:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001092s ] [2026-01-08T11:32:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000225s ] [2026-01-08T11:32:55+08:00][sql] CONNECT:[ UseTime:0.001484s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001460s ] [2026-01-08T11:32:55+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000263s ] [2026-01-08T11:32:55+08:00][sql] CONNECT:[ UseTime:0.011380s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001315s ] [2026-01-08T11:32:55+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.000457s ] [2026-01-08T11:32:55+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.000410s ] [2026-01-08T11:32:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001147s ] [2026-01-08T11:32:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000992s ] [2026-01-08T11:32:57+08:00][sql] CONNECT:[ UseTime:0.001457s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001385s ] [2026-01-08T11:32:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000262s ] [2026-01-08T11:32:57+08:00][sql] CONNECT:[ UseTime:0.001314s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001334s ] [2026-01-08T11:32:57+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.000562s ] [2026-01-08T11:32:57+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.000364s ] [2026-01-08T11:32:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001012s ] [2026-01-08T11:32:57+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (152,151,150,149,148,147,143,139,138) [ RunTime:0.000284s ] [2026-01-08T11:32:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001072s ] [2026-01-08T11:32:59+08:00][sql] CONNECT:[ UseTime:0.011126s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001423s ] [2026-01-08T11:32:59+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000277s ] [2026-01-08T11:32:59+08:00][sql] CONNECT:[ UseTime:0.011240s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:32:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001311s ] [2026-01-08T11:32:59+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.000377s ] [2026-01-08T11:32:59+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.000391s ] [2026-01-08T11:32:59+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000971s ] [2026-01-08T11:32:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001101s ] [2026-01-08T11:33:02+08:00][sql] CONNECT:[ UseTime:0.001454s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001476s ] [2026-01-08T11:33:02+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000266s ] [2026-01-08T11:33:03+08:00][sql] CONNECT:[ UseTime:0.010254s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:33:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001418s ] [2026-01-08T11:33:03+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.000448s ] [2026-01-08T11:33:03+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-08T11:33:03+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.000407s ] [2026-01-08T11:33:03+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.000440s ] [2026-01-08T11:54:08+08:00][sql] CONNECT:[ UseTime:0.001481s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:54:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001415s ] [2026-01-08T11:54:08+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-08T11:54:08+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.000381s ] [2026-01-08T11:54:08+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.000318s ] [2026-01-08T11:54:08+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.000409s ] [2026-01-08T11:54:09+08:00][sql] CONNECT:[ UseTime:0.001423s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:54:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001382s ] [2026-01-08T11:54: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.000397s ] [2026-01-08T11:54:09+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.000365s ] [2026-01-08T11:54: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.000347s ] [2026-01-08T11:54:09+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.000389s ] [2026-01-08T11:54:09+08:00][sql] CONNECT:[ UseTime:0.001495s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:54:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001506s ] [2026-01-08T11:54: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.000422s ] [2026-01-08T11:54:09+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.000354s ] [2026-01-08T11:54: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.000374s ] [2026-01-08T11:54:09+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.000435s ] [2026-01-08T11:54:09+08:00][sql] CONNECT:[ UseTime:0.011425s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:54:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001393s ] [2026-01-08T11:54: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.000428s ] [2026-01-08T11:54:09+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.000375s ] [2026-01-08T11:54: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.000322s ] [2026-01-08T11:54:09+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.000412s ] [2026-01-08T11:54:11+08:00][sql] CONNECT:[ UseTime:0.010986s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:54:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001380s ] [2026-01-08T11:54:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000366s ] [2026-01-08T11:54:11+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000374s ] [2026-01-08T11:54:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001053s ] [2026-01-08T11:54:11+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000238s ] [2026-01-08T11:54:12+08:00][sql] CONNECT:[ UseTime:0.001440s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:54:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001340s ] [2026-01-08T11:54:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000422s ] [2026-01-08T11:54:12+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000297s ] [2026-01-08T11:54:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001124s ] [2026-01-08T11:54:12+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000240s ] [2026-01-08T11:54:12+08:00][sql] CONNECT:[ UseTime:0.012102s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T11:54:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001449s ] [2026-01-08T11:54:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000344s ] [2026-01-08T11:54:12+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000292s ] [2026-01-08T11:54:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001209s ] [2026-01-08T11:54:12+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000242s ] [2026-01-08T12:00:26+08:00][sql] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T12:00:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001233s ] [2026-01-08T12:00:26+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000312s ] [2026-01-08T12:00:26+08:00][sql] CONNECT:[ UseTime:0.011118s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T12:00:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001396s ] [2026-01-08T12:00:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000337s ] [2026-01-08T12:00:26+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000317s ] [2026-01-08T12:00:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001142s ] [2026-01-08T12:00:26+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000256s ] [2026-01-08T13:30:45+08:00][sql] CONNECT:[ UseTime:0.011277s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:30:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001406s ] [2026-01-08T13:30:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000374s ] [2026-01-08T13:30:45+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000399s ] [2026-01-08T13:30:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001129s ] [2026-01-08T13:30:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000231s ] [2026-01-08T13:30:45+08:00][sql] CONNECT:[ UseTime:0.011536s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:30:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001453s ] [2026-01-08T13:30:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000348s ] [2026-01-08T13:30:45+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000285s ] [2026-01-08T13:30:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001129s ] [2026-01-08T13:30:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000291s ] [2026-01-08T13:30:47+08:00][sql] CONNECT:[ UseTime:0.011253s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:30:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001392s ] [2026-01-08T13:30:47+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000263s ] [2026-01-08T13:30:47+08:00][sql] CONNECT:[ UseTime:0.001423s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:30:47+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001310s ] [2026-01-08T13:30:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000386s ] [2026-01-08T13:30:47+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000291s ] [2026-01-08T13:30:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001088s ] [2026-01-08T13:30:47+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000249s ] [2026-01-08T13:30:49+08:00][sql] CONNECT:[ UseTime:0.001440s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:30:49+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001317s ] [2026-01-08T13:30:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000350s ] [2026-01-08T13:30:49+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000329s ] [2026-01-08T13:30:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001027s ] [2026-01-08T13:30:49+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000245s ] [2026-01-08T13:30:51+08:00][sql] CONNECT:[ UseTime:0.011123s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001455s ] [2026-01-08T13:30:51+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000271s ] [2026-01-08T13:30:51+08:00][sql] CONNECT:[ UseTime:0.011094s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001459s ] [2026-01-08T13:30:51+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.000544s ] [2026-01-08T13:30:51+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.000398s ] [2026-01-08T13:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001210s ] [2026-01-08T13:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001089s ] [2026-01-08T13:30:52+08:00][sql] CONNECT:[ UseTime:0.001459s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:30:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001533s ] [2026-01-08T13:30:52+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000254s ] [2026-01-08T13:30:52+08:00][sql] CONNECT:[ UseTime:0.011444s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:30:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001364s ] [2026-01-08T13:30:52+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.000604s ] [2026-01-08T13:30:52+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.000371s ] [2026-01-08T13:30:52+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000999s ] [2026-01-08T13:30:52+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (152,151,150,149,148,147,143,139,138) [ RunTime:0.000278s ] [2026-01-08T13:30:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001029s ] [2026-01-08T13:34:56+08:00][sql] CONNECT:[ UseTime:0.011500s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:34:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001375s ] [2026-01-08T13:34:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000437s ] [2026-01-08T13:34:56+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000331s ] [2026-01-08T13:34:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001013s ] [2026-01-08T13:34:56+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000236s ] [2026-01-08T13:34:57+08:00][sql] CONNECT:[ UseTime:0.010562s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001484s ] [2026-01-08T13:34:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000435s ] [2026-01-08T13:34:57+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000339s ] [2026-01-08T13:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001106s ] [2026-01-08T13:34:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000222s ] [2026-01-08T13:34:57+08:00][sql] CONNECT:[ UseTime:0.001527s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001560s ] [2026-01-08T13:34:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000440s ] [2026-01-08T13:34:57+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000318s ] [2026-01-08T13:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001103s ] [2026-01-08T13:34:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000235s ] [2026-01-08T13:40:56+08:00][sql] CONNECT:[ UseTime:0.001412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:40:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001350s ] [2026-01-08T13:40:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000370s ] [2026-01-08T13:40:56+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000337s ] [2026-01-08T13:40:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001023s ] [2026-01-08T13:40:56+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000237s ] [2026-01-08T13:41:00+08:00][sql] CONNECT:[ UseTime:0.010937s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:41:00+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001504s ] [2026-01-08T13:41:00+08:00][sql] SELECT * FROM `trade` WHERE `id` = 152 LIMIT 1 [ RunTime:0.000288s ] [2026-01-08T13:42:45+08:00][sql] CONNECT:[ UseTime:0.010905s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:42:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001467s ] [2026-01-08T13:42:45+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.000526s ] [2026-01-08T13:42:45+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.000386s ] [2026-01-08T13:42:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001170s ] [2026-01-08T13:42:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000988s ] [2026-01-08T13:42:49+08:00][sql] CONNECT:[ UseTime:0.001655s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:42:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001478s ] [2026-01-08T13:42:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001192s ] [2026-01-08T13:42:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001073s ] [2026-01-08T13:42:49+08:00][sql] SELECT * FROM `trade_gold` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000277s ] [2026-01-08T13:42:49+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 108 AND `ordertype` = 0 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000364s ] [2026-01-08T13:42:49+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000912s ] [2026-01-08T13:42:49+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 108 LIMIT 1 [ RunTime:0.000329s ] [2026-01-08T13:42:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000933s ] [2026-01-08T13:42:49+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000232s ] [2026-01-08T13:43:07+08:00][sql] CONNECT:[ UseTime:0.011372s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T13:43:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001585s ] [2026-01-08T13:43:07+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') AND `tr`.`username` = 'ctshaiya001' LIMIT 1 [ RunTime:0.000551s ] [2026-01-08T13:43:07+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') AND `tr`.`username` = 'ctshaiya001' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000473s ] [2026-01-08T13:43:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001081s ] [2026-01-08T13:43:07+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (152,151,150,147,132,131,130,129,128,119) [ RunTime:0.000280s ] [2026-01-08T13:43:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001089s ] [2026-01-08T15:55:15+08:00][sql] CONNECT:[ UseTime:0.001482s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T15:55:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001337s ] [2026-01-08T15:55:15+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000263s ] [2026-01-08T15:55:15+08:00][sql] CONNECT:[ UseTime:0.010243s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T15:55:15+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001477s ] [2026-01-08T15:55:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000416s ] [2026-01-08T15:55:15+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000312s ] [2026-01-08T15:55:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001082s ] [2026-01-08T15:55:15+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000318s ] [2026-01-08T15:55:23+08:00][sql] CONNECT:[ UseTime:0.010409s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T15:55:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001324s ] [2026-01-08T15:55:23+08:00][sql] SELECT * FROM `trade` WHERE `id` = 152 LIMIT 1 [ RunTime:0.000331s ] [2026-01-08T15:55:33+08:00][sql] CONNECT:[ UseTime:0.010860s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T15:55:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001360s ] [2026-01-08T15:55:33+08:00][sql] SELECT * FROM `trade` WHERE `id` = 137 LIMIT 1 [ RunTime:0.000273s ] [2026-01-08T17:41:17+08:00][sql] CONNECT:[ UseTime:0.011444s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T17:41:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001291s ] [2026-01-08T17:41:17+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000258s ] [2026-01-08T17:41:18+08:00][sql] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T17:41:18+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001394s ] [2026-01-08T17:41:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000345s ] [2026-01-08T17:41:18+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000296s ] [2026-01-08T17:41:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001064s ] [2026-01-08T17:41:18+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000230s ] [2026-01-08T17:41:22+08:00][sql] CONNECT:[ UseTime:0.001487s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T17:41:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001275s ] [2026-01-08T17:41:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000335s ] [2026-01-08T17:41:22+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000304s ] [2026-01-08T17:41:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000982s ] [2026-01-08T17:41:22+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000220s ] [2026-01-08T17:41:23+08:00][sql] CONNECT:[ UseTime:0.011396s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T17:41:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001234s ] [2026-01-08T17:41:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000333s ] [2026-01-08T17:41:23+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000287s ] [2026-01-08T17:41:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000962s ] [2026-01-08T17:41:23+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000216s ] [2026-01-08T17:43:58+08:00][sql] CONNECT:[ UseTime:0.001398s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T17:43:58+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001337s ] [2026-01-08T17:43:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000346s ] [2026-01-08T17:43:58+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000294s ] [2026-01-08T17:43:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001064s ] [2026-01-08T17:43:58+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000237s ] [2026-01-08T17:43:58+08:00][sql] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T17:43:58+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001320s ] [2026-01-08T17:43:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000354s ] [2026-01-08T17:43:58+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000302s ] [2026-01-08T17:43:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001065s ] [2026-01-08T17:43:58+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000223s ] [2026-01-08T17:43:58+08:00][sql] CONNECT:[ UseTime:0.001450s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T17:43:58+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001286s ] [2026-01-08T17:43:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000356s ] [2026-01-08T17:43:58+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000364s ] [2026-01-08T17:43:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000993s ] [2026-01-08T17:43:58+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000290s ] [2026-01-08T18:13:56+08:00][sql] CONNECT:[ UseTime:0.001535s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T18:13:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001342s ] [2026-01-08T18:13:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000349s ] [2026-01-08T18:13:56+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000297s ] [2026-01-08T18:13:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000990s ] [2026-01-08T18:13:56+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000256s ] [2026-01-08T18:13:56+08:00][sql] CONNECT:[ UseTime:0.011865s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T18:13:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001468s ] [2026-01-08T18:13:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000389s ] [2026-01-08T18:13:56+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000383s ] [2026-01-08T18:13:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001094s ] [2026-01-08T18:13:56+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000233s ] [2026-01-08T18:13:57+08:00][sql] CONNECT:[ UseTime:0.001385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T18:13:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001262s ] [2026-01-08T18:13:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000353s ] [2026-01-08T18:13:57+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000314s ] [2026-01-08T18:13:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001012s ] [2026-01-08T18:13:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000226s ] [2026-01-08T18:14:00+08:00][sql] CONNECT:[ UseTime:0.010649s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T18:14:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001264s ] [2026-01-08T18:14:00+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000288s ] [2026-01-08T18:14:00+08:00][sql] CONNECT:[ UseTime:0.011540s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T18:14:00+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001303s ] [2026-01-08T18:14:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000334s ] [2026-01-08T18:14:00+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000303s ] [2026-01-08T18:14:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001018s ] [2026-01-08T18:14:00+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000242s ] [2026-01-08T18:14:05+08:00][sql] CONNECT:[ UseTime:0.011248s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-08T18:14:05+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001386s ] [2026-01-08T18:14:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000378s ] [2026-01-08T18:14:05+08:00][sql] SELECT * FROM `trade` WHERE `game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000355s ] [2026-01-08T18:14:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001103s ] [2026-01-08T18:14:05+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `game` IN ('shaiya','shaiya5') [ RunTime:0.000285s ]