Query time 0.00035
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": "PRIMARY",
"key_length": "6",
"used_key_parts": ["feature_id", "product_id"],
"rows": 2,
"filtered": 100,
"attached_condition": "pfv.feature_id = 568 and pfv.product_id in (2383,2380) 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"],
"rowid_filter": {
"range": {
"key": "feature_id",
"used_key_parts": ["feature_id"]
},
"rows": 9,
"selectivity_pct": 1.451612903
},
"rows": 1,
"filtered": 100,
"attached_condition": "fv.feature_id = 568"
},
"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 |
568 |
2380 |
1408 |
0 |
1 Case |
568 |
2383 |
1408 |
0 |
1 Case |