[2025-08-22T14:25:43+08:00][sql] CONNECT:[ UseTime:0.001488s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T14:25:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001462s ] [2025-08-22T14:25:43+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.000492s ] [2025-08-22T14:25:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001110s ] [2025-08-22T14:25:43+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000214s ] [2025-08-22T17:55:07+08:00][sql] CONNECT:[ UseTime:0.001438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T17:55:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001305s ] [2025-08-22T17:55:07+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.000422s ] [2025-08-22T17:55:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001045s ] [2025-08-22T17:55:07+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000209s ] [2025-08-22T18:22:44+08:00][sql] CONNECT:[ UseTime:0.001558s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:22:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001364s ] [2025-08-22T18:22:44+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.000422s ] [2025-08-22T18:22:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001060s ] [2025-08-22T18:22:44+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000245s ] [2025-08-22T18:34:49+08:00][sql] CONNECT:[ UseTime:0.011487s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:34:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001437s ] [2025-08-22T18:34:49+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000519s ] [2025-08-22T18:34:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001153s ] [2025-08-22T18:34:49+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000297s ] [2025-08-22T18:34:50+08:00][sql] CONNECT:[ UseTime:0.011035s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:34:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001280s ] [2025-08-22T18:34: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.000419s ] [2025-08-22T18:34:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001012s ] [2025-08-22T18:34:50+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '116dbfb732616492e66bc9c04e703fd8' AND `status` = 1 LIMIT 1 [ RunTime:0.000288s ] [2025-08-22T18:34:50+08:00][sql] CONNECT:[ UseTime:0.001338s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:34:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001109s ] [2025-08-22T18:34:50+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000386s ] [2025-08-22T18:34:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001172s ] [2025-08-22T18:34:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-22 17:29:50' AND '2025-08-22 18:29:50' AND `specuser` = '' LIMIT 1 [ RunTime:0.000444s ] [2025-08-22T18:34:52+08:00][sql] CONNECT:[ UseTime:0.011123s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:34:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001333s ] [2025-08-22T18:34:52+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000438s ] [2025-08-22T18:34:52+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001017s ] [2025-08-22T18:34:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = '' AND `created_at` >= '2025-05-24 18:34:52' LIMIT 1 [ RunTime:0.000433s ] [2025-08-22T18:34:54+08:00][sql] CONNECT:[ UseTime:0.011235s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:34:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001365s ] [2025-08-22T18:34:54+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000414s ] [2025-08-22T18:34:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001251s ] [2025-08-22T18:34:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-22 17:29:54' AND '2025-08-22 18:29:54' AND `specuser` = '' LIMIT 1 [ RunTime:0.000480s ] [2025-08-22T18:34:57+08:00][sql] CONNECT:[ UseTime:0.010953s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001346s ] [2025-08-22T18:34:57+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000385s ] [2025-08-22T18:34:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001242s ] [2025-08-22T18:34:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-22 17:29:57' AND '2025-08-22 18:29:57' AND `specuser` = '' LIMIT 1 [ RunTime:0.000331s ] [2025-08-22T18:34:58+08:00][sql] CONNECT:[ UseTime:0.001416s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:34:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001382s ] [2025-08-22T18:34:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000381s ] [2025-08-22T18:34:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001260s ] [2025-08-22T18:34:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:29:58' LIMIT 1 [ RunTime:0.000341s ] [2025-08-22T18:34:59+08:00][sql] CONNECT:[ UseTime:0.011807s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:34:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001299s ] [2025-08-22T18:34:59+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000392s ] [2025-08-22T18:34:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001163s ] [2025-08-22T18:34:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:29:59' LIMIT 1 [ RunTime:0.000334s ] [2025-08-22T18:35:00+08:00][sql] CONNECT:[ UseTime:0.001535s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:35:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001394s ] [2025-08-22T18:35:00+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000423s ] [2025-08-22T18:35:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001242s ] [2025-08-22T18:35:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-22 17:30:00' AND '2025-08-22 18:30:00' AND `specuser` = '' LIMIT 1 [ RunTime:0.000333s ] [2025-08-22T18:35:00+08:00][sql] CONNECT:[ UseTime:0.011271s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:35:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001384s ] [2025-08-22T18:35:00+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000396s ] [2025-08-22T18:35:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001217s ] [2025-08-22T18:35:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:30:00' LIMIT 1 [ RunTime:0.000390s ] [2025-08-22T18:35:04+08:00][sql] CONNECT:[ UseTime:0.010507s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:35:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001512s ] [2025-08-22T18:35:04+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000480s ] [2025-08-22T18:35:04+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001123s ] [2025-08-22T18:35:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = '' AND `created_at` >= '2025-05-24 18:35:04' LIMIT 1 [ RunTime:0.000521s ] [2025-08-22T18:35:08+08:00][sql] CONNECT:[ UseTime:0.010850s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:35:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001377s ] [2025-08-22T18:35:08+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000457s ] [2025-08-22T18:35:08+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000976s ] [2025-08-22T18:35:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = '' AND `created_at` >= '2025-05-24 18:35:08' LIMIT 1 [ RunTime:0.000439s ] [2025-08-22T18:35:19+08:00][sql] CONNECT:[ UseTime:0.010995s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:35:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001298s ] [2025-08-22T18:35:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000394s ] [2025-08-22T18:35:19+08:00][sql] CONNECT:[ UseTime:0.048832s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-08-22T18:35:19+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.032842s ] [2025-08-22T18:35:19+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.037410s ] [2025-08-22T18:35:19+08:00][sql] CONNECT:[ UseTime:0.011589s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:35:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001344s ] [2025-08-22T18:35:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000380s ] [2025-08-22T18:35:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001036s ] [2025-08-22T18:35:19+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000354s ] [2025-08-22T18:35:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000967s ] [2025-08-22T18:35:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:35:19' LIMIT 1 [ RunTime:0.000423s ] [2025-08-22T18:35:19+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:35:19' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000395s ] [2025-08-22T18:35:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001109s ] [2025-08-22T18:35:19+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (65,64,63,60) [ RunTime:0.000368s ] [2025-08-22T18:35:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001094s ] [2025-08-22T18:35:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001161s ] [2025-08-22T18:35:19+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (80,74,62) [ RunTime:0.000414s ] [2025-08-22T18:35:19+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025081810510949072728' [ RunTime:0.000209s ] [2025-08-22T18:35:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001158s ] [2025-08-22T18:35:19+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000362s ] [2025-08-22T18:35:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001258s ] [2025-08-22T18:35:19+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.030431s ] [2025-08-22T18:35:30+08:00][sql] CONNECT:[ UseTime:0.001401s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:35:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001241s ] [2025-08-22T18:35:30+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000461s ] [2025-08-22T18:35:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000990s ] [2025-08-22T18:35:30+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000318s ] [2025-08-22T18:35:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001095s ] [2025-08-22T18:35:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-22 17:30:30' AND '2025-08-22 18:30:30' AND `specuser` = '' LIMIT 1 [ RunTime:0.000445s ] [2025-08-22T18:35:31+08:00][sql] CONNECT:[ UseTime:0.011006s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:35:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001305s ] [2025-08-22T18:35:31+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000396s ] [2025-08-22T18:35:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001092s ] [2025-08-22T18:35:31+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000363s ] [2025-08-22T18:35:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001253s ] [2025-08-22T18:35:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:30:31' LIMIT 1 [ RunTime:0.000416s ] [2025-08-22T18:35:33+08:00][sql] CONNECT:[ UseTime:0.001424s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:35:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001267s ] [2025-08-22T18:35:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000569s ] [2025-08-22T18:35:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001076s ] [2025-08-22T18:35:33+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000345s ] [2025-08-22T18:35:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001122s ] [2025-08-22T18:35:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-22 17:30:33' AND '2025-08-22 18:30:33' AND `specuser` = '' LIMIT 1 [ RunTime:0.000338s ] [2025-08-22T18:35:34+08:00][sql] CONNECT:[ UseTime:0.010909s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:35:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001329s ] [2025-08-22T18:35:34+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000405s ] [2025-08-22T18:35:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001004s ] [2025-08-22T18:35:34+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000344s ] [2025-08-22T18:35:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001130s ] [2025-08-22T18:35:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:30:34' LIMIT 1 [ RunTime:0.000331s ] [2025-08-22T18:35:34+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:30:34' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000354s ] [2025-08-22T18:35:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001180s ] [2025-08-22T18:35:34+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.030388s ] [2025-08-22T18:35:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001203s ] [2025-08-22T18:35:34+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000302s ] [2025-08-22T18:35:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001264s ] [2025-08-22T18:35:34+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 GROUP BY `tid` [ RunTime:0.000307s ] [2025-08-22T18:35:34+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000914s ] [2025-08-22T18:35:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001230s ] [2025-08-22T18:35:40+08:00][sql] CONNECT:[ UseTime:0.011247s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:35:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001297s ] [2025-08-22T18:35:40+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000397s ] [2025-08-22T18:35:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001005s ] [2025-08-22T18:35:40+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000362s ] [2025-08-22T18:35:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001154s ] [2025-08-22T18:35:40+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE `id` = 1 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000282s ] [2025-08-22T18:35:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001176s ] [2025-08-22T18:35:40+08:00][sql] SELECT * FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 LIMIT 1 [ RunTime:0.017691s ] [2025-08-22T18:35:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001178s ] [2025-08-22T18:35:40+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000299s ] [2025-08-22T18:35:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000926s ] [2025-08-22T18:35:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001095s ] [2025-08-22T18:35:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000927s ] [2025-08-22T18:35:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `type` = 2 AND `relationid` = 1 LIMIT 1 [ RunTime:0.000318s ] [2025-08-22T18:36:01+08:00][sql] CONNECT:[ UseTime:0.001403s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:36:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001237s ] [2025-08-22T18:36:01+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000382s ] [2025-08-22T18:36:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000968s ] [2025-08-22T18:36:01+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000319s ] [2025-08-22T18:36:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001034s ] [2025-08-22T18:36:01+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE `id` = 1 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000278s ] [2025-08-22T18:36:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001093s ] [2025-08-22T18:36:01+08:00][sql] SELECT * FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 LIMIT 1 [ RunTime:0.027609s ] [2025-08-22T18:36:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001818s ] [2025-08-22T18:36:01+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000425s ] [2025-08-22T18:36:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001397s ] [2025-08-22T18:36:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001761s ] [2025-08-22T18:36:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001273s ] [2025-08-22T18:36:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `type` = 2 AND `relationid` = 1 LIMIT 1 [ RunTime:0.000413s ] [2025-08-22T18:36:09+08:00][sql] CONNECT:[ UseTime:0.011055s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:36:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001343s ] [2025-08-22T18:36:09+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000392s ] [2025-08-22T18:36:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001038s ] [2025-08-22T18:36:09+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000326s ] [2025-08-22T18:36:09+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000959s ] [2025-08-22T18:36:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:36:09' LIMIT 1 [ RunTime:0.000409s ] [2025-08-22T18:36:09+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:36:09' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000390s ] [2025-08-22T18:36:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001101s ] [2025-08-22T18:36:09+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (65,64,63,60) [ RunTime:0.000358s ] [2025-08-22T18:36:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001078s ] [2025-08-22T18:36:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001130s ] [2025-08-22T18:36:09+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (80,74,62) [ RunTime:0.000380s ] [2025-08-22T18:36:09+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025081810510949072728' [ RunTime:0.000210s ] [2025-08-22T18:36:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001120s ] [2025-08-22T18:36:09+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000293s ] [2025-08-22T18:36:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001137s ] [2025-08-22T18:36:09+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.030432s ] [2025-08-22T18:36:11+08:00][sql] CONNECT:[ UseTime:0.010822s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:36:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001229s ] [2025-08-22T18:36:11+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000391s ] [2025-08-22T18:36:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000921s ] [2025-08-22T18:36:11+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000318s ] [2025-08-22T18:36:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001066s ] [2025-08-22T18:36:11+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 50 AND `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.000323s ] [2025-08-22T18:36:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000980s ] [2025-08-22T18:36:11+08:00][sql] SELECT `id`,`orderno`,`charge`,`price`,`amount`,`withdraw_status`,`pay_status`,`addtime`,`paytime` FROM `trade_order` WHERE `relationid` = 50 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000281s ] [2025-08-22T18:36:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000857s ] [2025-08-22T18:36:57+08:00][sql] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:36:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001348s ] [2025-08-22T18:36:57+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000416s ] [2025-08-22T18:36:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001060s ] [2025-08-22T18:36:57+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000342s ] [2025-08-22T18:36:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001302s ] [2025-08-22T18:36:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-22 17:31:57' AND '2025-08-22 18:31:57' AND `specuser` = '' LIMIT 1 [ RunTime:0.000420s ] [2025-08-22T18:36:58+08:00][sql] CONNECT:[ UseTime:0.001457s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:36:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001342s ] [2025-08-22T18:36:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000458s ] [2025-08-22T18:36:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001040s ] [2025-08-22T18:36:58+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000338s ] [2025-08-22T18:36:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001164s ] [2025-08-22T18:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:31:58' LIMIT 1 [ RunTime:0.000411s ] [2025-08-22T18:36:59+08:00][sql] CONNECT:[ UseTime:0.001468s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:36:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001316s ] [2025-08-22T18:36:59+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000421s ] [2025-08-22T18:36:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001056s ] [2025-08-22T18:36:59+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000342s ] [2025-08-22T18:36:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001219s ] [2025-08-22T18:36:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:31:59' LIMIT 1 [ RunTime:0.000423s ] [2025-08-22T18:37:00+08:00][sql] CONNECT:[ UseTime:0.010267s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:37:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001355s ] [2025-08-22T18:37:00+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000395s ] [2025-08-22T18:37:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001000s ] [2025-08-22T18:37:00+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000332s ] [2025-08-22T18:37:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001089s ] [2025-08-22T18:37:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:32:00' LIMIT 1 [ RunTime:0.000383s ] [2025-08-22T18:37:00+08:00][sql] CONNECT:[ UseTime:0.011064s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:37:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001354s ] [2025-08-22T18:37:00+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000378s ] [2025-08-22T18:37:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001035s ] [2025-08-22T18:37:00+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000326s ] [2025-08-22T18:37:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001196s ] [2025-08-22T18:37:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:32:00' LIMIT 1 [ RunTime:0.000379s ] [2025-08-22T18:37:00+08:00][sql] CONNECT:[ UseTime:0.001418s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:37:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001345s ] [2025-08-22T18:37:00+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000399s ] [2025-08-22T18:37:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001059s ] [2025-08-22T18:37:00+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000325s ] [2025-08-22T18:37:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001170s ] [2025-08-22T18:37:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:32:00' LIMIT 1 [ RunTime:0.000423s ] [2025-08-22T18:37:01+08:00][sql] CONNECT:[ UseTime:0.001726s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:37:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001415s ] [2025-08-22T18:37:01+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000471s ] [2025-08-22T18:37:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001382s ] [2025-08-22T18:37:01+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000484s ] [2025-08-22T18:37:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001640s ] [2025-08-22T18:37:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-22 17:32:01' AND '2025-08-22 18:32:01' AND `specuser` = '' LIMIT 1 [ RunTime:0.000556s ] [2025-08-22T18:37:04+08:00][sql] CONNECT:[ UseTime:0.001428s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001283s ] [2025-08-22T18:37:04+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000415s ] [2025-08-22T18:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001092s ] [2025-08-22T18:37:04+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000343s ] [2025-08-22T18:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001167s ] [2025-08-22T18:37:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-22 17:32:04' AND '2025-08-22 18:32:04' AND `specuser` = '' LIMIT 1 [ RunTime:0.000340s ] [2025-08-22T18:37:04+08:00][sql] CONNECT:[ UseTime:0.011425s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001453s ] [2025-08-22T18:37:04+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000471s ] [2025-08-22T18:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001064s ] [2025-08-22T18:37:04+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000356s ] [2025-08-22T18:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001129s ] [2025-08-22T18:37:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:32:04' LIMIT 1 [ RunTime:0.000376s ] [2025-08-22T18:37:04+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-08-22 18:32:04' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000335s ] [2025-08-22T18:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001173s ] [2025-08-22T18:37:04+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.030420s ] [2025-08-22T18:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001305s ] [2025-08-22T18:37:04+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000302s ] [2025-08-22T18:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000893s ] [2025-08-22T18:37:04+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 GROUP BY `tid` [ RunTime:0.000321s ] [2025-08-22T18:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000943s ] [2025-08-22T18:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001051s ] [2025-08-22T18:37:06+08:00][sql] CONNECT:[ UseTime:0.001394s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:37:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001289s ] [2025-08-22T18:37:06+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000409s ] [2025-08-22T18:37:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001013s ] [2025-08-22T18:37:06+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000342s ] [2025-08-22T18:37:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001111s ] [2025-08-22T18:37:06+08:00][sql] SELECT `id`,`game`,`tid`,`serverid`,`itemid`,`num`,`unit_price`,`price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE `id` = 1 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000283s ] [2025-08-22T18:37:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001135s ] [2025-08-22T18:37:06+08:00][sql] SELECT * FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 LIMIT 1 [ RunTime:0.017060s ] [2025-08-22T18:37:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001161s ] [2025-08-22T18:37:06+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000302s ] [2025-08-22T18:37:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000934s ] [2025-08-22T18:37:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001048s ] [2025-08-22T18:37:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000914s ] [2025-08-22T18:37:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `type` = 2 AND `relationid` = 1 LIMIT 1 [ RunTime:0.000294s ] [2025-08-22T18:40:15+08:00][sql] CONNECT:[ UseTime:0.010810s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001319s ] [2025-08-22T18:40:15+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000410s ] [2025-08-22T18:40:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001037s ] [2025-08-22T18:40:15+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000371s ] [2025-08-22T18:40:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001126s ] [2025-08-22T18:40:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-22 17:35:15' AND '2025-08-22 18:35:15' AND `specuser` = '' LIMIT 1 [ RunTime:0.000373s ] [2025-08-22T18:40:15+08:00][sql] SELECT `id`,`game`,`tid`,`num`,`itemid`,`price`,`unit_price`,`created_at`,`trade_status`,`job`,`pay_status` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-08-22 17:35:15' AND '2025-08-22 18:35:15' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000342s ] [2025-08-22T18:40:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001146s ] [2025-08-22T18:40:15+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.029374s ] [2025-08-22T18:40:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001172s ] [2025-08-22T18:40:15+08:00][sql] SELECT `cj`,`itemid` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000288s ] [2025-08-22T18:40:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000862s ] [2025-08-22T18:40:15+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 GROUP BY `tid` [ RunTime:0.000309s ] [2025-08-22T18:40:15+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000928s ] [2025-08-22T18:40:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001038s ] [2025-08-22T18:40:18+08:00][sql] CONNECT:[ UseTime:0.011060s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001417s ] [2025-08-22T18:40:18+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000427s ] [2025-08-22T18:40:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001103s ] [2025-08-22T18:40:18+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000419s ] [2025-08-22T18:40:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001154s ] [2025-08-22T18:40:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tousername` = 'ctshaiya008' AND `addtime` >= 1753267218 LIMIT 1 [ RunTime:0.000304s ] [2025-08-22T18:40:18+08:00][sql] SELECT `id`,`orderno`,`ordertype`,`tid`,`price`,`relationid`,`pay_status`,`addtime`,`tousername` FROM `trade_order` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tousername` = 'ctshaiya008' AND `addtime` >= 1753267218 ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000311s ] [2025-08-22T18:40:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001203s ] [2025-08-22T18:40:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001226s ] [2025-08-22T18:40:18+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (58,56,47) [ RunTime:0.000421s ] [2025-08-22T18:40:18+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025080611234024256924','R2025080614044114693721') [ RunTime:0.000221s ] [2025-08-22T18:40:18+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001037s ] [2025-08-22T18:40:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001214s ] [2025-08-22T18:40:18+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000242s ] [2025-08-22T18:40:19+08:00][sql] CONNECT:[ UseTime:0.001476s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001358s ] [2025-08-22T18:40:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000417s ] [2025-08-22T18:40:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001142s ] [2025-08-22T18:40:19+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000387s ] [2025-08-22T18:40:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 LIMIT 1 [ RunTime:0.000345s ] [2025-08-22T18:40:19+08:00][sql] SELECT `mark`,`title` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 ORDER BY `sort` DESC LIMIT 0,100 [ RunTime:0.000264s ] [2025-08-22T18:40:19+08:00][sql] SELECT `mark`,`title`,`content` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.000296s ] [2025-08-22T18:40:21+08:00][sql] CONNECT:[ UseTime:0.001389s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001286s ] [2025-08-22T18:40:21+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000385s ] [2025-08-22T18:40:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000970s ] [2025-08-22T18:40:21+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000351s ] [2025-08-22T18:40:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000921s ] [2025-08-22T18:40:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:21' LIMIT 1 [ RunTime:0.000391s ] [2025-08-22T18:40:21+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:21' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000338s ] [2025-08-22T18:40:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001024s ] [2025-08-22T18:40:21+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (65,64,63,60) [ RunTime:0.000334s ] [2025-08-22T18:40:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001044s ] [2025-08-22T18:40:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001072s ] [2025-08-22T18:40:21+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (80,74,62) [ RunTime:0.000382s ] [2025-08-22T18:40:21+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025081810510949072728' [ RunTime:0.000209s ] [2025-08-22T18:40:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001086s ] [2025-08-22T18:40:21+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000312s ] [2025-08-22T18:40:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001094s ] [2025-08-22T18:40:21+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.028559s ] [2025-08-22T18:40:24+08:00][sql] CONNECT:[ UseTime:0.001453s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001350s ] [2025-08-22T18:40:24+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000344s ] [2025-08-22T18:40:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001069s ] [2025-08-22T18:40:24+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000339s ] [2025-08-22T18:40:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001041s ] [2025-08-22T18:40:24+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000330s ] [2025-08-22T18:40:24+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001116s ] [2025-08-22T18:40:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001155s ] [2025-08-22T18:40:24+08:00][sql] SELECT `id`,`tid`,`trade_status` FROM `trade_prop` WHERE `id` = 1 AND `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.000263s ] [2025-08-22T18:40:24+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_status`,`sync_tradeno` FROM `trade` WHERE `id` = 81 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000260s ] [2025-08-22T18:40:24+08:00][sql] UPDATE `trade_prop` SET `trade_status` = 5 WHERE `id` = 1 [ RunTime:0.000221s ] [2025-08-22T18:40:24+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 81 , `username` = 'ctshaiya008' , `orderno` = '' , `trade_type` = 2 , `type` = 3 , `content` = '%s已完成下架%s，商品已退回游戏，请前往游戏内角色列表/角色邮箱查收。如有疑问可联系官方客服咨询%s' [ RunTime:0.000225s ] [2025-08-22T18:40:25+08:00][sql] CONNECT:[ UseTime:0.010879s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001468s ] [2025-08-22T18:40:25+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000428s ] [2025-08-22T18:40:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001022s ] [2025-08-22T18:40:25+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000343s ] [2025-08-22T18:40:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000941s ] [2025-08-22T18:40:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:25' LIMIT 1 [ RunTime:0.000399s ] [2025-08-22T18:40:25+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:25' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000372s ] [2025-08-22T18:40:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001121s ] [2025-08-22T18:40: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` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (65,64,63,60) [ RunTime:0.000360s ] [2025-08-22T18:40:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001052s ] [2025-08-22T18:40:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001108s ] [2025-08-22T18:40: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` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (80,74,62) [ RunTime:0.000417s ] [2025-08-22T18:40:25+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025081810510949072728' [ RunTime:0.000219s ] [2025-08-22T18:40:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001119s ] [2025-08-22T18:40: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` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000297s ] [2025-08-22T18:40:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001140s ] [2025-08-22T18:40:25+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.030259s ] [2025-08-22T18:40:28+08:00][sql] CONNECT:[ UseTime:0.010945s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001434s ] [2025-08-22T18:40:28+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000447s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001083s ] [2025-08-22T18:40:28+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000426s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000944s ] [2025-08-22T18:40:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:28' LIMIT 1 [ RunTime:0.000440s ] [2025-08-22T18:40:28+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:28' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000395s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001198s ] [2025-08-22T18:40:28+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (65,64,63,60) [ RunTime:0.000435s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001142s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001362s ] [2025-08-22T18:40:28+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (80,74,62) [ RunTime:0.000427s ] [2025-08-22T18:40:28+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025081810510949072728' [ RunTime:0.000203s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001176s ] [2025-08-22T18:40:28+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000384s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001244s ] [2025-08-22T18:40:28+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.031835s ] [2025-08-22T18:40:28+08:00][sql] CONNECT:[ UseTime:0.001442s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001316s ] [2025-08-22T18:40:28+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000382s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000993s ] [2025-08-22T18:40:28+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000339s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001008s ] [2025-08-22T18:40:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:28' LIMIT 1 [ RunTime:0.000395s ] [2025-08-22T18:40:28+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:28' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000382s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001078s ] [2025-08-22T18:40:28+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (65,64,63,60) [ RunTime:0.000358s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001032s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001159s ] [2025-08-22T18:40:28+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (80,74,62) [ RunTime:0.000386s ] [2025-08-22T18:40:28+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025081810510949072728' [ RunTime:0.000229s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001095s ] [2025-08-22T18:40:28+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000304s ] [2025-08-22T18:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001118s ] [2025-08-22T18:40:28+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.029654s ] [2025-08-22T18:40:30+08:00][sql] CONNECT:[ UseTime:0.010588s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001450s ] [2025-08-22T18:40:30+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000445s ] [2025-08-22T18:40:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001067s ] [2025-08-22T18:40:30+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000359s ] [2025-08-22T18:40:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000948s ] [2025-08-22T18:40:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:30' LIMIT 1 [ RunTime:0.000420s ] [2025-08-22T18:40:30+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:30' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000365s ] [2025-08-22T18:40:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001132s ] [2025-08-22T18:40:30+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (65,64,63,60) [ RunTime:0.000382s ] [2025-08-22T18:40:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001118s ] [2025-08-22T18:40:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001201s ] [2025-08-22T18:40:30+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (80,74,62) [ RunTime:0.000398s ] [2025-08-22T18:40:30+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025081810510949072728' [ RunTime:0.000211s ] [2025-08-22T18:40:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001120s ] [2025-08-22T18:40:30+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000338s ] [2025-08-22T18:40:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001268s ] [2025-08-22T18:40:30+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.030272s ] [2025-08-22T18:40:50+08:00][sql] CONNECT:[ UseTime:0.010464s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001320s ] [2025-08-22T18:40:50+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000418s ] [2025-08-22T18:40:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001048s ] [2025-08-22T18:40:50+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000350s ] [2025-08-22T18:40:50+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000969s ] [2025-08-22T18:40:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:50' LIMIT 1 [ RunTime:0.000425s ] [2025-08-22T18:40:50+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:50' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000381s ] [2025-08-22T18:40:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001119s ] [2025-08-22T18:40:50+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (65,64,63,60) [ RunTime:0.000338s ] [2025-08-22T18:40:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001126s ] [2025-08-22T18:40:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001139s ] [2025-08-22T18:40:50+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (80,74,62) [ RunTime:0.000391s ] [2025-08-22T18:40:50+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025081810510949072728' [ RunTime:0.000220s ] [2025-08-22T18:40:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001147s ] [2025-08-22T18:40:50+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000347s ] [2025-08-22T18:40:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001154s ] [2025-08-22T18:40:50+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.030137s ] [2025-08-22T18:40:56+08:00][sql] CONNECT:[ UseTime:0.010858s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001241s ] [2025-08-22T18:40:56+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000404s ] [2025-08-22T18:40:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000964s ] [2025-08-22T18:40:56+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000329s ] [2025-08-22T18:40:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000910s ] [2025-08-22T18:40:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:56' LIMIT 1 [ RunTime:0.000384s ] [2025-08-22T18:40:56+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:56' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000355s ] [2025-08-22T18:40:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001010s ] [2025-08-22T18:40:56+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (65,64,63,60) [ RunTime:0.000345s ] [2025-08-22T18:40:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000996s ] [2025-08-22T18:40:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001083s ] [2025-08-22T18:40:56+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (80,74,62) [ RunTime:0.000374s ] [2025-08-22T18:40:56+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025081810510949072728' [ RunTime:0.000199s ] [2025-08-22T18:40:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001039s ] [2025-08-22T18:40:56+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000304s ] [2025-08-22T18:40:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001086s ] [2025-08-22T18:40:56+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.028702s ] [2025-08-22T18:40:58+08:00][sql] CONNECT:[ UseTime:0.010988s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T18:40:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001237s ] [2025-08-22T18:40:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000446s ] [2025-08-22T18:40:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000940s ] [2025-08-22T18:40:58+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000333s ] [2025-08-22T18:40:58+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000899s ] [2025-08-22T18:40:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:58' LIMIT 1 [ RunTime:0.000375s ] [2025-08-22T18:40:58+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-05-24 18:40:58' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000378s ] [2025-08-22T18:40:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001021s ] [2025-08-22T18:40:58+08:00][sql] SELECT `id`,`tid`,`num`,`unit_price`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_gold` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (65,64,63,60) [ RunTime:0.000351s ] [2025-08-22T18:40:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001001s ] [2025-08-22T18:40:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001073s ] [2025-08-22T18:40:58+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (80,74,62) [ RunTime:0.000373s ] [2025-08-22T18:40:58+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025081810510949072728' [ RunTime:0.000194s ] [2025-08-22T18:40:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001038s ] [2025-08-22T18:40:58+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 81 [ RunTime:0.000295s ] [2025-08-22T18:40:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001094s ] [2025-08-22T18:40:58+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` = 42216 [ RunTime:0.028473s ] [2025-08-22T20:06:05+08:00][sql] CONNECT:[ UseTime:0.001508s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-08-22T20:06:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001443s ] [2025-08-22T20:06:05+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.000442s ] [2025-08-22T20:06:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001115s ] [2025-08-22T20:06:05+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000213s ]