SELECT 
  DISTINCT `PF`.`filter_id`, 
  `PF`.`feature_id`, 
  `PD`.`range_input`, 
  `PFD`.`description` 
FROM 
  `cscart_product_filters` AS `PF` 
  LEFT JOIN `cscart_product_filter_descriptions` AS `PD` ON `PD`.`filter_id` = `PF`.`filter_id` 
  LEFT JOIN `cscart_product_features` AS `PFV` ON `PFV`.`feature_id` = `PF`.`feature_id` 
  LEFT JOIN `cscart_product_features_descriptions` AS `PFD` ON `PFD`.`feature_id` = `PF`.`feature_id` 
WHERE 
  FIND_IN_SET(559, `PF`.`categories_path`) 
  AND `PFV`.`status` = 'A'

Query time 0.00077

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "89.94"
    },
    "duplicates_removal": {
      "using_temporary_table": true,
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "PF",
            "access_type": "ALL",
            "possible_keys": [
              "feature_id"
            ],
            "rows_examined_per_scan": 88,
            "rows_produced_per_join": 88,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.25",
              "eval_cost": "8.80",
              "prefix_cost": "9.05",
              "data_read_per_join": "6K"
            },
            "used_columns": [
              "filter_id",
              "categories_path",
              "feature_id"
            ],
            "attached_condition": "(0 <> find_in_set(559,`dev2`.`PF`.`categories_path`))"
          }
        },
        {
          "table": {
            "table_name": "PFV",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "status"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "feature_id"
            ],
            "key_length": "3",
            "ref": [
              "dev2.PF.feature_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 70,
            "filtered": "80.46",
            "cost_info": {
              "read_cost": "22.00",
              "eval_cost": "7.08",
              "prefix_cost": "39.85",
              "data_read_per_join": "111K"
            },
            "used_columns": [
              "feature_id",
              "status"
            ],
            "attached_condition": "(`dev2`.`PFV`.`status` = 'A')"
          }
        },
        {
          "table": {
            "table_name": "PFD",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "feature_id"
            ],
            "key_length": "3",
            "ref": [
              "dev2.PF.feature_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 71,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "17.70",
              "eval_cost": "7.16",
              "prefix_cost": "64.71",
              "data_read_per_join": "196K"
            },
            "used_columns": [
              "feature_id",
              "description",
              "lang_code"
            ]
          }
        },
        {
          "table": {
            "table_name": "PD",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "filter_id"
            ],
            "key_length": "3",
            "ref": [
              "dev2.PF.filter_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 73,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "17.90",
              "eval_cost": "7.32",
              "prefix_cost": "89.94",
              "data_read_per_join": "77K"
            },
            "used_columns": [
              "filter_id",
              "lang_code",
              "range_input"
            ]
          }
        }
      ]
    }
  }
}