Query time 0.00044
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": 10,
"filtered": 100,
"attached_condition": "pfv.feature_id = 568 and pfv.product_id in (4340,2364,3236,4344,3221,3225,3218,3246,3222,4347) 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 |
2364 |
1408 |
0 |
1 Case |
568 |
3218 |
1408 |
0 |
1 Case |
568 |
3221 |
1408 |
0 |
1 Case |
568 |
3222 |
1408 |
0 |
1 Case |
568 |
3225 |
1408 |
0 |
1 Case |
568 |
3236 |
1414 |
0 |
6 Pack |
568 |
3246 |
1414 |
0 |
6 Pack |
568 |
4340 |
1408 |
0 |
1 Case |
568 |
4344 |
1414 |
0 |
6 Pack |
568 |
4347 |
1408 |
0 |
1 Case |