SELECT 
  `P`.`product_id`, 
  `PFD`.`internal_name` AS `name`, 
  `PFVD`.`variant`, 
  `PFVD`.`variant_id`, 
  `PFD`.`feature_id` 
FROM 
  `cscart_product_features_values` AS `PFV` 
  JOIN `cscart_product_features` AS `PF` ON `PFV`.`feature_id` = `PF`.`feature_id` 
  JOIN `cscart_products` AS `P` ON `P`.`product_id` = `PFV`.`product_id` 
  JOIN `cscart_product_features_descriptions` AS `PFD` ON `PFV`.`feature_id` = `PFD`.`feature_id` 
  JOIN `cscart_product_feature_variants` AS `PFVS` ON `PFVS`.`variant_id` = `PFV`.`variant_id` 
  JOIN `cscart_product_feature_variant_descriptions` AS `PFVD` ON `PFVS`.`variant_id` = `PFVD`.`variant_id` 
WHERE 
  1 
  AND `PF`.`status` = 'A' 
  AND `PFV`.`product_id` IN(
    '32465', '28881', '14714', '28163', 
    '9184', '14253', '21422', '20475', 
    '22120', '18006', '26397'
  )

Query time 0.00856

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "63.52"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "PFV",
          "access_type": "range",
          "possible_keys": [
            "PRIMARY",
            "fl",
            "variant_id",
            "product_id",
            "fpl",
            "idx_product_feature_variant_id"
          ],
          "key": "product_id",
          "used_key_parts": [
            "product_id"
          ],
          "key_length": "3",
          "rows_examined_per_scan": 36,
          "rows_produced_per_join": 36,
          "filtered": "100.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "4.16",
            "eval_cost": "3.60",
            "prefix_cost": "7.76",
            "data_read_per_join": "27K"
          },
          "used_columns": [
            "feature_id",
            "product_id",
            "variant_id"
          ],
          "attached_condition": "(`dev2`.`PFV`.`product_id` in ('32465','28881','14714','28163','9184','14253','21422','20475','22120','18006','26397'))"
        }
      },
      {
        "table": {
          "table_name": "P",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY",
            "cscart_products_product_id_index"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "product_id"
          ],
          "key_length": "3",
          "ref": [
            "dev2.PFV.product_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 36,
          "filtered": "100.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "9.00",
            "eval_cost": "3.60",
            "prefix_cost": "20.36",
            "data_read_per_join": "271K"
          },
          "used_columns": [
            "product_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "PF",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY",
            "status"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "feature_id"
          ],
          "key_length": "3",
          "ref": [
            "dev2.PFV.feature_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 28,
          "filtered": "80.46",
          "cost_info": {
            "read_cost": "9.00",
            "eval_cost": "2.90",
            "prefix_cost": "32.96",
            "data_read_per_join": "45K"
          },
          "used_columns": [
            "feature_id",
            "status"
          ],
          "attached_condition": "(`dev2`.`PF`.`status` = 'A')"
        }
      },
      {
        "table": {
          "table_name": "PFVS",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "variant_id"
          ],
          "key_length": "3",
          "ref": [
            "dev2.PFV.variant_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 28,
          "filtered": "100.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "7.24",
            "eval_cost": "2.90",
            "prefix_cost": "43.10",
            "data_read_per_join": "43K"
          },
          "used_columns": [
            "variant_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "PFD",
          "access_type": "ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "feature_id"
          ],
          "key_length": "3",
          "ref": [
            "dev2.PFV.feature_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 29,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "7.24",
            "eval_cost": "2.93",
            "prefix_cost": "53.27",
            "data_read_per_join": "80K"
          },
          "used_columns": [
            "feature_id",
            "internal_name"
          ]
        }
      },
      {
        "table": {
          "table_name": "PFVD",
          "access_type": "ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "variant_id"
          ],
          "key_length": "3",
          "ref": [
            "dev2.PFV.variant_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 29,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "7.32",
            "eval_cost": "2.93",
            "prefix_cost": "63.53",
            "data_read_per_join": "124K"
          },
          "used_columns": [
            "variant_id",
            "variant"
          ]
        }
      }
    ]
  }
}

Result

product_id name variant variant_id feature_id
9184 Мощность двигателя, л.с. 285 12072 737
9184 Колесная формула 6x6 8735 744
9184 Шины 425/85 R21 9218 745
9184 Объем топливного бака, л. 210 12073 746
9184 Количество мест в автобусе 28+2 11719 750
14253 Мощность двигателя, л.с. 273 8764 737
14253 Шины 425/85 R21 9218 745
14253 Объем топливного бака, л. 300 9494 746
14253 Максимальная скорость, км/ч 85 9137 748
14253 Количество мест в автобусе 22 13583 750
14714 Мощность двигателя, л.с. 273 8764 737
14714 Колесная формула 6х6 13865 744
14714 Объем топливного бака, л. 300 9494 746
14714 Количество мест в автобусе 28+2 11719 750
28163 Мощность двигателя, л.с. 300 8737 737
28163 Колесная формула 6x6 8735 744
28163 Шины 10 R22.5 9276 745
28163 Объем топливного бака, л. 210 12073 746
28163 Максимальная скорость, км/ч 160 13871 748
28163 Количество мест в автобусе 28+2 11719 750
28881 Мощность двигателя, л.с. 106.8 14394 737
28881 Колесная формула 4x4 8961 744
28881 Шины 195/75R16C 14369 745
28881 Объем топливного бака, л. 80 9038 746
28881 Максимальная скорость, км/ч 130 14336 748
28881 Количество мест в автобусе 8+1 14396 750
32465 Мощность двигателя, л.с. 273 8764 737
32465 Колесная формула 6x6 8735 744
32465 Объем топливного бака, л. 300 9494 746
32465 Максимальная скорость, км/ч 80 9105 748
32465 Количество мест в автобусе 28+2 11719 750