[2026-02-09T15:06:45+08:00][sql] CONNECT:[ UseTime:0.001557s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T15:06:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001319s ] [2026-02-09T15:06:45+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000426s ] [2026-02-09T15:06:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001010s ] [2026-02-09T15:06:45+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000236s ] [2026-02-09T16:27:17+08:00][sql] CONNECT:[ UseTime:0.011140s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T16:27:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001472s ] [2026-02-09T16:27:17+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.000519s ] [2026-02-09T16:27:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001103s ] [2026-02-09T16:27:17+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000210s ] [2026-02-09T16:27:19+08:00][sql] CONNECT:[ UseTime:0.001470s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T16:27:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001410s ] [2026-02-09T16:27:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000466s ] [2026-02-09T16:27:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001036s ] [2026-02-09T16:27:19+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '116dbfb732616492e66bc9c04e703fd8' AND `status` = 1 LIMIT 1 [ RunTime:0.000288s ] [2026-02-09T16:27:19+08:00][sql] CONNECT:[ UseTime:0.011609s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T16:27:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001120s ] [2026-02-09T16:27: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.000396s ] [2026-02-09T16:27:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001286s ] [2026-02-09T16:27: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 '2026-02-09 15:22:19' AND '2026-02-09 16:22:19' AND `specuser` = '' LIMIT 1 [ RunTime:0.000488s ] [2026-02-09T16:27:24+08:00][sql] CONNECT:[ UseTime:0.001444s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T16:27:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001286s ] [2026-02-09T16:27: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.000381s ] [2026-02-09T16:27:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001163s ] [2026-02-09T16:27: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 '2026-02-09 15:22:24' AND '2026-02-09 16:22:24' AND `specuser` = '' LIMIT 1 [ RunTime:0.000382s ] [2026-02-09T16:27:26+08:00][sql] CONNECT:[ UseTime:0.010411s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T16:27:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001455s ] [2026-02-09T16:27: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.000472s ] [2026-02-09T16:27:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001255s ] [2026-02-09T16:27: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` >= '2026-02-09 16:22:26' LIMIT 1 [ RunTime:0.000443s ] [2026-02-09T16:27: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` >= '2026-02-09 16:22:26' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000369s ] [2026-02-09T16:27:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001268s ] [2026-02-09T16:27:26+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 126006 [ RunTime:0.031221s ] [2026-02-09T16:27:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001272s ] [2026-02-09T16:27:26+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 161 [ RunTime:0.000335s ] [2026-02-09T16:27:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000973s ] [2026-02-09T16:27:26+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 161 GROUP BY `tid` [ RunTime:0.000294s ] [2026-02-09T16:27:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001023s ] [2026-02-09T16:27:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001224s ] [2026-02-09T17:39:53+08:00][sql] CONNECT:[ UseTime:0.001427s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T17:39:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001295s ] [2026-02-09T17:39: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.000408s ] [2026-02-09T17:39:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001215s ] [2026-02-09T17:39:53+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` >= '2026-02-09 17:34:53' LIMIT 1 [ RunTime:0.000398s ] [2026-02-09T17:40:03+08:00][sql] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T17:40:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001357s ] [2026-02-09T17:40:03+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000441s ] [2026-02-09T17:40:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001244s ] [2026-02-09T17:40:03+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` >= '2026-02-09 17:35:03' LIMIT 1 [ RunTime:0.000357s ] [2026-02-09T17:49:41+08:00][sql] CONNECT:[ UseTime:0.001535s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T17:49:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001341s ] [2026-02-09T17:49:41+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000445s ] [2026-02-09T17:49:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001225s ] [2026-02-09T17:49:41+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` >= '2026-02-09 17:44:41' LIMIT 1 [ RunTime:0.000418s ] [2026-02-09T20:52:04+08:00][sql] CONNECT:[ UseTime:0.001584s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T20:52:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001469s ] [2026-02-09T20:52:04+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.000450s ] [2026-02-09T20:52:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001102s ] [2026-02-09T20:52:04+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000328s ] [2026-02-09T21:38:59+08:00][sql] CONNECT:[ UseTime:0.001473s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T21:38:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001249s ] [2026-02-09T21:38: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.000467s ] [2026-02-09T21:38:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001008s ] [2026-02-09T21:38:59+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000228s ] [2026-02-09T23:16:19+08:00][sql] CONNECT:[ UseTime:0.001534s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-02-09T23:16:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001294s ] [2026-02-09T23:16:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000433s ] [2026-02-09T23:16:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001002s ] [2026-02-09T23:16:19+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000260s ]