[2025-09-02T09:37:45+08:00][sql] CONNECT:[ UseTime:0.001470s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T09:37:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001377s ]
[2025-09-02T09:37:45+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.000397s ]
[2025-09-02T09:37:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001047s ]
[2025-09-02T09:37:45+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000231s ]
[2025-09-02T13:16:18+08:00][sql] CONNECT:[ UseTime:0.001608s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T13:16:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001477s ]
[2025-09-02T13:16: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.000404s ]
[2025-09-02T13:16:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001004s ]
[2025-09-02T13:16:18+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000227s ]
[2025-09-02T17:06:09+08:00][sql] CONNECT:[ UseTime:0.010831s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:06:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001357s ]
[2025-09-02T17:06:09+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.000390s ]
[2025-09-02T17:06:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001034s ]
[2025-09-02T17:06:09+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000275s ]
[2025-09-02T17:06:10+08:00][sql] CONNECT:[ UseTime:0.010365s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:06:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001295s ]
[2025-09-02T17:06:10+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.000427s ]
[2025-09-02T17:06:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001022s ]
[2025-09-02T17:06:10+08:00][sql] SELECT * FROM `trade_game` WHERE  `code` = '116dbfb732616492e66bc9c04e703fd8'  AND `status` = 1 LIMIT 1 [ RunTime:0.000277s ]
[2025-09-02T17:06:10+08:00][sql] CONNECT:[ UseTime:0.001369s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:06:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001197s ]
[2025-09-02T17:06:10+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.000387s ]
[2025-09-02T17:06:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001232s ]
[2025-09-02T17:06:10+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-09-02 16:01:10' AND '2025-09-02 17:01:10'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000522s ]
[2025-09-02T17:06:12+08:00][sql] CONNECT:[ UseTime:0.001449s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:06:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001271s ]
[2025-09-02T17:06: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.000389s ]
[2025-09-02T17:06:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001169s ]
[2025-09-02T17:06: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` >= '2025-09-02 17:01:12' LIMIT 1 [ RunTime:0.000402s ]
[2025-09-02T17:06:14+08:00][sql] CONNECT:[ UseTime:0.011315s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:06:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001290s ]
[2025-09-02T17:06: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.000403s ]
[2025-09-02T17:06:14+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001014s ]
[2025-09-02T17:06:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = ''  AND `created_at` >= '2025-06-04 17:06:14' LIMIT 1 [ RunTime:0.000462s ]
[2025-09-02T17:32:19+08:00][sql] CONNECT:[ UseTime:0.010533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:32:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001383s ]
[2025-09-02T17:32: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.000423s ]
[2025-09-02T17:32:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001187s ]
[2025-09-02T17:32: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-09-02 16:27:19' AND '2025-09-02 17:27:19'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000435s ]
[2025-09-02T17:32:21+08:00][sql] CONNECT:[ UseTime:0.011064s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:32:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001319s ]
[2025-09-02T17:32: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.000382s ]
[2025-09-02T17:32:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001198s ]
[2025-09-02T17:32:21+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-09-02 17:27:21' LIMIT 1 [ RunTime:0.000409s ]
[2025-09-02T17:32:21+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` >= '2025-09-02 17:27:21' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000443s ]
[2025-09-02T17:32:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000970s ]
[2025-09-02T17:32:21+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 86 GROUP BY `tid` [ RunTime:0.000292s ]
[2025-09-02T17:32:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000892s ]
[2025-09-02T17:32:21+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 86 [ RunTime:0.000230s ]
[2025-09-02T17:32:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001031s ]
[2025-09-02T17:32:28+08:00][sql] CONNECT:[ UseTime:0.011504s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001307s ]
[2025-09-02T17:32: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.000403s ]
[2025-09-02T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001196s ]
[2025-09-02T17:32: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` >= '2025-09-02 17:27:28' LIMIT 1 [ RunTime:0.000422s ]
[2025-09-02T17:32: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` >= '2025-09-02 17:27:28' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000433s ]
[2025-09-02T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000916s ]
[2025-09-02T17:32:28+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 86 GROUP BY `tid` [ RunTime:0.000323s ]
[2025-09-02T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000913s ]
[2025-09-02T17:32:28+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 86 [ RunTime:0.000241s ]
[2025-09-02T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001066s ]
[2025-09-02T17:42:02+08:00][sql] CONNECT:[ UseTime:0.011203s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001363s ]
[2025-09-02T17:42: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.000479s ]
[2025-09-02T17:42:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001412s ]
[2025-09-02T17:42:02+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-09-02 17:37:02' LIMIT 1 [ RunTime:0.000529s ]
[2025-09-02T17:42:03+08:00][sql] CONNECT:[ UseTime:0.010933s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001368s ]
[2025-09-02T17:42:03+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-09-02T17:42:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001293s ]
[2025-09-02T17:42:03+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-09-02 17:37:03' LIMIT 1 [ RunTime:0.000451s ]
[2025-09-02T17:42:03+08:00][sql] CONNECT:[ UseTime:0.010911s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001338s ]
[2025-09-02T17:42:03+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-09-02T17:42:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001191s ]
[2025-09-02T17:42:03+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-09-02 17:37:03' LIMIT 1 [ RunTime:0.000402s ]
[2025-09-02T17:42:04+08:00][sql] CONNECT:[ UseTime:0.002303s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001345s ]
[2025-09-02T17:42: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.000396s ]
[2025-09-02T17:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001202s ]
[2025-09-02T17:42: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-09-02 16:37:04' AND '2025-09-02 17:37:04'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000412s ]
[2025-09-02T17:42:04+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-09-02 16:37:04' AND '2025-09-02 17:37:04'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000440s ]
[2025-09-02T17:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000924s ]
[2025-09-02T17:42:04+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 86 GROUP BY `tid` [ RunTime:0.000312s ]
[2025-09-02T17:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000901s ]
[2025-09-02T17:42:04+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 86 [ RunTime:0.000242s ]
[2025-09-02T17:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001022s ]
[2025-09-02T17:42:06+08:00][sql] CONNECT:[ UseTime:0.010944s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001371s ]
[2025-09-02T17:42:06+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-09-02T17:42:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001222s ]
[2025-09-02T17:42:06+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-09-02 16:37:06' AND '2025-09-02 17:37:06'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000468s ]
[2025-09-02T17:42:06+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-09-02 16:37:06' AND '2025-09-02 17:37:06'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000488s ]
[2025-09-02T17:42:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000958s ]
[2025-09-02T17:42:06+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 86 GROUP BY `tid` [ RunTime:0.000362s ]
[2025-09-02T17:42:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001006s ]
[2025-09-02T17:42:06+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 86 [ RunTime:0.000256s ]
[2025-09-02T17:42:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001112s ]
[2025-09-02T17:42:07+08:00][sql] CONNECT:[ UseTime:0.001466s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001365s ]
[2025-09-02T17:42: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.000449s ]
[2025-09-02T17:42:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001268s ]
[2025-09-02T17:42: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` >= '2025-09-02 17:37:07' LIMIT 1 [ RunTime:0.000449s ]
[2025-09-02T17:42:08+08:00][sql] CONNECT:[ UseTime:0.010871s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001355s ]
[2025-09-02T17:42: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.000378s ]
[2025-09-02T17:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001281s ]
[2025-09-02T17:42: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` >= '2025-09-02 17:37:08' LIMIT 1 [ RunTime:0.000450s ]
[2025-09-02T17:42:09+08:00][sql] CONNECT:[ UseTime:0.011525s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001416s ]
[2025-09-02T17:42:09+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.000458s ]
[2025-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001233s ]
[2025-09-02T17:42:09+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-09-02 17:37:09' LIMIT 1 [ RunTime:0.000454s ]
[2025-09-02T17:42:09+08:00][sql] CONNECT:[ UseTime:0.011346s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001274s ]
[2025-09-02T17:42:09+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-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001162s ]
[2025-09-02T17:42:09+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-09-02 17:37:09' LIMIT 1 [ RunTime:0.000386s ]
[2025-09-02T17:42:09+08:00][sql] CONNECT:[ UseTime:0.001423s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001298s ]
[2025-09-02T17:42:09+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.000450s ]
[2025-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001211s ]
[2025-09-02T17:42:09+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-09-02 17:37:09' LIMIT 1 [ RunTime:0.000416s ]
[2025-09-02T17:42:09+08:00][sql] CONNECT:[ UseTime:0.001338s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001182s ]
[2025-09-02T17:42:09+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-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001230s ]
[2025-09-02T17:42:09+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-09-02 17:37:09' LIMIT 1 [ RunTime:0.000443s ]
[2025-09-02T17:42:09+08:00][sql] CONNECT:[ UseTime:0.011306s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001304s ]
[2025-09-02T17:42:09+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.000447s ]
[2025-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001242s ]
[2025-09-02T17:42:09+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-09-02 17:37:09' LIMIT 1 [ RunTime:0.000419s ]
[2025-09-02T17:42:09+08:00][sql] CONNECT:[ UseTime:0.011085s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001100s ]
[2025-09-02T17:42:09+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-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001140s ]
[2025-09-02T17:42:09+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-09-02 17:37:09' LIMIT 1 [ RunTime:0.000392s ]
[2025-09-02T17:42:09+08:00][sql] CONNECT:[ UseTime:0.011509s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001250s ]
[2025-09-02T17:42:09+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-09-02T17:42:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001191s ]
[2025-09-02T17:42:09+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-09-02 17:37:09' LIMIT 1 [ RunTime:0.000420s ]
[2025-09-02T17:42:10+08:00][sql] CONNECT:[ UseTime:0.001358s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001220s ]
[2025-09-02T17:42:10+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.000417s ]
[2025-09-02T17:42:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001206s ]
[2025-09-02T17:42:10+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-09-02 17:37:10' LIMIT 1 [ RunTime:0.000414s ]
[2025-09-02T17:42:10+08:00][sql] CONNECT:[ UseTime:0.011284s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001218s ]
[2025-09-02T17:42:10+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-09-02T17:42:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001228s ]
[2025-09-02T17:42:10+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-09-02 17:37:10' LIMIT 1 [ RunTime:0.000434s ]
[2025-09-02T17:42:10+08:00][sql] CONNECT:[ UseTime:0.001340s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001181s ]
[2025-09-02T17:42:10+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.000367s ]
[2025-09-02T17:42:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001258s ]
[2025-09-02T17:42:10+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-09-02 17:37:10' LIMIT 1 [ RunTime:0.000455s ]
[2025-09-02T17:42:43+08:00][sql] CONNECT:[ UseTime:0.010722s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001284s ]
[2025-09-02T17:42: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.000411s ]
[2025-09-02T17:42:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001158s ]
[2025-09-02T17:42: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` >= '2025-09-02 17:37:43' LIMIT 1 [ RunTime:0.000404s ]
[2025-09-02T17:42:43+08:00][sql] CONNECT:[ UseTime:0.010479s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001465s ]
[2025-09-02T17:42: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.000470s ]
[2025-09-02T17:42:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001267s ]
[2025-09-02T17:42: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` >= '2025-09-02 17:37:43' LIMIT 1 [ RunTime:0.000476s ]
[2025-09-02T17:42:43+08:00][sql] CONNECT:[ UseTime:0.001506s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001363s ]
[2025-09-02T17:42: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.000378s ]
[2025-09-02T17:42:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001313s ]
[2025-09-02T17:42: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` >= '2025-09-02 17:37:43' LIMIT 1 [ RunTime:0.000401s ]
[2025-09-02T17:42:44+08:00][sql] CONNECT:[ UseTime:0.011017s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001444s ]
[2025-09-02T17:42:44+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.000466s ]
[2025-09-02T17:42:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001271s ]
[2025-09-02T17:42:44+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-09-02 17:37:44' LIMIT 1 [ RunTime:0.000470s ]
[2025-09-02T17:42:44+08:00][sql] CONNECT:[ UseTime:0.011435s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001263s ]
[2025-09-02T17:42:44+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-09-02T17:42:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001170s ]
[2025-09-02T17:42:44+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-09-02 16:37:44' AND '2025-09-02 17:37:44'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000412s ]
[2025-09-02T17:42:44+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-09-02 16:37:44' AND '2025-09-02 17:37:44'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000428s ]
[2025-09-02T17:42:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000933s ]
[2025-09-02T17:42:44+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 86 GROUP BY `tid` [ RunTime:0.000306s ]
[2025-09-02T17:42:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000888s ]
[2025-09-02T17:42:44+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 86 [ RunTime:0.000242s ]
[2025-09-02T17:42:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001021s ]
[2025-09-02T17:42:46+08:00][sql] CONNECT:[ UseTime:0.011412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001329s ]
[2025-09-02T17:42: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.000381s ]
[2025-09-02T17:42:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001204s ]
[2025-09-02T17:42: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-09-02 16:37:46' AND '2025-09-02 17:37:46'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000434s ]
[2025-09-02T17:42:46+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-09-02 16:37:46' AND '2025-09-02 17:37:46'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000436s ]
[2025-09-02T17:42:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000951s ]
[2025-09-02T17:42:46+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 86 GROUP BY `tid` [ RunTime:0.000305s ]
[2025-09-02T17:42:46+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000939s ]
[2025-09-02T17:42:46+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 86 [ RunTime:0.000223s ]
[2025-09-02T17:42:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001030s ]
[2025-09-02T17:42:46+08:00][sql] CONNECT:[ UseTime:0.011478s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001378s ]
[2025-09-02T17:42: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.000387s ]
[2025-09-02T17:42:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001204s ]
[2025-09-02T17:42: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-09-02 16:37:46' AND '2025-09-02 17:37:46'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000430s ]
[2025-09-02T17:42:46+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-09-02 16:37:46' AND '2025-09-02 17:37:46'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000497s ]
[2025-09-02T17:42:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000985s ]
[2025-09-02T17:42:46+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 86 GROUP BY `tid` [ RunTime:0.000281s ]
[2025-09-02T17:42:46+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000909s ]
[2025-09-02T17:42:46+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 86 [ RunTime:0.000237s ]
[2025-09-02T17:42:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001092s ]
[2025-09-02T17:42:47+08:00][sql] CONNECT:[ UseTime:0.011129s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001345s ]
[2025-09-02T17:42: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.000373s ]
[2025-09-02T17:42:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001247s ]
[2025-09-02T17:42: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` >= '2025-09-02 17:37:47' LIMIT 1 [ RunTime:0.000421s ]
[2025-09-02T17:42:48+08:00][sql] CONNECT:[ UseTime:0.001453s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001333s ]
[2025-09-02T17:42:48+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.000448s ]
[2025-09-02T17:42:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001210s ]
[2025-09-02T17:42:48+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-09-02 17:37:48' LIMIT 1 [ RunTime:0.000393s ]
[2025-09-02T17:42:49+08:00][sql] CONNECT:[ UseTime:0.010595s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001288s ]
[2025-09-02T17:42: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.000395s ]
[2025-09-02T17:42:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001166s ]
[2025-09-02T17:42: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` >= '2025-09-02 17:37:49' LIMIT 1 [ RunTime:0.000400s ]
[2025-09-02T17:42:58+08:00][sql] CONNECT:[ UseTime:0.001446s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001325s ]
[2025-09-02T17:42: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.000389s ]
[2025-09-02T17:42:58+08:00][sql] CONNECT:[ UseTime:0.043806s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8
[2025-09-02T17:42:58+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.029529s ]
[2025-09-02T17:42:58+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE  `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.070536s ]
[2025-09-02T17:42:58+08:00][sql] CONNECT:[ UseTime:0.001481s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:42:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001421s ]
[2025-09-02T17:42: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.000374s ]
[2025-09-02T17:42:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001054s ]
[2025-09-02T17:42: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.000333s ]
[2025-09-02T17:42:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001227s ]
[2025-09-02T17:42: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-09-02 17:37:58' LIMIT 1 [ RunTime:0.000456s ]
[2025-09-02T17:43:00+08:00][sql] CONNECT:[ UseTime:0.011080s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:43:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001370s ]
[2025-09-02T17:43: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.000408s ]
[2025-09-02T17:43:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001071s ]
[2025-09-02T17:43: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.000361s ]
[2025-09-02T17:43:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001163s ]
[2025-09-02T17:43: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` >= '2025-09-02 17:38:00' LIMIT 1 [ RunTime:0.000443s ]
[2025-09-02T17:43:01+08:00][sql] CONNECT:[ UseTime:0.010915s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001249s ]
[2025-09-02T17:43: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.000428s ]
[2025-09-02T17:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000998s ]
[2025-09-02T17:43:01+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-09-02T17:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001108s ]
[2025-09-02T17:43: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-09-02 16:38:01' AND '2025-09-02 17:38:01'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000406s ]
[2025-09-02T17:43:01+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-09-02 16:38:01' AND '2025-09-02 17:38:01'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000445s ]
[2025-09-02T17:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000879s ]
[2025-09-02T17:43:01+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 86 GROUP BY `tid` [ RunTime:0.000313s ]
[2025-09-02T17:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000899s ]
[2025-09-02T17:43:01+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 86 [ RunTime:0.000231s ]
[2025-09-02T17:43:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001010s ]
[2025-09-02T17:43:03+08:00][sql] CONNECT:[ UseTime:0.001389s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:43:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001265s ]
[2025-09-02T17:43:03+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-09-02T17:43:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001010s ]
[2025-09-02T17:43:03+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000369s ]
[2025-09-02T17:43:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001114s ]
[2025-09-02T17:43:03+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-09-02 16:38:03' AND '2025-09-02 17:38:03'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000404s ]
[2025-09-02T17:43:03+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-09-02 16:38:03' AND '2025-09-02 17:38:03'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000481s ]
[2025-09-02T17:43:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000930s ]
[2025-09-02T17:43:03+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 86 GROUP BY `tid` [ RunTime:0.000295s ]
[2025-09-02T17:43:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000885s ]
[2025-09-02T17:43:03+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 86 [ RunTime:0.000223s ]
[2025-09-02T17:43:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000993s ]
[2025-09-02T17:43:04+08:00][sql] CONNECT:[ UseTime:0.010923s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:43:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001447s ]
[2025-09-02T17:43: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.000485s ]
[2025-09-02T17:43:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001059s ]
[2025-09-02T17:43: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.000377s ]
[2025-09-02T17:43:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001230s ]
[2025-09-02T17:43: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` >= '2025-09-02 17:38:04' LIMIT 1 [ RunTime:0.000474s ]
[2025-09-02T17:43:04+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` >= '2025-09-02 17:38:04' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000392s ]
[2025-09-02T17:43:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001018s ]
[2025-09-02T17:43:04+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 87 GROUP BY `tid` [ RunTime:0.000296s ]
[2025-09-02T17:43:04+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000981s ]
[2025-09-02T17:43:04+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 87 [ RunTime:0.000215s ]
[2025-09-02T17:43:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001110s ]
[2025-09-02T17:43:06+08:00][sql] CONNECT:[ UseTime:0.001502s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:43:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001474s ]
[2025-09-02T17:43:06+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-09-02T17:43:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001119s ]
[2025-09-02T17:43:06+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-09-02T17:43:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001196s ]
[2025-09-02T17:43:06+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-09-02 17:38:06' LIMIT 1 [ RunTime:0.000452s ]
[2025-09-02T17:43:06+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` >= '2025-09-02 17:38:06' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000513s ]
[2025-09-02T17:43:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000948s ]
[2025-09-02T17:43:06+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 87 GROUP BY `tid` [ RunTime:0.000362s ]
[2025-09-02T17:43:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001013s ]
[2025-09-02T17:43:06+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 87 [ RunTime:0.000308s ]
[2025-09-02T17:43:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001102s ]
[2025-09-02T17:43:08+08:00][sql] CONNECT:[ UseTime:0.001445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:43:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001378s ]
[2025-09-02T17:43: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.000421s ]
[2025-09-02T17:43:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001084s ]
[2025-09-02T17:43: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.000340s ]
[2025-09-02T17:43:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001196s ]
[2025-09-02T17:43: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-09-02 16:38:08' AND '2025-09-02 17:38:08'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000385s ]
[2025-09-02T17:43: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-09-02 16:38:08' AND '2025-09-02 17:38:08'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000576s ]
[2025-09-02T17:43:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001010s ]
[2025-09-02T17:43:08+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 86 GROUP BY `tid` [ RunTime:0.000291s ]
[2025-09-02T17:43:08+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000896s ]
[2025-09-02T17:43:08+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 86 [ RunTime:0.000231s ]
[2025-09-02T17:43:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001047s ]
[2025-09-02T17:43:09+08:00][sql] CONNECT:[ UseTime:0.011437s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:43:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001279s ]
[2025-09-02T17:43:09+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.000407s ]
[2025-09-02T17:43:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000991s ]
[2025-09-02T17:43:09+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000361s ]
[2025-09-02T17:43:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001117s ]
[2025-09-02T17:43:09+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-09-02 17:38:09' LIMIT 1 [ RunTime:0.000398s ]
[2025-09-02T17:43:09+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` >= '2025-09-02 17:38:09' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000426s ]
[2025-09-02T17:43:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000937s ]
[2025-09-02T17:43:09+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 87 GROUP BY `tid` [ RunTime:0.000300s ]
[2025-09-02T17:43:09+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000887s ]
[2025-09-02T17:43:09+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` = 87 [ RunTime:0.000216s ]
[2025-09-02T17:43:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000997s ]
[2025-09-02T17:44:29+08:00][sql] CONNECT:[ UseTime:0.010872s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001296s ]
[2025-09-02T17:44:29+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-09-02T17:44:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001019s ]
[2025-09-02T17:44:29+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-09-02T17:44:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001084s ]
[2025-09-02T17:44:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tousername` = 'ctshaiya008'  AND `addtime` >= 1754214268 LIMIT 1 [ RunTime:0.000324s ]
[2025-09-02T17:44:29+08:00][sql] SELECT `id`,`orderno`,`ordertype`,`tid`,`price`,`relationid`,`pay_status`,`addtime`,`tousername` FROM `trade_order` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tousername` = 'ctshaiya008'  AND `addtime` >= 1754214268 ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000334s ]
[2025-09-02T17:44:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001080s ]
[2025-09-02T17:44:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001114s ]
[2025-09-02T17:44:29+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 (58,56,47) [ RunTime:0.000408s ]
[2025-09-02T17:44:29+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025080611234024256924','R2025080614044114693721') [ RunTime:0.000245s ]
[2025-09-02T17:44:29+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001016s ]
[2025-09-02T17:44:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001154s ]
[2025-09-02T17:44:29+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 `tid` = 83 [ RunTime:0.000337s ]
[2025-09-02T17:44:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001165s ]
[2025-09-02T17:44:29+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.030335s ]
[2025-09-02T17:44:29+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'P2025082517462348250203' [ RunTime:0.000206s ]
[2025-09-02T17:44:30+08:00][sql] CONNECT:[ UseTime:0.010632s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001405s ]
[2025-09-02T17:44: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.000439s ]
[2025-09-02T17:44:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001021s ]
[2025-09-02T17:44: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.000366s ]
[2025-09-02T17:44:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE  `game` = 'shaiya5'  AND `status` = 1 LIMIT 1 [ RunTime:0.000291s ]
[2025-09-02T17:44:30+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.000248s ]
[2025-09-02T17:44:30+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.000339s ]
[2025-09-02T17:44:31+08:00][sql] CONNECT:[ UseTime:0.001456s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001291s ]
[2025-09-02T17:44: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.000423s ]
[2025-09-02T17:44:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001025s ]
[2025-09-02T17:44:31+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000330s ]
[2025-09-02T17:44:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001090s ]
[2025-09-02T17:44:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tousername` = 'ctshaiya008'  AND `addtime` >= 1754214271 LIMIT 1 [ RunTime:0.000327s ]
[2025-09-02T17:44:31+08:00][sql] SELECT `id`,`orderno`,`ordertype`,`tid`,`price`,`relationid`,`pay_status`,`addtime`,`tousername` FROM `trade_order` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tousername` = 'ctshaiya008'  AND `addtime` >= 1754214271 ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000381s ]
[2025-09-02T17:44:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001083s ]
[2025-09-02T17:44:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001147s ]
[2025-09-02T17:44:31+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 (58,56,47) [ RunTime:0.000394s ]
[2025-09-02T17:44:31+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025080611234024256924','R2025080614044114693721') [ RunTime:0.000232s ]
[2025-09-02T17:44:31+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000939s ]
[2025-09-02T17:44:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001131s ]
[2025-09-02T17:44:31+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 `tid` = 83 [ RunTime:0.000315s ]
[2025-09-02T17:44:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001139s ]
[2025-09-02T17:44:31+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.030335s ]
[2025-09-02T17:44:31+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'P2025082517462348250203' [ RunTime:0.000211s ]
[2025-09-02T17:44:32+08:00][sql] CONNECT:[ UseTime:0.010897s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001312s ]
[2025-09-02T17:44: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.000378s ]
[2025-09-02T17:44:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001018s ]
[2025-09-02T17:44: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.000330s ]
[2025-09-02T17:44:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000947s ]
[2025-09-02T17:44:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `created_at` >= '2025-08-23 17:44:32' LIMIT 1 [ RunTime:0.000322s ]
[2025-09-02T17:44:33+08:00][sql] CONNECT:[ UseTime:0.010853s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001436s ]
[2025-09-02T17:44: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.000370s ]
[2025-09-02T17:44:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000970s ]
[2025-09-02T17:44: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.000339s ]
[2025-09-02T17:44:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000903s ]
[2025-09-02T17:44:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `created_at` >= '2025-06-04 17:44:33' LIMIT 1 [ RunTime:0.000437s ]
[2025-09-02T17:44:33+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `created_at` >= '2025-06-04 17:44:33' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000391s ]
[2025-09-02T17:44:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001009s ]
[2025-09-02T17:44:33+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (65,64,63) [ RunTime:0.000334s ]
[2025-09-02T17:44:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001014s ]
[2025-09-02T17:44:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001120s ]
[2025-09-02T17:44: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 (86,80,74,62) [ RunTime:0.000385s ]
[2025-09-02T17:44:33+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'R2025081810510949072728' [ RunTime:0.000188s ]
[2025-09-02T17:44:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001017s ]
[2025-09-02T17:44: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 `tid` = 81 [ RunTime:0.000300s ]
[2025-09-02T17:44:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001101s ]
[2025-09-02T17:44:33+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.028553s ]
[2025-09-02T17:44:35+08:00][sql] CONNECT:[ UseTime:0.010635s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001261s ]
[2025-09-02T17:44:35+08:00][sql] SELECT * FROM `trade_game` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000306s ]
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000958s ]
[2025-09-02T17:44: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.000334s ]
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000915s ]
[2025-09-02T17:44:35+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-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001227s ]
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001259s ]
[2025-09-02T17:44:35+08:00][sql] SELECT `id`,`tid`,`trade_status` FROM `trade_role` WHERE  `id` = 52  AND `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.000239s ]
[2025-09-02T17:44:35+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_status`,`sync_tradeno` FROM `trade` WHERE  `id` = 86  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000255s ]
[2025-09-02T17:44:35+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 5  WHERE  `id` = 52 [ RunTime:0.000217s ]
[2025-09-02T17:44:35+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 86 , `username` = 'ctshaiya008' , `orderno` = '' , `trade_type` = 1 , `type` = 3 , `content` = '%s已完成下架%s，商品已退回游戏，请前往游戏内角色列表/角色邮箱查收。如有疑问可联系官方客服咨询%s' [ RunTime:0.000232s ]
[2025-09-02T17:44:35+08:00][sql] CONNECT:[ UseTime:0.001371s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001266s ]
[2025-09-02T17:44: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.000379s ]
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000956s ]
[2025-09-02T17:44:35+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000337s ]
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000917s ]
[2025-09-02T17:44:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `created_at` >= '2025-06-04 17:44:35' LIMIT 1 [ RunTime:0.000434s ]
[2025-09-02T17:44:35+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `created_at` >= '2025-06-04 17:44:35' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000366s ]
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001041s ]
[2025-09-02T17:44:35+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (65,64,63) [ RunTime:0.000315s ]
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001045s ]
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001132s ]
[2025-09-02T17:44:35+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 (86,80,74,62) [ RunTime:0.000382s ]
[2025-09-02T17:44:35+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'R2025081810510949072728' [ RunTime:0.000222s ]
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001038s ]
[2025-09-02T17:44:35+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 `tid` = 81 [ RunTime:0.000315s ]
[2025-09-02T17:44:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001105s ]
[2025-09-02T17:44:35+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.028608s ]
[2025-09-02T17:44:36+08:00][sql] CONNECT:[ UseTime:0.011390s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001241s ]
[2025-09-02T17:44:36+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.000426s ]
[2025-09-02T17:44:38+08:00][sql] CONNECT:[ UseTime:0.010979s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001242s ]
[2025-09-02T17:44: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-09-02T17:44:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001103s ]
[2025-09-02T17:44:38+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-09-02 16:39:37' AND '2025-09-02 17:39:37'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000397s ]
[2025-09-02T17:44:45+08:00][sql] CONNECT:[ UseTime:0.001371s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001334s ]
[2025-09-02T17:44: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.000408s ]
[2025-09-02T17:44:45+08:00][sql] CONNECT:[ UseTime:0.045382s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8
[2025-09-02T17:44:45+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.030688s ]
[2025-09-02T17:44:45+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE  `username` = 'ctshaiya013' LIMIT 1 [ RunTime:0.072266s ]
[2025-09-02T17:44:45+08:00][sql] CONNECT:[ UseTime:0.010901s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001360s ]
[2025-09-02T17:44: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.000405s ]
[2025-09-02T17:44:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001093s ]
[2025-09-02T17:44:45+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000402s ]
[2025-09-02T17:44:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001223s ]
[2025-09-02T17:44:45+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-09-02 16:39:45' AND '2025-09-02 17:39:45'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000476s ]
[2025-09-02T17:44:52+08:00][sql] CONNECT:[ UseTime:0.011144s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001251s ]
[2025-09-02T17: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.000427s ]
[2025-09-02T17:44:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001035s ]
[2025-09-02T17:44:52+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000309s ]
[2025-09-02T17:44:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001072s ]
[2025-09-02T17:44:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tousername` = 'ctshaiya013'  AND `addtime` >= 1754214292 LIMIT 1 [ RunTime:0.000316s ]
[2025-09-02T17:44:52+08:00][sql] SELECT `id`,`orderno`,`ordertype`,`tid`,`price`,`relationid`,`pay_status`,`addtime`,`tousername` FROM `trade_order` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tousername` = 'ctshaiya013'  AND `addtime` >= 1754214292 ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000322s ]
[2025-09-02T17:44:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001121s ]
[2025-09-02T17:44:52+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 50 [ RunTime:0.000342s ]
[2025-09-02T17:44:52+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'G2025080610424847237182' [ RunTime:0.000184s ]
[2025-09-02T17:44:52+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000911s ]
[2025-09-02T17:44:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001136s ]
[2025-09-02T17:44:52+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 (76,75,73,74) [ RunTime:0.000425s ]
[2025-09-02T17:44:52+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025081811000411730555','R2025081810510949072728') [ RunTime:0.000276s ]
[2025-09-02T17:44:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001096s ]
[2025-09-02T17:44:52+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.000254s ]
[2025-09-02T17:44:53+08:00][sql] CONNECT:[ UseTime:0.010876s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001375s ]
[2025-09-02T17: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.000394s ]
[2025-09-02T17:44:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001047s ]
[2025-09-02T17:44:53+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000319s ]
[2025-09-02T17:44:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000997s ]
[2025-09-02T17:44:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `created_at` >= '2025-06-04 17:44:53' LIMIT 1 [ RunTime:0.000464s ]
[2025-09-02T17:44:53+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `created_at` >= '2025-06-04 17:44:53' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000464s ]
[2025-09-02T17:44:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001119s ]
[2025-09-02T17:44:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001198s ]
[2025-09-02T17:44:53+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 (87,58,56) [ RunTime:0.000445s ]
[2025-09-02T17:44:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001081s ]
[2025-09-02T17:44:53+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025080611234024256924','R2025080614044114693721') [ RunTime:0.000227s ]
[2025-09-02T17:44:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001115s ]
[2025-09-02T17:44:53+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.000236s ]
[2025-09-02T17:44:55+08:00][sql] CONNECT:[ UseTime:0.001438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001424s ]
[2025-09-02T17:44:55+08:00][sql] SELECT * FROM `trade_game` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000339s ]
[2025-09-02T17:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001009s ]
[2025-09-02T17:44: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.000374s ]
[2025-09-02T17:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000975s ]
[2025-09-02T17:44:55+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000350s ]
[2025-09-02T17:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001131s ]
[2025-09-02T17:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001308s ]
[2025-09-02T17:44:55+08:00][sql] SELECT `id`,`tid`,`trade_status` FROM `trade_role` WHERE  `id` = 53  AND `username` = 'ctshaiya013' LIMIT 1 [ RunTime:0.000238s ]
[2025-09-02T17:44:55+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_status`,`sync_tradeno` FROM `trade` WHERE  `id` = 87  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000240s ]
[2025-09-02T17:44:55+08:00][sql] UPDATE `trade_role`  SET `trade_status` = 5  WHERE  `id` = 53 [ RunTime:0.000214s ]
[2025-09-02T17:44:55+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 87 , `username` = 'ctshaiya013' , `orderno` = '' , `trade_type` = 1 , `type` = 3 , `content` = '%s已完成下架%s，商品已退回游戏，请前往游戏内角色列表/角色邮箱查收。如有疑问可联系官方客服咨询%s' [ RunTime:0.002263s ]
[2025-09-02T17:44:56+08:00][sql] CONNECT:[ UseTime:0.010873s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001364s ]
[2025-09-02T17:44: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.000415s ]
[2025-09-02T17:44:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001011s ]
[2025-09-02T17:44:56+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000338s ]
[2025-09-02T17:44:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000943s ]
[2025-09-02T17:44:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `created_at` >= '2025-06-04 17:44:56' LIMIT 1 [ RunTime:0.000446s ]
[2025-09-02T17:44:56+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `created_at` >= '2025-06-04 17:44:56' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000433s ]
[2025-09-02T17:44:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001090s ]
[2025-09-02T17:44:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001098s ]
[2025-09-02T17:44:56+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 (87,58,56) [ RunTime:0.000401s ]
[2025-09-02T17:44:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001045s ]
[2025-09-02T17:44:56+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025080611234024256924','R2025080614044114693721') [ RunTime:0.000248s ]
[2025-09-02T17:44:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001068s ]
[2025-09-02T17:44:56+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.000262s ]
[2025-09-02T17:44:57+08:00][sql] CONNECT:[ UseTime:0.001633s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T17:44:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001783s ]
[2025-09-02T17: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.000488s ]
[2025-09-02T17:44:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001589s ]
[2025-09-02T17:44:57+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000484s ]
[2025-09-02T17:44:57+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001032s ]
[2025-09-02T17:44:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `created_at` >= '2025-06-04 17:44:57' LIMIT 1 [ RunTime:0.000423s ]
[2025-09-02T17:44:57+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `created_at` >= '2025-06-04 17:44:57' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000421s ]
[2025-09-02T17:44:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001100s ]
[2025-09-02T17:44:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001141s ]
[2025-09-02T17:44:57+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 (87,58,56) [ RunTime:0.000405s ]
[2025-09-02T17:44:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001089s ]
[2025-09-02T17:44:57+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025080611234024256924','R2025080614044114693721') [ RunTime:0.000254s ]
[2025-09-02T17:44:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001065s ]
[2025-09-02T17:44:57+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-09-02T21:33:32+08:00][sql] CONNECT:[ UseTime:0.001548s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T21:33:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001356s ]
[2025-09-02T21:33:32+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.000479s ]
[2025-09-02T21:33:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001075s ]
[2025-09-02T21:33:32+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000280s ]
[2025-09-02T21:44:22+08:00][sql] CONNECT:[ UseTime:0.001462s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T21:44:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001296s ]
[2025-09-02T21:44: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.000426s ]
[2025-09-02T21:44:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001134s ]
[2025-09-02T21:44:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE  `game` = ''  AND `serverid` = 0  AND `tousername` = ''  AND `addtime` >= 1754228662 LIMIT 1 [ RunTime:0.000337s ]
[2025-09-02T21:50:25+08:00][sql] CONNECT:[ UseTime:0.001468s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T21:50:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001287s ]
[2025-09-02T21:50:25+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-09-02T21:50:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001298s ]
[2025-09-02T21:50:25+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000287s ]
[2025-09-02T23:34:23+08:00][sql] CONNECT:[ UseTime:0.001409s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-09-02T23:34:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001253s ]
[2025-09-02T23:34:23+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.000479s ]
[2025-09-02T23:34:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001027s ]
[2025-09-02T23:34:23+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000230s ]