[2025-12-02T06:50:22+08:00][sql] CONNECT:[ UseTime:0.001500s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T06:50:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001382s ] [2025-12-02T06:50:22+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000428s ] [2025-12-02T06:50:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001045s ] [2025-12-02T06:50:22+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000237s ] [2025-12-02T12:28:01+08:00][info] 系统错误{"Message":"Route Not Found","Line":820,"File":"C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Route.php","Trace":"#0 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Route.php(783): think\\Route->check()\n#1 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(216): think\\Route->dispatch(Object(app\\Request), Object(Closure))\n#2 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(206): think\\Http->dispatchToRoute(Object(app\\Request))\n#3 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(59): think\\Http->think\\{closure}(Object(app\\Request))\n#4 C:\\wamp64\\www\\zbg\\vendor\\topthink\\think-multi-app\\src\\MultiApp.php(51): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#5 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(59): think\\app\\MultiApp->think\\app\\{closure}(Object(app\\Request))\n#6 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\middleware\\SessionInit.php(67): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#7 [internal function]: think\\middleware\\SessionInit->handle(Object(app\\Request), Object(Closure))\n#8 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Middleware.php(142): call_user_func(Array, Object(app\\Request), Object(Closure))\n#9 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(85): think\\Middleware->think\\{closure}(Object(app\\Request), Object(Closure))\n#10 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\middleware\\LoadLangPack.php(57): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#11 [internal function]: think\\middleware\\LoadLangPack->handle(Object(app\\Request), Object(Closure))\n#12 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Middleware.php(142): call_user_func(Array, Object(app\\Request), Object(Closure))\n#13 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(85): think\\Middleware->think\\{closure}(Object(app\\Request), Object(Closure))\n#14 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(66): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#15 C:\\wamp64\\www\\zbg\\vendor\\topthink\\think-multi-app\\src\\MultiApp.php(52): think\\Pipeline->then(Object(Closure))\n#16 [internal function]: think\\app\\MultiApp->handle(Object(app\\Request), Object(Closure))\n#17 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Middleware.php(142): call_user_func(Array, Object(app\\Request), Object(Closure))\n#18 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(85): think\\Middleware->think\\{closure}(Object(app\\Request), Object(Closure))\n#19 C:\\wamp64\\www\\zbg\\vendor\\topthink\\think-trace\\src\\TraceDebug.php(71): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#20 [internal function]: think\\trace\\TraceDebug->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\\Pipeline.php(66): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#24 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(207): think\\Pipeline->then(Object(Closure))\n#25 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(170): think\\Http->runWithRequest(Object(app\\Request))\n#26 C:\\wamp64\\www\\zbg\\public\\index.php(19): think\\Http->run()\n#27 {main}"} [2025-12-02T12:28:01+08:00][info] 系统错误{"Message":"Route Not Found","Line":820,"File":"C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Route.php","Trace":"#0 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Route.php(783): think\\Route->check()\n#1 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(216): think\\Route->dispatch(Object(app\\Request), Object(Closure))\n#2 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(206): think\\Http->dispatchToRoute(Object(app\\Request))\n#3 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(59): think\\Http->think\\{closure}(Object(app\\Request))\n#4 C:\\wamp64\\www\\zbg\\vendor\\topthink\\think-multi-app\\src\\MultiApp.php(51): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#5 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(59): think\\app\\MultiApp->think\\app\\{closure}(Object(app\\Request))\n#6 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\middleware\\SessionInit.php(67): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#7 [internal function]: think\\middleware\\SessionInit->handle(Object(app\\Request), Object(Closure))\n#8 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Middleware.php(142): call_user_func(Array, Object(app\\Request), Object(Closure))\n#9 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(85): think\\Middleware->think\\{closure}(Object(app\\Request), Object(Closure))\n#10 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\middleware\\LoadLangPack.php(57): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#11 [internal function]: think\\middleware\\LoadLangPack->handle(Object(app\\Request), Object(Closure))\n#12 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Middleware.php(142): call_user_func(Array, Object(app\\Request), Object(Closure))\n#13 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(85): think\\Middleware->think\\{closure}(Object(app\\Request), Object(Closure))\n#14 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(66): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#15 C:\\wamp64\\www\\zbg\\vendor\\topthink\\think-multi-app\\src\\MultiApp.php(52): think\\Pipeline->then(Object(Closure))\n#16 [internal function]: think\\app\\MultiApp->handle(Object(app\\Request), Object(Closure))\n#17 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Middleware.php(142): call_user_func(Array, Object(app\\Request), Object(Closure))\n#18 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Pipeline.php(85): think\\Middleware->think\\{closure}(Object(app\\Request), Object(Closure))\n#19 C:\\wamp64\\www\\zbg\\vendor\\topthink\\think-trace\\src\\TraceDebug.php(71): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#20 [internal function]: think\\trace\\TraceDebug->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\\Pipeline.php(66): think\\Pipeline->think\\{closure}(Object(app\\Request))\n#24 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(207): think\\Pipeline->then(Object(Closure))\n#25 C:\\wamp64\\www\\zbg\\vendor\\topthink\\framework\\src\\think\\Http.php(170): think\\Http->runWithRequest(Object(app\\Request))\n#26 C:\\wamp64\\www\\zbg\\public\\index.php(19): think\\Http->run()\n#27 {main}"} [2025-12-02T17:26:09+08:00][sql] CONNECT:[ UseTime:0.010812s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:26:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001235s ] [2025-12-02T17:26:09+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000399s ] [2025-12-02T17:26:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000967s ] [2025-12-02T17:26:09+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000229s ] [2025-12-02T17:26:10+08:00][sql] CONNECT:[ UseTime:0.001459s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001307s ] [2025-12-02T17:26:10+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000400s ] [2025-12-02T17:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001016s ] [2025-12-02T17:26:10+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '116dbfb732616492e66bc9c04e703fd8' AND `status` = 1 LIMIT 1 [ RunTime:0.000312s ] [2025-12-02T17:26:10+08:00][sql] CONNECT:[ UseTime:0.010822s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001113s ] [2025-12-02T17:26:10+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000386s ] [2025-12-02T17:26:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001165s ] [2025-12-02T17:26:10+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-12-02 16:21:10' AND '2025-12-02 17:21:10' AND `specuser` = '' LIMIT 1 [ RunTime:0.000478s ] [2025-12-02T17:29:20+08:00][sql] CONNECT:[ UseTime:0.010909s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:29:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001336s ] [2025-12-02T17:29:20+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000387s ] [2025-12-02T17:29:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001181s ] [2025-12-02T17:29:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2025-12-02 16:24:20' AND '2025-12-02 17:24:20' AND `specuser` = '' LIMIT 1 [ RunTime:0.000462s ] [2025-12-02T17:29:35+08:00][sql] CONNECT:[ UseTime:0.001374s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:29:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001232s ] [2025-12-02T17:29:35+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000440s ] [2025-12-02T17:29:35+08:00][sql] CONNECT:[ UseTime:0.047282s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-12-02T17:29:35+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.031833s ] [2025-12-02T17:29:35+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya001' LIMIT 1 [ RunTime:0.072848s ] [2025-12-02T17:29:36+08:00][sql] CONNECT:[ UseTime:0.010410s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:29:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001266s ] [2025-12-02T17:29:36+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000419s ] [2025-12-02T17:29:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000974s ] [2025-12-02T17:29:36+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000339s ] [2025-12-02T17:29:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001108s ] [2025-12-02T17:29:36+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-12-02 16:24:36' AND '2025-12-02 17:24:36' AND `specuser` = '' LIMIT 1 [ RunTime:0.000452s ] [2025-12-02T17:29:37+08:00][sql] CONNECT:[ UseTime:0.010369s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:29:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001218s ] [2025-12-02T17:29:37+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.000370s ] [2025-12-02T17:29:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000938s ] [2025-12-02T17:29:37+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000320s ] [2025-12-02T17:29:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000329s ] [2025-12-02T17:29:37+08:00][sql] SELECT `id`,`tid`,`content`,`created_at`,`is_read`,`trade_type`,`type`,`orderno` FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `deleted_at` IS NULL ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000288s ] [2025-12-02T17:29:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001077s ] [2025-12-02T17:29:37+08:00][sql] SELECT `id`,`tid`,`chaname` FROM `trade_role` WHERE `tid` IN (132,131,130,129,128,119,76,73) [ RunTime:0.000293s ] [2025-12-02T17:29:38+08:00][sql] CONNECT:[ UseTime:0.010882s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:29:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001249s ] [2025-12-02T17:29:38+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000384s ] [2025-12-02T17:29:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000948s ] [2025-12-02T17:29:38+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000332s ] [2025-12-02T17:29:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000906s ] [2025-12-02T17:29:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:29:38' LIMIT 1 [ RunTime:0.000491s ] [2025-12-02T17:29:38+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:29:38' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000603s ] [2025-12-02T17:29:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001035s ] [2025-12-02T17:29:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001080s ] [2025-12-02T17:29:38+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 (147,132,131,130,129,128,119) [ RunTime:0.000495s ] [2025-12-02T17:29:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001222s ] [2025-12-02T17:29:38+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000343s ] [2025-12-02T17:29:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001297s ] [2025-12-02T17:29:38+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000244s ] [2025-12-02T17:29:40+08:00][sql] CONNECT:[ UseTime:0.001429s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:29:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001281s ] [2025-12-02T17:29: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.000407s ] [2025-12-02T17:29:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001011s ] [2025-12-02T17:29:40+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000339s ] [2025-12-02T17:29:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001118s ] [2025-12-02T17:29:40+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-12-02 16:24:40' AND '2025-12-02 17:24:40' AND `specuser` = '' LIMIT 1 [ RunTime:0.000463s ] [2025-12-02T17:29:41+08:00][sql] CONNECT:[ UseTime:0.012737s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:29:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001382s ] [2025-12-02T17:29:41+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000412s ] [2025-12-02T17:29:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001127s ] [2025-12-02T17:29:41+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000367s ] [2025-12-02T17:29:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001257s ] [2025-12-02T17:29:41+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-12-02 17:24:41' LIMIT 1 [ RunTime:0.000515s ] [2025-12-02T17:29:47+08:00][sql] CONNECT:[ UseTime:0.011613s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001380s ] [2025-12-02T17:29:47+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000422s ] [2025-12-02T17:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001118s ] [2025-12-02T17:29:47+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000364s ] [2025-12-02T17:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001302s ] [2025-12-02T17:29:47+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-12-02 17:24:46' LIMIT 1 [ RunTime:0.000494s ] [2025-12-02T17:29:47+08:00][sql] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001385s ] [2025-12-02T17:29:47+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000450s ] [2025-12-02T17:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001085s ] [2025-12-02T17:29:47+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000321s ] [2025-12-02T17:29:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001199s ] [2025-12-02T17:29:47+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-12-02 17:24:47' LIMIT 1 [ RunTime:0.000418s ] [2025-12-02T17:30:10+08:00][sql] CONNECT:[ UseTime:0.011242s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:30:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001314s ] [2025-12-02T17:30:10+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000394s ] [2025-12-02T17:30:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001011s ] [2025-12-02T17:30:10+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000333s ] [2025-12-02T17:30:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001087s ] [2025-12-02T17:30:10+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-12-02 17:25:10' LIMIT 1 [ RunTime:0.000461s ] [2025-12-02T17:31:32+08:00][sql] CONNECT:[ UseTime:0.011149s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:31:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001325s ] [2025-12-02T17:31:32+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000430s ] [2025-12-02T17:31:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001070s ] [2025-12-02T17:31:32+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000391s ] [2025-12-02T17:31:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001185s ] [2025-12-02T17:31:32+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-12-02 17:26:32' LIMIT 1 [ RunTime:0.000536s ] [2025-12-02T17:31:32+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-12-02 17:26:32' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000523s ] [2025-12-02T17:31:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000993s ] [2025-12-02T17:31:32+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 GROUP BY `tid` [ RunTime:0.000286s ] [2025-12-02T17:31:32+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000958s ] [2025-12-02T17:31:32+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 147 [ RunTime:0.000219s ] [2025-12-02T17:31:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001091s ] [2025-12-02T17:31:34+08:00][sql] CONNECT:[ UseTime:0.001478s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001333s ] [2025-12-02T17:31: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.000450s ] [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001056s ] [2025-12-02T17:31:34+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000346s ] [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001159s ] [2025-12-02T17:31:34+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`job`,`grow`,`specuser`,`chaid`,`chaname`,`chalv`,`kill`,`family`,`price`,`created_at`,`trade_status`,`pay_status`,`money` FROM `trade_role` WHERE `id` = 79 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000337s ] [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001071s ] [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001050s ] [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001096s ] [2025-12-02T17:31:34+08:00][sql] SELECT `id`,`game`,`type`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ap`,`dp`,`af`,`as`,`am`,`df`,`ds`,`dm` FROM `trade_war` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 [ RunTime:0.000350s ] [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001260s ] [2025-12-02T17:31:34+08:00][sql] SELECT `id`,`game`,`type`,`itemid`,`st`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ia`,`iav`,`ide`,`idm`,`rd`,`sl`,`cj`,`g1`,`g2`,`g3`,`g4`,`g5`,`g6` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 [ RunTime:0.000415s ] [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001215s ] [2025-12-02T17:31:34+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` IN (13203,13003,40255,126106,126113) [ RunTime:0.039139s ] [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000990s ] [2025-12-02T17:31:34+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 [ RunTime:0.000385s ] [2025-12-02T17:31:34+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` IN (100143,100175,100182,101197,100214,128194,125059,123230) [ RunTime:0.038186s ] [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001201s ] [2025-12-02T17:31:34+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`skillid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 [ RunTime:0.000390s ] [2025-12-02T17:31:34+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`godid` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `godid` = 210401 [ RunTime:0.000294s ] [2025-12-02T17:31:34+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`skillid` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `skillid` = 1 [ RunTime:0.000304s ] [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001032s ] [2025-12-02T17:31:34+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 [ RunTime:0.000284s ] [2025-12-02T17:31:34+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 147 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000219s ] [2025-12-02T17:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000980s ] [2025-12-02T17:31:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `type` = 1 AND `relationid` = 79 LIMIT 1 [ RunTime:0.000310s ] [2025-12-02T17:31:48+08:00][sql] CONNECT:[ UseTime:0.010993s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001242s ] [2025-12-02T17:31:48+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000372s ] [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000968s ] [2025-12-02T17:31:48+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000402s ] [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001102s ] [2025-12-02T17:31:48+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`job`,`grow`,`specuser`,`chaid`,`chaname`,`chalv`,`kill`,`family`,`price`,`created_at`,`trade_status`,`pay_status`,`money` FROM `trade_role` WHERE `id` = 79 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000332s ] [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000999s ] [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000953s ] [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001013s ] [2025-12-02T17:31:48+08:00][sql] SELECT `id`,`game`,`type`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ap`,`dp`,`af`,`as`,`am`,`df`,`ds`,`dm` FROM `trade_war` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 [ RunTime:0.000341s ] [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001105s ] [2025-12-02T17:31:48+08:00][sql] SELECT `id`,`game`,`type`,`itemid`,`st`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ia`,`iav`,`ide`,`idm`,`rd`,`sl`,`cj`,`g1`,`g2`,`g3`,`g4`,`g5`,`g6` FROM `trade_equip` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 [ RunTime:0.000381s ] [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001116s ] [2025-12-02T17:31:48+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` IN (13203,13003,40255,126106,126113) [ RunTime:0.036911s ] [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000884s ] [2025-12-02T17:31:48+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 [ RunTime:0.000308s ] [2025-12-02T17:31:48+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` IN (100143,100175,100182,101197,100214,128194,125059,123230) [ RunTime:0.035974s ] [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001080s ] [2025-12-02T17:31:48+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`skillid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 [ RunTime:0.000335s ] [2025-12-02T17:31:48+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`godid` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `godid` = 210401 [ RunTime:0.000297s ] [2025-12-02T17:31:48+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`skillid` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `skillid` = 1 [ RunTime:0.000325s ] [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000938s ] [2025-12-02T17:31:48+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 [ RunTime:0.000282s ] [2025-12-02T17:31:48+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 147 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000220s ] [2025-12-02T17:31:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001160s ] [2025-12-02T17:31:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `type` = 1 AND `relationid` = 79 LIMIT 1 [ RunTime:0.000328s ] [2025-12-02T17:32:35+08:00][sql] CONNECT:[ UseTime:0.001412s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:32:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001280s ] [2025-12-02T17:32:35+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.000367s ] [2025-12-02T17:32:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001019s ] [2025-12-02T17:32:35+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000370s ] [2025-12-02T17:32:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001094s ] [2025-12-02T17:32:35+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-12-02 17:27:35' LIMIT 1 [ RunTime:0.000411s ] [2025-12-02T17:32:35+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`chalv`,`kill`,`price`,`grow`,`created_at`,`trade_status`,`job`,`family`,`pay_status`,`specuser` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2025-12-02 17:27:35' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000449s ] [2025-12-02T17:32:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000869s ] [2025-12-02T17:32:35+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 147 GROUP BY `tid` [ RunTime:0.000283s ] [2025-12-02T17:32:35+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000903s ] [2025-12-02T17:32:35+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 147 [ RunTime:0.000209s ] [2025-12-02T17:32:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000971s ] [2025-12-02T17:32:39+08:00][sql] CONNECT:[ UseTime:0.001374s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:32:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001220s ] [2025-12-02T17:32:39+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000433s ] [2025-12-02T17:32:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000947s ] [2025-12-02T17:32:39+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000324s ] [2025-12-02T17:32:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001022s ] [2025-12-02T17:32:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_order` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tousername` = 'ctshaiya001' AND `addtime` >= 1762075959 LIMIT 1 [ RunTime:0.000310s ] [2025-12-02T17:32:40+08:00][sql] CONNECT:[ UseTime:0.011446s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:32:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001318s ] [2025-12-02T17:32: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.000392s ] [2025-12-02T17:32:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001028s ] [2025-12-02T17:32:40+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000348s ] [2025-12-02T17:32:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000966s ] [2025-12-02T17:32:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:32:40' LIMIT 1 [ RunTime:0.000473s ] [2025-12-02T17:32:40+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:32:40' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000551s ] [2025-12-02T17:32:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001107s ] [2025-12-02T17:32:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001133s ] [2025-12-02T17:32:40+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 (147,132,131,130,129,128,119) [ RunTime:0.000476s ] [2025-12-02T17:32:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001060s ] [2025-12-02T17:32:40+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000247s ] [2025-12-02T17:32:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001142s ] [2025-12-02T17:32:40+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.000273s ] [2025-12-02T17:32:44+08:00][sql] CONNECT:[ UseTime:0.010978s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001269s ] [2025-12-02T17:32:44+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.000435s ] [2025-12-02T17:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000951s ] [2025-12-02T17:32:44+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000312s ] [2025-12-02T17:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000916s ] [2025-12-02T17:32:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:32:44' LIMIT 1 [ RunTime:0.000426s ] [2025-12-02T17:32:44+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:32:44' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000549s ] [2025-12-02T17:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001043s ] [2025-12-02T17:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001145s ] [2025-12-02T17:32:44+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 (147,132,131,130,129,128,119) [ RunTime:0.000444s ] [2025-12-02T17:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000986s ] [2025-12-02T17:32:44+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000240s ] [2025-12-02T17:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001065s ] [2025-12-02T17:32:44+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.000234s ] [2025-12-02T17:33:02+08:00][sql] CONNECT:[ UseTime:0.001414s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001329s ] [2025-12-02T17:33:02+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000463s ] [2025-12-02T17:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001094s ] [2025-12-02T17:33:02+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000318s ] [2025-12-02T17:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001162s ] [2025-12-02T17:33:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:33:02' LIMIT 1 [ RunTime:0.000477s ] [2025-12-02T17:33:02+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:33:02' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000515s ] [2025-12-02T17:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001101s ] [2025-12-02T17:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001166s ] [2025-12-02T17:33:02+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 (147,132,131,130,129,128,119) [ RunTime:0.000482s ] [2025-12-02T17:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001047s ] [2025-12-02T17:33:02+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000256s ] [2025-12-02T17:33:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001124s ] [2025-12-02T17:33:02+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.000240s ] [2025-12-02T17:33:10+08:00][sql] CONNECT:[ UseTime:0.011618s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:33:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001325s ] [2025-12-02T17:33:10+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000403s ] [2025-12-02T17:33:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001039s ] [2025-12-02T17:33:10+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000356s ] [2025-12-02T17:33:10+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000953s ] [2025-12-02T17:33:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:33:10' LIMIT 1 [ RunTime:0.000495s ] [2025-12-02T17:33:10+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:33:10' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000530s ] [2025-12-02T17:33:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001122s ] [2025-12-02T17:33:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001129s ] [2025-12-02T17:33:10+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (147,132,131,130,129,128,119) [ RunTime:0.000447s ] [2025-12-02T17:33:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001073s ] [2025-12-02T17:33:10+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000312s ] [2025-12-02T17:33:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001112s ] [2025-12-02T17:33:10+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000246s ] [2025-12-02T17:33:21+08:00][sql] CONNECT:[ UseTime:0.011063s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:33:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001270s ] [2025-12-02T17:33:21+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000322s ] [2025-12-02T17:33:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.000972s ] [2025-12-02T17:33: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.000344s ] [2025-12-02T17:33:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000906s ] [2025-12-02T17:33:21+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000310s ] [2025-12-02T17:33:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001205s ] [2025-12-02T17:33:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001162s ] [2025-12-02T17:33:21+08:00][sql] SELECT `id`,`tid`,`trade_status` FROM `trade_role` WHERE `id` = 79 AND `username` = 'ctshaiya001' LIMIT 1 [ RunTime:0.000238s ] [2025-12-02T17:33:21+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_status`,`sync_tradeno` FROM `trade` WHERE `id` = 147 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000247s ] [2025-12-02T17:33:21+08:00][sql] UPDATE `trade_role` SET `trade_status` = 5 WHERE `id` = 79 [ RunTime:0.000214s ] [2025-12-02T17:33:21+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 147 , `username` = 'ctshaiya001' , `orderno` = '' , `trade_type` = 1 , `type` = 3 , `content` = '%s已完成下架%s，商品已退回游戏，请前往游戏内角色列表/角色邮箱查收。如有疑问可联系官方客服咨询%s' [ RunTime:0.000226s ] [2025-12-02T17:33:22+08:00][sql] CONNECT:[ UseTime:0.010958s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:33:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001337s ] [2025-12-02T17:33:22+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000404s ] [2025-12-02T17:33:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001053s ] [2025-12-02T17:33:22+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000342s ] [2025-12-02T17:33:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000962s ] [2025-12-02T17:33:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:33:22' LIMIT 1 [ RunTime:0.000476s ] [2025-12-02T17:33:22+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:33:22' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000503s ] [2025-12-02T17:33:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001139s ] [2025-12-02T17:33:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001169s ] [2025-12-02T17:33:22+08:00][sql] SELECT `id`,`game`,`tid`,`family`,`job`,`grow`,`price`,`chalv`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_role` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` IN (147,132,131,130,129,128,119) [ RunTime:0.000453s ] [2025-12-02T17:33:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001062s ] [2025-12-02T17:33:22+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000243s ] [2025-12-02T17:33:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001101s ] [2025-12-02T17:33:22+08:00][sql] SELECT `id`,`game`,`tid`,`itemid`,`num`,`price`,`api_status`,`pay_status`,`trade_status`,`outtime`,`created_at`,`orderno` FROM `trade_prop` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND 0 = 1 [ RunTime:0.000239s ] [2025-12-02T17:33:23+08:00][sql] CONNECT:[ UseTime:0.011407s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T17:33:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001489s ] [2025-12-02T17:33:23+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya5' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000478s ] [2025-12-02T17:33:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001074s ] [2025-12-02T17:33:23+08:00][sql] SELECT * FROM `trade_notice` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `is_read` = 0 LIMIT 1 [ RunTime:0.000367s ] [2025-12-02T17:33:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001004s ] [2025-12-02T17:33:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:33:23' LIMIT 1 [ RunTime:0.000519s ] [2025-12-02T17:33:23+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya001' AND `created_at` >= '2025-09-03 17:33:23' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000491s ] [2025-12-02T17:33:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001205s ] [2025-12-02T17:33:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001215s ] [2025-12-02T17:33:23+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 (147,132,131,130,129,128,119) [ RunTime:0.000526s ] [2025-12-02T17:33:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001152s ] [2025-12-02T17:33:23+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` IN ('R2025111113545512740371','R2025111114221479422544','R2025111115130369892401') [ RunTime:0.000263s ] [2025-12-02T17:33:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001183s ] [2025-12-02T17:33:23+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.000300s ] [2025-12-02T19:56:51+08:00][sql] CONNECT:[ UseTime:0.001440s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T19:56:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001296s ] [2025-12-02T19:56:51+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000428s ] [2025-12-02T19:56:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001053s ] [2025-12-02T19:56:51+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000215s ] [2025-12-02T20:19:39+08:00][sql] CONNECT:[ UseTime:0.001586s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T20:19:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001459s ] [2025-12-02T20:19:39+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000490s ] [2025-12-02T20:19:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001091s ] [2025-12-02T20:19:39+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000214s ] [2025-12-02T20:21:07+08:00][sql] CONNECT:[ UseTime:0.010914s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-12-02T20:21:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001367s ] [2025-12-02T20:21: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.000478s ] [2025-12-02T20:21:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001046s ] [2025-12-02T20:21:07+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000269s ]