[2026-01-09T06:42:00+08:00][sql] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T06:42:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001295s ] [2026-01-09T06:42:00+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.000427s ] [2026-01-09T06:42:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001022s ] [2026-01-09T06:42:00+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000208s ] [2026-01-09T09:35:33+08:00][sql] CONNECT:[ UseTime:0.001528s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T09:35:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001298s ] [2026-01-09T09:35:33+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.000460s ] [2026-01-09T09:35:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000993s ] [2026-01-09T09:35:33+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000207s ] [2026-01-09T10:18:45+08:00][sql] CONNECT:[ UseTime:0.010974s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T10:18:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001421s ] [2026-01-09T10:18:45+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.000466s ] [2026-01-09T10:18:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001050s ] [2026-01-09T10:18:45+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000208s ] [2026-01-09T10:18:48+08:00][sql] CONNECT:[ UseTime:0.001580s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001387s ] [2026-01-09T10:18:48+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-09T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001092s ] [2026-01-09T10:18:48+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '5049a55a206d441ab03568ce2b48bcc4' AND `status` = 1 LIMIT 1 [ RunTime:0.000367s ] [2026-01-09T10:18:48+08:00][sql] CONNECT:[ UseTime:0.011563s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001131s ] [2026-01-09T10:18:48+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.000416s ] [2026-01-09T10:18:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001194s ] [2026-01-09T10:18:48+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-09 09:13:48' AND '2026-01-09 10:13:48' AND `specuser` = '' LIMIT 1 [ RunTime:0.000420s ] [2026-01-09T10:18:55+08:00][sql] CONNECT:[ UseTime:0.011432s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T10:18:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001265s ] [2026-01-09T10:18:55+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.000381s ] [2026-01-09T10:18:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001181s ] [2026-01-09T10:18:55+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-09 10:13:55' LIMIT 1 [ RunTime:0.000424s ] [2026-01-09T10:18:57+08:00][sql] CONNECT:[ UseTime:0.011538s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T10:18:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001371s ] [2026-01-09T10: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.000386s ] [2026-01-09T10:18:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001206s ] [2026-01-09T10: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-09 09:13:57' AND '2026-01-09 10:13:57' AND `specuser` = '' LIMIT 1 [ RunTime:0.000452s ] [2026-01-09T10:20:02+08:00][sql] CONNECT:[ UseTime:0.001384s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T10:20:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001274s ] [2026-01-09T10:20:02+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-09T10:20:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001204s ] [2026-01-09T10:20:02+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-09 09:15:02' AND '2026-01-09 10:15:02' AND `specuser` = '' LIMIT 1 [ RunTime:0.000440s ] [2026-01-09T10:20:03+08:00][sql] CONNECT:[ UseTime:0.010911s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T10:20:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001348s ] [2026-01-09T10:20: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.000366s ] [2026-01-09T10:20:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001188s ] [2026-01-09T10:20:03+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-09 10:15:03' LIMIT 1 [ RunTime:0.000422s ] [2026-01-09T10:20:03+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-09 10:15:03' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000466s ] [2026-01-09T10:20:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000944s ] [2026-01-09T10:20:03+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 154 GROUP BY `tid` [ RunTime:0.000293s ] [2026-01-09T10:20:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000934s ] [2026-01-09T10:20:03+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 154 [ RunTime:0.000223s ] [2026-01-09T10:20:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001007s ] [2026-01-09T10:20:07+08:00][sql] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001437s ] [2026-01-09T10:20: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.000429s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001243s ] [2026-01-09T10:20: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` = 86 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000319s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001120s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000991s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001127s ] [2026-01-09T10:20: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` = 154 [ RunTime:0.000397s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001219s ] [2026-01-09T10:20: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` = 154 [ RunTime:0.000500s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001249s ] [2026-01-09T10:20:07+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.030728s ] [2026-01-09T10:20: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 (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.041456s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001107s ] [2026-01-09T10:20:07+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 154 [ RunTime:0.001715s ] [2026-01-09T10:20: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 (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.042270s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001675s ] [2026-01-09T10:20: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` = 154 [ RunTime:0.000360s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001037s ] [2026-01-09T10:20: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` = 154 [ RunTime:0.000325s ] [2026-01-09T10:20:07+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 154 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000245s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000881s ] [2026-01-09T10:20:07+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 154 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000260s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000920s ] [2026-01-09T10:20: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` = 154 [ RunTime:0.000287s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000871s ] [2026-01-09T10:20:07+08:00][sql] SELECT `tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 154 [ RunTime:0.000249s ] [2026-01-09T10:20:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000845s ] [2026-01-09T10:21:08+08:00][sql] CONNECT:[ UseTime:0.010847s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001395s ] [2026-01-09T10:21: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.000422s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001353s ] [2026-01-09T10:21: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` = 86 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000305s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001161s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001076s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001172s ] [2026-01-09T10:21: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` = 154 [ RunTime:0.000337s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001249s ] [2026-01-09T10:21: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` = 154 [ RunTime:0.000487s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001267s ] [2026-01-09T10:21:08+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.032412s ] [2026-01-09T10:21: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 (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.043914s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001323s ] [2026-01-09T10:21:08+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 154 [ RunTime:0.001719s ] [2026-01-09T10:21: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 (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.044811s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001443s ] [2026-01-09T10:21: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` = 154 [ RunTime:0.000399s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001174s ] [2026-01-09T10:21: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` = 154 [ RunTime:0.000297s ] [2026-01-09T10:21:08+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 154 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000235s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000968s ] [2026-01-09T10:21:08+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 154 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000338s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000973s ] [2026-01-09T10:21: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` = 154 [ RunTime:0.000352s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000933s ] [2026-01-09T10:21:08+08:00][sql] SELECT `tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 154 [ RunTime:0.000254s ] [2026-01-09T10:21:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000942s ] [2026-01-09T10:23:03+08:00][sql] CONNECT:[ UseTime:0.010998s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001276s ] [2026-01-09T10:23: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.000383s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001151s ] [2026-01-09T10:23: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` = 86 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000318s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001071s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000967s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001074s ] [2026-01-09T10:23: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` = 154 [ RunTime:0.000343s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001163s ] [2026-01-09T10:23: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` = 154 [ RunTime:0.000441s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001181s ] [2026-01-09T10:23: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.029931s ] [2026-01-09T10:23: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.040693s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001148s ] [2026-01-09T10:23:03+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 154 [ RunTime:0.001556s ] [2026-01-09T10:23: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.041333s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001394s ] [2026-01-09T10:23: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` = 154 [ RunTime:0.000370s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001009s ] [2026-01-09T10:23: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` = 154 [ RunTime:0.000314s ] [2026-01-09T10:23:03+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 154 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000255s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000853s ] [2026-01-09T10:23:03+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 154 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000363s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000929s ] [2026-01-09T10:23: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` = 154 [ RunTime:0.000381s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000871s ] [2026-01-09T10:23:03+08:00][sql] SELECT `tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 154 [ RunTime:0.000375s ] [2026-01-09T10:23:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000878s ] [2026-01-09T11:45:58+08:00][sql] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T11:45:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001305s ] [2026-01-09T11:45:58+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000417s ] [2026-01-09T11:45:58+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001041s ] [2026-01-09T11:45:58+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000250s ] [2026-01-09T11:47:07+08:00][sql] CONNECT:[ UseTime:0.001424s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T11:47:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001440s ] [2026-01-09T11:47: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.000428s ] [2026-01-09T11:47:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001010s ] [2026-01-09T11:47:07+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000210s ] [2026-01-09T13:21:57+08:00][sql] CONNECT:[ UseTime:0.001490s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T13:21:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001311s ] [2026-01-09T13:21: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.000422s ] [2026-01-09T13:21:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001037s ] [2026-01-09T13:21:57+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000215s ] [2026-01-09T14:26:12+08:00][sql] CONNECT:[ UseTime:0.010774s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:26:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001243s ] [2026-01-09T14:26:12+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.000399s ] [2026-01-09T14:26:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001211s ] [2026-01-09T14:26:12+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-09 14:21:12' LIMIT 1 [ RunTime:0.000414s ] [2026-01-09T14:26:13+08:00][sql] CONNECT:[ UseTime:0.011285s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:26:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001305s ] [2026-01-09T14:26: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.000401s ] [2026-01-09T14:26:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001188s ] [2026-01-09T14:26:13+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-09 13:21:13' AND '2026-01-09 14:21:13' AND `specuser` = '' LIMIT 1 [ RunTime:0.000448s ] [2026-01-09T14:26:14+08:00][sql] CONNECT:[ UseTime:0.001421s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:26:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001257s ] [2026-01-09T14:26:14+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-09T14:26:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001120s ] [2026-01-09T14:26:14+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-09 14:21:14' LIMIT 1 [ RunTime:0.000380s ] [2026-01-09T14:27:04+08:00][sql] CONNECT:[ UseTime:0.010488s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001269s ] [2026-01-09T14:27: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.000378s ] [2026-01-09T14:27:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001115s ] [2026-01-09T14:27:04+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-09 14:22:04' LIMIT 1 [ RunTime:0.000404s ] [2026-01-09T14:27:05+08:00][sql] CONNECT:[ UseTime:0.011313s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001322s ] [2026-01-09T14:27:05+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-09T14:27:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001199s ] [2026-01-09T14:27:05+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-09 13:22:05' AND '2026-01-09 14:22:05' AND `specuser` = '' LIMIT 1 [ RunTime:0.000432s ] [2026-01-09T14:27:06+08:00][sql] CONNECT:[ UseTime:0.010941s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001251s ] [2026-01-09T14:27: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.000372s ] [2026-01-09T14:27:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001317s ] [2026-01-09T14:27:06+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-09 14:22:06' LIMIT 1 [ RunTime:0.000408s ] [2026-01-09T14:27:08+08:00][sql] CONNECT:[ UseTime:0.001405s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001259s ] [2026-01-09T14:27: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.000390s ] [2026-01-09T14:27:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001121s ] [2026-01-09T14:27:08+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-09 14:22:08' LIMIT 1 [ RunTime:0.000381s ] [2026-01-09T14:27:10+08:00][sql] CONNECT:[ UseTime:0.001426s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001234s ] [2026-01-09T14:27: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.000376s ] [2026-01-09T14:27:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001196s ] [2026-01-09T14:27: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` BETWEEN '2026-01-09 13:22:10' AND '2026-01-09 14:22:10' AND `specuser` = '' LIMIT 1 [ RunTime:0.000457s ] [2026-01-09T14:27:10+08:00][sql] CONNECT:[ UseTime:0.011413s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001345s ] [2026-01-09T14:27: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.000403s ] [2026-01-09T14:27:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001200s ] [2026-01-09T14:27: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-09 14:22:10' LIMIT 1 [ RunTime:0.000446s ] [2026-01-09T14:27:12+08:00][sql] CONNECT:[ UseTime:0.001446s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001359s ] [2026-01-09T14:27:12+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.000398s ] [2026-01-09T14:27:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001174s ] [2026-01-09T14:27:12+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-09 14:22:12' LIMIT 1 [ RunTime:0.000557s ] [2026-01-09T14:27:32+08:00][sql] CONNECT:[ UseTime:0.011076s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001349s ] [2026-01-09T14:27:32+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-09T14:27:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001172s ] [2026-01-09T14:27:32+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-09 14:22:32' LIMIT 1 [ RunTime:0.000412s ] [2026-01-09T14:27:33+08:00][sql] CONNECT:[ UseTime:0.001492s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001331s ] [2026-01-09T14:27:33+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.000411s ] [2026-01-09T14:27:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001234s ] [2026-01-09T14:27:33+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-09 13:22:33' AND '2026-01-09 14:22:33' AND `specuser` = '' LIMIT 1 [ RunTime:0.000428s ] [2026-01-09T14:27:34+08:00][sql] CONNECT:[ UseTime:0.011450s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001335s ] [2026-01-09T14:27:34+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.000372s ] [2026-01-09T14:27:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001173s ] [2026-01-09T14:27:34+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-09 14:22:34' LIMIT 1 [ RunTime:0.000440s ] [2026-01-09T14:27:41+08:00][sql] CONNECT:[ UseTime:0.011598s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001265s ] [2026-01-09T14:27:41+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.000386s ] [2026-01-09T14:27:41+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001025s ] [2026-01-09T14:27:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `username` = '' AND `created_at` >= '2025-10-11 14:27:41' LIMIT 1 [ RunTime:0.000440s ] [2026-01-09T14:27:44+08:00][sql] CONNECT:[ UseTime:0.011469s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:27:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001345s ] [2026-01-09T14:27:44+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-09T14:27:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001198s ] [2026-01-09T14:27:44+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-09 13:22:44' AND '2026-01-09 14:22:44' AND `specuser` = '' LIMIT 1 [ RunTime:0.000429s ] [2026-01-09T14:28:35+08:00][sql] CONNECT:[ UseTime:0.010474s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001256s ] [2026-01-09T14:28: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.000370s ] [2026-01-09T14:28:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001133s ] [2026-01-09T14:28:35+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-09 13:23:35' AND '2026-01-09 14:23:35' AND `specuser` = '' LIMIT 1 [ RunTime:0.000487s ] [2026-01-09T14:28:35+08:00][sql] CONNECT:[ UseTime:0.001409s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001223s ] [2026-01-09T14:28: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.000371s ] [2026-01-09T14:28:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001125s ] [2026-01-09T14:28:35+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-09 14:23:35' LIMIT 1 [ RunTime:0.000442s ] [2026-01-09T14:28:36+08:00][sql] CONNECT:[ UseTime:0.001640s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001729s ] [2026-01-09T14:28:36+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.000624s ] [2026-01-09T14:28:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001654s ] [2026-01-09T14:28:36+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-09 14:23:36' LIMIT 1 [ RunTime:0.000492s ] [2026-01-09T14:28:36+08:00][sql] CONNECT:[ UseTime:0.010475s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001229s ] [2026-01-09T14:28:36+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-09T14:28:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001118s ] [2026-01-09T14:28:36+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-09 13:23:36' AND '2026-01-09 14:23:36' AND `specuser` = '' LIMIT 1 [ RunTime:0.000391s ] [2026-01-09T14:28:37+08:00][sql] CONNECT:[ UseTime:0.001581s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001497s ] [2026-01-09T14:28: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.000421s ] [2026-01-09T14:28:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001356s ] [2026-01-09T14:28:37+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-09 13:23:37' AND '2026-01-09 14:23:37' AND `specuser` = '' LIMIT 1 [ RunTime:0.000489s ] [2026-01-09T14:28:37+08:00][sql] CONNECT:[ UseTime:0.010981s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001239s ] [2026-01-09T14:28: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.000454s ] [2026-01-09T14:28:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001121s ] [2026-01-09T14:28:37+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-09 14:23:37' LIMIT 1 [ RunTime:0.000386s ] [2026-01-09T14:28:37+08:00][sql] CONNECT:[ UseTime:0.010836s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001230s ] [2026-01-09T14:28: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.000373s ] [2026-01-09T14:28:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001142s ] [2026-01-09T14:28:37+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-09 13:23:37' AND '2026-01-09 14:23:37' AND `specuser` = '' LIMIT 1 [ RunTime:0.000431s ] [2026-01-09T14:28:38+08:00][sql] CONNECT:[ UseTime:0.001372s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001235s ] [2026-01-09T14:28: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.000393s ] [2026-01-09T14:28:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001207s ] [2026-01-09T14:28:38+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-09 14:23:38' LIMIT 1 [ RunTime:0.000495s ] [2026-01-09T14:28:38+08:00][sql] CONNECT:[ UseTime:0.011207s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001291s ] [2026-01-09T14:28: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.000412s ] [2026-01-09T14:28:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001181s ] [2026-01-09T14:28:38+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-09 14:23:38' LIMIT 1 [ RunTime:0.000405s ] [2026-01-09T14:28:39+08:00][sql] CONNECT:[ UseTime:0.011850s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001323s ] [2026-01-09T14:28:39+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-09T14:28:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001189s ] [2026-01-09T14:28:39+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-09 13:23:39' AND '2026-01-09 14:23:39' AND `specuser` = '' LIMIT 1 [ RunTime:0.000399s ] [2026-01-09T14:28:40+08:00][sql] CONNECT:[ UseTime:0.001477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001347s ] [2026-01-09T14:28:40+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.000427s ] [2026-01-09T14:28:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001191s ] [2026-01-09T14:28:40+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-09 14:23:39' LIMIT 1 [ RunTime:0.000413s ] [2026-01-09T14:28:40+08:00][sql] CONNECT:[ UseTime:0.010569s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:28:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001262s ] [2026-01-09T14:28:40+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.000381s ] [2026-01-09T14:28:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001193s ] [2026-01-09T14:28:40+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-09 14:23:40' LIMIT 1 [ RunTime:0.000424s ] [2026-01-09T14:29:38+08:00][sql] CONNECT:[ UseTime:0.010906s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:29:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001338s ] [2026-01-09T14:29: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.000383s ] [2026-01-09T14:29:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001187s ] [2026-01-09T14:29:38+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-09 13:24:38' AND '2026-01-09 14:24:38' AND `specuser` = '' LIMIT 1 [ RunTime:0.000437s ] [2026-01-09T14:29:39+08:00][sql] CONNECT:[ UseTime:0.010421s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:29:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001244s ] [2026-01-09T14:29:39+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.000376s ] [2026-01-09T14:29:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001121s ] [2026-01-09T14:29:39+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-09 14:24:39' LIMIT 1 [ RunTime:0.000392s ] [2026-01-09T14:29:39+08:00][sql] CONNECT:[ UseTime:0.010477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:29:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001323s ] [2026-01-09T14:29:39+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.000388s ] [2026-01-09T14:29:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001218s ] [2026-01-09T14:29:39+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-09 13:24:39' AND '2026-01-09 14:24:39' AND `specuser` = '' LIMIT 1 [ RunTime:0.000423s ] [2026-01-09T14:29:40+08:00][sql] CONNECT:[ UseTime:0.001378s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:29:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001221s ] [2026-01-09T14:29:40+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.000378s ] [2026-01-09T14:29:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001242s ] [2026-01-09T14:29:40+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-09 14:24:40' LIMIT 1 [ RunTime:0.000427s ] [2026-01-09T14:34:36+08:00][sql] CONNECT:[ UseTime:0.011581s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:34:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001330s ] [2026-01-09T14:34:36+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-09T14:34:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001210s ] [2026-01-09T14:34:36+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-09 13:29:36' AND '2026-01-09 14:29:36' AND `specuser` = '' LIMIT 1 [ RunTime:0.000412s ] [2026-01-09T14:34:36+08:00][sql] CONNECT:[ UseTime:0.001392s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:34:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001220s ] [2026-01-09T14:34:36+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.000443s ] [2026-01-09T14:34:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001248s ] [2026-01-09T14:34:36+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-09 14:29:36' LIMIT 1 [ RunTime:0.000371s ] [2026-01-09T14:35:01+08:00][sql] CONNECT:[ UseTime:0.011659s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:35:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001289s ] [2026-01-09T14:35:01+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-09T14:35:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001219s ] [2026-01-09T14:35:01+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-09 13:30:01' AND '2026-01-09 14:30:01' AND `specuser` = '' LIMIT 1 [ RunTime:0.000448s ] [2026-01-09T14:35:02+08:00][sql] CONNECT:[ UseTime:0.001876s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001823s ] [2026-01-09T14:35:02+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.000682s ] [2026-01-09T14:35:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001714s ] [2026-01-09T14:35:02+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-09 14:30:02' LIMIT 1 [ RunTime:0.000543s ] [2026-01-09T14:35:29+08:00][sql] CONNECT:[ UseTime:0.010953s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:35:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001352s ] [2026-01-09T14:35:29+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-09T14:35:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001162s ] [2026-01-09T14:35:29+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-09 13:30:29' AND '2026-01-09 14:30:29' AND `specuser` = '' LIMIT 1 [ RunTime:0.000424s ] [2026-01-09T14:35:29+08:00][sql] CONNECT:[ UseTime:0.011534s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:35:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001264s ] [2026-01-09T14:35:29+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.000411s ] [2026-01-09T14:35:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001173s ] [2026-01-09T14:35:29+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-09 14:30:29' LIMIT 1 [ RunTime:0.000426s ] [2026-01-09T14:35:39+08:00][sql] CONNECT:[ UseTime:0.001463s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:35:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001279s ] [2026-01-09T14:35:39+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.000413s ] [2026-01-09T14:35:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001185s ] [2026-01-09T14:35:39+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-09 13:30:39' AND '2026-01-09 14:30:39' AND `specuser` = '' LIMIT 1 [ RunTime:0.000415s ] [2026-01-09T14:35:39+08:00][sql] CONNECT:[ UseTime:0.011181s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:35:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001331s ] [2026-01-09T14:35:39+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.000407s ] [2026-01-09T14:35:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001186s ] [2026-01-09T14:35:39+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-09 14:30:39' LIMIT 1 [ RunTime:0.000419s ] [2026-01-09T14:36:27+08:00][sql] CONNECT:[ UseTime:0.011216s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001337s ] [2026-01-09T14:36: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.000399s ] [2026-01-09T14:36:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001210s ] [2026-01-09T14:36:27+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-09 13:31:27' AND '2026-01-09 14:31:27' AND `specuser` = '' LIMIT 1 [ RunTime:0.000438s ] [2026-01-09T14:36:28+08:00][sql] CONNECT:[ UseTime:0.011508s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001299s ] [2026-01-09T14:36:28+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-09T14:36:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001176s ] [2026-01-09T14:36:28+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-09 14:31:28' LIMIT 1 [ RunTime:0.000389s ] [2026-01-09T14:36:29+08:00][sql] CONNECT:[ UseTime:0.011514s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001309s ] [2026-01-09T14:36:29+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.000398s ] [2026-01-09T14:36:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001172s ] [2026-01-09T14:36:29+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-09 13:31:29' AND '2026-01-09 14:31:29' AND `specuser` = '' LIMIT 1 [ RunTime:0.000392s ] [2026-01-09T14:36:30+08:00][sql] CONNECT:[ UseTime:0.011278s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001319s ] [2026-01-09T14:36:30+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.000408s ] [2026-01-09T14:36:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001183s ] [2026-01-09T14:36:30+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-09 13:31:30' AND '2026-01-09 14:31:30' AND `specuser` = '' LIMIT 1 [ RunTime:0.000402s ] [2026-01-09T14:36:30+08:00][sql] CONNECT:[ UseTime:0.010518s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001344s ] [2026-01-09T14:36:30+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.000381s ] [2026-01-09T14:36:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001194s ] [2026-01-09T14:36:30+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-09 14:31:30' LIMIT 1 [ RunTime:0.000398s ] [2026-01-09T14:36:31+08:00][sql] CONNECT:[ UseTime:0.010972s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001300s ] [2026-01-09T14:36:31+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-09T14:36:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001199s ] [2026-01-09T14:36:31+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-09 14:31:31' LIMIT 1 [ RunTime:0.000408s ] [2026-01-09T14:36:31+08:00][sql] CONNECT:[ UseTime:0.010898s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001322s ] [2026-01-09T14:36:31+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.000390s ] [2026-01-09T14:36:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001195s ] [2026-01-09T14:36:31+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-09 14:31:31' LIMIT 1 [ RunTime:0.000405s ] [2026-01-09T14:36:31+08:00][sql] CONNECT:[ UseTime:0.010983s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001306s ] [2026-01-09T14:36:31+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.000370s ] [2026-01-09T14:36:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001200s ] [2026-01-09T14:36:31+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-09 14:31:31' LIMIT 1 [ RunTime:0.000559s ] [2026-01-09T14:36:32+08:00][sql] CONNECT:[ UseTime:0.011034s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001298s ] [2026-01-09T14:36:32+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-09T14:36:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001168s ] [2026-01-09T14:36:32+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-09 14:31:32' LIMIT 1 [ RunTime:0.000434s ] [2026-01-09T14:36:32+08:00][sql] CONNECT:[ UseTime:0.001392s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001237s ] [2026-01-09T14:36:32+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-09T14:36:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001149s ] [2026-01-09T14:36:32+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-09 14:31:32' LIMIT 1 [ RunTime:0.000398s ] [2026-01-09T14:36:33+08:00][sql] CONNECT:[ UseTime:0.010661s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001220s ] [2026-01-09T14:36:33+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.000399s ] [2026-01-09T14:36:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001197s ] [2026-01-09T14:36:33+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-09 14:31:33' LIMIT 1 [ RunTime:0.000419s ] [2026-01-09T14:36:33+08:00][sql] CONNECT:[ UseTime:0.001358s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001220s ] [2026-01-09T14:36:33+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.000359s ] [2026-01-09T14:36:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001112s ] [2026-01-09T14:36:33+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-09 14:31:33' LIMIT 1 [ RunTime:0.000454s ] [2026-01-09T14:36:34+08:00][sql] CONNECT:[ UseTime:0.010836s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001242s ] [2026-01-09T14:36:34+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000382s ] [2026-01-09T14:36:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001117s ] [2026-01-09T14:36:34+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-09 14:31:34' LIMIT 1 [ RunTime:0.000382s ] [2026-01-09T14:36:35+08:00][sql] CONNECT:[ UseTime:0.010944s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001247s ] [2026-01-09T14:36: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.000441s ] [2026-01-09T14:36:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001140s ] [2026-01-09T14:36:35+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-09 14:31:35' LIMIT 1 [ RunTime:0.000390s ] [2026-01-09T14:36:35+08:00][sql] CONNECT:[ UseTime:0.011019s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001322s ] [2026-01-09T14:36: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.000392s ] [2026-01-09T14:36:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001197s ] [2026-01-09T14:36:35+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-09 14:31:35' LIMIT 1 [ RunTime:0.000377s ] [2026-01-09T14:36:36+08:00][sql] CONNECT:[ UseTime:0.010951s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001220s ] [2026-01-09T14:36:36+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.000371s ] [2026-01-09T14:36:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001108s ] [2026-01-09T14:36:36+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-09 14:31:36' LIMIT 1 [ RunTime:0.000400s ] [2026-01-09T14:36:36+08:00][sql] CONNECT:[ UseTime:0.010711s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001316s ] [2026-01-09T14:36:36+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.000390s ] [2026-01-09T14:36:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001178s ] [2026-01-09T14:36:36+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-09 14:31:36' LIMIT 1 [ RunTime:0.000396s ] [2026-01-09T14:36:36+08:00][sql] CONNECT:[ UseTime:0.011256s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001316s ] [2026-01-09T14:36:36+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-09T14:36:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001184s ] [2026-01-09T14:36:36+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-09 14:31:36' LIMIT 1 [ RunTime:0.000392s ] [2026-01-09T14:36:37+08:00][sql] CONNECT:[ UseTime:0.011035s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001245s ] [2026-01-09T14:36: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.000370s ] [2026-01-09T14:36:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001113s ] [2026-01-09T14:36:37+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-09 14:31:37' LIMIT 1 [ RunTime:0.000461s ] [2026-01-09T14:36:37+08:00][sql] CONNECT:[ UseTime:0.010905s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:36:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001320s ] [2026-01-09T14:36: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.000396s ] [2026-01-09T14:36:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001183s ] [2026-01-09T14:36:37+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-09 14:31:37' LIMIT 1 [ RunTime:0.000385s ] [2026-01-09T14:39:48+08:00][sql] CONNECT:[ UseTime:0.010865s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:39:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001236s ] [2026-01-09T14:39:48+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.000363s ] [2026-01-09T14:39:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001177s ] [2026-01-09T14:39:48+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-09 13:34:48' AND '2026-01-09 14:34:48' AND `specuser` = '' LIMIT 1 [ RunTime:0.000486s ] [2026-01-09T14:39:49+08:00][sql] CONNECT:[ UseTime:0.001377s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:39:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001244s ] [2026-01-09T14:39:49+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.000399s ] [2026-01-09T14:39:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001137s ] [2026-01-09T14:39:49+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-09 14:34:49' LIMIT 1 [ RunTime:0.000384s ] [2026-01-09T14:39:50+08:00][sql] CONNECT:[ UseTime:0.011324s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:39:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001330s ] [2026-01-09T14:39:50+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-09T14:39:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001177s ] [2026-01-09T14:39:50+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-09 13:34:50' AND '2026-01-09 14:34:50' AND `specuser` = '' LIMIT 1 [ RunTime:0.000433s ] [2026-01-09T14:39:50+08:00][sql] CONNECT:[ UseTime:0.010980s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:39:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001310s ] [2026-01-09T14:39:50+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.000365s ] [2026-01-09T14:39:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001171s ] [2026-01-09T14:39:50+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-09 14:34:50' LIMIT 1 [ RunTime:0.000425s ] [2026-01-09T14:39:51+08:00][sql] CONNECT:[ UseTime:0.011411s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:39:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001315s ] [2026-01-09T14:39: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.000382s ] [2026-01-09T14:39:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001196s ] [2026-01-09T14:39:51+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-09 14:34:51' LIMIT 1 [ RunTime:0.000414s ] [2026-01-09T14:41:33+08:00][sql] CONNECT:[ UseTime:0.011367s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:41:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001319s ] [2026-01-09T14:41:33+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000382s ] [2026-01-09T14:41:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001197s ] [2026-01-09T14:41:33+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-09 13:36:33' AND '2026-01-09 14:36:33' AND `specuser` = '' LIMIT 1 [ RunTime:0.000425s ] [2026-01-09T14:41:33+08:00][sql] CONNECT:[ UseTime:0.001486s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:41:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001354s ] [2026-01-09T14:41:33+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.000466s ] [2026-01-09T14:41:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001259s ] [2026-01-09T14:41:33+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-09 14:36:33' LIMIT 1 [ RunTime:0.000462s ] [2026-01-09T14:50:48+08:00][sql] CONNECT:[ UseTime:0.001581s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:50:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001485s ] [2026-01-09T14:50:48+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.000431s ] [2026-01-09T14:50:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001209s ] [2026-01-09T14:50:48+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-09 13:45:48' AND '2026-01-09 14:45:48' AND `specuser` = '' LIMIT 1 [ RunTime:0.000417s ] [2026-01-09T14:50:48+08:00][sql] CONNECT:[ UseTime:0.011350s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:50:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001337s ] [2026-01-09T14:50:48+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-09T14:50:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001190s ] [2026-01-09T14:50:48+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-09 14:45:48' LIMIT 1 [ RunTime:0.000384s ] [2026-01-09T14:50:49+08:00][sql] CONNECT:[ UseTime:0.011085s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:50:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001228s ] [2026-01-09T14:50:49+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.000451s ] [2026-01-09T14:50:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001155s ] [2026-01-09T14:50:49+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-09 13:45:49' AND '2026-01-09 14:45:49' AND `specuser` = '' LIMIT 1 [ RunTime:0.000469s ] [2026-01-09T14:50:49+08:00][sql] CONNECT:[ UseTime:0.010986s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:50:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001220s ] [2026-01-09T14:50:49+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.000441s ] [2026-01-09T14:50:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001105s ] [2026-01-09T14:50:49+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-09 14:45:49' LIMIT 1 [ RunTime:0.000387s ] [2026-01-09T14:50:50+08:00][sql] CONNECT:[ UseTime:0.011163s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:50:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001232s ] [2026-01-09T14:50:50+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.000376s ] [2026-01-09T14:50:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001141s ] [2026-01-09T14:50:50+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-09 14:45:50' LIMIT 1 [ RunTime:0.000387s ] [2026-01-09T14:50:50+08:00][sql] CONNECT:[ UseTime:0.011071s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:50:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001220s ] [2026-01-09T14:50:50+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.000367s ] [2026-01-09T14:50:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001163s ] [2026-01-09T14:50:50+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-09 14:45:50' LIMIT 1 [ RunTime:0.000408s ] [2026-01-09T14:50:51+08:00][sql] CONNECT:[ UseTime:0.011169s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:50:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001333s ] [2026-01-09T14:50: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.000372s ] [2026-01-09T14:50:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001193s ] [2026-01-09T14:50:51+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-09 14:45:51' LIMIT 1 [ RunTime:0.000431s ] [2026-01-09T14:52:13+08:00][sql] CONNECT:[ UseTime:0.010852s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:52:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001257s ] [2026-01-09T14:52: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.000400s ] [2026-01-09T14:52:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001129s ] [2026-01-09T14:52:13+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-09 13:47:13' AND '2026-01-09 14:47:13' AND `specuser` = '' LIMIT 1 [ RunTime:0.000462s ] [2026-01-09T14:52:14+08:00][sql] CONNECT:[ UseTime:0.010837s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:52:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001238s ] [2026-01-09T14:52:14+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.000378s ] [2026-01-09T14:52:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001124s ] [2026-01-09T14:52:14+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-09 14:47:14' LIMIT 1 [ RunTime:0.000385s ] [2026-01-09T14:52:34+08:00][sql] CONNECT:[ UseTime:0.011408s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:52:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001231s ] [2026-01-09T14:52:34+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.000381s ] [2026-01-09T14:52:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000949s ] [2026-01-09T14:52:34+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000203s ] [2026-01-09T14:52:35+08:00][sql] CONNECT:[ UseTime:0.011143s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:52:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001437s ] [2026-01-09T14:52:35+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000452s ] [2026-01-09T14:52:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001126s ] [2026-01-09T14:52:35+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '230a289f190b079d7a6bbc0163bc182b' AND `status` = 1 LIMIT 1 [ RunTime:0.000349s ] [2026-01-09T14:52:35+08:00][sql] CONNECT:[ UseTime:0.010900s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:52:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001213s ] [2026-01-09T14:52: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.000457s ] [2026-01-09T14:52:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001238s ] [2026-01-09T14:52:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-09 13:47:35' AND '2026-01-09 14:47:35' AND `specuser` = '' LIMIT 1 [ RunTime:0.000365s ] [2026-01-09T14:53:08+08:00][sql] CONNECT:[ UseTime:0.001538s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:53:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001417s ] [2026-01-09T14:53: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.000428s ] [2026-01-09T14:53:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001306s ] [2026-01-09T14:53:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:48:08' LIMIT 1 [ RunTime:0.000360s ] [2026-01-09T14:53:08+08:00][sql] CONNECT:[ UseTime:0.001434s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:53:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001271s ] [2026-01-09T14:53: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.000393s ] [2026-01-09T14:53:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001171s ] [2026-01-09T14:53:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-09 13:48:08' AND '2026-01-09 14:48:08' AND `specuser` = '' LIMIT 1 [ RunTime:0.000368s ] [2026-01-09T14:53:08+08:00][sql] CONNECT:[ UseTime:0.011331s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:53:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001345s ] [2026-01-09T14:53: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.000397s ] [2026-01-09T14:53:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001287s ] [2026-01-09T14:53:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:48:08' LIMIT 1 [ RunTime:0.000394s ] [2026-01-09T14:54:56+08:00][sql] CONNECT:[ UseTime:0.011497s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:54:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001412s ] [2026-01-09T14:54:56+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.000429s ] [2026-01-09T14:54:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001251s ] [2026-01-09T14:54:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-09 13:49:56' AND '2026-01-09 14:49:56' AND `specuser` = '' LIMIT 1 [ RunTime:0.000366s ] [2026-01-09T14:54:56+08:00][sql] CONNECT:[ UseTime:0.011596s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:54:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001296s ] [2026-01-09T14:54:56+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-09T14:54:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001163s ] [2026-01-09T14:54:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:49:56' LIMIT 1 [ RunTime:0.000349s ] [2026-01-09T14:55:00+08:00][sql] CONNECT:[ UseTime:0.010343s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001344s ] [2026-01-09T14:55:00+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.000386s ] [2026-01-09T14:55:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001205s ] [2026-01-09T14:55:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-09 13:50:00' AND '2026-01-09 14:50:00' AND `specuser` = '' LIMIT 1 [ RunTime:0.000378s ] [2026-01-09T14:55:00+08:00][sql] CONNECT:[ UseTime:0.011536s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001315s ] [2026-01-09T14:55:00+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-09T14:55:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001178s ] [2026-01-09T14:55:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-09 13:50:00' AND '2026-01-09 14:50:00' AND `specuser` = '' LIMIT 1 [ RunTime:0.000380s ] [2026-01-09T14:55:01+08:00][sql] CONNECT:[ UseTime:0.001535s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001313s ] [2026-01-09T14:55:01+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.000413s ] [2026-01-09T14:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001257s ] [2026-01-09T14:55:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:50:01' LIMIT 1 [ RunTime:0.000374s ] [2026-01-09T14:55:01+08:00][sql] CONNECT:[ UseTime:0.001410s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001319s ] [2026-01-09T14:55:01+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-09T14:55:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001255s ] [2026-01-09T14:55:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:50:01' LIMIT 1 [ RunTime:0.000392s ] [2026-01-09T14:55:02+08:00][sql] CONNECT:[ UseTime:0.001856s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001943s ] [2026-01-09T14:55:02+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.000509s ] [2026-01-09T14:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001692s ] [2026-01-09T14:55:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-09 13:50:02' AND '2026-01-09 14:50:02' AND `specuser` = '' LIMIT 1 [ RunTime:0.000663s ] [2026-01-09T14:55:02+08:00][sql] CONNECT:[ UseTime:0.001478s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001370s ] [2026-01-09T14:55:02+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.000453s ] [2026-01-09T14:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001247s ] [2026-01-09T14:55:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-09 13:50:02' AND '2026-01-09 14:50:02' AND `specuser` = '' LIMIT 1 [ RunTime:0.000420s ] [2026-01-09T14:55:02+08:00][sql] CONNECT:[ UseTime:0.011569s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001263s ] [2026-01-09T14:55:02+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.000405s ] [2026-01-09T14:55:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001179s ] [2026-01-09T14:55:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:50:02' LIMIT 1 [ RunTime:0.000354s ] [2026-01-09T14:55:03+08:00][sql] CONNECT:[ UseTime:0.001446s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001323s ] [2026-01-09T14:55: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.000450s ] [2026-01-09T14:55:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001229s ] [2026-01-09T14:55:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:50:03' LIMIT 1 [ RunTime:0.000432s ] [2026-01-09T14:55:03+08:00][sql] CONNECT:[ UseTime:0.001430s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001274s ] [2026-01-09T14:55: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.000397s ] [2026-01-09T14:55:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001161s ] [2026-01-09T14:55:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:50:03' LIMIT 1 [ RunTime:0.000372s ] [2026-01-09T14:55:04+08:00][sql] CONNECT:[ UseTime:0.011451s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001378s ] [2026-01-09T14:55: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.000387s ] [2026-01-09T14:55:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001234s ] [2026-01-09T14:55:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-09 13:50:04' AND '2026-01-09 14:50:04' AND `specuser` = '' LIMIT 1 [ RunTime:0.000389s ] [2026-01-09T14:55:04+08:00][sql] CONNECT:[ UseTime:0.011267s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001271s ] [2026-01-09T14:55: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.000398s ] [2026-01-09T14:55:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001176s ] [2026-01-09T14:55:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-09 13:50:04' AND '2026-01-09 14:50:04' AND `specuser` = '' LIMIT 1 [ RunTime:0.000363s ] [2026-01-09T14:55:04+08:00][sql] CONNECT:[ UseTime:0.010918s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001257s ] [2026-01-09T14:55: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.000476s ] [2026-01-09T14:55:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001231s ] [2026-01-09T14:55:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:50:04' LIMIT 1 [ RunTime:0.000376s ] [2026-01-09T14:55:05+08:00][sql] CONNECT:[ UseTime:0.001432s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001341s ] [2026-01-09T14:55:05+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.000421s ] [2026-01-09T14:55:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001223s ] [2026-01-09T14:55:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:50:05' LIMIT 1 [ RunTime:0.000354s ] [2026-01-09T14:55:05+08:00][sql] CONNECT:[ UseTime:0.010911s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001362s ] [2026-01-09T14:55:05+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.000406s ] [2026-01-09T14:55:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001206s ] [2026-01-09T14:55:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-09 13:50:05' AND '2026-01-09 14:50:05' AND `specuser` = '' LIMIT 1 [ RunTime:0.000353s ] [2026-01-09T14:55:06+08:00][sql] CONNECT:[ UseTime:0.010951s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001357s ] [2026-01-09T14:55: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.000446s ] [2026-01-09T14:55:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001222s ] [2026-01-09T14:55:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` BETWEEN '2026-01-09 13:50:06' AND '2026-01-09 14:50:06' AND `specuser` = '' LIMIT 1 [ RunTime:0.000387s ] [2026-01-09T14:55:06+08:00][sql] CONNECT:[ UseTime:0.010877s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001308s ] [2026-01-09T14:55: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.000378s ] [2026-01-09T14:55:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001162s ] [2026-01-09T14:55:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:50:06' LIMIT 1 [ RunTime:0.000355s ] [2026-01-09T14:55:06+08:00][sql] CONNECT:[ UseTime:0.001525s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001431s ] [2026-01-09T14:55: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.000419s ] [2026-01-09T14:55:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001198s ] [2026-01-09T14:55:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `pay_status` = 0 AND `trade_status` IN (1,2) AND `created_at` >= '2026-01-09 14:50:06' LIMIT 1 [ RunTime:0.000361s ] [2026-01-09T14:55:15+08:00][sql] CONNECT:[ UseTime:0.011575s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001295s ] [2026-01-09T14:55:15+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.000420s ] [2026-01-09T14:55:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001022s ] [2026-01-09T14:55:15+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000230s ] [2026-01-09T14:55:17+08:00][sql] CONNECT:[ UseTime:0.010566s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001417s ] [2026-01-09T14:55:17+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000485s ] [2026-01-09T14:55:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001114s ] [2026-01-09T14:55:17+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '5049a55a206d441ab03568ce2b48bcc4' AND `status` = 1 LIMIT 1 [ RunTime:0.000353s ] [2026-01-09T14:55:17+08:00][sql] CONNECT:[ UseTime:0.010187s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001117s ] [2026-01-09T14:55:17+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-09T14:55:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001159s ] [2026-01-09T14:55:17+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-09 13:50:17' AND '2026-01-09 14:50:17' AND `specuser` = '' LIMIT 1 [ RunTime:0.000444s ] [2026-01-09T14:55:17+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-09 13:50:17' AND '2026-01-09 14:50:17' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000460s ] [2026-01-09T14:55:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000899s ] [2026-01-09T14:55:17+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 GROUP BY `tid` [ RunTime:0.000308s ] [2026-01-09T14:55:17+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000894s ] [2026-01-09T14:55:17+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 155 [ RunTime:0.000243s ] [2026-01-09T14:55:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001020s ] [2026-01-09T14:55:19+08:00][sql] CONNECT:[ UseTime:0.011123s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001273s ] [2026-01-09T14:55:19+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.000404s ] [2026-01-09T14:55:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001189s ] [2026-01-09T14:55:19+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-09 14:50:19' LIMIT 1 [ RunTime:0.000422s ] [2026-01-09T14:55:20+08:00][sql] CONNECT:[ UseTime:0.011329s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001372s ] [2026-01-09T14:55:20+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000372s ] [2026-01-09T14:55:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001229s ] [2026-01-09T14:55:20+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-09 13:50:20' AND '2026-01-09 14:50:20' AND `specuser` = '' LIMIT 1 [ RunTime:0.000442s ] [2026-01-09T14:55:20+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-09 13:50:20' AND '2026-01-09 14:50:20' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000473s ] [2026-01-09T14:55:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001004s ] [2026-01-09T14:55:20+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 GROUP BY `tid` [ RunTime:0.000305s ] [2026-01-09T14:55:20+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000980s ] [2026-01-09T14:55:20+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 155 [ RunTime:0.000232s ] [2026-01-09T14:55:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001116s ] [2026-01-09T14:55:22+08:00][sql] CONNECT:[ UseTime:0.001470s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001329s ] [2026-01-09T14: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.000456s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001264s ] [2026-01-09T14:55:22+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` = 87 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000302s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001123s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001074s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001112s ] [2026-01-09T14:55:22+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` = 155 [ RunTime:0.000344s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001211s ] [2026-01-09T14:55:22+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` = 155 [ RunTime:0.000479s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001250s ] [2026-01-09T14:55:22+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.030305s ] [2026-01-09T14:55:22+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.041130s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001255s ] [2026-01-09T14:55:22+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 [ RunTime:0.001895s ] [2026-01-09T14:55:22+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.042248s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001559s ] [2026-01-09T14:55:22+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` = 155 [ RunTime:0.000371s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001113s ] [2026-01-09T14:55:22+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` = 155 [ RunTime:0.000371s ] [2026-01-09T14:55:22+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 155 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000244s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.001086s ] [2026-01-09T14:55:22+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 155 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000331s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000906s ] [2026-01-09T14:55:22+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` = 155 [ RunTime:0.000340s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000870s ] [2026-01-09T14:55:22+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.000476s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000940s ] [2026-01-09T14:55:22+08:00][sql] SELECT `tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 [ RunTime:0.000464s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001084s ] [2026-01-09T14:55:22+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 (2,5,6,8,9,16,17,31,32,33,34,40,43,44,45,46,47,48,52,53,54,55,60,61,62,63,66,67,68,69,70,71,76,79,81,82,83,86,87,88,89,94,95,100,101,102,105,106,111,113,114,115,116,117,118,119,123,125,126,127,128,129,132,134,135,136,137,140,141,144,146,151,152,153,155,158,161,162,163,164,165,166,168,169,171,172,174,175,176,179,182,183,186,187,188,191) [ RunTime:0.001658s ] [2026-01-09T14:55:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000920s ] [2026-01-09T14:55:40+08:00][sql] CONNECT:[ UseTime:0.011492s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001364s ] [2026-01-09T14:55:40+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.000408s ] [2026-01-09T14:55:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001214s ] [2026-01-09T14:55:40+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-09 14:50:40' LIMIT 1 [ RunTime:0.000437s ] [2026-01-09T14:55:41+08:00][sql] CONNECT:[ UseTime:0.001461s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001270s ] [2026-01-09T14:55:41+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-09T14:55:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001182s ] [2026-01-09T14:55:41+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-09 13:50:41' AND '2026-01-09 14:50:41' AND `specuser` = '' LIMIT 1 [ RunTime:0.000558s ] [2026-01-09T14:55:41+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-09 13:50:41' AND '2026-01-09 14:50:41' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000433s ] [2026-01-09T14:55:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001043s ] [2026-01-09T14:55:41+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 GROUP BY `tid` [ RunTime:0.000291s ] [2026-01-09T14:55:41+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000938s ] [2026-01-09T14:55:41+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 155 [ RunTime:0.000228s ] [2026-01-09T14:55:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001014s ] [2026-01-09T14:55:42+08:00][sql] CONNECT:[ UseTime:0.001458s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001402s ] [2026-01-09T14:55: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.000378s ] [2026-01-09T14:55:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001210s ] [2026-01-09T14:55:42+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-09 14:50:42' LIMIT 1 [ RunTime:0.000465s ] [2026-01-09T14:55:43+08:00][sql] CONNECT:[ UseTime:0.011456s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001311s ] [2026-01-09T14:55:43+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-09T14:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001180s ] [2026-01-09T14:55:43+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-09 13:50:43' AND '2026-01-09 14:50:43' AND `specuser` = '' LIMIT 1 [ RunTime:0.000421s ] [2026-01-09T14:55:43+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-09 13:50:43' AND '2026-01-09 14:50:43' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000438s ] [2026-01-09T14:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000883s ] [2026-01-09T14:55:43+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 GROUP BY `tid` [ RunTime:0.000302s ] [2026-01-09T14:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000902s ] [2026-01-09T14:55:43+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 155 [ RunTime:0.000253s ] [2026-01-09T14:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001033s ] [2026-01-09T14:55:44+08:00][sql] CONNECT:[ UseTime:0.011001s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001413s ] [2026-01-09T14:55:44+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.000422s ] [2026-01-09T14:55:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001257s ] [2026-01-09T14:55:44+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-09 14:50:44' LIMIT 1 [ RunTime:0.000480s ] [2026-01-09T14:55:45+08:00][sql] CONNECT:[ UseTime:0.001410s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001286s ] [2026-01-09T14:55:45+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.000406s ] [2026-01-09T14:55:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001175s ] [2026-01-09T14:55:45+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-09 13:50:45' AND '2026-01-09 14:50:45' AND `specuser` = '' LIMIT 1 [ RunTime:0.000419s ] [2026-01-09T14:55:45+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-09 13:50:45' AND '2026-01-09 14:50:45' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000423s ] [2026-01-09T14:55:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001029s ] [2026-01-09T14:55:45+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 GROUP BY `tid` [ RunTime:0.000298s ] [2026-01-09T14:55:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000919s ] [2026-01-09T14:55:45+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` = 155 [ RunTime:0.000220s ] [2026-01-09T14:55:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000993s ] [2026-01-09T14:55:49+08:00][sql] CONNECT:[ UseTime:0.001398s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001286s ] [2026-01-09T14:55:49+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.000396s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001163s ] [2026-01-09T14:55:49+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` = 87 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000307s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001049s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000950s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001063s ] [2026-01-09T14:55:49+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` = 155 [ RunTime:0.000345s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001161s ] [2026-01-09T14:55:49+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` = 155 [ RunTime:0.000452s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001142s ] [2026-01-09T14:55:49+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.029682s ] [2026-01-09T14:55:49+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.039836s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000956s ] [2026-01-09T14:55:49+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 [ RunTime:0.001735s ] [2026-01-09T14:55:49+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.040138s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001208s ] [2026-01-09T14:55:49+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` = 155 [ RunTime:0.000343s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000996s ] [2026-01-09T14:55:49+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` = 155 [ RunTime:0.000326s ] [2026-01-09T14:55:49+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 155 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000233s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000847s ] [2026-01-09T14:55:49+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 155 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000285s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000913s ] [2026-01-09T14:55:49+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` = 155 [ RunTime:0.000301s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000895s ] [2026-01-09T14:55:49+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.000514s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000935s ] [2026-01-09T14:55:49+08:00][sql] SELECT `tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 [ RunTime:0.000469s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001075s ] [2026-01-09T14:55:49+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 (2,5,6,8,9,16,17,31,32,33,34,40,43,44,45,46,47,48,52,53,54,55,60,61,62,63,66,67,68,69,70,71,76,79,81,82,83,86,87,88,89,94,95,100,101,102,105,106,111,113,114,115,116,117,118,119,123,125,126,127,128,129,132,134,135,136,137,140,141,144,146,151,152,153,155,158,161,162,163,164,165,166,168,169,171,172,174,175,176,179,182,183,186,187,188,191) [ RunTime:0.001753s ] [2026-01-09T14:55:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000956s ] [2026-01-09T15:02:16+08:00][sql] CONNECT:[ UseTime:0.001404s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T15:02:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001249s ] [2026-01-09T15:02:16+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.000426s ] [2026-01-09T15:02:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001010s ] [2026-01-09T15:02:16+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000236s ] [2026-01-09T15:02:18+08:00][sql] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T15:02:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001398s ] [2026-01-09T15:02:18+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.000477s ] [2026-01-09T15:02:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001140s ] [2026-01-09T15:02:18+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '5049a55a206d441ab03568ce2b48bcc4' AND `status` = 1 LIMIT 1 [ RunTime:0.000304s ] [2026-01-09T15:02:18+08:00][sql] CONNECT:[ UseTime:0.011481s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T15:02:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001088s ] [2026-01-09T15:02:18+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = 'shaiya' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000371s ] [2026-01-09T15:02:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001104s ] [2026-01-09T15:02:18+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-09 13:57:18' AND '2026-01-09 14:57:18' AND `specuser` = '' LIMIT 1 [ RunTime:0.000454s ] [2026-01-09T15:02:18+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-09 13:57:18' AND '2026-01-09 14:57:18' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000424s ] [2026-01-09T15:02:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000885s ] [2026-01-09T15:02:18+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` IN (156,155) GROUP BY `tid` [ RunTime:0.000308s ] [2026-01-09T15:02:18+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000855s ] [2026-01-09T15:02:18+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (156,155) [ RunTime:0.000250s ] [2026-01-09T15:02:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.000992s ] [2026-01-09T15:02:21+08:00][sql] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001431s ] [2026-01-09T15:02:21+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.000381s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001267s ] [2026-01-09T15:02:21+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.000369s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001129s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000978s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001135s ] [2026-01-09T15:02:21+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.000400s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001202s ] [2026-01-09T15:02:21+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.000459s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001206s ] [2026-01-09T15:02:21+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.030450s ] [2026-01-09T15:02:21+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.040817s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001052s ] [2026-01-09T15:02:21+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.001908s ] [2026-01-09T15:02:21+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.041101s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001378s ] [2026-01-09T15:02:21+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.000385s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001059s ] [2026-01-09T15:02:21+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.000323s ] [2026-01-09T15:02:21+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000281s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000902s ] [2026-01-09T15:02:21+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000275s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000957s ] [2026-01-09T15:02:21+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.000293s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000821s ] [2026-01-09T15:02:21+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.000543s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000953s ] [2026-01-09T15:02:21+08:00][sql] SELECT `tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000521s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001108s ] [2026-01-09T15:02:21+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 (1,3,4,6,7,17,18,19,28,29,30,37,38,39,40,41,43,44,45,46,47,48,49,50,54,55,60,61,62,63,64,65,68,69,70,71,72,74,76,81,82,83,86,87,88,89,90,91,92,93,94,95,98,100,101,102,103,104,105,106,111,112,113,119,120,121,122,126,127,128,129,132,133,134,136,137,141,142,143,144,145,147,154,156,158,161,162,163,164,165,166,168,169,171,172,175,176,179,180,181,182,186) [ RunTime:0.001890s ] [2026-01-09T15:02:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001009s ] [2026-01-09T15:04:00+08:00][sql] CONNECT:[ UseTime:0.011287s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T15:04:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001313s ] [2026-01-09T15:04:00+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.000396s ] [2026-01-09T15:04:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001173s ] [2026-01-09T15:04:00+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-09 13:59:00' AND '2026-01-09 14:59:00' AND `specuser` = '' LIMIT 1 [ RunTime:0.000407s ] [2026-01-09T15:04:00+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-09 13:59:00' AND '2026-01-09 14:59:00' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000469s ] [2026-01-09T15:04:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000963s ] [2026-01-09T15:04:00+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` IN (156,155) GROUP BY `tid` [ RunTime:0.000315s ] [2026-01-09T15:04:00+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001211s ] [2026-01-09T15:04:00+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (156,155) [ RunTime:0.000265s ] [2026-01-09T15:04:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001137s ] [2026-01-09T15:04:01+08:00][sql] CONNECT:[ UseTime:0.001520s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T15:04:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001489s ] [2026-01-09T15:04:01+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.000371s ] [2026-01-09T15:04:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001288s ] [2026-01-09T15:04:01+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-09 14:59:01' LIMIT 1 [ RunTime:0.000461s ] [2026-01-09T15:04:02+08:00][sql] CONNECT:[ UseTime:0.001722s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T15:04:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001060s ] [2026-01-09T15:04:02+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.000482s ] [2026-01-09T15:04:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001171s ] [2026-01-09T15:04:02+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-09 13:59:02' AND '2026-01-09 14:59:02' AND `specuser` = '' LIMIT 1 [ RunTime:0.000409s ] [2026-01-09T15:04:02+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-09 13:59:02' AND '2026-01-09 14:59:02' AND `specuser` = '' ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000448s ] [2026-01-09T15:04:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000950s ] [2026-01-09T15:04:02+08:00][sql] SELECT `tid`,count(1) as num FROM `trade_collect` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` IN (156,155) GROUP BY `tid` [ RunTime:0.000343s ] [2026-01-09T15:04:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000940s ] [2026-01-09T15:04:02+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (156,155) [ RunTime:0.000236s ] [2026-01-09T15:04:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001020s ] [2026-01-09T15:04:06+08:00][sql] CONNECT:[ UseTime:0.001520s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001287s ] [2026-01-09T15:04: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.000404s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001189s ] [2026-01-09T15:04: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` = 88 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000323s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001112s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000953s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001074s ] [2026-01-09T15:04: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` = 156 [ RunTime:0.000361s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001181s ] [2026-01-09T15:04: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` = 156 [ RunTime:0.000454s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001194s ] [2026-01-09T15:04:06+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.030562s ] [2026-01-09T15:04: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 (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.041875s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001065s ] [2026-01-09T15:04:06+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.001736s ] [2026-01-09T15:04: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 (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.042529s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001374s ] [2026-01-09T15:04: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` = 156 [ RunTime:0.000378s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001047s ] [2026-01-09T15:04: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` = 156 [ RunTime:0.000322s ] [2026-01-09T15:04:06+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000236s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000870s ] [2026-01-09T15:04:06+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000361s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000955s ] [2026-01-09T15:04: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` = 156 [ RunTime:0.000430s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000835s ] [2026-01-09T15:04: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 (18,33,51,118,133,151,218,233,251) [ RunTime:0.000489s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000902s ] [2026-01-09T15:04:06+08:00][sql] SELECT `tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000569s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001104s ] [2026-01-09T15:04: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 (1,3,4,6,7,17,18,19,28,29,30,37,38,39,40,41,43,44,45,46,47,48,49,50,54,55,60,61,62,63,64,65,68,69,70,71,72,74,76,81,82,83,86,87,88,89,90,91,92,93,94,95,98,100,101,102,103,104,105,106,111,112,113,119,120,121,122,126,127,128,129,132,133,134,136,137,141,142,143,144,145,147,154,156,158,161,162,163,164,165,166,168,169,171,172,175,176,179,180,181,182,186) [ RunTime:0.001755s ] [2026-01-09T15:04:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000992s ] [2026-01-09T15:04:21+08:00][sql] CONNECT:[ UseTime:0.011190s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001330s ] [2026-01-09T15:04:21+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-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001255s ] [2026-01-09T15:04:21+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` = 87 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000375s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001125s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000993s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001148s ] [2026-01-09T15:04:21+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` = 155 [ RunTime:0.000364s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001215s ] [2026-01-09T15:04:21+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` = 155 [ RunTime:0.000503s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001246s ] [2026-01-09T15:04:21+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.030354s ] [2026-01-09T15:04:21+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.040895s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001071s ] [2026-01-09T15:04:21+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 [ RunTime:0.001835s ] [2026-01-09T15:04:21+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.041274s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001346s ] [2026-01-09T15:04:21+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` = 155 [ RunTime:0.000363s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001047s ] [2026-01-09T15:04:21+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` = 155 [ RunTime:0.000309s ] [2026-01-09T15:04:21+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 155 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000293s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000950s ] [2026-01-09T15:04:21+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 155 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000278s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000960s ] [2026-01-09T15:04:21+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` = 155 [ RunTime:0.000306s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000910s ] [2026-01-09T15:04:21+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.000518s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000979s ] [2026-01-09T15:04:21+08:00][sql] SELECT `tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 [ RunTime:0.000531s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001155s ] [2026-01-09T15:04:21+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 (2,5,6,8,9,16,17,31,32,33,34,40,43,44,45,46,47,48,52,53,54,55,60,61,62,63,66,67,68,69,70,71,76,79,81,82,83,86,87,88,89,94,95,100,101,102,105,106,111,113,114,115,116,117,118,119,123,125,126,127,128,129,132,134,135,136,137,140,141,144,146,151,152,153,155,158,161,162,163,164,165,166,168,169,171,172,174,175,176,179,182,183,186,187,188,191) [ RunTime:0.001718s ] [2026-01-09T15:04:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001019s ] [2026-01-09T16:14:31+08:00][sql] CONNECT:[ UseTime:0.001800s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001364s ] [2026-01-09T16:14:31+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-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001203s ] [2026-01-09T16:14:31+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.000307s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001089s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001003s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001087s ] [2026-01-09T16:14:31+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.000334s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001145s ] [2026-01-09T16:14:31+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.000448s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001176s ] [2026-01-09T16:14:31+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.030394s ] [2026-01-09T16:14:31+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.041385s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001042s ] [2026-01-09T16:14:31+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.001780s ] [2026-01-09T16:14:31+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.041872s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001256s ] [2026-01-09T16:14:31+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.000366s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000986s ] [2026-01-09T16:14:31+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.000360s ] [2026-01-09T16:14:31+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000238s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000877s ] [2026-01-09T16:14:31+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000309s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000919s ] [2026-01-09T16:14:31+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.000362s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000830s ] [2026-01-09T16:14:31+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.000387s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000905s ] [2026-01-09T16:14:31+08:00][sql] SELECT `tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000464s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001088s ] [2026-01-09T16:14:31+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 (1,3,4,6,7,17,18,19,28,29,30,37,38,39,40,41,43,44,45,46,47,48,49,50,54,55,60,61,62,63,64,65,68,69,70,71,72,74,76,81,82,83,86,87,88,89,90,91,92,93,94,95,98,100,101,102,103,104,105,106,111,112,113,119,120,121,122,126,127,128,129,132,133,134,136,137,141,142,143,144,145,147,154,156,158,161,162,163,164,165,166,168,169,171,172,175,176,179,180,181,182,186) [ RunTime:0.001906s ] [2026-01-09T16:14:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000968s ] [2026-01-09T16:15:22+08:00][sql] CONNECT:[ UseTime:0.001424s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001376s ] [2026-01-09T16:15: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.000443s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001271s ] [2026-01-09T16:15:22+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.000306s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001137s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001038s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001115s ] [2026-01-09T16:15:22+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.000365s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001240s ] [2026-01-09T16:15:22+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.000453s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001219s ] [2026-01-09T16:15:22+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.030471s ] [2026-01-09T16:15:22+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.042075s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001189s ] [2026-01-09T16:15:22+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-09T16:15:22+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.041721s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001511s ] [2026-01-09T16:15:22+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.000365s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001057s ] [2026-01-09T16:15:22+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.000314s ] [2026-01-09T16:15:22+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000245s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000900s ] [2026-01-09T16:15:22+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000275s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000932s ] [2026-01-09T16:15:22+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.000308s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000864s ] [2026-01-09T16:15:22+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.000474s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000875s ] [2026-01-09T16:15:22+08:00][sql] SELECT `attr_tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000471s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001060s ] [2026-01-09T16:15:22+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.001230s ] [2026-01-09T16:15:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000934s ] [2026-01-09T16:22:54+08:00][sql] CONNECT:[ UseTime:0.001499s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001309s ] [2026-01-09T16:22: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.000400s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001209s ] [2026-01-09T16:22: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` = 87 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000370s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001070s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001016s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001089s ] [2026-01-09T16:22: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` = 155 [ RunTime:0.000361s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001165s ] [2026-01-09T16:22: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` = 155 [ RunTime:0.000478s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001198s ] [2026-01-09T16:22:54+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.030499s ] [2026-01-09T16:22: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 (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.041414s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001095s ] [2026-01-09T16:22:54+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 [ RunTime:0.001814s ] [2026-01-09T16:22: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 (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.042164s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001326s ] [2026-01-09T16:22: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` = 155 [ RunTime:0.000330s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001046s ] [2026-01-09T16:22: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` = 155 [ RunTime:0.000296s ] [2026-01-09T16:22:54+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 155 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000241s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000872s ] [2026-01-09T16:22:54+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 155 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000271s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000941s ] [2026-01-09T16:22: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` = 155 [ RunTime:0.000294s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000852s ] [2026-01-09T16:22: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 (15,31,51,115,131,201,231,249,255) [ RunTime:0.000475s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000956s ] [2026-01-09T16:22:54+08:00][sql] SELECT `attr_tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 [ RunTime:0.000450s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001084s ] [2026-01-09T16:22: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 (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.001162s ] [2026-01-09T16:22:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000959s ] [2026-01-09T16:24:21+08:00][sql] CONNECT:[ UseTime:0.011007s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:24:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001411s ] [2026-01-09T16:24:21+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.000422s ] [2026-01-09T16:24:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001366s ] [2026-01-09T16:24:21+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-09 15:19:21' AND '2026-01-09 16:19:21' AND `specuser` = '' LIMIT 1 [ RunTime:0.000517s ] [2026-01-09T16:24:22+08:00][sql] CONNECT:[ UseTime:0.011195s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:24:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001284s ] [2026-01-09T16:24: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.000402s ] [2026-01-09T16:24:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001157s ] [2026-01-09T16:24: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-09 16:19:22' LIMIT 1 [ RunTime:0.000406s ] [2026-01-09T16:46:16+08:00][sql] CONNECT:[ UseTime:0.001527s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:46:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001462s ] [2026-01-09T16:46:16+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.000421s ] [2026-01-09T16:46:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001116s ] [2026-01-09T16:46:16+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000216s ] [2026-01-09T16:48:43+08:00][sql] CONNECT:[ UseTime:0.011431s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:48:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001340s ] [2026-01-09T16:48:43+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000397s ] [2026-01-09T16:48:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001013s ] [2026-01-09T16:48:43+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000207s ] [2026-01-09T16:48:45+08:00][sql] CONNECT:[ UseTime:0.010384s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:48:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001581s ] [2026-01-09T16:48:45+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.000481s ] [2026-01-09T16:48:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001101s ] [2026-01-09T16:48:45+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '5049a55a206d441ab03568ce2b48bcc4' AND `status` = 1 LIMIT 1 [ RunTime:0.000322s ] [2026-01-09T16:48:45+08:00][sql] CONNECT:[ UseTime:0.010450s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:48:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001145s ] [2026-01-09T16:48:45+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-09T16:48:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001184s ] [2026-01-09T16:48:45+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-09 15:43:45' AND '2026-01-09 16:43:45' AND `specuser` = '' LIMIT 1 [ RunTime:0.000439s ] [2026-01-09T16:48:47+08:00][sql] CONNECT:[ UseTime:0.011218s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:48:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001298s ] [2026-01-09T16:48:47+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-09T16:48:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001180s ] [2026-01-09T16:48:47+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-09 16:43:47' LIMIT 1 [ RunTime:0.000406s ] [2026-01-09T16:48:55+08:00][sql] CONNECT:[ UseTime:0.001455s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001298s ] [2026-01-09T16:48:55+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-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001182s ] [2026-01-09T16:48:55+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.000326s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001102s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000992s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001255s ] [2026-01-09T16:48:55+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.000361s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001169s ] [2026-01-09T16:48:55+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.000472s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001186s ] [2026-01-09T16:48:55+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.030474s ] [2026-01-09T16:48:55+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.041183s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000935s ] [2026-01-09T16:48:55+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.001762s ] [2026-01-09T16:48:55+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.041534s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001224s ] [2026-01-09T16:48:55+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.000339s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001015s ] [2026-01-09T16:48:55+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.000300s ] [2026-01-09T16:48:55+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000230s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000880s ] [2026-01-09T16:48:55+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 156 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000296s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000902s ] [2026-01-09T16:48:55+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.000341s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000835s ] [2026-01-09T16:48:55+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.000414s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000847s ] [2026-01-09T16:48:55+08:00][sql] SELECT `attr_tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 156 [ RunTime:0.000435s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001098s ] [2026-01-09T16:48:55+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.001100s ] [2026-01-09T16:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000940s ] [2026-01-09T16:49:07+08:00][sql] CONNECT:[ UseTime:0.011603s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001385s ] [2026-01-09T16:49: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.000424s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001350s ] [2026-01-09T16:49: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` = 87 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000321s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001168s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001079s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001188s ] [2026-01-09T16:49: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` = 155 [ RunTime:0.000431s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001237s ] [2026-01-09T16:49: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` = 155 [ RunTime:0.000512s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001246s ] [2026-01-09T16:49:07+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.030411s ] [2026-01-09T16:49: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 (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.041137s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001002s ] [2026-01-09T16:49:07+08:00][sql] SELECT `type`,`itemid`,`num`,`slot` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 [ RunTime:0.001799s ] [2026-01-09T16:49: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 (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.041569s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001235s ] [2026-01-09T16:49: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` = 155 [ RunTime:0.000357s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001010s ] [2026-01-09T16:49: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` = 155 [ RunTime:0.000294s ] [2026-01-09T16:49:07+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 155 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000235s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season` [ RunTime:0.000912s ] [2026-01-09T16:49:07+08:00][sql] SELECT `lv`,`seasonlv` FROM `trade_season` WHERE `tid` = 155 AND `game` = 'shaiya' AND `serverid` = 6 LIMIT 1 [ RunTime:0.000279s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_equip` [ RunTime:0.000931s ] [2026-01-09T16:49: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` = 155 [ RunTime:0.000311s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_effect` [ RunTime:0.000899s ] [2026-01-09T16:49: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 (15,31,51,115,131,201,231,249,255) [ RunTime:0.000377s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_tanent` [ RunTime:0.000909s ] [2026-01-09T16:49:07+08:00][sql] SELECT `attr_tanent_id` FROM `trade_season_tanent` WHERE `game` = 'shaiya' AND `serverid` = 6 AND `tid` = 155 [ RunTime:0.000404s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_season_skill` [ RunTime:0.001092s ] [2026-01-09T16:49: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 (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.001042s ] [2026-01-09T16:49:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000949s ] [2026-01-09T17:15:36+08:00][sql] CONNECT:[ UseTime:0.001491s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T17:15:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001452s ] [2026-01-09T17:15:36+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.000413s ] [2026-01-09T17:15:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001056s ] [2026-01-09T17:15:36+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000285s ] [2026-01-09T17:16:28+08:00][sql] CONNECT:[ UseTime:0.010384s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T17:16:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001508s ] [2026-01-09T17:16:28+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.000504s ] [2026-01-09T17:16:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001100s ] [2026-01-09T17:16:28+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000206s ] [2026-01-09T18:37:46+08:00][sql] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T18:37:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001321s ] [2026-01-09T18:37:46+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-09T18:37:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001036s ] [2026-01-09T18:37:46+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000214s ] [2026-01-09T19:17:52+08:00][sql] CONNECT:[ UseTime:0.011250s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T19:17:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001364s ] [2026-01-09T19:17:52+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.000475s ] [2026-01-09T19:17:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001068s ] [2026-01-09T19:17:52+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000225s ] [2026-01-09T19:32:20+08:00][sql] CONNECT:[ UseTime:0.001529s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2026-01-09T19:32:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001445s ] [2026-01-09T19:32: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.000457s ] [2026-01-09T19:32:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001066s ] [2026-01-09T19:32:20+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000202s ]