[2025-07-31T11:38:11+08:00][sql] CONNECT:[ UseTime:0.011559s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T11:38:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001380s ] [2025-07-31T11:38:11+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000310s ] [2025-07-31T11:38:11+08:00][sql] CONNECT:[ UseTime:0.010760s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T11:38:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001425s ] [2025-07-31T11:38:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000880s ] [2025-07-31T11:38:11+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000403s ] [2025-07-31T11:38:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001177s ] [2025-07-31T11:38:11+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (18,17,16,15,14,13,12,11,10,9) AND `pay_status` IN (0,1) [ RunTime:0.000327s ] [2025-07-31T11:38:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000923s ] [2025-07-31T11:38:11+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (18,17,16,15,14,13,12,11,10,9) [ RunTime:0.000284s ] [2025-07-31T11:38:13+08:00][sql] CONNECT:[ UseTime:0.011433s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T11:38:13+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001303s ] [2025-07-31T11:38:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001205s ] [2025-07-31T11:38:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001062s ] [2025-07-31T11:38:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001059s ] [2025-07-31T11:38:13+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000300s ] [2025-07-31T11:38:13+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000209s ] [2025-07-31T11:38:13+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 18 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000285s ] [2025-07-31T11:38:13+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 18 LIMIT 1 [ RunTime:0.000232s ] [2025-07-31T11:38:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000928s ] [2025-07-31T11:38:13+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000262s ] [2025-07-31T13:40:37+08:00][sql] CONNECT:[ UseTime:0.001498s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T13:40:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001323s ] [2025-07-31T13:40:37+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000297s ] [2025-07-31T13:40:37+08:00][sql] CONNECT:[ UseTime:0.011550s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T13:40:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001458s ] [2025-07-31T13:40:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000848s ] [2025-07-31T13:40:37+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000266s ] [2025-07-31T13:40:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001146s ] [2025-07-31T13:40:37+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (18,17,16,15,14,13,12,11,10,9) AND `pay_status` IN (0,1) [ RunTime:0.000338s ] [2025-07-31T13:40:37+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000959s ] [2025-07-31T13:40:37+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (18,17,16,15,14,13,12,11,10,9) [ RunTime:0.000281s ] [2025-07-31T13:45:42+08:00][sql] CONNECT:[ UseTime:0.011052s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T13:45:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001408s ] [2025-07-31T13:45:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000849s ] [2025-07-31T13:45:42+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000288s ] [2025-07-31T13:50:36+08:00][sql] CONNECT:[ UseTime:0.011510s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T13:50:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001412s ] [2025-07-31T13:50:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_cate` LIMIT 1 [ RunTime:0.000202s ] [2025-07-31T13:50:36+08:00][sql] SELECT * FROM `trade_help_cate` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000277s ] [2025-07-31T13:50:38+08:00][sql] CONNECT:[ UseTime:0.011072s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T13:50:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001186s ] [2025-07-31T13:50:38+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000240s ] [2025-07-31T13:50:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001021s ] [2025-07-31T13:50:38+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000253s ] [2025-07-31T13:50:38+08:00][sql] CONNECT:[ UseTime:0.011450s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T13:50:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001285s ] [2025-07-31T13:50:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000892s ] [2025-07-31T13:50:38+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000469s ] [2025-07-31T14:24:36+08:00][sql] CONNECT:[ UseTime:0.010497s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:24:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001336s ] [2025-07-31T14:24:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000914s ] [2025-07-31T14:24:36+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000279s ] [2025-07-31T14:24:39+08:00][sql] CONNECT:[ UseTime:0.001446s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:24:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001358s ] [2025-07-31T14:24:39+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000299s ] [2025-07-31T14:24:39+08:00][sql] CONNECT:[ UseTime:0.011828s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:24:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001563s ] [2025-07-31T14:24:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.010237s ] [2025-07-31T14:24:39+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.059743s ] [2025-07-31T14:29:47+08:00][sql] CONNECT:[ UseTime:0.011611s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001319s ] [2025-07-31T14:29:47+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000444s ] [2025-07-31T14:29:47+08:00][sql] CONNECT:[ UseTime:0.011060s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001488s ] [2025-07-31T14:29:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000821s ] [2025-07-31T14:29:47+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000370s ] [2025-07-31T14:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001281s ] [2025-07-31T14:29:47+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.000378s ] [2025-07-31T14:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001055s ] [2025-07-31T14:29:48+08:00][sql] CONNECT:[ UseTime:0.010861s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:29:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001351s ] [2025-07-31T14:29:48+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000288s ] [2025-07-31T14:29:48+08:00][sql] CONNECT:[ UseTime:0.011512s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:29:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001434s ] [2025-07-31T14:29:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000806s ] [2025-07-31T14:29:48+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000285s ] [2025-07-31T14:29:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001185s ] [2025-07-31T14:29:48+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (20,18,17,16,15,14,13,12,11,10) AND `pay_status` IN (0,1) [ RunTime:0.000357s ] [2025-07-31T14:29:48+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000926s ] [2025-07-31T14:29:48+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (20,18,17,16,15,14,13,12,11,10) [ RunTime:0.000340s ] [2025-07-31T14:30:06+08:00][sql] CONNECT:[ UseTime:0.001786s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:30:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.002529s ] [2025-07-31T14:30:06+08:00][sql] SELECT `id`,`game`,`username`,`serverid`,`tid`,`trade_status` FROM `trade_role` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000427s ] [2025-07-31T14:30:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001466s ] [2025-07-31T14:30:06+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000384s ] [2025-07-31T14:30:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001244s ] [2025-07-31T14:30:06+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_status`,`sync_tradeno` FROM `trade` WHERE `id` = 20 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000421s ] [2025-07-31T14:30:06+08:00][sql] UPDATE `trade_role` SET `trade_status` = 7 WHERE `id` = 17 [ RunTime:0.000354s ] [2025-07-31T14:30:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001333s ] [2025-07-31T14:30:06+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya' , `serverid` = 6 , `tid` = 20 , `username` = '13279598332' , `orderno` = '' , `trade_type` = 1 , `type` = 0 , `content` = '%s未通过公示期%s,商品已退回游戏,请前往游戏内角色列表/角色邮箱查收。如有疑问可联系官方客服咨询%s' [ RunTime:0.000350s ] [2025-07-31T14:30:07+08:00][sql] CONNECT:[ UseTime:0.010625s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001497s ] [2025-07-31T14:30:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000873s ] [2025-07-31T14:30:07+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000293s ] [2025-07-31T14:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001372s ] [2025-07-31T14:30:07+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (20,18,17,16,15,14,13,12,11,10) AND `pay_status` IN (0,1) [ RunTime:0.000290s ] [2025-07-31T14:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001061s ] [2025-07-31T14:30:07+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (20,18,17,16,15,14,13,12,11,10) [ RunTime:0.000280s ] [2025-07-31T14:46:03+08:00][sql] CONNECT:[ UseTime:0.010841s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:46:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001271s ] [2025-07-31T14:46:03+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000282s ] [2025-07-31T14:46:03+08:00][sql] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:46:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001468s ] [2025-07-31T14:46:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000835s ] [2025-07-31T14:46:03+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000331s ] [2025-07-31T14:46:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001271s ] [2025-07-31T14:46:03+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (21,20,18,17,16,15,14,13,12,11) AND `pay_status` IN (0,1) [ RunTime:0.000316s ] [2025-07-31T14:46:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000965s ] [2025-07-31T14:46:03+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (21,20,18,17,16,15,14,13,12,11) [ RunTime:0.000308s ] [2025-07-31T14:49:26+08:00][sql] CONNECT:[ UseTime:0.001469s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:49:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001340s ] [2025-07-31T14:49:26+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000359s ] [2025-07-31T14:49:26+08:00][sql] CONNECT:[ UseTime:0.011034s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:49:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001651s ] [2025-07-31T14:49:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000890s ] [2025-07-31T14:49:26+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000370s ] [2025-07-31T14:49:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001231s ] [2025-07-31T14:49:26+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (21,20,18,17,16,15,14,13,12,11) AND `pay_status` IN (0,1) [ RunTime:0.000386s ] [2025-07-31T14:49:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000905s ] [2025-07-31T14:49:26+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (21,20,18,17,16,15,14,13,12,11) [ RunTime:0.000260s ] [2025-07-31T14:49:29+08:00][sql] CONNECT:[ UseTime:0.011492s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:49:29+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001362s ] [2025-07-31T14:49:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001304s ] [2025-07-31T14:49:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001204s ] [2025-07-31T14:49:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001175s ] [2025-07-31T14:49:29+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000293s ] [2025-07-31T14:49:29+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000206s ] [2025-07-31T14:49:29+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 21 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000287s ] [2025-07-31T14:49:29+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 21 LIMIT 1 [ RunTime:0.000222s ] [2025-07-31T14:49:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000977s ] [2025-07-31T14:49:29+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000257s ] [2025-07-31T14:51:55+08:00][sql] CONNECT:[ UseTime:0.010973s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:51:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001364s ] [2025-07-31T14:51:55+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000305s ] [2025-07-31T14:51:55+08:00][sql] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:51:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001487s ] [2025-07-31T14:51:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000871s ] [2025-07-31T14:51:55+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000288s ] [2025-07-31T14:51:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001155s ] [2025-07-31T14:51:55+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (21,20,18,17,16,15,14,13,12,11) AND `pay_status` IN (0,1) [ RunTime:0.000385s ] [2025-07-31T14:51:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000942s ] [2025-07-31T14:51:55+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (21,20,18,17,16,15,14,13,12,11) [ RunTime:0.000267s ] [2025-07-31T14:52:19+08:00][sql] CONNECT:[ UseTime:0.011056s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:52:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001340s ] [2025-07-31T14:52:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000289s ] [2025-07-31T14:52:19+08:00][sql] CONNECT:[ UseTime:0.011530s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:52:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001600s ] [2025-07-31T14:52:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.010281s ] [2025-07-31T14:52:19+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.057696s ] [2025-07-31T14:52:34+08:00][sql] CONNECT:[ UseTime:0.011474s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:52:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001275s ] [2025-07-31T14:52:34+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000275s ] [2025-07-31T14:52:34+08:00][sql] CONNECT:[ UseTime:0.012565s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:52:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001403s ] [2025-07-31T14:52:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000783s ] [2025-07-31T14:52:34+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000262s ] [2025-07-31T14:52:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001174s ] [2025-07-31T14:52:34+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.000272s ] [2025-07-31T14:52:34+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000946s ] [2025-07-31T14:52:38+08:00][sql] CONNECT:[ UseTime:0.011314s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:52:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001293s ] [2025-07-31T14:52:38+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000285s ] [2025-07-31T14:52:39+08:00][sql] CONNECT:[ UseTime:0.010386s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:52:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001514s ] [2025-07-31T14:52:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000320s ] [2025-07-31T14:52:40+08:00][sql] CONNECT:[ UseTime:0.010997s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:52:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001604s ] [2025-07-31T14:52:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000355s ] [2025-07-31T14:52:40+08:00][sql] CONNECT:[ UseTime:0.011203s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:52:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001660s ] [2025-07-31T14:52: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.000307s ] [2025-07-31T14:52: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.000332s ] [2025-07-31T14:52: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.000381s ] [2025-07-31T14:52:40+08:00][sql] CONNECT:[ UseTime:0.001594s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:52:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001515s ] [2025-07-31T14:52:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000279s ] [2025-07-31T14:52:40+08:00][sql] CONNECT:[ UseTime:0.010578s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:52:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001281s ] [2025-07-31T14:52:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE `ordertype` = -1 LIMIT 1 [ RunTime:0.000458s ] [2025-07-31T14:52:40+08:00][sql] SELECT * FROM `trade_stats` WHERE `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000253s ] [2025-07-31T14:54:03+08:00][sql] CONNECT:[ UseTime:0.011174s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:54:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001301s ] [2025-07-31T14:54:03+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000280s ] [2025-07-31T14:54:04+08:00][sql] CONNECT:[ UseTime:0.010997s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:54:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001488s ] [2025-07-31T14:54:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000816s ] [2025-07-31T14:54:04+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000298s ] [2025-07-31T14:54:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001177s ] [2025-07-31T14:54:04+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (21,20,18,17,16,15,14,13,12,11) AND `pay_status` IN (0,1) [ RunTime:0.000300s ] [2025-07-31T14:54:04+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000944s ] [2025-07-31T14:54:04+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (21,20,18,17,16,15,14,13,12,11) [ RunTime:0.000314s ] [2025-07-31T14:54:09+08:00][sql] CONNECT:[ UseTime:0.011307s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:54:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001179s ] [2025-07-31T14:54:09+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000226s ] [2025-07-31T14:54:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001034s ] [2025-07-31T14:54:09+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000271s ] [2025-07-31T14:54:09+08:00][sql] CONNECT:[ UseTime:0.010902s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:54:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001323s ] [2025-07-31T14:54:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000902s ] [2025-07-31T14:54:09+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000491s ] [2025-07-31T14:54:20+08:00][sql] CONNECT:[ UseTime:0.010666s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:54:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001352s ] [2025-07-31T14:54:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000888s ] [2025-07-31T14:54:20+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000558s ] [2025-07-31T14:54:21+08:00][sql] CONNECT:[ UseTime:0.011321s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:54:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001320s ] [2025-07-31T14:54:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000831s ] [2025-07-31T14:54:21+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000451s ] [2025-07-31T14:54:21+08:00][sql] CONNECT:[ UseTime:0.011089s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:54:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001280s ] [2025-07-31T14:54:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000911s ] [2025-07-31T14:54:21+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000415s ] [2025-07-31T14:54:21+08:00][sql] CONNECT:[ UseTime:0.011088s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:54:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001306s ] [2025-07-31T14:54:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya5' LIMIT 1 [ RunTime:0.000293s ] [2025-07-31T14:54:33+08:00][sql] CONNECT:[ UseTime:0.011195s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:54:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001221s ] [2025-07-31T14:54:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_cate` LIMIT 1 [ RunTime:0.000221s ] [2025-07-31T14:54:33+08:00][sql] SELECT * FROM `trade_help_cate` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000194s ] [2025-07-31T14:54:40+08:00][sql] CONNECT:[ UseTime:0.001384s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:54:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001241s ] [2025-07-31T14:54:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000969s ] [2025-07-31T14:54:40+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000282s ] [2025-07-31T14:56:12+08:00][sql] CONNECT:[ UseTime:0.011218s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T14:56:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001326s ] [2025-07-31T14:56:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya' LIMIT 1 [ RunTime:0.000294s ] [2025-07-31T14:56:12+08:00][sql] SELECT * FROM `trade_help_article` WHERE `game` = 'shaiya' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000473s ] [2025-07-31T15:10:44+08:00][sql] CONNECT:[ UseTime:0.010872s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:10:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001257s ] [2025-07-31T15:10:44+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000268s ] [2025-07-31T15:10:44+08:00][sql] CONNECT:[ UseTime:0.011417s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:10:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001589s ] [2025-07-31T15:10:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000858s ] [2025-07-31T15:10:44+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000310s ] [2025-07-31T15:10:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001167s ] [2025-07-31T15:10:44+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (22,21,20,18,17,16,15,14,13,12) AND `pay_status` IN (0,1) [ RunTime:0.000297s ] [2025-07-31T15:10:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000967s ] [2025-07-31T15:10:44+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (22,21,20,18,17,16,15,14,13,12) [ RunTime:0.000276s ] [2025-07-31T15:11:10+08:00][sql] CONNECT:[ UseTime:0.001426s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:11:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001351s ] [2025-07-31T15:11:10+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000295s ] [2025-07-31T15:11:10+08:00][sql] CONNECT:[ UseTime:0.011053s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:11:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001394s ] [2025-07-31T15:11:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000862s ] [2025-07-31T15:11:10+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000270s ] [2025-07-31T15:11:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001157s ] [2025-07-31T15:11:10+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (22,21,20,18,17,16,15,14,13,12) AND `pay_status` IN (0,1) [ RunTime:0.000289s ] [2025-07-31T15:11:10+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001093s ] [2025-07-31T15:11:10+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (22,21,20,18,17,16,15,14,13,12) [ RunTime:0.000298s ] [2025-07-31T15:11:37+08:00][sql] CONNECT:[ UseTime:0.001397s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:11:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001458s ] [2025-07-31T15:11:37+08:00][sql] SELECT `id`,`game`,`username`,`serverid`,`tid`,`trade_status` FROM `trade_role` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000299s ] [2025-07-31T15:11:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001058s ] [2025-07-31T15:11:37+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000277s ] [2025-07-31T15:19:11+08:00][sql] CONNECT:[ UseTime:0.001476s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:19:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001302s ] [2025-07-31T15:19:11+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000287s ] [2025-07-31T15:19:12+08:00][sql] CONNECT:[ UseTime:0.010994s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:19:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001533s ] [2025-07-31T15:19:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000969s ] [2025-07-31T15:19:12+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000291s ] [2025-07-31T15:19:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001292s ] [2025-07-31T15:19:12+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (22,21,20,18,17,16,15,14,13,12) AND `pay_status` IN (0,1) [ RunTime:0.000306s ] [2025-07-31T15:19:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001070s ] [2025-07-31T15:19:12+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (22,21,20,18,17,16,15,14,13,12) [ RunTime:0.000308s ] [2025-07-31T15:19:26+08:00][sql] CONNECT:[ UseTime:0.011326s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:19:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001387s ] [2025-07-31T15:19:26+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000285s ] [2025-07-31T15:19:26+08:00][sql] CONNECT:[ UseTime:0.010962s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:19:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001521s ] [2025-07-31T15:19:26+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.000310s ] [2025-07-31T15:19:26+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.000269s ] [2025-07-31T15:19:26+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.000243s ] [2025-07-31T15:19:32+08:00][sql] CONNECT:[ UseTime:0.011324s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:19:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001343s ] [2025-07-31T15:19:32+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000306s ] [2025-07-31T15:19:32+08:00][sql] CONNECT:[ UseTime:0.011629s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:19:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001486s ] [2025-07-31T15:19:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000799s ] [2025-07-31T15:19:32+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000263s ] [2025-07-31T15:19:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001184s ] [2025-07-31T15:19:32+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.000283s ] [2025-07-31T15:19:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000936s ] [2025-07-31T15:25:08+08:00][sql] CONNECT:[ UseTime:0.011582s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:25:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001279s ] [2025-07-31T15:25:08+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000229s ] [2025-07-31T15:25:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001141s ] [2025-07-31T15:25:08+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000270s ] [2025-07-31T15:25:09+08:00][sql] CONNECT:[ UseTime:0.001473s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:25:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001412s ] [2025-07-31T15:25:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000945s ] [2025-07-31T15:25:09+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000586s ] [2025-07-31T15:25:34+08:00][sql] CONNECT:[ UseTime:0.010478s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:25:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001319s ] [2025-07-31T15:25:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya5' LIMIT 1 [ RunTime:0.000312s ] [2025-07-31T15:26:10+08:00][sql] CONNECT:[ UseTime:0.001580s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001512s ] [2025-07-31T15:26:10+08:00][sql] INSERT INTO `trade_help_article` SET `id` = 0 , `game` = 'shaiya5' , `title` = '什么是指定我?' , `cate_id` = 2 , `sort` = 49 , `status` = 1 , `class` = '' , `content` = '
关于“指定我”
角色商品可指定购买账号,上架时在游戏内勾选指定并填写账号即可指定。
指定售卖的角色在“浏览商品”页不可见,需要在“公示期商品”和被指定账号的“指定我”中查看。
指定售卖角色只能被指定账号购买,可以做到安心定向交易。
交易成功后向卖方收取12%手续费,不足30元按30元计,最高不超过8000元。
“珍宝阁”——官方认可的游戏线下交易平台,为满足玩家对线下交易的需求,同时保障大家可以远离骗子,并打击盗号者销赃行为,应运而生。在“珍宝阁”,玩家每一笔交易都是和游戏数据对应的,所有交易凭据都确切存在,而不再仅仅是一张截图或一段聊天记录,而且交易全程有系统监控,安全得到充分保障。因此在“珍宝阁”上的交易是合法且得到官方承认的。
买家快速上手
登录→浏览→购买→付款→游戏内查收
卖家快速上手
游戏内寄售上架,网页查看、下架商品
' , `mark` = 'OKpFniVMWrZjDuZhSpJOTQiWmJmSMBgh' [ RunTime:0.002481s ] [2025-07-31T15:27:13+08:00][sql] CONNECT:[ UseTime:0.001443s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:27:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001301s ] [2025-07-31T15:27:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya5' LIMIT 1 [ RunTime:0.000319s ] [2025-07-31T15:27:13+08:00][sql] SELECT * FROM `trade_help_article` WHERE `game` = 'shaiya5' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000248s ] [2025-07-31T15:27:48+08:00][sql] CONNECT:[ UseTime:0.011333s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-31T15:27:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001330s ] [2025-07-31T15:27:48+08:00][sql] INSERT INTO `trade_help_article` SET `id` = 0 , `game` = 'shaiya5' , `title` = '提现问题' , `cate_id` = 1 , `sort` = 59 , `status` = 1 , `class` = 'icon_v_05' , `content` = '如何提现
登录珍宝阁点击【我是卖家→我的物品】,商品出售成功后,方可申请对应订单的提现(提现时间3个工作日)。
申请提现时要填写正确的支付宝账号和姓名。
上架角色问题
问:为什么我刚上架的角色没有显示?
答:游戏内完成上架后需要等待数据存储传输,游戏操作上架后需要等待15分钟网页才会显示。
下架问题
问:为什么我的角色下架不了?
答:当角色已经被玩家下订单购买时,为保障交易的正常进行,卖家暂时不可以将角色下架。
上架角色消失问题
问:为什么我上架的角色在平台上看不见了?
答:当上架的角色已经被购买,或对角色下订单的买家达到一定数量时,系统将自动将角色设置为不可见,此时其他买家在平台看不到此角色,卖家自己可以在 [我是卖家--> 我的物品] 中查看到对应角色。
付款未显示问题
问:为什么我已经支付了,在平台看到订单还是处于未付款状态?
答:珍宝阁在收到银行反馈您成功支付的信息后才会对您的支付进行处理,由于银行内部处理需要一定的时间,以及网络的原因。 从您支付成功的时刻到银行反馈到交易平台的时刻可能有一定的延迟,请您耐心等待,或联系我们的客服人员进行处理。
登录珍宝阁是否消费点卡
问:登录珍宝阁消费点卡吗?
答:登录珍宝阁网站不消费点卡。
未交易的角色是否收费
问:未交易的角色收不收费用?
答:在成功交易和提现时收取费用。未成功交易的角色不收取任何费用。
珍宝阁是否可以点卡交易
问:珍宝阁可以点卡交易吗?
答:现不支持点卡交易。
账号封停问题
问:我在珍宝阁刚购买的角色,然后被封停,购买之前的违规行为怎么算到我身上?
答:账号违规封停是即时的,与购买前的账号无直接关系,封停是针对角色的即时行为,不会有延时封停的情况。
如何购买角色
步骤一:登录想要购买角色的游戏账号,点击“我是买家”,选择角色商品分类进行浏览,查看在售商品详情。
步骤二:选择想要购买的角色点击“购买”,确认商品及订单信息后进行支付。
请注意:
1、接收角色的账号必须在被购买角色所属游戏区服登录过。
2、用来接收购买角色的账号下已有的游戏角色不得超出可建角色限制(单阵营最多创建5个角色)。
※若玩家购买角色为熊灵族职业,须优先满足其创建条件(至少拥有一名60级角色且对应阵营已创建熊灵族职业<2个)。
3、用于购买角色的账号账号安全信息最好不为空,且绑定了手机及完善身份证信息。我们再次提醒大家,共享账号将可能给你带来不可预估的损失和伤害。
4、挑中自己满意的角色后,查看其相关数据信息,一一确认了之后,支付即可。
5、购买成功后,可在“我的珍宝阁→我的订单”中查看。
步骤三:购买发货成功后,使用购买账号登录游戏即可看到购买的角色。
请注意:
角色购买成功后,则在游戏角色界面增加所购买的角色,并可正常游戏。也即购买的角色成功转入到执行购买操作的通行证账号下。
如何购买金币/道具
步骤一:登录想要购买角色的游戏账号,点击“我是买家”,选择金币/道具商品分类进行浏览,查看在售商品详情。
步骤二:选择想要购买的商品点击“购买”。
步骤三:在订单界面选择收货角色,确认商品及订单信息后进行支付。
步骤四:购买成功后,登录游戏收货角色,前往邮箱查收商品。
登录要出售的角色/要出售金币、道具所在的角色,前往珍宝阁npc(坐标:阿普伦630,232 伊里斯693,252)处点击对应寄售。
所有商品寄售上架后均有公示期3天,出售期7天。
所有商品最低售价为50元。
出售注意事项:
角色:
1、存在上架中道具/金币的角色无法寄售。
2、180天有过违规封停的账号无法寄售角色。
3、同个角色24小时内只能上架一次。
4、指定购买的角色可在公示期商品、指定我中查看,浏览商品中不可见。
金币:
1、金币出售使用指定金币道具“珍宝币”进行交易,可前往金块商人处购买。
2、同个账号24小时内最多只能上架3次金币,合计金额不得超过1亿金币。(下架金币不计入)
道具:
1、道具寄售为活动限时开放且只能寄售指定的道具。(具体可寄售道具见限时开放时的活动说明)
商品改价:
已上架商品想要修改价格只能下架后在游戏内重新上架。
通过珍宝阁发布交易信息,如果交易成功,需从卖方所得金额中扣除一定的手续费。如果没有交易成功不收取信息费。
角色类
普通交易角色收费规则:手续费=交易额×8%(单笔最低手续费30元,最高手续费8000元)
| 收费规则 | 例子:卖方以1000元卖出一个角色 | |
卖方 | 普通交易:手续费=交易额×8% | 交易成功后,手续费为1000*8%=80元 1000-80=920元作为卖方实际收入,可被提现。 |
| 买方 | 不收取手续费 | 买方支付1000元即可 |
指定交易角色收费规则:手续费=交易额×12%(单笔最低手续费30元,最高手续费8000元)
| 收费规则 | 例子:卖方以1000元卖出一个角色 | |
卖方 | 普通交易:手续费=交易额×12% | 交易成功后,手续费为1000*12%=120元 1000-120=880元作为卖方实际收入,可被提现。 |
| 买方 | 不收取手续费 | 买方支付1000元即可 |
金币类
金币收费规则:手续费=交易额×5%
| 收费规则 | 例子:卖方以101元卖出一笔金币 | |
卖方 | 普通交易:手续费=交易额×5% | 交易成功后,手续费为101*5%=5.05元 101-5.05=95.95元作为卖方实际收入,可被提现。 |
| 买方 | 不收取手续费 | 买方支付101元即可 |
道具类
道具收费规则:手续费=交易额×5%(单笔最高手续费5000元)
| 收费规则 | 例子:卖方以101元能卖出一组道具 | |
卖方 | 普通交易:手续费=交易额×5% | 交易成功后,手续费为101*5%=5.05元 101-5.05=95.95元作为卖方实际收入,可被提现。 |
| 买方 | 不收取手续费 | 买方支付101元即可 |