{
"query_block": {
"select_id": 1,
"table": {
"table_name": "pfv",
"access_type": "range",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["variant_id"],
"rows": 50,
"filtered": 100,
"index_condition": "pfv.variant_id in (1498,1499,1500,1501,1514,1238,1207,1504,1518,1519,1520,1521,1522,1523,1540,1541,1552,1600,1554,1555,1558,1559,1561,1560,1556,1205,1206,1216,1564,1242,1550,1565,1239,1566,1567,1208,1218,1577,1578,1579,1580,1581,1582,1583,1584,1586,1587,1215,1213,1212)"
},
"table": {
"table_name": "pfvd",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["variant_id", "lang_code"],
"ref": ["ymonline_livedata.pfv.variant_id", "const"],
"rows": 1,
"filtered": 100,
"index_condition": "pfvd.lang_code = 'en'"
}
}
}
variant_id | position | variant |
---|---|---|
1205 | 3 | Brown |
1206 | 2 | Black |
1207 | 1 | White |
1208 | 4 | Green |
1212 | 0 | Yellow |
1213 | 0 | Gold |
1215 | 0 | Silver |
1216 | 0 | BLUE |
1218 | 0 | Orange |
1238 | 0 | Red |
1239 | 0 | Purple |
1242 | 0 | Grey |
1498 | 0 | Stripe |
1499 | 0 | Chevron |
1500 | 0 | White |
1501 | 0 | Batik |
1504 | 0 | Star |
1514 | 0 | Dark red |
1518 | 0 | Flower batik |
1519 | 0 | Stripe batik |
1520 | 0 | Plain |
1521 | 0 | Chevron stripe |
1522 | 0 | Long stripe |
1523 | 0 | Circles |
1540 | 0 | 66cm x 23cm x 23cm |
1541 | 0 | 66cm x 16cm x 18cm |
1550 | 0 | Multi colour |
1552 | 0 | Bush colours |
1554 | 0 | Animal print |
1555 | 0 | Zebra print |
1556 | 0 | Batik |
1558 | 0 | Copper beads |
1559 | 0 | Bone beads |
1560 | 0 | More Blue |
1561 | 0 | More Red |
1564 | 0 | Blue/green |
1565 | 0 | Blue/Grey |
1566 | 0 | Brown Oval |
1567 | 0 | Brown rectangle |
1577 | 0 | Black with Natural triangle pattern |
1578 | 0 | Black with rectangle and dot pattern |
1579 | 0 | Black with chevron & stripe pattern |
1580 | 0 | Black with white stripe pattern |
1581 | 0 | Black and white with patterns |
1582 | 0 | Natural with black wave pattern |
1583 | 0 | Natural with black chevron and dot pattern |
1584 | 0 | Natural with black chevron pattern |
1586 | 0 | Mustard & brown both with patterns |
1587 | 0 | Mustard with natural chevron pattern |
1600 | 0 | Elephant pattern |