Query time 0.00120
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "10.26"
},
"nested_loop": [
{
"table": {
"table_name": "v",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"fl",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id",
"product_id"
],
"key_length": "6",
"rows_examined_per_scan": 11,
"rows_produced_per_join": 11,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.46",
"eval_cost": "1.10",
"prefix_cost": "2.56",
"data_read_per_join": "8K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id"
],
"attached_condition": "((`cscartdb`.`v`.`feature_id` = 1188) and (`cscartdb`.`v`.`product_id` in ('33758','33761','33760','33759','33752','33757','33756','33755','33754','33753','32298')))"
}
},
{
"table": {
"table_name": "vd",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscartdb.v.variant_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 11,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.75",
"eval_cost": "1.10",
"prefix_cost": "6.41",
"data_read_per_join": "33K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
]
}
},
{
"table": {
"table_name": "vf",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"ref": [
"cscartdb.v.variant_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 11,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.75",
"eval_cost": "1.10",
"prefix_cost": "10.26",
"data_read_per_join": "12K"
},
"used_columns": [
"variant_id",
"color",
"position"
]
}
}
]
}
}
Result
variant_id |
product_id |
variant |
position |
color |
4485 |
32298 |
COIR ALL NATURAL MINI 16"X24" |
1 |
#ffffff |
4505 |
33752 |
ALL WEATHER GRAY LARGE 24"X36" |
10 |
#ffffff |
4506 |
33753 |
ALL WEATHER GRAY EXTRA LARGE 30"X47" |
11 |
#ffffff |
4486 |
33754 |
COIR ALL NATURAL MEDIUM 18” x 30” *MOST POPULAR SIZE |
2 |
#ffffff |
4493 |
33755 |
COIR ALL NATURAL MEDIUM DELUXE HAND-PAINTED 18” x 30” |
3 |
#ffffff |
4494 |
33756 |
COIR ALL NATURAL LARGE DELUXE HAND-PAINTED 24"X30" |
4 |
#ffffff |
4495 |
33757 |
COIR ALL NATURAL LARGE 24” x 36” |
5 |
#ffffff |
4496 |
33758 |
COIR ALL NATURAL SUPER SIZE 24"X48" |
6 |
#ffffff |
4498 |
33759 |
COIR ALL NATURAL SUPER DUPER SIZE 36"X60" |
7 |
#ffffff |
4502 |
33760 |
ALL WEATHER CREAM 18"X30" |
8 |
#ffffff |
4501 |
33761 |
ALL WEATHER GRAY 18"X30" |
9 |
#ffffff |