[2026-02-10T16:37:11+08:00][sql] CONNECT:[ UseTime:0.010477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:37:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001366s ]
[2026-02-10T16:37:11+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000260s ]
[2026-02-10T16:37:12+08:00][sql] CONNECT:[ UseTime:0.010387s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:37:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001503s ]
[2026-02-10T16:37:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000424s ]
[2026-02-10T16:37:12+08:00][sql] SELECT `tp`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000373s ]
[2026-02-10T16:37:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001070s ]
[2026-02-10T16:37:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001155s ]
[2026-02-10T16:39:29+08:00][sql] CONNECT:[ UseTime:0.001431s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:39:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001517s ]
[2026-02-10T16:39:29+08:00][sql] SELECT `id`,`game`,`serverid`,`orderno`,`tid`,`pay_status`,`ordertype`,`relationid`,`tousername`,`tochaid`,`tochaname`,`api_status`,`order_details` FROM `trade_order` WHERE  `orderno` = 'P2026021016340910145156' LIMIT 1 [ RunTime:0.000325s ]
[2026-02-10T16:39:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001241s ]
[2026-02-10T16:53:07+08:00][sql] CONNECT:[ UseTime:0.001396s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:53:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001255s ]
[2026-02-10T16:53:07+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000256s ]
[2026-02-10T16:53:07+08:00][sql] CONNECT:[ UseTime:0.010554s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:53:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001348s ]
[2026-02-10T16:53:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000398s ]
[2026-02-10T16:53:07+08:00][sql] SELECT `tp`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000373s ]
[2026-02-10T16:53:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000989s ]
[2026-02-10T16:53:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001054s ]
[2026-02-10T16:53:15+08:00][sql] CONNECT:[ UseTime:0.001467s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:53:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001478s ]
[2026-02-10T16:53:15+08:00][sql] SELECT `id`,`game`,`serverid`,`orderno`,`tid`,`pay_status`,`ordertype`,`relationid`,`tousername`,`tochaid`,`tochaname`,`api_status`,`order_details` FROM `trade_order` WHERE  `orderno` = 'P2026021016340910145156' LIMIT 1 [ RunTime:0.000297s ]
[2026-02-10T16:53:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001227s ]
[2026-02-10T16:53:15+08:00][sql] UPDATE `trade_order`  SET `api_status` = 1 , `totime` = 1770713595  WHERE  `id` = 49 [ RunTime:0.000314s ]
[2026-02-10T16:53:15+08:00][sql] UPDATE `trade_prop`  SET `api_status` = 1  WHERE  `id` = 16 [ RunTime:0.000224s ]
[2026-02-10T16:53:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001076s ]
[2026-02-10T16:53:15+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya5' , `serverid` = 5 , `tid` = 167 , `username` = 'ctshaiya001' , `orderno` = 'P2026021016340910145156' , `trade_type` = 2 , `type` = 1 , `content` = '%s出售成功%s！如有疑问可联系官方客服咨询%s' [ RunTime:0.000318s ]
[2026-02-10T16:53:17+08:00][sql] CONNECT:[ UseTime:0.011385s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:53:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001433s ]
[2026-02-10T16:53:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000418s ]
[2026-02-10T16:53:17+08:00][sql] SELECT `tp`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000389s ]
[2026-02-10T16:53:17+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000991s ]
[2026-02-10T16:53:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001051s ]
[2026-02-10T16:53:29+08:00][sql] CONNECT:[ UseTime:0.011346s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:53:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001460s ]
[2026-02-10T16:53:29+08:00][sql] SELECT `id`,`game`,`serverid`,`orderno`,`tid`,`pay_status`,`ordertype`,`relationid`,`tousername`,`tochaid`,`tochaname`,`api_status`,`order_details` FROM `trade_order` WHERE  `orderno` = 'P2026021016332287540721' LIMIT 1 [ RunTime:0.000295s ]
[2026-02-10T16:53:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001149s ]
[2026-02-10T16:53:33+08:00][sql] CONNECT:[ UseTime:0.011347s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:53:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001293s ]
[2026-02-10T16:53:33+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `game` IN ('shaiya','shaiya5') [ RunTime:0.000264s ]
[2026-02-10T16:53:33+08:00][sql] CONNECT:[ UseTime:0.010768s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:53:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001406s ]
[2026-02-10T16:53:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') LIMIT 1 [ RunTime:0.000413s ]
[2026-02-10T16:53:33+08:00][sql] SELECT `tp`.*,`to`.`amount`,`to`.`charge`,`to`.`tousername`,to.id as order_id,`to`.`withdraw_status` FROM `trade_prop` `tp` LEFT JOIN `trade_order` `to` ON `to`.`orderno`=`tp`.`orderno` WHERE  `tp`.`game` IN ('shaiya','shaiya5') ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000348s ]
[2026-02-10T16:53:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001028s ]
[2026-02-10T16:53:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001131s ]
[2026-02-10T16:53:35+08:00][sql] CONNECT:[ UseTime:0.010996s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:53:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001539s ]
[2026-02-10T16:53:35+08:00][sql] SELECT `id`,`game`,`serverid`,`orderno`,`tid`,`pay_status`,`ordertype`,`relationid`,`tousername`,`tochaid`,`tochaname`,`api_status`,`order_details` FROM `trade_order` WHERE  `orderno` = 'P2026021016332287540721' LIMIT 1 [ RunTime:0.000323s ]
[2026-02-10T16:53:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001266s ]
[2026-02-10T16:54:12+08:00][sql] CONNECT:[ UseTime:0.010850s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2026-02-10T16:54:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001363s ]
[2026-02-10T16:54:12+08:00][sql] SELECT `id`,`game`,`serverid`,`orderno`,`tid`,`pay_status`,`ordertype`,`relationid`,`tousername`,`tochaid`,`tochaname`,`api_status`,`order_details` FROM `trade_order` WHERE  `orderno` = 'P2026021016332287540721' LIMIT 1 [ RunTime:0.000317s ]
[2026-02-10T16:54:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001132s ]