Query time 0.00131
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "94.61"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "52.00"
},
"nested_loop": [
{
"table": {
"table_name": "a",
"access_type": "range",
"possible_keys": [
"status",
"option_id",
"option_id_2"
],
"key": "option_id",
"used_key_parts": [
"option_id",
"status"
],
"key_length": "6",
"rows_examined_per_scan": 52,
"rows_produced_per_join": 52,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`a`.`option_id` in (590,591,592,593)) and (`cscartdb`.`a`.`status` = 'A'))",
"cost_info": {
"read_cost": "19.21",
"eval_cost": "5.20",
"prefix_cost": "24.41",
"data_read_per_join": "2K"
},
"used_columns": [
"variant_id",
"option_id",
"position",
"modifier",
"modifier_type",
"weight_modifier",
"weight_modifier_type",
"point_modifier",
"point_modifier_type",
"status",
"note_required"
]
}
},
{
"table": {
"table_name": "b",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscartdb.a.variant_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 52,
"filtered": "100.00",
"cost_info": {
"read_cost": "13.00",
"eval_cost": "5.20",
"prefix_cost": "42.61",
"data_read_per_join": "39K"
},
"used_columns": [
"variant_id",
"lang_code",
"variant_name"
]
}
}
]
}
}
}
Result
variant_name |
variant_id |
option_id |
position |
modifier |
modifier_type |
weight_modifier |
weight_modifier_type |
point_modifier |
point_modifier_type |
status |
note_required |
silver |
13773 |
590 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Silver |
13779 |
591 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Silver |
13811 |
592 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
28.5 inches |
13842 |
593 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Gold |
13774 |
590 |
2 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Gold |
13812 |
592 |
2 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
25 inches |
13843 |
593 |
2 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Silver |
13775 |
590 |
3 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Red |
13781 |
591 |
3 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Rainbow |
13813 |
592 |
3 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Rosegold |
13776 |
590 |
4 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Black |
13782 |
591 |
4 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Rosegold |
13814 |
592 |
4 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Gunmetal |
13777 |
590 |
5 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Purple |
13783 |
591 |
5 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Black |
13815 |
592 |
5 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Rainbow |
13778 |
590 |
6 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Red |
13784 |
591 |
6 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Red |
13816 |
592 |
6 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Purple |
13817 |
592 |
7 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Green |
13786 |
591 |
8 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Hot Pink |
13818 |
592 |
8 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Hot Pink |
13787 |
591 |
9 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Sky Blue |
13819 |
592 |
9 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Gold |
13788 |
591 |
10 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Green |
13820 |
592 |
10 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Rosegold |
13789 |
591 |
11 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Black |
13821 |
592 |
11 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Heart Sky Blue |
13790 |
591 |
12 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Silver |
13822 |
592 |
12 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Black |
13791 |
591 |
13 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Gold |
13823 |
592 |
13 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Rosegold |
13792 |
591 |
14 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Rosegold |
13824 |
592 |
14 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Light Pink |
13825 |
592 |
15 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Rainbow |
13794 |
591 |
16 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Hot Pink |
13826 |
592 |
16 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Sky Blue |
13795 |
591 |
17 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Green |
13827 |
592 |
17 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Light Pink |
13796 |
591 |
18 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Sky Blue |
13828 |
592 |
18 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Purple |
13797 |
591 |
19 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Red |
13829 |
592 |
19 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Rosegold |
13798 |
591 |
20 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Gold |
13830 |
592 |
20 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Gold |
13799 |
591 |
21 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Rainbow |
13831 |
592 |
21 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Silver |
13800 |
591 |
22 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
O-Ring Large Silver |
13832 |
592 |
22 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Red |
13801 |
591 |
23 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Hot Pink |
13802 |
591 |
24 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
O-Ring Medium Silver |
13834 |
592 |
24 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kitty Green |
13803 |
591 |
25 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
O-Ring Large Rainbow |
13835 |
592 |
25 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
O ring small Silver |
13804 |
591 |
26 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
O-Ring Large Gunmetal |
13836 |
592 |
26 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
O-Ring Silver Large |
13805 |
591 |
27 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Dragon Head |
13837 |
592 |
27 |
10.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
O-Ring Silver Medium |
13806 |
591 |
28 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Snake Charm |
13838 |
592 |
28 |
10.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
O-Ring Large Gunmetal |
13807 |
591 |
29 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Pentagram Silver |
13839 |
592 |
29 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
O-Ring Large Rainbow |
13808 |
591 |
30 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Pentagram Black |
13840 |
592 |
30 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
O-Ring Large Gold |
13809 |
591 |
31 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Pentagram Rainbow |
13841 |
592 |
31 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
O-Ring Large Rosegold |
13810 |
591 |
32 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Pentagram Hot Pink |
13844 |
592 |
32 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|