有什么办法可以加快速度吗？现在要花很长时间去查询。

SELECT trades.*, trader1.user_name as trader1_name,
trader2.user_name as trader2_name FROM trades
LEFT JOIN logs_players trader1 ON trader1.user_id = trader1_account_id
LEFT JOIN logs_players trader2 ON trader2.user_id = trader2_account_id
ORDER BY time_added
LIMIT 20 OFFSET 0;

我已经尽我所能在网上搜索解决方案。或者只是想得到更多的信息为什么要花这么长时间来执行。

完成查询大约需要45秒。
创建语句：

CREATE TABLE `trades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trader1_account_id` int(11) DEFAULT NULL,
  `trader2_account_id` int(11) DEFAULT NULL,
  `trader1_value` bigint(20) DEFAULT NULL,
  `trader2_value` bigint(20) DEFAULT NULL,
  `trader1_ip` varchar(16) DEFAULT NULL,
  `trader2_ip` varchar(16) DEFAULT NULL,
  `world` int(11) DEFAULT NULL,
  `x` int(11) DEFAULT NULL,
  `z` int(11) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `trader1_user` varchar(12) DEFAULT NULL,
  `trader2_user` varchar(12) DEFAULT NULL,
  `time_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8

CREATE TABLE `logs_players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(20) DEFAULT NULL,
  `world_stage` varchar(20) DEFAULT NULL,
  `world_type` varchar(20) DEFAULT NULL,
  `bank` longtext,
  `inventory` longtext,
  `equipment` longtext,
  `total_wealth` mediumtext,
  `total_play_time` mediumtext,
  `rights` int(11) DEFAULT NULL,
  `icon` int(11) DEFAULT NULL,
  `ironmode` int(11) DEFAULT NULL,
  `x` int(11) DEFAULT NULL,
  `z` int(11) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `last_ip` varchar(16) DEFAULT NULL,
  `last_online` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `muted_until` timestamp NULL DEFAULT NULL,
  `banned_until` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8