SELECT 
  * 
FROM 
  tmall_product_feature_variants 
  LEFT JOIN tmall_product_feature_variant_descriptions ON tmall_product_feature_variant_descriptions.variant_id = tmall_product_feature_variants.variant_id 
  AND tmall_product_feature_variant_descriptions.lang_code = 'en' 
WHERE 
  tmall_product_feature_variants.variant_id = 117

Query time 0.01447

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "nested_loop": [
      {
        "table": {
          "table_name": "tmall_product_feature_variants",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["variant_id"],
          "ref": ["const"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "tmall_product_feature_variant_descriptions",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["variant_id", "lang_code"],
          "ref": ["const", "const"],
          "rows": 1,
          "filtered": 100
        }
      }
    ]
  }
}

Result

variant_id feature_id url color position abt__ut2_color_style abt__ut2_multicolor variant description page_title meta_keywords meta_description lang_code ab__emd_alternative_name
117 18 0 default Nikon <p><p><b>Nikon Corporation</b>, also known as just <b>Nikon</b>, is a Japanese multinational corporation headquartered in Tokyo, Japan, specializing in optics and imaging products.</p> <p>Its products include cameras, camera lenses, binoculars, microscopes, ophthalmic lenses, measurement instruments, and the steppers used in the photolithography steps of semiconductor fabrication, of which it is the world's second largest manufacturer. The companies held by Nikon form the Nikon Group. Among its products are Nikkor imaging lenses (for F-mount cameras, large format photography, photographic enlargers, and other applications), the Nikon F-series of 135 film SLR cameras, the Nikon D-series of digital SLR cameras, the Coolpix series of compact digital cameras, and the Nikonos series of underwater film cameras. Nikon's main competitors in camera and lens manufacturing include Canon, Sony, Pentax, and Olympus.</p> <p> </p><div><img> <div> <div><img> West Building of Nikon in Nishi-Ōi,Tokyo</div> </div> </div> <p>Founded in 25 July 1917 as <i>Nippon Kōgaku Kōgyō Kabushikigaisha</i> , the company was renamed Nikon Corporation, after its cameras, in 1988. Nikon is one of the companies of the Mitsubishi Group.</p></p> en