[2025-11-12T00:24:56+08:00][sql] CONNECT:[ UseTime:0.001469s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T00:24:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001281s ] [2025-11-12T00:24:56+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000423s ] [2025-11-12T00:24:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000983s ] [2025-11-12T00:24:56+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000206s ] [2025-11-12T09:44:44+08:00][sql] CONNECT:[ UseTime:0.016138s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:44:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001372s ] [2025-11-12T09:44:44+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000441s ] [2025-11-12T09:44:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001067s ] [2025-11-12T09:44:44+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000218s ] [2025-11-12T09:44:46+08:00][sql] CONNECT:[ UseTime:0.001614s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:44:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001323s ] [2025-11-12T09:44:46+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000432s ] [2025-11-12T09:44:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001030s ] [2025-11-12T09:44:46+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '116dbfb732616492e66bc9c04e703fd8' AND `status` = 1 LIMIT 1 [ RunTime:0.000290s ] [2025-11-12T09:44:46+08:00][sql] CONNECT:[ UseTime:0.013441s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:44:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001163s ] [2025-11-12T09:44:46+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000361s ] [2025-11-12T09:44:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001174s ] [2025-11-12T09:44:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 08:39:46' AND '2025-11-12 09:39:46' AND `specuser` = '' LIMIT 1 [ RunTime:0.000434s ] [2025-11-12T09:44:52+08:00][sql] CONNECT:[ UseTime:0.011840s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:44:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001313s ] [2025-11-12T09:44:52+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000405s ] [2025-11-12T09:44:52+08:00][sql] CONNECT:[ UseTime:0.045819s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-11-12T09:44:52+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.030907s ] [2025-11-12T09:44:52+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya001' LIMIT 1 [ RunTime:0.072569s ] [2025-11-12T09:44:53+08:00][sql] CONNECT:[ UseTime:0.009101s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:44:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001199s ] [2025-11-12T09:44:53+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000395s ] [2025-11-12T09:44:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000936s ] [2025-11-12T09:44:53+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000313s ] [2025-11-12T09:44:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001068s ] [2025-11-12T09:44:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 08:39:52' AND '2025-11-12 09:39:52' AND `specuser` = '' LIMIT 1 [ RunTime:0.000400s ] [2025-11-12T09:44:54+08:00][sql] CONNECT:[ UseTime:0.006501s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:44:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001356s ] [2025-11-12T09:44:54+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000420s ] [2025-11-12T09:44:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001013s ] [2025-11-12T09:44:54+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000363s ] [2025-11-12T09:44:54+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000937s ] [2025-11-12T09:44:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:44:54' LIMIT 1 [ RunTime:0.000508s ] [2025-11-12T09:44:54+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:44:54' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000445s ] [2025-11-12T09:44:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001134s ] [2025-11-12T09:44:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001196s ] [2025-11-12T09:44:54+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000411s ] [2025-11-12T09:44:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001109s ] [2025-11-12T09:44:54+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000330s ] [2025-11-12T09:44:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001169s ] [2025-11-12T09:44:54+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000250s ] [2025-11-12T09:44:57+08:00][sql] CONNECT:[ UseTime:0.002478s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:44:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001292s ] [2025-11-12T09:44:57+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000400s ] [2025-11-12T09:44:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001001s ] [2025-11-12T09:44:57+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000346s ] [2025-11-12T09:44:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001044s ] [2025-11-12T09:44:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tousername` = 'ctshaiya001' AND `addtime` >= 1760319897 LIMIT 1 [ RunTime:0.000342s ] [2025-11-12T09:44:58+08:00][sql] CONNECT:[ UseTime:0.014626s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001268s ] [2025-11-12T09:44:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000401s ] [2025-11-12T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001000s ] [2025-11-12T09:44:58+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000341s ] [2025-11-12T09:44:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 LIMIT 1 [ RunTime:0.000279s ] [2025-11-12T09:44:58+08:00][sql] SELECT `mark`,`title` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 ORDER BY `sort` DESC LIMIT 0,100 [ RunTime:0.000250s ] [2025-11-12T09:44:58+08:00][sql] SELECT `mark`,`title`,`content` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.000276s ] [2025-11-12T09:44:58+08:00][sql] CONNECT:[ UseTime:0.010134s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001213s ] [2025-11-12T09:44:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000380s ] [2025-11-12T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000959s ] [2025-11-12T09:44:58+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000322s ] [2025-11-12T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000886s ] [2025-11-12T09:44:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:44:58' LIMIT 1 [ RunTime:0.000460s ] [2025-11-12T09:44:58+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:44:58' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000419s ] [2025-11-12T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001020s ] [2025-11-12T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001064s ] [2025-11-12T09:44:58+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000419s ] [2025-11-12T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000986s ] [2025-11-12T09:44:58+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000257s ] [2025-11-12T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001046s ] [2025-11-12T09:44:58+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000235s ] [2025-11-12T09:44:59+08:00][sql] CONNECT:[ UseTime:0.001478s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:44:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001438s ] [2025-11-12T09:44:59+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000423s ] [2025-11-12T09:44:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001009s ] [2025-11-12T09:44:59+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000368s ] [2025-11-12T09:44:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001157s ] [2025-11-12T09:44:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 08:39:59' AND '2025-11-12 09:39:59' AND `specuser` = '' LIMIT 1 [ RunTime:0.000428s ] [2025-11-12T09:45:01+08:00][sql] CONNECT:[ UseTime:0.010710s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001355s ] [2025-11-12T09:45:01+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000416s ] [2025-11-12T09:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001043s ] [2025-11-12T09:45:01+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000360s ] [2025-11-12T09:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001002s ] [2025-11-12T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:01' LIMIT 1 [ RunTime:0.000514s ] [2025-11-12T09:45:01+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:01' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000435s ] [2025-11-12T09:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001159s ] [2025-11-12T09:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001165s ] [2025-11-12T09:45:01+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000447s ] [2025-11-12T09:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001084s ] [2025-11-12T09:45:01+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000354s ] [2025-11-12T09:45:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001133s ] [2025-11-12T09:45:01+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000245s ] [2025-11-12T09:45:17+08:00][sql] CONNECT:[ UseTime:0.001462s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001388s ] [2025-11-12T09:45:17+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000427s ] [2025-11-12T09:45:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001056s ] [2025-11-12T09:45:17+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000335s ] [2025-11-12T09:45:17+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001014s ] [2025-11-12T09:45:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:17' LIMIT 1 [ RunTime:0.000491s ] [2025-11-12T09:45:17+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:17' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000425s ] [2025-11-12T09:45:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001138s ] [2025-11-12T09:45:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001175s ] [2025-11-12T09:45:17+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000572s ] [2025-11-12T09:45:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001031s ] [2025-11-12T09:45:17+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000261s ] [2025-11-12T09:45:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001020s ] [2025-11-12T09:45:17+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000232s ] [2025-11-12T09:45:19+08:00][sql] CONNECT:[ UseTime:0.002159s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001210s ] [2025-11-12T09:45:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000378s ] [2025-11-12T09:45:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000937s ] [2025-11-12T09:45:19+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000330s ] [2025-11-12T09:45:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000864s ] [2025-11-12T09:45:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:19' LIMIT 1 [ RunTime:0.000449s ] [2025-11-12T09:45:19+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:19' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000388s ] [2025-11-12T09:45:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001032s ] [2025-11-12T09:45:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001050s ] [2025-11-12T09:45:19+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000409s ] [2025-11-12T09:45:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000980s ] [2025-11-12T09:45:19+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000262s ] [2025-11-12T09:45:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001024s ] [2025-11-12T09:45:19+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000235s ] [2025-11-12T09:45:20+08:00][sql] CONNECT:[ UseTime:0.012940s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001205s ] [2025-11-12T09:45:20+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000399s ] [2025-11-12T09:45:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000948s ] [2025-11-12T09:45:20+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000313s ] [2025-11-12T09:45:20+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000884s ] [2025-11-12T09:45:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:20' LIMIT 1 [ RunTime:0.000451s ] [2025-11-12T09:45:20+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:20' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000397s ] [2025-11-12T09:45:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001029s ] [2025-11-12T09:45:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001050s ] [2025-11-12T09:45:20+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000434s ] [2025-11-12T09:45:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001027s ] [2025-11-12T09:45:20+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000289s ] [2025-11-12T09:45:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001039s ] [2025-11-12T09:45:20+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000253s ] [2025-11-12T09:45:21+08:00][sql] CONNECT:[ UseTime:0.008147s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001347s ] [2025-11-12T09:45:21+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000411s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001019s ] [2025-11-12T09:45:21+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000352s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000932s ] [2025-11-12T09:45:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:21' LIMIT 1 [ RunTime:0.000461s ] [2025-11-12T09:45:21+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:21' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000432s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001117s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001142s ] [2025-11-12T09:45:21+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000419s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001111s ] [2025-11-12T09:45:21+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000295s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001106s ] [2025-11-12T09:45:21+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000237s ] [2025-11-12T09:45:21+08:00][sql] CONNECT:[ UseTime:0.001563s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001342s ] [2025-11-12T09:45:21+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000410s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001042s ] [2025-11-12T09:45:21+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000351s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000962s ] [2025-11-12T09:45:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:21' LIMIT 1 [ RunTime:0.000495s ] [2025-11-12T09:45:21+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:21' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000408s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001108s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001157s ] [2025-11-12T09:45:21+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000437s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001047s ] [2025-11-12T09:45:21+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000267s ] [2025-11-12T09:45:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001181s ] [2025-11-12T09:45:21+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000249s ] [2025-11-12T09:45:23+08:00][sql] CONNECT:[ UseTime:0.011687s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001210s ] [2025-11-12T09:45:23+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000395s ] [2025-11-12T09:45:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000940s ] [2025-11-12T09:45:23+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000314s ] [2025-11-12T09:45:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001094s ] [2025-11-12T09:45:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 08:40:23' AND '2025-11-12 09:40:23' AND `specuser` = '' LIMIT 1 [ RunTime:0.000434s ] [2025-11-12T09:45:24+08:00][sql] CONNECT:[ UseTime:0.010115s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001220s ] [2025-11-12T09:45:24+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000377s ] [2025-11-12T09:45:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000955s ] [2025-11-12T09:45:24+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000316s ] [2025-11-12T09:45:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000874s ] [2025-11-12T09:45:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:24' LIMIT 1 [ RunTime:0.000437s ] [2025-11-12T09:45:24+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:24' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000414s ] [2025-11-12T09:45:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001017s ] [2025-11-12T09:45:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001071s ] [2025-11-12T09:45:24+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000402s ] [2025-11-12T09:45:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000968s ] [2025-11-12T09:45:24+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000259s ] [2025-11-12T09:45:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001028s ] [2025-11-12T09:45:24+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000231s ] [2025-11-12T09:45:25+08:00][sql] CONNECT:[ UseTime:0.014597s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001362s ] [2025-11-12T09:45:25+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000420s ] [2025-11-12T09:45:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001028s ] [2025-11-12T09:45:25+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000368s ] [2025-11-12T09:45:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001131s ] [2025-11-12T09:45:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tousername` = 'ctshaiya001' AND `addtime` >= 1760319925 LIMIT 1 [ RunTime:0.000316s ] [2025-11-12T09:45:26+08:00][sql] CONNECT:[ UseTime:0.015845s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001304s ] [2025-11-12T09:45:26+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000403s ] [2025-11-12T09:45:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001026s ] [2025-11-12T09:45:26+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000341s ] [2025-11-12T09:45:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000964s ] [2025-11-12T09:45:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:26' LIMIT 1 [ RunTime:0.000452s ] [2025-11-12T09:45:26+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:26' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000434s ] [2025-11-12T09:45:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001092s ] [2025-11-12T09:45:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001121s ] [2025-11-12T09:45:26+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000440s ] [2025-11-12T09:45:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001125s ] [2025-11-12T09:45:26+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000273s ] [2025-11-12T09:45:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001106s ] [2025-11-12T09:45:26+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000263s ] [2025-11-12T09:45:26+08:00][sql] CONNECT:[ UseTime:0.006341s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001300s ] [2025-11-12T09:45:26+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000394s ] [2025-11-12T09:45:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001008s ] [2025-11-12T09:45:26+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000341s ] [2025-11-12T09:45:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001103s ] [2025-11-12T09:45:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 08:40:26' AND '2025-11-12 09:40:26' AND `specuser` = '' LIMIT 1 [ RunTime:0.000421s ] [2025-11-12T09:45:27+08:00][sql] CONNECT:[ UseTime:0.016321s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001301s ] [2025-11-12T09:45:27+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000409s ] [2025-11-12T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000990s ] [2025-11-12T09:45:27+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000350s ] [2025-11-12T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000931s ] [2025-11-12T09:45:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:27' LIMIT 1 [ RunTime:0.000480s ] [2025-11-12T09:45:27+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:27' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000403s ] [2025-11-12T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001081s ] [2025-11-12T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001105s ] [2025-11-12T09:45:27+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000431s ] [2025-11-12T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001041s ] [2025-11-12T09:45:27+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000273s ] [2025-11-12T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001094s ] [2025-11-12T09:45:27+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000256s ] [2025-11-12T09:45:32+08:00][sql] CONNECT:[ UseTime:0.015960s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001321s ] [2025-11-12T09:45:32+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000406s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001004s ] [2025-11-12T09:45:32+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000338s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000955s ] [2025-11-12T09:45:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:32' LIMIT 1 [ RunTime:0.000495s ] [2025-11-12T09:45:32+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:32' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000417s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001103s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001181s ] [2025-11-12T09:45:32+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000429s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001043s ] [2025-11-12T09:45:32+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000328s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001134s ] [2025-11-12T09:45:32+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000259s ] [2025-11-12T09:45:32+08:00][sql] CONNECT:[ UseTime:0.012399s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001270s ] [2025-11-12T09:45:32+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000388s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000983s ] [2025-11-12T09:45:32+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000341s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000942s ] [2025-11-12T09:45:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:32' LIMIT 1 [ RunTime:0.000445s ] [2025-11-12T09:45:32+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:32' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000406s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001088s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001099s ] [2025-11-12T09:45:32+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000428s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001022s ] [2025-11-12T09:45:32+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000318s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001105s ] [2025-11-12T09:45:32+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000258s ] [2025-11-12T09:45:32+08:00][sql] CONNECT:[ UseTime:0.002514s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001482s ] [2025-11-12T09:45:32+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000379s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001056s ] [2025-11-12T09:45:32+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000352s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000967s ] [2025-11-12T09:45:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:32' LIMIT 1 [ RunTime:0.000450s ] [2025-11-12T09:45:32+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:32' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000435s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001095s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001143s ] [2025-11-12T09:45:32+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000410s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001129s ] [2025-11-12T09:45:32+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000353s ] [2025-11-12T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001113s ] [2025-11-12T09:45:32+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000267s ] [2025-11-12T09:45:33+08:00][sql] CONNECT:[ UseTime:0.004730s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001297s ] [2025-11-12T09:45:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000392s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001008s ] [2025-11-12T09:45:33+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000330s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000930s ] [2025-11-12T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:33' LIMIT 1 [ RunTime:0.000453s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:33' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000407s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001063s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001122s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000418s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001015s ] [2025-11-12T09:45:33+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000256s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001091s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000265s ] [2025-11-12T09:45:33+08:00][sql] CONNECT:[ UseTime:0.006673s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001241s ] [2025-11-12T09:45:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000376s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000945s ] [2025-11-12T09:45:33+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000327s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000879s ] [2025-11-12T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:33' LIMIT 1 [ RunTime:0.000462s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:33' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000402s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001044s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001065s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000401s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000996s ] [2025-11-12T09:45:33+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000260s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001048s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000235s ] [2025-11-12T09:45:33+08:00][sql] CONNECT:[ UseTime:0.015284s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001279s ] [2025-11-12T09:45:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000378s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001012s ] [2025-11-12T09:45:33+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000361s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000940s ] [2025-11-12T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:33' LIMIT 1 [ RunTime:0.000451s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:33' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000401s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001094s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001120s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000420s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001060s ] [2025-11-12T09:45:33+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000302s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001090s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000258s ] [2025-11-12T09:45:33+08:00][sql] CONNECT:[ UseTime:0.015580s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001322s ] [2025-11-12T09:45:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000415s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001000s ] [2025-11-12T09:45:33+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000336s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000969s ] [2025-11-12T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:33' LIMIT 1 [ RunTime:0.000460s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:45:33' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000410s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001082s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001118s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000422s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001060s ] [2025-11-12T09:45:33+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000321s ] [2025-11-12T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001107s ] [2025-11-12T09:45:33+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000239s ] [2025-11-12T09:46:20+08:00][sql] CONNECT:[ UseTime:0.001440s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:46:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001336s ] [2025-11-12T09:46:20+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000406s ] [2025-11-12T09:46:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001067s ] [2025-11-12T09:46:20+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000328s ] [2025-11-12T09:46:20+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000971s ] [2025-11-12T09:46:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:46:20' LIMIT 1 [ RunTime:0.000502s ] [2025-11-12T09:46:20+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:46:20' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000433s ] [2025-11-12T09:46:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001135s ] [2025-11-12T09:46:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001169s ] [2025-11-12T09:46:20+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000440s ] [2025-11-12T09:46:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001249s ] [2025-11-12T09:46:20+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000320s ] [2025-11-12T09:46:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001078s ] [2025-11-12T09:46:20+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000253s ] [2025-11-12T09:46:21+08:00][sql] CONNECT:[ UseTime:0.001933s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001306s ] [2025-11-12T09:46:21+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000413s ] [2025-11-12T09:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000997s ] [2025-11-12T09:46:21+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000363s ] [2025-11-12T09:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000923s ] [2025-11-12T09:46:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:46:21' LIMIT 1 [ RunTime:0.000466s ] [2025-11-12T09:46:21+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:46:21' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000397s ] [2025-11-12T09:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001113s ] [2025-11-12T09:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001169s ] [2025-11-12T09:46:21+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000444s ] [2025-11-12T09:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001064s ] [2025-11-12T09:46:21+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000273s ] [2025-11-12T09:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001138s ] [2025-11-12T09:46:21+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000246s ] [2025-11-12T09:46:22+08:00][sql] CONNECT:[ UseTime:0.011276s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:46:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001331s ] [2025-11-12T09:46:22+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000412s ] [2025-11-12T09:46:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001015s ] [2025-11-12T09:46:22+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000350s ] [2025-11-12T09:46:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000942s ] [2025-11-12T09:46:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:46:22' LIMIT 1 [ RunTime:0.000451s ] [2025-11-12T09:46:22+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:46:22' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000431s ] [2025-11-12T09:46:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001137s ] [2025-11-12T09:46:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001165s ] [2025-11-12T09:46:22+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000440s ] [2025-11-12T09:46:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001051s ] [2025-11-12T09:46:22+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000304s ] [2025-11-12T09:46:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001085s ] [2025-11-12T09:46:22+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000238s ] [2025-11-12T09:46:24+08:00][sql] CONNECT:[ UseTime:0.011160s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:46:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001341s ] [2025-11-12T09:46:24+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000416s ] [2025-11-12T09:46:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001009s ] [2025-11-12T09:46:24+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000349s ] [2025-11-12T09:46:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001139s ] [2025-11-12T09:46:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 08:41:24' AND '2025-11-12 09:41:24' AND `specuser` = '' LIMIT 1 [ RunTime:0.000453s ] [2025-11-12T09:46:24+08:00][sql] CONNECT:[ UseTime:0.002999s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:46:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001333s ] [2025-11-12T09:46:24+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000409s ] [2025-11-12T09:46:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000980s ] [2025-11-12T09:46:24+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000336s ] [2025-11-12T09:46:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001101s ] [2025-11-12T09:46:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 08:41:24' AND '2025-11-12 09:41:24' AND `specuser` = '' LIMIT 1 [ RunTime:0.000425s ] [2025-11-12T09:46:25+08:00][sql] CONNECT:[ UseTime:0.011756s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:46:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001304s ] [2025-11-12T09:46:25+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000412s ] [2025-11-12T09:46:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001015s ] [2025-11-12T09:46:25+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000328s ] [2025-11-12T09:46:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001101s ] [2025-11-12T09:46:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-11-12 09:41:25' LIMIT 1 [ RunTime:0.000417s ] [2025-11-12T09:46:25+08:00][sql] CONNECT:[ UseTime:0.005541s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:46:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001334s ] [2025-11-12T09:46:25+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000408s ] [2025-11-12T09:46:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001046s ] [2025-11-12T09:46:25+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000345s ] [2025-11-12T09:46:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001122s ] [2025-11-12T09:46:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-11-12 09:41:25' LIMIT 1 [ RunTime:0.000412s ] [2025-11-12T09:46:26+08:00][sql] CONNECT:[ UseTime:0.004638s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:46:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001376s ] [2025-11-12T09:46:26+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000420s ] [2025-11-12T09:46:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001106s ] [2025-11-12T09:46:26+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000367s ] [2025-11-12T09:46:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001166s ] [2025-11-12T09:46:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-11-12 09:41:26' LIMIT 1 [ RunTime:0.000415s ] [2025-11-12T09:46:26+08:00][sql] CONNECT:[ UseTime:0.011229s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:46:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001228s ] [2025-11-12T09:46:26+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000371s ] [2025-11-12T09:46:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000942s ] [2025-11-12T09:46:26+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000329s ] [2025-11-12T09:46:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001058s ] [2025-11-12T09:46:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-11-12 09:41:26' LIMIT 1 [ RunTime:0.000436s ] [2025-11-12T09:53:58+08:00][sql] CONNECT:[ UseTime:0.001434s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:53:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001305s ] [2025-11-12T09:53:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000399s ] [2025-11-12T09:53:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001023s ] [2025-11-12T09:53:58+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000353s ] [2025-11-12T09:53:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001140s ] [2025-11-12T09:53:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-11-12 09:48:58' LIMIT 1 [ RunTime:0.000427s ] [2025-11-12T09:53:59+08:00][sql] CONNECT:[ UseTime:0.006367s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:53:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001290s ] [2025-11-12T09:53:59+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000404s ] [2025-11-12T09:53:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001037s ] [2025-11-12T09:53:59+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000356s ] [2025-11-12T09:53:59+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000930s ] [2025-11-12T09:53:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:53:59' LIMIT 1 [ RunTime:0.000484s ] [2025-11-12T09:53:59+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:53:59' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000414s ] [2025-11-12T09:53:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001107s ] [2025-11-12T09:53:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001176s ] [2025-11-12T09:53:59+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000419s ] [2025-11-12T09:53:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001048s ] [2025-11-12T09:53:59+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000331s ] [2025-11-12T09:53:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001084s ] [2025-11-12T09:53:59+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000256s ] [2025-11-12T09:54:01+08:00][sql] CONNECT:[ UseTime:0.007415s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001818s ] [2025-11-12T09:54:01+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000464s ] [2025-11-12T09:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001463s ] [2025-11-12T09:54:01+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000507s ] [2025-11-12T09:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001391s ] [2025-11-12T09:54:01+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000529s ] [2025-11-12T09:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001380s ] [2025-11-12T09:54:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001705s ] [2025-11-12T09:54:01+08:00][sql] SELECT `id`,`tid`,`trade_status` FROM `trade_role` WHERE `id` = 69 AND `username` = 'ctshaiya001' LIMIT 1 [ RunTime:0.000324s ] [2025-11-12T09:54:01+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_status`,`sync_tradeno` FROM `trade` WHERE `id` = 131 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000354s ] [2025-11-12T09:54:01+08:00][sql] UPDATE `trade_role` SET `trade_status` = 5 WHERE `id` = 69 [ RunTime:0.000321s ] [2025-11-12T09:54:01+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 131 , `username` = 'ctshaiya001' , `orderno` = '' , `trade_type` = 1 , `type` = 3 , `content` = '%s已完成下架%s，商品已退回游戏，请前往游戏内角色列表/角色邮箱查收。如有疑问可联系官方客服咨询%s' [ RunTime:0.000381s ] [2025-11-12T09:54:02+08:00][sql] CONNECT:[ UseTime:0.016647s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T09:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001186s ] [2025-11-12T09:54:02+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000399s ] [2025-11-12T09:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001028s ] [2025-11-12T09:54:02+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000337s ] [2025-11-12T09:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000947s ] [2025-11-12T09:54:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:54:02' LIMIT 1 [ RunTime:0.000499s ] [2025-11-12T09:54:02+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 09:54:02' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000415s ] [2025-11-12T09:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001098s ] [2025-11-12T09:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001235s ] [2025-11-12T09:54:02+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (131,130,129,128,119,76,73,72) [ RunTime:0.000430s ] [2025-11-12T09:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001135s ] [2025-11-12T09:54:02+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000312s ] [2025-11-12T09:54:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001134s ] [2025-11-12T09:54:02+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000261s ] [2025-11-12T11:14:59+08:00][sql] CONNECT:[ UseTime:0.006873s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:14:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001314s ] [2025-11-12T11:14:59+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000423s ] [2025-11-12T11:14:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001004s ] [2025-11-12T11:14:59+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000332s ] [2025-11-12T11:14:59+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000972s ] [2025-11-12T11:14:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 11:14:59' LIMIT 1 [ RunTime:0.000508s ] [2025-11-12T11:14:59+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-08-14 11:14:59' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000422s ] [2025-11-12T11:14:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001091s ] [2025-11-12T11:14:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001186s ] [2025-11-12T11:14:59+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (132,131,130,129,128,119,76,73) [ RunTime:0.000462s ] [2025-11-12T11:14:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001144s ] [2025-11-12T11:14:59+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000300s ] [2025-11-12T11:14:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001136s ] [2025-11-12T11:14:59+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000260s ] [2025-11-12T11:15:00+08:00][sql] CONNECT:[ UseTime:0.001458s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001330s ] [2025-11-12T11:15:00+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000379s ] [2025-11-12T11:15:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001022s ] [2025-11-12T11:15:00+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000358s ] [2025-11-12T11:15:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001121s ] [2025-11-12T11:15:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:10:00' AND '2025-11-12 11:10:00' AND `specuser` = '' LIMIT 1 [ RunTime:0.000435s ] [2025-11-12T11:15:01+08:00][sql] CONNECT:[ UseTime:0.093770s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001547s ] [2025-11-12T11:15:01+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000486s ] [2025-11-12T11:15:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001337s ] [2025-11-12T11:15:01+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000471s ] [2025-11-12T11:15:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001658s ] [2025-11-12T11:15:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:10:01' AND '2025-11-12 11:10:01' AND `specuser` = '' LIMIT 1 [ RunTime:0.000594s ] [2025-11-12T11:15:03+08:00][sql] CONNECT:[ UseTime:0.001445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001327s ] [2025-11-12T11:15:03+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000571s ] [2025-11-12T11:15:04+08:00][sql] CONNECT:[ UseTime:0.013583s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001225s ] [2025-11-12T11:15:04+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000377s ] [2025-11-12T11:15:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001119s ] [2025-11-12T11:15:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:10:04' AND '2025-11-12 11:10:04' AND `specuser` = '' LIMIT 1 [ RunTime:0.000415s ] [2025-11-12T11:15:13+08:00][sql] CONNECT:[ UseTime:0.014777s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001299s ] [2025-11-12T11:15:13+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000393s ] [2025-11-12T11:15:13+08:00][sql] CONNECT:[ UseTime:0.049326s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-11-12T11:15:13+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.033476s ] [2025-11-12T11:15:13+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.075075s ] [2025-11-12T11:15:13+08:00][sql] CONNECT:[ UseTime:0.012582s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001305s ] [2025-11-12T11:15:13+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000415s ] [2025-11-12T11:15:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000975s ] [2025-11-12T11:15:13+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000341s ] [2025-11-12T11:15:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001151s ] [2025-11-12T11:15:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:10:13' AND '2025-11-12 11:10:13' AND `specuser` = '' LIMIT 1 [ RunTime:0.000435s ] [2025-11-12T11:15:13+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:10:13' AND '2025-11-12 11:10:13' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000476s ] [2025-11-12T11:15:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000915s ] [2025-11-12T11:15:13+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 132 GROUP BY `tid` [ RunTime:0.000292s ] [2025-11-12T11:15:13+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000908s ] [2025-11-12T11:15:13+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 132 [ RunTime:0.000223s ] [2025-11-12T11:15:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001039s ] [2025-11-12T11:15:17+08:00][sql] CONNECT:[ UseTime:0.006194s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001295s ] [2025-11-12T11:15:17+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000411s ] [2025-11-12T11:15:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000977s ] [2025-11-12T11:15:17+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000353s ] [2025-11-12T11:15:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001113s ] [2025-11-12T11:15:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-11-12 11:10:17' LIMIT 1 [ RunTime:0.000415s ] [2025-11-12T11:15:19+08:00][sql] CONNECT:[ UseTime:0.012806s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001216s ] [2025-11-12T11:15:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000393s ] [2025-11-12T11:15:20+08:00][sql] CONNECT:[ UseTime:0.010843s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001301s ] [2025-11-12T11:15:20+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000413s ] [2025-11-12T11:15:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001146s ] [2025-11-12T11:15:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:10:20' AND '2025-11-12 11:10:20' AND `specuser` = '' LIMIT 1 [ RunTime:0.000427s ] [2025-11-12T11:15:20+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:10:20' AND '2025-11-12 11:10:20' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000487s ] [2025-11-12T11:15:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000914s ] [2025-11-12T11:15:20+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 132 GROUP BY `tid` [ RunTime:0.000315s ] [2025-11-12T11:15:20+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000912s ] [2025-11-12T11:15:20+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 132 [ RunTime:0.000225s ] [2025-11-12T11:15:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000984s ] [2025-11-12T11:15:28+08:00][sql] CONNECT:[ UseTime:0.001498s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001372s ] [2025-11-12T11:15:28+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000376s ] [2025-11-12T11:15:28+08:00][sql] CONNECT:[ UseTime:0.052344s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-11-12T11:15:28+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.035382s ] [2025-11-12T11:15:28+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya012' LIMIT 1 [ RunTime:0.077079s ] [2025-11-12T11:15:28+08:00][sql] CONNECT:[ UseTime:0.013650s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001373s ] [2025-11-12T11:15:28+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000422s ] [2025-11-12T11:15:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001012s ] [2025-11-12T11:15:28+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya012' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000355s ] [2025-11-12T11:15:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001177s ] [2025-11-12T11:15:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:10:28' AND '2025-11-12 11:10:28' AND `specuser` = '' LIMIT 1 [ RunTime:0.000447s ] [2025-11-12T11:15:28+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:10:28' AND '2025-11-12 11:10:28' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000488s ] [2025-11-12T11:15:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000980s ] [2025-11-12T11:15:28+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 132 GROUP BY `tid` [ RunTime:0.000318s ] [2025-11-12T11:15:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000956s ] [2025-11-12T11:15:28+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 132 [ RunTime:0.000226s ] [2025-11-12T11:15:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001070s ] [2025-11-12T11:15:31+08:00][sql] CONNECT:[ UseTime:0.004641s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001284s ] [2025-11-12T11:15:31+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000331s ] [2025-11-12T11:15:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000964s ] [2025-11-12T11:15:31+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000358s ] [2025-11-12T11:15:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000943s ] [2025-11-12T11:15:31+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya012' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000328s ] [2025-11-12T11:15:31+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001021s ] [2025-11-12T11:15:31+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000251s ] [2025-11-12T11:15:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001084s ] [2025-11-12T11:15:31+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000343s ] [2025-11-12T11:15:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001009s ] [2025-11-12T11:15:33+08:00][sql] CONNECT:[ UseTime:0.013210s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001320s ] [2025-11-12T11:15:33+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000327s ] [2025-11-12T11:15:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001016s ] [2025-11-12T11:15:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000345s ] [2025-11-12T11:15:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000973s ] [2025-11-12T11:15:33+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya012' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000349s ] [2025-11-12T11:15:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001051s ] [2025-11-12T11:15:33+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000251s ] [2025-11-12T11:15:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001078s ] [2025-11-12T11:15:33+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000354s ] [2025-11-12T11:15:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001060s ] [2025-11-12T11:15:35+08:00][sql] CONNECT:[ UseTime:0.004864s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001319s ] [2025-11-12T11:15:35+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000356s ] [2025-11-12T11:15:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001014s ] [2025-11-12T11:15:35+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000350s ] [2025-11-12T11:15:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000987s ] [2025-11-12T11:15:35+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya012' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000316s ] [2025-11-12T11:15:35+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001015s ] [2025-11-12T11:15:35+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000260s ] [2025-11-12T11:15:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001089s ] [2025-11-12T11:15:35+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000370s ] [2025-11-12T11:15:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001024s ] [2025-11-12T11:15:38+08:00][sql] CONNECT:[ UseTime:0.005343s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001233s ] [2025-11-12T11:15:38+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000299s ] [2025-11-12T11:15:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000961s ] [2025-11-12T11:15:38+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000372s ] [2025-11-12T11:15:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000884s ] [2025-11-12T11:15:38+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya012' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000294s ] [2025-11-12T11:15:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001180s ] [2025-11-12T11:15:38+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000261s ] [2025-11-12T11:15:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001114s ] [2025-11-12T11:15:38+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000353s ] [2025-11-12T11:15:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001065s ] [2025-11-12T11:15:39+08:00][sql] CONNECT:[ UseTime:0.012911s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001252s ] [2025-11-12T11:15:39+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000376s ] [2025-11-12T11:15:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000960s ] [2025-11-12T11:15:39+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya012' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000337s ] [2025-11-12T11:15:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001038s ] [2025-11-12T11:15:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:10:39' AND '2025-11-12 11:10:39' AND `specuser` = '' LIMIT 1 [ RunTime:0.000481s ] [2025-11-12T11:15:39+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:10:39' AND '2025-11-12 11:10:39' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000418s ] [2025-11-12T11:15:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000905s ] [2025-11-12T11:15:39+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 132 GROUP BY `tid` [ RunTime:0.000279s ] [2025-11-12T11:15:39+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000839s ] [2025-11-12T11:15:39+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 132 [ RunTime:0.000206s ] [2025-11-12T11:15:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000975s ] [2025-11-12T11:15:41+08:00][sql] CONNECT:[ UseTime:0.001430s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:15:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001316s ] [2025-11-12T11:15:41+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000329s ] [2025-11-12T11:15:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000977s ] [2025-11-12T11:15:41+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000357s ] [2025-11-12T11:15:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000974s ] [2025-11-12T11:15:41+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya012' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000315s ] [2025-11-12T11:15:41+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000991s ] [2025-11-12T11:15:41+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000271s ] [2025-11-12T11:15:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001055s ] [2025-11-12T11:15:41+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000383s ] [2025-11-12T11:15:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001001s ] [2025-11-12T11:16:56+08:00][sql] CONNECT:[ UseTime:0.001342s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:16:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001286s ] [2025-11-12T11:16:56+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000365s ] [2025-11-12T11:16:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000952s ] [2025-11-12T11:16:56+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000366s ] [2025-11-12T11:16:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000956s ] [2025-11-12T11:16:56+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya012' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000328s ] [2025-11-12T11:16:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001180s ] [2025-11-12T11:16:56+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000270s ] [2025-11-12T11:16:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001101s ] [2025-11-12T11:16:56+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000343s ] [2025-11-12T11:16:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001012s ] [2025-11-12T11:25:19+08:00][sql] CONNECT:[ UseTime:0.001398s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:25:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001224s ] [2025-11-12T11:25:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000424s ] [2025-11-12T11:25:20+08:00][sql] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:25:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001351s ] [2025-11-12T11:25:20+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000429s ] [2025-11-12T11:25:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001215s ] [2025-11-12T11:25:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:20:20' AND '2025-11-12 11:20:20' AND `specuser` = '' LIMIT 1 [ RunTime:0.000462s ] [2025-11-12T11:25:20+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:20:20' AND '2025-11-12 11:20:20' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000490s ] [2025-11-12T11:25:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000979s ] [2025-11-12T11:25:20+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000375s ] [2025-11-12T11:25:20+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000994s ] [2025-11-12T11:25:20+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000273s ] [2025-11-12T11:25:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001092s ] [2025-11-12T11:25:28+08:00][sql] CONNECT:[ UseTime:0.006608s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:25:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001319s ] [2025-11-12T11:25:28+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000438s ] [2025-11-12T11:25:28+08:00][sql] CONNECT:[ UseTime:0.050083s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-11-12T11:25:28+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.033770s ] [2025-11-12T11:25:28+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.074955s ] [2025-11-12T11:25:28+08:00][sql] CONNECT:[ UseTime:0.013184s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:25:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001226s ] [2025-11-12T11:25:28+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000377s ] [2025-11-12T11:25:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000945s ] [2025-11-12T11:25:28+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000325s ] [2025-11-12T11:25:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001021s ] [2025-11-12T11:25:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:20:28' AND '2025-11-12 11:20:28' AND `specuser` = '' LIMIT 1 [ RunTime:0.000414s ] [2025-11-12T11:25:28+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:20:28' AND '2025-11-12 11:20:28' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000449s ] [2025-11-12T11:25:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000869s ] [2025-11-12T11:25:28+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000307s ] [2025-11-12T11:25:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000846s ] [2025-11-12T11:25:28+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000236s ] [2025-11-12T11:25:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000953s ] [2025-11-12T11:25:30+08:00][sql] CONNECT:[ UseTime:0.001467s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:25:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001346s ] [2025-11-12T11:25:30+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000332s ] [2025-11-12T11:25:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001014s ] [2025-11-12T11:25:30+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000372s ] [2025-11-12T11:25:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000985s ] [2025-11-12T11:25:30+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000334s ] [2025-11-12T11:25:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001251s ] [2025-11-12T11:25:30+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000255s ] [2025-11-12T11:25:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001122s ] [2025-11-12T11:25:30+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000365s ] [2025-11-12T11:25:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001074s ] [2025-11-12T11:25:32+08:00][sql] CONNECT:[ UseTime:0.004438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:25:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001352s ] [2025-11-12T11:25:32+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000344s ] [2025-11-12T11:25:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001018s ] [2025-11-12T11:25:32+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000349s ] [2025-11-12T11:25:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000947s ] [2025-11-12T11:25:32+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000304s ] [2025-11-12T11:25:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001172s ] [2025-11-12T11:25:32+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000272s ] [2025-11-12T11:25:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001092s ] [2025-11-12T11:25:32+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000368s ] [2025-11-12T11:25:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001051s ] [2025-11-12T11:25:33+08:00][sql] CONNECT:[ UseTime:0.007543s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:25:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001292s ] [2025-11-12T11:25:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000391s ] [2025-11-12T11:25:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000996s ] [2025-11-12T11:25:33+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000316s ] [2025-11-12T11:25:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001072s ] [2025-11-12T11:25:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:20:33' AND '2025-11-12 11:20:33' AND `specuser` = '' LIMIT 1 [ RunTime:0.000442s ] [2025-11-12T11:25:33+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:20:33' AND '2025-11-12 11:20:33' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000465s ] [2025-11-12T11:25:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000906s ] [2025-11-12T11:25:33+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000331s ] [2025-11-12T11:25:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000915s ] [2025-11-12T11:25:33+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000234s ] [2025-11-12T11:25:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000987s ] [2025-11-12T11:25:34+08:00][sql] CONNECT:[ UseTime:0.001471s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:25:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001403s ] [2025-11-12T11:25:34+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000313s ] [2025-11-12T11:25:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001035s ] [2025-11-12T11:25:34+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000393s ] [2025-11-12T11:25:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000989s ] [2025-11-12T11:25:34+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000368s ] [2025-11-12T11:25:34+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000980s ] [2025-11-12T11:25:34+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000250s ] [2025-11-12T11:25:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001036s ] [2025-11-12T11:25:34+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000335s ] [2025-11-12T11:25:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000960s ] [2025-11-12T11:25:38+08:00][sql] CONNECT:[ UseTime:0.010146s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001283s ] [2025-11-12T11:25:38+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000334s ] [2025-11-12T11:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000990s ] [2025-11-12T11:25:38+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000362s ] [2025-11-12T11:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000957s ] [2025-11-12T11:25:38+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000334s ] [2025-11-12T11:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001057s ] [2025-11-12T11:25:38+08:00][sql] SELECT * FROM `trade` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000246s ] [2025-11-12T11:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001084s ] [2025-11-12T11:25:38+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 133 [ RunTime:0.000352s ] [2025-11-12T11:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001021s ] [2025-11-12T11:27:14+08:00][sql] CONNECT:[ UseTime:0.009270s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:27:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001354s ] [2025-11-12T11:27:14+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000418s ] [2025-11-12T11:27:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001079s ] [2025-11-12T11:27:14+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000353s ] [2025-11-12T11:27:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 LIMIT 1 [ RunTime:0.000260s ] [2025-11-12T11:27:14+08:00][sql] SELECT `mark`,`title` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 ORDER BY `sort` DESC LIMIT 0,100 [ RunTime:0.000273s ] [2025-11-12T11:27:14+08:00][sql] SELECT `mark`,`title`,`content` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.000274s ] [2025-11-12T11:27:17+08:00][sql] CONNECT:[ UseTime:0.011187s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:27:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001241s ] [2025-11-12T11:27:17+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000378s ] [2025-11-12T11:27:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000952s ] [2025-11-12T11:27:17+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000329s ] [2025-11-12T11:27:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001059s ] [2025-11-12T11:27:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:22:17' AND '2025-11-12 11:22:17' AND `specuser` = '' LIMIT 1 [ RunTime:0.000430s ] [2025-11-12T11:27:17+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:22:17' AND '2025-11-12 11:22:17' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000430s ] [2025-11-12T11:27:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000869s ] [2025-11-12T11:27:17+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000314s ] [2025-11-12T11:27:17+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000867s ] [2025-11-12T11:27:17+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000234s ] [2025-11-12T11:27:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000963s ] [2025-11-12T11:28:22+08:00][sql] CONNECT:[ UseTime:0.008585s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001275s ] [2025-11-12T11:28:22+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000368s ] [2025-11-12T11:28:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000995s ] [2025-11-12T11:28:22+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000368s ] [2025-11-12T11:28:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000952s ] [2025-11-12T11:28:22+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000354s ] [2025-11-12T11:28:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001058s ] [2025-11-12T11:28:22+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000242s ] [2025-11-12T11:28:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001101s ] [2025-11-12T11:28:22+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000484s ] [2025-11-12T11:28:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001188s ] [2025-11-12T11:28:24+08:00][sql] CONNECT:[ UseTime:0.012199s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001320s ] [2025-11-12T11:28:24+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000421s ] [2025-11-12T11:28:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001038s ] [2025-11-12T11:28:24+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000344s ] [2025-11-12T11:28:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001144s ] [2025-11-12T11:28:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:23:24' AND '2025-11-12 11:23:24' AND `specuser` = '' LIMIT 1 [ RunTime:0.000464s ] [2025-11-12T11:28:24+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:23:24' AND '2025-11-12 11:23:24' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000483s ] [2025-11-12T11:28:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000931s ] [2025-11-12T11:28:24+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000358s ] [2025-11-12T11:28:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000943s ] [2025-11-12T11:28:24+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000245s ] [2025-11-12T11:28:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001034s ] [2025-11-12T11:28:25+08:00][sql] CONNECT:[ UseTime:0.001757s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001365s ] [2025-11-12T11:28:25+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000349s ] [2025-11-12T11:28:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001023s ] [2025-11-12T11:28:25+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000370s ] [2025-11-12T11:28:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001036s ] [2025-11-12T11:28:25+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000347s ] [2025-11-12T11:28:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000978s ] [2025-11-12T11:28:25+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000246s ] [2025-11-12T11:28:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001127s ] [2025-11-12T11:28:25+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000333s ] [2025-11-12T11:28:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000999s ] [2025-11-12T11:28:26+08:00][sql] CONNECT:[ UseTime:0.007583s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001257s ] [2025-11-12T11:28:26+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000401s ] [2025-11-12T11:28:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000997s ] [2025-11-12T11:28:26+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000343s ] [2025-11-12T11:28:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001110s ] [2025-11-12T11:28:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:23:26' AND '2025-11-12 11:23:26' AND `specuser` = '' LIMIT 1 [ RunTime:0.000428s ] [2025-11-12T11:28:26+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:23:26' AND '2025-11-12 11:23:26' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000464s ] [2025-11-12T11:28:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000926s ] [2025-11-12T11:28:26+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000334s ] [2025-11-12T11:28:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000895s ] [2025-11-12T11:28:26+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000245s ] [2025-11-12T11:28:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001014s ] [2025-11-12T11:28:27+08:00][sql] CONNECT:[ UseTime:0.008936s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001326s ] [2025-11-12T11:28:27+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000320s ] [2025-11-12T11:28:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000995s ] [2025-11-12T11:28:27+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000366s ] [2025-11-12T11:28:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000933s ] [2025-11-12T11:28:27+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000326s ] [2025-11-12T11:28:27+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001182s ] [2025-11-12T11:28:27+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000252s ] [2025-11-12T11:28:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001090s ] [2025-11-12T11:28:27+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000351s ] [2025-11-12T11:28:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001017s ] [2025-11-12T11:28:30+08:00][sql] CONNECT:[ UseTime:0.011238s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001367s ] [2025-11-12T11:28:30+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000318s ] [2025-11-12T11:28:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001028s ] [2025-11-12T11:28:30+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000381s ] [2025-11-12T11:28:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001018s ] [2025-11-12T11:28:30+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000363s ] [2025-11-12T11:28:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000971s ] [2025-11-12T11:28:30+08:00][sql] SELECT * FROM `trade` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000267s ] [2025-11-12T11:28:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001044s ] [2025-11-12T11:28:30+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 133 [ RunTime:0.000346s ] [2025-11-12T11:28:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000970s ] [2025-11-12T11:28:32+08:00][sql] CONNECT:[ UseTime:0.012279s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001281s ] [2025-11-12T11:28:32+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000382s ] [2025-11-12T11:28:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000992s ] [2025-11-12T11:28:32+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000317s ] [2025-11-12T11:28:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001099s ] [2025-11-12T11:28:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:23:32' AND '2025-11-12 11:23:32' AND `specuser` = '' LIMIT 1 [ RunTime:0.000435s ] [2025-11-12T11:28:32+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:23:32' AND '2025-11-12 11:23:32' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000451s ] [2025-11-12T11:28:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000902s ] [2025-11-12T11:28:32+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000337s ] [2025-11-12T11:28:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000909s ] [2025-11-12T11:28:32+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000241s ] [2025-11-12T11:28:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001014s ] [2025-11-12T11:28:42+08:00][sql] CONNECT:[ UseTime:0.008823s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001268s ] [2025-11-12T11:28:42+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000401s ] [2025-11-12T11:28:43+08:00][sql] CONNECT:[ UseTime:0.008778s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001233s ] [2025-11-12T11:28:43+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000372s ] [2025-11-12T11:28:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001154s ] [2025-11-12T11:28:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:23:43' AND '2025-11-12 11:23:43' AND `specuser` = '' LIMIT 1 [ RunTime:0.000437s ] [2025-11-12T11:28:43+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:23:43' AND '2025-11-12 11:23:43' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000447s ] [2025-11-12T11:28:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000883s ] [2025-11-12T11:28:43+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000314s ] [2025-11-12T11:28:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001179s ] [2025-11-12T11:28:43+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000268s ] [2025-11-12T11:28:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001034s ] [2025-11-12T11:28:49+08:00][sql] CONNECT:[ UseTime:0.003414s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001294s ] [2025-11-12T11:28:49+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000399s ] [2025-11-12T11:28:49+08:00][sql] CONNECT:[ UseTime:0.050101s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-11-12T11:28:49+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.033960s ] [2025-11-12T11:28:49+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.075612s ] [2025-11-12T11:28:49+08:00][sql] CONNECT:[ UseTime:0.004580s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001327s ] [2025-11-12T11:28:49+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000409s ] [2025-11-12T11:28:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001026s ] [2025-11-12T11:28:49+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000359s ] [2025-11-12T11:28:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001129s ] [2025-11-12T11:28:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:23:49' AND '2025-11-12 11:23:49' AND `specuser` = '' LIMIT 1 [ RunTime:0.000431s ] [2025-11-12T11:28:49+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:23:49' AND '2025-11-12 11:23:49' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000481s ] [2025-11-12T11:28:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000915s ] [2025-11-12T11:28:49+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000321s ] [2025-11-12T11:28:49+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000892s ] [2025-11-12T11:28:49+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000246s ] [2025-11-12T11:28:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001031s ] [2025-11-12T11:28:52+08:00][sql] CONNECT:[ UseTime:0.011126s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001304s ] [2025-11-12T11:28:52+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000341s ] [2025-11-12T11:28:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000977s ] [2025-11-12T11:28:52+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000365s ] [2025-11-12T11:28:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000948s ] [2025-11-12T11:28:52+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000335s ] [2025-11-12T11:28:52+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001069s ] [2025-11-12T11:28:52+08:00][sql] SELECT * FROM `trade` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000255s ] [2025-11-12T11:28:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001104s ] [2025-11-12T11:28:52+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 133 [ RunTime:0.000356s ] [2025-11-12T11:28:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001036s ] [2025-11-12T11:28:55+08:00][sql] CONNECT:[ UseTime:0.009854s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001385s ] [2025-11-12T11:28:55+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000330s ] [2025-11-12T11:28:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001010s ] [2025-11-12T11:28:55+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000366s ] [2025-11-12T11:28:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000955s ] [2025-11-12T11:28:55+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000338s ] [2025-11-12T11:28:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001041s ] [2025-11-12T11:28:55+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000241s ] [2025-11-12T11:28:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001070s ] [2025-11-12T11:28:55+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000359s ] [2025-11-12T11:28:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000979s ] [2025-11-12T11:28:56+08:00][sql] CONNECT:[ UseTime:0.009334s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:28:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001213s ] [2025-11-12T11:28:56+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000299s ] [2025-11-12T11:28:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000949s ] [2025-11-12T11:28:56+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000364s ] [2025-11-12T11:28:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000904s ] [2025-11-12T11:28:56+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000319s ] [2025-11-12T11:28:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001171s ] [2025-11-12T11:28:56+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000259s ] [2025-11-12T11:28:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001090s ] [2025-11-12T11:28:56+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000359s ] [2025-11-12T11:28:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001099s ] [2025-11-12T11:29:45+08:00][sql] CONNECT:[ UseTime:0.015503s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:29:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001404s ] [2025-11-12T11:29:45+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000346s ] [2025-11-12T11:29:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001046s ] [2025-11-12T11:29:45+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000373s ] [2025-11-12T11:29:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001009s ] [2025-11-12T11:29:45+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000325s ] [2025-11-12T11:29:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001046s ] [2025-11-12T11:29:45+08:00][sql] SELECT * FROM `trade` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000251s ] [2025-11-12T11:29:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001159s ] [2025-11-12T11:29:45+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 133 [ RunTime:0.000352s ] [2025-11-12T11:29:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001077s ] [2025-11-12T11:29:47+08:00][sql] CONNECT:[ UseTime:0.003683s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001226s ] [2025-11-12T11:29:47+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000388s ] [2025-11-12T11:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000951s ] [2025-11-12T11:29:47+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000356s ] [2025-11-12T11:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001058s ] [2025-11-12T11:29:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:24:47' AND '2025-11-12 11:24:47' AND `specuser` = '' LIMIT 1 [ RunTime:0.000397s ] [2025-11-12T11:29:47+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:24:47' AND '2025-11-12 11:24:47' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000420s ] [2025-11-12T11:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000877s ] [2025-11-12T11:29:47+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000318s ] [2025-11-12T11:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000878s ] [2025-11-12T11:29:47+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000232s ] [2025-11-12T11:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000965s ] [2025-11-12T11:29:49+08:00][sql] CONNECT:[ UseTime:0.013836s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:29:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001246s ] [2025-11-12T11:29:49+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000312s ] [2025-11-12T11:29:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000931s ] [2025-11-12T11:29:49+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000339s ] [2025-11-12T11:29:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000887s ] [2025-11-12T11:29:49+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000306s ] [2025-11-12T11:29:49+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001152s ] [2025-11-12T11:29:49+08:00][sql] SELECT * FROM `trade` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000249s ] [2025-11-12T11:29:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001164s ] [2025-11-12T11:29:49+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 133 [ RunTime:0.000351s ] [2025-11-12T11:29:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001106s ] [2025-11-12T11:29:52+08:00][sql] CONNECT:[ UseTime:0.015764s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:29:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001338s ] [2025-11-12T11:29:52+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000428s ] [2025-11-12T11:29:53+08:00][sql] CONNECT:[ UseTime:0.014207s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:29:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001216s ] [2025-11-12T11:29:53+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000394s ] [2025-11-12T11:29:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001191s ] [2025-11-12T11:29:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:24:53' AND '2025-11-12 11:24:53' AND `specuser` = '' LIMIT 1 [ RunTime:0.000438s ] [2025-11-12T11:29:53+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:24:53' AND '2025-11-12 11:24:53' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000468s ] [2025-11-12T11:29:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000943s ] [2025-11-12T11:29:53+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000328s ] [2025-11-12T11:29:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000884s ] [2025-11-12T11:29:53+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000237s ] [2025-11-12T11:29:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001029s ] [2025-11-12T11:29:58+08:00][sql] CONNECT:[ UseTime:0.015827s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:29:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001270s ] [2025-11-12T11:29:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000390s ] [2025-11-12T11:29:58+08:00][sql] CONNECT:[ UseTime:0.049307s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-11-12T11:29:58+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.033196s ] [2025-11-12T11:29:58+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.074981s ] [2025-11-12T11:29:58+08:00][sql] CONNECT:[ UseTime:0.009053s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:29:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001286s ] [2025-11-12T11:29:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000375s ] [2025-11-12T11:29:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001009s ] [2025-11-12T11:29:58+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000360s ] [2025-11-12T11:29:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001128s ] [2025-11-12T11:29:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:24:58' AND '2025-11-12 11:24:58' AND `specuser` = '' LIMIT 1 [ RunTime:0.000442s ] [2025-11-12T11:29:58+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:24:58' AND '2025-11-12 11:24:58' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000469s ] [2025-11-12T11:29:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000941s ] [2025-11-12T11:29:58+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000326s ] [2025-11-12T11:29:58+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000915s ] [2025-11-12T11:29:58+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000240s ] [2025-11-12T11:29:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001030s ] [2025-11-12T11:30:00+08:00][sql] CONNECT:[ UseTime:0.009978s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:30:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001335s ] [2025-11-12T11:30:00+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000318s ] [2025-11-12T11:30:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000995s ] [2025-11-12T11:30:00+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000352s ] [2025-11-12T11:30:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000933s ] [2025-11-12T11:30:00+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000340s ] [2025-11-12T11:30:00+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001187s ] [2025-11-12T11:30:00+08:00][sql] SELECT * FROM `trade` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000262s ] [2025-11-12T11:30:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001099s ] [2025-11-12T11:30:00+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 133 [ RunTime:0.000359s ] [2025-11-12T11:30:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001029s ] [2025-11-12T11:30:02+08:00][sql] CONNECT:[ UseTime:0.013071s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001215s ] [2025-11-12T11:30:02+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000303s ] [2025-11-12T11:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000931s ] [2025-11-12T11:30:02+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000334s ] [2025-11-12T11:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000910s ] [2025-11-12T11:30:02+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000335s ] [2025-11-12T11:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001197s ] [2025-11-12T11:30:02+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000256s ] [2025-11-12T11:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001098s ] [2025-11-12T11:30:02+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000371s ] [2025-11-12T11:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001055s ] [2025-11-12T11:30:04+08:00][sql] CONNECT:[ UseTime:0.001437s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:30:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001332s ] [2025-11-12T11:30:04+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000326s ] [2025-11-12T11:30:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000977s ] [2025-11-12T11:30:04+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000385s ] [2025-11-12T11:30:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000970s ] [2025-11-12T11:30:04+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000328s ] [2025-11-12T11:30:04+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001060s ] [2025-11-12T11:30:04+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000273s ] [2025-11-12T11:30:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001091s ] [2025-11-12T11:30:04+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000360s ] [2025-11-12T11:30:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001047s ] [2025-11-12T11:30:05+08:00][sql] CONNECT:[ UseTime:0.004259s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:30:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001256s ] [2025-11-12T11:30:05+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000390s ] [2025-11-12T11:30:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000974s ] [2025-11-12T11:30:05+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000318s ] [2025-11-12T11:30:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001073s ] [2025-11-12T11:30:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:05' AND '2025-11-12 11:25:05' AND `specuser` = '' LIMIT 1 [ RunTime:0.000445s ] [2025-11-12T11:30:05+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:05' AND '2025-11-12 11:25:05' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000446s ] [2025-11-12T11:30:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000868s ] [2025-11-12T11:30:05+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000304s ] [2025-11-12T11:30:05+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000845s ] [2025-11-12T11:30:05+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000235s ] [2025-11-12T11:30:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000979s ] [2025-11-12T11:30:07+08:00][sql] CONNECT:[ UseTime:0.007189s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001380s ] [2025-11-12T11:30:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000435s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001070s ] [2025-11-12T11:30:07+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000357s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001179s ] [2025-11-12T11:30:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:07' AND '2025-11-12 11:25:07' AND `specuser` = '' LIMIT 1 [ RunTime:0.000449s ] [2025-11-12T11:30:07+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:07' AND '2025-11-12 11:25:07' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000489s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000973s ] [2025-11-12T11:30:07+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000333s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000948s ] [2025-11-12T11:30:07+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000235s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001064s ] [2025-11-12T11:30:07+08:00][sql] CONNECT:[ UseTime:0.004323s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001288s ] [2025-11-12T11:30:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000399s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001013s ] [2025-11-12T11:30:07+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000331s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001136s ] [2025-11-12T11:30:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:07' AND '2025-11-12 11:25:07' AND `specuser` = '' LIMIT 1 [ RunTime:0.000437s ] [2025-11-12T11:30:07+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:07' AND '2025-11-12 11:25:07' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000450s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000941s ] [2025-11-12T11:30:07+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000346s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000932s ] [2025-11-12T11:30:07+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000237s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001061s ] [2025-11-12T11:30:07+08:00][sql] CONNECT:[ UseTime:0.003952s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001379s ] [2025-11-12T11:30:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000443s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001008s ] [2025-11-12T11:30:07+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000342s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001100s ] [2025-11-12T11:30:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:07' AND '2025-11-12 11:25:07' AND `specuser` = '' LIMIT 1 [ RunTime:0.000434s ] [2025-11-12T11:30:07+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:07' AND '2025-11-12 11:25:07' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000469s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000909s ] [2025-11-12T11:30:07+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000307s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000887s ] [2025-11-12T11:30:07+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000231s ] [2025-11-12T11:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001026s ] [2025-11-12T11:30:08+08:00][sql] CONNECT:[ UseTime:0.008251s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001222s ] [2025-11-12T11:30:08+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000381s ] [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000943s ] [2025-11-12T11:30:08+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000314s ] [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001046s ] [2025-11-12T11:30:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:08' AND '2025-11-12 11:25:08' AND `specuser` = '' LIMIT 1 [ RunTime:0.000410s ] [2025-11-12T11:30:08+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:08' AND '2025-11-12 11:25:08' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000437s ] [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000893s ] [2025-11-12T11:30:08+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000317s ] [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000855s ] [2025-11-12T11:30:08+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000227s ] [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000965s ] [2025-11-12T11:30:08+08:00][sql] CONNECT:[ UseTime:0.005317s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001259s ] [2025-11-12T11:30:08+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000393s ] [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000998s ] [2025-11-12T11:30:08+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000341s ] [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001092s ] [2025-11-12T11:30:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:08' AND '2025-11-12 11:25:08' AND `specuser` = '' LIMIT 1 [ RunTime:0.000419s ] [2025-11-12T11:30:08+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:25:08' AND '2025-11-12 11:25:08' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000533s ] [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000953s ] [2025-11-12T11:30:08+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000342s ] [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000910s ] [2025-11-12T11:30:08+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000248s ] [2025-11-12T11:30:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001004s ] [2025-11-12T11:30:11+08:00][sql] CONNECT:[ UseTime:0.010423s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001316s ] [2025-11-12T11:30:11+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000311s ] [2025-11-12T11:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000983s ] [2025-11-12T11:30:11+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000348s ] [2025-11-12T11:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000932s ] [2025-11-12T11:30:11+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000346s ] [2025-11-12T11:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001177s ] [2025-11-12T11:30:11+08:00][sql] SELECT * FROM `trade` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000251s ] [2025-11-12T11:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001082s ] [2025-11-12T11:30:11+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 133 [ RunTime:0.000350s ] [2025-11-12T11:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001036s ] [2025-11-12T11:30:12+08:00][sql] CONNECT:[ UseTime:0.010460s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:30:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001276s ] [2025-11-12T11:30:12+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000344s ] [2025-11-12T11:30:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000985s ] [2025-11-12T11:30:12+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000344s ] [2025-11-12T11:30:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000951s ] [2025-11-12T11:30:12+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000333s ] [2025-11-12T11:30:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001033s ] [2025-11-12T11:30:12+08:00][sql] SELECT * FROM `trade` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000258s ] [2025-11-12T11:30:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001094s ] [2025-11-12T11:30:12+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 133 [ RunTime:0.000352s ] [2025-11-12T11:30:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001016s ] [2025-11-12T11:31:12+08:00][sql] CONNECT:[ UseTime:0.002147s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:31:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001218s ] [2025-11-12T11:31:12+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000366s ] [2025-11-12T11:31:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000958s ] [2025-11-12T11:31:12+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000327s ] [2025-11-12T11:31:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001052s ] [2025-11-12T11:31:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:26:12' AND '2025-11-12 11:26:12' AND `specuser` = '' LIMIT 1 [ RunTime:0.000403s ] [2025-11-12T11:31:12+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:26:12' AND '2025-11-12 11:26:12' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000464s ] [2025-11-12T11:31:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000898s ] [2025-11-12T11:31:12+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000313s ] [2025-11-12T11:31:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000871s ] [2025-11-12T11:31:12+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000227s ] [2025-11-12T11:31:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000957s ] [2025-11-12T11:31:14+08:00][sql] CONNECT:[ UseTime:0.004089s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:31:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001231s ] [2025-11-12T11:31:14+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000331s ] [2025-11-12T11:31:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000970s ] [2025-11-12T11:31:14+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000343s ] [2025-11-12T11:31:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000957s ] [2025-11-12T11:31:14+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000311s ] [2025-11-12T11:31:14+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001249s ] [2025-11-12T11:31:14+08:00][sql] SELECT * FROM `trade` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000268s ] [2025-11-12T11:31:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001135s ] [2025-11-12T11:31:14+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 133 [ RunTime:0.000370s ] [2025-11-12T11:31:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001068s ] [2025-11-12T11:31:18+08:00][sql] CONNECT:[ UseTime:0.008938s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:31:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001327s ] [2025-11-12T11:31:18+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000424s ] [2025-11-12T11:31:19+08:00][sql] CONNECT:[ UseTime:0.013571s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:31:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001311s ] [2025-11-12T11:31:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000398s ] [2025-11-12T11:31:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001157s ] [2025-11-12T11:31:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:26:19' AND '2025-11-12 11:26:19' AND `specuser` = '' LIMIT 1 [ RunTime:0.000425s ] [2025-11-12T11:31:19+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:26:19' AND '2025-11-12 11:26:19' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000601s ] [2025-11-12T11:31:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001018s ] [2025-11-12T11:31:19+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000359s ] [2025-11-12T11:31:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000916s ] [2025-11-12T11:31:19+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000233s ] [2025-11-12T11:31:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001053s ] [2025-11-12T11:31:24+08:00][sql] CONNECT:[ UseTime:0.007196s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:31:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001376s ] [2025-11-12T11:31:24+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000424s ] [2025-11-12T11:31:24+08:00][sql] CONNECT:[ UseTime:0.050829s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-11-12T11:31:24+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.034183s ] [2025-11-12T11:31:24+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.075257s ] [2025-11-12T11:31:25+08:00][sql] CONNECT:[ UseTime:0.010084s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:31:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001206s ] [2025-11-12T11:31:25+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000379s ] [2025-11-12T11:31:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000946s ] [2025-11-12T11:31:25+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000347s ] [2025-11-12T11:31:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001052s ] [2025-11-12T11:31:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:26:25' AND '2025-11-12 11:26:25' AND `specuser` = '' LIMIT 1 [ RunTime:0.000399s ] [2025-11-12T11:31:25+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:26:25' AND '2025-11-12 11:26:25' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000443s ] [2025-11-12T11:31:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000870s ] [2025-11-12T11:31:25+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (133,132) GROUP BY `tid` [ RunTime:0.000305s ] [2025-11-12T11:31:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000861s ] [2025-11-12T11:31:25+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (133,132) [ RunTime:0.000244s ] [2025-11-12T11:31:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000969s ] [2025-11-12T11:31:26+08:00][sql] CONNECT:[ UseTime:0.002591s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001289s ] [2025-11-12T11:31:26+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000319s ] [2025-11-12T11:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000974s ] [2025-11-12T11:31:26+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000364s ] [2025-11-12T11:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000954s ] [2025-11-12T11:31:26+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000339s ] [2025-11-12T11:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001058s ] [2025-11-12T11:31:26+08:00][sql] SELECT * FROM `trade` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000246s ] [2025-11-12T11:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001058s ] [2025-11-12T11:31:26+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 133 [ RunTime:0.000365s ] [2025-11-12T11:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000995s ] [2025-11-12T11:31:28+08:00][sql] CONNECT:[ UseTime:0.011123s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:31:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001230s ] [2025-11-12T11:31:28+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000304s ] [2025-11-12T11:31:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000964s ] [2025-11-12T11:31:28+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000337s ] [2025-11-12T11:31:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000906s ] [2025-11-12T11:31:28+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000302s ] [2025-11-12T11:31:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001197s ] [2025-11-12T11:31:28+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000260s ] [2025-11-12T11:31:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001079s ] [2025-11-12T11:31:28+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000350s ] [2025-11-12T11:31:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001034s ] [2025-11-12T11:31:42+08:00][sql] CONNECT:[ UseTime:0.013958s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001333s ] [2025-11-12T11:31:42+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000337s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000990s ] [2025-11-12T11:31:42+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000360s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000987s ] [2025-11-12T11:31:42+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000332s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001106s ] [2025-11-12T11:31:42+08:00][sql] SELECT * FROM `trade` WHERE `id` = 132 LIMIT 1 [ RunTime:0.000288s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001091s ] [2025-11-12T11:31:42+08:00][sql] SELECT * FROM `trade_role` WHERE `tid` = 132 [ RunTime:0.000371s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001038s ] [2025-11-12T11:31:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE `orderno` = 'R2025111211314232272853' LIMIT 1 [ RunTime:0.000284s ] [2025-11-12T11:31:42+08:00][sql] INSERT INTO `trade_order` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 132 , `orderno` = 'R2025111211314232272853' , `relationid` = 70 , `ordertype` = 1 , `charge` = '30' , `price` = '50.00' , `amount` = '20.00' , `tousername` = 'ctshaiya008' , `addtime` = 1762918302 , `order_details` = '{\"chaid\":394735,\"chaname\":\"tty\",\"job\":3,\"outtime\":1762920905,\"sync_tradeno\":\"7415551131520139264\",\"username\":\"ctshaiya001\"}' [ RunTime:0.000318s ] [2025-11-12T11:31:42+08:00][sql] UPDATE `trade_role` SET `trade_status` = 3 , `pay_status` = 1 , `orderno` = 'R2025111211314232272853' WHERE `id` = 70 [ RunTime:0.000268s ] [2025-11-12T11:31:42+08:00][sql] CONNECT:[ UseTime:0.008375s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001230s ] [2025-11-12T11:31:42+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000394s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001004s ] [2025-11-12T11:31:42+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000348s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001050s ] [2025-11-12T11:31:42+08:00][sql] SELECT * FROM `trade_order` WHERE `orderno` = 'R2025111211314232272853' AND `tousername` = 'ctshaiya008' LIMIT 1 [ RunTime:0.000285s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001093s ] [2025-11-12T11:31:42+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`job`,`grow`,`specuser`,`chaid`,`chaname`,`chalv`,`kill`,`family`,`price`,`created_at`,`trade_status`,`pay_status`,`money` FROM `trade_role` WHERE `id` = 70 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000302s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000886s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001088s ] [2025-11-12T11:31:42+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` = 'shaiya5' AND `serverid` = 5 AND `tid` = 132 [ RunTime:0.000352s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001183s ] [2025-11-12T11:31:42+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` = 'shaiya5' AND `serverid` = 5 AND `tid` = 132 [ RunTime:0.000384s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001136s ] [2025-11-12T11:31:42+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` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 13003 [ RunTime:0.037927s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000917s ] [2025-11-12T11:31:42+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 132 [ RunTime:0.000304s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001036s ] [2025-11-12T11:31:42+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` = 'shaiya5' AND `serverid` = 5 AND `tid` = 132 [ RunTime:0.000319s ] [2025-11-12T11:31:42+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`godid` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `godid` = 210401 [ RunTime:0.000321s ] [2025-11-12T11:31:42+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`skillid` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `skillid` = 1 [ RunTime:0.000324s ] [2025-11-12T11:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000934s ] [2025-11-12T11:31:42+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 132 [ RunTime:0.000296s ] [2025-11-12T11:31:42+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 132 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000236s ] [2025-11-12T11:47:19+08:00][sql] CONNECT:[ UseTime:0.001456s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:47:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001404s ] [2025-11-12T11:47:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000430s ] [2025-11-12T11:47:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001003s ] [2025-11-12T11:47:19+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000366s ] [2025-11-12T11:47:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001152s ] [2025-11-12T11:47:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:42:19' AND '2025-11-12 11:42:19' AND `specuser` = '' LIMIT 1 [ RunTime:0.000449s ] [2025-11-12T11:47:19+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-11-12 10:42:19' AND '2025-11-12 11:42:19' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000493s ] [2025-11-12T11:47:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001057s ] [2025-11-12T11:47:19+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 133 GROUP BY `tid` [ RunTime:0.000304s ] [2025-11-12T11:47:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000943s ] [2025-11-12T11:47:19+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 133 [ RunTime:0.000220s ] [2025-11-12T11:47:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001060s ] [2025-11-12T11:47:21+08:00][sql] CONNECT:[ UseTime:0.004604s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:47:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001308s ] [2025-11-12T11:47:21+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000410s ] [2025-11-12T11:47:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001004s ] [2025-11-12T11:47:21+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000348s ] [2025-11-12T11:47:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 LIMIT 1 [ RunTime:0.000248s ] [2025-11-12T11:47:21+08:00][sql] SELECT `mark`,`title` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 ORDER BY `sort` DESC LIMIT 0,100 [ RunTime:0.000249s ] [2025-11-12T11:47:21+08:00][sql] SELECT `mark`,`title`,`content` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.000277s ] [2025-11-12T11:47:23+08:00][sql] CONNECT:[ UseTime:0.014493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:47:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001348s ] [2025-11-12T11:47:23+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000415s ] [2025-11-12T11:47:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001075s ] [2025-11-12T11:47:23+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000362s ] [2025-11-12T11:47:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 LIMIT 1 [ RunTime:0.000284s ] [2025-11-12T11:47:23+08:00][sql] SELECT `mark`,`title` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 ORDER BY `sort` DESC LIMIT 0,100 [ RunTime:0.000276s ] [2025-11-12T11:47:23+08:00][sql] SELECT `mark`,`title`,`content` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `mark` = 'izLQfwsKonFGeUtjxaKpHaNabUYDhqKS' ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.000249s ] [2025-11-12T11:47:25+08:00][sql] CONNECT:[ UseTime:0.007910s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T11:47:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001257s ] [2025-11-12T11:47:25+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000382s ] [2025-11-12T11:47:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000990s ] [2025-11-12T11:47:25+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000332s ] [2025-11-12T11:47:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 LIMIT 1 [ RunTime:0.000253s ] [2025-11-12T11:47:25+08:00][sql] SELECT `mark`,`title` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 ORDER BY `sort` DESC LIMIT 0,100 [ RunTime:0.000247s ] [2025-11-12T11:47:25+08:00][sql] SELECT `mark`,`title`,`content` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `mark` = 'XvbLGKguBTutsPpEiaTwjfjZxJndeSYp' ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.000266s ] [2025-11-12T12:39:58+08:00][sql] CONNECT:[ UseTime:0.001454s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T12:39:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001353s ] [2025-11-12T12:39:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000461s ] [2025-11-12T12:39:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001019s ] [2025-11-12T12:39:58+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000207s ] [2025-11-12T12:59:55+08:00][sql] CONNECT:[ UseTime:0.001470s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T12:59:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001399s ] [2025-11-12T12:59:55+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000446s ] [2025-11-12T12:59:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001051s ] [2025-11-12T12:59:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = '' AND `serverid` = 0 AND `username` = '' AND `created_at` >= '2025-08-14 12:59:55' LIMIT 1 [ RunTime:0.000307s ] [2025-11-12T16:44:46+08:00][sql] CONNECT:[ UseTime:0.001485s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T16:44:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001252s ] [2025-11-12T16:44:46+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000388s ] [2025-11-12T16:44:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000933s ] [2025-11-12T16:44:46+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000222s ] [2025-11-12T16:52:20+08:00][sql] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T16:52:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001443s ] [2025-11-12T16:52:20+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000419s ] [2025-11-12T16:52:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001028s ] [2025-11-12T16:52:20+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000213s ] [2025-11-12T16:52:22+08:00][sql] CONNECT:[ UseTime:0.003012s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-12T16:52:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001282s ] [2025-11-12T16:52:22+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000439s ] [2025-11-12T16:52:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001012s ] [2025-11-12T16:52:22+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000238s ]