SELECT 
  vvr.*, 
  pfd.description, 
  pfvd.variant 
FROM 
  cscart_vd_vendors_relationships AS vvr 
  LEFT JOIN cscart_product_features_descriptions AS pfd ON pfd.feature_id = vvr.feature_id 
  AND pfd.lang_code = 'en' 
  LEFT JOIN cscart_product_feature_variant_descriptions AS pfvd ON pfvd.variant_id = vvr.variant_id 
  AND pfd.lang_code = 'en' 
WHERE 
  brand_id = 264

Query time 0.00073

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "vvr",
          "access_type": "ref",
          "possible_keys": ["brand_id"],
          "key": "brand_id",
          "key_length": "4",
          "used_key_parts": ["brand_id"],
          "ref": ["const"],
          "rows": 16,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "pfd",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["feature_id", "lang_code"],
          "ref": ["live_clonned.vvr.feature_id", "const"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(pfd.feature_id = vvr.feature_id and pfd.lang_code = 'en')"
        }
      },
      {
        "table": {
          "table_name": "pfvd",
          "access_type": "ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["variant_id"],
          "ref": ["live_clonned.vvr.variant_id"],
          "rows": 11,
          "filtered": 100,
          "attached_condition": "trigcond(pfvd.variant_id = vvr.variant_id and trigcond(pfd.lang_code = 'en'))"
        }
      }
    ]
  }
}

Result

id brand_id feature_id variant_id lang_code description variant
4834 264 639 1787 es Specialization Vintage clothing (garments more than 15 years old)
4834 264 639 1787 es Specialization Ropa vintage (prendas con más de 15 años de antigüedad)
4835 264 648 1920 es Headquarters Veracruz
4835 264 648 1920 es Headquarters Veracruz
4836 264 653 2128 es Products Clothes
4836 264 653 2128 es Products Ropa
4837 264 653 2130 es Products Footwear
4837 264 653 2130 es Products Calzado
4838 264 653 2131 es Products Bags
4838 264 653 2131 es Products Bolsas
4839 264 656 2153 es Vintage Period 70s
4839 264 656 2153 es Vintage Period Años 70
4840 264 656 2154 es Vintage Period 80s
4840 264 656 2154 es Vintage Period Años 80
4841 264 656 2155 es Vintage Period 90s
4841 264 656 2155 es Vintage Period Años 90
4842 264 656 2156 es Vintage Period 2000s
4842 264 656 2156 es Vintage Period Años 2000
4843 264 652 2124 es Mood Streetwear
4843 264 652 2124 es Mood Streetwear
4844 264 652 2104 es Mood Timeless
4844 264 652 2104 es Mood Atemporal
4845 264 652 2117 es Mood Maximalist
4845 264 652 2117 es Mood Maximalista
4846 264 652 2108 es Mood Colorful
4846 264 652 2108 es Mood Colorido
4847 264 660 2188 es Market Segment Casual
4847 264 660 2188 es Market Segment Casual
4848 264 649 1924 es Price Range Economy $300 - $999
4848 264 649 1924 es Price Range Económico $300 - $999
4849 264 650 1929 es Swapping Events No
4849 264 650 1929 es Swapping Events No
5965 264 661 2199 es New / Second Hand Second hand / Vintage
5965 264 661 2199 es New / Second Hand Segunda Mano / vintage