Sandbox

SELECT 
  * 
FROM 
  cscart_vd_vendors_relationships 
WHERE 
  brand_id = 89

Query time 0.00044

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_vd_vendors_relationships",
          "access_type": "ref",
          "possible_keys": ["brand_id"],
          "key": "brand_id",
          "key_length": "4",
          "used_key_parts": ["brand_id"],
          "ref": ["const"],
          "rows": 17,
          "filtered": 100
        }
      }
    ]
  }
}

Result

id	brand_id	feature_id	variant_id	lang_code
1544	89	653	2128	es
1545	89	646	1887	es
1546	89	658	2179	es
1547	89	660	2188	es
1548	89	648	1911	es
6679	89	662	2211	es
1550	89	649	1924	es
1551	89	652	2114	es
1552	89	652	2119	es
1553	89	652	2125	es
1554	89	652	2124	es
1555	89	652	2110	es
1556	89	652	2107	es
1557	89	654	2136	es
1558	89	654	2140	es
1559	89	654	2141	es
1560	89	647	1889	es
5790	89	661	2198	es