[2025-08-25T17:25:50+08:00][sql] CONNECT:[ UseTime:0.001586s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:25:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001481s ]
[2025-08-25T17:25:50+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.000471s ]
[2025-08-25T17:25:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001181s ]
[2025-08-25T17:25:50+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000253s ]
[2025-08-25T17:25:51+08:00][sql] CONNECT:[ UseTime:0.001552s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:25:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001263s ]
[2025-08-25T17:25:51+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.000415s ]
[2025-08-25T17:25:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001014s ]
[2025-08-25T17:25:51+08:00][sql] SELECT * FROM `trade_game` WHERE  `code` = '116dbfb732616492e66bc9c04e703fd8'  AND `status` = 1 LIMIT 1 [ RunTime:0.000274s ]
[2025-08-25T17:25:51+08:00][sql] CONNECT:[ UseTime:0.001410s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:25:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001281s ]
[2025-08-25T17:25:51+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.000436s ]
[2025-08-25T17:25:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001216s ]
[2025-08-25T17:25:51+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-08-25 16:20:51' AND '2025-08-25 17:20:51'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000414s ]
[2025-08-25T17:26:02+08:00][sql] CONNECT:[ UseTime:0.001451s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001336s ]
[2025-08-25T17:26: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.000415s ]
[2025-08-25T17:26:02+08:00][sql] CONNECT:[ UseTime:0.047071s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8
[2025-08-25T17:26:02+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.031820s ]
[2025-08-25T17:26:02+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE  `username` = 'ctshaiya001' LIMIT 1 [ RunTime:0.073191s ]
[2025-08-25T17:26:02+08:00][sql] CONNECT:[ UseTime:0.011364s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001355s ]
[2025-08-25T17:26: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.000465s ]
[2025-08-25T17:26:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001034s ]
[2025-08-25T17:26: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.000323s ]
[2025-08-25T17:26:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001100s ]
[2025-08-25T17:26: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` BETWEEN '2025-08-25 16:21:02' AND '2025-08-25 17:21:02'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000387s ]
[2025-08-25T17:26:05+08:00][sql] CONNECT:[ UseTime:0.010517s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001497s ]
[2025-08-25T17:26: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.000486s ]
[2025-08-25T17:26:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001125s ]
[2025-08-25T17:26:05+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-08-25T17:26:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000339s ]
[2025-08-25T17:26:05+08:00][sql] SELECT `id`,`tid`,`content`,`created_at`,`is_read`,`trade_type`,`type`,`orderno` FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `deleted_at` IS NULL ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000376s ]
[2025-08-25T17:26:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001231s ]
[2025-08-25T17:26:05+08:00][sql] SELECT `id`,`tid`,`chaname` FROM `trade_role` WHERE  `tid` IN (76,73,72,70,59,47,27) [ RunTime:0.000380s ]
[2025-08-25T17:26:06+08:00][sql] CONNECT:[ UseTime:0.010978s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001413s ]
[2025-08-25T17:26: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.000477s ]
[2025-08-25T17:26:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001086s ]
[2025-08-25T17:26:06+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000366s ]
[2025-08-25T17:26:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000323s ]
[2025-08-25T17:26:06+08:00][sql] SELECT `id`,`tid`,`content`,`created_at`,`is_read`,`trade_type`,`type`,`orderno` FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `deleted_at` IS NULL ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000295s ]
[2025-08-25T17:26:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001211s ]
[2025-08-25T17:26:06+08:00][sql] SELECT `id`,`tid`,`chaname` FROM `trade_role` WHERE  `tid` IN (76,73,72,70,59,47,27) [ RunTime:0.000385s ]
[2025-08-25T17:26:10+08:00][sql] CONNECT:[ UseTime:0.010882s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001427s ]
[2025-08-25T17:26: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.000429s ]
[2025-08-25T17:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001123s ]
[2025-08-25T17:26:10+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000426s ]
[2025-08-25T17:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001064s ]
[2025-08-25T17:26:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `created_at` >= '2025-05-27 17:26:10' LIMIT 1 [ RunTime:0.000423s ]
[2025-08-25T17:26:10+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `created_at` >= '2025-05-27 17:26:10' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000361s ]
[2025-08-25T17:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001071s ]
[2025-08-25T17:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001084s ]
[2025-08-25T17:26:10+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,73,72,70,59,54,47,27) [ RunTime:0.000393s ]
[2025-08-25T17:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001035s ]
[2025-08-25T17:26:10+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025080611262097726788','R2025081810572529886534','R2025081811065120144614') [ RunTime:0.000250s ]
[2025-08-25T17:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001041s ]
[2025-08-25T17:26:10+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-08-25T17:26:13+08:00][sql] CONNECT:[ UseTime:0.001481s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001382s ]
[2025-08-25T17:26: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.000430s ]
[2025-08-25T17:26:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001125s ]
[2025-08-25T17:26:13+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000414s ]
[2025-08-25T17:26:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001291s ]
[2025-08-25T17:26: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-08-25 16:21:13' AND '2025-08-25 17:21:13'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000465s ]
[2025-08-25T17:26:15+08:00][sql] CONNECT:[ UseTime:0.011394s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001433s ]
[2025-08-25T17:26:15+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-08-25T17:26:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001110s ]
[2025-08-25T17:26:15+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-08-25T17:26:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001409s ]
[2025-08-25T17:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:21:15' AND '2025-08-25 17:21:15'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000430s ]
[2025-08-25T17:26:16+08:00][sql] CONNECT:[ UseTime:0.001394s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001309s ]
[2025-08-25T17:26:16+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-08-25T17:26:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001008s ]
[2025-08-25T17:26:16+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000333s ]
[2025-08-25T17:26:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001143s ]
[2025-08-25T17:26:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:21:16' LIMIT 1 [ RunTime:0.000491s ]
[2025-08-25T17:26:54+08:00][sql] CONNECT:[ UseTime:0.010549s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001307s ]
[2025-08-25T17:26: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.000385s ]
[2025-08-25T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001013s ]
[2025-08-25T17:26: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.000334s ]
[2025-08-25T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001235s ]
[2025-08-25T17:26:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:21:54' LIMIT 1 [ RunTime:0.000335s ]
[2025-08-25T17:26:54+08:00][sql] CONNECT:[ UseTime:0.010863s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001443s ]
[2025-08-25T17:26: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.000449s ]
[2025-08-25T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001060s ]
[2025-08-25T17:26: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.000352s ]
[2025-08-25T17:26:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001199s ]
[2025-08-25T17:26:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:21:54' LIMIT 1 [ RunTime:0.000398s ]
[2025-08-25T17:26:55+08:00][sql] CONNECT:[ UseTime:0.010926s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001369s ]
[2025-08-25T17:26: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.000391s ]
[2025-08-25T17:26:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001049s ]
[2025-08-25T17:26:55+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-08-25T17:26:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001401s ]
[2025-08-25T17:26:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:21:55' AND '2025-08-25 17:21:55'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000402s ]
[2025-08-25T17:26:56+08:00][sql] CONNECT:[ UseTime:0.010988s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:26:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001352s ]
[2025-08-25T17:26: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.000378s ]
[2025-08-25T17:26:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001076s ]
[2025-08-25T17:26:56+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000344s ]
[2025-08-25T17:26:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001220s ]
[2025-08-25T17:26:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:21:56' LIMIT 1 [ RunTime:0.000326s ]
[2025-08-25T17:28:11+08:00][sql] CONNECT:[ UseTime:0.011031s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:28:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001368s ]
[2025-08-25T17:28: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.000418s ]
[2025-08-25T17:28:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001072s ]
[2025-08-25T17:28:11+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000420s ]
[2025-08-25T17:28:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001164s ]
[2025-08-25T17:28:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:23:11' LIMIT 1 [ RunTime:0.000409s ]
[2025-08-25T17:28:11+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:23:11' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000333s ]
[2025-08-25T17:28:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001250s ]
[2025-08-25T17:28:11+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` IN (42216,126052) [ RunTime:0.030652s ]
[2025-08-25T17:28:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001253s ]
[2025-08-25T17:28:11+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) [ RunTime:0.000408s ]
[2025-08-25T17:28:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000967s ]
[2025-08-25T17:28:11+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) GROUP BY `tid` [ RunTime:0.000397s ]
[2025-08-25T17:28:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000969s ]
[2025-08-25T17:28:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001153s ]
[2025-08-25T17:28:11+08:00][sql] CONNECT:[ UseTime:0.011028s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:28:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001347s ]
[2025-08-25T17:28: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.000384s ]
[2025-08-25T17:28:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001003s ]
[2025-08-25T17:28:11+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000342s ]
[2025-08-25T17:28:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001123s ]
[2025-08-25T17:28:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:23:11' AND '2025-08-25 17:23:11'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000360s ]
[2025-08-25T17:28:12+08:00][sql] CONNECT:[ UseTime:0.011544s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:28:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001284s ]
[2025-08-25T17:28: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.000502s ]
[2025-08-25T17:28:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001033s ]
[2025-08-25T17:28:12+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000403s ]
[2025-08-25T17:28:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001176s ]
[2025-08-25T17:28:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:23:12' LIMIT 1 [ RunTime:0.000349s ]
[2025-08-25T17:28:12+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:23:12' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000370s ]
[2025-08-25T17:28:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001197s ]
[2025-08-25T17:28:12+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` IN (42216,126052) [ RunTime:0.030444s ]
[2025-08-25T17:28:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001207s ]
[2025-08-25T17:28:12+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) [ RunTime:0.000316s ]
[2025-08-25T17:28:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001044s ]
[2025-08-25T17:28:12+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) GROUP BY `tid` [ RunTime:0.000404s ]
[2025-08-25T17:28:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000991s ]
[2025-08-25T17:28:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001159s ]
[2025-08-25T17:28:16+08:00][sql] CONNECT:[ UseTime:0.001478s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001380s ]
[2025-08-25T17:28:16+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.000403s ]
[2025-08-25T17:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001057s ]
[2025-08-25T17:28:16+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000288s ]
[2025-08-25T17:29:59+08:00][sql] CONNECT:[ UseTime:0.010788s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:29:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001399s ]
[2025-08-25T17:29: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.000567s ]
[2025-08-25T17:29:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001336s ]
[2025-08-25T17:29: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.000396s ]
[2025-08-25T17:29:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001239s ]
[2025-08-25T17:29:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:24:59' LIMIT 1 [ RunTime:0.000441s ]
[2025-08-25T17:29:59+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:24:59' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000371s ]
[2025-08-25T17:29:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001188s ]
[2025-08-25T17:29:59+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` IN (42216,126052) [ RunTime:0.030540s ]
[2025-08-25T17:29:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001256s ]
[2025-08-25T17:29:59+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) [ RunTime:0.000349s ]
[2025-08-25T17:29:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000933s ]
[2025-08-25T17:29:59+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) GROUP BY `tid` [ RunTime:0.000357s ]
[2025-08-25T17:29:59+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000923s ]
[2025-08-25T17:29:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001421s ]
[2025-08-25T17:30:02+08:00][sql] CONNECT:[ UseTime:0.011327s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001500s ]
[2025-08-25T17: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.000488s ]
[2025-08-25T17:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001117s ]
[2025-08-25T17:30: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.000355s ]
[2025-08-25T17:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001226s ]
[2025-08-25T17:30:02+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 3  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000375s ]
[2025-08-25T17:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001342s ]
[2025-08-25T17:30:02+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 LIMIT 1 [ RunTime:0.018700s ]
[2025-08-25T17:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001196s ]
[2025-08-25T17:30:02+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000297s ]
[2025-08-25T17:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000902s ]
[2025-08-25T17:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001030s ]
[2025-08-25T17:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000897s ]
[2025-08-25T17:30:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `type` = 2  AND `relationid` = 3 LIMIT 1 [ RunTime:0.000347s ]
[2025-08-25T17:30:05+08:00][sql] CONNECT:[ UseTime:0.011669s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001563s ]
[2025-08-25T17: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.000484s ]
[2025-08-25T17:30:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001145s ]
[2025-08-25T17:30:05+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000324s ]
[2025-08-25T17:30:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001211s ]
[2025-08-25T17:30:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:25:05' AND '2025-08-25 17:25:05'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000396s ]
[2025-08-25T17:30:07+08:00][sql] CONNECT:[ UseTime:0.010917s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001305s ]
[2025-08-25T17: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.000632s ]
[2025-08-25T17:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001187s ]
[2025-08-25T17:30:07+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000354s ]
[2025-08-25T17:30:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001089s ]
[2025-08-25T17:30:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:25:07' AND '2025-08-25 17:25:07'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000386s ]
[2025-08-25T17:30:09+08:00][sql] CONNECT:[ UseTime:0.011255s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001242s ]
[2025-08-25T17:30: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-08-25T17:30:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000963s ]
[2025-08-25T17:30:09+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-08-25T17:30:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001083s ]
[2025-08-25T17:30:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:25:09' LIMIT 1 [ RunTime:0.000346s ]
[2025-08-25T17:30:09+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:25:09' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000334s ]
[2025-08-25T17:30:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001119s ]
[2025-08-25T17:30:09+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` IN (42216,126052) [ RunTime:0.028686s ]
[2025-08-25T17:30:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001162s ]
[2025-08-25T17:30:09+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) [ RunTime:0.000349s ]
[2025-08-25T17:30:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000870s ]
[2025-08-25T17:30:09+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) GROUP BY `tid` [ RunTime:0.000327s ]
[2025-08-25T17:30:09+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000884s ]
[2025-08-25T17:30:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001143s ]
[2025-08-25T17:30:11+08:00][sql] CONNECT:[ UseTime:0.011389s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001282s ]
[2025-08-25T17: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.000420s ]
[2025-08-25T17:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001023s ]
[2025-08-25T17:30:11+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-08-25T17:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001108s ]
[2025-08-25T17:30:11+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 2  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000303s ]
[2025-08-25T17:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001138s ]
[2025-08-25T17:30:11+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 LIMIT 1 [ RunTime:0.039229s ]
[2025-08-25T17:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001198s ]
[2025-08-25T17:30:11+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000315s ]
[2025-08-25T17:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000942s ]
[2025-08-25T17:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001054s ]
[2025-08-25T17:30:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000912s ]
[2025-08-25T17:30:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `type` = 2  AND `relationid` = 2 LIMIT 1 [ RunTime:0.000313s ]
[2025-08-25T17:30:17+08:00][sql] CONNECT:[ UseTime:0.010926s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001287s ]
[2025-08-25T17:30: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.000392s ]
[2025-08-25T17:30:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001018s ]
[2025-08-25T17:30: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.000356s ]
[2025-08-25T17:30:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001105s ]
[2025-08-25T17:30:17+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 2  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000285s ]
[2025-08-25T17:30:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001151s ]
[2025-08-25T17:30:17+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 LIMIT 1 [ RunTime:0.039382s ]
[2025-08-25T17:30:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001205s ]
[2025-08-25T17:30:17+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000309s ]
[2025-08-25T17:30:17+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000957s ]
[2025-08-25T17:30:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001096s ]
[2025-08-25T17:30:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000960s ]
[2025-08-25T17:30:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `type` = 2  AND `relationid` = 2 LIMIT 1 [ RunTime:0.000307s ]
[2025-08-25T17:30:22+08:00][sql] CONNECT:[ UseTime:0.001419s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001291s ]
[2025-08-25T17:30: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.000402s ]
[2025-08-25T17:30:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001016s ]
[2025-08-25T17:30: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.000328s ]
[2025-08-25T17:30:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001111s ]
[2025-08-25T17:30:22+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 2  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000314s ]
[2025-08-25T17:30:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001198s ]
[2025-08-25T17:30:22+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 LIMIT 1 [ RunTime:0.039320s ]
[2025-08-25T17:30:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001187s ]
[2025-08-25T17:30:22+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000287s ]
[2025-08-25T17:30:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001053s ]
[2025-08-25T17:30:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001130s ]
[2025-08-25T17:30:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000903s ]
[2025-08-25T17:30:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `type` = 2  AND `relationid` = 2 LIMIT 1 [ RunTime:0.000339s ]
[2025-08-25T17:30:45+08:00][sql] CONNECT:[ UseTime:0.010412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001257s ]
[2025-08-25T17:30: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.000371s ]
[2025-08-25T17:30:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000977s ]
[2025-08-25T17:30:45+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-08-25T17:30:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000903s ]
[2025-08-25T17:30:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `created_at` >= '2025-05-27 17:30:45' LIMIT 1 [ RunTime:0.000422s ]
[2025-08-25T17:30:45+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `created_at` >= '2025-05-27 17:30:45' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000396s ]
[2025-08-25T17:30:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001321s ]
[2025-08-25T17:30:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001299s ]
[2025-08-25T17:30:45+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,73,72,70,59,54,47,27) [ RunTime:0.000432s ]
[2025-08-25T17:30:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001117s ]
[2025-08-25T17:30:45+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025080611262097726788','R2025081810572529886534','R2025081811065120144614') [ RunTime:0.000256s ]
[2025-08-25T17:30:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001166s ]
[2025-08-25T17:30:45+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.000244s ]
[2025-08-25T17:30:46+08:00][sql] CONNECT:[ UseTime:0.011506s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001358s ]
[2025-08-25T17:30: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.000378s ]
[2025-08-25T17:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001059s ]
[2025-08-25T17:30:46+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000319s ]
[2025-08-25T17:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001001s ]
[2025-08-25T17:30:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `created_at` >= '2025-05-27 17:30:46' LIMIT 1 [ RunTime:0.000554s ]
[2025-08-25T17:30:46+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `created_at` >= '2025-05-27 17:30:46' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000421s ]
[2025-08-25T17:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001230s ]
[2025-08-25T17:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001253s ]
[2025-08-25T17:30:46+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,73,72,70,59,54,47,27) [ RunTime:0.000470s ]
[2025-08-25T17:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001133s ]
[2025-08-25T17:30:46+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025080611262097726788','R2025081810572529886534','R2025081811065120144614') [ RunTime:0.000333s ]
[2025-08-25T17:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001166s ]
[2025-08-25T17:30:46+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.000314s ]
[2025-08-25T17:30:46+08:00][sql] CONNECT:[ UseTime:0.011146s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001367s ]
[2025-08-25T17:30: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.000492s ]
[2025-08-25T17:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001111s ]
[2025-08-25T17:30:46+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000371s ]
[2025-08-25T17:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001229s ]
[2025-08-25T17:30: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-08-25 16:25:46' AND '2025-08-25 17:25:46'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000478s ]
[2025-08-25T17:30:47+08:00][sql] CONNECT:[ UseTime:0.001495s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001346s ]
[2025-08-25T17:30: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.000431s ]
[2025-08-25T17:30:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001115s ]
[2025-08-25T17:30:47+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-08-25T17:30:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001190s ]
[2025-08-25T17:30:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:25:47' AND '2025-08-25 17:25:47'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000422s ]
[2025-08-25T17:30:49+08:00][sql] CONNECT:[ UseTime:0.001580s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001477s ]
[2025-08-25T17:30: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.000380s ]
[2025-08-25T17:30:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001112s ]
[2025-08-25T17:30:49+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-08-25T17:30:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001191s ]
[2025-08-25T17:30:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:25:49' LIMIT 1 [ RunTime:0.000411s ]
[2025-08-25T17:30:49+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:25:49' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000339s ]
[2025-08-25T17:30:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001282s ]
[2025-08-25T17:30:49+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` IN (42216,126052) [ RunTime:0.032042s ]
[2025-08-25T17:30:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001260s ]
[2025-08-25T17:30:49+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) [ RunTime:0.000400s ]
[2025-08-25T17:30:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000995s ]
[2025-08-25T17:30:49+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) GROUP BY `tid` [ RunTime:0.000418s ]
[2025-08-25T17:30:49+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001004s ]
[2025-08-25T17:30:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001271s ]
[2025-08-25T17:30:51+08:00][sql] CONNECT:[ UseTime:0.011200s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001408s ]
[2025-08-25T17:30:51+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-08-25T17:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001082s ]
[2025-08-25T17:30:51+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000389s ]
[2025-08-25T17:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001208s ]
[2025-08-25T17:30:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:25:50' LIMIT 1 [ RunTime:0.000399s ]
[2025-08-25T17:30:51+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:25:50' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000361s ]
[2025-08-25T17:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001233s ]
[2025-08-25T17:30:51+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` IN (42216,126052) [ RunTime:0.030555s ]
[2025-08-25T17:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001287s ]
[2025-08-25T17:30:51+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) [ RunTime:0.000352s ]
[2025-08-25T17:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000892s ]
[2025-08-25T17:30:51+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) GROUP BY `tid` [ RunTime:0.000339s ]
[2025-08-25T17:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000947s ]
[2025-08-25T17:30:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001049s ]
[2025-08-25T17:30:53+08:00][sql] CONNECT:[ UseTime:0.001489s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001288s ]
[2025-08-25T17:30: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.000404s ]
[2025-08-25T17:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001105s ]
[2025-08-25T17:30: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.000329s ]
[2025-08-25T17:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001202s ]
[2025-08-25T17:30:53+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 3  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000291s ]
[2025-08-25T17:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001146s ]
[2025-08-25T17:30:53+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 LIMIT 1 [ RunTime:0.017630s ]
[2025-08-25T17:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001187s ]
[2025-08-25T17:30:53+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000300s ]
[2025-08-25T17:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000945s ]
[2025-08-25T17:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001243s ]
[2025-08-25T17:30:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000966s ]
[2025-08-25T17:30:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `type` = 2  AND `relationid` = 3 LIMIT 1 [ RunTime:0.000310s ]
[2025-08-25T17:31:01+08:00][sql] CONNECT:[ UseTime:0.010384s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:31:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001284s ]
[2025-08-25T17:31: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.000421s ]
[2025-08-25T17:31:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001053s ]
[2025-08-25T17:31: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.000322s ]
[2025-08-25T17:31:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001124s ]
[2025-08-25T17:31:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:26:01' LIMIT 1 [ RunTime:0.000364s ]
[2025-08-25T17:31:01+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:26:01' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000337s ]
[2025-08-25T17:31:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001194s ]
[2025-08-25T17:31:01+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` IN (42216,126052) [ RunTime:0.038625s ]
[2025-08-25T17:31:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001764s ]
[2025-08-25T17:31:01+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) [ RunTime:0.000449s ]
[2025-08-25T17:31:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001275s ]
[2025-08-25T17:31:01+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` IN (83,82) GROUP BY `tid` [ RunTime:0.000464s ]
[2025-08-25T17:31:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001334s ]
[2025-08-25T17:31:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001690s ]
[2025-08-25T17:31:39+08:00][sql] CONNECT:[ UseTime:0.001402s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:31:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001241s ]
[2025-08-25T17:31: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.000387s ]
[2025-08-25T17:31:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000971s ]
[2025-08-25T17:31:39+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-08-25T17:31:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001049s ]
[2025-08-25T17:31:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:26:39' LIMIT 1 [ RunTime:0.000348s ]
[2025-08-25T17:31:39+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:26:39' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000345s ]
[2025-08-25T17:31:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001131s ]
[2025-08-25T17:31:39+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.028381s ]
[2025-08-25T17:31:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001135s ]
[2025-08-25T17:31:39+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000283s ]
[2025-08-25T17:31:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000852s ]
[2025-08-25T17:31:39+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000275s ]
[2025-08-25T17:31:39+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000883s ]
[2025-08-25T17:31:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000996s ]
[2025-08-25T17:31:40+08:00][sql] CONNECT:[ UseTime:0.010986s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001360s ]
[2025-08-25T17:31:40+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.000397s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000997s ]
[2025-08-25T17:31:40+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000334s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001107s ]
[2025-08-25T17:31:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:26:40' LIMIT 1 [ RunTime:0.000400s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:26:40' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000354s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001183s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.030214s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001196s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000305s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000899s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000338s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000912s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001069s ]
[2025-08-25T17:31:40+08:00][sql] CONNECT:[ UseTime:0.010933s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001466s ]
[2025-08-25T17:31:40+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.000441s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001117s ]
[2025-08-25T17:31:40+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000420s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001278s ]
[2025-08-25T17:31:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:26:40' LIMIT 1 [ RunTime:0.000438s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:26:40' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000369s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001253s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.031944s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001258s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000319s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001042s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000287s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001034s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001159s ]
[2025-08-25T17:31:40+08:00][sql] CONNECT:[ UseTime:0.001467s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001331s ]
[2025-08-25T17:31:40+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.000451s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001069s ]
[2025-08-25T17:31:40+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000408s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001149s ]
[2025-08-25T17:31:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:26:40' LIMIT 1 [ RunTime:0.000373s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:26:40' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000414s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001210s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.030303s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001259s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000355s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000963s ]
[2025-08-25T17:31:40+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000286s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000973s ]
[2025-08-25T17:31:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001142s ]
[2025-08-25T17:31:42+08:00][sql] CONNECT:[ UseTime:0.011572s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001358s ]
[2025-08-25T17: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.000422s ]
[2025-08-25T17:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001085s ]
[2025-08-25T17:31:42+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000340s ]
[2025-08-25T17:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001175s ]
[2025-08-25T17:31:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:26:42' AND '2025-08-25 17:26:42'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000366s ]
[2025-08-25T17:31:42+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:26:42' AND '2025-08-25 17:26:42'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000349s ]
[2025-08-25T17:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001202s ]
[2025-08-25T17:31:42+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 [ RunTime:0.030411s ]
[2025-08-25T17:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001283s ]
[2025-08-25T17:31:42+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000285s ]
[2025-08-25T17:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001103s ]
[2025-08-25T17:31:42+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 GROUP BY `tid` [ RunTime:0.000323s ]
[2025-08-25T17:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001055s ]
[2025-08-25T17:31:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001210s ]
[2025-08-25T17:31:43+08:00][sql] CONNECT:[ UseTime:0.010436s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:31:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001323s ]
[2025-08-25T17:31: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.000387s ]
[2025-08-25T17:31:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001002s ]
[2025-08-25T17:31:43+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-08-25T17:31:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001121s ]
[2025-08-25T17:31:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:26:43' AND '2025-08-25 17:26:43'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000362s ]
[2025-08-25T17:31:43+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:26:43' AND '2025-08-25 17:26:43'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000359s ]
[2025-08-25T17:31:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001166s ]
[2025-08-25T17:31:43+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 [ RunTime:0.030315s ]
[2025-08-25T17:31:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001216s ]
[2025-08-25T17:31:43+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000324s ]
[2025-08-25T17:31:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000900s ]
[2025-08-25T17:31:43+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 GROUP BY `tid` [ RunTime:0.000330s ]
[2025-08-25T17:31:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000945s ]
[2025-08-25T17:31:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001071s ]
[2025-08-25T17:32:10+08:00][sql] CONNECT:[ UseTime:0.011273s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001377s ]
[2025-08-25T17:32:10+08:00][sql] SELECT * FROM `trade_game` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000329s ]
[2025-08-25T17:32:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001056s ]
[2025-08-25T17:32: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.000377s ]
[2025-08-25T17:32:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001079s ]
[2025-08-25T17:32:10+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000333s ]
[2025-08-25T17:32:10+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001078s ]
[2025-08-25T17:32:10+08:00][sql] SELECT * FROM `trade` WHERE  `id` = 82 LIMIT 1 [ RunTime:0.000268s ]
[2025-08-25T17:32:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001133s ]
[2025-08-25T17:32:10+08:00][sql] SELECT * FROM `trade_prop` WHERE  `tid` = 82 [ RunTime:0.000285s ]
[2025-08-25T17:32:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001056s ]
[2025-08-25T17:32:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124' LIMIT 1 [ RunTime:0.000406s ]
[2025-08-25T17:32:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001309s ]
[2025-08-25T17:32:10+08:00][sql] SELECT `itemid`,`itemname` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 LIMIT 1 [ RunTime:0.026440s ]
[2025-08-25T17:32:10+08:00][sql] INSERT INTO `trade_order` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 82 , `orderno` = 'P2025082517321094017124' , `relationid` = 2 , `ordertype` = 2 , `charge` = '2.50' , `price` = '50.00' , `amount` = '47.50' , `tousername` = 'ctshaiya001' , `addtime` = 1756114330 , `order_details` = '{\"itemid\":126052,\"num\":1,\"goods_name\":\"霓凰\",\"outtime\":1756117891,\"sync_tradeno\":\"7367359867587198976\",\"username\":\"ctshaiya012\"}' [ RunTime:0.000343s ]
[2025-08-25T17:32:10+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 3 , `pay_status` = 1 , `orderno` = 'P2025082517321094017124'  WHERE  `id` = 2 [ RunTime:0.000268s ]
[2025-08-25T17:32:11+08:00][sql] CONNECT:[ UseTime:0.011067s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001240s ]
[2025-08-25T17:32: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.000378s ]
[2025-08-25T17:32:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001010s ]
[2025-08-25T17:32:11+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-08-25T17:32:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001141s ]
[2025-08-25T17:32:11+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124'  AND `tousername` = 'ctshaiya001' LIMIT 1 [ RunTime:0.000326s ]
[2025-08-25T17:32:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001139s ]
[2025-08-25T17:32:11+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 2  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000362s ]
[2025-08-25T17:32:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001277s ]
[2025-08-25T17:32:11+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 LIMIT 1 [ RunTime:0.042348s ]
[2025-08-25T17:32:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001303s ]
[2025-08-25T17:32:11+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000339s ]
[2025-08-25T17:32:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000988s ]
[2025-08-25T17:32:19+08:00][sql] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001405s ]
[2025-08-25T17: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.000386s ]
[2025-08-25T17:32:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001084s ]
[2025-08-25T17:32: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.000430s ]
[2025-08-25T17:32:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001172s ]
[2025-08-25T17:32:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:27:19' AND '2025-08-25 17:27:19'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000374s ]
[2025-08-25T17:32:19+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:27:19' AND '2025-08-25 17:27:19'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000349s ]
[2025-08-25T17:32:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001239s ]
[2025-08-25T17:32:19+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.030528s ]
[2025-08-25T17:32:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001235s ]
[2025-08-25T17:32:19+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000289s ]
[2025-08-25T17:32:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000957s ]
[2025-08-25T17:32:19+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000326s ]
[2025-08-25T17:32:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000989s ]
[2025-08-25T17:32:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001130s ]
[2025-08-25T17:32:22+08:00][sql] CONNECT:[ UseTime:0.011216s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001288s ]
[2025-08-25T17:32: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.000390s ]
[2025-08-25T17:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001038s ]
[2025-08-25T17:32: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.000318s ]
[2025-08-25T17:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001128s ]
[2025-08-25T17:32:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:27:22' LIMIT 1 [ RunTime:0.000348s ]
[2025-08-25T17:32:22+08:00][sql] CONNECT:[ UseTime:0.010891s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001276s ]
[2025-08-25T17:32: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.000483s ]
[2025-08-25T17:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001053s ]
[2025-08-25T17:32: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.000361s ]
[2025-08-25T17:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001138s ]
[2025-08-25T17:32:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:27:22' AND '2025-08-25 17:27:22'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000381s ]
[2025-08-25T17:32:22+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:27:22' AND '2025-08-25 17:27:22'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000367s ]
[2025-08-25T17:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001208s ]
[2025-08-25T17:32:22+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.030213s ]
[2025-08-25T17:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001197s ]
[2025-08-25T17:32:22+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000355s ]
[2025-08-25T17:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000902s ]
[2025-08-25T17:32:22+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000422s ]
[2025-08-25T17:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000958s ]
[2025-08-25T17:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001088s ]
[2025-08-25T17:32:24+08:00][sql] CONNECT:[ UseTime:0.001576s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001469s ]
[2025-08-25T17:32: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.000404s ]
[2025-08-25T17:32:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001123s ]
[2025-08-25T17:32: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.000341s ]
[2025-08-25T17:32:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001204s ]
[2025-08-25T17:32:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:27:24' AND '2025-08-25 17:27:24'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000425s ]
[2025-08-25T17:32:24+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:27:24' AND '2025-08-25 17:27:24'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000347s ]
[2025-08-25T17:32:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001241s ]
[2025-08-25T17:32:24+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.032049s ]
[2025-08-25T17:32:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001379s ]
[2025-08-25T17:32:24+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000385s ]
[2025-08-25T17:32:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001001s ]
[2025-08-25T17:32:24+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000284s ]
[2025-08-25T17:32:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001028s ]
[2025-08-25T17:32:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001211s ]
[2025-08-25T17:32:25+08:00][sql] CONNECT:[ UseTime:0.001445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001231s ]
[2025-08-25T17:32: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.000369s ]
[2025-08-25T17:32:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001001s ]
[2025-08-25T17:32: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.000327s ]
[2025-08-25T17:32:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001080s ]
[2025-08-25T17:32:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:27:25' AND '2025-08-25 17:27:25'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000339s ]
[2025-08-25T17:32:25+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:27:25' AND '2025-08-25 17:27:25'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000371s ]
[2025-08-25T17:32:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001125s ]
[2025-08-25T17:32:25+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.028546s ]
[2025-08-25T17:32:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001139s ]
[2025-08-25T17:32:25+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000327s ]
[2025-08-25T17:32:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000859s ]
[2025-08-25T17:32:25+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000291s ]
[2025-08-25T17:32:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001045s ]
[2025-08-25T17:32:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001225s ]
[2025-08-25T17:32:27+08:00][sql] CONNECT:[ UseTime:0.011235s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001379s ]
[2025-08-25T17:32: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.000387s ]
[2025-08-25T17:32:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001060s ]
[2025-08-25T17:32: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.000388s ]
[2025-08-25T17:32:27+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001022s ]
[2025-08-25T17:32:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `created_at` >= '2025-05-27 17:32:27' LIMIT 1 [ RunTime:0.000428s ]
[2025-08-25T17:32:27+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `created_at` >= '2025-05-27 17:32:27' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000430s ]
[2025-08-25T17:32:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001145s ]
[2025-08-25T17:32:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001173s ]
[2025-08-25T17:32: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 (76,73,72,70,59,54,47,27) [ RunTime:0.000431s ]
[2025-08-25T17:32:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001115s ]
[2025-08-25T17:32:27+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025080611262097726788','R2025081810572529886534','R2025081811065120144614') [ RunTime:0.000254s ]
[2025-08-25T17:32:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001177s ]
[2025-08-25T17:32: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.000308s ]
[2025-08-25T17:32:27+08:00][sql] CONNECT:[ UseTime:0.001565s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001392s ]
[2025-08-25T17:32: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.000480s ]
[2025-08-25T17:32:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001134s ]
[2025-08-25T17:32: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.000325s ]
[2025-08-25T17:32:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE  `game` = 'shaiya5'  AND `status` = 1 LIMIT 1 [ RunTime:0.000401s ]
[2025-08-25T17:32:27+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.000275s ]
[2025-08-25T17:32:27+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-08-25T17:32:28+08:00][sql] CONNECT:[ UseTime:0.001502s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001492s ]
[2025-08-25T17: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.000387s ]
[2025-08-25T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001108s ]
[2025-08-25T17:32:28+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000334s ]
[2025-08-25T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001156s ]
[2025-08-25T17:32:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tousername` = 'ctshaiya001'  AND `addtime` >= 1753522348 LIMIT 1 [ RunTime:0.000388s ]
[2025-08-25T17:32:28+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` = 'ctshaiya001'  AND `addtime` >= 1753522348 ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000302s ]
[2025-08-25T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001167s ]
[2025-08-25T17:32:28+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` = 48 [ RunTime:0.000363s ]
[2025-08-25T17:32:28+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'G2025080610065667409769' [ RunTime:0.000268s ]
[2025-08-25T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001139s ]
[2025-08-25T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001159s ]
[2025-08-25T17:32:28+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` = 49 [ RunTime:0.000418s ]
[2025-08-25T17:32:28+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'R2025080610063716860971' [ RunTime:0.000205s ]
[2025-08-25T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001091s ]
[2025-08-25T17:32:28+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` = 82 [ RunTime:0.000317s ]
[2025-08-25T17:32:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001157s ]
[2025-08-25T17:32:28+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 [ RunTime:0.029784s ]
[2025-08-25T17:32:28+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124' [ RunTime:0.000205s ]
[2025-08-25T17:32:31+08:00][sql] CONNECT:[ UseTime:0.011805s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001411s ]
[2025-08-25T17:32: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.000439s ]
[2025-08-25T17:32:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001102s ]
[2025-08-25T17:32:31+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-08-25T17:32:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001084s ]
[2025-08-25T17:32:31+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124'  AND `tousername` = 'ctshaiya001' LIMIT 1 [ RunTime:0.000300s ]
[2025-08-25T17:32:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001140s ]
[2025-08-25T17:32:31+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 2  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000360s ]
[2025-08-25T17:32:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001096s ]
[2025-08-25T17:32:31+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 LIMIT 1 [ RunTime:0.037666s ]
[2025-08-25T17:32:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001138s ]
[2025-08-25T17:32:31+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000288s ]
[2025-08-25T17:32:31+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000876s ]
[2025-08-25T17:32:39+08:00][sql] CONNECT:[ UseTime:0.001485s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:32:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001398s ]
[2025-08-25T17:32:39+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-08-25T17:32:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001101s ]
[2025-08-25T17:32:39+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000200s ]
[2025-08-25T17:34:57+08:00][sql] CONNECT:[ UseTime:0.011087s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001259s ]
[2025-08-25T17:34:57+08:00][sql] SELECT * FROM `trade_game` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000333s ]
[2025-08-25T17:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000957s ]
[2025-08-25T17:34: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.000328s ]
[2025-08-25T17:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000914s ]
[2025-08-25T17:34: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.000415s ]
[2025-08-25T17:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001129s ]
[2025-08-25T17:34:57+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124' LIMIT 1 [ RunTime:0.000252s ]
[2025-08-25T17:34:57+08:00][sql] UPDATE `trade_order`  SET `tochaid` = 398841 , `tochaname` = 'ggh'  WHERE  `orderno` = 'P2025082517321094017124' [ RunTime:0.002814s ]
[2025-08-25T17:34:57+08:00][sql] CONNECT:[ UseTime:0.010739s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001221s ]
[2025-08-25T17:34: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.000387s ]
[2025-08-25T17:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000992s ]
[2025-08-25T17:34: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.000371s ]
[2025-08-25T17:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001080s ]
[2025-08-25T17:34:57+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124' LIMIT 1 [ RunTime:0.000338s ]
[2025-08-25T17:44:11+08:00][sql] CONNECT:[ UseTime:0.001518s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:44:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001451s ]
[2025-08-25T17:44: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.000402s ]
[2025-08-25T17:44:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001108s ]
[2025-08-25T17:44:11+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000417s ]
[2025-08-25T17:44:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001204s ]
[2025-08-25T17:44:11+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-08-25 16:39:11' AND '2025-08-25 17:39:11'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000426s ]
[2025-08-25T17:44:14+08:00][sql] CONNECT:[ UseTime:0.001440s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:44:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001442s ]
[2025-08-25T17:44: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.000374s ]
[2025-08-25T17:44:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001084s ]
[2025-08-25T17:44:14+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000323s ]
[2025-08-25T17:44:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001193s ]
[2025-08-25T17:44:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:39:13' AND '2025-08-25 17:39:13'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000381s ]
[2025-08-25T17:44:14+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:39:13' AND '2025-08-25 17:39:13'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000427s ]
[2025-08-25T17:44:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001214s ]
[2025-08-25T17:44:14+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.030486s ]
[2025-08-25T17:44:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001250s ]
[2025-08-25T17:44:14+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000313s ]
[2025-08-25T17:44:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000948s ]
[2025-08-25T17:44:14+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000298s ]
[2025-08-25T17:44:14+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000900s ]
[2025-08-25T17:44:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001078s ]
[2025-08-25T17:44:17+08:00][sql] CONNECT:[ UseTime:0.001529s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:44:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001400s ]
[2025-08-25T17:44: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.000423s ]
[2025-08-25T17:44:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001205s ]
[2025-08-25T17:44: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.000340s ]
[2025-08-25T17:44:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000343s ]
[2025-08-25T17:44:17+08:00][sql] SELECT `id`,`tid`,`content`,`created_at`,`is_read`,`trade_type`,`type`,`orderno` FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `deleted_at` IS NULL ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000376s ]
[2025-08-25T17:44:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001252s ]
[2025-08-25T17:44:17+08:00][sql] SELECT `id`,`tid`,`chaname` FROM `trade_role` WHERE  `tid` IN (76,73,72,70,59,47,27) [ RunTime:0.000379s ]
[2025-08-25T17:44:19+08:00][sql] CONNECT:[ UseTime:0.011123s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:44:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001416s ]
[2025-08-25T17:44: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.000505s ]
[2025-08-25T17:44:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001068s ]
[2025-08-25T17:44: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.000369s ]
[2025-08-25T17:44:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001225s ]
[2025-08-25T17:44: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-08-25 16:39:19' AND '2025-08-25 17:39:19'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000486s ]
[2025-08-25T17:44:21+08:00][sql] CONNECT:[ UseTime:0.010921s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:44:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001344s ]
[2025-08-25T17:44: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.000398s ]
[2025-08-25T17:44:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001018s ]
[2025-08-25T17:44: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.000319s ]
[2025-08-25T17:44:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001134s ]
[2025-08-25T17:44:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:39:21' AND '2025-08-25 17:39:21'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000351s ]
[2025-08-25T17:44:21+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:39:21' AND '2025-08-25 17:39:21'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000362s ]
[2025-08-25T17:44:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001330s ]
[2025-08-25T17:44:21+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.030268s ]
[2025-08-25T17:44:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001227s ]
[2025-08-25T17:44:21+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000313s ]
[2025-08-25T17:44:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000949s ]
[2025-08-25T17:44:21+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000290s ]
[2025-08-25T17:44:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000973s ]
[2025-08-25T17:44:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001114s ]
[2025-08-25T17:44:26+08:00][sql] CONNECT:[ UseTime:0.010433s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:44:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001333s ]
[2025-08-25T17:44: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.000376s ]
[2025-08-25T17:44:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000999s ]
[2025-08-25T17:44: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.000324s ]
[2025-08-25T17:44:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001103s ]
[2025-08-25T17:44:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:39:26' AND '2025-08-25 17:39:26'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000357s ]
[2025-08-25T17:44:26+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:39:26' AND '2025-08-25 17:39:26'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000363s ]
[2025-08-25T17:44:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001177s ]
[2025-08-25T17:44:26+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.029884s ]
[2025-08-25T17:44:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001239s ]
[2025-08-25T17:44:26+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000305s ]
[2025-08-25T17:44:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000935s ]
[2025-08-25T17:44:26+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000305s ]
[2025-08-25T17:44:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000951s ]
[2025-08-25T17:44:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001070s ]
[2025-08-25T17:45:10+08:00][sql] CONNECT:[ UseTime:0.011508s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:45:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001298s ]
[2025-08-25T17:45: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.000417s ]
[2025-08-25T17:45:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001473s ]
[2025-08-25T17:45:10+08:00][sql] SELECT `id`,`game`,`serverid`,`orderno`,`tid`,`pay_status`,`ordertype`,`relationid`,`tousername`,`tochaid`,`tochaname`,`order_details` FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124' LIMIT 1 [ RunTime:0.000271s ]
[2025-08-25T17:45:10+08:00][sql] UPDATE `trade_order`  SET `pay_status` = 1 , `tradeno` = '2025080222001415211432544858' , `paytime` = 1755487648  WHERE  `orderno` = 'P2025082517321094017124' [ RunTime:0.000341s ]
[2025-08-25T17:45:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001196s ]
[2025-08-25T17:45:10+08:00][sql] UPDATE `trade_prop`  SET `pay_status` = 2 , `trade_status` = 4  WHERE  `id` = 2 [ RunTime:0.000302s ]
[2025-08-25T17:45:10+08:00][sql] UPDATE `trade_order`  SET `api_status` = 1 , `totime` = 1756115110  WHERE  `id` = 27 [ RunTime:0.000258s ]
[2025-08-25T17:45:10+08:00][sql] UPDATE `trade_prop`  SET `api_status` = 1  WHERE  `id` = 2 [ RunTime:0.000228s ]
[2025-08-25T17:45:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001309s ]
[2025-08-25T17:45:10+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 82 , `username` = 'ctshaiya012' , `orderno` = 'P2025082517321094017124' , `trade_type` = 2 , `type` = 1 , `content` = '%s出售成功%s！如有疑问可联系官方客服咨询%s' [ RunTime:0.000293s ]
[2025-08-25T17:45:27+08:00][sql] CONNECT:[ UseTime:0.011557s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001328s ]
[2025-08-25T17: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.000440s ]
[2025-08-25T17:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001037s ]
[2025-08-25T17: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.000345s ]
[2025-08-25T17:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001074s ]
[2025-08-25T17:45:27+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124'  AND `tousername` = 'ctshaiya001' LIMIT 1 [ RunTime:0.000280s ]
[2025-08-25T17:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001110s ]
[2025-08-25T17:45:27+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 2  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000285s ]
[2025-08-25T17:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001144s ]
[2025-08-25T17:45:27+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 LIMIT 1 [ RunTime:0.039550s ]
[2025-08-25T17:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001210s ]
[2025-08-25T17:45:27+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000300s ]
[2025-08-25T17:45:27+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000946s ]
[2025-08-25T17:45:49+08:00][sql] CONNECT:[ UseTime:0.010381s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:45:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001327s ]
[2025-08-25T17:45: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.000565s ]
[2025-08-25T17:45:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001152s ]
[2025-08-25T17:45:49+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000355s ]
[2025-08-25T17:45:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001118s ]
[2025-08-25T17:45:49+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124'  AND `tousername` = 'ctshaiya001' LIMIT 1 [ RunTime:0.000287s ]
[2025-08-25T17:45:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001137s ]
[2025-08-25T17:45:49+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 2  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000285s ]
[2025-08-25T17:45:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001175s ]
[2025-08-25T17:45:49+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 LIMIT 1 [ RunTime:0.040321s ]
[2025-08-25T17:45:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001277s ]
[2025-08-25T17:45:49+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000296s ]
[2025-08-25T17:45:49+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000942s ]
[2025-08-25T17:45:50+08:00][sql] CONNECT:[ UseTime:0.010877s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:45:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001354s ]
[2025-08-25T17:45:50+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-08-25T17:45:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001005s ]
[2025-08-25T17:45:50+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-08-25T17:45:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001115s ]
[2025-08-25T17:45:50+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124'  AND `tousername` = 'ctshaiya001' LIMIT 1 [ RunTime:0.000267s ]
[2025-08-25T17:45:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001133s ]
[2025-08-25T17:45:50+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 2  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000312s ]
[2025-08-25T17:45:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001134s ]
[2025-08-25T17:45:50+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 LIMIT 1 [ RunTime:0.040441s ]
[2025-08-25T17:45:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001223s ]
[2025-08-25T17:45:50+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000290s ]
[2025-08-25T17:45:50+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000909s ]
[2025-08-25T17:45:51+08:00][sql] CONNECT:[ UseTime:0.010950s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001429s ]
[2025-08-25T17:45:51+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.000441s ]
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001108s ]
[2025-08-25T17:45:51+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000413s ]
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001204s ]
[2025-08-25T17:45:51+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124'  AND `tousername` = 'ctshaiya001' LIMIT 1 [ RunTime:0.000294s ]
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001178s ]
[2025-08-25T17:45:51+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 2  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000277s ]
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001245s ]
[2025-08-25T17:45:51+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 LIMIT 1 [ RunTime:0.042554s ]
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001366s ]
[2025-08-25T17:45:51+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000281s ]
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000991s ]
[2025-08-25T17:45:51+08:00][sql] CONNECT:[ UseTime:0.010852s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001408s ]
[2025-08-25T17:45:51+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-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001063s ]
[2025-08-25T17:45:51+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000347s ]
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001142s ]
[2025-08-25T17:45:51+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124'  AND `tousername` = 'ctshaiya001' LIMIT 1 [ RunTime:0.000299s ]
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001170s ]
[2025-08-25T17:45:51+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 2  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000295s ]
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001193s ]
[2025-08-25T17:45:51+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 LIMIT 1 [ RunTime:0.040014s ]
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001278s ]
[2025-08-25T17:45:51+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 82 [ RunTime:0.000293s ]
[2025-08-25T17:45:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001020s ]
[2025-08-25T17:45:55+08:00][sql] CONNECT:[ UseTime:0.010989s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:45:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001353s ]
[2025-08-25T17:45: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.000418s ]
[2025-08-25T17:45:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001150s ]
[2025-08-25T17:45:55+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya001'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000340s ]
[2025-08-25T17:45:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001162s ]
[2025-08-25T17:45:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tousername` = 'ctshaiya001'  AND `addtime` >= 1753523155 LIMIT 1 [ RunTime:0.000382s ]
[2025-08-25T17:45:55+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` = 'ctshaiya001'  AND `addtime` >= 1753523155 ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000313s ]
[2025-08-25T17:45:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001132s ]
[2025-08-25T17:45:55+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` = 48 [ RunTime:0.000406s ]
[2025-08-25T17:45:55+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'G2025080610065667409769' [ RunTime:0.000190s ]
[2025-08-25T17:45:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000968s ]
[2025-08-25T17:45:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001285s ]
[2025-08-25T17:45:55+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` = 49 [ RunTime:0.000435s ]
[2025-08-25T17:45:55+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'R2025080610063716860971' [ RunTime:0.000179s ]
[2025-08-25T17:45:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001117s ]
[2025-08-25T17:45:55+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` = 82 [ RunTime:0.000367s ]
[2025-08-25T17:45:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001210s ]
[2025-08-25T17:45:55+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 126052 [ RunTime:0.030386s ]
[2025-08-25T17:45:55+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'P2025082517321094017124' [ RunTime:0.000212s ]
[2025-08-25T17:45:57+08:00][sql] CONNECT:[ UseTime:0.011504s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:45:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001451s ]
[2025-08-25T17:45: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.000438s ]
[2025-08-25T17:45:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001125s ]
[2025-08-25T17:45: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.000360s ]
[2025-08-25T17:45:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001241s ]
[2025-08-25T17:45:57+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-08-25 16:40:57' AND '2025-08-25 17:40:57'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000484s ]
[2025-08-25T17:45:59+08:00][sql] CONNECT:[ UseTime:0.011398s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:45:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001366s ]
[2025-08-25T17:45:59+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-08-25T17:46:00+08:00][sql] CONNECT:[ UseTime:0.001511s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:46:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001362s ]
[2025-08-25T17:46: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.000426s ]
[2025-08-25T17:46:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001187s ]
[2025-08-25T17:46: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-08-25 16:41:00' AND '2025-08-25 17:41:00'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000422s ]
[2025-08-25T17:46:13+08:00][sql] CONNECT:[ UseTime:0.011439s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:46:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001437s ]
[2025-08-25T17:46: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.000444s ]
[2025-08-25T17:46:13+08:00][sql] CONNECT:[ UseTime:0.046207s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8
[2025-08-25T17:46:13+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.031199s ]
[2025-08-25T17:46:13+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE  `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.072614s ]
[2025-08-25T17:46:13+08:00][sql] CONNECT:[ UseTime:0.011485s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:46:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001278s ]
[2025-08-25T17:46: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.000406s ]
[2025-08-25T17:46:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001005s ]
[2025-08-25T17:46: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.000333s ]
[2025-08-25T17:46:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001126s ]
[2025-08-25T17:46: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-08-25 16:41:13' AND '2025-08-25 17:41:13'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000410s ]
[2025-08-25T17:46:19+08:00][sql] CONNECT:[ UseTime:0.001391s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:46:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001402s ]
[2025-08-25T17:46: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.000420s ]
[2025-08-25T17:46:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001032s ]
[2025-08-25T17:46: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.000335s ]
[2025-08-25T17:46:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000923s ]
[2025-08-25T17:46:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `created_at` >= '2025-05-27 17:46:19' LIMIT 1 [ RunTime:0.000452s ]
[2025-08-25T17:46:19+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `created_at` >= '2025-05-27 17:46:19' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000369s ]
[2025-08-25T17:46:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001066s ]
[2025-08-25T17:46:19+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,60) [ RunTime:0.000353s ]
[2025-08-25T17:46:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001047s ]
[2025-08-25T17:46:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001136s ]
[2025-08-25T17:46: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 (80,74,62) [ RunTime:0.000411s ]
[2025-08-25T17:46:19+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'R2025081810510949072728' [ RunTime:0.000202s ]
[2025-08-25T17:46:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001099s ]
[2025-08-25T17:46: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 `tid` = 81 [ RunTime:0.000371s ]
[2025-08-25T17:46:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001378s ]
[2025-08-25T17:46:19+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.033252s ]
[2025-08-25T17:46:20+08:00][sql] CONNECT:[ UseTime:0.010953s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:46:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001355s ]
[2025-08-25T17: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.000381s ]
[2025-08-25T17:46:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001044s ]
[2025-08-25T17:46:20+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-08-25T17:46:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001235s ]
[2025-08-25T17:46: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-08-25 16:41:20' AND '2025-08-25 17:41:20'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000447s ]
[2025-08-25T17:46:21+08:00][sql] CONNECT:[ UseTime:0.001424s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001282s ]
[2025-08-25T17: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.000409s ]
[2025-08-25T17:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001049s ]
[2025-08-25T17:46: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.000355s ]
[2025-08-25T17:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001117s ]
[2025-08-25T17:46:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:41:21' AND '2025-08-25 17:41:21'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000347s ]
[2025-08-25T17:46:21+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:41:21' AND '2025-08-25 17:41:21'   AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000380s ]
[2025-08-25T17:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001144s ]
[2025-08-25T17:46:21+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 [ RunTime:0.029572s ]
[2025-08-25T17:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001198s ]
[2025-08-25T17:46:21+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000297s ]
[2025-08-25T17:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000871s ]
[2025-08-25T17:46:21+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 GROUP BY `tid` [ RunTime:0.000316s ]
[2025-08-25T17:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000888s ]
[2025-08-25T17:46:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001044s ]
[2025-08-25T17:46:23+08:00][sql] CONNECT:[ UseTime:0.011387s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001499s ]
[2025-08-25T17:46:23+08:00][sql] SELECT * FROM `trade_game` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000359s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001007s ]
[2025-08-25T17:46: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.000433s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000979s ]
[2025-08-25T17:46: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.000376s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001050s ]
[2025-08-25T17:46:23+08:00][sql] SELECT * FROM `trade` WHERE  `id` = 83 LIMIT 1 [ RunTime:0.000350s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001065s ]
[2025-08-25T17:46:23+08:00][sql] SELECT * FROM `trade_prop` WHERE  `tid` = 83 [ RunTime:0.000300s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001058s ]
[2025-08-25T17:46:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE  `orderno` = 'P2025082517462348250203' LIMIT 1 [ RunTime:0.000283s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001260s ]
[2025-08-25T17:46:23+08:00][sql] SELECT `itemid`,`itemname` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 LIMIT 1 [ RunTime:0.011692s ]
[2025-08-25T17:46:23+08:00][sql] INSERT INTO `trade_order` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 83 , `orderno` = 'P2025082517462348250203' , `relationid` = 3 , `ordertype` = 2 , `charge` = '2.50' , `price` = '50.00' , `amount` = '47.50' , `tousername` = 'ctshaiya008' , `addtime` = 1756115183 , `order_details` = '{\"itemid\":42216,\"num\":1,\"goods_name\":\"神圣黄金狮(永久)\",\"outtime\":1756117908,\"sync_tradeno\":\"7367359940601643008\",\"username\":\"ctshaiya012\"}' [ RunTime:0.000306s ]
[2025-08-25T17:46:23+08:00][sql] UPDATE `trade_prop`  SET `trade_status` = 3 , `pay_status` = 1 , `orderno` = 'P2025082517462348250203'  WHERE  `id` = 3 [ RunTime:0.000288s ]
[2025-08-25T17:46:23+08:00][sql] CONNECT:[ UseTime:0.011296s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001224s ]
[2025-08-25T17:46: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.000392s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001016s ]
[2025-08-25T17:46: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.000323s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001083s ]
[2025-08-25T17:46:23+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517462348250203'  AND `tousername` = 'ctshaiya008' LIMIT 1 [ RunTime:0.000261s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001098s ]
[2025-08-25T17:46:23+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 3  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000313s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001160s ]
[2025-08-25T17:46:23+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 LIMIT 1 [ RunTime:0.017665s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001182s ]
[2025-08-25T17:46:23+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000288s ]
[2025-08-25T17:46:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000906s ]
[2025-08-25T17:46:27+08:00][sql] CONNECT:[ UseTime:0.010500s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:46:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001485s ]
[2025-08-25T17:46: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.000473s ]
[2025-08-25T17:46:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001135s ]
[2025-08-25T17:46: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.000349s ]
[2025-08-25T17:46:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001154s ]
[2025-08-25T17:46:27+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 3  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000309s ]
[2025-08-25T17:46:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001143s ]
[2025-08-25T17:46:27+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 LIMIT 1 [ RunTime:0.017658s ]
[2025-08-25T17:46:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001232s ]
[2025-08-25T17:46:27+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000286s ]
[2025-08-25T17:46:27+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000885s ]
[2025-08-25T17:46:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001103s ]
[2025-08-25T17:46:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000919s ]
[2025-08-25T17:46:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `type` = 2  AND `relationid` = 3 LIMIT 1 [ RunTime:0.000304s ]
[2025-08-25T17:46:36+08:00][sql] CONNECT:[ UseTime:0.001544s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:46:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001503s ]
[2025-08-25T17:46:36+08:00][sql] SELECT * FROM `trade_game` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000320s ]
[2025-08-25T17:46:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001072s ]
[2025-08-25T17:46:36+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-08-25T17:46:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001041s ]
[2025-08-25T17:46:36+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000397s ]
[2025-08-25T17:46:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001142s ]
[2025-08-25T17:46:36+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517462348250203' LIMIT 1 [ RunTime:0.000346s ]
[2025-08-25T17:46:36+08:00][sql] UPDATE `trade_order`  SET `tochaid` = 364994 , `tochaname` = 'err1'  WHERE  `orderno` = 'P2025082517462348250203' [ RunTime:0.001942s ]
[2025-08-25T17:46:36+08:00][sql] CONNECT:[ UseTime:0.010385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:46:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001207s ]
[2025-08-25T17:46:36+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-08-25T17:46:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001118s ]
[2025-08-25T17:46:36+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya008'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000352s ]
[2025-08-25T17:46:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001260s ]
[2025-08-25T17:46:36+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517462348250203' LIMIT 1 [ RunTime:0.000257s ]
[2025-08-25T17:47:09+08:00][sql] CONNECT:[ UseTime:0.010913s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:47:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001436s ]
[2025-08-25T17:47: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.000438s ]
[2025-08-25T17:47:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001586s ]
[2025-08-25T17:47:09+08:00][sql] SELECT `id`,`game`,`serverid`,`orderno`,`tid`,`pay_status`,`ordertype`,`relationid`,`tousername`,`tochaid`,`tochaname`,`order_details` FROM `trade_order` WHERE  `orderno` = 'P2025082517462348250203' LIMIT 1 [ RunTime:0.000308s ]
[2025-08-25T17:47:09+08:00][sql] UPDATE `trade_order`  SET `pay_status` = 1 , `tradeno` = '2025080222001415211432544858' , `paytime` = 1755487648  WHERE  `orderno` = 'P2025082517462348250203' [ RunTime:0.000377s ]
[2025-08-25T17:47:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001332s ]
[2025-08-25T17:47:09+08:00][sql] UPDATE `trade_prop`  SET `pay_status` = 2 , `trade_status` = 4  WHERE  `id` = 3 [ RunTime:0.000273s ]
[2025-08-25T17:47:09+08:00][sql] UPDATE `trade_order`  SET `api_status` = 1 , `totime` = 1756115229  WHERE  `id` = 28 [ RunTime:0.000272s ]
[2025-08-25T17:47:09+08:00][sql] UPDATE `trade_prop`  SET `api_status` = 1  WHERE  `id` = 3 [ RunTime:0.000260s ]
[2025-08-25T17:47:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001061s ]
[2025-08-25T17:47:09+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 83 , `username` = 'ctshaiya012' , `orderno` = 'P2025082517462348250203' , `trade_type` = 2 , `type` = 1 , `content` = '%s出售成功%s！如有疑问可联系官方客服咨询%s' [ RunTime:0.000246s ]
[2025-08-25T17:47:18+08:00][sql] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:47:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001277s ]
[2025-08-25T17:47:18+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-08-25T17:47:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001006s ]
[2025-08-25T17:47:18+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-08-25T17:47:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001040s ]
[2025-08-25T17:47:18+08:00][sql] SELECT * FROM `trade_order` WHERE  `orderno` = 'P2025082517462348250203'  AND `tousername` = 'ctshaiya008' LIMIT 1 [ RunTime:0.000296s ]
[2025-08-25T17:47:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001062s ]
[2025-08-25T17:47:18+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE  `id` = 3  AND `game` = 'shaiya5'  AND `serverid` = 5 LIMIT 1 [ RunTime:0.000294s ]
[2025-08-25T17:47:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001176s ]
[2025-08-25T17:47:18+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 LIMIT 1 [ RunTime:0.017081s ]
[2025-08-25T17:47:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001168s ]
[2025-08-25T17:47:18+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000288s ]
[2025-08-25T17:47:18+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000918s ]
[2025-08-25T17:47:57+08:00][sql] CONNECT:[ UseTime:0.001480s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:47:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001398s ]
[2025-08-25T17:47: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.000399s ]
[2025-08-25T17:47:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001041s ]
[2025-08-25T17:47:57+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-08-25T17:47:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001224s ]
[2025-08-25T17:47:57+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-08-25 16:42:57' AND '2025-08-25 17:42:57'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000465s ]
[2025-08-25T17:47:59+08:00][sql] CONNECT:[ UseTime:0.010632s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:47:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001325s ]
[2025-08-25T17:47: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.000401s ]
[2025-08-25T17:47:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001005s ]
[2025-08-25T17:47:59+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-08-25T17:47:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001174s ]
[2025-08-25T17:47:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:42:59' AND '2025-08-25 17:42:59'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000455s ]
[2025-08-25T17:48:00+08:00][sql] CONNECT:[ UseTime:0.011059s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:48:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001456s ]
[2025-08-25T17:48: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.000477s ]
[2025-08-25T17:48:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001120s ]
[2025-08-25T17:48: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.000368s ]
[2025-08-25T17:48:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001231s ]
[2025-08-25T17:48:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` >= '2025-08-25 17:43:00' LIMIT 1 [ RunTime:0.000419s ]
[2025-08-25T17:48:00+08:00][sql] CONNECT:[ UseTime:0.001464s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:48:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001464s ]
[2025-08-25T17:48: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.000374s ]
[2025-08-25T17:48:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001124s ]
[2025-08-25T17:48: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.000338s ]
[2025-08-25T17:48:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001122s ]
[2025-08-25T17:48:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `pay_status` = 0  AND `trade_status` IN (1,2)  AND `created_at` BETWEEN '2025-08-25 16:43:00' AND '2025-08-25 17:43:00'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000346s ]
[2025-08-25T17:50:10+08:00][sql] CONNECT:[ UseTime:0.010354s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:50:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001242s ]
[2025-08-25T17:50: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.000378s ]
[2025-08-25T17:50:11+08:00][sql] CONNECT:[ UseTime:0.010929s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:50:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001388s ]
[2025-08-25T17:50: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.000397s ]
[2025-08-25T17:50:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001208s ]
[2025-08-25T17:50:11+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-08-25 16:45:11' AND '2025-08-25 17:45:11'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000457s ]
[2025-08-25T17:50:18+08:00][sql] CONNECT:[ UseTime:0.011457s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:50:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001339s ]
[2025-08-25T17:50:18+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-08-25T17:50:18+08:00][sql] CONNECT:[ UseTime:0.044817s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8
[2025-08-25T17:50:18+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.030319s ]
[2025-08-25T17:50:18+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE  `username` = 'ctshaiya013' LIMIT 1 [ RunTime:0.071980s ]
[2025-08-25T17:50:19+08:00][sql] CONNECT:[ UseTime:0.010913s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:50:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001376s ]
[2025-08-25T17:50: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.000395s ]
[2025-08-25T17:50:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001061s ]
[2025-08-25T17:50:19+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000357s ]
[2025-08-25T17:50:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001235s ]
[2025-08-25T17:50: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-08-25 16:45:19' AND '2025-08-25 17:45:19'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000446s ]
[2025-08-25T17:50:20+08:00][sql] CONNECT:[ UseTime:0.010809s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:50:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001307s ]
[2025-08-25T17:50: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.000394s ]
[2025-08-25T17:50:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001011s ]
[2025-08-25T17:50:20+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000337s ]
[2025-08-25T17:50:20+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000955s ]
[2025-08-25T17:50:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `created_at` >= '2025-05-27 17:50:20' LIMIT 1 [ RunTime:0.000446s ]
[2025-08-25T17:50:20+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `created_at` >= '2025-05-27 17:50:20' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000403s ]
[2025-08-25T17:50:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001076s ]
[2025-08-25T17:50:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001129s ]
[2025-08-25T17:50: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 (58,56) [ RunTime:0.000405s ]
[2025-08-25T17:50:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001021s ]
[2025-08-25T17:50:20+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025080611234024256924','R2025080614044114693721') [ RunTime:0.000253s ]
[2025-08-25T17:50:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001092s ]
[2025-08-25T17:50: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.000242s ]
[2025-08-25T17:50:22+08:00][sql] CONNECT:[ UseTime:0.011317s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:50:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001366s ]
[2025-08-25T17:50: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.000424s ]
[2025-08-25T17:50:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001088s ]
[2025-08-25T17:50:22+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya013'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000389s ]
[2025-08-25T17:50:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001131s ]
[2025-08-25T17:50:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tousername` = 'ctshaiya013'  AND `addtime` >= 1753523422 LIMIT 1 [ RunTime:0.000315s ]
[2025-08-25T17:50:22+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` >= 1753523422 ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000354s ]
[2025-08-25T17:50:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001143s ]
[2025-08-25T17:50:22+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.000396s ]
[2025-08-25T17:50:22+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` = 'G2025080610424847237182' [ RunTime:0.000186s ]
[2025-08-25T17:50:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000977s ]
[2025-08-25T17:50:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001216s ]
[2025-08-25T17:50: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 (76,75,73,74) [ RunTime:0.000387s ]
[2025-08-25T17:50:22+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('R2025081810572529886534','R2025081811065120144614','R2025081811000411730555','R2025081810510949072728') [ RunTime:0.000254s ]
[2025-08-25T17:50:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001163s ]
[2025-08-25T17:50: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.000265s ]
[2025-08-25T17:50:29+08:00][sql] CONNECT:[ UseTime:0.001455s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:50:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001275s ]
[2025-08-25T17:50:29+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-08-25T17:50:30+08:00][sql] CONNECT:[ UseTime:0.010995s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:50:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001418s ]
[2025-08-25T17:50: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.000385s ]
[2025-08-25T17:50:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001358s ]
[2025-08-25T17:50:30+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-08-25 16:45:30' AND '2025-08-25 17:45:30'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000477s ]
[2025-08-25T17:50:45+08:00][sql] CONNECT:[ UseTime:0.011522s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:50:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001349s ]
[2025-08-25T17:50: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.000372s ]
[2025-08-25T17:50:45+08:00][sql] CONNECT:[ UseTime:0.047852s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8
[2025-08-25T17:50:45+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.032428s ]
[2025-08-25T17:50:45+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE  `username` = 'ctshaiya012' LIMIT 1 [ RunTime:0.074286s ]
[2025-08-25T17:51:18+08:00][sql] CONNECT:[ UseTime:0.011109s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:51:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001454s ]
[2025-08-25T17:51:18+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.000471s ]
[2025-08-25T17:51:24+08:00][sql] CONNECT:[ UseTime:0.010505s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:51:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001333s ]
[2025-08-25T17:51: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.000402s ]
[2025-08-25T17:51:24+08:00][sql] CONNECT:[ UseTime:0.043346s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8
[2025-08-25T17:51:24+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.029323s ]
[2025-08-25T17:51:24+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE  `username` = 'ctshaiya012' LIMIT 1 [ RunTime:0.071350s ]
[2025-08-25T17:51:24+08:00][sql] CONNECT:[ UseTime:0.011058s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:51:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001384s ]
[2025-08-25T17:51: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.000480s ]
[2025-08-25T17:51:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001120s ]
[2025-08-25T17:51:24+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya012'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000340s ]
[2025-08-25T17:51:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001219s ]
[2025-08-25T17:51: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-08-25 16:46:24' AND '2025-08-25 17:46:24'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000448s ]
[2025-08-25T17:51:28+08:00][sql] CONNECT:[ UseTime:0.001396s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:51:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001264s ]
[2025-08-25T17:51: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.000401s ]
[2025-08-25T17:51:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001004s ]
[2025-08-25T17:51: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.000333s ]
[2025-08-25T17:51:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000935s ]
[2025-08-25T17:51:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya012'  AND `created_at` >= '2025-05-27 17:51:28' LIMIT 1 [ RunTime:0.000414s ]
[2025-08-25T17:51:28+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya012'  AND `created_at` >= '2025-05-27 17:51:28' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000420s ]
[2025-08-25T17:51:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001103s ]
[2025-08-25T17:51:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001158s ]
[2025-08-25T17:51:28+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 0 = 1 [ RunTime:0.000261s ]
[2025-08-25T17:51:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001075s ]
[2025-08-25T17:51:28+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` IN (83,82) [ RunTime:0.000326s ]
[2025-08-25T17:51:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001187s ]
[2025-08-25T17:51:28+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` IN (126052,42216) [ RunTime:0.030382s ]
[2025-08-25T17:51:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001074s ]
[2025-08-25T17:51:28+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE  `orderno` IN ('P2025082517321094017124','P2025082517462348250203') [ RunTime:0.000264s ]
[2025-08-25T17:51:31+08:00][sql] CONNECT:[ UseTime:0.001491s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:51:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001451s ]
[2025-08-25T17:51: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.000390s ]
[2025-08-25T17:51:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001119s ]
[2025-08-25T17:51: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.000314s ]
[2025-08-25T17:51:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001179s ]
[2025-08-25T17:51:31+08:00][sql] SELECT * FROM `trade_prop` WHERE  `id` = 3  AND `username` = 'ctshaiya012' LIMIT 1 [ RunTime:0.000314s ]
[2025-08-25T17:51:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001242s ]
[2025-08-25T17:51:31+08:00][sql] SELECT * FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` = 42216 LIMIT 1 [ RunTime:0.018411s ]
[2025-08-25T17:51:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001357s ]
[2025-08-25T17:51:31+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `tid` = 83 [ RunTime:0.000283s ]
[2025-08-25T17:51:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001154s ]
[2025-08-25T17:51:31+08:00][sql] SELECT `id`,`orderno`,`charge`,`price`,`amount`,`withdraw_status`,`pay_status`,`addtime`,`paytime` FROM `trade_order` WHERE  `relationid` = 3  AND `ordertype` = 2  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000295s ]
[2025-08-25T17:51:31+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001025s ]
[2025-08-25T17:51:51+08:00][sql] CONNECT:[ UseTime:0.001542s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:51:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001301s ]
[2025-08-25T17:51:51+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-08-25T17:51:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001021s ]
[2025-08-25T17:51:51+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya012'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000323s ]
[2025-08-25T17:51:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya012'  AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000312s ]
[2025-08-25T17:51:51+08:00][sql] SELECT `id`,`tid`,`content`,`created_at`,`is_read`,`trade_type`,`type`,`orderno` FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya012'  AND `deleted_at` IS NULL ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000291s ]
[2025-08-25T17:51:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001121s ]
[2025-08-25T17:51:51+08:00][sql] SELECT `id`,`tid`,`num`,`itemid` FROM `trade_prop` WHERE  `tid` IN (83,82) [ RunTime:0.000267s ]
[2025-08-25T17:51:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001156s ]
[2025-08-25T17:51:51+08:00][sql] SELECT `itemid`,`itemname` FROM `trade_items` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `itemid` IN (126052,42216) [ RunTime:0.027628s ]
[2025-08-25T17:51:54+08:00][sql] CONNECT:[ UseTime:0.010418s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:51:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001277s ]
[2025-08-25T17:51: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.000391s ]
[2025-08-25T17:51:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000989s ]
[2025-08-25T17:51:54+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya012'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000322s ]
[2025-08-25T17:51:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001134s ]
[2025-08-25T17:51:54+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-08-25 16:46:54' AND '2025-08-25 17:46:54'   AND `specuser` = '' LIMIT 1 [ RunTime:0.000396s ]
[2025-08-25T17:51:58+08:00][sql] CONNECT:[ UseTime:0.011016s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:51:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001329s ]
[2025-08-25T17:51: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-08-25T17:51:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001001s ]
[2025-08-25T17:51:58+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya012'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000321s ]
[2025-08-25T17:51:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE  `game` = 'shaiya5'  AND `status` = 1 LIMIT 1 [ RunTime:0.000272s ]
[2025-08-25T17:51: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.000261s ]
[2025-08-25T17:51: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.000271s ]
[2025-08-25T17:52:00+08:00][sql] CONNECT:[ UseTime:0.011410s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:52:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001282s ]
[2025-08-25T17:52: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.000381s ]
[2025-08-25T17:52:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000959s ]
[2025-08-25T17:52:00+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya012'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000309s ]
[2025-08-25T17:52:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE  `game` = 'shaiya5'  AND `status` = 1 LIMIT 1 [ RunTime:0.000243s ]
[2025-08-25T17:52:00+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.000241s ]
[2025-08-25T17:52:00+08:00][sql] SELECT `mark`,`title`,`content` FROM `trade_help_article` WHERE  `game` = 'shaiya5'  AND `status` = 1  AND `mark` = 'cfMRODXWHqpAiCksiGsUkKrFFgPcWyNe' ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.000295s ]
[2025-08-25T17:52:02+08:00][sql] CONNECT:[ UseTime:0.010412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001460s ]
[2025-08-25T17:52: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.000466s ]
[2025-08-25T17:52:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001080s ]
[2025-08-25T17:52:02+08:00][sql] SELECT * FROM `trade_notice` WHERE  `game` = 'shaiya5'  AND `serverid` = 5  AND `username` = 'ctshaiya012'  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000360s ]
[2025-08-25T17:52:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE  `game` = 'shaiya5'  AND `status` = 1 LIMIT 1 [ RunTime:0.000271s ]
[2025-08-25T17:52:02+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.000240s ]
[2025-08-25T17:52:02+08:00][sql] SELECT `mark`,`title`,`content` FROM `trade_help_article` WHERE  `game` = 'shaiya5'  AND `status` = 1  AND `mark` = 'fokfROPICmuorkhgwKHfJonofSxivLKW' ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.000255s ]
[2025-08-25T17:56:14+08:00][sql] CONNECT:[ UseTime:0.010566s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T17:56:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001360s ]
[2025-08-25T17:56:14+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.000458s ]
[2025-08-25T17:56:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001089s ]
[2025-08-25T17:56:14+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000210s ]
[2025-08-25T18:43:29+08:00][sql] CONNECT:[ UseTime:0.001522s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-08-25T18:43:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001467s ]
[2025-08-25T18:43:29+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.000403s ]
[2025-08-25T18:43:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001115s ]
[2025-08-25T18:43:29+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000291s ]