Query time 0.00083
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "18.90"
},
"ordering_operation": {
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "a",
"access_type": "ref",
"possible_keys": [
"status",
"option_id",
"option_id_2"
],
"key": "option_id",
"used_key_parts": [
"option_id",
"status"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 27,
"rows_produced_per_join": 27,
"filtered": "100.00",
"cost_info": {
"read_cost": "6.75",
"eval_cost": "2.70",
"prefix_cost": "9.45",
"data_read_per_join": "1K"
},
"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": 27,
"filtered": "100.00",
"cost_info": {
"read_cost": "6.75",
"eval_cost": "2.70",
"prefix_cost": "18.90",
"data_read_per_join": "20K"
},
"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 |
18mm/ 0.71 Inch |
20402 |
1147 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
20mm/ 0.79 Inch |
20403 |
1147 |
2 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
22mm/ 0.87 Inch |
20404 |
1147 |
3 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
25 mm/ 0.98 inch |
20405 |
1147 |
4 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
28 mm/ 1.10 inch |
20406 |
1147 |
5 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
30 mm/ 1.18 inch |
20407 |
1147 |
6 |
10.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
34 mm/ 1.32 inch |
20408 |
1147 |
7 |
20.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
36 mm/ 1.42 inch |
20409 |
1147 |
8 |
30.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
38 mm/ 1.50 inch |
20410 |
1147 |
9 |
40.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
40 mm/ 1.57 inch |
20411 |
1147 |
10 |
50.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
44 mm/ 1.73 inch |
20412 |
1147 |
11 |
60.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
46 mm/ 1.81 inch |
20413 |
1147 |
12 |
70.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
48 mm/ 1.89 inch |
20414 |
1147 |
13 |
80.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
50 mm/ 1.97 inch |
20415 |
1147 |
14 |
90.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
52 mm/ 2.04 inch |
20416 |
1147 |
15 |
100.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
54 mm/ 2.13 inch |
20417 |
1147 |
16 |
110.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
56mm / 2.20 mm |
20418 |
1147 |
17 |
120.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
58 mm/ 2.28 inch |
20419 |
1147 |
18 |
140.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
60mm/ 2.36 inch |
20420 |
1147 |
19 |
160.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|