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 = 'de' 
WHERE 
  cscart_product_feature_variants.variant_id = 217

Query time 0.00012

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.10",
            "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.10",
            "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
217 5 0 Flesh & Blood <p><i style="color: rgb(34, 34, 34); font-size: 21px; font-weight: 700;">"</i><b style="color: rgb(34, 34, 34); font-size: 21px;"><i>Our mission is to bring people together in the flesh and blood through the common language of playing great games."</i></b></p> <p> Flesh and Blood is created by an independent studio based in Auckland, New Zealand. Created for gamers, by gamers, Flesh and Blood spent seven years in development before its worldwide debut in October, 2019, with the release of our first booster set,<a href="https://fabtcg.com/products/booster-set/welcome-rathe/">&nbsp;Welcome to Rathe</a>.</p> <p>Flesh and Blood rewards good decisions, not good luck. With our game, we seek to challenge the fundamental laws of TCG card evaluation and deck building philosophies. It’s highly interactive, with action beginning from the very first turn. The game is built around a unique resource system, underpinning an innovative combat dynamic which has been rigorously tested by competitive TCG fanatics.</p> de