Sandbox

SELECT 
  * 
FROM 
  cscart_vd_vendors_relationships 
WHERE 
  brand_id = 72

Query time 0.00035

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": 22,
          "filtered": 100
        }
      }
    ]
  }
}

Result

id	brand_id	feature_id	variant_id	lang_code
10109	72	661	2198	es
10108	72	649	1925	es
10107	72	648	1898	es
10106	72	654	2140	es
10105	72	647	1890	es
10104	72	662	2212	es
10103	72	662	2211	es
10102	72	660	2224	es
10101	72	660	2194	es
10100	72	660	2193	es
10099	72	660	2188	es
10098	72	658	2180	es
10097	72	658	2179	es
10096	72	658	2178	es
10095	72	652	2104	es
10094	72	652	2106	es
10093	72	652	2123	es
10092	72	646	1887	es
10091	72	653	2128	es