[2025-07-05T09:43:07+08:00][sql] CONNECT:[ UseTime:0.001421s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T09:43:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001261s ] [2025-07-05T09:43:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000849s ] [2025-07-05T09:43:07+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000296s ] [2025-07-05T09:43:31+08:00][sql] CONNECT:[ UseTime:0.001502s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T09:43:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001185s ] [2025-07-05T09:43:31+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000242s ] [2025-07-05T09:43:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001003s ] [2025-07-05T09:43:31+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000263s ] [2025-07-05T09:43:31+08:00][sql] CONNECT:[ UseTime:0.001416s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T09:43:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001271s ] [2025-07-05T09:43:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000845s ] [2025-07-05T09:43:31+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000464s ] [2025-07-05T09:43:40+08:00][sql] CONNECT:[ UseTime:0.001522s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T09:43:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001182s ] [2025-07-05T09:43:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_cate` LIMIT 1 [ RunTime:0.000215s ] [2025-07-05T09:43:40+08:00][sql] SELECT * FROM `trade_help_cate` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000252s ] [2025-07-05T09:43:43+08:00][sql] CONNECT:[ UseTime:0.001498s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T09:43:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001319s ] [2025-07-05T09:43:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000294s ] [2025-07-05T09:43:43+08:00][sql] CONNECT:[ UseTime:0.010901s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T09:43:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001485s ] [2025-07-05T09:43:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000871s ] [2025-07-05T09:43:43+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000305s ] [2025-07-05T09:43:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001165s ] [2025-07-05T09:43:43+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000271s ] [2025-07-05T09:43:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000925s ] [2025-07-05T09:44:06+08:00][sql] CONNECT:[ UseTime:0.011696s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T09:44:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001326s ] [2025-07-05T09:44:06+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000310s ] [2025-07-05T09:44:06+08:00][sql] CONNECT:[ UseTime:0.001462s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T09:44:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001481s ] [2025-07-05T09:44:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000820s ] [2025-07-05T09:44:06+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000271s ] [2025-07-05T09:44:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001154s ] [2025-07-05T09:44:06+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000312s ] [2025-07-05T09:44:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000943s ] [2025-07-05T09:44:06+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (5,4,3,2,1) [ RunTime:0.000251s ] [2025-07-05T10:30:02+08:00][sql] CONNECT:[ UseTime:0.001922s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:30:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001937s ] [2025-07-05T10:30:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000900s ] [2025-07-05T10:30:02+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000286s ] [2025-07-05T10:32:53+08:00][sql] CONNECT:[ UseTime:0.011589s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:32:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001358s ] [2025-07-05T10:32:53+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000307s ] [2025-07-05T10:32:53+08:00][sql] CONNECT:[ UseTime:0.011397s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:32:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001472s ] [2025-07-05T10:32:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.001062s ] [2025-07-05T10:32:53+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000252s ] [2025-07-05T10:32:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001158s ] [2025-07-05T10:32:53+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000294s ] [2025-07-05T10:32:55+08:00][sql] CONNECT:[ UseTime:0.011287s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:32:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001488s ] [2025-07-05T10:32:55+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000515s ] [2025-07-05T10:32:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001208s ] [2025-07-05T10:32:55+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000288s ] [2025-07-05T10:32:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001013s ] [2025-07-05T10:32:55+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000227s ] [2025-07-05T10:35:33+08:00][sql] CONNECT:[ UseTime:0.011252s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:35:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001483s ] [2025-07-05T10:35:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000935s ] [2025-07-05T10:35:33+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000243s ] [2025-07-05T10:36:03+08:00][sql] CONNECT:[ UseTime:0.001503s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:36:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001375s ] [2025-07-05T10:36:03+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 1 , `servername` = '晓夜之歌' , `image` = '/storage/upload/20250705/4319f55133f473d8b885e65b58884673.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 2 [ RunTime:0.002135s ] [2025-07-05T10:36:05+08:00][sql] CONNECT:[ UseTime:0.011601s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:36:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001427s ] [2025-07-05T10:36:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000866s ] [2025-07-05T10:36:05+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000219s ] [2025-07-05T10:37:02+08:00][sql] CONNECT:[ UseTime:0.011077s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:37:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001321s ] [2025-07-05T10:37:02+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 1 , `servername` = '晓夜之歌' , `image` = '/storage/upload/20250705/92a2602dec62ccc6a29bfeca0e240e0b.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 2 [ RunTime:0.002205s ] [2025-07-05T10:37:04+08:00][sql] CONNECT:[ UseTime:0.001505s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:37:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001407s ] [2025-07-05T10:37:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000872s ] [2025-07-05T10:37:04+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000264s ] [2025-07-05T10:37:18+08:00][sql] CONNECT:[ UseTime:0.010860s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:37:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001314s ] [2025-07-05T10:37:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000880s ] [2025-07-05T10:37:18+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000247s ] [2025-07-05T10:37:34+08:00][sql] CONNECT:[ UseTime:0.010469s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:37:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001299s ] [2025-07-05T10:37:34+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 1 , `servername` = '晓夜之歌' , `image` = '/storage/upload/20250705/c0af46243734904c412a93c5e152fc9e.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 2 [ RunTime:0.001509s ] [2025-07-05T10:37:36+08:00][sql] CONNECT:[ UseTime:0.011113s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:37:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001345s ] [2025-07-05T10:37:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000828s ] [2025-07-05T10:37:36+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000259s ] [2025-07-05T10:38:10+08:00][sql] CONNECT:[ UseTime:0.001605s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:38:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001429s ] [2025-07-05T10:38:10+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000367s ] [2025-07-05T10:38:10+08:00][sql] CONNECT:[ UseTime:0.010840s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:38:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001324s ] [2025-07-05T10:38:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000930s ] [2025-07-05T10:38:10+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000246s ] [2025-07-05T10:38:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001247s ] [2025-07-05T10:38:10+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000236s ] [2025-07-05T10:41:42+08:00][sql] CONNECT:[ UseTime:0.010438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:41:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001267s ] [2025-07-05T10:41:42+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000359s ] [2025-07-05T10:41:43+08:00][sql] CONNECT:[ UseTime:0.011401s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:41:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001485s ] [2025-07-05T10:41:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000880s ] [2025-07-05T10:41:43+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000261s ] [2025-07-05T10:41:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001118s ] [2025-07-05T10:41:43+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000288s ] [2025-07-05T10:41:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000900s ] [2025-07-05T10:41:43+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (5,4,3,2,1) [ RunTime:0.000252s ] [2025-07-05T10:42:16+08:00][sql] CONNECT:[ UseTime:0.010445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:42:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001412s ] [2025-07-05T10:42:16+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000325s ] [2025-07-05T10:42:16+08:00][sql] CONNECT:[ UseTime:0.011102s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:42:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001399s ] [2025-07-05T10:42:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.001002s ] [2025-07-05T10:42:16+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000275s ] [2025-07-05T10:42:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001279s ] [2025-07-05T10:42:16+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000232s ] [2025-07-05T10:42:19+08:00][sql] CONNECT:[ UseTime:0.011599s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001602s ] [2025-07-05T10:42:19+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000430s ] [2025-07-05T10:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001129s ] [2025-07-05T10:42:19+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000263s ] [2025-07-05T10:42:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000972s ] [2025-07-05T10:42:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000245s ] [2025-07-05T10:47:08+08:00][sql] CONNECT:[ UseTime:0.001570s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:47:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001629s ] [2025-07-05T10:47:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.001003s ] [2025-07-05T10:47:08+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000314s ] [2025-07-05T10:47:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001095s ] [2025-07-05T10:47:08+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000222s ] [2025-07-05T10:48:14+08:00][sql] CONNECT:[ UseTime:0.011494s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:48:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001386s ] [2025-07-05T10:48:14+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000433s ] [2025-07-05T10:48:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001061s ] [2025-07-05T10:48:14+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000225s ] [2025-07-05T10:48:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000902s ] [2025-07-05T10:48:14+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000235s ] [2025-07-05T10:48:16+08:00][sql] CONNECT:[ UseTime:0.011036s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:48:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001416s ] [2025-07-05T10:48:16+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 1 , `servername` = '晓夜之歌' , `image` = '/storage/upload/20250705/604a5da465743727f540e648d1e084a3.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 2 [ RunTime:0.002314s ] [2025-07-05T10:48:18+08:00][sql] CONNECT:[ UseTime:0.011654s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:48:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001855s ] [2025-07-05T10:48:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000955s ] [2025-07-05T10:48:18+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000416s ] [2025-07-05T10:50:22+08:00][sql] CONNECT:[ UseTime:0.010382s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:50:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001457s ] [2025-07-05T10:50:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000844s ] [2025-07-05T10:50:22+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000348s ] [2025-07-05T10:50:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001231s ] [2025-07-05T10:50:22+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000227s ] [2025-07-05T10:50:23+08:00][sql] CONNECT:[ UseTime:0.011127s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:50:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001483s ] [2025-07-05T10:50:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000882s ] [2025-07-05T10:50:23+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000237s ] [2025-07-05T10:50:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001270s ] [2025-07-05T10:50:23+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000237s ] [2025-07-05T10:50:23+08:00][sql] CONNECT:[ UseTime:0.001476s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:50:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001590s ] [2025-07-05T10:50:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000896s ] [2025-07-05T10:50:23+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000278s ] [2025-07-05T10:50:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001196s ] [2025-07-05T10:50:23+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000243s ] [2025-07-05T10:56:27+08:00][sql] CONNECT:[ UseTime:0.011017s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:56:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001321s ] [2025-07-05T10:56:27+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/static/index/images/index_cp_5.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 3 [ RunTime:0.001550s ] [2025-07-05T10:56:29+08:00][sql] CONNECT:[ UseTime:0.011498s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:56:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001387s ] [2025-07-05T10:56:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000885s ] [2025-07-05T10:56:29+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000285s ] [2025-07-05T10:56:34+08:00][sql] CONNECT:[ UseTime:0.001425s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:56:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001288s ] [2025-07-05T10:56:34+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 6 , `servername` = '创世之境' , `image` = '/static/index/images/index_cp_6.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 1 [ RunTime:0.001913s ] [2025-07-05T10:56:35+08:00][sql] CONNECT:[ UseTime:0.001504s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:56:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001443s ] [2025-07-05T10:56:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000847s ] [2025-07-05T10:56:35+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000321s ] [2025-07-05T10:56:51+08:00][sql] CONNECT:[ UseTime:0.011469s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:56:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001336s ] [2025-07-05T10:56:51+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 1 , `servername` = '晓夜之歌' , `image` = '/storage/upload/20250705/f2a95e39ce695fcf23d9ec91e2db96e5.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 2 [ RunTime:0.002272s ] [2025-07-05T10:56:53+08:00][sql] CONNECT:[ UseTime:0.011118s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:56:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001445s ] [2025-07-05T10:56:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000890s ] [2025-07-05T10:56:53+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000267s ] [2025-07-05T10:57:41+08:00][sql] CONNECT:[ UseTime:0.001479s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:57:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001374s ] [2025-07-05T10:57:41+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 1 , `servername` = '晓夜之歌' , `image` = '/storage/upload/20250705/a5f23aace46dd0ec228f2d35de0a5e80.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 2 [ RunTime:0.002294s ] [2025-07-05T10:57:43+08:00][sql] CONNECT:[ UseTime:0.011122s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T10:57:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001411s ] [2025-07-05T10:57:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000957s ] [2025-07-05T10:57:43+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000281s ] [2025-07-05T11:02:34+08:00][sql] CONNECT:[ UseTime:0.001466s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:02:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001339s ] [2025-07-05T11:02:34+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 6 , `servername` = '创世之境' , `image` = '/storage/upload/20250705/8f16ff2853b8cfa3132d0fa1ca557c6b.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 1 [ RunTime:0.002277s ] [2025-07-05T11:02:36+08:00][sql] CONNECT:[ UseTime:0.001438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:02:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001238s ] [2025-07-05T11:02:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000828s ] [2025-07-05T11:02:36+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000234s ] [2025-07-05T11:06:30+08:00][sql] CONNECT:[ UseTime:0.010942s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:06:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001240s ] [2025-07-05T11:06:30+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 6 , `servername` = '创世之境' , `image` = '/storage/upload/20250705/8f16ff2853b8cfa3132d0fa1ca557c6b.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 1 [ RunTime:0.000371s ] [2025-07-05T11:06:32+08:00][sql] CONNECT:[ UseTime:0.010920s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:06:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001365s ] [2025-07-05T11:06:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000962s ] [2025-07-05T11:06:32+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000232s ] [2025-07-05T11:06:46+08:00][sql] CONNECT:[ UseTime:0.001491s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:06:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001371s ] [2025-07-05T11:06:46+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 6 , `servername` = '创世之境' , `image` = '/storage/upload/20250705/f30c5e2ad0a9f0fdddede9b6a40ade01.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 1 [ RunTime:0.002004s ] [2025-07-05T11:06:48+08:00][sql] CONNECT:[ UseTime:0.010445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:06:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001362s ] [2025-07-05T11:06:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000872s ] [2025-07-05T11:06:48+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000240s ] [2025-07-05T11:07:39+08:00][sql] CONNECT:[ UseTime:0.001425s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:07:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001387s ] [2025-07-05T11:07:39+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 6 , `servername` = '创世之境' , `image` = '/storage/upload/20250705/254015fa699f7e16bf0b909158905fc8.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 1 [ RunTime:0.001646s ] [2025-07-05T11:07:41+08:00][sql] CONNECT:[ UseTime:0.011021s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:07:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001346s ] [2025-07-05T11:07:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000912s ] [2025-07-05T11:07:41+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000252s ] [2025-07-05T11:09:20+08:00][sql] CONNECT:[ UseTime:0.001436s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:09:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001422s ] [2025-07-05T11:09:20+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 6 , `servername` = '创世之境' , `image` = '/storage/upload/20250705/ee5ebd9f9beae462b0342aca009cc93a.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 1 [ RunTime:0.002057s ] [2025-07-05T11:09:22+08:00][sql] CONNECT:[ UseTime:0.011216s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:09:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001255s ] [2025-07-05T11:09:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.001043s ] [2025-07-05T11:09:22+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000321s ] [2025-07-05T11:15:33+08:00][sql] CONNECT:[ UseTime:0.001501s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:15:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001222s ] [2025-07-05T11:15:33+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 6 , `servername` = '创世之境' , `image` = '/storage/upload/20250705/0649e280f0d6da76a86e3c7d0805adc5.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 1 [ RunTime:0.002077s ] [2025-07-05T11:15:34+08:00][sql] CONNECT:[ UseTime:0.001424s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:15:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001261s ] [2025-07-05T11:15:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000930s ] [2025-07-05T11:15:34+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000252s ] [2025-07-05T11:17:23+08:00][sql] CONNECT:[ UseTime:0.010578s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:17:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001324s ] [2025-07-05T11:17:23+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 6 , `servername` = '创世之境' , `image` = '/storage/upload/20250705/6c43919b8d297aeeb8f8bf168999c03b.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 1 [ RunTime:0.002307s ] [2025-07-05T11:17:24+08:00][sql] CONNECT:[ UseTime:0.010532s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:17:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001365s ] [2025-07-05T11:17:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000892s ] [2025-07-05T11:17:24+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000257s ] [2025-07-05T11:18:15+08:00][sql] CONNECT:[ UseTime:0.001414s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:18:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001330s ] [2025-07-05T11:18:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000858s ] [2025-07-05T11:18:15+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000263s ] [2025-07-05T11:18:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001203s ] [2025-07-05T11:18:15+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000263s ] [2025-07-05T11:18:16+08:00][sql] CONNECT:[ UseTime:0.010984s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:18:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001535s ] [2025-07-05T11:18:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000962s ] [2025-07-05T11:18:16+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000273s ] [2025-07-05T11:18:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001180s ] [2025-07-05T11:18:16+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000235s ] [2025-07-05T11:18:16+08:00][sql] CONNECT:[ UseTime:0.011108s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:18:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001434s ] [2025-07-05T11:18:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000884s ] [2025-07-05T11:18:16+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000241s ] [2025-07-05T11:18:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001132s ] [2025-07-05T11:18:16+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000283s ] [2025-07-05T11:18:16+08:00][sql] CONNECT:[ UseTime:0.011539s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:18:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001432s ] [2025-07-05T11:18:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000887s ] [2025-07-05T11:18:16+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000261s ] [2025-07-05T11:18:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001232s ] [2025-07-05T11:18:16+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000235s ] [2025-07-05T11:20:08+08:00][sql] CONNECT:[ UseTime:0.011441s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:20:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001354s ] [2025-07-05T11:20:08+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 6 , `servername` = '创世之境' , `image` = '/storage/upload/20250705/595e920066f82f5b1058b56a18c906bb.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 1 [ RunTime:0.001486s ] [2025-07-05T11:20:12+08:00][sql] CONNECT:[ UseTime:0.011011s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:20:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001316s ] [2025-07-05T11:20:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000886s ] [2025-07-05T11:20:12+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000275s ] [2025-07-05T11:24:35+08:00][sql] CONNECT:[ UseTime:0.010561s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:24:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001323s ] [2025-07-05T11:24:35+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/storage/upload/20250705/4683220e6aa7527352ad2846923108f1.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 3 [ RunTime:0.001722s ] [2025-07-05T11:24:36+08:00][sql] CONNECT:[ UseTime:0.010787s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:24:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001267s ] [2025-07-05T11:24:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000891s ] [2025-07-05T11:24:36+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000234s ] [2025-07-05T11:24:52+08:00][sql] CONNECT:[ UseTime:0.011217s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:24:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001363s ] [2025-07-05T11:24:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000971s ] [2025-07-05T11:24:52+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000246s ] [2025-07-05T11:24:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001339s ] [2025-07-05T11:24:52+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000270s ] [2025-07-05T11:27:29+08:00][sql] CONNECT:[ UseTime:0.011028s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:27:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001415s ] [2025-07-05T11:27:29+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/storage/upload/20250705/f5bdac950646e038b370204053b0907f.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 3 [ RunTime:0.001820s ] [2025-07-05T11:27:32+08:00][sql] CONNECT:[ UseTime:0.011048s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:27:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001329s ] [2025-07-05T11:27:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000880s ] [2025-07-05T11:27:32+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000259s ] [2025-07-05T11:29:12+08:00][sql] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:29:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001396s ] [2025-07-05T11:29:12+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/storage/upload/20250705/3be92a8f0d2116ccff99e2e6a7eb077f.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 3 [ RunTime:0.001921s ] [2025-07-05T11:29:14+08:00][sql] CONNECT:[ UseTime:0.010890s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:29:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001333s ] [2025-07-05T11:29:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000837s ] [2025-07-05T11:29:14+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000242s ] [2025-07-05T11:32:44+08:00][sql] CONNECT:[ UseTime:0.001515s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:32:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001359s ] [2025-07-05T11:32:44+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/storage/upload/20250705/7bd8e1d8212f21add4086887d436febb.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 3 [ RunTime:0.001469s ] [2025-07-05T11:32:46+08:00][sql] CONNECT:[ UseTime:0.011221s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:32:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001472s ] [2025-07-05T11:32:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000827s ] [2025-07-05T11:32:46+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000230s ] [2025-07-05T11:34:41+08:00][sql] CONNECT:[ UseTime:0.011047s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:34:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001295s ] [2025-07-05T11:34:41+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/storage/upload/20250705/030f2841b8c185b1d0ad7e7846eb4658.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 3 [ RunTime:0.001721s ] [2025-07-05T11:34:44+08:00][sql] CONNECT:[ UseTime:0.001530s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:34:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001382s ] [2025-07-05T11:34:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000889s ] [2025-07-05T11:34:44+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000272s ] [2025-07-05T11:35:45+08:00][sql] CONNECT:[ UseTime:0.001450s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:35:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001255s ] [2025-07-05T11:35:45+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/storage/upload/20250705/0174c1eb9a7d2811ef7164691c6b13fb.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 3 [ RunTime:0.001569s ] [2025-07-05T11:35:49+08:00][sql] CONNECT:[ UseTime:0.001641s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:35:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001469s ] [2025-07-05T11:35:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000850s ] [2025-07-05T11:35:49+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000265s ] [2025-07-05T11:38:24+08:00][sql] CONNECT:[ UseTime:0.011621s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:38:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001371s ] [2025-07-05T11:38:24+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/storage/upload/20250705/33d59bad07fdb190cbf3d203d97fff51.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 3 [ RunTime:0.002249s ] [2025-07-05T11:38:26+08:00][sql] CONNECT:[ UseTime:0.011597s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:38:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001372s ] [2025-07-05T11:38:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000865s ] [2025-07-05T11:38:26+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000222s ] [2025-07-05T11:40:57+08:00][sql] CONNECT:[ UseTime:0.001435s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:40:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001250s ] [2025-07-05T11:40:57+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/storage/upload/20250705/f45cd2c70257d718d4dbabd45481209b.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 3 [ RunTime:0.002043s ] [2025-07-05T11:41:00+08:00][sql] CONNECT:[ UseTime:0.010878s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:41:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001249s ] [2025-07-05T11:41:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000933s ] [2025-07-05T11:41:00+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000253s ] [2025-07-05T11:43:40+08:00][sql] CONNECT:[ UseTime:0.011331s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:43:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001412s ] [2025-07-05T11:43:40+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/storage/upload/20250705/50913b1b3d8f005638ff9fdae2b846b9.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 3 [ RunTime:0.001274s ] [2025-07-05T11:43:42+08:00][sql] CONNECT:[ UseTime:0.011517s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:43:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001454s ] [2025-07-05T11:43:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.001070s ] [2025-07-05T11:43:42+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000267s ] [2025-07-05T11:51:49+08:00][sql] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:51:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001269s ] [2025-07-05T11:51:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000885s ] [2025-07-05T11:51:49+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000260s ] [2025-07-05T11:51:53+08:00][sql] CONNECT:[ UseTime:0.010956s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:51:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001314s ] [2025-07-05T11:51:53+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000277s ] [2025-07-05T11:51:53+08:00][sql] CONNECT:[ UseTime:0.011104s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:51:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001302s ] [2025-07-05T11:51:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000828s ] [2025-07-05T11:51:53+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000269s ] [2025-07-05T11:51:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001332s ] [2025-07-05T11:51:53+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000239s ] [2025-07-05T11:52:50+08:00][sql] CONNECT:[ UseTime:0.011234s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:52:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001477s ] [2025-07-05T11:52:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001174s ] [2025-07-05T11:52:50+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`relationid`,`ordertype`,`username`,`orderno`,`payuser`,`aliname`,`status`,`alitime`,`transfer_order_id` FROM `trade_withdraw` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000301s ] [2025-07-05T11:52:50+08:00][sql] SELECT `id`,`pay_status`,`api_status`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000204s ] [2025-07-05T11:52:50+08:00][sql] UPDATE `trade_withdraw` SET `op_type` = 2 , `status` = 3 , `remark` = '账号与姓名不符' , `certificate` = '' WHERE `id` = 1 [ RunTime:0.000304s ] [2025-07-05T11:52:50+08:00][sql] UPDATE `trade_order` SET `withdraw_status` = 3 WHERE `id` = 1 [ RunTime:0.000209s ] [2025-07-05T11:52:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001013s ] [2025-07-05T11:52:50+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya' , `serverid` = 1 , `tid` = 3 , `username` = 'ctshaiya014' , `orderno` = 'R2025070315403097811238' , `trade_type` = 1 , `type` = 4 , `content` = '您有一笔订单提现失败%s,请联系官方客服咨询处理%s' [ RunTime:0.000325s ] [2025-07-05T11:52:52+08:00][sql] CONNECT:[ UseTime:0.010601s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:52:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001392s ] [2025-07-05T11:52:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000873s ] [2025-07-05T11:52:52+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000307s ] [2025-07-05T11:52:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001197s ] [2025-07-05T11:52:52+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000313s ] [2025-07-05T11:57:44+08:00][sql] CONNECT:[ UseTime:0.010422s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001377s ] [2025-07-05T11:57:44+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000333s ] [2025-07-05T11:57:44+08:00][sql] CONNECT:[ UseTime:0.011142s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001937s ] [2025-07-05T11:57:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.001043s ] [2025-07-05T11:57:44+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000382s ] [2025-07-05T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001599s ] [2025-07-05T11:57:44+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000394s ] [2025-07-05T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001137s ] [2025-07-05T11:57:44+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (5,4,3,2,1) [ RunTime:0.000336s ] [2025-07-05T12:02:55+08:00][sql] CONNECT:[ UseTime:0.010733s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T12:02:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001355s ] [2025-07-05T12:02:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000950s ] [2025-07-05T12:02:55+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000276s ] [2025-07-05T12:04:10+08:00][sql] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T12:04:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001318s ] [2025-07-05T12:04:10+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000302s ] [2025-07-05T12:04:10+08:00][sql] CONNECT:[ UseTime:0.001404s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T12:04:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001412s ] [2025-07-05T12:04:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000886s ] [2025-07-05T12:04:10+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000275s ] [2025-07-05T12:04:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001141s ] [2025-07-05T12:04:10+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000307s ] [2025-07-05T12:04:10+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000946s ] [2025-07-05T12:04:10+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (5,4,3,2,1) [ RunTime:0.000252s ] [2025-07-05T13:33:48+08:00][sql] CONNECT:[ UseTime:0.001582s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:33:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001417s ] [2025-07-05T13:33:48+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000279s ] [2025-07-05T13:33:48+08:00][sql] CONNECT:[ UseTime:0.001409s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:33:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001365s ] [2025-07-05T13:33:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000849s ] [2025-07-05T13:33:48+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000270s ] [2025-07-05T13:33:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001155s ] [2025-07-05T13:33:48+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000250s ] [2025-07-05T13:35:18+08:00][sql] CONNECT:[ UseTime:0.010995s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:35:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001311s ] [2025-07-05T13:35:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000821s ] [2025-07-05T13:35:18+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000248s ] [2025-07-05T13:36:40+08:00][sql] CONNECT:[ UseTime:0.011254s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:36:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001445s ] [2025-07-05T13:36:40+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000317s ] [2025-07-05T13:36:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001145s ] [2025-07-05T13:36:40+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000227s ] [2025-07-05T13:36:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000969s ] [2025-07-05T13:36:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000236s ] [2025-07-05T13:36:42+08:00][sql] CONNECT:[ UseTime:0.010948s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:36:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001254s ] [2025-07-05T13:36:42+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000518s ] [2025-07-05T13:36:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001014s ] [2025-07-05T13:36:42+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000299s ] [2025-07-05T13:36:42+08:00][sql] CONNECT:[ UseTime:0.011298s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:36:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001381s ] [2025-07-05T13:36:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000857s ] [2025-07-05T13:36:42+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000456s ] [2025-07-05T13:36:45+08:00][sql] CONNECT:[ UseTime:0.011054s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:36:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001269s ] [2025-07-05T13:36:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_cate` LIMIT 1 [ RunTime:0.000421s ] [2025-07-05T13:36:45+08:00][sql] SELECT * FROM `trade_help_cate` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000212s ] [2025-07-05T13:36:46+08:00][sql] CONNECT:[ UseTime:0.011156s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:36:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001516s ] [2025-07-05T13:36:46+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000363s ] [2025-07-05T13:36:46+08:00][sql] CONNECT:[ UseTime:0.011574s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:36:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001534s ] [2025-07-05T13:36:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000959s ] [2025-07-05T13:36:46+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000273s ] [2025-07-05T13:36:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001199s ] [2025-07-05T13:36:46+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000327s ] [2025-07-05T13:36:46+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000984s ] [2025-07-05T13:36:47+08:00][sql] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:36:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001325s ] [2025-07-05T13:36:47+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000304s ] [2025-07-05T13:36:47+08:00][sql] CONNECT:[ UseTime:0.010907s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:36:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001515s ] [2025-07-05T13:36:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000861s ] [2025-07-05T13:36:47+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000349s ] [2025-07-05T13:36:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001233s ] [2025-07-05T13:36:47+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000290s ] [2025-07-05T13:36:47+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001033s ] [2025-07-05T13:36:47+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000314s ] [2025-07-05T13:36:50+08:00][sql] CONNECT:[ UseTime:0.010995s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:36:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001730s ] [2025-07-05T13:36:50+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000512s ] [2025-07-05T13:36:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001272s ] [2025-07-05T13:36:50+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000232s ] [2025-07-05T13:36:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001106s ] [2025-07-05T13:36:50+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000243s ] [2025-07-05T13:43:37+08:00][sql] CONNECT:[ UseTime:0.001429s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:43:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001240s ] [2025-07-05T13:43:37+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000277s ] [2025-07-05T13:43:37+08:00][sql] CONNECT:[ UseTime:0.011400s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:43:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001540s ] [2025-07-05T13:43:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000848s ] [2025-07-05T13:43:37+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000243s ] [2025-07-05T13:43:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001106s ] [2025-07-05T13:43:37+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000254s ] [2025-07-05T13:43:37+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001126s ] [2025-07-05T13:47:43+08:00][sql] CONNECT:[ UseTime:0.001406s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:47:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001279s ] [2025-07-05T13:47:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000275s ] [2025-07-05T13:47:43+08:00][sql] CONNECT:[ UseTime:0.010595s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:47:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001370s ] [2025-07-05T13:47:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000889s ] [2025-07-05T13:47:43+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000247s ] [2025-07-05T13:47:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001155s ] [2025-07-05T13:47:43+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000285s ] [2025-07-05T13:47:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000959s ] [2025-07-05T13:47:44+08:00][sql] CONNECT:[ UseTime:0.001445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:47:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001230s ] [2025-07-05T13:47:44+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000292s ] [2025-07-05T13:47:44+08:00][sql] CONNECT:[ UseTime:0.011145s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:47:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001434s ] [2025-07-05T13:47:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000956s ] [2025-07-05T13:47:44+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000268s ] [2025-07-05T13:47:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001112s ] [2025-07-05T13:47:44+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000299s ] [2025-07-05T13:47:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000863s ] [2025-07-05T13:47:44+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000275s ] [2025-07-05T13:47:46+08:00][sql] CONNECT:[ UseTime:0.010524s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:47:46+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001333s ] [2025-07-05T13:47:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001273s ] [2025-07-05T13:47:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001102s ] [2025-07-05T13:47:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001044s ] [2025-07-05T13:47:46+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000321s ] [2025-07-05T13:47:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001026s ] [2025-07-05T13:47:46+08:00][sql] SELECT `id`,`game`,`type`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ap`,`dp`,`af`,`as`,`am`,`df`,`ds`,`dm` FROM `trade_war` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 8 [ RunTime:0.000362s ] [2025-07-05T13:47:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001159s ] [2025-07-05T13:47:46+08:00][sql] SELECT `id`,`game`,`type`,`itemid`,`st`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ia`,`iav`,`ide`,`idm`,`rd`,`sl`,`cj`,`g1`,`g2`,`g3`,`g4`,`g5`,`g6` FROM `trade_equip` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 8 [ RunTime:0.000356s ] [2025-07-05T13:47:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000889s ] [2025-07-05T13:47:46+08:00][sql] SELECT `type`,`itemid`,`num` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 8 [ RunTime:0.000282s ] [2025-07-05T13:47:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001128s ] [2025-07-05T13:47:46+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (25001,25253,101206) [ RunTime:0.041365s ] [2025-07-05T13:47:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001312s ] [2025-07-05T13:47:46+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` = 8 [ RunTime:0.000328s ] [2025-07-05T13:47:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001008s ] [2025-07-05T13:47:46+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 8 [ RunTime:0.000310s ] [2025-07-05T13:47:46+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000296s ] [2025-07-05T13:47:46+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 8 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000291s ] [2025-07-05T13:47:46+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 8 LIMIT 1 [ RunTime:0.000394s ] [2025-07-05T13:47:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001015s ] [2025-07-05T13:47:46+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000255s ] [2025-07-05T13:48:03+08:00][sql] CONNECT:[ UseTime:0.001464s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:48:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001223s ] [2025-07-05T13:48:03+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000248s ] [2025-07-05T13:48:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001023s ] [2025-07-05T13:48:03+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000239s ] [2025-07-05T13:48:03+08:00][sql] CONNECT:[ UseTime:0.011019s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:48:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001292s ] [2025-07-05T13:48:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000923s ] [2025-07-05T13:48:03+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000418s ] [2025-07-05T13:48:04+08:00][sql] CONNECT:[ UseTime:0.001417s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:48:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001141s ] [2025-07-05T13:48:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_cate` LIMIT 1 [ RunTime:0.000481s ] [2025-07-05T13:48:04+08:00][sql] SELECT * FROM `trade_help_cate` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000218s ] [2025-07-05T13:48:16+08:00][sql] CONNECT:[ UseTime:0.010919s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:48:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001332s ] [2025-07-05T13:48:16+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000304s ] [2025-07-05T13:48:17+08:00][sql] CONNECT:[ UseTime:0.011444s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:48:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001459s ] [2025-07-05T13:48:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000257s ] [2025-07-05T13:48:20+08:00][sql] CONNECT:[ UseTime:0.001833s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:48:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001368s ] [2025-07-05T13:48:20+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000291s ] [2025-07-05T13:48:20+08:00][sql] CONNECT:[ UseTime:0.001458s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:48:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001391s ] [2025-07-05T13:48:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE `ordertype` = -1 LIMIT 1 [ RunTime:0.000383s ] [2025-07-05T13:48:20+08:00][sql] SELECT * FROM `trade_stats` WHERE `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000249s ] [2025-07-05T13:48:20+08:00][sql] CONNECT:[ UseTime:0.001452s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:48:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001234s ] [2025-07-05T13:48:20+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000280s ] [2025-07-05T13:48:20+08:00][sql] CONNECT:[ UseTime:0.010327s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:48:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001240s ] [2025-07-05T13:48:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000838s ] [2025-07-05T13:48:20+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000289s ] [2025-07-05T13:48:46+08:00][sql] CONNECT:[ UseTime:0.010970s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:48:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001446s ] [2025-07-05T13:48:46+08:00][sql] SELECT * FROM `trade_notice` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000274s ] [2025-07-05T13:48:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001082s ] [2025-07-05T13:48:46+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000231s ] [2025-07-05T13:48:57+08:00][sql] CONNECT:[ UseTime:0.001487s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:48:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001321s ] [2025-07-05T13:48:57+08:00][sql] SELECT * FROM `trade_notice` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000351s ] [2025-07-05T13:48:57+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001013s ] [2025-07-05T13:48:57+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000317s ] [2025-07-05T13:53:00+08:00][sql] CONNECT:[ UseTime:0.001477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:53:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001353s ] [2025-07-05T13:53:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000892s ] [2025-07-05T13:53:00+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000284s ] [2025-07-05T13:53:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001150s ] [2025-07-05T13:53:00+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000235s ] [2025-07-05T13:53:09+08:00][sql] CONNECT:[ UseTime:0.001486s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:53:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001622s ] [2025-07-05T13:53:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000835s ] [2025-07-05T13:53:09+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000261s ] [2025-07-05T13:53:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001149s ] [2025-07-05T13:53:09+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000379s ] [2025-07-05T13:53:09+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000999s ] [2025-07-05T13:53:09+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000292s ] [2025-07-05T13:53:23+08:00][sql] CONNECT:[ UseTime:0.011205s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:53:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001328s ] [2025-07-05T13:53:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001281s ] [2025-07-05T13:53:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001072s ] [2025-07-05T13:53:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001096s ] [2025-07-05T13:53:23+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000294s ] [2025-07-05T13:53:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001063s ] [2025-07-05T13:53:23+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` = 8 [ RunTime:0.000356s ] [2025-07-05T13:53:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001162s ] [2025-07-05T13:53:23+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` = 8 [ RunTime:0.000364s ] [2025-07-05T13:53:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000847s ] [2025-07-05T13:53:23+08:00][sql] SELECT `type`,`itemid`,`num` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 8 [ RunTime:0.000294s ] [2025-07-05T13:53:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001159s ] [2025-07-05T13:53:23+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.041091s ] [2025-07-05T13:53:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001184s ] [2025-07-05T13:53:23+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` = 8 [ RunTime:0.000328s ] [2025-07-05T13:53:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000964s ] [2025-07-05T13:53:23+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` = 8 [ RunTime:0.000329s ] [2025-07-05T13:53:23+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000211s ] [2025-07-05T13:53:23+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 8 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000342s ] [2025-07-05T13:53:23+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 8 LIMIT 1 [ RunTime:0.000234s ] [2025-07-05T13:53:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000884s ] [2025-07-05T13:53:23+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000258s ] [2025-07-05T13:53:36+08:00][sql] CONNECT:[ UseTime:0.001483s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:53:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001323s ] [2025-07-05T13:53:36+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000284s ] [2025-07-05T13:53:36+08:00][sql] CONNECT:[ UseTime:0.011004s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:53:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001505s ] [2025-07-05T13:53:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000946s ] [2025-07-05T13:53:36+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000296s ] [2025-07-05T13:53:36+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001234s ] [2025-07-05T13:53:36+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000307s ] [2025-07-05T13:53:36+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001047s ] [2025-07-05T13:53:36+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000255s ] [2025-07-05T13:53:50+08:00][sql] CONNECT:[ UseTime:0.001515s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:53:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001439s ] [2025-07-05T13:53:50+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000284s ] [2025-07-05T13:53:50+08:00][sql] CONNECT:[ UseTime:0.001827s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:53:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001540s ] [2025-07-05T13:53:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000964s ] [2025-07-05T13:53:50+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000285s ] [2025-07-05T13:53:51+08:00][sql] CONNECT:[ UseTime:0.011627s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:53:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001386s ] [2025-07-05T13:53:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000868s ] [2025-07-05T13:53:51+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000311s ] [2025-07-05T13:53:59+08:00][sql] CONNECT:[ UseTime:0.011688s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:53:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001412s ] [2025-07-05T13:53:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000904s ] [2025-07-05T13:53:59+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000272s ] [2025-07-05T13:53:59+08:00][sql] CONNECT:[ UseTime:0.010964s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:53:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001275s ] [2025-07-05T13:53:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000830s ] [2025-07-05T13:53:59+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000288s ] [2025-07-05T13:53:59+08:00][sql] CONNECT:[ UseTime:0.011012s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:53:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001422s ] [2025-07-05T13:53:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000902s ] [2025-07-05T13:53:59+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000239s ] [2025-07-05T13:54:12+08:00][sql] CONNECT:[ UseTime:0.011253s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001363s ] [2025-07-05T13:54:12+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000309s ] [2025-07-05T13:54:12+08:00][sql] CONNECT:[ UseTime:0.010983s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001475s ] [2025-07-05T13:54:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000900s ] [2025-07-05T13:54:12+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000348s ] [2025-07-05T13:54:12+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001183s ] [2025-07-05T13:54:12+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000276s ] [2025-07-05T13:54:12+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000923s ] [2025-07-05T13:54:12+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000285s ] [2025-07-05T13:54:31+08:00][sql] CONNECT:[ UseTime:0.010838s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001410s ] [2025-07-05T13:54:31+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` = 'R2025070513464430955604' LIMIT 1 [ RunTime:0.000300s ] [2025-07-05T13:54:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001160s ] [2025-07-05T13:54:31+08:00][sql] UPDATE `trade_order` SET `api_status` = 1 , `totime` = 1751694871 WHERE `id` = 9 [ RunTime:0.000461s ] [2025-07-05T13:54:31+08:00][sql] UPDATE `trade_role` SET `api_status` = 1 WHERE `id` = 6 [ RunTime:0.000291s ] [2025-07-05T13:54:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001177s ] [2025-07-05T13:54:31+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya' , `serverid` = 1 , `tid` = 8 , `username` = '16754025722' , `orderno` = 'R2025070513464430955604' , `trade_type` = 1 , `type` = 1 , `content` = '%s出售成功%s!如有疑问可联系官方客服咨询%s' [ RunTime:0.000288s ] [2025-07-05T13:54:32+08:00][sql] CONNECT:[ UseTime:0.001477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001421s ] [2025-07-05T13:54:32+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000291s ] [2025-07-05T13:54:32+08:00][sql] CONNECT:[ UseTime:0.001484s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001281s ] [2025-07-05T13:54:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE `ordertype` = -1 LIMIT 1 [ RunTime:0.000408s ] [2025-07-05T13:54:32+08:00][sql] SELECT * FROM `trade_stats` WHERE `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000333s ] [2025-07-05T13:54:33+08:00][sql] CONNECT:[ UseTime:0.010906s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001671s ] [2025-07-05T13:54:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000839s ] [2025-07-05T13:54:33+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000334s ] [2025-07-05T13:54:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001190s ] [2025-07-05T13:54:33+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000285s ] [2025-07-05T13:54:33+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000915s ] [2025-07-05T13:54:33+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000357s ] [2025-07-05T13:54:34+08:00][sql] CONNECT:[ UseTime:0.011072s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001309s ] [2025-07-05T13:54:34+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000297s ] [2025-07-05T13:54:34+08:00][sql] CONNECT:[ UseTime:0.011072s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001505s ] [2025-07-05T13:54:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000272s ] [2025-07-05T13:54:37+08:00][sql] CONNECT:[ UseTime:0.011631s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001508s ] [2025-07-05T13:54:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000829s ] [2025-07-05T13:54:37+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000333s ] [2025-07-05T13:54:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001235s ] [2025-07-05T13:54:37+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000284s ] [2025-07-05T13:54:37+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000962s ] [2025-07-05T13:54:37+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000280s ] [2025-07-05T13:54:45+08:00][sql] CONNECT:[ UseTime:0.001497s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001381s ] [2025-07-05T13:54:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000896s ] [2025-07-05T13:54:45+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000338s ] [2025-07-05T13:54:49+08:00][sql] CONNECT:[ UseTime:0.011548s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001319s ] [2025-07-05T13:54:49+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000304s ] [2025-07-05T13:54:49+08:00][sql] CONNECT:[ UseTime:0.011346s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001618s ] [2025-07-05T13:54:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000890s ] [2025-07-05T13:54:49+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000355s ] [2025-07-05T13:54:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001225s ] [2025-07-05T13:54:49+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000283s ] [2025-07-05T13:54:49+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000896s ] [2025-07-05T13:54:49+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000266s ] [2025-07-05T13:54:51+08:00][sql] CONNECT:[ UseTime:0.011463s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001304s ] [2025-07-05T13:54:51+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000296s ] [2025-07-05T13:54:51+08:00][sql] CONNECT:[ UseTime:0.011303s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001479s ] [2025-07-05T13:54:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000964s ] [2025-07-05T13:54:51+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000265s ] [2025-07-05T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001164s ] [2025-07-05T13:54:51+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000277s ] [2025-07-05T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000943s ] [2025-07-05T13:54:51+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000288s ] [2025-07-05T13:54:53+08:00][sql] CONNECT:[ UseTime:0.011169s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001385s ] [2025-07-05T13:54:53+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000328s ] [2025-07-05T13:54:53+08:00][sql] CONNECT:[ UseTime:0.001539s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:54:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001573s ] [2025-07-05T13:54:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000888s ] [2025-07-05T13:54:53+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000308s ] [2025-07-05T13:54:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001182s ] [2025-07-05T13:54:53+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000341s ] [2025-07-05T13:54:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001000s ] [2025-07-05T13:54:53+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000351s ] [2025-07-05T13:55:43+08:00][sql] CONNECT:[ UseTime:0.001540s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001437s ] [2025-07-05T13:55:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000288s ] [2025-07-05T13:55:43+08:00][sql] CONNECT:[ UseTime:0.011280s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001439s ] [2025-07-05T13:55:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000886s ] [2025-07-05T13:55:43+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000255s ] [2025-07-05T13:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001172s ] [2025-07-05T13:55:43+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000271s ] [2025-07-05T13:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000963s ] [2025-07-05T13:55:43+08:00][sql] CONNECT:[ UseTime:0.010981s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001225s ] [2025-07-05T13:55:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000291s ] [2025-07-05T13:55:43+08:00][sql] CONNECT:[ UseTime:0.011281s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001588s ] [2025-07-05T13:55:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000966s ] [2025-07-05T13:55:43+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000307s ] [2025-07-05T13:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001397s ] [2025-07-05T13:55:43+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000279s ] [2025-07-05T13:55:43+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001062s ] [2025-07-05T13:55:43+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000297s ] [2025-07-05T13:55:44+08:00][sql] CONNECT:[ UseTime:0.001469s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:55:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001474s ] [2025-07-05T13:55:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000909s ] [2025-07-05T13:55:44+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000275s ] [2025-07-05T13:55:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001170s ] [2025-07-05T13:55:44+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000308s ] [2025-07-05T13:55:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000992s ] [2025-07-05T13:55:44+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000267s ] [2025-07-05T13:55:46+08:00][sql] CONNECT:[ UseTime:0.001432s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:55:46+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001237s ] [2025-07-05T13:55:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001246s ] [2025-07-05T13:55:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001036s ] [2025-07-05T13:55:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.000989s ] [2025-07-05T13:55:46+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000279s ] [2025-07-05T13:55:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001015s ] [2025-07-05T13:55:46+08:00][sql] SELECT `id`,`game`,`type`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ap`,`dp`,`af`,`as`,`am`,`df`,`ds`,`dm` FROM `trade_war` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 8 [ RunTime:0.000334s ] [2025-07-05T13:55:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001079s ] [2025-07-05T13:55:46+08:00][sql] SELECT `id`,`game`,`type`,`itemid`,`st`,`hp`,`sp`,`mp`,`str`,`dex`,`int`,`wis`,`rec`,`luc`,`ia`,`iav`,`ide`,`idm`,`rd`,`sl`,`cj`,`g1`,`g2`,`g3`,`g4`,`g5`,`g6` FROM `trade_equip` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 8 [ RunTime:0.000330s ] [2025-07-05T13:55:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000823s ] [2025-07-05T13:55:46+08:00][sql] SELECT `type`,`itemid`,`num` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 8 [ RunTime:0.000301s ] [2025-07-05T13:55:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001046s ] [2025-07-05T13:55:46+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `itemid` IN (25001,25253,101206) [ RunTime:0.041535s ] [2025-07-05T13:55:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001372s ] [2025-07-05T13:55:46+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` = 8 [ RunTime:0.000363s ] [2025-07-05T13:55:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000997s ] [2025-07-05T13:55:46+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`wingid`,`level`,`grade`,`str`,`dex`,`rec`,`int`,`luc`,`wis`,`wear` FROM `trade_wing` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 8 [ RunTime:0.000377s ] [2025-07-05T13:55:46+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000188s ] [2025-07-05T13:55:46+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 8 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000341s ] [2025-07-05T13:55:46+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 8 LIMIT 1 [ RunTime:0.000307s ] [2025-07-05T13:55:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000938s ] [2025-07-05T13:55:46+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000224s ] [2025-07-05T13:55:50+08:00][sql] CONNECT:[ UseTime:0.011598s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:55:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001330s ] [2025-07-05T13:55:50+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000292s ] [2025-07-05T13:55:50+08:00][sql] CONNECT:[ UseTime:0.001337s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:55:50+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001149s ] [2025-07-05T13:55:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000824s ] [2025-07-05T13:55:50+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000243s ] [2025-07-05T13:55:52+08:00][sql] CONNECT:[ UseTime:0.011101s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:55:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001287s ] [2025-07-05T13:55:52+08:00][sql] SELECT * FROM `trade_notice` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000267s ] [2025-07-05T13:55:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000937s ] [2025-07-05T13:55:52+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000233s ] [2025-07-05T13:56:30+08:00][sql] CONNECT:[ UseTime:0.001508s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:56:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001350s ] [2025-07-05T13:56:30+08:00][sql] SELECT * FROM `trade_notice` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000282s ] [2025-07-05T13:56:30+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001023s ] [2025-07-05T13:56:30+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000254s ] [2025-07-05T13:57:26+08:00][sql] CONNECT:[ UseTime:0.011545s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:57:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001412s ] [2025-07-05T13:57:26+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000317s ] [2025-07-05T13:57:26+08:00][sql] CONNECT:[ UseTime:0.001477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:57:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001569s ] [2025-07-05T13:57:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000921s ] [2025-07-05T13:57:26+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000323s ] [2025-07-05T13:57:26+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001180s ] [2025-07-05T13:57:26+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000345s ] [2025-07-05T13:57:26+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000972s ] [2025-07-05T13:57:26+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000266s ] [2025-07-05T13:57:40+08:00][sql] CONNECT:[ UseTime:0.010957s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:57:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001334s ] [2025-07-05T13:57:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000309s ] [2025-07-05T13:57:40+08:00][sql] CONNECT:[ UseTime:0.010899s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:57:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001493s ] [2025-07-05T13:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000865s ] [2025-07-05T13:57:40+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000386s ] [2025-07-05T13:57:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001277s ] [2025-07-05T13:57:40+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000277s ] [2025-07-05T13:57:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001020s ] [2025-07-05T13:57:40+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000285s ] [2025-07-05T13:57:48+08:00][sql] CONNECT:[ UseTime:0.001436s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:57:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001329s ] [2025-07-05T13:57:48+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000285s ] [2025-07-05T13:57:48+08:00][sql] CONNECT:[ UseTime:0.011099s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:57:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001550s ] [2025-07-05T13:57:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000939s ] [2025-07-05T13:57:48+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000339s ] [2025-07-05T13:57:48+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001248s ] [2025-07-05T13:57:48+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000284s ] [2025-07-05T13:57:48+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000907s ] [2025-07-05T13:57:48+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000288s ] [2025-07-05T13:58:33+08:00][sql] CONNECT:[ UseTime:0.011519s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:58:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001378s ] [2025-07-05T13:58:33+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000314s ] [2025-07-05T13:58:33+08:00][sql] CONNECT:[ UseTime:0.010306s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:58:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001503s ] [2025-07-05T13:58:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000850s ] [2025-07-05T13:58:33+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000303s ] [2025-07-05T13:58:33+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001276s ] [2025-07-05T13:58:33+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000231s ] [2025-07-05T13:59:13+08:00][sql] CONNECT:[ UseTime:0.011532s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:59:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001334s ] [2025-07-05T13:59:13+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000287s ] [2025-07-05T13:59:13+08:00][sql] CONNECT:[ UseTime:0.011643s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T13:59:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001482s ] [2025-07-05T13:59:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000270s ] [2025-07-05T14:08:08+08:00][sql] CONNECT:[ UseTime:0.011176s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:08:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001601s ] [2025-07-05T14:08:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001257s ] [2025-07-05T14:08:08+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`relationid`,`ordertype`,`username`,`orderno`,`payuser`,`aliname`,`status`,`alitime`,`transfer_order_id` FROM `trade_withdraw` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000416s ] [2025-07-05T14:08:08+08:00][sql] SELECT `id`,`pay_status`,`api_status`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000240s ] [2025-07-05T14:08:08+08:00][sql] UPDATE `trade_withdraw` SET `op_type` = 2 , `status` = 3 , `remark` = '原因' , `certificate` = '' WHERE `id` = 1 [ RunTime:0.000318s ] [2025-07-05T14:08:08+08:00][sql] UPDATE `trade_order` SET `withdraw_status` = 3 WHERE `id` = 1 [ RunTime:0.000355s ] [2025-07-05T14:08:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000992s ] [2025-07-05T14:08:08+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya' , `serverid` = 1 , `tid` = 3 , `username` = 'ctshaiya014' , `orderno` = 'R2025070315403097811238' , `trade_type` = 1 , `type` = 4 , `content` = '您有一笔订单提现失败%s,请联系官方客服咨询处理%s' [ RunTime:0.000294s ] [2025-07-05T14:08:10+08:00][sql] CONNECT:[ UseTime:0.011118s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:08:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001474s ] [2025-07-05T14:08:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000885s ] [2025-07-05T14:08:10+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000247s ] [2025-07-05T14:08:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001234s ] [2025-07-05T14:08:10+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000235s ] [2025-07-05T14:08:16+08:00][sql] CONNECT:[ UseTime:0.010668s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:08:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001563s ] [2025-07-05T14:08:16+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000384s ] [2025-07-05T14:08:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001220s ] [2025-07-05T14:08:16+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000234s ] [2025-07-05T14:08:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001046s ] [2025-07-05T14:08:16+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000247s ] [2025-07-05T14:08:45+08:00][sql] CONNECT:[ UseTime:0.010954s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:08:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001423s ] [2025-07-05T14:08:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000331s ] [2025-07-05T14:08:45+08:00][sql] CONNECT:[ UseTime:0.001536s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:08:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001483s ] [2025-07-05T14:08:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE `ordertype` = -1 LIMIT 1 [ RunTime:0.000272s ] [2025-07-05T14:08:45+08:00][sql] SELECT * FROM `trade_stats` WHERE `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000228s ] [2025-07-05T14:08:49+08:00][sql] CONNECT:[ UseTime:0.011533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:08:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001356s ] [2025-07-05T14:08:49+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000290s ] [2025-07-05T14:08:49+08:00][sql] CONNECT:[ UseTime:0.011161s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:08:49+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001335s ] [2025-07-05T14:08:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000806s ] [2025-07-05T14:08:49+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000266s ] [2025-07-05T14:08:52+08:00][sql] CONNECT:[ UseTime:0.001611s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:08:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001304s ] [2025-07-05T14:08:52+08:00][sql] SELECT * FROM `trade_notice` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000263s ] [2025-07-05T14:08:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000944s ] [2025-07-05T14:08:52+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000236s ] [2025-07-05T14:08:59+08:00][sql] CONNECT:[ UseTime:0.001500s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:08:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001497s ] [2025-07-05T14:08:59+08:00][sql] SELECT * FROM `trade_notice` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000280s ] [2025-07-05T14:08:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001105s ] [2025-07-05T14:08:59+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000257s ] [2025-07-05T14:09:00+08:00][sql] CONNECT:[ UseTime:0.001507s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001496s ] [2025-07-05T14:09:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000841s ] [2025-07-05T14:09:00+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000284s ] [2025-07-05T14:09:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001286s ] [2025-07-05T14:09:00+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000286s ] [2025-07-05T14:09:00+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001046s ] [2025-07-05T14:09:00+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000381s ] [2025-07-05T14:09:01+08:00][sql] CONNECT:[ UseTime:0.001512s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001492s ] [2025-07-05T14:09:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000830s ] [2025-07-05T14:09:01+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000268s ] [2025-07-05T14:09:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001221s ] [2025-07-05T14:09:01+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000280s ] [2025-07-05T14:09:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001003s ] [2025-07-05T14:09:01+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000292s ] [2025-07-05T14:09:01+08:00][sql] CONNECT:[ UseTime:0.011441s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001468s ] [2025-07-05T14:09:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000875s ] [2025-07-05T14:09:01+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000285s ] [2025-07-05T14:09:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001137s ] [2025-07-05T14:09:01+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000294s ] [2025-07-05T14:09:01+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000911s ] [2025-07-05T14:09:01+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000260s ] [2025-07-05T14:09:02+08:00][sql] CONNECT:[ UseTime:0.001898s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001728s ] [2025-07-05T14:09:02+08:00][sql] SELECT * FROM `trade_notice` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000430s ] [2025-07-05T14:09:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001444s ] [2025-07-05T14:09:02+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000341s ] [2025-07-05T14:09:02+08:00][sql] CONNECT:[ UseTime:0.001874s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.002022s ] [2025-07-05T14:09:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000923s ] [2025-07-05T14:09:02+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000357s ] [2025-07-05T14:09:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001688s ] [2025-07-05T14:09:02+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000406s ] [2025-07-05T14:09:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001413s ] [2025-07-05T14:09:02+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000374s ] [2025-07-05T14:09:02+08:00][sql] CONNECT:[ UseTime:0.011415s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001542s ] [2025-07-05T14:09:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000927s ] [2025-07-05T14:09:02+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000271s ] [2025-07-05T14:09:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001193s ] [2025-07-05T14:09:02+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000279s ] [2025-07-05T14:09:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000977s ] [2025-07-05T14:09:02+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000265s ] [2025-07-05T14:09:02+08:00][sql] CONNECT:[ UseTime:0.011301s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001479s ] [2025-07-05T14:09:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000911s ] [2025-07-05T14:09:02+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000301s ] [2025-07-05T14:09:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001263s ] [2025-07-05T14:09:02+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000293s ] [2025-07-05T14:09:02+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000961s ] [2025-07-05T14:09:02+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000309s ] [2025-07-05T14:09:03+08:00][sql] CONNECT:[ UseTime:0.011198s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001481s ] [2025-07-05T14:09:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000858s ] [2025-07-05T14:09:03+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000289s ] [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001304s ] [2025-07-05T14:09:03+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000305s ] [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000962s ] [2025-07-05T14:09:03+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000288s ] [2025-07-05T14:09:03+08:00][sql] CONNECT:[ UseTime:0.010513s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001606s ] [2025-07-05T14:09:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000838s ] [2025-07-05T14:09:03+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000358s ] [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001282s ] [2025-07-05T14:09:03+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000304s ] [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000951s ] [2025-07-05T14:09:03+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000277s ] [2025-07-05T14:09:03+08:00][sql] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001505s ] [2025-07-05T14:09:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000902s ] [2025-07-05T14:09:03+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000324s ] [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001259s ] [2025-07-05T14:09:03+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000360s ] [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001030s ] [2025-07-05T14:09:03+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000249s ] [2025-07-05T14:09:03+08:00][sql] CONNECT:[ UseTime:0.011592s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001543s ] [2025-07-05T14:09:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000859s ] [2025-07-05T14:09:03+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000291s ] [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001155s ] [2025-07-05T14:09:03+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000291s ] [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000914s ] [2025-07-05T14:09:03+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000277s ] [2025-07-05T14:09:03+08:00][sql] CONNECT:[ UseTime:0.010724s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001498s ] [2025-07-05T14:09:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000832s ] [2025-07-05T14:09:03+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000277s ] [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001128s ] [2025-07-05T14:09:03+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000286s ] [2025-07-05T14:09:03+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000951s ] [2025-07-05T14:09:03+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000258s ] [2025-07-05T14:09:04+08:00][sql] CONNECT:[ UseTime:0.001495s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001495s ] [2025-07-05T14:09:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000839s ] [2025-07-05T14:09:04+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000293s ] [2025-07-05T14:09:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001211s ] [2025-07-05T14:09:04+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000469s ] [2025-07-05T14:09:04+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001104s ] [2025-07-05T14:09:04+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000440s ] [2025-07-05T14:09:04+08:00][sql] CONNECT:[ UseTime:0.011335s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001692s ] [2025-07-05T14:09:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000826s ] [2025-07-05T14:09:04+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000272s ] [2025-07-05T14:09:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001223s ] [2025-07-05T14:09:04+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000291s ] [2025-07-05T14:09:04+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000982s ] [2025-07-05T14:09:04+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000270s ] [2025-07-05T14:09:04+08:00][sql] CONNECT:[ UseTime:0.010542s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001514s ] [2025-07-05T14:09:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000874s ] [2025-07-05T14:09:04+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000311s ] [2025-07-05T14:09:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001165s ] [2025-07-05T14:09:04+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000300s ] [2025-07-05T14:09:04+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000968s ] [2025-07-05T14:09:04+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000263s ] [2025-07-05T14:09:05+08:00][sql] CONNECT:[ UseTime:0.010929s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001386s ] [2025-07-05T14:09:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000848s ] [2025-07-05T14:09:05+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000347s ] [2025-07-05T14:09:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001209s ] [2025-07-05T14:09:05+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000300s ] [2025-07-05T14:09:05+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000986s ] [2025-07-05T14:09:05+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000272s ] [2025-07-05T14:09:05+08:00][sql] CONNECT:[ UseTime:0.011056s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001473s ] [2025-07-05T14:09:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000837s ] [2025-07-05T14:09:05+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000335s ] [2025-07-05T14:09:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001206s ] [2025-07-05T14:09:05+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000301s ] [2025-07-05T14:09:05+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000941s ] [2025-07-05T14:09:05+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000286s ] [2025-07-05T14:09:05+08:00][sql] CONNECT:[ UseTime:0.010974s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001453s ] [2025-07-05T14:09:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000912s ] [2025-07-05T14:09:05+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000261s ] [2025-07-05T14:09:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001242s ] [2025-07-05T14:09:05+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000274s ] [2025-07-05T14:09:05+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001017s ] [2025-07-05T14:09:05+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000286s ] [2025-07-05T14:09:06+08:00][sql] CONNECT:[ UseTime:0.001515s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001519s ] [2025-07-05T14:09:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000892s ] [2025-07-05T14:09:06+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000294s ] [2025-07-05T14:09:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001146s ] [2025-07-05T14:09:06+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000296s ] [2025-07-05T14:09:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000957s ] [2025-07-05T14:09:06+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000257s ] [2025-07-05T14:09:06+08:00][sql] CONNECT:[ UseTime:0.011202s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001476s ] [2025-07-05T14:09:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000845s ] [2025-07-05T14:09:06+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000281s ] [2025-07-05T14:09:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001217s ] [2025-07-05T14:09:06+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000307s ] [2025-07-05T14:09:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001002s ] [2025-07-05T14:09:06+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000266s ] [2025-07-05T14:09:06+08:00][sql] CONNECT:[ UseTime:0.011012s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001527s ] [2025-07-05T14:09:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000951s ] [2025-07-05T14:09:06+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000251s ] [2025-07-05T14:09:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001134s ] [2025-07-05T14:09:06+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000293s ] [2025-07-05T14:09:06+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000905s ] [2025-07-05T14:09:06+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000272s ] [2025-07-05T14:09:07+08:00][sql] CONNECT:[ UseTime:0.011243s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001463s ] [2025-07-05T14:09:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000861s ] [2025-07-05T14:09:07+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000346s ] [2025-07-05T14:09:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001303s ] [2025-07-05T14:09:07+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000342s ] [2025-07-05T14:09:07+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001031s ] [2025-07-05T14:09:07+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000275s ] [2025-07-05T14:09:08+08:00][sql] CONNECT:[ UseTime:0.011452s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001316s ] [2025-07-05T14:09:08+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000293s ] [2025-07-05T14:09:09+08:00][sql] CONNECT:[ UseTime:0.011540s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001398s ] [2025-07-05T14:09:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000837s ] [2025-07-05T14:09:09+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000235s ] [2025-07-05T14:09:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001188s ] [2025-07-05T14:09:09+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000238s ] [2025-07-05T14:09:10+08:00][sql] CONNECT:[ UseTime:0.011423s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001318s ] [2025-07-05T14:09:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000937s ] [2025-07-05T14:09:10+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000272s ] [2025-07-05T14:09:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001272s ] [2025-07-05T14:09:10+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000253s ] [2025-07-05T14:09:10+08:00][sql] CONNECT:[ UseTime:0.010944s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001433s ] [2025-07-05T14:09:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000835s ] [2025-07-05T14:09:10+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000245s ] [2025-07-05T14:09:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001213s ] [2025-07-05T14:09:10+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000238s ] [2025-07-05T14:09:10+08:00][sql] CONNECT:[ UseTime:0.011353s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001407s ] [2025-07-05T14:09:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.001001s ] [2025-07-05T14:09:10+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000255s ] [2025-07-05T14:09:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001120s ] [2025-07-05T14:09:10+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000240s ] [2025-07-05T14:09:11+08:00][sql] CONNECT:[ UseTime:0.011147s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001592s ] [2025-07-05T14:09:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.001005s ] [2025-07-05T14:09:11+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000316s ] [2025-07-05T14:09:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001155s ] [2025-07-05T14:09:11+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000262s ] [2025-07-05T14:09:21+08:00][sql] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:09:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001505s ] [2025-07-05T14:09:21+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000281s ] [2025-07-05T14:09:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001161s ] [2025-07-05T14:09:21+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000291s ] [2025-07-05T14:09:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000998s ] [2025-07-05T14:09:21+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000227s ] [2025-07-05T14:10:04+08:00][sql] CONNECT:[ UseTime:0.011128s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:10:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001256s ] [2025-07-05T14:10:04+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000281s ] [2025-07-05T14:10:04+08:00][sql] CONNECT:[ UseTime:0.001566s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:10:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001517s ] [2025-07-05T14:10:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000900s ] [2025-07-05T14:10:04+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000331s ] [2025-07-05T14:10:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001262s ] [2025-07-05T14:10:04+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000304s ] [2025-07-05T14:10:04+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001054s ] [2025-07-05T14:10:19+08:00][sql] CONNECT:[ UseTime:0.001481s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:10:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001295s ] [2025-07-05T14:10:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000312s ] [2025-07-05T14:10:19+08:00][sql] CONNECT:[ UseTime:0.011427s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:10:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001483s ] [2025-07-05T14:10:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000241s ] [2025-07-05T14:15:54+08:00][sql] CONNECT:[ UseTime:0.011508s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:15:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001791s ] [2025-07-05T14:15:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001636s ] [2025-07-05T14:15:54+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`relationid`,`ordertype`,`username`,`orderno`,`payuser`,`aliname`,`status`,`alitime`,`transfer_order_id` FROM `trade_withdraw` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000437s ] [2025-07-05T14:15:54+08:00][sql] SELECT `id`,`pay_status`,`api_status`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000376s ] [2025-07-05T14:15:54+08:00][sql] UPDATE `trade_withdraw` SET `op_type` = 2 , `status` = 3 , `remark` = '1' , `certificate` = '' WHERE `id` = 1 [ RunTime:0.000421s ] [2025-07-05T14:15:54+08:00][sql] UPDATE `trade_order` SET `withdraw_status` = 3 WHERE `id` = 1 [ RunTime:0.000301s ] [2025-07-05T14:15:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001124s ] [2025-07-05T14:15:54+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya' , `serverid` = 1 , `tid` = 3 , `username` = 'ctshaiya014' , `orderno` = 'R2025070315403097811238' , `trade_type` = 1 , `type` = 4 , `content` = '您有一笔订单提现失败%s,请联系官方客服咨询处理%s' [ RunTime:0.000278s ] [2025-07-05T14:15:55+08:00][sql] CONNECT:[ UseTime:0.001441s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:15:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001489s ] [2025-07-05T14:15:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000947s ] [2025-07-05T14:15:55+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000281s ] [2025-07-05T14:15:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001183s ] [2025-07-05T14:15:55+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000235s ] [2025-07-05T14:16:03+08:00][sql] CONNECT:[ UseTime:0.001523s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:16:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001445s ] [2025-07-05T14:16:03+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000288s ] [2025-07-05T14:16:03+08:00][sql] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:16:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001572s ] [2025-07-05T14:16:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000823s ] [2025-07-05T14:16:03+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000313s ] [2025-07-05T14:16:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001110s ] [2025-07-05T14:16:03+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000217s ] [2025-07-05T14:16:15+08:00][sql] CONNECT:[ UseTime:0.010961s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:16:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001458s ] [2025-07-05T14:16:15+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000305s ] [2025-07-05T14:16:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001179s ] [2025-07-05T14:16:15+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000231s ] [2025-07-05T14:16:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001037s ] [2025-07-05T14:16:15+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000276s ] [2025-07-05T14:16:53+08:00][sql] CONNECT:[ UseTime:0.001454s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:16:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001426s ] [2025-07-05T14:16:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001172s ] [2025-07-05T14:16:53+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`relationid`,`ordertype`,`username`,`orderno`,`payuser`,`aliname`,`status`,`alitime`,`transfer_order_id` FROM `trade_withdraw` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000403s ] [2025-07-05T14:16:53+08:00][sql] SELECT `id`,`pay_status`,`api_status`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000219s ] [2025-07-05T14:16:53+08:00][sql] UPDATE `trade_withdraw` SET `op_type` = 2 , `status` = 2 , `remark` = '成功' , `certificate` = '/storage/upload/20250705/754623086cafe509a91e27e6c9cd4d6b.png' WHERE `id` = 1 [ RunTime:0.000304s ] [2025-07-05T14:16:53+08:00][sql] UPDATE `trade_order` SET `withdraw_status` = 2 WHERE `id` = 1 [ RunTime:0.000215s ] [2025-07-05T14:16:55+08:00][sql] CONNECT:[ UseTime:0.011477s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:16:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001459s ] [2025-07-05T14:16:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000896s ] [2025-07-05T14:16:55+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000281s ] [2025-07-05T14:16:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001164s ] [2025-07-05T14:16:55+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000235s ] [2025-07-05T14:17:07+08:00][sql] CONNECT:[ UseTime:0.011542s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:17:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001492s ] [2025-07-05T14:17:07+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000321s ] [2025-07-05T14:17:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001227s ] [2025-07-05T14:17:07+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000224s ] [2025-07-05T14:17:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001037s ] [2025-07-05T14:17:07+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000319s ] [2025-07-05T14:30:29+08:00][sql] CONNECT:[ UseTime:0.010987s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:30:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001381s ] [2025-07-05T14:30:29+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000298s ] [2025-07-05T14:30:29+08:00][sql] CONNECT:[ UseTime:0.010944s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:30:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001588s ] [2025-07-05T14:30:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000852s ] [2025-07-05T14:30:29+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000282s ] [2025-07-05T14:30:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001253s ] [2025-07-05T14:30:29+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000296s ] [2025-07-05T14:30:29+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000992s ] [2025-07-05T14:30:29+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000285s ] [2025-07-05T14:31:32+08:00][sql] CONNECT:[ UseTime:0.010434s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:31:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001481s ] [2025-07-05T14:31:32+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000370s ] [2025-07-05T14:31:32+08:00][sql] CONNECT:[ UseTime:0.011027s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:31:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001609s ] [2025-07-05T14:31:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000309s ] [2025-07-05T14:31:34+08:00][sql] CONNECT:[ UseTime:0.011514s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001373s ] [2025-07-05T14:31:34+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000321s ] [2025-07-05T14:31:34+08:00][sql] CONNECT:[ UseTime:0.001506s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:31:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001401s ] [2025-07-05T14:31:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE `ordertype` = -1 LIMIT 1 [ RunTime:0.000387s ] [2025-07-05T14:31:34+08:00][sql] SELECT * FROM `trade_stats` WHERE `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000238s ] [2025-07-05T14:32:22+08:00][sql] CONNECT:[ UseTime:0.011143s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001330s ] [2025-07-05T14:32:22+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000277s ] [2025-07-05T14:32:22+08:00][sql] CONNECT:[ UseTime:0.010937s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001467s ] [2025-07-05T14:32:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000905s ] [2025-07-05T14:32:22+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000304s ] [2025-07-05T14:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001188s ] [2025-07-05T14:32:22+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000266s ] [2025-07-05T14:32:22+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000996s ] [2025-07-05T14:33:47+08:00][sql] CONNECT:[ UseTime:0.011593s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:33:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001456s ] [2025-07-05T14:33:47+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000317s ] [2025-07-05T14:33:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001134s ] [2025-07-05T14:33:47+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000231s ] [2025-07-05T14:33:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000980s ] [2025-07-05T14:33:47+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000242s ] [2025-07-05T14:44:09+08:00][sql] CONNECT:[ UseTime:0.011381s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:44:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001324s ] [2025-07-05T14:44:09+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000302s ] [2025-07-05T14:44:10+08:00][sql] CONNECT:[ UseTime:0.001495s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:44:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001481s ] [2025-07-05T14:44:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000909s ] [2025-07-05T14:44:10+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000289s ] [2025-07-05T14:44:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001178s ] [2025-07-05T14:44:10+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000238s ] [2025-07-05T14:47:45+08:00][sql] CONNECT:[ UseTime:0.011227s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:47:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001418s ] [2025-07-05T14:47:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000354s ] [2025-07-05T14:47:45+08:00][sql] CONNECT:[ UseTime:0.001560s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:47:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001503s ] [2025-07-05T14:47:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000852s ] [2025-07-05T14:47:45+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000229s ] [2025-07-05T14:47:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001221s ] [2025-07-05T14:47:45+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000307s ] [2025-07-05T14:48:54+08:00][sql] CONNECT:[ UseTime:0.011334s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:48:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001348s ] [2025-07-05T14:48:54+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000294s ] [2025-07-05T14:48:54+08:00][sql] CONNECT:[ UseTime:0.001509s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:48:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001474s ] [2025-07-05T14:48:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000836s ] [2025-07-05T14:48:54+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000263s ] [2025-07-05T14:48:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001143s ] [2025-07-05T14:48:54+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000227s ] [2025-07-05T14:50:06+08:00][sql] CONNECT:[ UseTime:0.011516s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001377s ] [2025-07-05T14:50:06+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000286s ] [2025-07-05T14:50:07+08:00][sql] CONNECT:[ UseTime:0.011863s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001458s ] [2025-07-05T14:50:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000868s ] [2025-07-05T14:50:07+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000259s ] [2025-07-05T14:50:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001130s ] [2025-07-05T14:50:07+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000250s ] [2025-07-05T14:50:08+08:00][sql] CONNECT:[ UseTime:0.001482s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001406s ] [2025-07-05T14:50:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000818s ] [2025-07-05T14:50:08+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000257s ] [2025-07-05T14:50:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001197s ] [2025-07-05T14:50:08+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000233s ] [2025-07-05T14:50:08+08:00][sql] CONNECT:[ UseTime:0.010495s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001573s ] [2025-07-05T14:50:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000948s ] [2025-07-05T14:50:08+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000264s ] [2025-07-05T14:50:08+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001185s ] [2025-07-05T14:50:08+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000234s ] [2025-07-05T14:50:09+08:00][sql] CONNECT:[ UseTime:0.011351s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001416s ] [2025-07-05T14:50:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000828s ] [2025-07-05T14:50:09+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000241s ] [2025-07-05T14:50:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001152s ] [2025-07-05T14:50:09+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000243s ] [2025-07-05T14:50:09+08:00][sql] CONNECT:[ UseTime:0.001579s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001600s ] [2025-07-05T14:50:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000840s ] [2025-07-05T14:50:09+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000219s ] [2025-07-05T14:50:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001248s ] [2025-07-05T14:50:09+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000233s ] [2025-07-05T14:50:10+08:00][sql] CONNECT:[ UseTime:0.011070s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001470s ] [2025-07-05T14:50:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000830s ] [2025-07-05T14:50:10+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000240s ] [2025-07-05T14:50:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001145s ] [2025-07-05T14:50:10+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000246s ] [2025-07-05T14:50:25+08:00][sql] CONNECT:[ UseTime:0.010557s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001368s ] [2025-07-05T14:50:25+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000369s ] [2025-07-05T14:50:25+08:00][sql] CONNECT:[ UseTime:0.011301s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001455s ] [2025-07-05T14:50:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000873s ] [2025-07-05T14:50:25+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000279s ] [2025-07-05T14:50:25+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001221s ] [2025-07-05T14:50:25+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000234s ] [2025-07-05T14:50:27+08:00][sql] CONNECT:[ UseTime:0.011583s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001505s ] [2025-07-05T14:50:27+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000372s ] [2025-07-05T14:50:27+08:00][sql] CONNECT:[ UseTime:0.010943s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001467s ] [2025-07-05T14:50:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000806s ] [2025-07-05T14:50:27+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000294s ] [2025-07-05T14:50:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001188s ] [2025-07-05T14:50:27+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000290s ] [2025-07-05T14:50:27+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000966s ] [2025-07-05T14:50:27+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000251s ] [2025-07-05T14:50:37+08:00][sql] CONNECT:[ UseTime:0.011039s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:50:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001420s ] [2025-07-05T14:50:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000858s ] [2025-07-05T14:50:37+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000254s ] [2025-07-05T14:50:37+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001247s ] [2025-07-05T14:50:37+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000272s ] [2025-07-05T14:54:20+08:00][sql] CONNECT:[ UseTime:0.011376s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:54:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001383s ] [2025-07-05T14:54:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000884s ] [2025-07-05T14:54:20+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000254s ] [2025-07-05T14:54:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001107s ] [2025-07-05T14:54:20+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000314s ] [2025-07-05T14:54:20+08:00][sql] CONNECT:[ UseTime:0.011499s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:54:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001528s ] [2025-07-05T14:54:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000950s ] [2025-07-05T14:54:20+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000248s ] [2025-07-05T14:54:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001130s ] [2025-07-05T14:54:20+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000222s ] [2025-07-05T14:54:20+08:00][sql] CONNECT:[ UseTime:0.001401s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:54:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001327s ] [2025-07-05T14:54:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000861s ] [2025-07-05T14:54:20+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000451s ] [2025-07-05T14:54:20+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001293s ] [2025-07-05T14:54:20+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000238s ] [2025-07-05T14:54:22+08:00][sql] CONNECT:[ UseTime:0.010987s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:54:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001416s ] [2025-07-05T14:54:22+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000292s ] [2025-07-05T14:54:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001099s ] [2025-07-05T14:54:22+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000232s ] [2025-07-05T14:54:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000958s ] [2025-07-05T14:54:22+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000236s ] [2025-07-05T14:54:29+08:00][sql] CONNECT:[ UseTime:0.001544s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:54:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001427s ] [2025-07-05T14:54:29+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000280s ] [2025-07-05T14:54:29+08:00][sql] CONNECT:[ UseTime:0.010922s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:54:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001572s ] [2025-07-05T14:54:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.005964s ] [2025-07-05T14:54:29+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.027273s ] [2025-07-05T14:55:38+08:00][sql] CONNECT:[ UseTime:0.001954s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T14:55:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001980s ] [2025-07-05T14:55:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.006107s ] [2025-07-05T14:55:38+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.027117s ] [2025-07-05T15:06:18+08:00][sql] CONNECT:[ UseTime:0.001583s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:06:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001491s ] [2025-07-05T15:06:18+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000282s ] [2025-07-05T15:06:18+08:00][sql] CONNECT:[ UseTime:0.001542s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:06:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001513s ] [2025-07-05T15:06:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000881s ] [2025-07-05T15:06:18+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000288s ] [2025-07-05T15:06:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001236s ] [2025-07-05T15:06:18+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000236s ] [2025-07-05T15:30:46+08:00][sql] CONNECT:[ UseTime:0.011021s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001451s ] [2025-07-05T15:30:46+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000325s ] [2025-07-05T15:30:46+08:00][sql] CONNECT:[ UseTime:0.011056s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:30:46+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001393s ] [2025-07-05T15:30:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000248s ] [2025-07-05T15:30:47+08:00][sql] CONNECT:[ UseTime:0.001516s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:30:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001392s ] [2025-07-05T15:30:47+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000300s ] [2025-07-05T15:30:47+08:00][sql] CONNECT:[ UseTime:0.001629s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:30:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.002079s ] [2025-07-05T15:30:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000971s ] [2025-07-05T15:30:47+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000270s ] [2025-07-05T15:30:47+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001161s ] [2025-07-05T15:30:47+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000294s ] [2025-07-05T15:30:47+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000951s ] [2025-07-05T15:30:47+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (8,5,4,3,2,1) [ RunTime:0.000265s ] [2025-07-05T15:32:21+08:00][sql] CONNECT:[ UseTime:0.001421s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:32:21+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001380s ] [2025-07-05T15:32:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000889s ] [2025-07-05T15:32:21+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000261s ] [2025-07-05T15:32:32+08:00][sql] CONNECT:[ UseTime:0.011425s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:32:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001428s ] [2025-07-05T15:32:32+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 1 , `servername` = '晓夜之歌' , `image` = '/storage/upload/20250705/a5f23aace46dd0ec228f2d35de0a5e80.png' , `status` = 1 , `is_mtain` = 1 WHERE `id` = 2 [ RunTime:0.004482s ] [2025-07-05T15:32:34+08:00][sql] CONNECT:[ UseTime:0.011068s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:32:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001248s ] [2025-07-05T15:32:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000841s ] [2025-07-05T15:32:34+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000246s ] [2025-07-05T15:39:04+08:00][sql] CONNECT:[ UseTime:0.001404s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:39:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001420s ] [2025-07-05T15:39:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000919s ] [2025-07-05T15:39:04+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000326s ] [2025-07-05T15:40:28+08:00][sql] CONNECT:[ UseTime:0.011099s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:40:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001478s ] [2025-07-05T15:40:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000858s ] [2025-07-05T15:40:28+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000301s ] [2025-07-05T15:40:44+08:00][sql] CONNECT:[ UseTime:0.010836s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:40:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001352s ] [2025-07-05T15:40:44+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000303s ] [2025-07-05T15:40:44+08:00][sql] CONNECT:[ UseTime:0.010988s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:40:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001560s ] [2025-07-05T15:40:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000941s ] [2025-07-05T15:40:44+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000245s ] [2025-07-05T15:40:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001176s ] [2025-07-05T15:40:44+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000292s ] [2025-07-05T15:40:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000946s ] [2025-07-05T15:40:44+08:00][sql] CONNECT:[ UseTime:0.011316s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:40:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001321s ] [2025-07-05T15:40:44+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000352s ] [2025-07-05T15:40:44+08:00][sql] CONNECT:[ UseTime:0.001492s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:40:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001564s ] [2025-07-05T15:40:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000920s ] [2025-07-05T15:40:44+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000300s ] [2025-07-05T15:40:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001156s ] [2025-07-05T15:40:44+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (9,8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000295s ] [2025-07-05T15:40:44+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000934s ] [2025-07-05T15:40:44+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (9,8,5,4,3,2,1) [ RunTime:0.000293s ] [2025-07-05T15:40:55+08:00][sql] CONNECT:[ UseTime:0.001511s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001365s ] [2025-07-05T15:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001399s ] [2025-07-05T15:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001140s ] [2025-07-05T15:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001127s ] [2025-07-05T15:40:55+08:00][sql] SELECT * FROM `trade_role` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000279s ] [2025-07-05T15:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001225s ] [2025-07-05T15:40: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` = 9 [ RunTime:0.000417s ] [2025-07-05T15:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001228s ] [2025-07-05T15:40: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` = 9 [ RunTime:0.000390s ] [2025-07-05T15:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.000913s ] [2025-07-05T15:40:55+08:00][sql] SELECT `type`,`itemid`,`num` FROM `trade_backpack` WHERE `game` = 'shaiya' AND `serverid` = 1 AND `tid` = 9 [ RunTime:0.000288s ] [2025-07-05T15:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001185s ] [2025-07-05T15:40: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 (25013,38208,101206) [ RunTime:0.043421s ] [2025-07-05T15:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001376s ] [2025-07-05T15:40: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` = 9 [ RunTime:0.000390s ] [2025-07-05T15:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.001037s ] [2025-07-05T15:40: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` = 9 [ RunTime:0.000369s ] [2025-07-05T15:40:55+08:00][sql] SELECT `sync_status` FROM `trade` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000184s ] [2025-07-05T15:40:55+08:00][sql] SELECT * FROM `trade_order` WHERE `tid` = 9 AND `ordertype` = 1 AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000336s ] [2025-07-05T15:40:55+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `tid` = 9 LIMIT 1 [ RunTime:0.000214s ] [2025-07-05T15:40:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000982s ] [2025-07-05T15:40:55+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000404s ] [2025-07-05T15:41:04+08:00][sql] CONNECT:[ UseTime:0.001489s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:41:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001427s ] [2025-07-05T15:41:04+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000299s ] [2025-07-05T15:41:04+08:00][sql] CONNECT:[ UseTime:0.011554s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:41:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001451s ] [2025-07-05T15:41:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000247s ] [2025-07-05T15:41:06+08:00][sql] CONNECT:[ UseTime:0.001520s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:41:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001442s ] [2025-07-05T15:41:06+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000272s ] [2025-07-05T15:41:06+08:00][sql] CONNECT:[ UseTime:0.011042s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:41:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001414s ] [2025-07-05T15:41:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000895s ] [2025-07-05T15:41:06+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000288s ] [2025-07-05T15:41:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001200s ] [2025-07-05T15:41:06+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000248s ] [2025-07-05T15:41:07+08:00][sql] CONNECT:[ UseTime:0.001541s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:41:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001441s ] [2025-07-05T15:41:07+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000312s ] [2025-07-05T15:41:07+08:00][sql] CONNECT:[ UseTime:0.001468s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:41:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001406s ] [2025-07-05T15:41:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE `ordertype` = -1 LIMIT 1 [ RunTime:0.000410s ] [2025-07-05T15:41:07+08:00][sql] SELECT * FROM `trade_stats` WHERE `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000249s ] [2025-07-05T15:51:16+08:00][sql] CONNECT:[ UseTime:0.011390s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:51:16+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001463s ] [2025-07-05T15:51:16+08:00][sql] UPDATE `trade_game` SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 1 , `servername` = '晓夜之歌' , `image` = '/storage/upload/20250705/a5f23aace46dd0ec228f2d35de0a5e80.png' , `status` = 1 , `is_mtain` = 0 WHERE `id` = 2 [ RunTime:0.002417s ] [2025-07-05T15:51:18+08:00][sql] CONNECT:[ UseTime:0.001480s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:51:18+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001321s ] [2025-07-05T15:51:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000903s ] [2025-07-05T15:51:18+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000257s ] [2025-07-05T15:51:22+08:00][sql] CONNECT:[ UseTime:0.011282s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:51:22+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001368s ] [2025-07-05T15:51:22+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000313s ] [2025-07-05T15:51:23+08:00][sql] CONNECT:[ UseTime:0.010904s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:51:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001379s ] [2025-07-05T15:51:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000849s ] [2025-07-05T15:51:23+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000230s ] [2025-07-05T15:51:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001184s ] [2025-07-05T15:51:23+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000287s ] [2025-07-05T15:51:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000970s ] [2025-07-05T15:51:23+08:00][sql] CONNECT:[ UseTime:0.011105s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:51:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001413s ] [2025-07-05T15:51:23+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000289s ] [2025-07-05T15:51:23+08:00][sql] CONNECT:[ UseTime:0.011667s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:51:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001479s ] [2025-07-05T15:51:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000873s ] [2025-07-05T15:51:23+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000361s ] [2025-07-05T15:51:23+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001292s ] [2025-07-05T15:51:23+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (9,8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000277s ] [2025-07-05T15:51:23+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001022s ] [2025-07-05T15:51:23+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (9,8,5,4,3,2,1) [ RunTime:0.000260s ] [2025-07-05T15:51:24+08:00][sql] CONNECT:[ UseTime:0.011078s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:51:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001348s ] [2025-07-05T15:51:24+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000282s ] [2025-07-05T15:51:24+08:00][sql] CONNECT:[ UseTime:0.011132s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:51:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001490s ] [2025-07-05T15:51:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000250s ] [2025-07-05T15:51:29+08:00][sql] CONNECT:[ UseTime:0.011778s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:51:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001365s ] [2025-07-05T15:51:29+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000275s ] [2025-07-05T15:51:29+08:00][sql] CONNECT:[ UseTime:0.010712s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T15:51:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001334s ] [2025-07-05T15:51:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000836s ] [2025-07-05T15:51:29+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000251s ] [2025-07-05T15:51:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001276s ] [2025-07-05T15:51:29+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000244s ] [2025-07-05T16:04:14+08:00][sql] CONNECT:[ UseTime:0.001575s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T16:04:14+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001448s ] [2025-07-05T16:04:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000885s ] [2025-07-05T16:04:14+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000248s ] [2025-07-05T17:59:02+08:00][sql] CONNECT:[ UseTime:0.001811s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:02+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001494s ] [2025-07-05T17:59:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.001005s ] [2025-07-05T17:59:02+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000304s ] [2025-07-05T17:59:06+08:00][sql] CONNECT:[ UseTime:0.001438s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001142s ] [2025-07-05T17:59:06+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000221s ] [2025-07-05T17:59:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000947s ] [2025-07-05T17:59:06+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000246s ] [2025-07-05T17:59:06+08:00][sql] CONNECT:[ UseTime:0.010388s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:06+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001142s ] [2025-07-05T17:59:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000914s ] [2025-07-05T17:59:06+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000472s ] [2025-07-05T17:59:07+08:00][sql] CONNECT:[ UseTime:0.011269s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001209s ] [2025-07-05T17:59:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_cate` LIMIT 1 [ RunTime:0.000493s ] [2025-07-05T17:59:07+08:00][sql] SELECT * FROM `trade_help_cate` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000239s ] [2025-07-05T17:59:09+08:00][sql] CONNECT:[ UseTime:0.010824s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001331s ] [2025-07-05T17:59:09+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000285s ] [2025-07-05T17:59:09+08:00][sql] CONNECT:[ UseTime:0.001375s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001357s ] [2025-07-05T17:59:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000928s ] [2025-07-05T17:59:09+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000343s ] [2025-07-05T17:59:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001233s ] [2025-07-05T17:59:09+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (7,6) AND `pay_status` IN (0,1) [ RunTime:0.000376s ] [2025-07-05T17:59:09+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001012s ] [2025-07-05T17:59:17+08:00][sql] CONNECT:[ UseTime:0.011139s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001387s ] [2025-07-05T17:59:17+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000280s ] [2025-07-05T17:59:17+08:00][sql] CONNECT:[ UseTime:0.010652s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001442s ] [2025-07-05T17:59:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000815s ] [2025-07-05T17:59:17+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000270s ] [2025-07-05T17:59:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001191s ] [2025-07-05T17:59:17+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE `tid` IN (9,8,5,4,3,2,1) AND `pay_status` IN (0,1) [ RunTime:0.000323s ] [2025-07-05T17:59:17+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000971s ] [2025-07-05T17:59:17+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE `id` IN (9,8,5,4,3,2,1) [ RunTime:0.000269s ] [2025-07-05T17:59:17+08:00][sql] CONNECT:[ UseTime:0.011449s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001333s ] [2025-07-05T17:59:17+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000282s ] [2025-07-05T17:59:17+08:00][sql] CONNECT:[ UseTime:0.011445s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:17+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001525s ] [2025-07-05T17:59:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000257s ] [2025-07-05T17:59:19+08:00][sql] CONNECT:[ UseTime:0.010869s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001235s ] [2025-07-05T17:59:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000273s ] [2025-07-05T17:59:19+08:00][sql] CONNECT:[ UseTime:0.010882s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001490s ] [2025-07-05T17:59:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000881s ] [2025-07-05T17:59:19+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000260s ] [2025-07-05T17:59:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001266s ] [2025-07-05T17:59:19+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000232s ] [2025-07-05T17:59:19+08:00][sql] CONNECT:[ UseTime:0.001488s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001362s ] [2025-07-05T17:59:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000288s ] [2025-07-05T17:59:19+08:00][sql] CONNECT:[ UseTime:0.010896s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001233s ] [2025-07-05T17:59:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE `ordertype` = -1 LIMIT 1 [ RunTime:0.000276s ] [2025-07-05T17:59:19+08:00][sql] SELECT * FROM `trade_stats` WHERE `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000235s ] [2025-07-05T17:59:19+08:00][sql] CONNECT:[ UseTime:0.001409s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001321s ] [2025-07-05T17:59:19+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000284s ] [2025-07-05T17:59:19+08:00][sql] CONNECT:[ UseTime:0.011175s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T17:59:19+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001289s ] [2025-07-05T17:59:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000905s ] [2025-07-05T17:59:19+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000275s ] [2025-07-05T18:01:38+08:00][sql] CONNECT:[ UseTime:0.010939s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T18:01:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001510s ] [2025-07-05T18:01:38+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000290s ] [2025-07-05T18:01:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001177s ] [2025-07-05T18:01:38+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000254s ] [2025-07-05T18:01:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001012s ] [2025-07-05T18:01:38+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000246s ] [2025-07-05T18:02:10+08:00][sql] CONNECT:[ UseTime:0.001408s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T18:02:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001372s ] [2025-07-05T18:02:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001133s ] [2025-07-05T18:02:10+08:00][sql] SELECT `id`,`game`,`serverid`,`tid`,`relationid`,`ordertype`,`op_type`,`username`,`orderno`,`payuser`,`aliname`,`status`,`alitime`,`transfer_order_id` FROM `trade_withdraw` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000261s ] [2025-07-05T18:02:10+08:00][sql] SELECT `id`,`pay_status`,`api_status`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000273s ] [2025-07-05T18:02:10+08:00][sql] UPDATE `trade_withdraw` SET `op_type` = 2 , `status` = 3 , `remark` = '姓名账号不符' , `certificate` = '' WHERE `id` = 1 [ RunTime:0.000340s ] [2025-07-05T18:02:10+08:00][sql] UPDATE `trade_order` SET `withdraw_status` = 3 WHERE `id` = 1 [ RunTime:0.000215s ] [2025-07-05T18:02:10+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.000915s ] [2025-07-05T18:02:10+08:00][sql] INSERT INTO `trade_notice` SET `game` = 'shaiya' , `serverid` = 1 , `tid` = 3 , `username` = 'ctshaiya014' , `orderno` = 'R2025070315403097811238' , `trade_type` = 1 , `type` = 4 , `content` = '您有一笔订单提现失败%s,请联系官方客服咨询处理%s' [ RunTime:0.000260s ] [2025-07-05T18:02:11+08:00][sql] CONNECT:[ UseTime:0.010711s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T18:02:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001449s ] [2025-07-05T18:02:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000850s ] [2025-07-05T18:02:11+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000252s ] [2025-07-05T18:02:11+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001197s ] [2025-07-05T18:02:11+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' [ RunTime:0.000268s ] [2025-07-05T18:02:43+08:00][sql] CONNECT:[ UseTime:0.010618s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8 [2025-07-05T18:02:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001464s ] [2025-07-05T18:02:43+08:00][sql] SELECT * FROM `trade_withdraw` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000362s ] [2025-07-05T18:02:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001128s ] [2025-07-05T18:02:43+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE `orderno` = 'R2025070315403097811238' LIMIT 1 [ RunTime:0.000232s ] [2025-07-05T18:02:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000911s ] [2025-07-05T18:02:43+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE `status` = 1 [ RunTime:0.000296s ]