[2025-07-04T02:10:23+08:00][sql] CONNECT:[ UseTime:0.001436s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T02:10:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001202s ] [2025-07-04T02:10:23+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000347s ] [2025-07-04T02:10:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000968s ] [2025-07-04T02:10:23+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000198s ] [2025-07-04T02:10:26+08:00][sql] CONNECT:[ UseTime:0.010533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T02:10:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001434s ] [2025-07-04T02:10:26+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000455s ] [2025-07-04T02:10:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001102s ] [2025-07-04T02:10:26+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000218s ] [2025-07-04T02:14:52+08:00][sql] CONNECT:[ UseTime:0.011255s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T02:14:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001264s ] [2025-07-04T02:14:52+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000389s ] [2025-07-04T02:14:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000999s ] [2025-07-04T02:14:52+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000232s ] [2025-07-04T02:15:06+08:00][sql] CONNECT:[ UseTime:0.011060s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T02:15:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001223s ] [2025-07-04T02:15:06+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000353s ] [2025-07-04T02:15:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000976s ] [2025-07-04T02:15:06+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000206s ] [2025-07-04T03:23:20+08:00][sql] CONNECT:[ UseTime:0.001705s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T03:23:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001358s ] [2025-07-04T03:23:20+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000446s ] [2025-07-04T03:23:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001093s ] [2025-07-04T03:23:20+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000216s ] [2025-07-04T03:31:46+08:00][sql] CONNECT:[ UseTime:0.001652s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T03:31:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001479s ] [2025-07-04T03:31:46+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000357s ] [2025-07-04T03:31:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001129s ] [2025-07-04T03:31:46+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000296s ] [2025-07-04T08:56:05+08:00][sql] CONNECT:[ UseTime:0.001515s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T08:56:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001272s ] [2025-07-04T08:56:05+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000375s ] [2025-07-04T08:56:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001020s ] [2025-07-04T08:56:05+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000267s ] [2025-07-04T08:56:07+08:00][sql] CONNECT:[ UseTime:0.001399s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T08:56:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001212s ] [2025-07-04T08:56:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000349s ] [2025-07-04T08:56:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000967s ] [2025-07-04T08:56:07+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '230a289f190b079d7a6bbc0163bc182b' AND `status` = 1 LIMIT 1 [ RunTime:0.000275s ] [2025-07-04T08:56:07+08:00][sql] CONNECT:[ UseTime:0.010969s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T08:56:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001269s ] [2025-07-04T08:56:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000369s ] [2025-07-04T08:56:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001175s ] [2025-07-04T08:56:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 07:51:07' AND '2025-07-04 08:51:07' AND `specuser` = '' LIMIT 1 [ RunTime:0.000348s ] [2025-07-04T09:33:19+08:00][sql] CONNECT:[ UseTime:0.001539s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:33:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001397s ] [2025-07-04T09:33:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000346s ] [2025-07-04T09:33:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001073s ] [2025-07-04T09:33:19+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000284s ] [2025-07-04T09:33:21+08:00][sql] CONNECT:[ UseTime:0.001462s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:33:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001265s ] [2025-07-04T09:33:21+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000380s ] [2025-07-04T09:33:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001062s ] [2025-07-04T09:33:21+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '230a289f190b079d7a6bbc0163bc182b' AND `status` = 1 LIMIT 1 [ RunTime:0.000292s ] [2025-07-04T09:33:21+08:00][sql] CONNECT:[ UseTime:0.001408s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:33:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001264s ] [2025-07-04T09:33:21+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000365s ] [2025-07-04T09:33:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001156s ] [2025-07-04T09:33:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 08:28:21' AND '2025-07-04 09:28:21' AND `specuser` = '' LIMIT 1 [ RunTime:0.000375s ] [2025-07-04T09:33:23+08:00][sql] CONNECT:[ UseTime:0.011006s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:33:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001269s ] [2025-07-04T09:33:23+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000360s ] [2025-07-04T09:33:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001024s ] [2025-07-04T09:33:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '' AND `created_at` >= '2025-06-04 09:33:23' LIMIT 1 [ RunTime:0.000368s ] [2025-07-04T09:33:30+08:00][sql] CONNECT:[ UseTime:0.011675s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:33:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001426s ] [2025-07-04T09:33:30+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000445s ] [2025-07-04T09:33:30+08:00][sql] CONNECT:[ UseTime:0.045526s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-07-04T09:33:30+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.030830s ] [2025-07-04T09:33:30+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya007' LIMIT 1 [ RunTime:0.033268s ] [2025-07-04T09:33:30+08:00][sql] CONNECT:[ UseTime:0.012183s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:33:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001365s ] [2025-07-04T09:33:30+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000392s ] [2025-07-04T09:33:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001092s ] [2025-07-04T09:33:30+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000429s ] [2025-07-04T09:33:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001014s ] [2025-07-04T09:33:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `created_at` >= '2025-06-04 09:33:30' LIMIT 1 [ RunTime:0.000356s ] [2025-07-04T09:33:33+08:00][sql] CONNECT:[ UseTime:0.011514s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:33:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001283s ] [2025-07-04T09:33:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000363s ] [2025-07-04T09:33:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001028s ] [2025-07-04T09:33:33+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000311s ] [2025-07-04T09:33:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001115s ] [2025-07-04T09:33:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 08:28:33' AND '2025-07-04 09:28:33' AND `specuser` = '' LIMIT 1 [ RunTime:0.000359s ] [2025-07-04T09:33:34+08:00][sql] CONNECT:[ UseTime:0.010961s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:33:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001353s ] [2025-07-04T09:33:34+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000352s ] [2025-07-04T09:33:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001083s ] [2025-07-04T09:33:34+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000304s ] [2025-07-04T09:33:34+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001004s ] [2025-07-04T09:33:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `created_at` >= '2025-06-04 09:33:34' LIMIT 1 [ RunTime:0.000314s ] [2025-07-04T09:33:35+08:00][sql] CONNECT:[ UseTime:0.011294s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:33:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001342s ] [2025-07-04T09:33:35+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000401s ] [2025-07-04T09:33:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001108s ] [2025-07-04T09:33:35+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000347s ] [2025-07-04T09:33:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001185s ] [2025-07-04T09:33:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tousername` = 'ctshaiya007' AND `addtime` >= 1749000815 LIMIT 1 [ RunTime:0.000319s ] [2025-07-04T09:33:35+08:00][sql] SELECT `id`,`orderno`,`ordertype`,`tid`,`price`,`relationid`,`pay_status`,`addtime`,`tousername` FROM `trade_order` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tousername` = 'ctshaiya007' AND `addtime` >= 1749000815 ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000312s ] [2025-07-04T09:33:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001128s ] [2025-07-04T09:33:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001250s ] [2025-07-04T09:33:35+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` IN (4,2) [ RunTime:0.000330s ] [2025-07-04T09:33:35+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001035s ] [2025-07-04T09:33:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001225s ] [2025-07-04T09:33:35+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya' AND `serverid` = 1 AND 0 = 1 [ RunTime:0.000248s ] [2025-07-04T09:33:41+08:00][sql] CONNECT:[ UseTime:0.011117s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:33:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001216s ] [2025-07-04T09:33:41+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000347s ] [2025-07-04T09:33:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000948s ] [2025-07-04T09:33:41+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000305s ] [2025-07-04T09:33:41+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000920s ] [2025-07-04T09:33:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `created_at` >= '2025-06-04 09:33:41' LIMIT 1 [ RunTime:0.000407s ] [2025-07-04T09:33:42+08:00][sql] CONNECT:[ UseTime:0.010984s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001253s ] [2025-07-04T09:33:42+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000453s ] [2025-07-04T09:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001096s ] [2025-07-04T09:33:42+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000336s ] [2025-07-04T09:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001088s ] [2025-07-04T09:33:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tousername` = 'ctshaiya007' AND `addtime` >= 1749000822 LIMIT 1 [ RunTime:0.000322s ] [2025-07-04T09:33:42+08:00][sql] SELECT `id`,`orderno`,`ordertype`,`tid`,`price`,`relationid`,`pay_status`,`addtime`,`tousername` FROM `trade_order` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tousername` = 'ctshaiya007' AND `addtime` >= 1749000822 ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000327s ] [2025-07-04T09:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001075s ] [2025-07-04T09:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001126s ] [2025-07-04T09:33:42+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` = 'shaiya' AND `serverid` = 1 AND `tid` IN (4,2) [ RunTime:0.000333s ] [2025-07-04T09:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000918s ] [2025-07-04T09:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001116s ] [2025-07-04T09:33:42+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` = 'shaiya' AND `serverid` = 1 AND 0 = 1 [ RunTime:0.000295s ] [2025-07-04T09:34:07+08:00][sql] CONNECT:[ UseTime:0.001467s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001270s ] [2025-07-04T09:34:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000359s ] [2025-07-04T09:34:08+08:00][sql] CONNECT:[ UseTime:0.001565s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T09:34:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001316s ] [2025-07-04T09:34:08+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000383s ] [2025-07-04T09:34:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001289s ] [2025-07-04T09:34:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 08:29:08' AND '2025-07-04 09:29:08' AND `specuser` = '' LIMIT 1 [ RunTime:0.000354s ] [2025-07-04T10:07:38+08:00][sql] CONNECT:[ UseTime:0.010913s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:07:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001368s ] [2025-07-04T10:07:38+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000384s ] [2025-07-04T10:07:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001044s ] [2025-07-04T10:07:38+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000215s ] [2025-07-04T10:11:58+08:00][sql] CONNECT:[ UseTime:0.011479s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:11:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001320s ] [2025-07-04T10:11:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000381s ] [2025-07-04T10:11:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001119s ] [2025-07-04T10:11:58+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '230a289f190b079d7a6bbc0163bc182b' AND `status` = 1 LIMIT 1 [ RunTime:0.000352s ] [2025-07-04T10:11:58+08:00][sql] CONNECT:[ UseTime:0.001393s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:11:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001187s ] [2025-07-04T10:11:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000364s ] [2025-07-04T10:11:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001146s ] [2025-07-04T10:11:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:06:58' AND '2025-07-04 10:06:58' AND `specuser` = '' LIMIT 1 [ RunTime:0.000359s ] [2025-07-04T10:12:01+08:00][sql] CONNECT:[ UseTime:0.001517s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001335s ] [2025-07-04T10:12:01+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000389s ] [2025-07-04T10:12:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001247s ] [2025-07-04T10:12:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:07:00' LIMIT 1 [ RunTime:0.000371s ] [2025-07-04T10:12:02+08:00][sql] CONNECT:[ UseTime:0.001692s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001417s ] [2025-07-04T10:12:02+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000456s ] [2025-07-04T10:12:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001508s ] [2025-07-04T10:12:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:07:02' AND '2025-07-04 10:07:02' AND `specuser` = '' LIMIT 1 [ RunTime:0.000567s ] [2025-07-04T10:12:03+08:00][sql] CONNECT:[ UseTime:0.011135s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001391s ] [2025-07-04T10:12:03+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000369s ] [2025-07-04T10:12:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001257s ] [2025-07-04T10:12:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:07:03' LIMIT 1 [ RunTime:0.000388s ] [2025-07-04T10:12:14+08:00][sql] CONNECT:[ UseTime:0.001510s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001401s ] [2025-07-04T10:12:14+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000415s ] [2025-07-04T10:12:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001335s ] [2025-07-04T10:12:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:07:14' AND '2025-07-04 10:07:14' AND `specuser` = '' LIMIT 1 [ RunTime:0.000440s ] [2025-07-04T10:12:15+08:00][sql] CONNECT:[ UseTime:0.011074s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001348s ] [2025-07-04T10:12:15+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000355s ] [2025-07-04T10:12:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001216s ] [2025-07-04T10:12:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:07:15' LIMIT 1 [ RunTime:0.000626s ] [2025-07-04T10:12:40+08:00][sql] CONNECT:[ UseTime:0.010484s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001316s ] [2025-07-04T10:12:40+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000439s ] [2025-07-04T10:12:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001241s ] [2025-07-04T10:12:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:07:40' LIMIT 1 [ RunTime:0.000358s ] [2025-07-04T10:12:40+08:00][sql] CONNECT:[ UseTime:0.011528s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001353s ] [2025-07-04T10:12:40+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000364s ] [2025-07-04T10:12:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001156s ] [2025-07-04T10:12:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:07:40' LIMIT 1 [ RunTime:0.000363s ] [2025-07-04T10:12:49+08:00][sql] CONNECT:[ UseTime:0.001556s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001434s ] [2025-07-04T10:12:49+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000393s ] [2025-07-04T10:12:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001267s ] [2025-07-04T10:12:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:07:49' AND '2025-07-04 10:07:49' AND `specuser` = '' LIMIT 1 [ RunTime:0.000441s ] [2025-07-04T10:12:50+08:00][sql] CONNECT:[ UseTime:0.001472s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001251s ] [2025-07-04T10:12:50+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000371s ] [2025-07-04T10:12:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001163s ] [2025-07-04T10:12:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:07:50' LIMIT 1 [ RunTime:0.000376s ] [2025-07-04T10:12:53+08:00][sql] CONNECT:[ UseTime:0.001520s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001371s ] [2025-07-04T10:12:53+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000449s ] [2025-07-04T10:12:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001319s ] [2025-07-04T10:12:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:07:53' AND '2025-07-04 10:07:53' AND `specuser` = '' LIMIT 1 [ RunTime:0.000369s ] [2025-07-04T10:12:53+08:00][sql] CONNECT:[ UseTime:0.010472s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001273s ] [2025-07-04T10:12:53+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000373s ] [2025-07-04T10:12:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001184s ] [2025-07-04T10:12:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:07:53' LIMIT 1 [ RunTime:0.000370s ] [2025-07-04T10:12:57+08:00][sql] CONNECT:[ UseTime:0.001516s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001309s ] [2025-07-04T10:12:57+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000393s ] [2025-07-04T10:12:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001292s ] [2025-07-04T10:12:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:07:57' AND '2025-07-04 10:07:57' AND `specuser` = '' LIMIT 1 [ RunTime:0.000355s ] [2025-07-04T10:12:58+08:00][sql] CONNECT:[ UseTime:0.001435s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:12:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001244s ] [2025-07-04T10:12:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000376s ] [2025-07-04T10:12:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001158s ] [2025-07-04T10:12:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:07:58' LIMIT 1 [ RunTime:0.000361s ] [2025-07-04T10:13:37+08:00][sql] CONNECT:[ UseTime:0.010927s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:13:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001279s ] [2025-07-04T10:13:37+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000353s ] [2025-07-04T10:13:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001254s ] [2025-07-04T10:13:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:08:37' LIMIT 1 [ RunTime:0.000370s ] [2025-07-04T10:13:45+08:00][sql] CONNECT:[ UseTime:0.001416s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:13:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001207s ] [2025-07-04T10:13:45+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000365s ] [2025-07-04T10:13:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001103s ] [2025-07-04T10:13:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:08:45' LIMIT 1 [ RunTime:0.000350s ] [2025-07-04T10:13:46+08:00][sql] CONNECT:[ UseTime:0.001601s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:13:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001368s ] [2025-07-04T10:13:46+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000436s ] [2025-07-04T10:13:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001248s ] [2025-07-04T10:13:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:08:46' AND '2025-07-04 10:08:46' AND `specuser` = '' LIMIT 1 [ RunTime:0.000366s ] [2025-07-04T10:13:47+08:00][sql] CONNECT:[ UseTime:0.011092s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:13:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001383s ] [2025-07-04T10:13:47+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000353s ] [2025-07-04T10:13:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001323s ] [2025-07-04T10:13:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:08:47' LIMIT 1 [ RunTime:0.000414s ] [2025-07-04T10:13:49+08:00][sql] CONNECT:[ UseTime:0.001441s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:13:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001268s ] [2025-07-04T10:13:49+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000360s ] [2025-07-04T10:13:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001205s ] [2025-07-04T10:13:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:08:49' AND '2025-07-04 10:08:49' AND `specuser` = '' LIMIT 1 [ RunTime:0.000355s ] [2025-07-04T10:13:50+08:00][sql] CONNECT:[ UseTime:0.001551s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:13:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001301s ] [2025-07-04T10:13:50+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000372s ] [2025-07-04T10:13:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001220s ] [2025-07-04T10:13:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:08:50' LIMIT 1 [ RunTime:0.000413s ] [2025-07-04T10:17:07+08:00][sql] CONNECT:[ UseTime:0.010921s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:17:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001286s ] [2025-07-04T10:17:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000372s ] [2025-07-04T10:17:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001225s ] [2025-07-04T10:17:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 10:12:07' LIMIT 1 [ RunTime:0.000342s ] [2025-07-04T10:17:09+08:00][sql] CONNECT:[ UseTime:0.011383s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:17:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001249s ] [2025-07-04T10:17:09+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000448s ] [2025-07-04T10:17:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001199s ] [2025-07-04T10:17:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:12:09' AND '2025-07-04 10:12:09' AND `specuser` = '' LIMIT 1 [ RunTime:0.000394s ] [2025-07-04T10:17:09+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:12:09' AND '2025-07-04 10:12:09' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000381s ] [2025-07-04T10:17:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000955s ] [2025-07-04T10:17:09+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 5 GROUP BY `tid` [ RunTime:0.000275s ] [2025-07-04T10:17:09+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000903s ] [2025-07-04T10:17:09+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 5 [ RunTime:0.000239s ] [2025-07-04T10:17:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001033s ] [2025-07-04T10:17:12+08:00][sql] CONNECT:[ UseTime:0.011673s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:17:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001433s ] [2025-07-04T10:17:12+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000446s ] [2025-07-04T10:17:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001252s ] [2025-07-04T10:17:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:12:12' AND '2025-07-04 10:12:12' AND `specuser` = '' LIMIT 1 [ RunTime:0.000365s ] [2025-07-04T10:17:12+08:00][sql] SELECT `id`,`num`,`price`,`tid`,`unit_price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:12:12' AND '2025-07-04 10:12:12' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000329s ] [2025-07-04T10:17:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001009s ] [2025-07-04T10:17:12+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 6 GROUP BY `tid` [ RunTime:0.000308s ] [2025-07-04T10:17:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001155s ] [2025-07-04T10:17:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000958s ] [2025-07-04T10:18:19+08:00][sql] CONNECT:[ UseTime:0.011557s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:18:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001412s ] [2025-07-04T10:18:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000467s ] [2025-07-04T10:18:19+08:00][sql] CONNECT:[ UseTime:0.051471s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-07-04T10:18:19+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.034950s ] [2025-07-04T10:18:19+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya007' LIMIT 1 [ RunTime:0.037711s ] [2025-07-04T10:18:19+08:00][sql] CONNECT:[ UseTime:0.011370s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:18:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001344s ] [2025-07-04T10:18:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000385s ] [2025-07-04T10:18:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001119s ] [2025-07-04T10:18:19+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000327s ] [2025-07-04T10:18:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001135s ] [2025-07-04T10:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:13:19' AND '2025-07-04 10:13:19' AND `specuser` = '' LIMIT 1 [ RunTime:0.000448s ] [2025-07-04T10:18:19+08:00][sql] SELECT `id`,`num`,`price`,`tid`,`unit_price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:13:19' AND '2025-07-04 10:13:19' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000370s ] [2025-07-04T10:18:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000948s ] [2025-07-04T10:18:19+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 6 GROUP BY `tid` [ RunTime:0.000332s ] [2025-07-04T10:18:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001032s ] [2025-07-04T10:18:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000996s ] [2025-07-04T10:18:23+08:00][sql] CONNECT:[ UseTime:0.011533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:18:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001260s ] [2025-07-04T10:18:23+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000371s ] [2025-07-04T10:18:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001017s ] [2025-07-04T10:18:23+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000305s ] [2025-07-04T10:18:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001071s ] [2025-07-04T10:18:23+08:00][sql] SELECT `id`,`num`,`tid`,`unit_price`,`price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `id` = 1 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000297s ] [2025-07-04T10:18:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001065s ] [2025-07-04T10:18:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000986s ] [2025-07-04T10:18:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000904s ] [2025-07-04T10:18:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `type` = 0 AND `relationid` = 1 LIMIT 1 [ RunTime:0.000331s ] [2025-07-04T10:18:25+08:00][sql] CONNECT:[ UseTime:0.001543s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:18:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001389s ] [2025-07-04T10:18:25+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000415s ] [2025-07-04T10:18:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001098s ] [2025-07-04T10:18:25+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000302s ] [2025-07-04T10:18:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001026s ] [2025-07-04T10:18:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `created_at` >= '2025-06-04 10:18:25' LIMIT 1 [ RunTime:0.000331s ] [2025-07-04T10:18:25+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `created_at` >= '2025-06-04 10:18:25' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000288s ] [2025-07-04T10:18:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001208s ] [2025-07-04T10:18:25+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` = 'shaiya' AND `serverid` = 1 AND `tid` = 6 [ RunTime:0.000322s ] [2025-07-04T10:18:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001078s ] [2025-07-04T10:18:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001203s ] [2025-07-04T10:18:25+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` = 'shaiya' AND `serverid` = 1 AND 0 = 1 [ RunTime:0.000325s ] [2025-07-04T10:18:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001099s ] [2025-07-04T10:18:25+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` = 'shaiya' AND `serverid` = 1 AND 0 = 1 [ RunTime:0.000276s ] [2025-07-04T10:18:30+08:00][sql] CONNECT:[ UseTime:0.011182s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:18:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001379s ] [2025-07-04T10:18:30+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000349s ] [2025-07-04T10:18:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001027s ] [2025-07-04T10:18:30+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000383s ] [2025-07-04T10:18:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001026s ] [2025-07-04T10:18:30+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000351s ] [2025-07-04T10:18:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001087s ] [2025-07-04T10:18:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001233s ] [2025-07-04T10:18:30+08:00][sql] SELECT `id`,`tid`,`trade_status` FROM `trade_gold` WHERE `id` = 1 AND `username` = 'ctshaiya007' LIMIT 1 [ RunTime:0.000232s ] [2025-07-04T10:18:30+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_status`,`sync_tradeno` FROM `trade` WHERE `id` = 6 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000247s ] [2025-07-04T10:18:30+08:00][sql] UPDATE `trade_gold` SET `trade_status` = 5 WHERE `id` = 1 [ RunTime:0.000242s ] [2025-07-04T10:18:30+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya' , `serverid` = 1 , `tid` = 6 , `username` = 'ctshaiya007' , `orderno` = '' , `trade_type` = 0 , `type` = 3 , `content` = '%s已完成下架%s，商品已退回游戏，请前往游戏内角色列表/角色邮箱查收。如有疑问可联系官方客服咨询%s' [ RunTime:0.000266s ] [2025-07-04T10:18:30+08:00][error] 玩家下架-处理出错：{"Message":"下架失败","Line":426,"File":"C:\\wamp64\\www\\zbg\\app\\common\\model\\Trade.php","Trace":"#0 C:\\wamp64\\www\\zbg\\app\\index\\controller\\Seller.php(151): app\\common\\model\\Trade->closeTrade(Array)\n#1 [internal function]: app\\index\\controller\\Seller->close()\n#2 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Container.php(329): ReflectionMethod->invokeArgs(Object(app\\index\\controller\\Seller), Array)\n#3 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Container.php(362): think\\Container->invokeMethod('close', Array, false)\n#4 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\route\\dispatch\\Callback.php(27): think\\Container->invoke(Array, Array)\n#5 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\route\\Dispatch.php(80): think\\route\\dispatch\\Callback->exec()\n#6 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Route.php(793): think\\route\\Dispatch->run()\n#7 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(59): think\\Route->think\\{closure}(Object(app\\Request))\n#8 C:\\wamp64\\www\\zbg\\app\\index\\middleware\\AuthMiddleware.php(45): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#9 [internal function]: app\\index\\middleware\\AuthMiddleware->handle(Object(app\\Request), Object(Closure))\n#10 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Middleware.php(142): call_user_func(Array, Object(app\\Request), Object(Closure))\n#11 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(85): think\\Middleware->think\\{closure}(Object(app\\Request), Object(Closure))\n#12 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(66): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#13 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Route.php(794): think\\Pipeline->then(Object(Closure))\n#14 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(216): think\\Route->dispatch(Object(app\\Request), Object(Closure))\n#15 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(206): think\\Http->dispatchToRoute(Object(app\\Request))\n#16 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(59): think\\Http->think\\{closure}(Object(app\\Request))\n#17 C:\\wamp64\\www\\zbg\\vendor\\topthink\\think-multi-app\\src\\MultiApp.php(51): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#18 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(59): think\\app\\MultiApp->think\\app\\{closure}(Object(app\\Request))\n#19 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\middleware\\SessionInit.php(67): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#20 [internal function]: think\\middleware\\SessionInit->handle(Object(app\\Request), Object(Closure))\n#21 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Middleware.php(142): call_user_func(Array, Object(app\\Request), Object(Closure))\n#22 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(85): think\\Middleware->think\\{closure}(Object(app\\Request), Object(Closure))\n#23 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\middleware\\LoadLangPack.php(57): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#24 [internal function]: think\\middleware\\LoadLangPack->handle(Object(app\\Request), Object(Closure))\n#25 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Middleware.php(142): call_user_func(Array, Object(app\\Request), Object(Closure))\n#26 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(85): think\\Middleware->think\\{closure}(Object(app\\Request), Object(Closure))\n#27 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(66): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#28 C:\\wamp64\\www\\zbg\\vendor\\topthink\\think-multi-app\\src\\MultiApp.php(52): think\\Pipeline->then(Object(Closure))\n#29 [internal function]: think\\app\\MultiApp->handle(Object(app\\Request), Object(Closure))\n#30 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Middleware.php(142): call_user_func(Array, Object(app\\Request), Object(Closure))\n#31 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(85): think\\Middleware->think\\{closure}(Object(app\\Request), Object(Closure))\n#32 C:\\wamp64\\www\\zbg\\vendor\\topthink\\think-trace\\src\\TraceDebug.php(71): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#33 [internal function]: think\\trace\\TraceDebug->handle(Object(app\\Request), Object(Closure))\n#34 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Middleware.php(142): call_user_func(Array, Object(app\\Request), Object(Closure))\n#35 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(85): think\\Middleware->think\\{closure}(Object(app\\Request), Object(Closure))\n#36 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(66): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#37 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(207): think\\Pipeline->then(Object(Closure))\n#38 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(170): think\\Http->runWithRequest(Object(app\\Request))\n#39 C:\\wamp64\\www\\zbg\\public\\index.php(19): think\\Http->run()\n#40 {main}"} [2025-07-04T10:22:59+08:00][sql] CONNECT:[ UseTime:0.011479s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:22:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001335s ] [2025-07-04T10:22:59+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000364s ] [2025-07-04T10:22:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001024s ] [2025-07-04T10:22:59+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000329s ] [2025-07-04T10:22:59+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000970s ] [2025-07-04T10:22:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `created_at` >= '2025-06-04 10:22:59' LIMIT 1 [ RunTime:0.000349s ] [2025-07-04T10:22:59+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `created_at` >= '2025-06-04 10:22:59' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000293s ] [2025-07-04T10:22:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001091s ] [2025-07-04T10:22:59+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` = 'shaiya' AND `serverid` = 1 AND `tid` = 6 [ RunTime:0.000313s ] [2025-07-04T10:22:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001078s ] [2025-07-04T10:22:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001117s ] [2025-07-04T10:22:59+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND 0 = 1 [ RunTime:0.000256s ] [2025-07-04T10:22:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001184s ] [2025-07-04T10:22:59+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya' AND `serverid` = 1 AND 0 = 1 [ RunTime:0.000330s ] [2025-07-04T10:23:08+08:00][sql] CONNECT:[ UseTime:0.011049s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:23:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001375s ] [2025-07-04T10:23:08+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000391s ] [2025-07-04T10:23:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001127s ] [2025-07-04T10:23:08+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000352s ] [2025-07-04T10:23:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001234s ] [2025-07-04T10:23:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:18:08' AND '2025-07-04 10:18:08' AND `specuser` = '' LIMIT 1 [ RunTime:0.000390s ] [2025-07-04T10:23:08+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:18:08' AND '2025-07-04 10:18:08' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000354s ] [2025-07-04T10:23:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000985s ] [2025-07-04T10:23:08+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 5 GROUP BY `tid` [ RunTime:0.000379s ] [2025-07-04T10:23:08+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001036s ] [2025-07-04T10:23:08+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 5 [ RunTime:0.000239s ] [2025-07-04T10:23:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001160s ] [2025-07-04T10:23:09+08:00][sql] CONNECT:[ UseTime:0.011494s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:23:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001454s ] [2025-07-04T10:23:09+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000439s ] [2025-07-04T10:23:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001089s ] [2025-07-04T10:23:09+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000359s ] [2025-07-04T10:23:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001287s ] [2025-07-04T10:23:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:18:09' AND '2025-07-04 10:18:09' AND `specuser` = '' LIMIT 1 [ RunTime:0.000449s ] [2025-07-04T10:23:09+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:18:09' AND '2025-07-04 10:18:09' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000372s ] [2025-07-04T10:23:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001024s ] [2025-07-04T10:23:09+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 5 GROUP BY `tid` [ RunTime:0.000369s ] [2025-07-04T10:23:09+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001000s ] [2025-07-04T10:23:09+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 5 [ RunTime:0.000275s ] [2025-07-04T10:23:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001183s ] [2025-07-04T10:23:11+08:00][sql] CONNECT:[ UseTime:0.001468s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:23:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001316s ] [2025-07-04T10:23:11+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000356s ] [2025-07-04T10:23:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001051s ] [2025-07-04T10:23:11+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000303s ] [2025-07-04T10:23:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001073s ] [2025-07-04T10:23:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:18:11' AND '2025-07-04 10:18:11' AND `specuser` = '' LIMIT 1 [ RunTime:0.000336s ] [2025-07-04T10:23:11+08:00][sql] SELECT `id`,`num`,`price`,`tid`,`unit_price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:18:11' AND '2025-07-04 10:18:11' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000350s ] [2025-07-04T10:23:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000922s ] [2025-07-04T10:23:11+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 6 GROUP BY `tid` [ RunTime:0.000289s ] [2025-07-04T10:23:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001063s ] [2025-07-04T10:23:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001008s ] [2025-07-04T10:25:31+08:00][sql] CONNECT:[ UseTime:0.011018s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:25:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001486s ] [2025-07-04T10:25:31+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000402s ] [2025-07-04T10:25:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001090s ] [2025-07-04T10:25:31+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000300s ] [2025-07-04T10:25:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001202s ] [2025-07-04T10:25:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:20:31' AND '2025-07-04 10:20:31' AND `specuser` = '' LIMIT 1 [ RunTime:0.000340s ] [2025-07-04T10:25:31+08:00][sql] SELECT `id`,`num`,`price`,`tid`,`unit_price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:20:31' AND '2025-07-04 10:20:31' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000323s ] [2025-07-04T10:25:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000995s ] [2025-07-04T10:25:31+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 6 GROUP BY `tid` [ RunTime:0.000334s ] [2025-07-04T10:25:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001137s ] [2025-07-04T10:25:31+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001069s ] [2025-07-04T10:25:38+08:00][sql] CONNECT:[ UseTime:0.010819s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001259s ] [2025-07-04T10:25:38+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000340s ] [2025-07-04T10:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000974s ] [2025-07-04T10:25:38+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000297s ] [2025-07-04T10:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001059s ] [2025-07-04T10:25:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:20:38' AND '2025-07-04 10:20:38' AND `specuser` = '' LIMIT 1 [ RunTime:0.000335s ] [2025-07-04T10:25:38+08:00][sql] SELECT `id`,`num`,`price`,`tid`,`unit_price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:20:38' AND '2025-07-04 10:20:38' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000329s ] [2025-07-04T10:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000947s ] [2025-07-04T10:25:38+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 6 GROUP BY `tid` [ RunTime:0.000363s ] [2025-07-04T10:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001005s ] [2025-07-04T10:25:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000893s ] [2025-07-04T10:27:42+08:00][sql] CONNECT:[ UseTime:0.001848s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:27:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001674s ] [2025-07-04T10:27:42+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000492s ] [2025-07-04T10:27:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001215s ] [2025-07-04T10:27:42+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000424s ] [2025-07-04T10:27:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001364s ] [2025-07-04T10:27:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:22:42' AND '2025-07-04 10:22:42' AND `specuser` = '' LIMIT 1 [ RunTime:0.000397s ] [2025-07-04T10:27:42+08:00][sql] SELECT `id`,`num`,`price`,`tid`,`unit_price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:22:42' AND '2025-07-04 10:22:42' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000469s ] [2025-07-04T10:27:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001167s ] [2025-07-04T10:27:42+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 6 GROUP BY `tid` [ RunTime:0.000309s ] [2025-07-04T10:27:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001094s ] [2025-07-04T10:27:42+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000995s ] [2025-07-04T10:27:44+08:00][sql] CONNECT:[ UseTime:0.010506s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:27:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001398s ] [2025-07-04T10:27:44+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000353s ] [2025-07-04T10:27:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001073s ] [2025-07-04T10:27:44+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000346s ] [2025-07-04T10:27:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001228s ] [2025-07-04T10:27:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:22:44' AND '2025-07-04 10:22:44' AND `specuser` = '' LIMIT 1 [ RunTime:0.000406s ] [2025-07-04T10:27:44+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:22:44' AND '2025-07-04 10:22:44' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000374s ] [2025-07-04T10:27:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000989s ] [2025-07-04T10:27:44+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 5 GROUP BY `tid` [ RunTime:0.000306s ] [2025-07-04T10:27:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000999s ] [2025-07-04T10:27:44+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 5 [ RunTime:0.000210s ] [2025-07-04T10:27:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001042s ] [2025-07-04T10:36:43+08:00][sql] CONNECT:[ UseTime:0.001529s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:36:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001301s ] [2025-07-04T10:36:43+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000357s ] [2025-07-04T10:36:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001039s ] [2025-07-04T10:36:43+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000330s ] [2025-07-04T10:36:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001108s ] [2025-07-04T10:36:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:31:43' AND '2025-07-04 10:31:43' AND `specuser` = '' LIMIT 1 [ RunTime:0.000351s ] [2025-07-04T10:36:43+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:31:43' AND '2025-07-04 10:31:43' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000386s ] [2025-07-04T10:36:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000934s ] [2025-07-04T10:36:43+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 5 GROUP BY `tid` [ RunTime:0.000315s ] [2025-07-04T10:36:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000928s ] [2025-07-04T10:36:43+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 5 [ RunTime:0.000226s ] [2025-07-04T10:36:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001051s ] [2025-07-04T10:36:47+08:00][sql] CONNECT:[ UseTime:0.001508s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:36:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001261s ] [2025-07-04T10:36:47+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000392s ] [2025-07-04T10:36:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001042s ] [2025-07-04T10:36:47+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000362s ] [2025-07-04T10:36:47+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001006s ] [2025-07-04T10:36:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `created_at` >= '2025-06-04 10:36:47' LIMIT 1 [ RunTime:0.000334s ] [2025-07-04T10:36:47+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `created_at` >= '2025-06-04 10:36:47' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000282s ] [2025-07-04T10:36:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001092s ] [2025-07-04T10:36:47+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` = 'shaiya' AND `serverid` = 1 AND `tid` = 6 [ RunTime:0.000353s ] [2025-07-04T10:36:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001061s ] [2025-07-04T10:36:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001135s ] [2025-07-04T10:36:47+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` = 'shaiya' AND `serverid` = 1 AND 0 = 1 [ RunTime:0.000255s ] [2025-07-04T10:36:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001058s ] [2025-07-04T10:36:47+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` = 'shaiya' AND `serverid` = 1 AND 0 = 1 [ RunTime:0.000231s ] [2025-07-04T10:36:52+08:00][sql] CONNECT:[ UseTime:0.010988s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:36:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001311s ] [2025-07-04T10:36:52+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000369s ] [2025-07-04T10:36:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000994s ] [2025-07-04T10:36:52+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000304s ] [2025-07-04T10:36:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001039s ] [2025-07-04T10:36:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:31:52' AND '2025-07-04 10:31:52' AND `specuser` = '' LIMIT 1 [ RunTime:0.000362s ] [2025-07-04T10:36:52+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:31:52' AND '2025-07-04 10:31:52' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000364s ] [2025-07-04T10:36:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000884s ] [2025-07-04T10:36:52+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 5 GROUP BY `tid` [ RunTime:0.000274s ] [2025-07-04T10:36:52+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000866s ] [2025-07-04T10:36:52+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 5 [ RunTime:0.000232s ] [2025-07-04T10:36:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000986s ] [2025-07-04T10:57:33+08:00][sql] CONNECT:[ UseTime:0.002061s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T10:57:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001606s ] [2025-07-04T10:57:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000499s ] [2025-07-04T10:57:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001432s ] [2025-07-04T10:57:33+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000429s ] [2025-07-04T10:57:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001586s ] [2025-07-04T10:57:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:52:33' AND '2025-07-04 10:52:33' AND `specuser` = '' LIMIT 1 [ RunTime:0.000499s ] [2025-07-04T10:57:33+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:52:33' AND '2025-07-04 10:52:33' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000669s ] [2025-07-04T10:57:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001486s ] [2025-07-04T10:57:33+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 5 GROUP BY `tid` [ RunTime:0.000388s ] [2025-07-04T10:57:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001337s ] [2025-07-04T10:57:33+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 5 [ RunTime:0.000395s ] [2025-07-04T10:57:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001407s ] [2025-07-04T11:04:29+08:00][sql] CONNECT:[ UseTime:0.001795s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:04:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001348s ] [2025-07-04T11:04:29+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000392s ] [2025-07-04T11:04:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001139s ] [2025-07-04T11:04:29+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000378s ] [2025-07-04T11:04:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001204s ] [2025-07-04T11:04:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:59:29' AND '2025-07-04 10:59:29' AND `specuser` = '' LIMIT 1 [ RunTime:0.000409s ] [2025-07-04T11:04:29+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:59:29' AND '2025-07-04 10:59:29' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000434s ] [2025-07-04T11:04:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001014s ] [2025-07-04T11:04:29+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 5 GROUP BY `tid` [ RunTime:0.000365s ] [2025-07-04T11:04:29+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001022s ] [2025-07-04T11:04:29+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 5 [ RunTime:0.000215s ] [2025-07-04T11:04:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001079s ] [2025-07-04T11:04:32+08:00][sql] CONNECT:[ UseTime:0.001581s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:04:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001423s ] [2025-07-04T11:04:32+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000349s ] [2025-07-04T11:04:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001082s ] [2025-07-04T11:04:32+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000301s ] [2025-07-04T11:04:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001184s ] [2025-07-04T11:04:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:59:32' AND '2025-07-04 10:59:32' AND `specuser` = '' LIMIT 1 [ RunTime:0.000372s ] [2025-07-04T11:04:32+08:00][sql] SELECT `id`,`num`,`price`,`tid`,`unit_price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:59:32' AND '2025-07-04 10:59:32' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000321s ] [2025-07-04T11:04:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001001s ] [2025-07-04T11:04:32+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 6 GROUP BY `tid` [ RunTime:0.000282s ] [2025-07-04T11:04:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001119s ] [2025-07-04T11:04:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001039s ] [2025-07-04T11:04:36+08:00][sql] CONNECT:[ UseTime:0.010994s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:04:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001305s ] [2025-07-04T11:04:36+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000354s ] [2025-07-04T11:04:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001012s ] [2025-07-04T11:04:36+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000328s ] [2025-07-04T11:04:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001133s ] [2025-07-04T11:04:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:59:36' AND '2025-07-04 10:59:36' AND `specuser` = '' LIMIT 1 [ RunTime:0.000361s ] [2025-07-04T11:04:36+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 09:59:36' AND '2025-07-04 10:59:36' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000370s ] [2025-07-04T11:04:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000921s ] [2025-07-04T11:04:36+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 5 GROUP BY `tid` [ RunTime:0.000286s ] [2025-07-04T11:04:36+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000884s ] [2025-07-04T11:04:36+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 5 [ RunTime:0.000230s ] [2025-07-04T11:04:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001018s ] [2025-07-04T11:05:54+08:00][sql] CONNECT:[ UseTime:0.011189s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:05:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001301s ] [2025-07-04T11:05:54+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000356s ] [2025-07-04T11:05:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000996s ] [2025-07-04T11:05:54+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000304s ] [2025-07-04T11:05:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001106s ] [2025-07-04T11:05:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:00:54' AND '2025-07-04 11:00:54' AND `specuser` = '' LIMIT 1 [ RunTime:0.000360s ] [2025-07-04T11:05:54+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status` FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:00:54' AND '2025-07-04 11:00:54' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000375s ] [2025-07-04T11:05:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000887s ] [2025-07-04T11:05:54+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 5 GROUP BY `tid` [ RunTime:0.000302s ] [2025-07-04T11:05:54+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000912s ] [2025-07-04T11:05:54+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 5 [ RunTime:0.000226s ] [2025-07-04T11:05:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001007s ] [2025-07-04T11:05:58+08:00][sql] CONNECT:[ UseTime:0.011125s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:05:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001300s ] [2025-07-04T11:05:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000342s ] [2025-07-04T11:05:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001004s ] [2025-07-04T11:05:58+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000334s ] [2025-07-04T11:05:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001074s ] [2025-07-04T11:05:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:00:58' AND '2025-07-04 11:00:58' AND `specuser` = '' LIMIT 1 [ RunTime:0.000341s ] [2025-07-04T11:05:58+08:00][sql] SELECT `id`,`num`,`price`,`tid`,`unit_price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:00:58' AND '2025-07-04 11:00:58' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000336s ] [2025-07-04T11:05:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000925s ] [2025-07-04T11:05:58+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 6 GROUP BY `tid` [ RunTime:0.000315s ] [2025-07-04T11:05:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001050s ] [2025-07-04T11:05:58+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000989s ] [2025-07-04T11:12:15+08:00][sql] CONNECT:[ UseTime:0.001622s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:12:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001423s ] [2025-07-04T11:12:15+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000426s ] [2025-07-04T11:12:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001097s ] [2025-07-04T11:12:15+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000326s ] [2025-07-04T11:12:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001136s ] [2025-07-04T11:12:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:07:15' AND '2025-07-04 11:07:15' AND `specuser` = '' LIMIT 1 [ RunTime:0.000339s ] [2025-07-04T11:12:17+08:00][sql] CONNECT:[ UseTime:0.011026s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:12:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001338s ] [2025-07-04T11:12:17+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000347s ] [2025-07-04T11:12:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001059s ] [2025-07-04T11:12:17+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000345s ] [2025-07-04T11:12:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001159s ] [2025-07-04T11:12:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:07:17' AND '2025-07-04 11:07:17' AND `specuser` = '' LIMIT 1 [ RunTime:0.000374s ] [2025-07-04T11:12:18+08:00][sql] CONNECT:[ UseTime:0.010657s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:12:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001388s ] [2025-07-04T11:12:18+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000400s ] [2025-07-04T11:12:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001048s ] [2025-07-04T11:12:18+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000344s ] [2025-07-04T11:12:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001177s ] [2025-07-04T11:12:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:07:18' AND '2025-07-04 11:07:18' AND `specuser` = '' LIMIT 1 [ RunTime:0.000405s ] [2025-07-04T11:14:30+08:00][sql] CONNECT:[ UseTime:0.011823s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:14:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001274s ] [2025-07-04T11:14:30+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000382s ] [2025-07-04T11:14:31+08:00][sql] CONNECT:[ UseTime:0.011287s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001338s ] [2025-07-04T11:14:31+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000354s ] [2025-07-04T11:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001247s ] [2025-07-04T11:14:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:09:31' AND '2025-07-04 11:09:31' AND `specuser` = '' LIMIT 1 [ RunTime:0.000433s ] [2025-07-04T11:14:46+08:00][sql] CONNECT:[ UseTime:0.010762s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:14:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001288s ] [2025-07-04T11:14:46+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000396s ] [2025-07-04T11:14:46+08:00][sql] CONNECT:[ UseTime:0.053973s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-07-04T11:14:46+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.036412s ] [2025-07-04T11:14:46+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = '16754025722' LIMIT 1 [ RunTime:0.039270s ] [2025-07-04T11:14:47+08:00][sql] CONNECT:[ UseTime:0.001379s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:14:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001189s ] [2025-07-04T11:14:47+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000339s ] [2025-07-04T11:14:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000960s ] [2025-07-04T11:14:47+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000325s ] [2025-07-04T11:14:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001400s ] [2025-07-04T11:14:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:09:47' AND '2025-07-04 11:09:47' AND `specuser` = '' LIMIT 1 [ RunTime:0.000378s ] [2025-07-04T11:14:48+08:00][sql] CONNECT:[ UseTime:0.001428s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:14:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001209s ] [2025-07-04T11:14:48+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000333s ] [2025-07-04T11:14:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000947s ] [2025-07-04T11:14:48+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000405s ] [2025-07-04T11:14:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000296s ] [2025-07-04T11:14:48+08:00][sql] SELECT `id`,`tid`,`content`,`created_at`,`is_read`,`trade_type`,`type`,`orderno` FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `deleted_at` IS NULL ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000300s ] [2025-07-04T11:14:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001093s ] [2025-07-04T11:14:48+08:00][sql] SELECT `id`,`tid`,`chaname` FROM `trade_role` WHERE `tid` IN (5,4,2,1) [ RunTime:0.000248s ] [2025-07-04T11:14:50+08:00][sql] CONNECT:[ UseTime:0.010975s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:14:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001359s ] [2025-07-04T11:14:50+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000370s ] [2025-07-04T11:14:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001057s ] [2025-07-04T11:14:50+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000339s ] [2025-07-04T11:14:50+08:00][sql] SELECT * FROM `trade_notice` WHERE `id` = 9 AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000226s ] [2025-07-04T11:14:50+08:00][sql] UPDATE `trade_notice` SET `is_read` = 1 , `looktime` = 1751598890 WHERE `id` = 9 [ RunTime:0.002648s ] [2025-07-04T11:14:53+08:00][sql] CONNECT:[ UseTime:0.010797s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:14:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001318s ] [2025-07-04T11:14:53+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000395s ] [2025-07-04T11:14:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000981s ] [2025-07-04T11:14:53+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000316s ] [2025-07-04T11:14:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001097s ] [2025-07-04T11:14:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:09:53' AND '2025-07-04 11:09:53' AND `specuser` = '' LIMIT 1 [ RunTime:0.000436s ] [2025-07-04T11:14:56+08:00][sql] CONNECT:[ UseTime:0.011296s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:14:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001294s ] [2025-07-04T11:14:56+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000355s ] [2025-07-04T11:14:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000977s ] [2025-07-04T11:14:56+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000316s ] [2025-07-04T11:14:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001051s ] [2025-07-04T11:14:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:09:56' AND '2025-07-04 11:09:56' AND `specuser` = '' LIMIT 1 [ RunTime:0.000327s ] [2025-07-04T11:14:57+08:00][sql] CONNECT:[ UseTime:0.001419s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:14:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001213s ] [2025-07-04T11:14:57+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000347s ] [2025-07-04T11:14:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001032s ] [2025-07-04T11:14:57+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000316s ] [2025-07-04T11:14:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001037s ] [2025-07-04T11:14:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 11:09:57' LIMIT 1 [ RunTime:0.000443s ] [2025-07-04T11:14:58+08:00][sql] CONNECT:[ UseTime:0.010669s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:14:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001317s ] [2025-07-04T11:14:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000369s ] [2025-07-04T11:14:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001015s ] [2025-07-04T11:14:58+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000344s ] [2025-07-04T11:14:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000327s ] [2025-07-04T11:14:58+08:00][sql] SELECT `id`,`tid`,`content`,`created_at`,`is_read`,`trade_type`,`type`,`orderno` FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `deleted_at` IS NULL ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000303s ] [2025-07-04T11:14:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001147s ] [2025-07-04T11:14:58+08:00][sql] SELECT `id`,`tid`,`chaname` FROM `trade_role` WHERE `tid` IN (5,4,2,1) [ RunTime:0.000266s ] [2025-07-04T11:15:01+08:00][sql] CONNECT:[ UseTime:0.010895s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:15:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001235s ] [2025-07-04T11:15:01+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000350s ] [2025-07-04T11:15:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001005s ] [2025-07-04T11:15:01+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000417s ] [2025-07-04T11:15:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000312s ] [2025-07-04T11:15:01+08:00][sql] SELECT `id`,`tid`,`content`,`created_at`,`is_read`,`trade_type`,`type`,`orderno` FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `deleted_at` IS NULL ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000327s ] [2025-07-04T11:15:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001150s ] [2025-07-04T11:15:01+08:00][sql] SELECT `id`,`tid`,`chaname` FROM `trade_role` WHERE `tid` IN (5,4,2,1) [ RunTime:0.000246s ] [2025-07-04T11:15:02+08:00][sql] CONNECT:[ UseTime:0.011310s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:15:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001370s ] [2025-07-04T11:15:02+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000340s ] [2025-07-04T11:15:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000995s ] [2025-07-04T11:15:02+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000314s ] [2025-07-04T11:15:02+08:00][sql] SELECT * FROM `trade_notice` WHERE `id` = 4 AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000207s ] [2025-07-04T11:15:02+08:00][sql] UPDATE `trade_notice` SET `is_read` = 1 , `looktime` = 1751598902 WHERE `id` = 4 [ RunTime:0.001858s ] [2025-07-04T11:15:03+08:00][sql] CONNECT:[ UseTime:0.010574s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:15:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001269s ] [2025-07-04T11:15:03+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000356s ] [2025-07-04T11:15:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000969s ] [2025-07-04T11:15:03+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000304s ] [2025-07-04T11:15:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000332s ] [2025-07-04T11:15:03+08:00][sql] SELECT `id`,`tid`,`content`,`created_at`,`is_read`,`trade_type`,`type`,`orderno` FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `deleted_at` IS NULL ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000288s ] [2025-07-04T11:15:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001163s ] [2025-07-04T11:15:03+08:00][sql] SELECT `id`,`tid`,`chaname` FROM `trade_role` WHERE `tid` IN (5,4,2,1) [ RunTime:0.000253s ] [2025-07-04T11:15:05+08:00][sql] CONNECT:[ UseTime:0.011583s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:15:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001291s ] [2025-07-04T11:15:05+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000365s ] [2025-07-04T11:15:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001025s ] [2025-07-04T11:15:05+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000348s ] [2025-07-04T11:15:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001101s ] [2025-07-04T11:15:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:10:05' AND '2025-07-04 11:10:05' AND `specuser` = '' LIMIT 1 [ RunTime:0.000345s ] [2025-07-04T11:15:07+08:00][sql] CONNECT:[ UseTime:0.011319s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:15:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001343s ] [2025-07-04T11:15:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000370s ] [2025-07-04T11:15:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001036s ] [2025-07-04T11:15:07+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000315s ] [2025-07-04T11:15:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001118s ] [2025-07-04T11:15:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:10:07' AND '2025-07-04 11:10:07' AND `specuser` = '' LIMIT 1 [ RunTime:0.000356s ] [2025-07-04T11:15:07+08:00][sql] CONNECT:[ UseTime:0.011220s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:15:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001286s ] [2025-07-04T11:15:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000360s ] [2025-07-04T11:15:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001006s ] [2025-07-04T11:15:07+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000376s ] [2025-07-04T11:15:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001096s ] [2025-07-04T11:15:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 11:10:07' LIMIT 1 [ RunTime:0.000356s ] [2025-07-04T11:15:07+08:00][sql] SELECT `id`,`num`,`price`,`tid`,`unit_price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 11:10:07' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000317s ] [2025-07-04T11:15:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000912s ] [2025-07-04T11:15:07+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 7 GROUP BY `tid` [ RunTime:0.000328s ] [2025-07-04T11:15:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001223s ] [2025-07-04T11:15:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001129s ] [2025-07-04T11:15:50+08:00][sql] CONNECT:[ UseTime:0.011390s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:15:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001284s ] [2025-07-04T11:15:50+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000350s ] [2025-07-04T11:15:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001030s ] [2025-07-04T11:15:50+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000319s ] [2025-07-04T11:15:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001090s ] [2025-07-04T11:15:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 11:10:50' LIMIT 1 [ RunTime:0.000339s ] [2025-07-04T11:15:50+08:00][sql] SELECT `id`,`num`,`price`,`tid`,`unit_price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 11:10:50' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000334s ] [2025-07-04T11:15:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000962s ] [2025-07-04T11:15:50+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 7 GROUP BY `tid` [ RunTime:0.000286s ] [2025-07-04T11:15:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001037s ] [2025-07-04T11:15:50+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000979s ] [2025-07-04T11:20:57+08:00][sql] CONNECT:[ UseTime:0.001516s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:20:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001250s ] [2025-07-04T11:20:57+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000373s ] [2025-07-04T11:20:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001112s ] [2025-07-04T11:20:57+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000335s ] [2025-07-04T11:20:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001120s ] [2025-07-04T11:20:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-07-04 11:15:57' LIMIT 1 [ RunTime:0.000369s ] [2025-07-04T11:20:59+08:00][sql] CONNECT:[ UseTime:0.011943s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:20:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001263s ] [2025-07-04T11:20:59+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000355s ] [2025-07-04T11:20:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001003s ] [2025-07-04T11:20:59+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000351s ] [2025-07-04T11:20:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001089s ] [2025-07-04T11:20:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:15:59' AND '2025-07-04 11:15:59' AND `specuser` = '' LIMIT 1 [ RunTime:0.000351s ] [2025-07-04T11:20:59+08:00][sql] SELECT `id`,`num`,`price`,`tid`,`unit_price`,`created_at`,`trade_status`,`pay_status` FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 10:15:59' AND '2025-07-04 11:15:59' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000372s ] [2025-07-04T11:20:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000940s ] [2025-07-04T11:20:59+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 7 GROUP BY `tid` [ RunTime:0.000311s ] [2025-07-04T11:20:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001039s ] [2025-07-04T11:20:59+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000947s ] [2025-07-04T11:21:02+08:00][sql] CONNECT:[ UseTime:0.011516s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:21:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001435s ] [2025-07-04T11:21:02+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000355s ] [2025-07-04T11:21:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000979s ] [2025-07-04T11:21:02+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000408s ] [2025-07-04T11:21:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001034s ] [2025-07-04T11:21:02+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000321s ] [2025-07-04T11:21:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001017s ] [2025-07-04T11:21:02+08:00][sql] SELECT * FROM `trade` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000292s ] [2025-07-04T11:21:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001037s ] [2025-07-04T11:21:02+08:00][sql] SELECT * FROM `trade_gold` WHERE `tid` = 7 [ RunTime:0.000272s ] [2025-07-04T11:21:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001074s ] [2025-07-04T11:21:07+08:00][sql] CONNECT:[ UseTime:0.001618s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T11:21:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001469s ] [2025-07-04T11:21:07+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000361s ] [2025-07-04T11:21:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001053s ] [2025-07-04T11:21:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000350s ] [2025-07-04T11:21:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001078s ] [2025-07-04T11:21:07+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000488s ] [2025-07-04T11:21:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001221s ] [2025-07-04T11:21:07+08:00][sql] SELECT * FROM `trade` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000263s ] [2025-07-04T11:21:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001051s ] [2025-07-04T11:21:07+08:00][sql] SELECT * FROM `trade_gold` WHERE `tid` = 7 [ RunTime:0.000319s ] [2025-07-04T11:21:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001081s ] [2025-07-04T13:54:04+08:00][sql] CONNECT:[ UseTime:0.001553s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T13:54:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001470s ] [2025-07-04T13:54:04+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000356s ] [2025-07-04T13:54:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001105s ] [2025-07-04T13:54:04+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '16754025722' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000379s ] [2025-07-04T13:54:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001215s ] [2025-07-04T13:54:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 12:49:04' AND '2025-07-04 13:49:04' AND `specuser` = '' LIMIT 1 [ RunTime:0.000387s ] [2025-07-04T14:14:20+08:00][sql] CONNECT:[ UseTime:0.001536s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T14:14:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001268s ] [2025-07-04T14:14:20+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000386s ] [2025-07-04T14:14:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001015s ] [2025-07-04T14:14:20+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000212s ] [2025-07-04T16:06:04+08:00][sql] CONNECT:[ UseTime:0.001521s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:06:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001313s ] [2025-07-04T16:06:04+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000348s ] [2025-07-04T16:06:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001018s ] [2025-07-04T16:06:04+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000234s ] [2025-07-04T16:06:22+08:00][sql] CONNECT:[ UseTime:0.011047s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:06:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001301s ] [2025-07-04T16:06:22+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000380s ] [2025-07-04T16:06:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001035s ] [2025-07-04T16:06:22+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '230a289f190b079d7a6bbc0163bc182b' AND `status` = 1 LIMIT 1 [ RunTime:0.000349s ] [2025-07-04T16:06:22+08:00][sql] CONNECT:[ UseTime:0.011060s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:06:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001344s ] [2025-07-04T16:06:22+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000375s ] [2025-07-04T16:06:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001269s ] [2025-07-04T16:06:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 15:01:22' AND '2025-07-04 16:01:22' AND `specuser` = '' LIMIT 1 [ RunTime:0.000361s ] [2025-07-04T16:07:09+08:00][sql] CONNECT:[ UseTime:0.010502s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:07:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001341s ] [2025-07-04T16:07:09+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000352s ] [2025-07-04T16:07:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001027s ] [2025-07-04T16:07:09+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000211s ] [2025-07-04T16:07:10+08:00][sql] CONNECT:[ UseTime:0.010988s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:07:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001230s ] [2025-07-04T16:07:10+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000351s ] [2025-07-04T16:07:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000991s ] [2025-07-04T16:07:10+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000231s ] [2025-07-04T16:07:14+08:00][sql] CONNECT:[ UseTime:0.001419s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:07:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001286s ] [2025-07-04T16:07:14+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000418s ] [2025-07-04T16:07:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001007s ] [2025-07-04T16:07:14+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000221s ] [2025-07-04T16:10:30+08:00][sql] CONNECT:[ UseTime:0.011313s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:10:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001296s ] [2025-07-04T16:10:30+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000382s ] [2025-07-04T16:10:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001023s ] [2025-07-04T16:10:30+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000202s ] [2025-07-04T16:13:02+08:00][sql] CONNECT:[ UseTime:0.011038s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:13:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001269s ] [2025-07-04T16:13:02+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000367s ] [2025-07-04T16:13:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001077s ] [2025-07-04T16:13:02+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000204s ] [2025-07-04T16:13:06+08:00][sql] CONNECT:[ UseTime:0.001504s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:13:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001354s ] [2025-07-04T16:13:06+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000372s ] [2025-07-04T16:13:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001035s ] [2025-07-04T16:13:06+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000227s ] [2025-07-04T16:13:08+08:00][sql] CONNECT:[ UseTime:0.010966s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:13:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001291s ] [2025-07-04T16:13:08+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000342s ] [2025-07-04T16:13:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001004s ] [2025-07-04T16:13:08+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '230a289f190b079d7a6bbc0163bc182b' AND `status` = 1 LIMIT 1 [ RunTime:0.000299s ] [2025-07-04T16:13:08+08:00][sql] CONNECT:[ UseTime:0.011009s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:13:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001239s ] [2025-07-04T16:13:08+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000367s ] [2025-07-04T16:13:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001162s ] [2025-07-04T16:13:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 15:08:08' AND '2025-07-04 16:08:08' AND `specuser` = '' LIMIT 1 [ RunTime:0.000365s ] [2025-07-04T16:13:15+08:00][sql] CONNECT:[ UseTime:0.001540s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:13:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001277s ] [2025-07-04T16:13:15+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000369s ] [2025-07-04T16:13:15+08:00][sql] CONNECT:[ UseTime:0.047956s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-07-04T16:13:15+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.032496s ] [2025-07-04T16:13:15+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya007' LIMIT 1 [ RunTime:0.035465s ] [2025-07-04T16:13:15+08:00][sql] CONNECT:[ UseTime:0.011149s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:13:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001371s ] [2025-07-04T16:13:15+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000354s ] [2025-07-04T16:13:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001057s ] [2025-07-04T16:13:15+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000378s ] [2025-07-04T16:13:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001192s ] [2025-07-04T16:13:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 15:08:15' AND '2025-07-04 16:08:15' AND `specuser` = '' LIMIT 1 [ RunTime:0.000416s ] [2025-07-04T16:13:16+08:00][sql] CONNECT:[ UseTime:0.010749s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:13:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001244s ] [2025-07-04T16:13:16+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000369s ] [2025-07-04T16:13:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000997s ] [2025-07-04T16:13:16+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000354s ] [2025-07-04T16:13:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000321s ] [2025-07-04T16:13:16+08:00][sql] SELECT `id`,`tid`,`content`,`created_at`,`is_read`,`trade_type`,`type`,`orderno` FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `deleted_at` IS NULL ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000290s ] [2025-07-04T16:13:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001090s ] [2025-07-04T16:13:16+08:00][sql] SELECT `id`,`tid`,`num` FROM `trade_gold` WHERE `tid` = 6 [ RunTime:0.000244s ] [2025-07-04T16:13:18+08:00][sql] CONNECT:[ UseTime:0.011283s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:13:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001426s ] [2025-07-04T16:13:18+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000440s ] [2025-07-04T16:13:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001076s ] [2025-07-04T16:13:18+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = 'ctshaiya007' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000372s ] [2025-07-04T16:13:18+08:00][sql] SELECT * FROM `trade_notice` WHERE `id` = 8 AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000252s ] [2025-07-04T16:13:18+08:00][sql] UPDATE `trade_notice` SET `is_read` = 1 , `looktime` = 1751616798 WHERE `id` = 8 [ RunTime:0.001556s ] [2025-07-04T16:36:45+08:00][sql] CONNECT:[ UseTime:0.001628s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T16:36:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001407s ] [2025-07-04T16:36:45+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000407s ] [2025-07-04T16:36:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001131s ] [2025-07-04T16:36:45+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000217s ] [2025-07-04T17:40:30+08:00][sql] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T17:40:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001348s ] [2025-07-04T17:40:30+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000477s ] [2025-07-04T17:40:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001096s ] [2025-07-04T17:40:30+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000230s ] [2025-07-04T17:40:31+08:00][sql] CONNECT:[ UseTime:0.001560s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T17:40:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001433s ] [2025-07-04T17:40:31+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000474s ] [2025-07-04T17:40:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001168s ] [2025-07-04T17:40:31+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '230a289f190b079d7a6bbc0163bc182b' AND `status` = 1 LIMIT 1 [ RunTime:0.000288s ] [2025-07-04T17:40:31+08:00][sql] CONNECT:[ UseTime:0.010948s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T17:40:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001254s ] [2025-07-04T17:40:31+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000478s ] [2025-07-04T17:40:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001215s ] [2025-07-04T17:40:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 16:35:31' AND '2025-07-04 17:35:31' AND `specuser` = '' LIMIT 1 [ RunTime:0.000378s ] [2025-07-04T17:40:32+08:00][sql] CONNECT:[ UseTime:0.001527s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T17:40:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001232s ] [2025-07-04T17:40:32+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000464s ] [2025-07-04T17:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 LIMIT 1 [ RunTime:0.000456s ] [2025-07-04T17:40:32+08:00][sql] SELECT `mark`,`title` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 ORDER BY `sort` DESC LIMIT 0,100 [ RunTime:0.000293s ] [2025-07-04T17:40:32+08:00][sql] SELECT `mark`,`title`,`content` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.000310s ] [2025-07-04T17:48:18+08:00][sql] CONNECT:[ UseTime:0.001560s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T17:48:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001253s ] [2025-07-04T17:48:18+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000522s ] [2025-07-04T17:48:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 LIMIT 1 [ RunTime:0.000267s ] [2025-07-04T17:48:18+08:00][sql] SELECT `mark`,`title` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 ORDER BY `sort` DESC LIMIT 0,100 [ RunTime:0.000249s ] [2025-07-04T17:48:18+08:00][sql] SELECT `mark`,`title`,`content` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.000273s ] [2025-07-04T17:48:20+08:00][sql] CONNECT:[ UseTime:0.001584s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T17:48:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001426s ] [2025-07-04T17:48:20+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000375s ] [2025-07-04T17:48:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001282s ] [2025-07-04T17:48:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-07-04 16:43:20' AND '2025-07-04 17:43:20' AND `specuser` = '' LIMIT 1 [ RunTime:0.000397s ] [2025-07-04T17:48:20+08:00][sql] CONNECT:[ UseTime:0.011047s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T17:48:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001345s ] [2025-07-04T17:48:20+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000382s ] [2025-07-04T17:48:20+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001056s ] [2025-07-04T17:48:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `username` = '' AND `created_at` >= '2025-06-04 17:48:20' LIMIT 1 [ RunTime:0.000360s ] [2025-07-04T19:41:50+08:00][sql] CONNECT:[ UseTime:0.001537s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-04T19:41:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001369s ] [2025-07-04T19:41: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.001608s ] [2025-07-04T19:41:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001009s ] [2025-07-04T19:41:50+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000230s ]