[2025-07-04T08:56:15+08:00][sql] CONNECT:[ UseTime:0.011542s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T08:56:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001382s ]
[2025-07-04T08:56:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000912s ]
[2025-07-04T08:56:15+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000271s ]
[2025-07-04T08:56:32+08:00][sql] CONNECT:[ UseTime:0.001502s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T08:56:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001350s ]
[2025-07-04T08:56:32+08:00][sql] UPDATE `trade_game`  SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/static/index/images/index_cp_5.png' , `is_mtain` = 1 , `status` = 0  WHERE  `id` = 3 [ RunTime:0.002420s ]
[2025-07-04T08:56:34+08:00][sql] CONNECT:[ UseTime:0.001554s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T08:56:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001409s ]
[2025-07-04T08:56:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000914s ]
[2025-07-04T08:56:34+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000272s ]
[2025-07-04T08:56:38+08:00][sql] CONNECT:[ UseTime:0.001441s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T08:56:38+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001370s ]
[2025-07-04T08:56:38+08:00][sql] UPDATE `trade_game`  SET `name` = '神泣' , `game` = 'shaiya' , `serverid` = 5 , `servername` = '血色星座' , `image` = '/static/index/images/index_cp_5.png' , `status` = 0 , `is_mtain` = 0  WHERE  `id` = 3 [ RunTime:0.002529s ]
[2025-07-04T08:56:40+08:00][sql] CONNECT:[ UseTime:0.010925s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T08:56:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001320s ]
[2025-07-04T08:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000918s ]
[2025-07-04T08:56:40+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000244s ]
[2025-07-04T09:06:42+08:00][sql] CONNECT:[ UseTime:0.001645s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:06:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001419s ]
[2025-07-04T09:06:42+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000525s ]
[2025-07-04T09:06:42+08:00][sql] CONNECT:[ UseTime:0.011017s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:06:42+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001409s ]
[2025-07-04T09:06:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000889s ]
[2025-07-04T09:06:42+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000513s ]
[2025-07-04T09:07:53+08:00][sql] CONNECT:[ UseTime:0.001442s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:07:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001123s ]
[2025-07-04T09:07:53+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000504s ]
[2025-07-04T09:07:53+08:00][sql] CONNECT:[ UseTime:0.011286s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:07:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001181s ]
[2025-07-04T09:07:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000924s ]
[2025-07-04T09:07:53+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000432s ]
[2025-07-04T09:12:24+08:00][sql] CONNECT:[ UseTime:0.011774s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:12:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001206s ]
[2025-07-04T09:12:24+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000227s ]
[2025-07-04T09:12:24+08:00][sql] CONNECT:[ UseTime:0.001395s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:12:24+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001204s ]
[2025-07-04T09:12:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.000872s ]
[2025-07-04T09:12:24+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000453s ]
[2025-07-04T09:12:27+08:00][sql] CONNECT:[ UseTime:0.011518s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:12:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001302s ]
[2025-07-04T09:12:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_cate` LIMIT 1 [ RunTime:0.000442s ]
[2025-07-04T09:12:27+08:00][sql] SELECT * FROM `trade_help_cate` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000217s ]
[2025-07-04T09:12:32+08:00][sql] CONNECT:[ UseTime:0.001476s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:12:32+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001359s ]
[2025-07-04T09:12:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000869s ]
[2025-07-04T09:12:32+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000278s ]
[2025-07-04T09:12:55+08:00][sql] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:12:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001360s ]
[2025-07-04T09:12:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000807s ]
[2025-07-04T09:12:55+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000243s ]
[2025-07-04T09:12:55+08:00][sql] CONNECT:[ UseTime:0.010916s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:12:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001389s ]
[2025-07-04T09:12:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000809s ]
[2025-07-04T09:12:55+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000259s ]
[2025-07-04T09:12:59+08:00][sql] CONNECT:[ UseTime:0.011423s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:12:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001302s ]
[2025-07-04T09:12:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000956s ]
[2025-07-04T09:12:59+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000244s ]
[2025-07-04T09:13:00+08:00][sql] CONNECT:[ UseTime:0.001506s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:13:00+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001396s ]
[2025-07-04T09:13:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000855s ]
[2025-07-04T09:13:00+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000286s ]
[2025-07-04T09:13:01+08:00][sql] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:13:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001351s ]
[2025-07-04T09:13:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000903s ]
[2025-07-04T09:13:01+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000293s ]
[2025-07-04T09:13:01+08:00][sql] CONNECT:[ UseTime:0.010988s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:13:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001426s ]
[2025-07-04T09:13:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000792s ]
[2025-07-04T09:13:01+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000258s ]
[2025-07-04T09:13:01+08:00][sql] CONNECT:[ UseTime:0.010858s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:13:01+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001374s ]
[2025-07-04T09:13:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000825s ]
[2025-07-04T09:13:01+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000242s ]
[2025-07-04T09:14:40+08:00][sql] CONNECT:[ UseTime:0.011357s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:14:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001335s ]
[2025-07-04T09:14:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000279s ]
[2025-07-04T09:14:40+08:00][sql] CONNECT:[ UseTime:0.011514s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:14:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001328s ]
[2025-07-04T09:14:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000957s ]
[2025-07-04T09:14:40+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000238s ]
[2025-07-04T09:14:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001129s ]
[2025-07-04T09:14:40+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE  `orderno` = 'R2025070315403097811238' [ RunTime:0.000223s ]
[2025-07-04T09:28:28+08:00][sql] CONNECT:[ UseTime:0.001512s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:28:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001289s ]
[2025-07-04T09:28:28+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000307s ]
[2025-07-04T09:28:28+08:00][sql] CONNECT:[ UseTime:0.001515s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:28:28+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001527s ]
[2025-07-04T09:28:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000231s ]
[2025-07-04T09:28:29+08:00][sql] CONNECT:[ UseTime:0.010944s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:28:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001373s ]
[2025-07-04T09:28:29+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000287s ]
[2025-07-04T09:28:29+08:00][sql] CONNECT:[ UseTime:0.011258s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:28:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001524s ]
[2025-07-04T09:28:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000859s ]
[2025-07-04T09:28:29+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000287s ]
[2025-07-04T09:28:29+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001256s ]
[2025-07-04T09:28:29+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (4,3,2,1)  AND `pay_status` IN (0,1) [ RunTime:0.000305s ]
[2025-07-04T09:28:29+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000933s ]
[2025-07-04T09:28:29+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (4,3,2,1) [ RunTime:0.000293s ]
[2025-07-04T09:28:31+08:00][sql] CONNECT:[ UseTime:0.011237s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:28:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001318s ]
[2025-07-04T09:28:31+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000291s ]
[2025-07-04T09:28:31+08:00][sql] CONNECT:[ UseTime:0.011469s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:28:31+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001357s ]
[2025-07-04T09:28:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE  `ordertype` = -1 LIMIT 1 [ RunTime:0.000273s ]
[2025-07-04T09:28:31+08:00][sql] SELECT * FROM `trade_stats` WHERE  `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000238s ]
[2025-07-04T09:28:34+08:00][sql] CONNECT:[ UseTime:0.001533s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:28:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001525s ]
[2025-07-04T09:28:34+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000282s ]
[2025-07-04T09:28:34+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001060s ]
[2025-07-04T09:28:34+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000245s ]
[2025-07-04T09:31:56+08:00][sql] CONNECT:[ UseTime:0.010918s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T09:31:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001467s ]
[2025-07-04T09:31:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000881s ]
[2025-07-04T09:31:56+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000314s ]
[2025-07-04T09:31:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001107s ]
[2025-07-04T09:31:56+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (4,3,2,1)  AND `pay_status` IN (0,1) [ RunTime:0.000308s ]
[2025-07-04T09:31:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000954s ]
[2025-07-04T09:31:56+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (4,3,2,1) [ RunTime:0.000264s ]
[2025-07-04T10:21:09+08:00][sql] CONNECT:[ UseTime:0.011508s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T10:21:09+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001543s ]
[2025-07-04T10:21:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000877s ]
[2025-07-04T10:21:09+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000308s ]
[2025-07-04T10:21:44+08:00][sql] CONNECT:[ UseTime:0.001481s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T10:21:44+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001324s ]
[2025-07-04T10:21:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000890s ]
[2025-07-04T10:21:44+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000282s ]
[2025-07-04T11:25:40+08:00][sql] CONNECT:[ UseTime:0.011080s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:25:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001307s ]
[2025-07-04T11:25:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000329s ]
[2025-07-04T11:25:40+08:00][sql] CONNECT:[ UseTime:0.010755s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:25:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001469s ]
[2025-07-04T11:25:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000853s ]
[2025-07-04T11:25:40+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000300s ]
[2025-07-04T11:25:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001185s ]
[2025-07-04T11:25:40+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.000338s ]
[2025-07-04T11:25:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000967s ]
[2025-07-04T11:25:40+08:00][sql] CONNECT:[ UseTime:0.011155s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:25:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001326s ]
[2025-07-04T11:25:40+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000276s ]
[2025-07-04T11:25:40+08:00][sql] CONNECT:[ UseTime:0.011436s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:25:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001544s ]
[2025-07-04T11:25:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000871s ]
[2025-07-04T11:25:40+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000299s ]
[2025-07-04T11:25:40+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001160s ]
[2025-07-04T11:25:40+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.000294s ]
[2025-07-04T11:25:40+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000956s ]
[2025-07-04T11:25:40+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (5,4,3,2,1) [ RunTime:0.000309s ]
[2025-07-04T11:25:52+08:00][sql] CONNECT:[ UseTime:0.001463s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.001306s ]
[2025-07-04T11:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001256s ]
[2025-07-04T11:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001078s ]
[2025-07-04T11:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001078s ]
[2025-07-04T11:25:52+08:00][sql] SELECT * FROM `trade_role` WHERE  `id` = 5 LIMIT 1 [ RunTime:0.000316s ]
[2025-07-04T11:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_war` [ RunTime:0.001067s ]
[2025-07-04T11:25:52+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` = 5 [ RunTime:0.000358s ]
[2025-07-04T11:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_equip` [ RunTime:0.001171s ]
[2025-07-04T11:25:52+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` = 5 [ RunTime:0.000427s ]
[2025-07-04T11:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001163s ]
[2025-07-04T11:25:52+08:00][sql] SELECT `itemname`,`itemid` FROM `trade_items` WHERE  `game` = 'shaiya'  AND `serverid` = 1  AND `itemid` IN (30059,30024,30200,30250,30017,30025,30031,30045,30011,98001,30060,30046) [ RunTime:0.028698s ]
[2025-07-04T11:25:52+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE  `game` = 'shaiya'  AND `serverid` = 1  AND `itemid` IN (16196,17211,18211,20212,21211,12110,23014,22025,40247,40205,120078,16168,17174,18067,20067,21068,12009,17189,18073,20073,21189,12019,23006,22007,40006) [ RunTime:0.039933s ]
[2025-07-04T11:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_backpack` [ RunTime:0.001092s ]
[2025-07-04T11:25:52+08:00][sql] SELECT `type`,`itemid`,`num` FROM `trade_backpack` WHERE  `game` = 'shaiya'  AND `serverid` = 1  AND `tid` = 5 [ RunTime:0.000498s ]
[2025-07-04T11:25:52+08:00][sql] SELECT `game`,`itemname`,`text`,`itemid`,`icon`,`level`,`dex`,`og`,`attacktime`,`effect1`,`effect2`,`effect3`,`effect4`,`consthp`,`constsp`,`constmp`,`conststr`,`constdex`,`constrec`,`constint`,`constwis`,`constluc`,`iconset`,`extduration` FROM `trade_items` WHERE  `game` = 'shaiya'  AND `serverid` = 1  AND `itemid` IN (100176,101190,102107,102072,102071,101165,98001,94002,94008,41124,12107,12108,12109,100193,30031,30045,30025,30092,95006,95012,101208,95001,161003,161002,101203,95011,41122,100171,25177,161001,119119,119097,128135,128136,42006,102079,101104,101105,101106,101217,101218,101219,100131,100167,100221,100254,100253,118004,127069,127072,127189,101191,101197,101234,101233,127058,127057,127059,127060,127188,120052,120255,42052,101138,119254,120077) [ RunTime:0.040079s ]
[2025-07-04T11:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_god` [ RunTime:0.001246s ]
[2025-07-04T11:25:52+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` = 5 [ RunTime:0.000332s ]
[2025-07-04T11:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_wing` [ RunTime:0.000996s ]
[2025-07-04T11:25:52+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` = 5 [ RunTime:0.000325s ]
[2025-07-04T11:25:52+08:00][sql] SELECT `itemname`,`icon`,`iconset`,`itemid` FROM `trade_items` WHERE  `game` = 'shaiya'  AND `serverid` = 1  AND `itemid` IN (121033,121028,121017) [ RunTime:0.029377s ]
[2025-07-04T11:25:52+08:00][sql] SELECT `sync_status` FROM `trade` WHERE  `id` = 5 LIMIT 1 [ RunTime:0.000244s ]
[2025-07-04T11:25:52+08:00][sql] SELECT * FROM `trade_order` WHERE  `tid` = 5  AND `ordertype` = 1  AND `pay_status` IN (0,1) LIMIT 1 [ RunTime:0.000296s ]
[2025-07-04T11:25:52+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `tid` = 5 LIMIT 1 [ RunTime:0.000359s ]
[2025-07-04T11:25:52+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.000983s ]
[2025-07-04T11:25:52+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000268s ]
[2025-07-04T11:26:41+08:00][sql] CONNECT:[ UseTime:0.011175s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:26:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001263s ]
[2025-07-04T11:26:41+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000303s ]
[2025-07-04T11:26:41+08:00][sql] CONNECT:[ UseTime:0.011021s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:26:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001422s ]
[2025-07-04T11:26:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000231s ]
[2025-07-04T11:36:13+08:00][sql] CONNECT:[ UseTime:0.001536s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:36:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001422s ]
[2025-07-04T11:36:13+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000294s ]
[2025-07-04T11:36:13+08:00][sql] CONNECT:[ UseTime:0.011171s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:36:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001391s ]
[2025-07-04T11:36:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000846s ]
[2025-07-04T11:36:13+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000261s ]
[2025-07-04T11:36:13+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001180s ]
[2025-07-04T11:36:13+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE  `orderno` = 'R2025070315403097811238' [ RunTime:0.000260s ]
[2025-07-04T11:36:15+08:00][sql] CONNECT:[ UseTime:0.011526s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:36:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001396s ]
[2025-07-04T11:36:15+08:00][sql] SELECT * FROM `trade_withdraw` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000276s ]
[2025-07-04T11:36:15+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001002s ]
[2025-07-04T11:36:15+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000238s ]
[2025-07-04T11:36:45+08:00][sql] CONNECT:[ UseTime:0.011323s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:36:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001324s ]
[2025-07-04T11:36:45+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000313s ]
[2025-07-04T11:36:45+08:00][sql] CONNECT:[ UseTime:0.011539s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T11:36:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001304s ]
[2025-07-04T11:36:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` LIMIT 1 [ RunTime:0.000861s ]
[2025-07-04T11:36:45+08:00][sql] SELECT * FROM `trade_withdraw` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000273s ]
[2025-07-04T11:36:45+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001261s ]
[2025-07-04T11:36:45+08:00][sql] SELECT `orderno`,`charge`,`price`,`amount` FROM `trade_order` WHERE  `orderno` = 'R2025070315403097811238' [ RunTime:0.000236s ]
[2025-07-04T17:48:27+08:00][sql] CONNECT:[ UseTime:0.011275s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T17:48:27+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001297s ]
[2025-07-04T17:48:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000798s ]
[2025-07-04T17:48:27+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000313s ]
[2025-07-04T17:48:35+08:00][sql] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T17:48:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_cate` [ RunTime:0.001176s ]
[2025-07-04T17:48:35+08:00][sql] SELECT `id`,`name` FROM `trade_help_cate` [ RunTime:0.000239s ]
[2025-07-04T17:48:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001020s ]
[2025-07-04T17:48:35+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000257s ]
[2025-07-04T17:48:35+08:00][sql] CONNECT:[ UseTime:0.001444s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T17:48:35+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001208s ]
[2025-07-04T17:48:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.001014s ]
[2025-07-04T17:48:35+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000472s ]
[2025-07-04T17:48:39+08:00][sql] CONNECT:[ UseTime:0.001606s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T17:48:39+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001488s ]
[2025-07-04T17:48:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.001081s ]
[2025-07-04T17:48:39+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000504s ]
[2025-07-04T17:48:43+08:00][sql] CONNECT:[ UseTime:0.011426s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T17:48:43+08:00][sql] SHOW FULL COLUMNS FROM `trade_help_article` [ RunTime:0.001329s ]
[2025-07-04T17:48:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_help_article` LIMIT 1 [ RunTime:0.001033s ]
[2025-07-04T17:48:43+08:00][sql] SELECT * FROM `trade_help_article` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000438s ]
[2025-07-04T17:48:51+08:00][sql] CONNECT:[ UseTime:0.010934s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T17:48:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001264s ]
[2025-07-04T17:48:51+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000270s ]
[2025-07-04T17:48:51+08:00][sql] CONNECT:[ UseTime:0.011142s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T17:48:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001534s ]
[2025-07-04T17:48:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000924s ]
[2025-07-04T17:48:51+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000275s ]
[2025-07-04T17:48:51+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001167s ]
[2025-07-04T17:48:51+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.000332s ]
[2025-07-04T17:48:51+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000970s ]
[2025-07-04T17:48:53+08:00][sql] CONNECT:[ UseTime:0.011248s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T17:48:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001475s ]
[2025-07-04T17:48:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000845s ]
[2025-07-04T17:48:53+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000271s ]
[2025-07-04T17:48:53+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001285s ]
[2025-07-04T17:48:53+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.000279s ]
[2025-07-04T17:48:53+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000953s ]
[2025-07-04T17:48:55+08:00][sql] CONNECT:[ UseTime:0.011606s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T17:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001431s ]
[2025-07-04T17:48:55+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000318s ]
[2025-07-04T17:48:55+08:00][sql] CONNECT:[ UseTime:0.011516s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-04T17:48:55+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001655s ]
[2025-07-04T17:48:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.005942s ]
[2025-07-04T17:48:55+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.027184s ]