{
"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": 19,
"filtered": 100,
"index_condition": "pfv.variant_id in (1498,1524,1205,1534,1535,1214,1536,1537,1206,1207,1544,1545,1556,1557,1208,1213,1215,1604,1605)"
},
"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 |
1213 | 0 | Gold |
1214 | 0 | PINK |
1215 | 0 | Silver |
1498 | 0 | Stripe |
1524 | 0 | 3 circle |
1534 | 0 | Kenti yellow |
1535 | 0 | Kenti multi-colour |
1536 | 0 | More orange |
1537 | 0 | More yellow |
1544 | 0 | Large bead |
1545 | 0 | Medium bead |
1556 | 0 | Batik |
1557 | 0 | Batik spots |
1604 | 0 | Male |
1605 | 0 | Female |