[2025-07-29T09:42:41+08:00][sql] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T09:42:41+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001406s ]
[2025-07-29T09:42:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_game` LIMIT 1 [ RunTime:0.000902s ]
[2025-07-29T09:42:41+08:00][sql] SELECT * FROM `trade_game` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000255s ]
[2025-07-29T15:49:54+08:00][sql] CONNECT:[ UseTime:0.001570s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:49:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001310s ]
[2025-07-29T15:49:54+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000299s ]
[2025-07-29T15:49:54+08:00][sql] CONNECT:[ UseTime:0.007063s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:49:54+08:00][sql] SHOW FULL COLUMNS FROM `trade_items` [ RunTime:0.001399s ]
[2025-07-29T15:49:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_items` LIMIT 1 [ RunTime:0.006158s ]
[2025-07-29T15:49:54+08:00][sql] SELECT * FROM `trade_items` ORDER BY `itemid` DESC LIMIT 0,10 [ RunTime:0.030674s ]
[2025-07-29T15:49:56+08:00][sql] CONNECT:[ UseTime:0.005756s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:49:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001353s ]
[2025-07-29T15:49:56+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000288s ]
[2025-07-29T15:49:56+08:00][sql] CONNECT:[ UseTime:0.007197s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:49:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_gold` [ RunTime:0.001299s ]
[2025-07-29T15:49:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_gold` LIMIT 1 [ RunTime:0.000806s ]
[2025-07-29T15:49:56+08:00][sql] SELECT * FROM `trade_gold` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000260s ]
[2025-07-29T15:49:56+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001181s ]
[2025-07-29T15:49:56+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-29T15:49:56+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000971s ]
[2025-07-29T15:49:59+08:00][sql] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:49:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001339s ]
[2025-07-29T15:49:59+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000299s ]
[2025-07-29T15:49:59+08:00][sql] CONNECT:[ UseTime:0.002993s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:49:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_role` [ RunTime:0.001422s ]
[2025-07-29T15:49:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_role` LIMIT 1 [ RunTime:0.000860s ]
[2025-07-29T15:49:59+08:00][sql] SELECT * FROM `trade_role` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000336s ]
[2025-07-29T15:49:59+08:00][sql] SHOW FULL COLUMNS FROM `trade_order` [ RunTime:0.001175s ]
[2025-07-29T15:49:59+08:00][sql] SELECT `tid`,`price`,`amount`,`charge`,`tousername` FROM `trade_order` WHERE  `tid` IN (17,16,15,14,13,12,11,10,9,8)  AND `pay_status` IN (0,1) [ RunTime:0.000329s ]
[2025-07-29T15:49:59+08:00][sql] SHOW FULL COLUMNS FROM `trade` [ RunTime:0.000936s ]
[2025-07-29T15:49:59+08:00][sql] SELECT `sync_status`,`id` FROM `trade` WHERE  `id` IN (17,16,15,14,13,12,11,10,9,8) [ RunTime:0.000275s ]
[2025-07-29T15:50:03+08:00][sql] CONNECT:[ UseTime:0.003549s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:50:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001300s ]
[2025-07-29T15:50:03+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000299s ]
[2025-07-29T15:50:03+08:00][sql] CONNECT:[ UseTime:0.007728s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:50:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_prop` [ RunTime:0.001472s ]
[2025-07-29T15:50:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_prop` LIMIT 1 [ RunTime:0.000252s ]
[2025-07-29T15:50:03+08:00][sql] CONNECT:[ UseTime:0.003018s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:50:03+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001285s ]
[2025-07-29T15:50:03+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000294s ]
[2025-07-29T15:50:04+08:00][sql] CONNECT:[ UseTime:0.004093s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:50:04+08:00][sql] SHOW FULL COLUMNS FROM `trade_withdraw` [ RunTime:0.001358s ]
[2025-07-29T15:50:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` LIMIT 1 [ RunTime:0.000294s ]
[2025-07-29T15:50:04+08:00][sql] SELECT `to`.`orderno`,`to`.`charge`,`to`.`price`,`to`.`amount`,`tw`.`id`,`tw`.`game`,`tw`.`serverid`,`tw`.`alitime`,`tw`.`withdrawtime`,`tw`.`username`,`tw`.`payuser`,`tw`.`aliname`,`tw`.`status`,`tw`.`ordertype`,`tw`.`relationid`,`tw`.`tid` FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` ORDER BY `tw`.`id` DESC LIMIT 0,10 [ RunTime:0.000254s ]
[2025-07-29T15:50:04+08:00][sql] SELECT IFNULL(SUM(to.price), 0) AS total_price,IFNULL(SUM(to.amount), 0) AS total_amount,IFNULL(SUM(to.charge), 0) AS total_charge FROM `trade_withdraw` `tw` INNER JOIN `trade_order` `to` ON `to`.`orderno`=`tw`.`orderno` [ RunTime:0.000248s ]
[2025-07-29T15:50:05+08:00][sql] CONNECT:[ UseTime:0.002568s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:50:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001306s ]
[2025-07-29T15:50:05+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000277s ]
[2025-07-29T15:50:05+08:00][sql] CONNECT:[ UseTime:0.008872s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:50:05+08:00][sql] SHOW FULL COLUMNS FROM `trade_stats` [ RunTime:0.001259s ]
[2025-07-29T15:50:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_stats` WHERE  `ordertype` = -1 LIMIT 1 [ RunTime:0.000280s ]
[2025-07-29T15:50:05+08:00][sql] SELECT * FROM `trade_stats` WHERE  `ordertype` = -1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000242s ]
[2025-07-29T15:50:07+08:00][sql] CONNECT:[ UseTime:0.014913s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:50:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_game` [ RunTime:0.001307s ]
[2025-07-29T15:50:07+08:00][sql] SELECT `id`,`name`,`game`,`serverid`,`servername` FROM `trade_game` WHERE  `status` = 1 [ RunTime:0.000276s ]
[2025-07-29T15:50:07+08:00][sql] CONNECT:[ UseTime:0.010394s ] mysql:host=127.0.0.1;port=3306;dbname=zbg;charset=utf8
[2025-07-29T15:50:07+08:00][sql] SHOW FULL COLUMNS FROM `trade_notice` [ RunTime:0.001307s ]
[2025-07-29T15:50:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `trade_notice` LIMIT 1 [ RunTime:0.000865s ]
[2025-07-29T15:50:07+08:00][sql] SELECT * FROM `trade_notice` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000286s ]