Query time 0.00223
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "69.41"
},
"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": 76,
"rows_produced_per_join": 76,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "8.61",
"eval_cost": "7.60",
"prefix_cost": "16.21",
"data_read_per_join": "58K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id"
],
"attached_condition": "((`cscartdb`.`v`.`feature_id` = 345) and (`cscartdb`.`v`.`product_id` in ('18638','57377','57378','57379','57380','57381','57382','57383','57384','57385','57386','57387','57388','57389','57390','57391','57392','57393','57394','57395','57396','57397','57398','57399','57400','57401','57402','57403','57404','57405','57406','57407','57408','57409','57410','57411','57412','57413','57414','57415','57416','57417','57418','57419','57420','57421','57422','57423','57424','57425','57426','57427','57428','57429','57430','57431','57432','57433','57434','57435','57436','57437','57438','57439','57440','57441','57442','57443','57444','57445','57446','57447','57448','57449','57450')))"
}
},
{
"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": 76,
"filtered": "100.00",
"cost_info": {
"read_cost": "19.00",
"eval_cost": "7.60",
"prefix_cost": "42.81",
"data_read_per_join": "229K"
},
"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": 76,
"filtered": "100.00",
"cost_info": {
"read_cost": "19.00",
"eval_cost": "7.60",
"prefix_cost": "69.41",
"data_read_per_join": "86K"
},
"used_columns": [
"variant_id",
"color",
"position"
]
}
}
]
}
}
Result
variant_id |
product_id |
variant |
position |
color |
1735 |
18638 |
S |
0 |
#000000 |
1735 |
57377 |
S |
0 |
#000000 |
1735 |
57378 |
S |
0 |
#000000 |
1735 |
57379 |
S |
0 |
#000000 |
1735 |
57380 |
S |
0 |
#000000 |
1735 |
57381 |
S |
0 |
#000000 |
1735 |
57382 |
S |
0 |
#000000 |
1735 |
57383 |
S |
0 |
#000000 |
1735 |
57384 |
S |
0 |
#000000 |
1735 |
57385 |
S |
0 |
#000000 |
1735 |
57386 |
S |
0 |
#000000 |
1735 |
57387 |
S |
0 |
#000000 |
1735 |
57388 |
S |
0 |
#000000 |
1735 |
57389 |
S |
0 |
#000000 |
1735 |
57390 |
S |
0 |
#000000 |
1736 |
57391 |
M |
1 |
#000000 |
1736 |
57392 |
M |
1 |
#000000 |
1736 |
57393 |
M |
1 |
#000000 |
1736 |
57394 |
M |
1 |
#000000 |
1736 |
57395 |
M |
1 |
#000000 |
1736 |
57396 |
M |
1 |
#000000 |
1736 |
57397 |
M |
1 |
#000000 |
1736 |
57398 |
M |
1 |
#000000 |
1736 |
57399 |
M |
1 |
#000000 |
1736 |
57400 |
M |
1 |
#000000 |
1736 |
57401 |
M |
1 |
#000000 |
1736 |
57402 |
M |
1 |
#000000 |
1736 |
57403 |
M |
1 |
#000000 |
1736 |
57404 |
M |
1 |
#000000 |
1736 |
57405 |
M |
1 |
#000000 |
1737 |
57406 |
L |
2 |
#000000 |
1737 |
57407 |
L |
2 |
#000000 |
1737 |
57408 |
L |
2 |
#000000 |
1737 |
57409 |
L |
2 |
#000000 |
1737 |
57410 |
L |
2 |
#000000 |
1737 |
57411 |
L |
2 |
#000000 |
1737 |
57412 |
L |
2 |
#000000 |
1737 |
57413 |
L |
2 |
#000000 |
1737 |
57414 |
L |
2 |
#000000 |
1737 |
57415 |
L |
2 |
#000000 |
1737 |
57416 |
L |
2 |
#000000 |
1737 |
57417 |
L |
2 |
#000000 |
1737 |
57418 |
L |
2 |
#000000 |
1737 |
57419 |
L |
2 |
#000000 |
1737 |
57420 |
L |
2 |
#000000 |
1738 |
57421 |
XL |
3 |
#000000 |
1738 |
57422 |
XL |
3 |
#000000 |
1738 |
57423 |
XL |
3 |
#000000 |
1738 |
57424 |
XL |
3 |
#000000 |
1738 |
57425 |
XL |
3 |
#000000 |
1738 |
57426 |
XL |
3 |
#000000 |
1738 |
57427 |
XL |
3 |
#000000 |
1738 |
57428 |
XL |
3 |
#000000 |
1738 |
57429 |
XL |
3 |
#000000 |
1738 |
57430 |
XL |
3 |
#000000 |
1738 |
57431 |
XL |
3 |
#000000 |
1738 |
57432 |
XL |
3 |
#000000 |
1738 |
57433 |
XL |
3 |
#000000 |
1738 |
57434 |
XL |
3 |
#000000 |
1738 |
57435 |
XL |
3 |
#000000 |
1739 |
57436 |
XXL |
4 |
#000000 |
1739 |
57437 |
XXL |
4 |
#000000 |
1739 |
57438 |
XXL |
4 |
#000000 |
1739 |
57439 |
XXL |
4 |
#000000 |
1739 |
57440 |
XXL |
4 |
#000000 |
1739 |
57441 |
XXL |
4 |
#000000 |
1739 |
57442 |
XXL |
4 |
#000000 |
1739 |
57443 |
XXL |
4 |
#000000 |
1739 |
57444 |
XXL |
4 |
#000000 |
1739 |
57445 |
XXL |
4 |
#000000 |
1739 |
57446 |
XXL |
4 |
#000000 |
1739 |
57447 |
XXL |
4 |
#000000 |
1739 |
57448 |
XXL |
4 |
#000000 |
1739 |
57449 |
XXL |
4 |
#000000 |
1739 |
57450 |
XXL |
4 |
#000000 |