Query time 0.00165
JSON explain
{
"query_block": {
"select_id": 1,
"table": {
"table_name": "pfv",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"fl",
"variant_id",
"lang_code",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "idx_product_feature_variant_id",
"key_length": "12",
"used_key_parts": ["product_id", "feature_id", "lang_code"],
"rows": 24,
"filtered": 100,
"attached_condition": "pfv.feature_id in (574,575,551,564) and pfv.product_id in (4970,4963,4974,4978,4956,4959) and pfv.lang_code = 'en'",
"using_index": true
},
"table": {
"table_name": "fv",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "feature_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["variant_id"],
"ref": ["ymonline_livedata.pfv.variant_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "fv.feature_id = pfv.feature_id"
},
"table": {
"table_name": "fvd",
"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": "fvd.lang_code = 'en'"
}
}
}
Result
feature_id |
product_id |
variant_id |
position |
variant |
564 |
4956 |
1716 |
0 |
21.5" |
574 |
4956 |
1461 |
0 |
256GB |
575 |
4956 |
1715 |
0 |
3.0GHZ 6-CORE 8TH GENERATION I5 |
564 |
4959 |
1720 |
0 |
27" |
574 |
4959 |
1461 |
0 |
256GB |
575 |
4959 |
1719 |
0 |
3.1GHZ 6-CORE 10TH-GENERATION |
551 |
4963 |
1470 |
0 |
SPACE GREY |
574 |
4963 |
1466 |
0 |
128GB |
575 |
4963 |
1723 |
0 |
1.8GHZ DUAL-CORE I5 |
551 |
4970 |
1469 |
0 |
SILVER |
574 |
4970 |
1456 |
0 |
1TB |
575 |
4970 |
1725 |
0 |
2.0GHZ QUAD-CORE 10th GENERATION I5 |
551 |
4974 |
1469 |
0 |
SILVER |
574 |
4974 |
1461 |
0 |
256GB |
575 |
4974 |
1724 |
0 |
APPLE M1 CHIP WITH 8-CORE |
551 |
4978 |
1469 |
0 |
SILVER |
574 |
4978 |
1456 |
0 |
1TB |
575 |
4978 |
1729 |
0 |
2.3GHZ 8-CORE 9TH-GENERATION I9 |