[2025-11-04T03:16:07+08:00][sql] CONNECT:[ UseTime:0.001450s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T03:16:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001297s ] [2025-11-04T03:16: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.000442s ] [2025-11-04T03:16:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001038s ] [2025-11-04T03:16:07+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000234s ] [2025-11-04T09:38:35+08:00][sql] CONNECT:[ UseTime:0.007931s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:38:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001335s ] [2025-11-04T09:38:35+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000450s ] [2025-11-04T09:38:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001032s ] [2025-11-04T09:38:35+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000222s ] [2025-11-04T09:38:37+08:00][sql] CONNECT:[ UseTime:0.011672s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:38:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001211s ] [2025-11-04T09:38:37+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.000390s ] [2025-11-04T09:38:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000937s ] [2025-11-04T09:38:37+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '116dbfb732616492e66bc9c04e703fd8' AND `status` = 1 LIMIT 1 [ RunTime:0.000270s ] [2025-11-04T09:38:37+08:00][sql] CONNECT:[ UseTime:0.003780s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:38:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001106s ] [2025-11-04T09:38: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.000369s ] [2025-11-04T09:38:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001124s ] [2025-11-04T09:38:37+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-11-04 08:33:37' AND '2025-11-04 09:33:37' AND `specuser` = '' LIMIT 1 [ RunTime:0.000438s ] [2025-11-04T09:38:38+08:00][sql] CONNECT:[ UseTime:0.001416s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:38:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001278s ] [2025-11-04T09:38: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.000393s ] [2025-11-04T09:38:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001139s ] [2025-11-04T09:38:38+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-11-04 09:33:38' LIMIT 1 [ RunTime:0.000421s ] [2025-11-04T09:38:38+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-11-04 09:33:38' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000443s ] [2025-11-04T09:38:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000915s ] [2025-11-04T09:38:38+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 120 GROUP BY `tid` [ RunTime:0.000277s ] [2025-11-04T09:38:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001088s ] [2025-11-04T09:38:38+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 120 [ RunTime:0.000229s ] [2025-11-04T09:38:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001023s ] [2025-11-04T09:38:40+08:00][sql] CONNECT:[ UseTime:0.005494s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:38:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001227s ] [2025-11-04T09:38: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.000390s ] [2025-11-04T09:38:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001160s ] [2025-11-04T09:38: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-11-04 08:33:40' AND '2025-11-04 09:33:40' AND `specuser` = '' LIMIT 1 [ RunTime:0.000463s ] [2025-11-04T09:42:06+08:00][sql] CONNECT:[ UseTime:0.011071s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:42:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001306s ] [2025-11-04T09:42: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.000405s ] [2025-11-04T09:42:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001180s ] [2025-11-04T09:42:06+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-11-04 08:37:06' AND '2025-11-04 09:37:06' AND `specuser` = '' LIMIT 1 [ RunTime:0.000468s ] [2025-11-04T09:42:06+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` BETWEEN '2025-11-04 08:37:06' AND '2025-11-04 09:37:06' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000461s ] [2025-11-04T09:42:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000928s ] [2025-11-04T09:42:06+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 120 GROUP BY `tid` [ RunTime:0.000302s ] [2025-11-04T09:42:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000893s ] [2025-11-04T09:42:06+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 120 [ RunTime:0.000228s ] [2025-11-04T09:42:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001003s ] [2025-11-04T09:42:11+08:00][sql] CONNECT:[ UseTime:0.008220s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001228s ] [2025-11-04T09:42: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.000376s ] [2025-11-04T09:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001107s ] [2025-11-04T09:42:11+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` = 65 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000306s ] [2025-11-04T09:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000992s ] [2025-11-04T09:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000903s ] [2025-11-04T09:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001012s ] [2025-11-04T09:42:11+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` = 120 [ RunTime:0.000323s ] [2025-11-04T09:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001097s ] [2025-11-04T09:42:11+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` = 120 [ RunTime:0.000371s ] [2025-11-04T09:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001097s ] [2025-11-04T09:42:11+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 (4003,23170,40255,126104,120012,126071,11203,14202) [ RunTime:0.037259s ] [2025-11-04T09:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001116s ] [2025-11-04T09:42:11+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 120 [ RunTime:0.000375s ] [2025-11-04T09:42:11+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 (11203,14202,42144,126069,25007,25014,25040,25041,25045,25091,25236,30083,95001,127001,100092,100095,100098,100107,102216,166127,125133,125147,128057,166012,166043,166155) [ RunTime:0.037046s ] [2025-11-04T09:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001273s ] [2025-11-04T09:42:11+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` = 120 [ RunTime:0.000342s ] [2025-11-04T09:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000946s ] [2025-11-04T09:42:11+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` = 120 [ RunTime:0.000303s ] [2025-11-04T09:42:11+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 120 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000227s ] [2025-11-04T09:42:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000925s ] [2025-11-04T09:42:19+08:00][sql] CONNECT:[ UseTime:0.004499s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001225s ] [2025-11-04T09:42: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.000395s ] [2025-11-04T09:42:19+08:00][sql] CONNECT:[ UseTime:0.046679s ] mysql:host=47.103.95.153;port=33006;dbname=ctwl;charset=utf8 [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `ct_member` [ RunTime:0.031823s ] [2025-11-04T09:42:19+08:00][sql] SELECT `uid`,`username`,`password`,`salt` FROM `ct_member` WHERE `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.073217s ] [2025-11-04T09:42:19+08:00][sql] CONNECT:[ UseTime:0.002160s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001220s ] [2025-11-04T09:42: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.000378s ] [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000945s ] [2025-11-04T09:42: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.000323s ] [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001020s ] [2025-11-04T09:42:19+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` = 65 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000304s ] [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000987s ] [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000887s ] [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.000979s ] [2025-11-04T09:42:19+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` = 120 [ RunTime:0.000331s ] [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001097s ] [2025-11-04T09:42:19+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` = 120 [ RunTime:0.000439s ] [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001074s ] [2025-11-04T09:42:19+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 (4003,23170,40255,126104,120012,126071,11203,14202) [ RunTime:0.039157s ] [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001055s ] [2025-11-04T09:42:19+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `tid` = 120 [ RunTime:0.000380s ] [2025-11-04T09:42:19+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 (11203,14202,42144,126069,25007,25014,25040,25041,25045,25091,25236,30083,95001,127001,100092,100095,100098,100107,102216,166127,125133,125147,128057,166012,166043,166155) [ RunTime:0.038915s ] [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001286s ] [2025-11-04T09:42:19+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` = 120 [ RunTime:0.000343s ] [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000989s ] [2025-11-04T09:42:19+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` = 120 [ RunTime:0.000293s ] [2025-11-04T09:42:19+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 120 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000244s ] [2025-11-04T09:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000845s ] [2025-11-04T09:42:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_collect` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `type` = 1 AND `relationid` = 65 LIMIT 1 [ RunTime:0.000308s ] [2025-11-04T09:42:25+08:00][sql] CONNECT:[ UseTime:0.001402s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:42:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001312s ] [2025-11-04T09:42: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.000409s ] [2025-11-04T09:42:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001012s ] [2025-11-04T09:42: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.000333s ] [2025-11-04T09:42:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001099s ] [2025-11-04T09:42:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-08-06 09:42:25' LIMIT 1 [ RunTime:0.000482s ] [2025-11-04T09:42:25+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-08-06 09:42:25' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000422s ] [2025-11-04T09:42:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001086s ] [2025-11-04T09:42:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001191s ] [2025-11-04T09:42: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 (120,118,91,89,86,80) [ RunTime:0.000459s ] [2025-11-04T09:42:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001081s ] [2025-11-04T09:42:25+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025090815131159021332' [ RunTime:0.000214s ] [2025-11-04T09:42:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001087s ] [2025-11-04T09:42: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` IN (88,81) [ RunTime:0.000338s ] [2025-11-04T09:42:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001153s ] [2025-11-04T09:42:25+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` IN (42216,126052) [ RunTime:0.029294s ] [2025-11-04T09:42:28+08:00][sql] CONNECT:[ UseTime:0.011558s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001325s ] [2025-11-04T09:42:28+08:00][sql] SELECT * FROM `trade_game` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `is_mtain` = 1 LIMIT 1 [ RunTime:0.000342s ] [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001018s ] [2025-11-04T09:42: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.000359s ] [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001087s ] [2025-11-04T09:42: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.000356s ] [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001017s ] [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001168s ] [2025-11-04T09:42:28+08:00][sql] SELECT `id`,`tid`,`trade_status` FROM `trade_role` WHERE `id` = 65 AND `username` = 'ctshaiya008' LIMIT 1 [ RunTime:0.000253s ] [2025-11-04T09:42:28+08:00][sql] SELECT `id`,`game`,`serverid`,`username`,`type`,`sync_status`,`sync_tradeno` FROM `trade` WHERE `id` = 120 AND `game` = 'shaiya5' AND `serverid` = 5 LIMIT 1 [ RunTime:0.000232s ] [2025-11-04T09:42:28+08:00][sql] UPDATE `trade_role` SET `trade_status` = 5 WHERE `id` = 65 [ RunTime:0.000206s ] [2025-11-04T09:42:28+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 120 , `username` = 'ctshaiya008' , `orderno` = '' , `trade_type` = 1 , `type` = 3 , `content` = '%s已完成下架%s，商品已退回游戏，请前往游戏内角色列表/角色邮箱查收。如有疑问可联系官方客服咨询%s' [ RunTime:0.000220s ] [2025-11-04T09:42:28+08:00][sql] CONNECT:[ UseTime:0.014998s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001215s ] [2025-11-04T09:42: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.000369s ] [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000963s ] [2025-11-04T09:42: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.000430s ] [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000980s ] [2025-11-04T09:42:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-08-06 09:42:28' LIMIT 1 [ RunTime:0.000438s ] [2025-11-04T09:42:28+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-08-06 09:42:28' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000403s ] [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001043s ] [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001160s ] [2025-11-04T09:42: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 (120,118,91,89,86,80) [ RunTime:0.000433s ] [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001174s ] [2025-11-04T09:42:28+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025090815131159021332' [ RunTime:0.000235s ] [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001009s ] [2025-11-04T09:42: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` IN (88,81) [ RunTime:0.000319s ] [2025-11-04T09:42:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001084s ] [2025-11-04T09:42:28+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` IN (42216,126052) [ RunTime:0.028502s ] [2025-11-04T09:42:30+08:00][sql] CONNECT:[ UseTime:0.013368s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T09:42:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001221s ] [2025-11-04T09:42: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.000385s ] [2025-11-04T09:42:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000937s ] [2025-11-04T09:42: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.000321s ] [2025-11-04T09:42:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000874s ] [2025-11-04T09:42:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-08-06 09:42:30' LIMIT 1 [ RunTime:0.000442s ] [2025-11-04T09:42:30+08:00][sql] SELECT `id`,`type` FROM `trade` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `username` = 'ctshaiya008' AND `created_at` >= '2025-08-06 09:42:30' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000410s ] [2025-11-04T09:42:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001002s ] [2025-11-04T09:42:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001036s ] [2025-11-04T09:42: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 (120,118,91,89,86,80) [ RunTime:0.000411s ] [2025-11-04T09:42:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000989s ] [2025-11-04T09:42:30+08:00][sql] SELECT `orderno`,`addtime`,`pay_status` FROM `trade_order` WHERE `orderno` = 'R2025090815131159021332' [ RunTime:0.000238s ] [2025-11-04T09:42:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001013s ] [2025-11-04T09:42: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` IN (88,81) [ RunTime:0.000325s ] [2025-11-04T09:42:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001089s ] [2025-11-04T09:42:30+08:00][sql] SELECT `itemid`,`icon`,`itemname`,`iconset`,`og` FROM `trade_items` WHERE `game` = 'shaiya5' AND `serverid` = 5 AND `itemid` IN (42216,126052) [ RunTime:0.029998s ] [2025-11-04T13:32:42+08:00][sql] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T13:32:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001380s ] [2025-11-04T13:32:42+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.000417s ] [2025-11-04T13:32:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001007s ] [2025-11-04T13:32:42+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000209s ] [2025-11-04T18:08:01+08:00][sql] CONNECT:[ UseTime:0.001400s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T18:08:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001248s ] [2025-11-04T18:08:01+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.000517s ] [2025-11-04T18:08:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001020s ] [2025-11-04T18:08:01+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000222s ] [2025-11-04T18:08:55+08:00][sql] CONNECT:[ UseTime:0.001440s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T18:08:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001286s ] [2025-11-04T18:08:55+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.000401s ] [2025-11-04T18:08:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000990s ] [2025-11-04T18:08:55+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000203s ] [2025-11-04T21:22:17+08:00][sql] CONNECT:[ UseTime:0.001423s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-11-04T21:22:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001224s ] [2025-11-04T21:22:17+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000392s ] [2025-11-04T21:22:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000965s ] [2025-11-04T21:22:17+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000202s ]