SELECT 
  * 
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 = 'tr' 
WHERE 
  cscart_product_feature_variants.variant_id = 111

Query time 0.00074

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_feature_variants const PRIMARY PRIMARY 3 const 1
1 SIMPLE cscart_product_feature_variant_descriptions const PRIMARY PRIMARY 9 const,const 1

Result

variant_id feature_id url color position variant description page_title meta_keywords meta_description lang_code gr__sf_seo_variant
111 18 0 Creative <p><b>Creative Technology Ltd.</b> is a Singapore-based global company headquartered in Jurong East, Singapore. The principal activities of the company and its subsidiaries consist of the design, manufacture and distribution of digitized sound and video boards, computers and related multimedia, and personal digital entertainment products.<br></p> tr