slow crap

players_to_teams

+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| id              | int(11)      | NO   | PRI | NULL    | auto_increment |
| IsActive        | tinyint(1)   | YES  |     | NULL    |                |
| IsVisible       | tinyint(1)   | YES  |     | NULL    |                |
| player_id       | int(11)      | YES  |     | NULL    |                |
| team_id         | int(11)      | YES  |     | NULL    |                |
| CreationDate    | varchar(255) | YES  |     | NULL    |                |
| Position        | varchar(255) | YES  |     | NULL    |                |
| Number          | varchar(255) | YES  |     | NULL    |                |
| Club            | varchar(255) | YES  |     | NULL    |                |
| BT              | varchar(255) | YES  |     | NULL    |                |
| BioLink         | varchar(255) | YES  |     | NULL    |                |
| OtherBioLink    | varchar(255) | YES  |     | NULL    |                |
| StartYear       | varchar(255) | YES  |     | NULL    |                |
| EndYear         | varchar(255) | YES  |     | NULL    |                |
| NeulionPlayerID | varchar(255) | YES  |     | NULL    |                |
| SeasonYear      | varchar(255) | YES  |     | NULL    |                |
| GamesPlayed     | varchar(255) | YES  |     | NULL    |                |
| created_at      | datetime     | NO   |     | NULL    |                |
| updated_at      | datetime     | NO   |     | NULL    |                |
+-----------------+--------------+------+-----+---------+----------------+
19 rows in set (0.00 sec)

players_to_teams another way

| players_to_teams | CREATE TABLE `players_to_teams` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `IsActive` tinyint(1) DEFAULT NULL,
  `IsVisible` tinyint(1) DEFAULT NULL,
  `player_id` int(11) DEFAULT NULL,
  `team_id` int(11) DEFAULT NULL,
  `CreationDate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Position` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Club` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BT` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BioLink` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OtherBioLink` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `StartYear` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `EndYear` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NeulionPlayerID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SeasonYear` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `GamesPlayed` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=256003 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |