Looking through the tables I found a lot of duplicate indexes that I did not create...
Code:
CREATE TABLE IF NOT EXISTS `xxxhashtag_search` (
`id_search` int(11) NOT NULL AUTO_INCREMENT,
`query` varchar(255) NOT NULL,
`views` int(11) NOT NULL DEFAULT '1',
`insitemap` int(1) NOT NULL DEFAULT '0',
`insitemap_link` int(1) NOT NULL DEFAULT '0',
`insitemap_link2` int(1) NOT NULL DEFAULT '0',
`data_ins` varchar(255) NOT NULL DEFAULT '1388796621',
`last_mod` varchar(255) DEFAULT '1415144202',
`engine` varchar(255) NOT NULL,
PRIMARY KEY (`id_search`),
KEY `query` (`query`),
KEY `query_2` (`query`),
KEY `query_3` (`query`),
KEY `query_4` (`query`),
FULLTEXT KEY `query_5` (`query`),
FULLTEXT KEY `query_6` (`query`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=925373 ;
By removing the indexes in addition the script from 8000 seconds now takes 0.2 seconds...
Now I check all the other tables looking for duplicate indexes...
(I will take about 3 days, as I am happy...

)