Optimizer creates very bad execution plan for tokudb on random

CREATE TABLE `stats_traffic_value` (

  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,

  `values` varchar(2048) NOT NULL,

  `_last_used` date NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `values` (`values`)

) ENGINE=TokuDB AUTO_INCREMENT=4249003 DEFAULT CHARSET=ascii;

CREATE TABLE `stats_traffic` (

  `date` date NOT NULL,

  `network_id` int(11) NOT NULL,

  `publisher_id` varchar(255) NOT NULL,

  `zone` varchar(255) NOT NULL,

  `language` char(2) NOT NULL,

  `country` char(2) NOT NULL,

  `stv_domain` int(11) NOT NULL,

  `stv_tag` int(11) NOT NULL,

  `stv_tag_secondary` int(11) NOT NULL,

  `stv_gender` int(11) NOT NULL,

  `stv_looking_for` int(11) NOT NULL,

  `device` varchar(20) NOT NULL,

  `_sandbox` varchar(255) NOT NULL,

  `impressions` int(11) NOT NULL DEFAULT '0',

  `unique` int(11) NOT NULL,

  `free_impressions` int(11) NOT NULL DEFAULT '0',

  `free_unique` int(11) NOT NULL,

  `clicks` int(11) NOT NULL,

  `clicks_total` int(11) NOT NULL,

  `conversions` int(11) NOT NULL,

  `conversion_value` decimal(10,3) NOT NULL,

  `spending` decimal(10,4) NOT NULL,

  `earnings` decimal(12,6) NOT NULL,

  `_key` binary(27) NOT NULL,

  UNIQUE KEY `_key` (`date`,`_key`) USING HASH

) ENGINE=TokuDB DEFAULT CHARSET=ascii

/*!50100 PARTITION BY HASH (TO_DAYS(date) DIV 20)

PARTITIONS 5 */;

SELECT    	

`tf`.`network_id` as network,

`tf`.`publisher_id`,

`tf`.`country`,

`tf`.`zone`,

`tv2`.`value` AS `tag_secondary`,	

`tv`.`value` AS `tag`,

`tf`.`device` as `device`,

`tf`.`_sandbox` as `sandbox`,

SUM(`impressions`) as impressions,          

SUM(`free_impressions`) as free_impressions

FROM `pstats`.`stats_traffic` `tf`

INNER JOIN `pstats`.`stats_traffic_value_lookup` `tv` ON `tv`.`stats_traffic_value_id` = `tf`.`stv_tag`

INNER JOIN `pstats`.`stats_traffic_value_lookup` `tv2` ON `tv2`.`stats_traffic_value_id` = `tf`.`stv_tag_secondary`

WHERE 1=1 AND date = '2017-07-21' AND `tf`.`_sandbox` = '' AND

`tv`.`value`='gay' AND country='us'	AND `tf`.network_id = 51

GROUP BY `publisher_id`, `zone`, `device`, `_sandbox`, 

stv_gender, `tv2`.`value`, `tv`.value, stv_looking_for