Sandbox

SELECT 
  csscart_ec_bd_features.feature_id, 
  csscart_ec_bd_feature_descriptions.feature, 
  csscart_ec_bd_features.status, 
  csscart_ec_bd_features.timestamp, 
  csscart_ec_bd_features.feature_style, 
  csscart_ec_bd_features.filter_type, 
  csscart_ec_bd_features.categories_path, 
  csscart_ec_bd_features.display_on_vendor, 
  csscart_ec_bd_feature_values.value, 
  csscart_ec_bd_feature_values.variant_id, 
  csscart_ec_bd_feature_values.value_int 
FROM 
  csscart_ec_bd_features 
  LEFT JOIN csscart_ec_bd_feature_values ON csscart_ec_bd_feature_values.feature_id = csscart_ec_bd_features.feature_id 
  AND csscart_ec_bd_feature_values.company_id = 2 
  AND csscart_ec_bd_feature_values.lang_code = 'en' 
  LEFT JOIN csscart_ec_bd_feature_descriptions ON csscart_ec_bd_feature_descriptions.feature_id = csscart_ec_bd_features.feature_id 
  AND csscart_ec_bd_feature_descriptions.lang_code = 'en' 
WHERE 
  1 
  AND csscart_ec_bd_features.status = 'A' 
ORDER BY 
  csscart_ec_bd_features.position asc

Query time 0.00118

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}