[2025-07-19T08:47:34+08:00][sql] CONNECT:[ UseTime:0.001559s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T08:47:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001306s ] [2025-07-19T08:47: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.000432s ] [2025-07-19T08:47:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001003s ] [2025-07-19T08:47:34+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000214s ] [2025-07-19T10:45:11+08:00][sql] CONNECT:[ UseTime:0.001522s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T10:45:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001304s ] [2025-07-19T10:45:11+08:00][sql] SELECT `mark`,`title`,`class` FROM `trade_help_article` WHERE `game` = '' AND `status` = 1 AND `cate_id` = 1 ORDER BY `sort` DESC [ RunTime:0.000417s ] [2025-07-19T10:45:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001037s ] [2025-07-19T10:45:11+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000209s ] [2025-07-19T14:44:45+08:00][sql] CONNECT:[ UseTime:0.001686s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T14:44:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001401s ] [2025-07-19T14:44: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.000405s ] [2025-07-19T14:44:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001067s ] [2025-07-19T14:44:45+08:00][sql] SELECT `code`,`name`,`game`,`serverid`,`servername`,`image`,`status` FROM `trade_game` [ RunTime:0.000244s ] [2025-07-19T14:44:48+08:00][sql] CONNECT:[ UseTime:0.011625s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T14:44:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001362s ] [2025-07-19T14:44: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.000433s ] [2025-07-19T14:44:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001085s ] [2025-07-19T14:44:48+08:00][sql] SELECT * FROM `trade_game` WHERE `code` = '230a289f190b079d7a6bbc0163bc182b' AND `status` = 1 LIMIT 1 [ RunTime:0.000327s ] [2025-07-19T14:44:48+08:00][sql] CONNECT:[ UseTime:0.011182s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T14:44:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001351s ] [2025-07-19T14:44: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.000434s ] [2025-07-19T14:44:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001275s ] [2025-07-19T14:44:48+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 '2025-07-19 13:39:48' AND '2025-07-19 14:39:48' AND `specuser` = '' LIMIT 1 [ RunTime:0.000457s ] [2025-07-19T14:44:50+08:00][sql] CONNECT:[ UseTime:0.010884s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T14:44:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001354s ] [2025-07-19T14:44: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.000396s ] [2025-07-19T14:44:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001198s ] [2025-07-19T14:44:50+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` >= '2025-07-19 14:39:50' LIMIT 1 [ RunTime:0.000375s ] [2025-07-19T14:44:55+08:00][sql] CONNECT:[ UseTime:0.011609s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T14:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001376s ] [2025-07-19T14:44: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.000408s ] [2025-07-19T14:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001196s ] [2025-07-19T14:44:55+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`job`,`grow`,`chaid`,`chaname`,`chalv`,`kill`,`family`,`price`,`created_at`,`trade_status`,`pay_status`,`money` FROM `trade_role` WHERE `id` = 1 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000330s ] [2025-07-19T14:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001204s ] [2025-07-19T14:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000973s ] [2025-07-19T14:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001082s ] [2025-07-19T14:44: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` = 1 AND `tid` = 1 [ RunTime:0.000345s ] [2025-07-19T14:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001197s ] [2025-07-19T14:44: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` = 1 AND `tid` = 1 [ RunTime:0.000438s ] [2025-07-19T14:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001141s ] [2025-07-19T14:44:55+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (30059,30024,30200,30250,30017,30025,30031,30045,30011,98001,30060,30046) [ RunTime:0.029306s ] [2025-07-19T14:44: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` = 1 AND `itemid` IN (16196,17211,18211,20212,21211,12110,23014,22025,40247,40205,120078,16168,17174,18067,20067,21068,12009,17189,18073,20073,21189,12019,23006,22007,40006) [ RunTime:0.041034s ] [2025-07-19T14:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001107s ] [2025-07-19T14:44:55+08:00][sql] SELECT `type`,`itemid`,`num` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 1 [ RunTime:0.000503s ] [2025-07-19T14:44: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` = 1 AND `itemid` IN (100176,101190,102107,102072,102071,101165,98001,121017,121028,121033,94002,94008,41124,12107,12108,12109,100193,30031,30045,30025,30092,95006,95012,101208,95001,161003,161002,101203,95011,41122,100171,25177,161001,119119,119097,128135,128136,42006,102079,101104,101105,101106,101217,101218,101219,100131,100167,100221,100254,100253,118004,127069,127072,127189,101191,101197,101234,101233,127058,127057,127059,127060,127188,120052,120255,42052,101138,119254,120077) [ RunTime:0.041317s ] [2025-07-19T14:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001366s ] [2025-07-19T14:44:55+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 1 [ RunTime:0.000357s ] [2025-07-19T14:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000984s ] [2025-07-19T14:44: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` = 1 AND `tid` = 1 [ RunTime:0.000322s ] [2025-07-19T14:44:55+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (121033,121028,121017) [ RunTime:0.030291s ] [2025-07-19T14:44:55+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 1 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000273s ] [2025-07-19T14:44:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000967s ] [2025-07-19T14:45:07+08:00][sql] CONNECT:[ UseTime:0.001574s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T14:45:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001257s ] [2025-07-19T14:45: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.000386s ] [2025-07-19T14:45:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001170s ] [2025-07-19T14:45:07+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`job`,`grow`,`chaid`,`chaname`,`chalv`,`kill`,`family`,`price`,`created_at`,`trade_status`,`pay_status`,`money` FROM `trade_role` WHERE `id` = 2 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000352s ] [2025-07-19T14:45:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001054s ] [2025-07-19T14:45:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000977s ] [2025-07-19T14:45:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001084s ] [2025-07-19T14:45: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` = 1 AND `tid` = 2 [ RunTime:0.000336s ] [2025-07-19T14:45:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001169s ] [2025-07-19T14:45: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` = 1 AND `tid` = 2 [ RunTime:0.000348s ] [2025-07-19T14:45:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000857s ] [2025-07-19T14:45:07+08:00][sql] SELECT `type`,`itemid`,`num` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 2 [ RunTime:0.000303s ] [2025-07-19T14:45:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001149s ] [2025-07-19T14:45: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` = 1 AND `itemid` IN (25001,25253,101206) [ RunTime:0.042731s ] [2025-07-19T14:45:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001244s ] [2025-07-19T14:45:07+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 2 [ RunTime:0.000333s ] [2025-07-19T14:45:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001010s ] [2025-07-19T14:45: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` = 1 AND `tid` = 2 [ RunTime:0.000407s ] [2025-07-19T14:45:07+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 2 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000229s ] [2025-07-19T14:45:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000987s ] [2025-07-19T14:45:14+08:00][sql] CONNECT:[ UseTime:0.010722s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T14:45:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001304s ] [2025-07-19T14:45: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.000383s ] [2025-07-19T14:45:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001213s ] [2025-07-19T14:45:14+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`job`,`grow`,`chaid`,`chaname`,`chalv`,`kill`,`family`,`price`,`created_at`,`trade_status`,`pay_status`,`money` FROM `trade_role` WHERE `id` = 3 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000331s ] [2025-07-19T14:45:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001108s ] [2025-07-19T14:45:14+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001016s ] [2025-07-19T14:45:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001108s ] [2025-07-19T14:45:14+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` = 1 AND `tid` = 3 [ RunTime:0.000384s ] [2025-07-19T14:45:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001212s ] [2025-07-19T14:45:14+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` = 1 AND `tid` = 3 [ RunTime:0.000361s ] [2025-07-19T14:45:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001180s ] [2025-07-19T14:45:14+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` = 1 AND `itemid` = 13100 [ RunTime:0.041169s ] [2025-07-19T14:45:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001086s ] [2025-07-19T14:45:14+08:00][sql] SELECT `type`,`itemid`,`num` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 3 [ RunTime:0.000301s ] [2025-07-19T14:45:14+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` = 1 AND `itemid` = 13003 [ RunTime:0.040747s ] [2025-07-19T14:45:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001383s ] [2025-07-19T14:45:14+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 3 [ RunTime:0.000352s ] [2025-07-19T14:45:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001011s ] [2025-07-19T14:45:14+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` = 1 AND `tid` = 3 [ RunTime:0.000293s ] [2025-07-19T14:45:14+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 3 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000214s ] [2025-07-19T14:45:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000927s ] [2025-07-19T14:45:30+08:00][sql] CONNECT:[ UseTime:0.011086s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T14:45:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001286s ] [2025-07-19T14:45: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.000376s ] [2025-07-19T14:45:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001191s ] [2025-07-19T14:45:30+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`job`,`grow`,`chaid`,`chaname`,`chalv`,`kill`,`family`,`price`,`created_at`,`trade_status`,`pay_status`,`money` FROM `trade_role` WHERE `id` = 13 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000355s ] [2025-07-19T14:45:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001072s ] [2025-07-19T14:45:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001209s ] [2025-07-19T14:45:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000895s ] [2025-07-19T14:45:30+08:00][sql] SELECT `type`,`itemid`,`num` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 0 [ RunTime:0.000306s ] [2025-07-19T14:45:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001030s ] [2025-07-19T14:45:30+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 0 [ RunTime:0.000377s ] [2025-07-19T14:45:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000951s ] [2025-07-19T14:45:30+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` = 1 AND `tid` = 0 [ RunTime:0.000334s ] [2025-07-19T14:45:30+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000894s ] [2025-07-19T14:45:30+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 0 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000252s ] [2025-07-19T14:45:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000875s ] [2025-07-19T14:45:30+08:00][error] [2]Undefined array key "trade_status" [2025-07-19T14:45:35+08:00][sql] CONNECT:[ UseTime:0.010987s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001321s ] [2025-07-19T14:45: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.000394s ] [2025-07-19T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001179s ] [2025-07-19T14:45:35+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`job`,`grow`,`chaid`,`chaname`,`chalv`,`kill`,`family`,`price`,`created_at`,`trade_status`,`pay_status`,`money` FROM `trade_role` WHERE `id` = 7 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000322s ] [2025-07-19T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001128s ] [2025-07-19T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000948s ] [2025-07-19T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001096s ] [2025-07-19T14:45:35+08:00][sql] SELECT `id`,`game`,`type`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ap`,`dp`,`af`,`as`,`am`,`df`,`ds`,`dm` FROM `trade_war` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 9 [ RunTime:0.000381s ] [2025-07-19T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001184s ] [2025-07-19T14:45:35+08:00][sql] SELECT `id`,`game`,`type`,`itemid`,`st`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ia`,`iav`,`ide`,`idm`,`rd`,`sl`,`cj`,`g1`,`g2`,`g3`,`g4`,`g5`,`g6` FROM `trade_equip` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 9 [ RunTime:0.000360s ] [2025-07-19T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000892s ] [2025-07-19T14:45:35+08:00][sql] SELECT `type`,`itemid`,`num` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 9 [ RunTime:0.000297s ] [2025-07-19T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001200s ] [2025-07-19T14:45:35+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (25013,38208,101206) [ RunTime:0.041333s ] [2025-07-19T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001239s ] [2025-07-19T14:45:35+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 9 [ RunTime:0.000318s ] [2025-07-19T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001002s ] [2025-07-19T14:45:35+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 9 [ RunTime:0.000314s ] [2025-07-19T14:45:35+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 9 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000228s ] [2025-07-19T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.000898s ] [2025-07-19T14:45:45+08:00][sql] CONNECT:[ UseTime:0.010714s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-19T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001362s ] [2025-07-19T14:45: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.000410s ] [2025-07-19T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001269s ] [2025-07-19T14:45:45+08:00][sql] SELECT `id`,`game`,`tid`,`title`,`job`,`grow`,`chaid`,`chaname`,`chalv`,`kill`,`family`,`price`,`created_at`,`trade_status`,`pay_status`,`money` FROM `trade_role` WHERE `id` = 1 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000374s ] [2025-07-19T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001116s ] [2025-07-19T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001101s ] [2025-07-19T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001125s ] [2025-07-19T14:45:45+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` = 1 AND `tid` = 1 [ RunTime:0.000333s ] [2025-07-19T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001192s ] [2025-07-19T14:45:45+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` = 1 AND `tid` = 1 [ RunTime:0.000428s ] [2025-07-19T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001218s ] [2025-07-19T14:45:45+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (30059,30024,30200,30250,30017,30025,30031,30045,30011,98001,30060,30046) [ RunTime:0.028922s ] [2025-07-19T14:45:45+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` = 1 AND `itemid` IN (16196,17211,18211,20212,21211,12110,23014,22025,40247,40205,120078,16168,17174,18067,20067,21068,12009,17189,18073,20073,21189,12019,23006,22007,40006) [ RunTime:0.040618s ] [2025-07-19T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001238s ] [2025-07-19T14:45:45+08:00][sql] SELECT `type`,`itemid`,`num` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 1 [ RunTime:0.000487s ] [2025-07-19T14:45:45+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` = 1 AND `itemid` IN (100176,101190,102107,102072,102071,101165,98001,121017,121028,121033,94002,94008,41124,12107,12108,12109,100193,30031,30045,30025,30092,95006,95012,101208,95001,161003,161002,101203,95011,41122,100171,25177,161001,119119,119097,128135,128136,42006,102079,101104,101105,101106,101217,101218,101219,100131,100167,100221,100254,100253,118004,127069,127072,127189,101191,101197,101234,101233,127058,127057,127059,127060,127188,120052,120255,42052,101138,119254,120077) [ RunTime:0.041488s ] [2025-07-19T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001442s ] [2025-07-19T14:45:45+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`godid`,`index`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`hp`,`mp`,`sp`,`at`,`atv`,`df`,`dfm`,`level`,`mul` FROM `trade_god` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 1 [ RunTime:0.000395s ] [2025-07-19T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001105s ] [2025-07-19T14:45:45+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` = 1 AND `tid` = 1 [ RunTime:0.000368s ] [2025-07-19T14:45:45+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`itemid` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (121033,121028,121017) [ RunTime:0.029870s ] [2025-07-19T14:45:45+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 1 AND `game` = 'shaiya' AND `serverid` = 1 LIMIT 1 [ RunTime:0.000322s ] [2025-07-19T14:45:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_collect` [ RunTime:0.001059s ]