Query time 0.00133
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "59.86"
},
"nested_loop": [
{
"table": {
"table_name": "pfv",
"access_type": "range",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"rows_examined_per_scan": 57,
"rows_produced_per_join": 57,
"filtered": "100.00",
"index_condition": "(`cscartdb`.`pfv`.`variant_id` in (1137,1134,1138,1136,1146,1148,1147,1145,1173,1174,1153,1156,1266,1269,1268,1267,1264,1265,1255,1253,1259,1256,4698,4697,4696,4695,4694,4693,4692,4707,4706,4705,4704,4703,4702,4701,4700,4699,4710,4709,4708,4711,4712,5884,5867,5868,5885,5886,5887,5888,5889,5985,5986,5987,5988,5989,5990))",
"cost_info": {
"read_cost": "34.21",
"eval_cost": "5.70",
"prefix_cost": "39.91",
"data_read_per_join": "65K"
},
"used_columns": [
"variant_id",
"position"
]
}
},
{
"table": {
"table_name": "pfvd",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscartdb.pfv.variant_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 57,
"filtered": "100.00",
"cost_info": {
"read_cost": "14.25",
"eval_cost": "5.70",
"prefix_cost": "59.86",
"data_read_per_join": "172K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
]
}
}
]
}
}
Result
variant_id |
position |
variant |
1134 |
0 |
Radical 0.25mm |
1136 |
1 |
Supatex 0.4mm |
1137 |
0 |
Powdered |
1138 |
1 |
Chlorinated |
1145 |
1 |
Small: 27" - 36" waist |
1146 |
2 |
Medium: 34" - 42" waist |
1147 |
3 |
Large: 40" - 48" waist |
1148 |
4 |
Extra Large: 46" - 54" waist |
1153 |
1 |
Small |
1156 |
2 |
Large |
1173 |
1 |
Small: 28" - 38" |
1174 |
2 |
Large: 39" - 50" |
1253 |
1 |
Small |
1255 |
2 |
Large |
1256 |
0 |
S |
1259 |
3 |
XL |
1264 |
1 |
S |
1265 |
2 |
M |
1266 |
0 |
L |
1267 |
3 |
XL |
1268 |
4 |
2XL |
1269 |
5 |
3XL |
4692 |
0 |
Strap on harness/XS |
4693 |
1 |
Strap on harness/S |
4694 |
2 |
Strap on harness/M |
4695 |
3 |
Strap on harness/L |
4696 |
4 |
Strap on harness/XL |
4697 |
5 |
Strap on harness/2XL |
4698 |
6 |
Strap on harness/3XL |
4699 |
7 |
Chest harness/XS |
4700 |
8 |
Chest harness/S |
4701 |
9 |
Chest harness/M |
4702 |
10 |
Chest harness/L |
4703 |
11 |
Chest harness/XL |
4704 |
12 |
Chest harness/2XL |
4705 |
13 |
Chest harness/3XL |
4706 |
14 |
Full set/XS |
4707 |
15 |
Full set/S |
4708 |
16 |
Full set/M |
4709 |
17 |
Full set/L |
4710 |
18 |
Full set/XL |
4711 |
19 |
Full set/2XL |
4712 |
20 |
Full set/3XL |
5867 |
0 |
Silver |
5868 |
1 |
Brass |
5884 |
0 |
Red |
5885 |
1 |
Black |
5886 |
2 |
Purple |
5887 |
3 |
Pink |
5888 |
4 |
White |
5889 |
5 |
Blue |
5985 |
0 |
xs |
5986 |
1 |
s |
5987 |
2 |
m |
5988 |
3 |
l |
5989 |
4 |
xl |
5990 |
5 |
xxl |