Query time 0.00251
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "82.15"
},
"nested_loop": [
{
"table": {
"table_name": "v",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"fl",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "idx_product_feature_variant_id",
"used_key_parts": [
"product_id",
"feature_id"
],
"key_length": "6",
"rows_examined_per_scan": 90,
"rows_produced_per_join": 90,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "10.15",
"eval_cost": "9.00",
"prefix_cost": "19.15",
"data_read_per_join": "69K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id"
],
"attached_condition": "((`cscartdb`.`v`.`feature_id` = 345) and (`cscartdb`.`v`.`product_id` in ('18489','55622','55623','55624','55625','55626','55627','55628','55629','55630','55631','55632','55633','55634','55635','55636','55637','55638','55639','55640','55641','55642','55643','55644','55645','55646','55647','55648','55649','55650','55651','55652','55653','55654','55655','55656','55657','55658','55659','55660','55661','55662','55663','55664','55665','55666','55667','55668','55669','55670','55671','55672','55673','55674','55675','55676','55677','55678','55679','55680','55681','55682','55683','55684','55685','55686','55687','55688','55689','55690','55691','55692','55693','55694','55695','55696','55697','55698','55699','55700','55701','55702','55703','55704','55705','55706','55707','55708','55709','55710')))"
}
},
{
"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": 90,
"filtered": "100.00",
"cost_info": {
"read_cost": "22.50",
"eval_cost": "9.00",
"prefix_cost": "50.65",
"data_read_per_join": "272K"
},
"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": 90,
"filtered": "100.00",
"cost_info": {
"read_cost": "22.50",
"eval_cost": "9.00",
"prefix_cost": "82.15",
"data_read_per_join": "102K"
},
"used_columns": [
"variant_id",
"color",
"position"
]
}
}
]
}
}
Result
variant_id |
product_id |
variant |
position |
color |
1735 |
18489 |
S |
0 |
#000000 |
1735 |
55622 |
S |
0 |
#000000 |
1735 |
55623 |
S |
0 |
#000000 |
1735 |
55624 |
S |
0 |
#000000 |
1735 |
55625 |
S |
0 |
#000000 |
1735 |
55626 |
S |
0 |
#000000 |
1735 |
55627 |
S |
0 |
#000000 |
1735 |
55628 |
S |
0 |
#000000 |
1735 |
55629 |
S |
0 |
#000000 |
1735 |
55630 |
S |
0 |
#000000 |
1735 |
55631 |
S |
0 |
#000000 |
1735 |
55632 |
S |
0 |
#000000 |
1735 |
55633 |
S |
0 |
#000000 |
1735 |
55634 |
S |
0 |
#000000 |
1735 |
55635 |
S |
0 |
#000000 |
1735 |
55636 |
S |
0 |
#000000 |
1735 |
55637 |
S |
0 |
#000000 |
1735 |
55638 |
S |
0 |
#000000 |
1736 |
55639 |
M |
1 |
#000000 |
1736 |
55640 |
M |
1 |
#000000 |
1736 |
55641 |
M |
1 |
#000000 |
1736 |
55642 |
M |
1 |
#000000 |
1736 |
55643 |
M |
1 |
#000000 |
1736 |
55644 |
M |
1 |
#000000 |
1736 |
55645 |
M |
1 |
#000000 |
1736 |
55646 |
M |
1 |
#000000 |
1736 |
55647 |
M |
1 |
#000000 |
1736 |
55648 |
M |
1 |
#000000 |
1736 |
55649 |
M |
1 |
#000000 |
1736 |
55650 |
M |
1 |
#000000 |
1736 |
55651 |
M |
1 |
#000000 |
1736 |
55652 |
M |
1 |
#000000 |
1736 |
55653 |
M |
1 |
#000000 |
1736 |
55654 |
M |
1 |
#000000 |
1736 |
55655 |
M |
1 |
#000000 |
1736 |
55656 |
M |
1 |
#000000 |
1737 |
55657 |
L |
2 |
#000000 |
1737 |
55658 |
L |
2 |
#000000 |
1737 |
55659 |
L |
2 |
#000000 |
1737 |
55660 |
L |
2 |
#000000 |
1737 |
55661 |
L |
2 |
#000000 |
1737 |
55662 |
L |
2 |
#000000 |
1737 |
55663 |
L |
2 |
#000000 |
1737 |
55664 |
L |
2 |
#000000 |
1737 |
55665 |
L |
2 |
#000000 |
1737 |
55666 |
L |
2 |
#000000 |
1737 |
55667 |
L |
2 |
#000000 |
1737 |
55668 |
L |
2 |
#000000 |
1737 |
55669 |
L |
2 |
#000000 |
1737 |
55670 |
L |
2 |
#000000 |
1737 |
55671 |
L |
2 |
#000000 |
1737 |
55672 |
L |
2 |
#000000 |
1737 |
55673 |
L |
2 |
#000000 |
1737 |
55674 |
L |
2 |
#000000 |
1738 |
55675 |
XL |
3 |
#000000 |
1738 |
55676 |
XL |
3 |
#000000 |
1738 |
55677 |
XL |
3 |
#000000 |
1738 |
55678 |
XL |
3 |
#000000 |
1738 |
55679 |
XL |
3 |
#000000 |
1738 |
55680 |
XL |
3 |
#000000 |
1738 |
55681 |
XL |
3 |
#000000 |
1738 |
55682 |
XL |
3 |
#000000 |
1738 |
55683 |
XL |
3 |
#000000 |
1738 |
55684 |
XL |
3 |
#000000 |
1738 |
55685 |
XL |
3 |
#000000 |
1738 |
55686 |
XL |
3 |
#000000 |
1738 |
55687 |
XL |
3 |
#000000 |
1738 |
55688 |
XL |
3 |
#000000 |
1738 |
55689 |
XL |
3 |
#000000 |
1738 |
55690 |
XL |
3 |
#000000 |
1738 |
55691 |
XL |
3 |
#000000 |
1738 |
55692 |
XL |
3 |
#000000 |
1739 |
55693 |
XXL |
4 |
#000000 |
1739 |
55694 |
XXL |
4 |
#000000 |
1739 |
55695 |
XXL |
4 |
#000000 |
1739 |
55696 |
XXL |
4 |
#000000 |
1739 |
55697 |
XXL |
4 |
#000000 |
1739 |
55698 |
XXL |
4 |
#000000 |
1739 |
55699 |
XXL |
4 |
#000000 |
1739 |
55700 |
XXL |
4 |
#000000 |
1739 |
55701 |
XXL |
4 |
#000000 |
1739 |
55702 |
XXL |
4 |
#000000 |
1739 |
55703 |
XXL |
4 |
#000000 |
1739 |
55704 |
XXL |
4 |
#000000 |
1739 |
55705 |
XXL |
4 |
#000000 |
1739 |
55706 |
XXL |
4 |
#000000 |
1739 |
55707 |
XXL |
4 |
#000000 |
1739 |
55708 |
XXL |
4 |
#000000 |
1739 |
55709 |
XXL |
4 |
#000000 |
1739 |
55710 |
XXL |
4 |
#000000 |