[2026-01-13T10:18:54+08:00][sql] CONNECT:[ UseTime:0.011352s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T10:18:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001438s ] [2026-01-13T10:18:54+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.000500s ] [2026-01-13T10:18:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001095s ] [2026-01-13T10:18:54+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000214s ] [2026-01-13T10:18:57+08:00][sql] CONNECT:[ UseTime:0.001454s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T10:18:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001493s ] [2026-01-13T10:18:57+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.000482s ] [2026-01-13T10:18:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001095s ] [2026-01-13T10:18:57+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '5049a55a206d441ab03568ce2b48bcc4' AND `status` = 1 LIMIT 1 [ RunTime:0.000283s ] [2026-01-13T10:18:57+08:00][sql] CONNECT:[ UseTime:0.011075s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T10:18:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001163s ] [2026-01-13T10:18:57+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000395s ] [2026-01-13T10:18:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001201s ] [2026-01-13T10:18:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-13 09:13:57' AND '2026-01-13 10:13:57' AND `specuser` = '' LIMIT 1 [ RunTime:0.000469s ] [2026-01-13T10:22:10+08:00][sql] CONNECT:[ UseTime:0.010408s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T10:22:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001414s ] [2026-01-13T10:22:10+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000483s ] [2026-01-13T10:22:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001347s ] [2026-01-13T10:22:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-13 10:17:10' LIMIT 1 [ RunTime:0.000496s ] [2026-01-13T10:22:10+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` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-13 10:17:10' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000435s ] [2026-01-13T10:22:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001015s ] [2026-01-13T10:22:10+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 GROUP BY `tid` [ RunTime:0.000402s ] [2026-01-13T10:22:10+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001032s ] [2026-01-13T10:22:10+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 157 [ RunTime:0.000298s ] [2026-01-13T10:22:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001122s ] [2026-01-13T10:22:11+08:00][sql] CONNECT:[ UseTime:0.001469s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T10:22:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001332s ] [2026-01-13T10:22:11+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000419s ] [2026-01-13T10:22:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001193s ] [2026-01-13T10:22:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-13 09:17:11' AND '2026-01-13 10:17:11' AND `specuser` = '' LIMIT 1 [ RunTime:0.000433s ] [2026-01-13T10:22:11+08:00][sql] CONNECT:[ UseTime:0.001507s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T10:22:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001444s ] [2026-01-13T10:22:11+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000402s ] [2026-01-13T10:22:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001328s ] [2026-01-13T10:22:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-13 10:17:11' LIMIT 1 [ RunTime:0.000464s ] [2026-01-13T10:22:11+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` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-13 10:17:11' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000509s ] [2026-01-13T10:22:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001073s ] [2026-01-13T10:22:11+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 GROUP BY `tid` [ RunTime:0.000292s ] [2026-01-13T10:22:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000966s ] [2026-01-13T10:22:11+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 157 [ RunTime:0.000227s ] [2026-01-13T10:22:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001153s ] [2026-01-13T10:22:13+08:00][sql] CONNECT:[ UseTime:0.001518s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001480s ] [2026-01-13T10:22:13+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000375s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001254s ] [2026-01-13T10:22:13+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` = 89 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000312s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001195s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001131s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001176s ] [2026-01-13T10:22:13+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000404s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001279s ] [2026-01-13T10:22:13+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000537s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001288s ] [2026-01-13T10:22:13+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30227,30147,30013,30034,30068,30005,30192,98015,30195,30250,30092,30010,30045,98009,30146,30204,30203,30206,30069,30229,30048,30201,30191,30024,98003,30228,30080,30041,30088,98013,30009,98011,30207,30006,30081,98007,30211,30223,30212,30033) [ RunTime:0.031932s ] [2026-01-13T10:22:13+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81023,88023,89023,91023,92023,7230,90008,23155,22156,40155,42049,120059,31168,88002,89002,91002,92002,47017,90002,23243,22025,40247,42194,120123,31020,32020,33020,35020,36020,54086,84057,42031,7202,7211) [ RunTime:0.043168s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001132s ] [2026-01-13T10:22:13+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.002258s ] [2026-01-13T10:22:13+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (7202,7211,7230,88023,34096,43012,25021,25024,25027,25039,94014,94017,25068,25070,127019,127020,127022,127023,127025,127026,127027,127029,44089,44090,44091,127032,25163,25164,25165,25182,25183,25184,127067,127068,127069,127070,127102,127186,127187,127188,127190,127201,30003,30004,30011,30024,30025,30031,30038,30046,30054,30192,30195,30196,30199,30200,30201,30204,30206,30207,30211,30215,30216,30224,95001,95006,95011,95012,128001,129001,128002,100008,100009,129008,129015,101022,100045,100046,100061,100062,100092,100098,100101,100104,100107,100117,100131,100167,100169,100175,100176,118153,118154,101190,101191,101195,101197,101206,101208,100221,100225,100232,100234,101233,101234,100252,100254,177223,120128,128011,120126,38146,127211,128010,28147,101196,101139,177045,177222,177042,177043,28152,42019,101127,100144,101146,127254,128081,103055,101155,101138,28122,127103,127075,28146,38244,118155,119005,119004,103238,102107,120082,120051,120084,120013,120081,99202,151007,42007,42015,42142,42011,152001,153001,151001,154001,155001,7046) [ RunTime:0.043982s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001336s ] [2026-01-13T10:22:13+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000341s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001002s ] [2026-01-13T10:22:13+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000317s ] [2026-01-13T10:22:13+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 157 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000238s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000857s ] [2026-01-13T10:22:13+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 157 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000303s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000931s ] [2026-01-13T10:22:13+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000325s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000825s ] [2026-01-13T10:22:13+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (15,31,51,115,131,201,231,249,255) [ RunTime:0.000493s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000934s ] [2026-01-13T10:22:13+08:00][sql] SELECT `attr_tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000446s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001089s ] [2026-01-13T10:22:13+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (8,19,10,68,199,97,47,70,9,18,36,69,172,49,208,170,57,173,37,20,67,39,59,96,110,159,150,108,147,160,109,400,420,450,410,440,460,280,330,310,260,340,290,369,220,300,10127,10128,230,10146) [ RunTime:0.001197s ] [2026-01-13T10:22:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000944s ] [2026-01-13T10:43:20+08:00][sql] CONNECT:[ UseTime:0.001394s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T10:43:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001248s ] [2026-01-13T10:43:20+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.000375s ] [2026-01-13T10:43:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000956s ] [2026-01-13T10:43:20+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000201s ] [2026-01-13T10:43:25+08:00][sql] CONNECT:[ UseTime:0.001376s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T10:43:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001257s ] [2026-01-13T10:43:25+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.000412s ] [2026-01-13T10:43:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000976s ] [2026-01-13T10:43:25+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '5049a55a206d441ab03568ce2b48bcc4' AND `status` = 1 LIMIT 1 [ RunTime:0.000272s ] [2026-01-13T10:43:25+08:00][sql] CONNECT:[ UseTime:0.010308s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T10:43:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001161s ] [2026-01-13T10:43:25+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000384s ] [2026-01-13T10:43:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001186s ] [2026-01-13T10:43:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-13 09:38:25' AND '2026-01-13 10:38:25' AND `specuser` = '' LIMIT 1 [ RunTime:0.000609s ] [2026-01-13T10:43:25+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` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-13 09:38:25' AND '2026-01-13 10:38:25' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000516s ] [2026-01-13T10:43:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001038s ] [2026-01-13T10:43:25+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 GROUP BY `tid` [ RunTime:0.000398s ] [2026-01-13T10:43:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001061s ] [2026-01-13T10:43:25+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 157 [ RunTime:0.000250s ] [2026-01-13T10:43:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001196s ] [2026-01-13T10:43:27+08:00][sql] CONNECT:[ UseTime:0.001418s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001245s ] [2026-01-13T10:43:27+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000436s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001111s ] [2026-01-13T10:43:27+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` = 89 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000297s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001025s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000907s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001020s ] [2026-01-13T10:43:27+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000398s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001112s ] [2026-01-13T10:43:27+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000446s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001094s ] [2026-01-13T10:43:27+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30227,30147,30013,30034,30068,30005,30192,98015,30195,30250,30092,30010,30045,98009,30146,30204,30203,30206,30069,30229,30048,30201,30191,30024,98003,30228,30080,30041,30088,98013,30009,98011,30207,30006,30081,98007,30211,30223,30212,30033) [ RunTime:0.029105s ] [2026-01-13T10:43:27+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81023,88023,89023,91023,92023,7230,90008,23155,22156,40155,42049,120059,31168,88002,89002,91002,92002,47017,90002,23243,22025,40247,42194,120123,31020,32020,33020,35020,36020,54086,84057,42031,7202,7211) [ RunTime:0.039718s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001148s ] [2026-01-13T10:43:27+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.001921s ] [2026-01-13T10:43:27+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (7202,7211,7230,88023,34096,43012,25021,25024,25027,25039,94014,94017,25068,25070,127019,127020,127022,127023,127025,127026,127027,127029,44089,44090,44091,127032,25163,25164,25165,25182,25183,25184,127067,127068,127069,127070,127102,127186,127187,127188,127190,127201,30003,30004,30011,30024,30025,30031,30038,30046,30054,30192,30195,30196,30199,30200,30201,30204,30206,30207,30211,30215,30216,30224,95001,95006,95011,95012,128001,129001,128002,100008,100009,129008,129015,101022,100045,100046,100061,100062,100092,100098,100101,100104,100107,100117,100131,100167,100169,100175,100176,118153,118154,101190,101191,101195,101197,101206,101208,100221,100225,100232,100234,101233,101234,100252,100254,177223,120128,128011,120126,38146,127211,128010,28147,101196,101139,177045,177222,177042,177043,28152,42019,101127,100144,101146,127254,128081,103055,101155,101138,28122,127103,127075,28146,38244,118155,119005,119004,103238,102107,120082,120051,120084,120013,120081,99202,151007,42007,42015,42142,42011,152001,153001,151001,154001,155001,7046) [ RunTime:0.040110s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001373s ] [2026-01-13T10:43:27+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000368s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000965s ] [2026-01-13T10:43:27+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000288s ] [2026-01-13T10:43:27+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 157 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000247s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000834s ] [2026-01-13T10:43:27+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 157 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000261s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000858s ] [2026-01-13T10:43:27+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000279s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000817s ] [2026-01-13T10:43:27+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (15,31,51,115,131,201,231,249,255) [ RunTime:0.000379s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000811s ] [2026-01-13T10:43:27+08:00][sql] SELECT `attr_tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000446s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001226s ] [2026-01-13T10:43:27+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (8,19,10,68,199,97,47,70,9,18,36,69,172,49,208,170,57,173,37,20,67,39,59,96,110,159,150,108,147,160,109,400,420,450,410,440,460,280,330,310,260,340,290,369,220,300,10127,10128,230,10146) [ RunTime:0.001239s ] [2026-01-13T10:43:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001019s ] [2026-01-13T11:39:26+08:00][sql] CONNECT:[ UseTime:0.001441s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001268s ] [2026-01-13T11:39:26+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000392s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001183s ] [2026-01-13T11:39:26+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` = 89 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000306s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001090s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000980s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001074s ] [2026-01-13T11:39:26+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000330s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001153s ] [2026-01-13T11:39:26+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000450s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001156s ] [2026-01-13T11:39:26+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30227,30147,30013,30034,30068,30005,30192,98015,30195,30250,30092,30010,30045,98009,30146,30204,30203,30206,30069,30229,30048,30201,30191,30024,98003,30228,30080,30041,30088,98013,30009,98011,30207,30006,30081,98007,30211,30223,30212,30033) [ RunTime:0.029742s ] [2026-01-13T11:39:26+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81023,88023,89023,91023,92023,7230,90008,23155,22156,40155,42049,120059,31168,88002,89002,91002,92002,47017,90002,23243,22025,40247,42194,120123,31020,32020,33020,35020,36020,54086,84057,42031,7202,7211) [ RunTime:0.041089s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001127s ] [2026-01-13T11:39:26+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.002040s ] [2026-01-13T11:39:26+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (7202,7211,7230,88023,34096,43012,25021,25024,25027,25039,94014,94017,25068,25070,127019,127020,127022,127023,127025,127026,127027,127029,44089,44090,44091,127032,25163,25164,25165,25182,25183,25184,127067,127068,127069,127070,127102,127186,127187,127188,127190,127201,30003,30004,30011,30024,30025,30031,30038,30046,30054,30192,30195,30196,30199,30200,30201,30204,30206,30207,30211,30215,30216,30224,95001,95006,95011,95012,128001,129001,128002,100008,100009,129008,129015,101022,100045,100046,100061,100062,100092,100098,100101,100104,100107,100117,100131,100167,100169,100175,100176,118153,118154,101190,101191,101195,101197,101206,101208,100221,100225,100232,100234,101233,101234,100252,100254,177223,120128,128011,120126,38146,127211,128010,28147,101196,101139,177045,177222,177042,177043,28152,42019,101127,100144,101146,127254,128081,103055,101155,101138,28122,127103,127075,28146,38244,118155,119005,119004,103238,102107,120082,120051,120084,120013,120081,99202,151007,42007,42015,42142,42011,152001,153001,151001,154001,155001,7046) [ RunTime:0.042199s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001391s ] [2026-01-13T11:39:26+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000367s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001015s ] [2026-01-13T11:39:26+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000320s ] [2026-01-13T11:39:26+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 157 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000245s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000871s ] [2026-01-13T11:39:26+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 157 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000272s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000931s ] [2026-01-13T11:39:26+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000312s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000885s ] [2026-01-13T11:39:26+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (15,31,51,115,131,201,231,249,255) [ RunTime:0.000401s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000908s ] [2026-01-13T11:39:26+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 GROUP BY `attr_tanent_id` [ RunTime:0.000511s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001078s ] [2026-01-13T11:39:26+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (8,19,10,68,199,97,47,70,9,18,36,69,172,49,208,170,57,173,37,20,67,39,59,96,110,159,150,108,147,160,109,400,420,450,410,440,460,280,330,310,260,340,290,369,220,300,10127,10128,230,10146) [ RunTime:0.001040s ] [2026-01-13T11:39:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000942s ] [2026-01-13T13:46:05+08:00][sql] CONNECT:[ UseTime:0.001490s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T13:46:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001394s ] [2026-01-13T13:46: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.000447s ] [2026-01-13T13:46:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001105s ] [2026-01-13T13:46:05+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000202s ] [2026-01-13T14:55:22+08:00][sql] CONNECT:[ UseTime:0.011102s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001231s ] [2026-01-13T14:55:22+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000380s ] [2026-01-13T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001144s ] [2026-01-13T14:55:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-13 14:50:22' LIMIT 1 [ RunTime:0.000404s ] [2026-01-13T14:55:22+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` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-13 14:50:22' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000416s ] [2026-01-13T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000921s ] [2026-01-13T14:55:22+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 GROUP BY `tid` [ RunTime:0.000279s ] [2026-01-13T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000941s ] [2026-01-13T14:55:22+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 158 [ RunTime:0.000233s ] [2026-01-13T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001000s ] [2026-01-13T14:55:25+08:00][sql] CONNECT:[ UseTime:0.001425s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001245s ] [2026-01-13T14:55:25+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000394s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001127s ] [2026-01-13T14:55:25+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` = 90 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000362s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001008s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000926s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001017s ] [2026-01-13T14:55:25+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.000329s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001101s ] [2026-01-13T14:55:25+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.000430s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001118s ] [2026-01-13T14:55:25+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30232,30006,30048,30005,98013,30045,30030,30038,30031,98012,30223,30204,30207,30086,30080,30032,30013,98018,30010,30003,98002,98007,30203,30206,30079,30085,30229,30034,30041,30040,30192,30044,30078,98003,30226,30227,30012,30228,30033,30201,98015,30047) [ RunTime:0.029524s ] [2026-01-13T14:55:25+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (87027,88025,89025,91025,92025,13109,23155,22156,40155,42195,120059,31085,32090,33090,35095,36090,63018,23243,22025,40247,42142,31103,32105,33105,35105,36105,63086,42063,13217,13107,13233,59088) [ RunTime:0.041446s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001049s ] [2026-01-13T14:55:25+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.002211s ] [2026-01-13T14:55:25+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (13217,13107,13233,59088,11093,11024,25164,25165,25027,127031,25163,127022,25021,127019,127020,127069,127021,127023,127025,127026,127027,25024,101203,94014,120051,100169,100175,100221,5110,100254,177222,127024,25029,127105,100101,100104,118153,118154,118155,128010,128002,95001,95011,44089,100107,95006,95012,101196,101190,101127,119004,119005,101109,101223,100167,101107,101108,101222,100131,44090,44091,100045,100046,44026,100008,101191,101197,25182,25183,25184,127185,127187,127188,127186,100061,101233,100095,100098,100092,100176,100062,101234,32238,33238,35238,36238,13241,40006,22007,177044,128011,16168,101206,101210,101211,101209,100185,177043,177042,78225,17081,18072,20072,21073,23006,101029,100225,102128,17072,18066,20066,21067,100252,100143,151007,101195,101138,38244,100224,128081,120082,120126,120133,120127,120136,120123,120128,120130,120084,120095,120147,120142,42063,42194,42049,102113,119097,151015,177045,127103,99202,101146,131201,127075,28147,127104,38146,127211,151001,62152,152001,153001,154001,155001,155014,32090,152012,153014,151012,155012,154012,153012,151016,152014,154014) [ RunTime:0.042180s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001391s ] [2026-01-13T14:55:25+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.000339s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001050s ] [2026-01-13T14:55:25+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.000306s ] [2026-01-13T14:55:25+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 158 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000235s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000899s ] [2026-01-13T14:55:25+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 158 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000264s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000950s ] [2026-01-13T14:55:25+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.000279s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000871s ] [2026-01-13T14:55:25+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (217,231,249,263) [ RunTime:0.000308s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000877s ] [2026-01-13T14:55:25+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 GROUP BY `attr_tanent_id` [ RunTime:0.000580s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001117s ] [2026-01-13T14:55:25+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (6,1,59,68,58,94,54,205,9,178,47,18,207,36,70,48,60,96,169,93,46,52,62,98,10,69,167,57,65,7,168,114,160,150,119,120,118,158,400,420,450,410,440,460,280,330,310,350,290,220,300,230) [ RunTime:0.001223s ] [2026-01-13T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000962s ] [2026-01-13T15:26:09+08:00][sql] CONNECT:[ UseTime:0.011095s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:26:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001360s ] [2026-01-13T15:26:09+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000377s ] [2026-01-13T15:26:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001193s ] [2026-01-13T15:26:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-13 15:21:09' LIMIT 1 [ RunTime:0.000411s ] [2026-01-13T15:26:09+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` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-13 15:21:09' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000447s ] [2026-01-13T15:26:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000953s ] [2026-01-13T15:26:09+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 GROUP BY `tid` [ RunTime:0.000304s ] [2026-01-13T15:26:09+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000932s ] [2026-01-13T15:26:09+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 159 [ RunTime:0.000237s ] [2026-01-13T15:26:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001024s ] [2026-01-13T15:26:11+08:00][sql] CONNECT:[ UseTime:0.010973s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001349s ] [2026-01-13T15:26:11+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000389s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001226s ] [2026-01-13T15:26: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` = 91 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000329s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001109s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001072s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001208s ] [2026-01-13T15:26: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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000333s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001199s ] [2026-01-13T15:26: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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000440s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001598s ] [2026-01-13T15:26:11+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30224,30215,30027,30020,30019,30067,98016,98015,30024,30045,30010,98011,30220,30011,30048,30148,30041,98018,30023,30092,98005,30231,30093,30025,30230,30013,30081,30196,30197,30009,30229,30040,30088,98017,30046,30216,30047,30198,30044,30232,30218) [ RunTime:0.030177s ] [2026-01-13T15:26: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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81027,88027,89027,91027,92027,12133,23155,22156,40155,42194,120059,31172,32175,33175,35180,36175,58018,23243,22025,40247,42120,120126,31188,88013,89013,91013,92013,58089,42063,120133) [ RunTime:0.040394s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001059s ] [2026-01-13T15:26:11+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.002245s ] [2026-01-13T15:26: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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (25027,127026,25021,127020,127019,127031,127030,127029,127032,127070,25070,25024,127024,127022,25163,25165,25164,127069,127071,25068,12181,12136,100253,94017,94014,127067,118154,100169,100052,25039,41244,127068,100252,177255,177223,100008,128002,177222,100107,79032,129001,129008,129015,129022,129029,100167,100131,101107,101108,101109,101222,177045,177051,100254,100046,100175,100104,100101,100045,44026,127210,127105,128010,127104,95001,95012,127102,101127,127211,95006,95011,100095,100098,100092,25182,127189,100063,100176,44089,101197,25183,127188,101233,44091,101190,25184,127186,101234,44090,101191,127190,100062,101196,127023,128009,177042,177043,131201,101138,100232,41126,101195,130113,38146,101155,100144,119097,128081,100234,100207,101146,100049,100221,101022,120148,101092,127254,42142,38244,118155,120142,151015,120130,120128,120136,120147,42063,102129,28147,103055,42024,43024,42051,127103,42005,12241,23006,22007,40006,119004,119005,21240,20240,18240,17240,16168,152001,12002,154001,151001,155001,153001,58180,32196,33160,32191,32162,33162,12066,151017,33161) [ RunTime:0.041348s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001393s ] [2026-01-13T15:26: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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000352s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001141s ] [2026-01-13T15:26:11+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000315s ] [2026-01-13T15:26:11+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000238s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000922s ] [2026-01-13T15:26:11+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000264s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000938s ] [2026-01-13T15:26:11+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000296s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000868s ] [2026-01-13T15:26:11+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (206,234,242,270) [ RunTime:0.000316s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000912s ] [2026-01-13T15:26:11+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 GROUP BY `attr_tanent_id` [ RunTime:0.000571s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001094s ] [2026-01-13T15:26:11+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (18,29,39,68,28,38,69,205,185,67,41,70,203,86,17,37,30,88,188,169,87,58,155,150,129,128,130,158,157,156,400,429,449,410,439,460,280,319,310,360,290,369,10488,219,300,379,230) [ RunTime:0.000987s ] [2026-01-13T15:26:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000958s ] [2026-01-13T15:31:20+08:00][sql] CONNECT:[ UseTime:0.001450s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:31:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001261s ] [2026-01-13T15:31:20+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.000405s ] [2026-01-13T15:31:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000967s ] [2026-01-13T15:31:20+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000201s ] [2026-01-13T15:31:23+08:00][sql] CONNECT:[ UseTime:0.001356s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:31:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001266s ] [2026-01-13T15:31:23+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.000430s ] [2026-01-13T15:31:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000982s ] [2026-01-13T15:31:23+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '5049a55a206d441ab03568ce2b48bcc4' AND `status` = 1 LIMIT 1 [ RunTime:0.000275s ] [2026-01-13T15:31:23+08:00][sql] CONNECT:[ UseTime:0.011384s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:31:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001126s ] [2026-01-13T15:31:23+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000400s ] [2026-01-13T15:31:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001157s ] [2026-01-13T15:31:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-13 14:26:23' AND '2026-01-13 15:26:23' AND `specuser` = '' LIMIT 1 [ RunTime:0.000413s ] [2026-01-13T15:31:23+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` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-13 14:26:23' AND '2026-01-13 15:26:23' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000449s ] [2026-01-13T15:31:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000932s ] [2026-01-13T15:31:23+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` IN (159,158) GROUP BY `tid` [ RunTime:0.000338s ] [2026-01-13T15:31:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000910s ] [2026-01-13T15:31:23+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (159,158) [ RunTime:0.000240s ] [2026-01-13T15:31:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001067s ] [2026-01-13T15:31:26+08:00][sql] CONNECT:[ UseTime:0.011138s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001409s ] [2026-01-13T15:31:26+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000420s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001355s ] [2026-01-13T15:31:26+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` = 91 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000318s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001164s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001082s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001176s ] [2026-01-13T15:31:26+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000421s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001239s ] [2026-01-13T15:31:26+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000437s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001268s ] [2026-01-13T15:31:26+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30224,30215,30027,30020,30019,30067,98016,98015,30024,30045,30010,98011,30220,30011,30048,30148,30041,98018,30023,30092,98005,30231,30093,30025,30230,30013,30081,30196,30197,30009,30229,30040,30088,98017,30046,30216,30047,30198,30044,30232,30218) [ RunTime:0.032239s ] [2026-01-13T15:31:26+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81027,88027,89027,91027,92027,12133,23155,22156,40155,42194,120059,31172,32175,33175,35180,36175,58018,23243,22025,40247,42120,120126,31188,88013,89013,91013,92013,58089,42063,120133) [ RunTime:0.043961s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001193s ] [2026-01-13T15:31:26+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.002213s ] [2026-01-13T15:31:26+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (25027,127026,25021,127020,127019,127031,127030,127029,127032,127070,25070,25024,127024,127022,25163,25165,25164,127069,127071,25068,12181,12136,100253,94017,94014,127067,118154,100169,100052,25039,41244,127068,100252,177255,177223,100008,128002,177222,100107,79032,129001,129008,129015,129022,129029,100167,100131,101107,101108,101109,101222,177045,177051,100254,100046,100175,100104,100101,100045,44026,127210,127105,128010,127104,95001,95012,127102,101127,127211,95006,95011,100095,100098,100092,25182,127189,100063,100176,44089,101197,25183,127188,101233,44091,101190,25184,127186,101234,44090,101191,127190,100062,101196,127023,128009,177042,177043,131201,101138,100232,41126,101195,130113,38146,101155,100144,119097,128081,100234,100207,101146,100049,100221,101022,120148,101092,127254,42142,38244,118155,120142,151015,120130,120128,120136,120147,42063,102129,28147,103055,42024,43024,42051,127103,42005,12241,23006,22007,40006,119004,119005,21240,20240,18240,17240,16168,152001,12002,154001,151001,155001,153001,58180,32196,33160,32191,32162,33162,12066,151017,33161) [ RunTime:0.042257s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001409s ] [2026-01-13T15:31:26+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000402s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001075s ] [2026-01-13T15:31:26+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000355s ] [2026-01-13T15:31:26+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000232s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000867s ] [2026-01-13T15:31:26+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000278s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000981s ] [2026-01-13T15:31:26+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000301s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000880s ] [2026-01-13T15:31:26+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (206,234,242,270) [ RunTime:0.000407s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000955s ] [2026-01-13T15:31:26+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 GROUP BY `attr_tanent_id` [ RunTime:0.000555s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001147s ] [2026-01-13T15:31:26+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (18,29,39,68,28,38,69,205,185,67,41,70,203,86,17,37,30,88,188,169,87,58,155,150,129,128,130,158,157,156,400,429,449,410,439,460,280,319,310,360,290,369,10488,219,300,379,230) [ RunTime:0.001189s ] [2026-01-13T15:31:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000994s ] [2026-01-13T15:31:38+08:00][sql] CONNECT:[ UseTime:0.011531s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001476s ] [2026-01-13T15:31:38+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000373s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001281s ] [2026-01-13T15:31:38+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` = 90 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000376s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001126s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001117s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001146s ] [2026-01-13T15:31:38+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.000340s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001221s ] [2026-01-13T15:31:38+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.000446s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001231s ] [2026-01-13T15:31:38+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30232,30006,30048,30005,98013,30045,30030,30038,30031,98012,30223,30204,30207,30086,30080,30032,30013,98018,30010,30003,98002,98007,30203,30206,30079,30085,30229,30034,30041,30040,30192,30044,30078,98003,30226,30227,30012,30228,30033,30201,98015,30047) [ RunTime:0.030742s ] [2026-01-13T15:31:38+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (87027,88025,89025,91025,92025,13109,23155,22156,40155,42195,120059,31085,32090,33090,35095,36090,63018,23243,22025,40247,42142,31103,32105,33105,35105,36105,63086,42063,13217,13107,13233,59088) [ RunTime:0.042206s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001283s ] [2026-01-13T15:31:38+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.002075s ] [2026-01-13T15:31:38+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (13217,13107,13233,59088,11093,11024,25164,25165,25027,127031,25163,127022,25021,127019,127020,127069,127021,127023,127025,127026,127027,25024,101203,94014,120051,100169,100175,100221,5110,100254,177222,127024,25029,127105,100101,100104,118153,118154,118155,128010,128002,95001,95011,44089,100107,95006,95012,101196,101190,101127,119004,119005,101109,101223,100167,101107,101108,101222,100131,44090,44091,100045,100046,44026,100008,101191,101197,25182,25183,25184,127185,127187,127188,127186,100061,101233,100095,100098,100092,100176,100062,101234,32238,33238,35238,36238,13241,40006,22007,177044,128011,16168,101206,101210,101211,101209,100185,177043,177042,78225,17081,18072,20072,21073,23006,101029,100225,102128,17072,18066,20066,21067,100252,100143,151007,101195,101138,38244,100224,128081,120082,120126,120133,120127,120136,120123,120128,120130,120084,120095,120147,120142,42063,42194,42049,102113,119097,151015,177045,127103,99202,101146,131201,127075,28147,127104,38146,127211,151001,62152,152001,153001,154001,155001,155014,32090,152012,153014,151012,155012,154012,153012,151016,152014,154014) [ RunTime:0.042459s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001440s ] [2026-01-13T15:31:38+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.000348s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001087s ] [2026-01-13T15:31:38+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.000306s ] [2026-01-13T15:31:38+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 158 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000239s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000943s ] [2026-01-13T15:31:38+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 158 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000257s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000977s ] [2026-01-13T15:31:38+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 [ RunTime:0.000276s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000861s ] [2026-01-13T15:31:38+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (217,231,249,263) [ RunTime:0.000393s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000974s ] [2026-01-13T15:31:38+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 158 GROUP BY `attr_tanent_id` [ RunTime:0.000522s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001152s ] [2026-01-13T15:31:38+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (6,1,59,68,58,94,54,205,9,178,47,18,207,36,70,48,60,96,169,93,46,52,62,98,10,69,167,57,65,7,168,114,160,150,119,120,118,158,400,420,450,410,440,460,280,330,310,350,290,220,300,230) [ RunTime:0.001068s ] [2026-01-13T15:31:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000999s ] [2026-01-13T15:33:42+08:00][sql] CONNECT:[ UseTime:0.011242s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001338s ] [2026-01-13T15:33:42+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000459s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001253s ] [2026-01-13T15:33:42+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` = 91 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000369s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001125s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000991s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001125s ] [2026-01-13T15:33:42+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000350s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001193s ] [2026-01-13T15:33:42+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000443s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001214s ] [2026-01-13T15:33:42+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30224,30215,30027,30020,30019,30067,98016,98015,30024,30045,30010,98011,30220,30011,30048,30148,30041,98018,30023,30092,98005,30231,30093,30025,30230,30013,30081,30196,30197,30009,30229,30040,30088,98017,30046,30216,30047,30198,30044,30232,30218) [ RunTime:0.030367s ] [2026-01-13T15:33:42+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81027,88027,89027,91027,92027,12133,23155,22156,40155,42194,120059,31172,32175,33175,35180,36175,58018,23243,22025,40247,42120,120126,31188,88013,89013,91013,92013,58089,42063,120133) [ RunTime:0.041047s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001117s ] [2026-01-13T15:33:42+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.002086s ] [2026-01-13T15:33:42+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (25027,127026,25021,127020,127019,127031,127030,127029,127032,127070,25070,25024,127024,127022,25163,25165,25164,127069,127071,25068,12181,12136,100253,94017,94014,127067,118154,100169,100052,25039,41244,127068,100252,177255,177223,100008,128002,177222,100107,79032,129001,129008,129015,129022,129029,100167,100131,101107,101108,101109,101222,177045,177051,100254,100046,100175,100104,100101,100045,44026,127210,127105,128010,127104,95001,95012,127102,101127,127211,95006,95011,100095,100098,100092,25182,127189,100063,100176,44089,101197,25183,127188,101233,44091,101190,25184,127186,101234,44090,101191,127190,100062,101196,127023,128009,177042,177043,131201,101138,100232,41126,101195,130113,38146,101155,100144,119097,128081,100234,100207,101146,100049,100221,101022,120148,101092,127254,42142,38244,118155,120142,151015,120130,120128,120136,120147,42063,102129,28147,103055,42024,43024,42051,127103,42005,12241,23006,22007,40006,119004,119005,21240,20240,18240,17240,16168,152001,12002,154001,151001,155001,153001,58180,32196,33160,32191,32162,33162,12066,151017,33161) [ RunTime:0.041664s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001347s ] [2026-01-13T15:33:42+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000346s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001046s ] [2026-01-13T15:33:42+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000305s ] [2026-01-13T15:33:42+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000239s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000971s ] [2026-01-13T15:33:42+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000301s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000947s ] [2026-01-13T15:33:42+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000298s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000895s ] [2026-01-13T15:33:42+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (206,234,242,270) [ RunTime:0.000309s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000902s ] [2026-01-13T15:33:42+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 GROUP BY `attr_tanent_id` [ RunTime:0.000567s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001142s ] [2026-01-13T15:33:42+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (18,29,39,68,28,38,69,205,185,67,41,70,203,86,17,37,30,88,188,169,87,58,155,150,129,128,130,158,157,156,400,429,449,410,439,460,280,319,310,360,290,369,10488,219,300,379,230) [ RunTime:0.001011s ] [2026-01-13T15:33:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000987s ] [2026-01-13T15:33:58+08:00][sql] CONNECT:[ UseTime:0.010720s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:33:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001283s ] [2026-01-13T15:33:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000375s ] [2026-01-13T15:33:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001098s ] [2026-01-13T15:33:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-13 15:28:58' LIMIT 1 [ RunTime:0.000398s ] [2026-01-13T15:33:59+08:00][sql] CONNECT:[ UseTime:0.011147s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:33:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001439s ] [2026-01-13T15:33:59+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000476s ] [2026-01-13T15:33:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001271s ] [2026-01-13T15:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-13 14:28:59' AND '2026-01-13 15:28:59' AND `specuser` = '' LIMIT 1 [ RunTime:0.000441s ] [2026-01-13T15:33:59+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` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-13 14:28:59' AND '2026-01-13 15:28:59' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000495s ] [2026-01-13T15:33:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001057s ] [2026-01-13T15:33:59+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` IN (159,158) GROUP BY `tid` [ RunTime:0.000330s ] [2026-01-13T15:33:59+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001060s ] [2026-01-13T15:33:59+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (159,158) [ RunTime:0.000244s ] [2026-01-13T15:33:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001124s ] [2026-01-13T15:34:03+08:00][sql] CONNECT:[ UseTime:0.010931s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001448s ] [2026-01-13T15:34:03+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000428s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001283s ] [2026-01-13T15:34:03+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` = 91 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000337s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001188s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001098s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001202s ] [2026-01-13T15:34:03+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000398s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001263s ] [2026-01-13T15:34:03+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000482s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001251s ] [2026-01-13T15:34:03+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30224,30215,30027,30020,30019,30067,98016,98015,30024,30045,30010,98011,30220,30011,30048,30148,30041,98018,30023,30092,98005,30231,30093,30025,30230,30013,30081,30196,30197,30009,30229,30040,30088,98017,30046,30216,30047,30198,30044,30232,30218) [ RunTime:0.032380s ] [2026-01-13T15:34:03+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81027,88027,89027,91027,92027,12133,23155,22156,40155,42194,120059,31172,32175,33175,35180,36175,58018,23243,22025,40247,42120,120126,31188,88013,89013,91013,92013,58089,42063,120133) [ RunTime:0.043747s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001257s ] [2026-01-13T15:34:03+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.002242s ] [2026-01-13T15:34:03+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (25027,127026,25021,127020,127019,127031,127030,127029,127032,127070,25070,25024,127024,127022,25163,25165,25164,127069,127071,25068,12181,12136,100253,94017,94014,127067,118154,100169,100052,25039,41244,127068,100252,177255,177223,100008,128002,177222,100107,79032,129001,129008,129015,129022,129029,100167,100131,101107,101108,101109,101222,177045,177051,100254,100046,100175,100104,100101,100045,44026,127210,127105,128010,127104,95001,95012,127102,101127,127211,95006,95011,100095,100098,100092,25182,127189,100063,100176,44089,101197,25183,127188,101233,44091,101190,25184,127186,101234,44090,101191,127190,100062,101196,127023,128009,177042,177043,131201,101138,100232,41126,101195,130113,38146,101155,100144,119097,128081,100234,100207,101146,100049,100221,101022,120148,101092,127254,42142,38244,118155,120142,151015,120130,120128,120136,120147,42063,102129,28147,103055,42024,43024,42051,127103,42005,12241,23006,22007,40006,119004,119005,21240,20240,18240,17240,16168,152001,12002,154001,151001,155001,153001,58180,32196,33160,32191,32162,33162,12066,151017,33161) [ RunTime:0.044982s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001576s ] [2026-01-13T15:34:03+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000445s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001112s ] [2026-01-13T15:34:03+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000373s ] [2026-01-13T15:34:03+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000237s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000869s ] [2026-01-13T15:34:03+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000366s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000969s ] [2026-01-13T15:34:03+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000384s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000941s ] [2026-01-13T15:34:03+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (206,234,242,270) [ RunTime:0.000370s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000948s ] [2026-01-13T15:34:03+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 GROUP BY `attr_tanent_id` [ RunTime:0.000542s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001185s ] [2026-01-13T15:34:03+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (18,29,39,68,28,38,69,205,185,67,41,70,203,86,17,37,30,88,188,169,87,58,155,150,129,128,130,158,157,156,400,429,449,410,439,460,280,319,310,360,290,369,10488,219,300,379,230) [ RunTime:0.001276s ] [2026-01-13T15:34:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001030s ] [2026-01-13T15:34:07+08:00][sql] CONNECT:[ UseTime:0.011422s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001364s ] [2026-01-13T15:34:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000409s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001201s ] [2026-01-13T15:34:07+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` = 88 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000330s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001136s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001027s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001114s ] [2026-01-13T15:34:07+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000356s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001293s ] [2026-01-13T15:34:07+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000471s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001192s ] [2026-01-13T15:34:07+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30211,30094,30026,30048,30012,98011,30024,30010,98005,30092,98009,30222,30046,30011,30025,30212,30027,30045,30219,30093,30229,30095,30013,30023,30098,30231,98003) [ RunTime:0.030446s ] [2026-01-13T15:34:07+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (72047,73027,74027,76027,77027,12177,23155,22156,40155,42049,120123,16172,73006,74006,76006,77006,58017,23243,22025,40247,16188,73013,74013,76013,77013,60089) [ RunTime:0.041279s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001067s ] [2026-01-13T15:34:07+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.001748s ] [2026-01-13T15:34:07+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (94014,30012,30210,30033,166001,166106,30207,30019,30004,30040,166155,98005,100101,100061,95012,177223,177222,127103,127104,177016,177006,127101,127201,177026,177036,127210,127211,131202,127102,127254,38244,177051,118153,118154,118155,127068,127069,127030,127070,101190,100176,100062,100095,100107,127186,127190,101233,100104,127020,25163,127019,25182,127023,127026,127022,25164,127025,127038,25165,101104,101105,101106,101217,128002,100131,100254,100046,100045,100167,101206,100081,100221,127027,127039,127024,127021,100144,127029,127032,28146,43012,28151,101022,128081,103055,101195,151007,119005,119004,101146,100175,101155,128010,103232,100172,95011,42194,28147,120127,151001,152001,153001,154001,155001,177042,177041,177043,120051,42063,42142,177045,101139,99202,119097,100252,127074,127075,12003,12005,12241,12014,12019,16168,40006,17058,17067,17076,17082,17240,23006,18061,18064,18070,18073,18240,22007,20061,20064,20070,20073,20240,21062,21065,21071,21074,21240,20205,17216,21205,18205) [ RunTime:0.041727s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001307s ] [2026-01-13T15:34:07+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000348s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001066s ] [2026-01-13T15:34:07+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000331s ] [2026-01-13T15:34:07+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000279s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000925s ] [2026-01-13T15:34:07+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000262s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000968s ] [2026-01-13T15:34:07+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000283s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000932s ] [2026-01-13T15:34:07+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (18,33,51,118,133,151,218,233,251) [ RunTime:0.000522s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000941s ] [2026-01-13T15:34:07+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 GROUP BY `attr_tanent_id` [ RunTime:0.000548s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001172s ] [2026-01-13T15:34:07+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (19,39,38,70,199,69,201,20,183,25,186,23,165,206,84,24,169,53,40,18,181,168,68,28,170,55,17,161,159,150,121,122,149,140,160,123,127,125,142,399,430,449,410,440,459,280,320,310,260,290,370,10488,10493,380) [ RunTime:0.001196s ] [2026-01-13T15:34:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000987s ] [2026-01-13T17:10:44+08:00][sql] CONNECT:[ UseTime:0.001545s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T17:10:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001322s ] [2026-01-13T17:10: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.000411s ] [2026-01-13T17:10:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001030s ] [2026-01-13T17:10:44+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000216s ] [2026-01-13T17:53:38+08:00][sql] CONNECT:[ UseTime:0.001456s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T17:53:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001263s ] [2026-01-13T17:53:38+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 ] [2026-01-13T17:53:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000990s ] [2026-01-13T17:53:38+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000202s ] [2026-01-13T17:55:04+08:00][sql] CONNECT:[ UseTime:0.010878s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T17:55:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001457s ] [2026-01-13T17:55:04+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000432s ] [2026-01-13T17:55:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001042s ] [2026-01-13T17:55:04+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000219s ] [2026-01-13T17:55:07+08:00][sql] CONNECT:[ UseTime:0.001568s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T17:55:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001491s ] [2026-01-13T17: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.000397s ] [2026-01-13T17:55:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001056s ] [2026-01-13T17:55:07+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '5049a55a206d441ab03568ce2b48bcc4' AND `status` = 1 LIMIT 1 [ RunTime:0.000374s ] [2026-01-13T17:55:07+08:00][sql] CONNECT:[ UseTime:0.011245s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T17:55:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001134s ] [2026-01-13T17:55:07+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000393s ] [2026-01-13T17:55:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001166s ] [2026-01-13T17:55:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-13 16:50:07' AND '2026-01-13 17:50:07' AND `specuser` = '' LIMIT 1 [ RunTime:0.000434s ] [2026-01-13T17:55:13+08:00][sql] CONNECT:[ UseTime:0.001372s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001262s ] [2026-01-13T17:55:13+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000397s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001144s ] [2026-01-13T17:55:13+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` = 88 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000330s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001255s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001120s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001147s ] [2026-01-13T17:55:13+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000370s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001257s ] [2026-01-13T17:55:13+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000460s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001257s ] [2026-01-13T17:55:13+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30211,30094,30026,30048,30012,98011,30024,30010,98005,30092,98009,30222,30046,30011,30025,30212,30027,30045,30219,30093,30229,30095,30013,30023,30098,30231,98003) [ RunTime:0.030451s ] [2026-01-13T17:55:13+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (72047,73027,74027,76027,77027,12177,23155,22156,40155,42049,120123,16172,73006,74006,76006,77006,58017,23243,22025,40247,16188,73013,74013,76013,77013,60089) [ RunTime:0.040994s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001063s ] [2026-01-13T17:55:13+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.001795s ] [2026-01-13T17:55:13+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (94014,30012,30210,30033,166001,166106,30207,30019,30004,30040,166155,98005,100101,100061,95012,177223,177222,127103,127104,177016,177006,127101,127201,177026,177036,127210,127211,131202,127102,127254,38244,177051,118153,118154,118155,127068,127069,127030,127070,101190,100176,100062,100095,100107,127186,127190,101233,100104,127020,25163,127019,25182,127023,127026,127022,25164,127025,127038,25165,101104,101105,101106,101217,128002,100131,100254,100046,100045,100167,101206,100081,100221,127027,127039,127024,127021,100144,127029,127032,28146,43012,28151,101022,128081,103055,101195,151007,119005,119004,101146,100175,101155,128010,103232,100172,95011,42194,28147,120127,151001,152001,153001,154001,155001,177042,177041,177043,120051,42063,42142,177045,101139,99202,119097,100252,127074,127075,12003,12005,12241,12014,12019,16168,40006,17058,17067,17076,17082,17240,23006,18061,18064,18070,18073,18240,22007,20061,20064,20070,20073,20240,21062,21065,21071,21074,21240,20205,17216,21205,18205) [ RunTime:0.041810s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001369s ] [2026-01-13T17:55:13+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000403s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001089s ] [2026-01-13T17:55:13+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000302s ] [2026-01-13T17:55:13+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000226s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000920s ] [2026-01-13T17:55:13+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000329s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000989s ] [2026-01-13T17:55:13+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000359s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000924s ] [2026-01-13T17:55:13+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (18,33,51,118,133,151,218,233,251) [ RunTime:0.000374s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000885s ] [2026-01-13T17:55:13+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 GROUP BY `attr_tanent_id` [ RunTime:0.000584s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001134s ] [2026-01-13T17:55:13+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (19,39,38,70,199,69,201,20,183,25,186,23,165,206,84,24,169,53,40,18,181,168,68,28,170,55,17,161,159,150,121,122,149,140,160,123,127,125,142,399,430,449,410,440,459,280,320,310,260,290,370,10488,10493,380) [ RunTime:0.001237s ] [2026-01-13T17:55:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000996s ] [2026-01-13T18:10:37+08:00][sql] CONNECT:[ UseTime:0.011347s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001246s ] [2026-01-13T18:10:37+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000379s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001237s ] [2026-01-13T18:10:37+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` = 91 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000318s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001038s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000975s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001012s ] [2026-01-13T18:10:37+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000337s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001095s ] [2026-01-13T18:10:37+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000562s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001130s ] [2026-01-13T18:10:37+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30224,30215,30027,30020,30019,30067,98016,98015,30024,30045,30010,98011,30220,30011,30048,30148,30041,98018,30023,30092,98005,30231,30093,30025,30230,30013,30081,30196,30197,30009,30229,30040,30088,98017,30046,30216,30047,30198,30044,30232,30218) [ RunTime:0.028751s ] [2026-01-13T18:10:37+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81027,88027,89027,91027,92027,12133,23155,22156,40155,42194,120059,31172,32175,33175,35180,36175,58018,23243,22025,40247,42120,120126,31188,88013,89013,91013,92013,58089,42063,120133) [ RunTime:0.039097s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001030s ] [2026-01-13T18:10:37+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.002006s ] [2026-01-13T18:10:37+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (25027,127026,25021,127020,127019,127031,127030,127029,127032,127070,25070,25024,127024,127022,25163,25165,25164,127069,127071,25068,12181,12136,100253,94017,94014,127067,118154,100169,100052,25039,41244,127068,100252,177255,177223,100008,128002,177222,100107,79032,129001,129008,129015,129022,129029,100167,100131,101107,101108,101109,101222,177045,177051,100254,100046,100175,100104,100101,100045,44026,127210,127105,128010,127104,95001,95012,127102,101127,127211,95006,95011,100095,100098,100092,25182,127189,100063,100176,44089,101197,25183,127188,101233,44091,101190,25184,127186,101234,44090,101191,127190,100062,101196,127023,128009,177042,177043,131201,101138,100232,41126,101195,130113,38146,101155,100144,119097,128081,100234,100207,101146,100049,100221,101022,120148,101092,127254,42142,38244,118155,120142,151015,120130,120128,120136,120147,42063,102129,28147,103055,42024,43024,42051,127103,42005,12241,23006,22007,40006,119004,119005,21240,20240,18240,17240,16168,152001,12002,154001,151001,155001,153001,58180,32196,33160,32191,32162,33162,12066,151017,33161) [ RunTime:0.039577s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001226s ] [2026-01-13T18:10:37+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000354s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001010s ] [2026-01-13T18:10:37+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000328s ] [2026-01-13T18:10:37+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000226s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000854s ] [2026-01-13T18:10:37+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000269s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000867s ] [2026-01-13T18:10:37+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000309s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000811s ] [2026-01-13T18:10:37+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (206,234,242,270) [ RunTime:0.000316s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000854s ] [2026-01-13T18:10:37+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 GROUP BY `attr_tanent_id` [ RunTime:0.000480s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001045s ] [2026-01-13T18:10:37+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (18,29,39,68,28,38,69,205,185,67,41,70,203,86,17,37,30,88,188,169,87,58,155,150,129,128,130,158,157,156,400,429,449,410,439,460,280,319,310,360,290,369,10488,219,300,379,230) [ RunTime:0.001002s ] [2026-01-13T18:10:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000902s ] [2026-01-13T18:10:51+08:00][sql] CONNECT:[ UseTime:0.011295s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001347s ] [2026-01-13T18:10:51+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000379s ] [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001194s ] [2026-01-13T18:10:51+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` = 92 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000289s ] [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001078s ] [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001217s ] [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000903s ] [2026-01-13T18:10:51+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 0 [ RunTime:0.000319s ] [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001070s ] [2026-01-13T18:10:51+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 0 [ RunTime:0.000338s ] [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000956s ] [2026-01-13T18:10:51+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 0 [ RunTime:0.000300s ] [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000901s ] [2026-01-13T18:10:51+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 0 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000233s ] [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000833s ] [2026-01-13T18:10:51+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 0 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000268s ] [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000922s ] [2026-01-13T18:10:51+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 0 [ RunTime:0.000266s ] [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000835s ] [2026-01-13T18:10:51+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 0 GROUP BY `attr_tanent_id` [ RunTime:0.000319s ] [2026-01-13T18:10:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000910s ] [2026-01-13T18:10:51+08:00][error] [2]Undefined array key "trade_status" [2026-01-13T18:10:54+08:00][sql] CONNECT:[ UseTime:0.001408s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001302s ] [2026-01-13T18:10:54+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000391s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001178s ] [2026-01-13T18:10:54+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` = 91 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000317s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001064s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000954s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001083s ] [2026-01-13T18:10:54+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000353s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001150s ] [2026-01-13T18:10:54+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000524s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001186s ] [2026-01-13T18:10:54+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30224,30215,30027,30020,30019,30067,98016,98015,30024,30045,30010,98011,30220,30011,30048,30148,30041,98018,30023,30092,98005,30231,30093,30025,30230,30013,30081,30196,30197,30009,30229,30040,30088,98017,30046,30216,30047,30198,30044,30232,30218) [ RunTime:0.029701s ] [2026-01-13T18:10:54+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81027,88027,89027,91027,92027,12133,23155,22156,40155,42194,120059,31172,32175,33175,35180,36175,58018,23243,22025,40247,42120,120126,31188,88013,89013,91013,92013,58089,42063,120133) [ RunTime:0.039983s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001089s ] [2026-01-13T18:10:54+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.002065s ] [2026-01-13T18:10:54+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (25027,127026,25021,127020,127019,127031,127030,127029,127032,127070,25070,25024,127024,127022,25163,25165,25164,127069,127071,25068,12181,12136,100253,94017,94014,127067,118154,100169,100052,25039,41244,127068,100252,177255,177223,100008,128002,177222,100107,79032,129001,129008,129015,129022,129029,100167,100131,101107,101108,101109,101222,177045,177051,100254,100046,100175,100104,100101,100045,44026,127210,127105,128010,127104,95001,95012,127102,101127,127211,95006,95011,100095,100098,100092,25182,127189,100063,100176,44089,101197,25183,127188,101233,44091,101190,25184,127186,101234,44090,101191,127190,100062,101196,127023,128009,177042,177043,131201,101138,100232,41126,101195,130113,38146,101155,100144,119097,128081,100234,100207,101146,100049,100221,101022,120148,101092,127254,42142,38244,118155,120142,151015,120130,120128,120136,120147,42063,102129,28147,103055,42024,43024,42051,127103,42005,12241,23006,22007,40006,119004,119005,21240,20240,18240,17240,16168,152001,12002,154001,151001,155001,153001,58180,32196,33160,32191,32162,33162,12066,151017,33161) [ RunTime:0.041364s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001354s ] [2026-01-13T18:10:54+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000338s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001037s ] [2026-01-13T18:10:54+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000317s ] [2026-01-13T18:10:54+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000224s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000854s ] [2026-01-13T18:10:54+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000290s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000919s ] [2026-01-13T18:10:54+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000302s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000833s ] [2026-01-13T18:10:54+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (206,234,242,270) [ RunTime:0.000336s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000851s ] [2026-01-13T18:10:54+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 GROUP BY `attr_tanent_id` [ RunTime:0.000512s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001084s ] [2026-01-13T18:10:54+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (18,29,39,68,28,38,69,205,185,67,41,70,203,86,17,37,30,88,188,169,87,58,155,150,129,128,130,158,157,156,400,429,449,410,439,460,280,319,310,360,290,369,10488,219,300,379,230) [ RunTime:0.000975s ] [2026-01-13T18:10:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000948s ] [2026-01-13T18:12:01+08:00][sql] CONNECT:[ UseTime:0.011044s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:12:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001316s ] [2026-01-13T18:12: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.000399s ] [2026-01-13T18:12:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001013s ] [2026-01-13T18:12:01+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000233s ] [2026-01-13T18:28:07+08:00][sql] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:28:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001302s ] [2026-01-13T18:28: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.000468s ] [2026-01-13T18:28:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001049s ] [2026-01-13T18:28:07+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000226s ] [2026-01-13T18:28:09+08:00][sql] CONNECT:[ UseTime:0.001584s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:28:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001291s ] [2026-01-13T18:28: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.000418s ] [2026-01-13T18:28:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001022s ] [2026-01-13T18:28:09+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '5049a55a206d441ab03568ce2b48bcc4' AND `status` = 1 LIMIT 1 [ RunTime:0.000298s ] [2026-01-13T18:28:09+08:00][sql] CONNECT:[ UseTime:0.011238s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:28:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001282s ] [2026-01-13T18:28:09+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000448s ] [2026-01-13T18:28:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001348s ] [2026-01-13T18:28:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-13 17:23:09' AND '2026-01-13 18:23:09' AND `specuser` = '' LIMIT 1 [ RunTime:0.000517s ] [2026-01-13T18:28:16+08:00][sql] CONNECT:[ UseTime:0.001530s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001342s ] [2026-01-13T18:28:16+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000384s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001232s ] [2026-01-13T18:28:16+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` = 91 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000356s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001162s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001024s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001172s ] [2026-01-13T18:28:16+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000412s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001235s ] [2026-01-13T18:28:16+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000662s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001293s ] [2026-01-13T18:28:16+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30224,30215,30027,30020,30019,30067,98016,98015,30024,30045,30010,98011,30220,30011,30048,30148,30041,98018,30023,30092,98005,30231,30093,30025,30230,30013,30081,30196,30197,30009,30229,30040,30088,98017,30046,30216,30047,30198,30044,30232,30218) [ RunTime:0.030723s ] [2026-01-13T18:28:16+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81027,88027,89027,91027,92027,12133,23155,22156,40155,42194,120059,31172,32175,33175,35180,36175,58018,23243,22025,40247,42120,120126,31188,88013,89013,91013,92013,58089,42063,120133) [ RunTime:0.041903s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001162s ] [2026-01-13T18:28:16+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.002172s ] [2026-01-13T18:28:16+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (25027,127026,25021,127020,127019,127031,127030,127029,127032,127070,25070,25024,127024,127022,25163,25165,25164,127069,127071,25068,12181,12136,100253,94017,94014,127067,118154,100169,100052,25039,41244,127068,100252,177255,177223,100008,128002,177222,100107,79032,129001,129008,129015,129022,129029,100167,100131,101107,101108,101109,101222,177045,177051,100254,100046,100175,100104,100101,100045,44026,127210,127105,128010,127104,95001,95012,127102,101127,127211,95006,95011,100095,100098,100092,25182,127189,100063,100176,44089,101197,25183,127188,101233,44091,101190,25184,127186,101234,44090,101191,127190,100062,101196,127023,128009,177042,177043,131201,101138,100232,41126,101195,130113,38146,101155,100144,119097,128081,100234,100207,101146,100049,100221,101022,120148,101092,127254,42142,38244,118155,120142,151015,120130,120128,120136,120147,42063,102129,28147,103055,42024,43024,42051,127103,42005,12241,23006,22007,40006,119004,119005,21240,20240,18240,17240,16168,152001,12002,154001,151001,155001,153001,58180,32196,33160,32191,32162,33162,12066,151017,33161) [ RunTime:0.042409s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001558s ] [2026-01-13T18:28:16+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000430s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001109s ] [2026-01-13T18:28:16+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000306s ] [2026-01-13T18:28:16+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000231s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000947s ] [2026-01-13T18:28:16+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000275s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000991s ] [2026-01-13T18:28:16+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000286s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000890s ] [2026-01-13T18:28:16+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (206,234,242,270) [ RunTime:0.000395s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000930s ] [2026-01-13T18:28:16+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 GROUP BY `attr_tanent_id` [ RunTime:0.000613s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001109s ] [2026-01-13T18:28:16+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (18,29,39,68,28,38,69,205,185,67,41,70,203,86,17,37,30,88,188,169,87,58,155,150,129,128,130,158,157,156,400,429,449,410,439,460,280,319,310,360,290,369,10488,219,300,379,230) [ RunTime:0.001042s ] [2026-01-13T18:28:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000961s ] [2026-01-13T18:28:19+08:00][sql] CONNECT:[ UseTime:0.001501s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001445s ] [2026-01-13T18:28:19+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000461s ] [2026-01-13T18:28:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001084s ] [2026-01-13T18:28:19+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000227s ] [2026-01-13T18:30:35+08:00][sql] CONNECT:[ UseTime:0.010410s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001351s ] [2026-01-13T18:30:35+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000385s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001176s ] [2026-01-13T18:30:35+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` = 91 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000319s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001091s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001040s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001103s ] [2026-01-13T18:30:35+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000379s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001163s ] [2026-01-13T18:30:35+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000521s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001255s ] [2026-01-13T18:30:35+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30224,30215,30027,30020,30019,30067,98016,98015,30024,30045,30010,98011,30220,30011,30048,30148,30041,98018,30023,30092,98005,30231,30093,30025,30230,30013,30081,30196,30197,30009,30229,30040,30088,98017,30046,30216,30047,30198,30044,30232,30218) [ RunTime:0.030579s ] [2026-01-13T18:30:35+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81027,88027,89027,91027,92027,12133,23155,22156,40155,42194,120059,31172,32175,33175,35180,36175,58018,23243,22025,40247,42120,120126,31188,88013,89013,91013,92013,58089,42063,120133) [ RunTime:0.041551s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001063s ] [2026-01-13T18:30:35+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000350s ] [2026-01-13T18:30:35+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (152001,12002,154001,151001,155001,153001,58180,32196,33160,32191,32162,33162,12066,151017,33161) [ RunTime:0.041191s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001215s ] [2026-01-13T18:30:35+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000341s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001200s ] [2026-01-13T18:30:35+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000320s ] [2026-01-13T18:30:35+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000234s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000870s ] [2026-01-13T18:30:35+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000302s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000937s ] [2026-01-13T18:30:35+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000305s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000882s ] [2026-01-13T18:30:35+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (206,234,242,270) [ RunTime:0.000440s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000913s ] [2026-01-13T18:30:35+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 GROUP BY `attr_tanent_id` [ RunTime:0.000539s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001104s ] [2026-01-13T18:30:35+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (18,29,39,68,28,38,69,205,185,67,41,70,203,86,17,37,30,88,188,169,87,58,155,150,129,128,130,158,157,156,400,429,449,410,439,460,280,319,310,360,290,369,10488,219,300,379,230) [ RunTime:0.001012s ] [2026-01-13T18:30:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000946s ] [2026-01-13T18:30:46+08:00][sql] CONNECT:[ UseTime:0.011310s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001325s ] [2026-01-13T18:30:46+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000423s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001219s ] [2026-01-13T18:30:46+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` = 91 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000305s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001091s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000960s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001124s ] [2026-01-13T18:30:46+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000363s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001178s ] [2026-01-13T18:30:46+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000474s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001192s ] [2026-01-13T18:30:46+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30224,30215,30027,30020,30019,30067,98016,98015,30024,30045,30010,98011,30220,30011,30048,30148,30041,98018,30023,30092,98005,30231,30093,30025,30230,30013,30081,30196,30197,30009,30229,30040,30088,98017,30046,30216,30047,30198,30044,30232,30218) [ RunTime:0.030868s ] [2026-01-13T18:30:46+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81027,88027,89027,91027,92027,12133,23155,22156,40155,42194,120059,31172,32175,33175,35180,36175,58018,23243,22025,40247,42120,120126,31188,88013,89013,91013,92013,58089,42063,120133) [ RunTime:0.041469s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001109s ] [2026-01-13T18:30:46+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000373s ] [2026-01-13T18:30:46+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (152001,12002,154001,151001,155001,153001,58180,32196,33160,32191,32162,33162,12066,151017,33161) [ RunTime:0.041603s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001274s ] [2026-01-13T18:30:46+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000349s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001207s ] [2026-01-13T18:30:46+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000310s ] [2026-01-13T18:30:46+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000233s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000873s ] [2026-01-13T18:30:46+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000298s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000922s ] [2026-01-13T18:30:46+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000324s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000872s ] [2026-01-13T18:30:46+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (206,234,242,270) [ RunTime:0.000339s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000930s ] [2026-01-13T18:30:46+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 GROUP BY `attr_tanent_id` [ RunTime:0.000542s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001102s ] [2026-01-13T18:30:46+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (18,29,39,68,28,38,69,205,185,67,41,70,203,86,17,37,30,88,188,169,87,58,155,150,129,128,130,158,157,156,400,429,449,410,439,460,280,319,310,360,290,369,10488,219,300,379,230) [ RunTime:0.001002s ] [2026-01-13T18:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000987s ] [2026-01-13T18:36:06+08:00][sql] CONNECT:[ UseTime:0.011617s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001258s ] [2026-01-13T18:36:06+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000387s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001117s ] [2026-01-13T18:36:06+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` = 91 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000336s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001048s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000931s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001024s ] [2026-01-13T18:36:06+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000399s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001108s ] [2026-01-13T18:36:06+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000460s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001103s ] [2026-01-13T18:36:06+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30224,30215,30027,30020,30019,30067,98016,98015,30024,30045,30010,98011,30220,30011,30048,30148,30041,98018,30023,30092,98005,30231,30093,30025,30230,30013,30081,30196,30197,30009,30229,30040,30088,98017,30046,30216,30047,30198,30044,30232,30218) [ RunTime:0.028696s ] [2026-01-13T18:36:06+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81027,88027,89027,91027,92027,12133,23155,22156,40155,42194,120059,31172,32175,33175,35180,36175,58018,23243,22025,40247,42120,120126,31188,88013,89013,91013,92013,58089,42063,120133) [ RunTime:0.039575s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001047s ] [2026-01-13T18:36:06+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.002144s ] [2026-01-13T18:36:06+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (25027,127026,25021,127020,127019,127031,127030,127029,127032,127070,25070,25024,127024,127022,25163,25165,25164,127069,127071,25068,12181,12136,100253,94017,94014,127067,118154,100169,100052,25039,41244,127068,100252,177255,177223,100008,128002,177222,100107,79032,129001,129008,129015,129022,129029,100167,100131,101107,101108,101109,101222,177045,177051,100254,100046,100175,100104,100101,100045,44026,127210,127105,128010,127104,95001,95012,127102,101127,127211,95006,95011,100095,100098,100092,25182,127189,100063,100176,44089,101197,25183,127188,101233,44091,101190,25184,127186,101234,44090,101191,127190,100062,101196,127023,128009,177042,177043,131201,101138,100232,41126,101195,130113,38146,101155,100144,119097,128081,100234,100207,101146,100049,100221,101022,120148,101092,127254,42142,38244,118155,120142,151015,120130,120128,120136,120147,42063,102129,28147,103055,42024,43024,42051,127103,42005,12241,23006,22007,40006,119004,119005,21240,20240,18240,17240,16168,152001,12002,154001,151001,155001,153001,58180,32196,33160,32191,32162,33162,12066,151017,33161) [ RunTime:0.040088s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001354s ] [2026-01-13T18:36:06+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000339s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000987s ] [2026-01-13T18:36:06+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000296s ] [2026-01-13T18:36:06+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000225s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000825s ] [2026-01-13T18:36:06+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 159 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000254s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000882s ] [2026-01-13T18:36:06+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 [ RunTime:0.000276s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000821s ] [2026-01-13T18:36:06+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (206,234,242,270) [ RunTime:0.000315s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000851s ] [2026-01-13T18:36:06+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 159 GROUP BY `attr_tanent_id` [ RunTime:0.000597s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001035s ] [2026-01-13T18:36:06+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (18,29,39,68,28,38,69,205,185,67,41,70,203,86,17,37,30,88,188,169,87,58,155,150,129,128,130,158,157,156,400,429,449,410,439,460,280,319,310,360,290,369,10488,219,300,379,230) [ RunTime:0.000936s ] [2026-01-13T18:36:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000916s ] [2026-01-13T18:42:04+08:00][sql] CONNECT:[ UseTime:0.001438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001289s ] [2026-01-13T18:42:04+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000401s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001212s ] [2026-01-13T18:42:04+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` = 88 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000328s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001113s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001026s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001091s ] [2026-01-13T18:42:04+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000452s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001215s ] [2026-01-13T18:42:04+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000469s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001181s ] [2026-01-13T18:42:04+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30211,30094,30026,30048,30012,98011,30024,30010,98005,30092,98009,30222,30046,30011,30025,30212,30027,30045,30219,30093,30229,30095,30013,30023,30098,30231,98003) [ RunTime:0.030634s ] [2026-01-13T18:42:04+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (72047,73027,74027,76027,77027,12177,23155,22156,40155,42049,120123,16172,73006,74006,76006,77006,58017,23243,22025,40247,16188,73013,74013,76013,77013,60089) [ RunTime:0.041611s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001097s ] [2026-01-13T18:42:04+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.001798s ] [2026-01-13T18:42:04+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (94014,30012,30210,30033,166001,166106,30207,30019,30004,30040,166155,98005,100101,100061,95012,177223,177222,127103,127104,177016,177006,127101,127201,177026,177036,127210,127211,131202,127102,127254,38244,177051,118153,118154,118155,127068,127069,127030,127070,101190,100176,100062,100095,100107,127186,127190,101233,100104,127020,25163,127019,25182,127023,127026,127022,25164,127025,127038,25165,101104,101105,101106,101217,128002,100131,100254,100046,100045,100167,101206,100081,100221,127027,127039,127024,127021,100144,127029,127032,28146,43012,28151,101022,128081,103055,101195,151007,119005,119004,101146,100175,101155,128010,103232,100172,95011,42194,28147,120127,151001,152001,153001,154001,155001,177042,177041,177043,120051,42063,42142,177045,101139,99202,119097,100252,127074,127075,12003,12005,12241,12014,12019,16168,40006,17058,17067,17076,17082,17240,23006,18061,18064,18070,18073,18240,22007,20061,20064,20070,20073,20240,21062,21065,21071,21074,21240,20205,17216,21205,18205) [ RunTime:0.042193s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001463s ] [2026-01-13T18:42:04+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000389s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001017s ] [2026-01-13T18:42:04+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000337s ] [2026-01-13T18:42:04+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000233s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000891s ] [2026-01-13T18:42:04+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000262s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000943s ] [2026-01-13T18:42:04+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000302s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000884s ] [2026-01-13T18:42:04+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (18,33,51,118,133,151,218,233,251) [ RunTime:0.000376s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000915s ] [2026-01-13T18:42:04+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 GROUP BY `attr_tanent_id` [ RunTime:0.000530s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001129s ] [2026-01-13T18:42:04+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (19,39,38,70,199,69,201,20,183,25,186,23,165,206,84,24,169,53,40,18,181,168,68,28,170,55,17,161,159,150,121,122,149,140,160,123,127,125,142,399,430,449,410,440,459,280,320,310,260,290,370,10488,10493,380) [ RunTime:0.001070s ] [2026-01-13T18:42:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000935s ] [2026-01-13T18:42:08+08:00][sql] CONNECT:[ UseTime:0.001434s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001284s ] [2026-01-13T18:42:08+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000414s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001188s ] [2026-01-13T18:42:08+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` = 89 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000317s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001173s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001040s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001137s ] [2026-01-13T18:42:08+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000345s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001141s ] [2026-01-13T18:42:08+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000464s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001195s ] [2026-01-13T18:42:08+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (30227,30147,30013,30034,30068,30005,30192,98015,30195,30250,30092,30010,30045,98009,30146,30204,30203,30206,30069,30229,30048,30201,30191,30024,98003,30228,30080,30041,30088,98013,30009,98011,30207,30006,30081,98007,30211,30223,30212,30033) [ RunTime:0.030519s ] [2026-01-13T18:42:08+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (81023,88023,89023,91023,92023,7230,90008,23155,22156,40155,42049,120059,31168,88002,89002,91002,92002,47017,90002,23243,22025,40247,42194,120123,31020,32020,33020,35020,36020,54086,84057,42031,7202,7211) [ RunTime:0.041627s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001010s ] [2026-01-13T18:42:08+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.002029s ] [2026-01-13T18:42:08+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` = 'shaiya' AND `serverid` = 6 AND `itemid` IN (7202,7211,7230,88023,34096,43012,25021,25024,25027,25039,94014,94017,25068,25070,127019,127020,127022,127023,127025,127026,127027,127029,44089,44090,44091,127032,25163,25164,25165,25182,25183,25184,127067,127068,127069,127070,127102,127186,127187,127188,127190,127201,30003,30004,30011,30024,30025,30031,30038,30046,30054,30192,30195,30196,30199,30200,30201,30204,30206,30207,30211,30215,30216,30224,95001,95006,95011,95012,128001,129001,128002,100008,100009,129008,129015,101022,100045,100046,100061,100062,100092,100098,100101,100104,100107,100117,100131,100167,100169,100175,100176,118153,118154,101190,101191,101195,101197,101206,101208,100221,100225,100232,100234,101233,101234,100252,100254,177223,120128,128011,120126,38146,127211,128010,28147,101196,101139,177045,177222,177042,177043,28152,42019,101127,100144,101146,127254,128081,103055,101155,101138,28122,127103,127075,28146,38244,118155,119005,119004,103238,102107,120082,120051,120084,120013,120081,99202,151007,42007,42015,42142,42011,152001,153001,151001,154001,155001,7046) [ RunTime:0.042300s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001392s ] [2026-01-13T18:42:08+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` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000457s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001018s ] [2026-01-13T18:42:08+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000341s ] [2026-01-13T18:42:08+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 157 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000233s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000867s ] [2026-01-13T18:42:08+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 157 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000294s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000905s ] [2026-01-13T18:42:08+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`group_type`,`attr_id`,`level` FROM `trade_season_equip` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 [ RunTime:0.000292s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000829s ] [2026-01-13T18:42:08+08:00][sql] SELECT `id`,`game`,`serverid`,`attr_id`,`remark` FROM `trade_season_effect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `attr_id` IN (15,31,51,115,131,201,231,249,255) [ RunTime:0.000377s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000889s ] [2026-01-13T18:42:08+08:00][sql] SELECT `attr_tanent_id`,count(id) as num FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 157 GROUP BY `attr_tanent_id` [ RunTime:0.000535s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001062s ] [2026-01-13T18:42:08+08:00][sql] SELECT `id`,`game`,`serverid`,`tanent_id`,`attrid1`,`attrvalue1`,`attrid2`,`attrvalue2`,`attrtext1`,`attrtext2`,`attrid3`,`attrvalue3`,`attrid4`,`attrvalue4`,`attrid5`,`attrvalue5`,`attrid6`,`attrvalue6` FROM `trade_season_skill` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tanent_id` IN (8,19,10,68,199,97,47,70,9,18,36,69,172,49,208,170,57,173,37,20,67,39,59,96,110,159,150,108,147,160,109,400,420,450,410,440,460,280,330,310,260,340,290,369,220,300,10127,10128,230,10146) [ RunTime:0.001023s ] [2026-01-13T18:42:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000925s ] [2026-01-13T19:56:32+08:00][sql] CONNECT:[ UseTime:0.001595s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T19:56:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001484s ] [2026-01-13T19:56:32+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 ] [2026-01-13T19:56:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001153s ] [2026-01-13T19:56:32+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000237s ] [2026-01-13T20:21:08+08:00][sql] CONNECT:[ UseTime:0.001510s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T20:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001281s ] [2026-01-13T20:21:08+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.000438s ] [2026-01-13T20:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001012s ] [2026-01-13T20:21:08+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000256s ] [2026-01-13T20:30:30+08:00][sql] CONNECT:[ UseTime:0.010814s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T20:30:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001331s ] [2026-01-13T20:30:30+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.000410s ] [2026-01-13T20:30:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000996s ] [2026-01-13T20:30:30+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000246s ] [2026-01-13T20:42:03+08:00][sql] CONNECT:[ UseTime:0.001565s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T20:42:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001483s ] [2026-01-13T20:42:03+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.000432s ] [2026-01-13T20:42:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001129s ] [2026-01-13T20:42:03+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000250s ] [2026-01-13T22:07:32+08:00][sql] CONNECT:[ UseTime:0.001533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T22:07:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001315s ] [2026-01-13T22:07:32+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.000512s ] [2026-01-13T22:07:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001083s ] [2026-01-13T22:07:32+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000217s ] [2026-01-13T22:43:07+08:00][sql] CONNECT:[ UseTime:0.001526s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-13T22:43:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001301s ] [2026-01-13T22:43: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.000410s ] [2026-01-13T22:43:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001031s ] [2026-01-13T22:43:07+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000235s ]