Query time 0.00523
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` = 1509) 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 |
6150 |
67475 |
Soft |
0 |
#000000 |
6151 |
67476 |
Medium |
1 |
#000000 |
6152 |
67477 |
Firm |
2 |
#000000 |
6150 |
67478 |
Soft |
0 |
#000000 |
6151 |
67479 |
Medium |
1 |
#000000 |
6152 |
67480 |
Firm |
2 |
#000000 |
6150 |
67481 |
Soft |
0 |
#000000 |
6151 |
67482 |
Medium |
1 |
#000000 |
6152 |
67483 |
Firm |
2 |
#000000 |
6150 |
67484 |
Soft |
0 |
#000000 |
6151 |
67485 |
Medium |
1 |
#000000 |
6152 |
67486 |
Firm |
2 |
#000000 |
6150 |
67487 |
Soft |
0 |
#000000 |
6151 |
67488 |
Medium |
1 |
#000000 |
6152 |
67489 |
Firm |
2 |
#000000 |
6150 |
67490 |
Soft |
0 |
#000000 |
6151 |
67491 |
Medium |
1 |
#000000 |
6152 |
67492 |
Firm |
2 |
#000000 |
6150 |
67493 |
Soft |
0 |
#000000 |
6151 |
67494 |
Medium |
1 |
#000000 |
6152 |
67495 |
Firm |
2 |
#000000 |
6150 |
67496 |
Soft |
0 |
#000000 |
6151 |
67497 |
Medium |
1 |
#000000 |
6152 |
67498 |
Firm |
2 |
#000000 |
6150 |
67499 |
Soft |
0 |
#000000 |
6151 |
67500 |
Medium |
1 |
#000000 |
6152 |
67501 |
Firm |
2 |
#000000 |
6150 |
67502 |
Soft |
0 |
#000000 |
6151 |
67503 |
Medium |
1 |
#000000 |
6152 |
67504 |
Firm |
2 |
#000000 |
6150 |
67505 |
Soft |
0 |
#000000 |
6151 |
67506 |
Medium |
1 |
#000000 |
6152 |
67507 |
Firm |
2 |
#000000 |
6150 |
67508 |
Soft |
0 |
#000000 |
6151 |
67509 |
Medium |
1 |
#000000 |
6152 |
67510 |
Firm |
2 |
#000000 |
6150 |
67511 |
Soft |
0 |
#000000 |
6151 |
67512 |
Medium |
1 |
#000000 |
6152 |
67513 |
Firm |
2 |
#000000 |
6150 |
67514 |
Soft |
0 |
#000000 |
6151 |
67515 |
Medium |
1 |
#000000 |
6152 |
67516 |
Firm |
2 |
#000000 |
6150 |
67517 |
Soft |
0 |
#000000 |
6151 |
67518 |
Medium |
1 |
#000000 |
6152 |
67519 |
Firm |
2 |
#000000 |
6150 |
67520 |
Soft |
0 |
#000000 |
6151 |
67521 |
Medium |
1 |
#000000 |
6152 |
67522 |
Firm |
2 |
#000000 |
6150 |
67523 |
Soft |
0 |
#000000 |
6151 |
67524 |
Medium |
1 |
#000000 |
6152 |
67525 |
Firm |
2 |
#000000 |
6150 |
67526 |
Soft |
0 |
#000000 |
6151 |
67527 |
Medium |
1 |
#000000 |
6152 |
67528 |
Firm |
2 |
#000000 |
6150 |
67529 |
Soft |
0 |
#000000 |
6151 |
67530 |
Medium |
1 |
#000000 |
6152 |
67531 |
Firm |
2 |
#000000 |
6150 |
67532 |
Soft |
0 |
#000000 |
6151 |
67533 |
Medium |
1 |
#000000 |
6152 |
67534 |
Firm |
2 |
#000000 |
6150 |
67535 |
Soft |
0 |
#000000 |
6151 |
67536 |
Medium |
1 |
#000000 |
6152 |
67537 |
Firm |
2 |
#000000 |
6150 |
67538 |
Soft |
0 |
#000000 |
6151 |
67539 |
Medium |
1 |
#000000 |
6152 |
67540 |
Firm |
2 |
#000000 |
6150 |
67541 |
Soft |
0 |
#000000 |
6151 |
67542 |
Medium |
1 |
#000000 |
6152 |
67543 |
Firm |
2 |
#000000 |
6150 |
67544 |
Soft |
0 |
#000000 |
6151 |
67545 |
Medium |
1 |
#000000 |
6152 |
67546 |
Firm |
2 |
#000000 |
6150 |
67547 |
Soft |
0 |
#000000 |
6151 |
67548 |
Medium |
1 |
#000000 |
6152 |
67549 |
Firm |
2 |
#000000 |
6150 |
67550 |
Soft |
0 |
#000000 |
6151 |
67551 |
Medium |
1 |
#000000 |
6152 |
67552 |
Firm |
2 |
#000000 |
6150 |
67553 |
Soft |
0 |
#000000 |
6151 |
67554 |
Medium |
1 |
#000000 |
6152 |
67555 |
Firm |
2 |
#000000 |
6150 |
67556 |
Soft |
0 |
#000000 |
6151 |
67557 |
Medium |
1 |
#000000 |
6152 |
67558 |
Firm |
2 |
#000000 |
6150 |
67559 |
Soft |
0 |
#000000 |
6151 |
67560 |
Medium |
1 |
#000000 |
6152 |
67561 |
Firm |
2 |
#000000 |
6150 |
67562 |
Soft |
0 |
#000000 |
6151 |
67563 |
Medium |
1 |
#000000 |
6152 |
67564 |
Firm |
2 |
#000000 |
6150 |
67565 |
Soft |
0 |
#000000 |
6151 |
67566 |
Medium |
1 |
#000000 |
6152 |
67567 |
Firm |
2 |
#000000 |
6150 |
67568 |
Soft |
0 |
#000000 |
6151 |
67569 |
Medium |
1 |
#000000 |
6152 |
67570 |
Firm |
2 |
#000000 |
6150 |
67571 |
Soft |
0 |
#000000 |
6151 |
67572 |
Medium |
1 |
#000000 |
6152 |
67573 |
Firm |
2 |
#000000 |
6150 |
67574 |
Soft |
0 |
#000000 |
6151 |
67575 |
Medium |
1 |
#000000 |
6152 |
67576 |
Firm |
2 |
#000000 |
6150 |
67577 |
Soft |
0 |
#000000 |
6151 |
67578 |
Medium |
1 |
#000000 |
6152 |
67579 |
Firm |
2 |
#000000 |
6150 |
67580 |
Soft |
0 |
#000000 |
6151 |
67581 |
Medium |
1 |
#000000 |
6152 |
67582 |
Firm |
2 |
#000000 |
6150 |
67583 |
Soft |
0 |
#000000 |
6151 |
67584 |
Medium |
1 |
#000000 |
6152 |
67585 |
Firm |
2 |
#000000 |
6150 |
67586 |
Soft |
0 |
#000000 |
6151 |
67587 |
Medium |
1 |
#000000 |
6152 |
67588 |
Firm |
2 |
#000000 |
6150 |
67589 |
Soft |
0 |
#000000 |
6151 |
67590 |
Medium |
1 |
#000000 |
6152 |
67591 |
Firm |
2 |
#000000 |
6150 |
67592 |
Soft |
0 |
#000000 |
6151 |
67593 |
Medium |
1 |
#000000 |
6152 |
67594 |
Firm |
2 |
#000000 |
6150 |
67595 |
Soft |
0 |
#000000 |
6151 |
67596 |
Medium |
1 |
#000000 |
6152 |
67597 |
Firm |
2 |
#000000 |
6150 |
67598 |
Soft |
0 |
#000000 |
6151 |
67599 |
Medium |
1 |
#000000 |
6152 |
67600 |
Firm |
2 |
#000000 |
6150 |
67601 |
Soft |
0 |
#000000 |
6151 |
67602 |
Medium |
1 |
#000000 |
6152 |
67603 |
Firm |
2 |
#000000 |
6150 |
67604 |
Soft |
0 |
#000000 |
6151 |
67605 |
Medium |
1 |
#000000 |
6152 |
67606 |
Firm |
2 |
#000000 |
6150 |
67607 |
Soft |
0 |
#000000 |
6151 |
67608 |
Medium |
1 |
#000000 |
6152 |
67609 |
Firm |
2 |
#000000 |
6150 |
67610 |
Soft |
0 |
#000000 |
6151 |
67611 |
Medium |
1 |
#000000 |
6152 |
67612 |
Firm |
2 |
#000000 |
6150 |
67613 |
Soft |
0 |
#000000 |
6151 |
67614 |
Medium |
1 |
#000000 |
6152 |
67615 |
Firm |
2 |
#000000 |
6150 |
67616 |
Soft |
0 |
#000000 |
6151 |
67617 |
Medium |
1 |
#000000 |
6152 |
67618 |
Firm |
2 |
#000000 |
6150 |
67619 |
Soft |
0 |
#000000 |
6151 |
67620 |
Medium |
1 |
#000000 |
6152 |
67621 |
Firm |
2 |
#000000 |
6150 |
67622 |
Soft |
0 |
#000000 |
6151 |
67623 |
Medium |
1 |
#000000 |
6152 |
67624 |
Firm |
2 |
#000000 |
6150 |
67625 |
Soft |
0 |
#000000 |
6151 |
67626 |
Medium |
1 |
#000000 |
6152 |
67627 |
Firm |
2 |
#000000 |
6150 |
67628 |
Soft |
0 |
#000000 |
6151 |
67629 |
Medium |
1 |
#000000 |
6152 |
67630 |
Firm |
2 |
#000000 |
6150 |
67631 |
Soft |
0 |
#000000 |
6151 |
67632 |
Medium |
1 |
#000000 |
6152 |
67633 |
Firm |
2 |
#000000 |
6150 |
67634 |
Soft |
0 |
#000000 |
6151 |
67635 |
Medium |
1 |
#000000 |
6152 |
67636 |
Firm |
2 |
#000000 |
6150 |
67637 |
Soft |
0 |
#000000 |
6151 |
67638 |
Medium |
1 |
#000000 |
6152 |
67639 |
Firm |
2 |
#000000 |
6150 |
67640 |
Soft |
0 |
#000000 |
6151 |
67641 |
Medium |
1 |
#000000 |
6152 |
67642 |
Firm |
2 |
#000000 |
6150 |
67643 |
Soft |
0 |
#000000 |
6151 |
67644 |
Medium |
1 |
#000000 |
6152 |
67645 |
Firm |
2 |
#000000 |
6150 |
67646 |
Soft |
0 |
#000000 |
6151 |
67647 |
Medium |
1 |
#000000 |
6152 |
67648 |
Firm |
2 |
#000000 |
6150 |
67649 |
Soft |
0 |
#000000 |
6151 |
67650 |
Medium |
1 |
#000000 |
6152 |
67651 |
Firm |
2 |
#000000 |
6150 |
67652 |
Soft |
0 |
#000000 |
6151 |
67653 |
Medium |
1 |
#000000 |
6152 |
67654 |
Firm |
2 |
#000000 |
6150 |
67655 |
Soft |
0 |
#000000 |
6151 |
67656 |
Medium |
1 |
#000000 |
6152 |
67657 |
Firm |
2 |
#000000 |
6150 |
67658 |
Soft |
0 |
#000000 |
6151 |
67659 |
Medium |
1 |
#000000 |
6152 |
67660 |
Firm |
2 |
#000000 |
6150 |
67661 |
Soft |
0 |
#000000 |
6151 |
67662 |
Medium |
1 |
#000000 |
6152 |
67663 |
Firm |
2 |
#000000 |
6150 |
67664 |
Soft |
0 |
#000000 |
6151 |
67665 |
Medium |
1 |
#000000 |
6152 |
67666 |
Firm |
2 |
#000000 |
6150 |
67667 |
Soft |
0 |
#000000 |
6151 |
67668 |
Medium |
1 |
#000000 |
6152 |
67669 |
Firm |
2 |
#000000 |
6150 |
67670 |
Soft |
0 |
#000000 |
6151 |
67671 |
Medium |
1 |
#000000 |
6152 |
67672 |
Firm |
2 |
#000000 |
6150 |
67673 |
Soft |
0 |
#000000 |
6151 |
67674 |
Medium |
1 |
#000000 |
6152 |
67675 |
Firm |
2 |
#000000 |
6150 |
67676 |
Soft |
0 |
#000000 |
6151 |
67677 |
Medium |
1 |
#000000 |
6152 |
67678 |
Firm |
2 |
#000000 |
6150 |
67679 |
Soft |
0 |
#000000 |
6151 |
67680 |
Medium |
1 |
#000000 |
6152 |
67681 |
Firm |
2 |
#000000 |
6150 |
67682 |
Soft |
0 |
#000000 |
6151 |
67683 |
Medium |
1 |
#000000 |
6152 |
67684 |
Firm |
2 |
#000000 |
6150 |
67685 |
Soft |
0 |
#000000 |
6151 |
67686 |
Medium |
1 |
#000000 |
6152 |
67687 |
Firm |
2 |
#000000 |
6150 |
67688 |
Soft |
0 |
#000000 |
6151 |
67689 |
Medium |
1 |
#000000 |
6152 |
67690 |
Firm |
2 |
#000000 |
6150 |
67691 |
Soft |
0 |
#000000 |
6151 |
67692 |
Medium |
1 |
#000000 |
6152 |
67693 |
Firm |
2 |
#000000 |
6150 |
67694 |
Soft |
0 |
#000000 |
6151 |
67695 |
Medium |
1 |
#000000 |
6152 |
67696 |
Firm |
2 |
#000000 |
6150 |
67697 |
Soft |
0 |
#000000 |
6151 |
67698 |
Medium |
1 |
#000000 |
6152 |
67699 |
Firm |
2 |
#000000 |
6150 |
67700 |
Soft |
0 |
#000000 |
6151 |
67701 |
Medium |
1 |
#000000 |
6152 |
67702 |
Firm |
2 |
#000000 |
6150 |
67703 |
Soft |
0 |
#000000 |
6151 |
67704 |
Medium |
1 |
#000000 |
6152 |
67705 |
Firm |
2 |
#000000 |
6150 |
67706 |
Soft |
0 |
#000000 |
6151 |
67707 |
Medium |
1 |
#000000 |
6152 |
67708 |
Firm |
2 |
#000000 |
6150 |
67709 |
Soft |
0 |
#000000 |
6151 |
67710 |
Medium |
1 |
#000000 |
6152 |
67711 |
Firm |
2 |
#000000 |
6150 |
67712 |
Soft |
0 |
#000000 |
6151 |
67713 |
Medium |
1 |
#000000 |
6152 |
67714 |
Firm |
2 |
#000000 |
6150 |
67715 |
Soft |
0 |
#000000 |
6151 |
67716 |
Medium |
1 |
#000000 |
6152 |
67717 |
Firm |
2 |
#000000 |
6150 |
67718 |
Soft |
0 |
#000000 |
6151 |
67719 |
Medium |
1 |
#000000 |
6152 |
67720 |
Firm |
2 |
#000000 |
6150 |
67721 |
Soft |
0 |
#000000 |
6151 |
67722 |
Medium |
1 |
#000000 |
6152 |
67723 |
Firm |
2 |
#000000 |
6150 |
67724 |
Soft |
0 |
#000000 |
6151 |
67725 |
Medium |
1 |
#000000 |
6152 |
67726 |
Firm |
2 |
#000000 |
6150 |
67727 |
Soft |
0 |
#000000 |
6151 |
67728 |
Medium |
1 |
#000000 |
6152 |
67729 |
Firm |
2 |
#000000 |
6150 |
67730 |
Soft |
0 |
#000000 |
6151 |
67731 |
Medium |
1 |
#000000 |
6152 |
67732 |
Firm |
2 |
#000000 |
6150 |
67733 |
Soft |
0 |
#000000 |
6151 |
67734 |
Medium |
1 |
#000000 |
6152 |
67735 |
Firm |
2 |
#000000 |
6150 |
67736 |
Soft |
0 |
#000000 |
6151 |
67737 |
Medium |
1 |
#000000 |
6152 |
67738 |
Firm |
2 |
#000000 |
6150 |
67739 |
Soft |
0 |
#000000 |
6151 |
67740 |
Medium |
1 |
#000000 |
6152 |
67741 |
Firm |
2 |
#000000 |
6150 |
67742 |
Soft |
0 |
#000000 |
6151 |
67743 |
Medium |
1 |
#000000 |
6152 |
67744 |
Firm |
2 |
#000000 |