SELECT 
  cscart_product_feature_variant_descriptions.*, 
  cscart_product_feature_variants.*, 
  cscart_product_features_values.variant_id as selected, 
  cscart_product_features.feature_type, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_product_feature_variants 
  LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variant_descriptions.variant_id = cscart_product_feature_variants.variant_id 
  AND cscart_product_feature_variant_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_product_features_values ON cscart_product_features_values.variant_id = cscart_product_feature_variants.variant_id 
  AND cscart_product_features_values.lang_code = 'en' 
  AND cscart_product_features_values.product_id = 3325 
  LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_feature_variants.feature_id 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_product_feature_variants.variant_id 
  AND cscart_seo_names.type = 'e' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  AND (
    cscart_seo_names.company_id = 2 
    OR cscart_seo_names.company_id = 0
  ) 
WHERE 
  1 
  AND cscart_product_feature_variants.feature_id IN (135) 
GROUP BY 
  cscart_product_feature_variants.variant_id 
ORDER BY 
  cscart_product_feature_variants.position, 
  cscart_product_feature_variant_descriptions.variant

Query time 0.00270

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_feature_variants ref feature_id feature_id 3 const 9 Using where; Using temporary; Using filesort
1 SIMPLE cscart_product_feature_variant_descriptions eq_ref PRIMARY PRIMARY 9 mahm3t_cs443.cscart_product_feature_variants.variant_id,const 1 Using where
1 SIMPLE cscart_product_features_values ref variant_id,lang_code,product_id,product_id_idx,variant_id_idx,product_feature_idx product_id 3 const 74 Using where
1 SIMPLE cscart_product_features const PRIMARY PRIMARY 3 const 1
1 SIMPLE cscart_seo_names ref PRIMARY,dispatch PRIMARY 206 mahm3t_cs443.cscart_product_feature_variants.variant_id,const,const,const 2 Using where

Result

variant_id variant description page_title meta_keywords meta_description lang_code custom_header feature_id url position selected feature_type seo_name seo_path
5963 Light adjustment en 135 10 5963 M
5964 Blackout en 135 15 5964 M
5965 Heat protection en 135 20 M
5966 Insulation en 135 25 M
5967 Decoration en 135 30 5967 M
5968 Privacy en 135 35 5968 M
5969 Safety en 135 40 M
5970 Noise reduction en 135 45 M
5971 Insect protection en 135 50 M