[2025-07-22T11:37:11+08:00][sql] CONNECT:[ UseTime:0.011345s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T11:37:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001355s ] [2025-07-22T11:37:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000895s ] [2025-07-22T11:37:11+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000255s ] [2025-07-22T11:37:25+08:00][sql] CONNECT:[ UseTime:0.011072s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T11:37:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001344s ] [2025-07-22T11:37:25+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000279s ] [2025-07-22T11:37:26+08:00][sql] CONNECT:[ UseTime:0.011385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T11:37:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001431s ] [2025-07-22T11:37:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000886s ] [2025-07-22T11:37:26+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000262s ] [2025-07-22T11:37:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001202s ] [2025-07-22T11:37:26+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000303s ] [2025-07-22T11:37:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000934s ] [2025-07-22T12:00:43+08:00][sql] CONNECT:[ UseTime:0.011702s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T12:00:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001289s ] [2025-07-22T12:00:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000304s ] [2025-07-22T12:00:43+08:00][sql] CONNECT:[ UseTime:0.001396s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T12:00:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001457s ] [2025-07-22T12:00:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000916s ] [2025-07-22T12:00:43+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000285s ] [2025-07-22T12:00:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001144s ] [2025-07-22T12:00:43+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (12,11,10,9,8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000321s ] [2025-07-22T12:00:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001715s ] [2025-07-22T12:00:43+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (12,11,10,9,8,5,4,3,2,1) [ RunTime:0.000449s ] [2025-07-22T12:00:47+08:00][sql] CONNECT:[ UseTime:0.011050s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T12:00:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001391s ] [2025-07-22T12:00:47+08:00][sql] SELECT `id`,`game`,`username`,`serverid`,`tid`,`trade_status` FROM `trade_role` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000562s ] [2025-07-22T12:00:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001515s ] [2025-07-22T12:00:47+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000368s ] [2025-07-22T15:16:40+08:00][sql] CONNECT:[ UseTime:0.001675s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:16:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001322s ] [2025-07-22T15:16:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000301s ] [2025-07-22T15:16:40+08:00][sql] CONNECT:[ UseTime:0.001527s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:16:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001563s ] [2025-07-22T15:16:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000871s ] [2025-07-22T15:16:40+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000313s ] [2025-07-22T15:16:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001122s ] [2025-07-22T15:16:40+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000280s ] [2025-07-22T15:16:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000917s ] [2025-07-22T15:16:41+08:00][sql] CONNECT:[ UseTime:0.011606s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:16:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001441s ] [2025-07-22T15:16:41+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000281s ] [2025-07-22T15:16:41+08:00][sql] CONNECT:[ UseTime:0.011100s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:16:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001509s ] [2025-07-22T15:16:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000871s ] [2025-07-22T15:16:41+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000288s ] [2025-07-22T15:16:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001232s ] [2025-07-22T15:16:41+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (14,13,12,11,10,9,8,5,4,3) AND `pay_status` IN (0,1) [ RunTime:0.000375s ] [2025-07-22T15:16:41+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001006s ] [2025-07-22T15:16:41+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (14,13,12,11,10,9,8,5,4,3) [ RunTime:0.000368s ] [2025-07-22T15:16:43+08:00][sql] CONNECT:[ UseTime:0.011099s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:16:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001557s ] [2025-07-22T15:16:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `orderno` = 'R2025070513464430955604' LIMIT 1 [ RunTime:0.000291s ] [2025-07-22T15:16:43+08:00][sql] SELECT * FROM `trade_role` WHERE `orderno` = 'R2025070513464430955604' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000317s ] [2025-07-22T15:16:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001183s ] [2025-07-22T15:16:43+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` = 8 AND `pay_status` IN (0,1) [ RunTime:0.000270s ] [2025-07-22T15:16:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000994s ] [2025-07-22T15:16:43+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 8 [ RunTime:0.000308s ] [2025-07-22T15:16:53+08:00][sql] CONNECT:[ UseTime:0.010975s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:16:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001497s ] [2025-07-22T15:16:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `username` = '16754025722' AND `orderno` = 'R2025070513464430955604' LIMIT 1 [ RunTime:0.000309s ] [2025-07-22T15:16:53+08:00][sql] SELECT * FROM `trade_role` WHERE `username` = '16754025722' AND `orderno` = 'R2025070513464430955604' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000277s ] [2025-07-22T15:16:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001124s ] [2025-07-22T15:16:53+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` = 8 AND `pay_status` IN (0,1) [ RunTime:0.000297s ] [2025-07-22T15:16:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000942s ] [2025-07-22T15:16:53+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 8 [ RunTime:0.000226s ] [2025-07-22T15:16:57+08:00][sql] CONNECT:[ UseTime:0.011115s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:16:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001481s ] [2025-07-22T15:16:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `username` = '16754025722' LIMIT 1 [ RunTime:0.000280s ] [2025-07-22T15:16:57+08:00][sql] SELECT * FROM `trade_role` WHERE `username` = '16754025722' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000265s ] [2025-07-22T15:16:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001072s ] [2025-07-22T15:16:57+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (9,8,5,4,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000266s ] [2025-07-22T15:16:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000925s ] [2025-07-22T15:16:57+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (9,8,5,4,2,1) [ RunTime:0.000335s ] [2025-07-22T15:17:05+08:00][sql] CONNECT:[ UseTime:0.011484s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:17:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001484s ] [2025-07-22T15:17:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `username` = 'ctshaiya007' LIMIT 1 [ RunTime:0.000303s ] [2025-07-22T15:17:05+08:00][sql] SELECT * FROM `trade_role` WHERE `username` = 'ctshaiya007' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000267s ] [2025-07-22T15:17:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001113s ] [2025-07-22T15:17:05+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` = 11 AND `pay_status` IN (0,1) [ RunTime:0.000299s ] [2025-07-22T15:17:05+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000940s ] [2025-07-22T15:17:05+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 11 [ RunTime:0.000240s ] [2025-07-22T15:17:33+08:00][sql] CONNECT:[ UseTime:0.010884s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:17:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001385s ] [2025-07-22T15:17:33+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000316s ] [2025-07-22T15:17:33+08:00][sql] CONNECT:[ UseTime:0.011361s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:17:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001513s ] [2025-07-22T15:17:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.006414s ] [2025-07-22T15:17:33+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.030980s ] [2025-07-22T15:17:39+08:00][sql] CONNECT:[ UseTime:0.011728s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:17:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001627s ] [2025-07-22T15:17:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 160001 LIMIT 1 [ RunTime:0.006763s ] [2025-07-22T15:17:39+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 160001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.024325s ] [2025-07-22T15:19:21+08:00][sql] CONNECT:[ UseTime:0.011232s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:19:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001606s ] [2025-07-22T15:19:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006851s ] [2025-07-22T15:19:21+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.024363s ] [2025-07-22T15:20:19+08:00][sql] CONNECT:[ UseTime:0.011211s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:20:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001513s ] [2025-07-22T15:20:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemname` LIKE '熔岩%' AND `itemid` = 120001 LIMIT 1 [ RunTime:0.000416s ] [2025-07-22T15:20:24+08:00][sql] CONNECT:[ UseTime:0.011448s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:20:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001710s ] [2025-07-22T15:20:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemname` LIKE '熔岩%' LIMIT 1 [ RunTime:0.000385s ] [2025-07-22T15:20:24+08:00][sql] SELECT * FROM `trade_items` WHERE `itemname` LIKE '熔岩%' ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.000321s ] [2025-07-22T15:20:31+08:00][sql] CONNECT:[ UseTime:0.010510s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:20:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001618s ] [2025-07-22T15:20:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 121001 LIMIT 1 [ RunTime:0.006630s ] [2025-07-22T15:20:31+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 121001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.023844s ] [2025-07-22T15:20:39+08:00][sql] CONNECT:[ UseTime:0.010963s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:20:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001658s ] [2025-07-22T15:20:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006589s ] [2025-07-22T15:20:39+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.024896s ] [2025-07-22T15:27:14+08:00][sql] CONNECT:[ UseTime:0.001522s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:27:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001284s ] [2025-07-22T15:27:14+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000321s ] [2025-07-22T15:27:14+08:00][sql] CONNECT:[ UseTime:0.001452s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:27:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001506s ] [2025-07-22T15:27:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.005662s ] [2025-07-22T15:27:14+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.029919s ] [2025-07-22T15:32:03+08:00][sql] CONNECT:[ UseTime:0.010963s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:32:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001613s ] [2025-07-22T15:32:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006751s ] [2025-07-22T15:32:03+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.025677s ] [2025-07-22T15:32:25+08:00][sql] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:32:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001527s ] [2025-07-22T15:32:25+08:00][sql] SELECT `game`,`serverid`,`iconset` FROM `trade_items` WHERE `id` = 18701 LIMIT 1 [ RunTime:0.000255s ] [2025-07-22T15:32:25+08:00][sql] UPDATE `trade_items` SET `game` = 'shaiya' , `serverid` = 1 , `itemname` = '鹰(30天)' , `iconset` = '/storage/images/items/icon_pet.png' , `text` = '一只宠物鹰.' , `itemid` = 120001 , `icon` = 1 , `level` = 1 , `dex` = 2 , `og` = 2 , `attacktime` = 0 , `effect1` = -1 , `effect2` = -1 , `effect3` = -1 , `effect4` = -1 , `consthp` = -1 , `constsp` = -1 , `constmp` = -1 , `conststr` = 10 , `constdex` = 10 , `constrec` = 10 , `constint` = 10 , `constwis` = 10 , `constluc` = 10 , `extduration` = -1 WHERE `id` = 18701 [ RunTime:0.000421s ] [2025-07-22T15:32:25+08:00][sql] UPDATE `trade_items` SET `iconset` = '/storage/images/items/icon_pet.png' WHERE `game` = 'shaiya' AND `serverid` = 1 AND `iconset` = '/storage/images/items/icon_pet.png' [ RunTime:0.040777s ] [2025-07-22T15:32:27+08:00][sql] CONNECT:[ UseTime:0.011341s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:32:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001533s ] [2025-07-22T15:32:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006770s ] [2025-07-22T15:32:27+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.024817s ] [2025-07-22T15:32:38+08:00][sql] CONNECT:[ UseTime:0.011512s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:32:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001545s ] [2025-07-22T15:32:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemname` LIKE '熔岩%' AND `itemid` = 120001 LIMIT 1 [ RunTime:0.000337s ] [2025-07-22T15:32:42+08:00][sql] CONNECT:[ UseTime:0.010851s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:32:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001590s ] [2025-07-22T15:32:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemname` LIKE '熔岩%' LIMIT 1 [ RunTime:0.000433s ] [2025-07-22T15:32:42+08:00][sql] SELECT * FROM `trade_items` WHERE `itemname` LIKE '熔岩%' ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.000338s ] [2025-07-22T15:33:05+08:00][sql] CONNECT:[ UseTime:0.011853s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:33:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001526s ] [2025-07-22T15:33:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006695s ] [2025-07-22T15:33:05+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.024754s ] [2025-07-22T15:33:50+08:00][sql] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:33:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001364s ] [2025-07-22T15:33:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000880s ] [2025-07-22T15:33:50+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000249s ] [2025-07-22T15:33:53+08:00][sql] CONNECT:[ UseTime:0.001501s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:33:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001409s ] [2025-07-22T15:33:53+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000320s ] [2025-07-22T15:33:54+08:00][sql] CONNECT:[ UseTime:0.001508s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:33:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001601s ] [2025-07-22T15:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.006247s ] [2025-07-22T15:33:54+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.031128s ] [2025-07-22T15:34:00+08:00][sql] CONNECT:[ UseTime:0.001431s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:34:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001491s ] [2025-07-22T15:34:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006527s ] [2025-07-22T15:34:00+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.023705s ] [2025-07-22T15:37:58+08:00][sql] CONNECT:[ UseTime:0.011562s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:37:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001422s ] [2025-07-22T15:37:58+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000320s ] [2025-07-22T15:37:58+08:00][sql] CONNECT:[ UseTime:0.011556s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:37:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001501s ] [2025-07-22T15:37:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.006366s ] [2025-07-22T15:37:58+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.031098s ] [2025-07-22T15:38:04+08:00][sql] CONNECT:[ UseTime:0.001404s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:38:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001524s ] [2025-07-22T15:38:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006251s ] [2025-07-22T15:38:04+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.023046s ] [2025-07-22T15:38:20+08:00][sql] CONNECT:[ UseTime:0.001517s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:38:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001521s ] [2025-07-22T15:38:20+08:00][sql] SELECT `game`,`serverid`,`iconset` FROM `trade_items` WHERE `id` = 18701 LIMIT 1 [ RunTime:0.000247s ] [2025-07-22T15:38:20+08:00][sql] UPDATE `trade_items` SET `game` = 'shaiya' , `serverid` = 1 , `itemname` = '鹰(30天)' , `iconset` = '/storage/images/items/icon_pet.png' , `text` = '一只宠物鹰.' , `itemid` = 120001 , `icon` = 1 , `level` = 1 , `dex` = 2 , `og` = 2 , `attacktime` = 0 , `effect1` = -1 , `effect2` = -1 , `effect3` = -1 , `effect4` = -1 , `consthp` = -1 , `constsp` = -1 , `constmp` = -1 , `conststr` = 10 , `constdex` = 10 , `constrec` = 10 , `constint` = 10 , `constwis` = 10 , `constluc` = 10 , `extduration` = -1 WHERE `id` = 18701 [ RunTime:0.000425s ] [2025-07-22T15:38:20+08:00][sql] UPDATE `trade_items` SET `iconset` = '/storage/images/items/icon_pet.png' WHERE `game` = 'shaiya' AND `serverid` = 1 AND `iconset` = '/storage/images/items/icon_pet.png' [ RunTime:0.040988s ] [2025-07-22T15:38:22+08:00][sql] CONNECT:[ UseTime:0.011668s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:38:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001477s ] [2025-07-22T15:38:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006310s ] [2025-07-22T15:38:22+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.023050s ] [2025-07-22T15:38:47+08:00][sql] CONNECT:[ UseTime:0.011118s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:38:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001633s ] [2025-07-22T15:38:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006424s ] [2025-07-22T15:38:47+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.024872s ] [2025-07-22T15:38:57+08:00][sql] CONNECT:[ UseTime:0.001466s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:38:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001561s ] [2025-07-22T15:38:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.006336s ] [2025-07-22T15:38:57+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.030589s ] [2025-07-22T15:39:05+08:00][sql] CONNECT:[ UseTime:0.001543s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:39:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001472s ] [2025-07-22T15:39:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemname` LIKE '熔岩%' LIMIT 1 [ RunTime:0.000300s ] [2025-07-22T15:39:05+08:00][sql] SELECT * FROM `trade_items` WHERE `itemname` LIKE '熔岩%' ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.000312s ] [2025-07-22T15:40:52+08:00][sql] CONNECT:[ UseTime:0.010696s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:40:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001481s ] [2025-07-22T15:40:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 121001 LIMIT 1 [ RunTime:0.006260s ] [2025-07-22T15:40:52+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 121001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.023485s ] [2025-07-22T15:40:57+08:00][sql] CONNECT:[ UseTime:0.001495s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T15:40:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001569s ] [2025-07-22T15:40:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006660s ] [2025-07-22T15:40:57+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.024440s ] [2025-07-22T16:12:55+08:00][sql] CONNECT:[ UseTime:0.001559s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T16:12:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001372s ] [2025-07-22T16:12:55+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000320s ] [2025-07-22T16:12:56+08:00][sql] CONNECT:[ UseTime:0.011188s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T16:12:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001556s ] [2025-07-22T16:12:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.005910s ] [2025-07-22T16:12:56+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.030395s ] [2025-07-22T16:13:00+08:00][sql] CONNECT:[ UseTime:0.011000s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T16:13:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001539s ] [2025-07-22T16:13:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006718s ] [2025-07-22T16:13:00+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.025241s ] [2025-07-22T16:13:18+08:00][sql] CONNECT:[ UseTime:0.001455s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T16:13:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001458s ] [2025-07-22T16:13:18+08:00][sql] SELECT `game`,`serverid`,`iconset` FROM `trade_items` WHERE `id` = 18701 LIMIT 1 [ RunTime:0.000252s ] [2025-07-22T16:13:18+08:00][sql] UPDATE `trade_items` SET `game` = 'shaiya' , `serverid` = 1 , `itemname` = '鹰(30天)' , `iconset` = '/storage/images/items/icon_pet.png_687f481a39e2c.png' , `text` = '一只宠物鹰.' , `itemid` = 120001 , `icon` = 1 , `level` = 1 , `dex` = 2 , `og` = 2 , `attacktime` = 0 , `effect1` = -1 , `effect2` = -1 , `effect3` = -1 , `effect4` = -1 , `consthp` = -1 , `constsp` = -1 , `constmp` = -1 , `conststr` = 10 , `constdex` = 10 , `constrec` = 10 , `constint` = 10 , `constwis` = 10 , `constluc` = 10 , `extduration` = -1 WHERE `id` = 18701 [ RunTime:0.000397s ] [2025-07-22T16:13:18+08:00][sql] UPDATE `trade_items` SET `iconset` = '/storage/images/items/icon_pet.png_687f481a39e2c.png' WHERE `game` = 'shaiya' AND `serverid` = 1 AND `iconset` = '/storage/images/items/icon_pet.png' [ RunTime:0.045131s ] [2025-07-22T16:13:20+08:00][sql] CONNECT:[ UseTime:0.010986s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T16:13:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001542s ] [2025-07-22T16:13:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemid` = 120001 LIMIT 1 [ RunTime:0.006806s ] [2025-07-22T16:13:20+08:00][sql] SELECT * FROM `trade_items` WHERE `itemid` = 120001 ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.025267s ] [2025-07-22T16:15:09+08:00][sql] CONNECT:[ UseTime:0.001395s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T16:15:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001428s ] [2025-07-22T16:15:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemname` LIKE '熔岩%' LIMIT 1 [ RunTime:0.000331s ] [2025-07-22T16:15:09+08:00][sql] SELECT * FROM `trade_items` WHERE `itemname` LIKE '熔岩%' ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.000384s ] [2025-07-22T16:16:11+08:00][sql] CONNECT:[ UseTime:0.010861s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T16:16:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001453s ] [2025-07-22T16:16:11+08:00][sql] SELECT `game`,`serverid`,`iconset` FROM `trade_items` WHERE `id` = 20064 LIMIT 1 [ RunTime:0.000264s ] [2025-07-22T16:16:11+08:00][sql] UPDATE `trade_items` SET `game` = 'shaiya' , `serverid` = 1 , `itemname` = '熔岩飞马(30天)' , `iconset` = '/storage/images/items/icon_pet.png_687f481a39e2c.png' , `text` = '热气腾腾的熔岩飞马，马头旁边似乎还长着牛头\\n自动拾取金币和道具.' , `itemid` = 152106 , `icon` = 121 , `level` = 1 , `dex` = 2 , `og` = 2 , `attacktime` = 0 , `effect1` = -1 , `effect2` = -1 , `effect3` = -1 , `effect4` = -1 , `consthp` = -1 , `constsp` = -1 , `constmp` = -1 , `conststr` = 20 , `constdex` = 20 , `constrec` = 20 , `constint` = 20 , `constwis` = 20 , `constluc` = 20 , `extduration` = -1 WHERE `id` = 20064 [ RunTime:0.000384s ] [2025-07-22T16:16:11+08:00][sql] UPDATE `trade_items` SET `iconset` = '/storage/images/items/icon_pet.png_687f481a39e2c.png' WHERE `game` = 'shaiya' AND `serverid` = 1 AND `iconset` = '/storage/images/items/icon_pet.png_687f481a39e2c.png' [ RunTime:0.039002s ] [2025-07-22T16:16:12+08:00][sql] CONNECT:[ UseTime:0.011487s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T16:16:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001482s ] [2025-07-22T16:16:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemname` LIKE '熔岩%' LIMIT 1 [ RunTime:0.000308s ] [2025-07-22T16:16:12+08:00][sql] SELECT * FROM `trade_items` WHERE `itemname` LIKE '熔岩%' ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.000342s ] [2025-07-22T16:16:21+08:00][sql] CONNECT:[ UseTime:0.010609s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T16:16:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001548s ] [2025-07-22T16:16:21+08:00][sql] SELECT `game`,`serverid`,`iconset` FROM `trade_items` WHERE `id` = 20063 LIMIT 1 [ RunTime:0.000257s ] [2025-07-22T16:16:21+08:00][sql] UPDATE `trade_items` SET `game` = 'shaiya' , `serverid` = 1 , `itemname` = '熔岩飞马(7天)' , `iconset` = '/storage/images/items/icon_pet.png_687f481a39e2c.png' , `text` = '热气腾腾的熔岩飞马，马头旁边似乎还长着牛头\\n自动拾取金币和道具.' , `itemid` = 152105 , `icon` = 121 , `level` = 1 , `dex` = 2 , `og` = 2 , `attacktime` = 0 , `effect1` = -1 , `effect2` = -1 , `effect3` = -1 , `effect4` = -1 , `consthp` = -1 , `constsp` = -1 , `constmp` = -1 , `conststr` = 20 , `constdex` = 20 , `constrec` = 20 , `constint` = 20 , `constwis` = 20 , `constluc` = 20 , `extduration` = -1 WHERE `id` = 20063 [ RunTime:0.000467s ] [2025-07-22T16:16:21+08:00][sql] UPDATE `trade_items` SET `iconset` = '/storage/images/items/icon_pet.png_687f481a39e2c.png' WHERE `game` = 'shaiya' AND `serverid` = 1 AND `iconset` = '/storage/images/items/icon_pet.png_687f481a39e2c.png' [ RunTime:0.040803s ] [2025-07-22T16:16:23+08:00][sql] CONNECT:[ UseTime:0.011368s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T16:16:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001518s ] [2025-07-22T16:16:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` WHERE `itemname` LIKE '熔岩%' LIMIT 1 [ RunTime:0.000332s ] [2025-07-22T16:16:23+08:00][sql] SELECT * FROM `trade_items` WHERE `itemname` LIKE '熔岩%' ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.000334s ] [2025-07-22T17:14:17+08:00][sql] CONNECT:[ UseTime:0.001463s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:14:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001242s ] [2025-07-22T17:14:17+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000276s ] [2025-07-22T17:14:17+08:00][sql] CONNECT:[ UseTime:0.001383s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:14:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001358s ] [2025-07-22T17:14:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000913s ] [2025-07-22T17:14:17+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000269s ] [2025-07-22T17:14:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001282s ] [2025-07-22T17:14:17+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000316s ] [2025-07-22T17:14:17+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000947s ] [2025-07-22T17:14:21+08:00][sql] CONNECT:[ UseTime:0.011225s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:14:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001353s ] [2025-07-22T17:14:21+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000287s ] [2025-07-22T17:14:21+08:00][sql] CONNECT:[ UseTime:0.010860s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:14:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001393s ] [2025-07-22T17:14:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000867s ] [2025-07-22T17:14:21+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000294s ] [2025-07-22T17:14:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001247s ] [2025-07-22T17:14:21+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (16,15,14,13,12,11,10,9,8,5) AND `pay_status` IN (0,1) [ RunTime:0.000373s ] [2025-07-22T17:14:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001018s ] [2025-07-22T17:14:21+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (16,15,14,13,12,11,10,9,8,5) [ RunTime:0.000326s ] [2025-07-22T17:14:27+08:00][sql] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:14:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001321s ] [2025-07-22T17:14:27+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000302s ] [2025-07-22T17:14:27+08:00][sql] CONNECT:[ UseTime:0.001431s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:14:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001397s ] [2025-07-22T17:14:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000243s ] [2025-07-22T17:15:40+08:00][sql] CONNECT:[ UseTime:0.010989s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:15:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001293s ] [2025-07-22T17:15:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000850s ] [2025-07-22T17:15:40+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000284s ] [2025-07-22T17:18:27+08:00][sql] CONNECT:[ UseTime:0.010853s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:18:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001463s ] [2025-07-22T17:18:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000922s ] [2025-07-22T17:18:27+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000265s ] [2025-07-22T17:18:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001197s ] [2025-07-22T17:18:27+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000289s ] [2025-07-22T17:18:27+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000961s ] [2025-07-22T17:18:29+08:00][sql] CONNECT:[ UseTime:0.010713s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:18:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001504s ] [2025-07-22T17:18:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001158s ] [2025-07-22T17:18:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001078s ] [2025-07-22T17:18:29+08:00][sql] SELECT * FROM `trade_gold` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000261s ] [2025-07-22T17:18:29+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 7 AND `ordertype` = 0 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000302s ] [2025-07-22T17:18:29+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000928s ] [2025-07-22T17:18:29+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 7 LIMIT 1 [ RunTime:0.000269s ] [2025-07-22T17:18:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000941s ] [2025-07-22T17:18:29+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000248s ] [2025-07-22T17:18:34+08:00][sql] CONNECT:[ UseTime:0.011124s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:18:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001455s ] [2025-07-22T17:18:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000865s ] [2025-07-22T17:18:34+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000274s ] [2025-07-22T17:18:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001174s ] [2025-07-22T17:18:34+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (16,15,14,13,12,11,10,9,8,5) AND `pay_status` IN (0,1) [ RunTime:0.000338s ] [2025-07-22T17:18:34+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000924s ] [2025-07-22T17:18:34+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (16,15,14,13,12,11,10,9,8,5) [ RunTime:0.000309s ] [2025-07-22T17:18:34+08:00][sql] CONNECT:[ UseTime:0.011400s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:18:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001478s ] [2025-07-22T17:18:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000967s ] [2025-07-22T17:18:34+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000327s ] [2025-07-22T17:18:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001284s ] [2025-07-22T17:18:34+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (16,15,14,13,12,11,10,9,8,5) AND `pay_status` IN (0,1) [ RunTime:0.000309s ] [2025-07-22T17:18:34+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001045s ] [2025-07-22T17:18:34+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (16,15,14,13,12,11,10,9,8,5) [ RunTime:0.000286s ] [2025-07-22T17:18:35+08:00][sql] CONNECT:[ UseTime:0.010739s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:18:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001391s ] [2025-07-22T17:18:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000910s ] [2025-07-22T17:18:35+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000378s ] [2025-07-22T17:18:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001219s ] [2025-07-22T17:18:35+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (16,15,14,13,12,11,10,9,8,5) AND `pay_status` IN (0,1) [ RunTime:0.000320s ] [2025-07-22T17:18:35+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000989s ] [2025-07-22T17:18:35+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (16,15,14,13,12,11,10,9,8,5) [ RunTime:0.000290s ] [2025-07-22T17:18:38+08:00][sql] CONNECT:[ UseTime:0.011019s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:18:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001346s ] [2025-07-22T17:18:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001390s ] [2025-07-22T17:18:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001100s ] [2025-07-22T17:18:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001042s ] [2025-07-22T17:18:38+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000295s ] [2025-07-22T17:18:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001069s ] [2025-07-22T17:18:38+08:00][sql] SELECT `id`,`game`,`type`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ap`,`dp`,`af`,`as`,`am`,`df`,`ds`,`dm` FROM `trade_war` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000347s ] [2025-07-22T17:18:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001160s ] [2025-07-22T17:18:38+08:00][sql] SELECT `id`,`game`,`type`,`itemid`,`st`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ia`,`iav`,`ide`,`idm`,`rd`,`sl`,`cj`,`g1`,`g2`,`g3`,`g4`,`g5`,`g6` FROM `trade_equip` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000327s ] [2025-07-22T17:18:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000883s ] [2025-07-22T17:18:38+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000327s ] [2025-07-22T17:18:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001137s ] [2025-07-22T17:18:38+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (25001,38184,101206) [ RunTime:0.042358s ] [2025-07-22T17:18:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001154s ] [2025-07-22T17:18:38+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`skillid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000348s ] [2025-07-22T17:18:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000994s ] [2025-07-22T17:18:38+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000313s ] [2025-07-22T17:18:38+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000188s ] [2025-07-22T17:18:38+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 15 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000280s ] [2025-07-22T17:18:38+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 15 LIMIT 1 [ RunTime:0.000241s ] [2025-07-22T17:18:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000924s ] [2025-07-22T17:18:38+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000266s ] [2025-07-22T17:19:19+08:00][sql] CONNECT:[ UseTime:0.011443s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:19:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001363s ] [2025-07-22T17:19:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001236s ] [2025-07-22T17:19:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001109s ] [2025-07-22T17:19:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001112s ] [2025-07-22T17:19:19+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000288s ] [2025-07-22T17:19:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001082s ] [2025-07-22T17:19:19+08:00][sql] SELECT `id`,`game`,`type`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ap`,`dp`,`af`,`as`,`am`,`df`,`ds`,`dm` FROM `trade_war` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000370s ] [2025-07-22T17:19:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001193s ] [2025-07-22T17:19:19+08:00][sql] SELECT `id`,`game`,`type`,`itemid`,`st`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ia`,`iav`,`ide`,`idm`,`rd`,`sl`,`cj`,`g1`,`g2`,`g3`,`g4`,`g5`,`g6` FROM `trade_equip` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000368s ] [2025-07-22T17:19:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000917s ] [2025-07-22T17:19:19+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000304s ] [2025-07-22T17:19:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001139s ] [2025-07-22T17:19:19+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (25001,38184,101206) [ RunTime:0.044144s ] [2025-07-22T17:19:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001429s ] [2025-07-22T17:19:19+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`skillid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000355s ] [2025-07-22T17:19:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001042s ] [2025-07-22T17:19:19+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000317s ] [2025-07-22T17:19:19+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000196s ] [2025-07-22T17:19:19+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 15 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000286s ] [2025-07-22T17:19:19+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 15 LIMIT 1 [ RunTime:0.000256s ] [2025-07-22T17:19:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000936s ] [2025-07-22T17:19:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000261s ] [2025-07-22T17:25:31+08:00][sql] CONNECT:[ UseTime:0.009220s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:25:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001604s ] [2025-07-22T17:25:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.006377s ] [2025-07-22T17:25:31+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.031460s ] [2025-07-22T17:25:40+08:00][sql] CONNECT:[ UseTime:0.001440s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:25:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001338s ] [2025-07-22T17:25:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000292s ] [2025-07-22T17:25:40+08:00][sql] CONNECT:[ UseTime:0.001369s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:25:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001317s ] [2025-07-22T17:25:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` LIMIT 1 [ RunTime:0.000287s ] [2025-07-22T17:25:40+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` FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` ORDER BY `tw`.`id` DESC LIMIT 0,10 [ RunTime:0.000252s ] [2025-07-22T17:25: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` [ RunTime:0.000241s ] [2025-07-22T17:26:47+08:00][sql] CONNECT:[ UseTime:0.004369s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:26:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001332s ] [2025-07-22T17:26:47+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000299s ] [2025-07-22T17:26:47+08:00][sql] CONNECT:[ UseTime:0.009202s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:26:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001462s ] [2025-07-22T17:26:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000963s ] [2025-07-22T17:26:47+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000411s ] [2025-07-22T17:26:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001662s ] [2025-07-22T17:26:47+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (16,15,14,13,12,11,10,9,8,5) AND `pay_status` IN (0,1) [ RunTime:0.000428s ] [2025-07-22T17:26:47+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001126s ] [2025-07-22T17:26:47+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (16,15,14,13,12,11,10,9,8,5) [ RunTime:0.000438s ] [2025-07-22T17:26:54+08:00][sql] CONNECT:[ UseTime:0.005181s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001258s ] [2025-07-22T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001197s ] [2025-07-22T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001046s ] [2025-07-22T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001022s ] [2025-07-22T17:26:54+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000292s ] [2025-07-22T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001054s ] [2025-07-22T17:26:54+08:00][sql] SELECT `id`,`game`,`type`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ap`,`dp`,`af`,`as`,`am`,`df`,`ds`,`dm` FROM `trade_war` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000345s ] [2025-07-22T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001145s ] [2025-07-22T17:26:54+08:00][sql] SELECT `id`,`game`,`type`,`itemid`,`st`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ia`,`iav`,`ide`,`idm`,`rd`,`sl`,`cj`,`g1`,`g2`,`g3`,`g4`,`g5`,`g6` FROM `trade_equip` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000338s ] [2025-07-22T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000852s ] [2025-07-22T17:26:54+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000312s ] [2025-07-22T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001171s ] [2025-07-22T17:26:54+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (25001,38184,101206) [ RunTime:0.041717s ] [2025-07-22T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001264s ] [2025-07-22T17:26:54+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`skillid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000351s ] [2025-07-22T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001015s ] [2025-07-22T17:26:54+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000316s ] [2025-07-22T17:26:54+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000202s ] [2025-07-22T17:26:54+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 15 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000285s ] [2025-07-22T17:26:54+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 15 LIMIT 1 [ RunTime:0.000238s ] [2025-07-22T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000930s ] [2025-07-22T17:26:54+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000244s ] [2025-07-22T17:34:36+08:00][sql] CONNECT:[ UseTime:0.001533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:34:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001423s ] [2025-07-22T17:34:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000820s ] [2025-07-22T17:34:36+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000394s ] [2025-07-22T17:34:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001196s ] [2025-07-22T17:34:36+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (16,15,14,13,12,11,10,9,8,5) AND `pay_status` IN (0,1) [ RunTime:0.000313s ] [2025-07-22T17:34:36+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000961s ] [2025-07-22T17:34:36+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (16,15,14,13,12,11,10,9,8,5) [ RunTime:0.000292s ] [2025-07-22T17:34:37+08:00][sql] CONNECT:[ UseTime:0.001410s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:34:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001405s ] [2025-07-22T17:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000877s ] [2025-07-22T17:34:37+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000283s ] [2025-07-22T17:34:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001217s ] [2025-07-22T17:34:37+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (16,15,14,13,12,11,10,9,8,5) AND `pay_status` IN (0,1) [ RunTime:0.000332s ] [2025-07-22T17:34:37+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000945s ] [2025-07-22T17:34:37+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (16,15,14,13,12,11,10,9,8,5) [ RunTime:0.000310s ] [2025-07-22T17:34:37+08:00][sql] CONNECT:[ UseTime:0.001539s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:34:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001522s ] [2025-07-22T17:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000903s ] [2025-07-22T17:34:37+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000279s ] [2025-07-22T17:34:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001132s ] [2025-07-22T17:34:37+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (16,15,14,13,12,11,10,9,8,5) AND `pay_status` IN (0,1) [ RunTime:0.000332s ] [2025-07-22T17:34:37+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000933s ] [2025-07-22T17:34:37+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (16,15,14,13,12,11,10,9,8,5) [ RunTime:0.000269s ] [2025-07-22T17:34:38+08:00][sql] CONNECT:[ UseTime:0.016070s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:34:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001274s ] [2025-07-22T17:34:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001195s ] [2025-07-22T17:34:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001054s ] [2025-07-22T17:34:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001121s ] [2025-07-22T17:34:38+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000296s ] [2025-07-22T17:34:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001035s ] [2025-07-22T17:34:38+08:00][sql] SELECT `id`,`game`,`type`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ap`,`dp`,`af`,`as`,`am`,`df`,`ds`,`dm` FROM `trade_war` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 16 [ RunTime:0.000349s ] [2025-07-22T17:34:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001159s ] [2025-07-22T17:34:38+08:00][sql] SELECT `id`,`game`,`type`,`itemid`,`st`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ia`,`iav`,`ide`,`idm`,`rd`,`sl`,`cj`,`g1`,`g2`,`g3`,`g4`,`g5`,`g6` FROM `trade_equip` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 16 [ RunTime:0.000488s ] [2025-07-22T17:34:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001147s ] [2025-07-22T17:34:38+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (30228,30149,30006,30205,30191,30192,98013,30193,30203,30208,30223,30227,30241,30080,30201,30070,30069,30081,30229,30005,30068,98018,98014,30202,30034,30067,30033,30013,30012,30232,30204,30195,30148) [ RunTime:0.029717s ] [2025-07-22T17:34:38+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (87008,82073,83073,85073,86073,4107,24034,23057,22162,40158,42179,152097,122003,87006,32005,33005,35009,36005,7029,34024,23243,22025,40247,42149,152104,31019,82055,83055,85055,86055,5060,23155,22156,40155,42144,152107,4110,4109) [ RunTime:0.041702s ] [2025-07-22T17:34:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001144s ] [2025-07-22T17:34:38+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 16 [ RunTime:0.000910s ] [2025-07-22T17:34:38+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (82073,4110,4109,127021,127027,25069,127069,25070,127070,127024,127039,127041,127042,127040,127073,79032,25027,25026,130226,119212,79152,79170,32204,128029,128030,43012,79153,100080,79154,101222,25029,25028,25032,25033,25030,25031,101107,101108,101109,100131,100132,100167,127185,127187,127188,127189,127186,127190,101209,101210,101211,100092,103021,79116,101051,100238,101233,101241,100062,101234,118214,79117,101190,127064,101191,101197,25023,23170,25020,50087,82055,25024,25021,25039,25165,161001,79161,127068,127043,44099,100046,100045,102203,103008,103023,103024,95011,95012,128081,125002,100252,101022,100183,125003,101195,161005,161006,78201,119097,103055,78224,125001,128100,100234,100232,100174,100143,41126,100175,101029,100221,127062,128103,119005,101036,119004,101203,131201,100251,100254,100253,118158,125010,161002,127055,127053,127054,127052,130045,42045,42046,42123,42212,120100,100224,101095,100169,101064) [ RunTime:0.042362s ] [2025-07-22T17:34:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001382s ] [2025-07-22T17:34:38+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`skillid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 16 [ RunTime:0.000366s ] [2025-07-22T17:34:38+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`godid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `godid` IN (140004,240501) [ RunTime:0.000359s ] [2025-07-22T17:34:38+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`skillid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `skillid` IN (2015005,2008005,2033005,2035005) [ RunTime:0.000361s ] [2025-07-22T17:34:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001027s ] [2025-07-22T17:34:38+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 16 [ RunTime:0.000323s ] [2025-07-22T17:34:38+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (121033,121039,121017,121028,121045) [ RunTime:0.030785s ] [2025-07-22T17:34:38+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000250s ] [2025-07-22T17:34:38+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 16 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000300s ] [2025-07-22T17:34:38+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 16 LIMIT 1 [ RunTime:0.000246s ] [2025-07-22T17:34:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001016s ] [2025-07-22T17:34:38+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000240s ] [2025-07-22T17:39:30+08:00][sql] CONNECT:[ UseTime:0.017456s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:39:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001671s ] [2025-07-22T17:39:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000944s ] [2025-07-22T17:39:30+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000303s ] [2025-07-22T17:39:33+08:00][sql] CONNECT:[ UseTime:0.011951s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:39:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001283s ] [2025-07-22T17:39:33+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000294s ] [2025-07-22T17:39:33+08:00][sql] CONNECT:[ UseTime:0.002014s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:39:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001325s ] [2025-07-22T17:39:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000914s ] [2025-07-22T17:39:33+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000280s ] [2025-07-22T17:39:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001052s ] [2025-07-22T17:39:33+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (16,15,14,13,12,11,10,9,8,5) AND `pay_status` IN (0,1) [ RunTime:0.000291s ] [2025-07-22T17:39:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000893s ] [2025-07-22T17:39:33+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (16,15,14,13,12,11,10,9,8,5) [ RunTime:0.000284s ] [2025-07-22T17:39:35+08:00][sql] CONNECT:[ UseTime:0.002511s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-22T17:39:35+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001385s ] [2025-07-22T17:39:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001282s ] [2025-07-22T17:39:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001112s ] [2025-07-22T17:39:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001098s ] [2025-07-22T17:39:35+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000317s ] [2025-07-22T17:39:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001085s ] [2025-07-22T17:39:35+08:00][sql] SELECT `id`,`game`,`type`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ap`,`dp`,`af`,`as`,`am`,`df`,`ds`,`dm` FROM `trade_war` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000369s ] [2025-07-22T17:39:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001184s ] [2025-07-22T17:39:35+08:00][sql] SELECT `id`,`game`,`type`,`itemid`,`st`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ia`,`iav`,`ide`,`idm`,`rd`,`sl`,`cj`,`g1`,`g2`,`g3`,`g4`,`g5`,`g6` FROM `trade_equip` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000363s ] [2025-07-22T17:39:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000885s ] [2025-07-22T17:39:35+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000342s ] [2025-07-22T17:39:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001241s ] [2025-07-22T17:39:35+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (25001,38184,101206) [ RunTime:0.045033s ] [2025-07-22T17:39:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001230s ] [2025-07-22T17:39:35+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`skillid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000338s ] [2025-07-22T17:39:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000943s ] [2025-07-22T17:39:35+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 15 [ RunTime:0.000300s ] [2025-07-22T17:39:35+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000180s ] [2025-07-22T17:39:35+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 15 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000294s ] [2025-07-22T17:39:35+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 15 LIMIT 1 [ RunTime:0.000265s ] [2025-07-22T17:39:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000858s ] [2025-07-22T17:39:35+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000217s ]