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 = 'es' 
WHERE 
  cscart_product_feature_variants.variant_id = 101

Query time 0.00072

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_feature_variants",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "variant_id"
          ],
          "key_length": "3",
          "ref": [
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.20",
            "prefix_cost": "0.00",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "variant_id",
            "feature_id",
            "url",
            "color",
            "position"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_product_feature_variant_descriptions",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "variant_id",
            "lang_code"
          ],
          "key_length": "9",
          "ref": [
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.20",
            "prefix_cost": "0.00",
            "data_read_per_join": "3K"
          },
          "used_columns": [
            "variant_id",
            "variant",
            "description",
            "page_title",
            "meta_keywords",
            "meta_description",
            "lang_code"
          ]
        }
      }
    ]
  }
}

Result

variant_id feature_id url color position variant description page_title meta_keywords meta_description lang_code
101 18 0 TomTom <p><b>TomTom NV</b> (Euronext:&nbsp;TOM2) is a Dutch manufacturer of automotive navigation systems, including both stand-alone units and software for personal digital assistants and mobile telephones. It is the leading manufacturer of navigation systems in Europe. TomTom's customer service is located in Amsterdam, Netherlands. TomTom was a follow-up of Palmtop Software, founded by Peter-Frans Pauwels, Pieter Geelen, Harold Goddijn and Corinne Vigreux in 1991.</p> <p>In 2008, TomTom acquired Tele Atlas, a digital map maker, for €2.9 billion.</p> <p>On June 11, 2012, at an event for Apple's iOS 6 preview, TomTom was announced as the main mapping data provider for Apple's revamped iOS 6 "Maps" app replacing long time provider Google Maps.</p><p><br></p> es