{
"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": 25,
"filtered": 100,
"index_condition": "pfv.variant_id in (1498,1499,1500,1501,1514,1238,1207,1504,1518,1519,1520,1540,1541,1554,1555,1556,1206,1216,1564,1242,1550,1565,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 |
---|---|---|
1206 | 2 | Black |
1207 | 1 | White |
1212 | 0 | Yellow |
1213 | 0 | Gold |
1215 | 0 | Silver |
1216 | 0 | BLUE |
1238 | 0 | Red |
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 |
1540 | 0 | 66cm x 23cm x 23cm |
1541 | 0 | 66cm x 16cm x 18cm |
1550 | 0 | Multi colour |
1554 | 0 | Animal print |
1555 | 0 | Zebra print |
1556 | 0 | Batik |
1564 | 0 | Blue/green |
1565 | 0 | Blue/Grey |