[2025-08-26T00:46:56+08:00][sql] CONNECT:[ UseTime:0.001536s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T00:46:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001349s ] [2025-08-26T00:46:56+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000430s ] [2025-08-26T00:46:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001026s ] [2025-08-26T00:46:56+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000223s ] [2025-08-26T01:01:38+08:00][sql] CONNECT:[ UseTime:0.001466s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T01:01:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001281s ] [2025-08-26T01:01:38+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.000431s ] [2025-08-26T01:01:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000986s ] [2025-08-26T01:01:38+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000205s ] [2025-08-26T01:04:31+08:00][sql] CONNECT:[ UseTime:0.010470s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T01:04:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001278s ] [2025-08-26T01:04:31+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-26T01:04:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001032s ] [2025-08-26T01:04:31+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000206s ] [2025-08-26T02:01:26+08:00][sql] CONNECT:[ UseTime:0.001398s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T02:01:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001259s ] [2025-08-26T02:01:26+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-26T02:01:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000972s ] [2025-08-26T02:01:26+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000259s ] [2025-08-26T16:11:25+08:00][sql] CONNECT:[ UseTime:0.001528s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T16:11:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001314s ] [2025-08-26T16:11:25+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000434s ] [2025-08-26T16:11:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001015s ] [2025-08-26T16:11:25+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000214s ] [2025-08-26T16:11:28+08:00][sql] CONNECT:[ UseTime:0.011816s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T16:11:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001305s ] [2025-08-26T16:11:28+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.000430s ] [2025-08-26T16:11:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001026s ] [2025-08-26T16:11:28+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '116dbfb732616492e66bc9c04e703fd8' AND `status` = 1 LIMIT 1 [ RunTime:0.000281s ] [2025-08-26T16:11:28+08:00][sql] CONNECT:[ UseTime:0.011726s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T16:11:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001219s ] [2025-08-26T16:11: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.000432s ] [2025-08-26T16:11:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001171s ] [2025-08-26T16:11:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-26 15:06:28' AND '2025-08-26 16:06:28' AND `specuser` = '' LIMIT 1 [ RunTime:0.000429s ] [2025-08-26T16:11:29+08:00][sql] CONNECT:[ UseTime:0.011250s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T16:11:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001243s ] [2025-08-26T16:11:29+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000371s ] [2025-08-26T16:11:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001129s ] [2025-08-26T16:11:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-26 16:06:29' LIMIT 1 [ RunTime:0.000391s ] [2025-08-26T16:11:30+08:00][sql] CONNECT:[ UseTime:0.010982s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T16:11:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001320s ] [2025-08-26T16:11: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.000386s ] [2025-08-26T16:11:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001187s ] [2025-08-26T16:11: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-26 15:06:30' AND '2025-08-26 16:06:30' AND `specuser` = '' LIMIT 1 [ RunTime:0.000423s ] [2025-08-26T16:11:32+08:00][sql] CONNECT:[ UseTime:0.010642s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T16:11:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001233s ] [2025-08-26T16:11:32+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000372s ] [2025-08-26T16:11:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001114s ] [2025-08-26T16:11:32+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-26 15:06:32' AND '2025-08-26 16:06:32' AND `specuser` = '' LIMIT 1 [ RunTime:0.000438s ] [2025-08-26T16:11:32+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-26 15:06:32' AND '2025-08-26 16:06:32' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000374s ] [2025-08-26T16:11:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001128s ] [2025-08-26T16:11:32+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.028625s ] [2025-08-26T16:11:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001215s ] [2025-08-26T16:11:32+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 84 [ RunTime:0.000288s ] [2025-08-26T16:11:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000908s ] [2025-08-26T16:11:32+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 84 GROUP BY `tid` [ RunTime:0.000369s ] [2025-08-26T16:11:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000891s ] [2025-08-26T16:11:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001078s ] [2025-08-26T16:11:33+08:00][sql] CONNECT:[ UseTime:0.011387s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T16:11:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001319s ] [2025-08-26T16:11:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000396s ] [2025-08-26T16:11:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001177s ] [2025-08-26T16:11:33+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-26 16:06:33' LIMIT 1 [ RunTime:0.000364s ] [2025-08-26T16:11:33+08:00][sql] CONNECT:[ UseTime:0.011235s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T16:11:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001303s ] [2025-08-26T16:11:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000393s ] [2025-08-26T16:11:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001196s ] [2025-08-26T16:11:33+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-26 15:06:33' AND '2025-08-26 16:06:33' AND `specuser` = '' LIMIT 1 [ RunTime:0.000364s ] [2025-08-26T16:11:33+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-26 15:06:33' AND '2025-08-26 16:06:33' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000436s ] [2025-08-26T16:11:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001189s ] [2025-08-26T16:11:33+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.030463s ] [2025-08-26T16:11:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001243s ] [2025-08-26T16:11:33+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 84 [ RunTime:0.000314s ] [2025-08-26T16:11:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000901s ] [2025-08-26T16:11:33+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 84 GROUP BY `tid` [ RunTime:0.000283s ] [2025-08-26T16:11:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000947s ] [2025-08-26T16:11:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001135s ] [2025-08-26T16:11:40+08:00][sql] CONNECT:[ UseTime:0.010384s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-26T16:11:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001365s ] [2025-08-26T16:11: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.000449s ] [2025-08-26T16:11:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001352s ] [2025-08-26T16:11:40+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` = 4 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000362s ] [2025-08-26T16:11:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001220s ] [2025-08-26T16:11:40+08:00][sql] SELECT * FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 LIMIT 1 [ RunTime:0.018098s ] [2025-08-26T16:11:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001223s ] [2025-08-26T16:11:40+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 84 [ RunTime:0.000318s ] [2025-08-26T16:11:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000969s ] [2025-08-26T16:11:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001131s ] [2025-08-26T16:11:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000974s ]