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 = 99

Query time 0.01513

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
99 18 0 default Intel <p><p><b>Intel Corporation</b> is an American multinational semiconductor chip maker corporation headquartered in Santa Clara, California. Intel is the world's largest and highest valued semiconductor chip maker, based on revenue. It is the inventor of the x86 series of microprocessors, the processors found in most personal computers. Intel Corporation, founded on July 18, 1968, is a portmanteau of <b>Int</b>egrated <b>El</b>ectronics (the fact that "intel" is the term for intelligence information was also quite suitable). Intel also makes motherboard chipsets, network interface controllers and integrated circuits, flash memory, graphic chips, embedded processors and other devices related to communications and computing. Founded by semiconductor pioneers Robert Noyce and Gordon Moore and widely associated with the executive leadership and vision of Andrew Grove, Intel combines advanced chip design capability with a leading-edge manufacturing capability. Though Intel was originally known primarily to engineers and technologists, its "Intel Inside" advertising campaign of the 1990s made it and its Pentium processor household names.</p> <p>Intel was an early developer of SRAM and DRAM memory chips, and this represented the majority of its business until 1981. Although Intel created the world's first commercial microprocessor chip in 1971, it was not until the success of the personal computer (PC) that this became its primary business. During the 1990s, Intel invested heavily in new microprocessor designs fostering the rapid growth of the computer industry. During this period Intel became the dominant supplier of microprocessors for PCs, and was known for aggressive and sometimes illegal tactics in defense of its market position, particularly against Advanced Micro Devices (AMD), as well as a struggle with Microsoft for control over the direction of the PC industry. The 2011 rankings of the world's 100 most valuable brands published by Millward Brown Optimor showed the company's brand value at number 58 and in 2012 at number 49.</p> <p>Intel has also begun research in electrical transmission and generation. Intel has recently introduced a 3-D transistor that improves performance and energy efficiency. Intel has begun mass-producing this 3-D transistor, named the Tri-Gate transistor, with their 22&nbsp;nm process, which is currently used in their 3rd generation core processors initially released on April 29, 2012. In 2011, SpectraWatt Inc., a solar cell spinoff of Intel, filed for bankruptcy under Chapter 11.</p> <p>The <b>Open Source Technology Center</b> at Intel hosts PowerTOP and LatencyTOP, and supports other open-source projects such as Wayland, Intel Array Building Blocks, Intel Threading Building Blocks, and Xen.</p><br></p> en