Query time 0.00269
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "37.23"
},
"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": 270,
"rows_produced_per_join": 5,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "3.26",
"eval_cost": "0.54",
"prefix_cost": "33.46",
"data_read_per_join": "4K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id"
],
"attached_condition": "((`cscartdb`.`v`.`feature_id` = 1476) and (`cscartdb`.`v`.`product_id` in ('67475','67476','67477','67478','67479','67480','67481','67482','67483','67484','67485','67486','67487','67488','67489','67490','67491','67492','67493','67494','67495','67496','67497','67498','67499','67500','67501','67502','67503','67504','67505','67506','67507','67508','67509','67510','67511','67512','67513','67514','67515','67516','67517','67518','67519','67520','67521','67522','67523','67524','67525','67526','67527','67528','67529','67530','67531','67532','67533','67534','67535','67536','67537','67538','67539','67540','67541','67542','67543','67544','67545','67546','67547','67548','67549','67550','67551','67552','67553','67554','67555','67556','67557','67558','67559','67560','67561','67562','67563','67564','67565','67566','67567','67568','67569','67570','67571','67572','67573','67574','67575','67576','67577','67578','67579','67580','67581','67582','67583','67584','67585','67586','67587','67588','67589','67590','67591','67592','67593','67594','67595','67596','67597','67598','67599','67600','67601','67602','67603','67604','67605','67606','67607','67608','67609','67610','67611','67612','67613','67614','67615','67616','67617','67618','67619','67620','67621','67622','67623','67624','67625','67626','67627','67628','67629','67630','67631','67632','67633','67634','67635','67636','67637','67638','67639','67640','67641','67642','67643','67644','67645','67646','67647','67648','67649','67650','67651','67652','67653','67654','67655','67656','67657','67658','67659','67660','67661','67662','67663','67664','67665','67666','67667','67668','67669','67670','67671','67672','67673','67674','67675','67676','67677','67678','67679','67680','67681','67682','67683','67684','67685','67686','67687','67688','67689','67690','67691','67692','67693','67694','67695','67696','67697','67698','67699','67700','67701','67702','67703','67704','67705','67706','67707','67708','67709','67710','67711','67712','67713','67714','67715','67716','67717','67718','67719','67720','67721','67722','67723','67724','67725','67726','67727','67728','67729','67730','67731','67732','67733','67734','67735','67736','67737','67738','67739','67740','67741','67742','67743','67744')))"
}
},
{
"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": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.35",
"eval_cost": "0.54",
"prefix_cost": "35.35",
"data_read_per_join": "16K"
},
"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": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.35",
"eval_cost": "0.54",
"prefix_cost": "37.23",
"data_read_per_join": "6K"
},
"used_columns": [
"variant_id",
"color",
"position"
]
}
}
]
}
}
Result
variant_id |
product_id |
variant |
position |
color |
5913 |
67475 |
Ultra White |
0 |
#000000 |
5913 |
67476 |
Ultra White |
0 |
#000000 |
5913 |
67477 |
Ultra White |
0 |
#000000 |
5913 |
67478 |
Ultra White |
0 |
#000000 |
5913 |
67479 |
Ultra White |
0 |
#000000 |
5913 |
67480 |
Ultra White |
0 |
#000000 |
5913 |
67481 |
Ultra White |
0 |
#000000 |
5913 |
67482 |
Ultra White |
0 |
#000000 |
5913 |
67483 |
Ultra White |
0 |
#000000 |
5923 |
67484 |
Blonde |
10 |
#000000 |
5923 |
67485 |
Blonde |
10 |
#000000 |
5923 |
67486 |
Blonde |
10 |
#000000 |
5923 |
67487 |
Blonde |
10 |
#000000 |
5923 |
67488 |
Blonde |
10 |
#000000 |
5923 |
67489 |
Blonde |
10 |
#000000 |
5923 |
67490 |
Blonde |
10 |
#000000 |
5923 |
67491 |
Blonde |
10 |
#000000 |
5923 |
67492 |
Blonde |
10 |
#000000 |
5924 |
67493 |
Rose Gold |
11 |
#000000 |
5924 |
67494 |
Rose Gold |
11 |
#000000 |
5924 |
67495 |
Rose Gold |
11 |
#000000 |
5924 |
67496 |
Rose Gold |
11 |
#000000 |
5924 |
67497 |
Rose Gold |
11 |
#000000 |
5924 |
67498 |
Rose Gold |
11 |
#000000 |
5924 |
67499 |
Rose Gold |
11 |
#000000 |
5924 |
67500 |
Rose Gold |
11 |
#000000 |
5924 |
67501 |
Rose Gold |
11 |
#000000 |
5925 |
67502 |
Gold |
12 |
#000000 |
5925 |
67503 |
Gold |
12 |
#000000 |
5925 |
67504 |
Gold |
12 |
#000000 |
5925 |
67505 |
Gold |
12 |
#000000 |
5925 |
67506 |
Gold |
12 |
#000000 |
5925 |
67507 |
Gold |
12 |
#000000 |
5925 |
67508 |
Gold |
12 |
#000000 |
5925 |
67509 |
Gold |
12 |
#000000 |
5925 |
67510 |
Gold |
12 |
#000000 |
5926 |
67511 |
Toffee |
13 |
#000000 |
5926 |
67512 |
Toffee |
13 |
#000000 |
5926 |
67513 |
Toffee |
13 |
#000000 |
5926 |
67514 |
Toffee |
13 |
#000000 |
5926 |
67515 |
Toffee |
13 |
#000000 |
5926 |
67516 |
Toffee |
13 |
#000000 |
5926 |
67517 |
Toffee |
13 |
#000000 |
5926 |
67518 |
Toffee |
13 |
#000000 |
5926 |
67519 |
Toffee |
13 |
#000000 |
5927 |
67520 |
Wine Red |
14 |
#000000 |
5927 |
67521 |
Wine Red |
14 |
#000000 |
5927 |
67522 |
Wine Red |
14 |
#000000 |
5927 |
67523 |
Wine Red |
14 |
#000000 |
5927 |
67524 |
Wine Red |
14 |
#000000 |
5927 |
67525 |
Wine Red |
14 |
#000000 |
5927 |
67526 |
Wine Red |
14 |
#000000 |
5927 |
67527 |
Wine Red |
14 |
#000000 |
5927 |
67528 |
Wine Red |
14 |
#000000 |
5928 |
67529 |
Dark Cherry |
15 |
#000000 |
5928 |
67530 |
Dark Cherry |
15 |
#000000 |
5928 |
67531 |
Dark Cherry |
15 |
#000000 |
5928 |
67532 |
Dark Cherry |
15 |
#000000 |
5928 |
67533 |
Dark Cherry |
15 |
#000000 |
5928 |
67534 |
Dark Cherry |
15 |
#000000 |
5928 |
67535 |
Dark Cherry |
15 |
#000000 |
5928 |
67536 |
Dark Cherry |
15 |
#000000 |
5928 |
67537 |
Dark Cherry |
15 |
#000000 |
5929 |
67538 |
Pacific Blue |
16 |
#000000 |
5929 |
67539 |
Pacific Blue |
16 |
#000000 |
5929 |
67540 |
Pacific Blue |
16 |
#000000 |
5929 |
67541 |
Pacific Blue |
16 |
#000000 |
5929 |
67542 |
Pacific Blue |
16 |
#000000 |
5929 |
67543 |
Pacific Blue |
16 |
#000000 |
5929 |
67544 |
Pacific Blue |
16 |
#000000 |
5929 |
67545 |
Pacific Blue |
16 |
#000000 |
5929 |
67546 |
Pacific Blue |
16 |
#000000 |
5930 |
67547 |
Royal Blue |
17 |
#000000 |
5930 |
67548 |
Royal Blue |
17 |
#000000 |
5930 |
67549 |
Royal Blue |
17 |
#000000 |
5930 |
67550 |
Royal Blue |
17 |
#000000 |
5930 |
67551 |
Royal Blue |
17 |
#000000 |
5930 |
67552 |
Royal Blue |
17 |
#000000 |
5930 |
67553 |
Royal Blue |
17 |
#000000 |
5930 |
67554 |
Royal Blue |
17 |
#000000 |
5930 |
67555 |
Royal Blue |
17 |
#000000 |
5931 |
67556 |
Midnight Blue |
18 |
#000000 |
5931 |
67557 |
Midnight Blue |
18 |
#000000 |
5931 |
67558 |
Midnight Blue |
18 |
#000000 |
5931 |
67559 |
Midnight Blue |
18 |
#000000 |
5931 |
67560 |
Midnight Blue |
18 |
#000000 |
5931 |
67561 |
Midnight Blue |
18 |
#000000 |
5931 |
67562 |
Midnight Blue |
18 |
#000000 |
5931 |
67563 |
Midnight Blue |
18 |
#000000 |
5931 |
67564 |
Midnight Blue |
18 |
#000000 |
5932 |
67565 |
Olive Green |
19 |
#000000 |
5932 |
67566 |
Olive Green |
19 |
#000000 |
5932 |
67567 |
Olive Green |
19 |
#000000 |
5932 |
67568 |
Olive Green |
19 |
#000000 |
5932 |
67569 |
Olive Green |
19 |
#000000 |
5932 |
67570 |
Olive Green |
19 |
#000000 |
5932 |
67571 |
Olive Green |
19 |
#000000 |
5932 |
67572 |
Olive Green |
19 |
#000000 |
5932 |
67573 |
Olive Green |
19 |
#000000 |
5914 |
67574 |
Pearl |
1 |
#000000 |
5914 |
67575 |
Pearl |
1 |
#000000 |
5914 |
67576 |
Pearl |
1 |
#000000 |
5914 |
67577 |
Pearl |
1 |
#000000 |
5914 |
67578 |
Pearl |
1 |
#000000 |
5914 |
67579 |
Pearl |
1 |
#000000 |
5914 |
67580 |
Pearl |
1 |
#000000 |
5914 |
67581 |
Pearl |
1 |
#000000 |
5914 |
67582 |
Pearl |
1 |
#000000 |
5933 |
67583 |
Atlantis Green |
20 |
#000000 |
5933 |
67584 |
Atlantis Green |
20 |
#000000 |
5933 |
67585 |
Atlantis Green |
20 |
#000000 |
5933 |
67586 |
Atlantis Green |
20 |
#000000 |
5933 |
67587 |
Atlantis Green |
20 |
#000000 |
5933 |
67588 |
Atlantis Green |
20 |
#000000 |
5933 |
67589 |
Atlantis Green |
20 |
#000000 |
5933 |
67590 |
Atlantis Green |
20 |
#000000 |
5933 |
67591 |
Atlantis Green |
20 |
#000000 |
5934 |
67592 |
Dark Purple |
21 |
#000000 |
5934 |
67593 |
Dark Purple |
21 |
#000000 |
5934 |
67594 |
Dark Purple |
21 |
#000000 |
5934 |
67595 |
Dark Purple |
21 |
#000000 |
5934 |
67596 |
Dark Purple |
21 |
#000000 |
5934 |
67597 |
Dark Purple |
21 |
#000000 |
5934 |
67598 |
Dark Purple |
21 |
#000000 |
5934 |
67599 |
Dark Purple |
21 |
#000000 |
5934 |
67600 |
Dark Purple |
21 |
#000000 |
5935 |
67601 |
Dragon Scale |
22 |
#000000 |
5935 |
67602 |
Dragon Scale |
22 |
#000000 |
5935 |
67603 |
Dragon Scale |
22 |
#000000 |
5935 |
67604 |
Dragon Scale |
22 |
#000000 |
5935 |
67605 |
Dragon Scale |
22 |
#000000 |
5935 |
67606 |
Dragon Scale |
22 |
#000000 |
5935 |
67607 |
Dragon Scale |
22 |
#000000 |
5935 |
67608 |
Dragon Scale |
22 |
#000000 |
5935 |
67609 |
Dragon Scale |
22 |
#000000 |
5936 |
67610 |
Amethyst |
23 |
#000000 |
5936 |
67611 |
Amethyst |
23 |
#000000 |
5936 |
67612 |
Amethyst |
23 |
#000000 |
5936 |
67613 |
Amethyst |
23 |
#000000 |
5936 |
67614 |
Amethyst |
23 |
#000000 |
5936 |
67615 |
Amethyst |
23 |
#000000 |
5936 |
67616 |
Amethyst |
23 |
#000000 |
5936 |
67617 |
Amethyst |
23 |
#000000 |
5936 |
67618 |
Amethyst |
23 |
#000000 |
5937 |
67619 |
Blue Gold |
24 |
#000000 |
5937 |
67620 |
Blue Gold |
24 |
#000000 |
5937 |
67621 |
Blue Gold |
24 |
#000000 |
5937 |
67622 |
Blue Gold |
24 |
#000000 |
5937 |
67623 |
Blue Gold |
24 |
#000000 |
5937 |
67624 |
Blue Gold |
24 |
#000000 |
5937 |
67625 |
Blue Gold |
24 |
#000000 |
5937 |
67626 |
Blue Gold |
24 |
#000000 |
5937 |
67627 |
Blue Gold |
24 |
#000000 |
5938 |
67628 |
Dream Blue |
25 |
#000000 |
5938 |
67629 |
Dream Blue |
25 |
#000000 |
5938 |
67630 |
Dream Blue |
25 |
#000000 |
5938 |
67631 |
Dream Blue |
25 |
#000000 |
5938 |
67632 |
Dream Blue |
25 |
#000000 |
5938 |
67633 |
Dream Blue |
25 |
#000000 |
5938 |
67634 |
Dream Blue |
25 |
#000000 |
5938 |
67635 |
Dream Blue |
25 |
#000000 |
5938 |
67636 |
Dream Blue |
25 |
#000000 |
5939 |
67637 |
Hot Pink |
26 |
#000000 |
5939 |
67638 |
Hot Pink |
26 |
#000000 |
5939 |
67639 |
Hot Pink |
26 |
#000000 |
5939 |
67640 |
Hot Pink |
26 |
#000000 |
5939 |
67641 |
Hot Pink |
26 |
#000000 |
5939 |
67642 |
Hot Pink |
26 |
#000000 |
5939 |
67643 |
Hot Pink |
26 |
#000000 |
5939 |
67644 |
Hot Pink |
26 |
#000000 |
5939 |
67645 |
Hot Pink |
26 |
#000000 |
5940 |
67646 |
Octarine |
27 |
#000000 |
5940 |
67647 |
Octarine |
27 |
#000000 |
5940 |
67648 |
Octarine |
27 |
#000000 |
5940 |
67649 |
Octarine |
27 |
#000000 |
5940 |
67650 |
Octarine |
27 |
#000000 |
5940 |
67651 |
Octarine |
27 |
#000000 |
5940 |
67652 |
Octarine |
27 |
#000000 |
5940 |
67653 |
Octarine |
27 |
#000000 |
5940 |
67654 |
Octarine |
27 |
#000000 |
5941 |
67655 |
Tarrot |
28 |
#000000 |
5941 |
67656 |
Tarrot |
28 |
#000000 |
5941 |
67657 |
Tarrot |
28 |
#000000 |
5941 |
67658 |
Tarrot |
28 |
#000000 |
5941 |
67659 |
Tarrot |
28 |
#000000 |
5941 |
67660 |
Tarrot |
28 |
#000000 |
5941 |
67661 |
Tarrot |
28 |
#000000 |
5941 |
67662 |
Tarrot |
28 |
#000000 |
5941 |
67663 |
Tarrot |
28 |
#000000 |
5942 |
67664 |
Yale Blue |
29 |
#000000 |
5942 |
67665 |
Yale Blue |
29 |
#000000 |
5942 |
67666 |
Yale Blue |
29 |
#000000 |
5942 |
67667 |
Yale Blue |
29 |
#000000 |
5942 |
67668 |
Yale Blue |
29 |
#000000 |
5942 |
67669 |
Yale Blue |
29 |
#000000 |
5942 |
67670 |
Yale Blue |
29 |
#000000 |
5942 |
67671 |
Yale Blue |
29 |
#000000 |
5942 |
67672 |
Yale Blue |
29 |
#000000 |
5915 |
67673 |
Gun Metal |
2 |
#000000 |
5915 |
67674 |
Gun Metal |
2 |
#000000 |
5915 |
67675 |
Gun Metal |
2 |
#000000 |
5915 |
67676 |
Gun Metal |
2 |
#000000 |
5915 |
67677 |
Gun Metal |
2 |
#000000 |
5915 |
67678 |
Gun Metal |
2 |
#000000 |
5915 |
67679 |
Gun Metal |
2 |
#000000 |
5915 |
67680 |
Gun Metal |
2 |
#000000 |
5915 |
67681 |
Gun Metal |
2 |
#000000 |
5916 |
67682 |
Charcoal |
3 |
#000000 |
5916 |
67683 |
Charcoal |
3 |
#000000 |
5916 |
67684 |
Charcoal |
3 |
#000000 |
5916 |
67685 |
Charcoal |
3 |
#000000 |
5916 |
67686 |
Charcoal |
3 |
#000000 |
5916 |
67687 |
Charcoal |
3 |
#000000 |
5916 |
67688 |
Charcoal |
3 |
#000000 |
5916 |
67689 |
Charcoal |
3 |
#000000 |
5916 |
67690 |
Charcoal |
3 |
#000000 |
5917 |
67691 |
Onyx |
4 |
#000000 |
5917 |
67692 |
Onyx |
4 |
#000000 |
5917 |
67693 |
Onyx |
4 |
#000000 |
5917 |
67694 |
Onyx |
4 |
#000000 |
5917 |
67695 |
Onyx |
4 |
#000000 |
5917 |
67696 |
Onyx |
4 |
#000000 |
5917 |
67697 |
Onyx |
4 |
#000000 |
5917 |
67698 |
Onyx |
4 |
#000000 |
5917 |
67699 |
Onyx |
4 |
#000000 |
5918 |
67700 |
Bark Brown |
5 |
#000000 |
5918 |
67701 |
Bark Brown |
5 |
#000000 |
5918 |
67702 |
Bark Brown |
5 |
#000000 |
5918 |
67703 |
Bark Brown |
5 |
#000000 |
5918 |
67704 |
Bark Brown |
5 |
#000000 |
5918 |
67705 |
Bark Brown |
5 |
#000000 |
5918 |
67706 |
Bark Brown |
5 |
#000000 |
5918 |
67707 |
Bark Brown |
5 |
#000000 |
5918 |
67708 |
Bark Brown |
5 |
#000000 |
5919 |
67709 |
Bronze |
6 |
#000000 |
5919 |
67710 |
Bronze |
6 |
#000000 |
5919 |
67711 |
Bronze |
6 |
#000000 |
5919 |
67712 |
Bronze |
6 |
#000000 |
5919 |
67713 |
Bronze |
6 |
#000000 |
5919 |
67714 |
Bronze |
6 |
#000000 |
5919 |
67715 |
Bronze |
6 |
#000000 |
5919 |
67716 |
Bronze |
6 |
#000000 |
5919 |
67717 |
Bronze |
6 |
#000000 |
5920 |
67718 |
Copper |
7 |
#000000 |
5920 |
67719 |
Copper |
7 |
#000000 |
5920 |
67720 |
Copper |
7 |
#000000 |
5920 |
67721 |
Copper |
7 |
#000000 |
5920 |
67722 |
Copper |
7 |
#000000 |
5920 |
67723 |
Copper |
7 |
#000000 |
5920 |
67724 |
Copper |
7 |
#000000 |
5920 |
67725 |
Copper |
7 |
#000000 |
5920 |
67726 |
Copper |
7 |
#000000 |
5921 |
67727 |
Cooper Brown |
8 |
#000000 |
5921 |
67728 |
Cooper Brown |
8 |
#000000 |
5921 |
67729 |
Cooper Brown |
8 |
#000000 |
5921 |
67730 |
Cooper Brown |
8 |
#000000 |
5921 |
67731 |
Cooper Brown |
8 |
#000000 |
5921 |
67732 |
Cooper Brown |
8 |
#000000 |
5921 |
67733 |
Cooper Brown |
8 |
#000000 |
5921 |
67734 |
Cooper Brown |
8 |
#000000 |
5921 |
67735 |
Cooper Brown |
8 |
#000000 |
5922 |
67736 |
Pewter |
9 |
#000000 |
5922 |
67737 |
Pewter |
9 |
#000000 |
5922 |
67738 |
Pewter |
9 |
#000000 |
5922 |
67739 |
Pewter |
9 |
#000000 |
5922 |
67740 |
Pewter |
9 |
#000000 |
5922 |
67741 |
Pewter |
9 |
#000000 |
5922 |
67742 |
Pewter |
9 |
#000000 |
5922 |
67743 |
Pewter |
9 |
#000000 |
5922 |
67744 |
Pewter |
9 |
#000000 |