CREATE TABLE IF NOT EXISTS `paramsSelectValuesInherit` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `valuesId` int(10) unsigned NOT NULL,
  `inherit` int(10) unsigned DEFAULT NULL,
  `inherit2` int(10) unsigned DEFAULT NULL,
  `interhit3` int(10) unsigned DEFAULT NULL,
  `interhit4` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`,`valuesId`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  KEY `fk_table1_paramsSelectValues3` (`valuesId`),
  KEY `fk_paramsSelectValuesInherit_newAutoline_paramsSe1` (`inherit`),
  KEY `fk_paramsSelectValuesInherit_newAutoline_paramsSe2` (`inherit2`),
  KEY `fk_paramsSelectValuesInherit_newAutoline_paramsSe3` (`interhit3`),
  KEY `fk_paramsSelectValuesInherit_newAutoline_paramsSe4` (`interhit4`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

SELECT
            `paramsSelectValues`.`id`, `paramsTranslateValue`.`text`
FROM `paramsSelectValues`
  JOIN `paramsTranslateValue` ON `paramsTranslateValue`.`valuesId` = `paramsSelectValues`.`id`
  JOIN `paramsSelectValuesInherit` ON `paramsSelectValues`.`id` = `paramsSelectValuesInherit`.`valuesId` 
WHERE
        (`paramsSelectValuesInherit`.`inherit` = 14252 
          OR `paramsSelectValuesInherit`.`inherit` = 14256 
          OR `paramsSelectValuesInherit`.`inherit` = 14258 
          OR `paramsSelectValuesInherit`.`inherit` = 14260 
          OR `paramsSelectValuesInherit`.`inherit` = 14261 
          OR `paramsSelectValuesInherit`.`inherit` = 14264 
          OR `paramsSelectValuesInherit`.`inherit` = 14265 
          OR `paramsSelectValuesInherit`.`inherit` = 14268)
         AND `paramsSelectValues`.`paramsId` = '26'
        AND `paramsTranslateValue`.`langId` = '1'
        AND `paramsSelectValuesInherit`.`inherit2` = '14225'
        AND `paramsSelectValuesInherit`.`interhit3` = '14238'
GROUP by `paramsSelectValues`.`id`
ORDER by CAST(`paramsTranslateValue`.`text` AS DECIMAL)

+----------------------+-----------+
| Status               | Duration  |
+----------------------+-----------+
| starting             |  0.000190 |
| checking permissions |  0.000012 |
| checking permissions |  0.000006 |
| checking permissions |  0.000011 |
| Opening tables       |  0.000043 |
| System lock          |  0.000019 |
| init                 |  0.000056 |
| optimizing           |  0.000038 |
| statistics           |  0.054937 |
| preparing            |  0.000124 |
| Creating tmp table   |  0.000703 |
| Sorting for group    |  0.000024 |
| executing            |  0.000010 |
| Copying to tmp table | 13.237371 |
| Sorting result       |  0.000079 |
| Sending data         |  0.000049 |
| end                  |  0.000008 |
| removing tmp table   |  0.000126 |
| end                  |  0.000011 |
| query end            |  0.000009 |
| closing tables       |  0.000049 |
| freeing items        |  0.000046 |
| logging slow query   |  0.000009 |
| logging slow query   |  0.000079 |
| cleaning up          |  0.000011 |
+----------------------+-----------+