Query time 0.00106
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "79.96"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "44.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": 44,
"rows_produced_per_join": 44,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`a`.`option_id` in (199,86,117)) and (`cscartdb`.`a`.`status` = 'A'))",
"cost_info": {
"read_cost": "16.16",
"eval_cost": "4.40",
"prefix_cost": "20.56",
"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": 44,
"filtered": "100.00",
"cost_info": {
"read_cost": "11.00",
"eval_cost": "4.40",
"prefix_cost": "35.96",
"data_read_per_join": "33K"
},
"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 |
No |
3299 |
117 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Small |
7451 |
199 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Medium |
7452 |
199 |
0 |
25.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Large |
7453 |
199 |
0 |
56.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
XL |
7454 |
199 |
0 |
101.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Small and Medium Set |
7455 |
199 |
0 |
46.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Small, Medium, and Large Set |
7456 |
199 |
0 |
110.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
All Four Sizes! |
7457 |
199 |
0 |
173.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kreature Orange |
3327 |
117 |
1 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Super soft |
7624 |
86 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Brilliant Yellow |
3328 |
117 |
2 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Classic (Recommended) |
7625 |
86 |
2 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Sparkle White |
3341 |
117 |
3 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Extra Firm |
7626 |
86 |
3 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Blood Red |
3340 |
117 |
4 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Burnt Orange |
3339 |
117 |
5 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kreature Purple |
3338 |
117 |
6 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Deep Violet |
3337 |
117 |
7 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Bubble Gum Pink |
3336 |
117 |
8 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Dark Rose |
3323 |
117 |
9 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Metallic Silver |
3334 |
117 |
10 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Chartreuse |
3333 |
117 |
11 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Swamp Green |
3332 |
117 |
12 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Shimmer Gold |
3331 |
117 |
13 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Bright Cherry |
3330 |
117 |
14 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Dark Brown |
3329 |
117 |
15 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kreature Green |
3325 |
117 |
16 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Sparkle Bronze |
3324 |
117 |
17 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Deep Blue-Green |
3326 |
117 |
18 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Ocean Blue |
3335 |
117 |
19 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Kreature Blue |
3342 |
117 |
20 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Inky Grey |
3343 |
117 |
21 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Jade |
3344 |
117 |
22 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Gray Green |
3345 |
117 |
23 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Olive |
3312 |
117 |
24 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Rose Gold |
3301 |
117 |
25 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Coal Black |
3302 |
117 |
26 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Rust |
3303 |
117 |
27 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Copper |
3304 |
117 |
28 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Ukon Brown |
3305 |
117 |
29 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Valentine |
3306 |
117 |
30 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Fire Red |
3307 |
117 |
31 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Chocolate |
3308 |
117 |
32 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Ruddy Gold |
3309 |
117 |
33 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Jet Black |
3310 |
117 |
34 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Solid White |
3311 |
117 |
35 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Fluorescent Blue |
3300 |
117 |
36 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Fluorescent Orange |
3313 |
117 |
37 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Fluorescent Purple |
3314 |
117 |
38 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Fluorescent Green |
3315 |
117 |
39 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Red-Orange Glow |
3316 |
117 |
40 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
White-Green Glow |
3317 |
117 |
41 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Blue Glow |
3318 |
117 |
42 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Golden Copper Shift |
3319 |
117 |
43 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Rusty Pink Shift |
3320 |
117 |
44 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Blue Purple Shift |
3321 |
117 |
45 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Blue Green Shift |
3322 |
117 |
46 |
7.990 |
A |
0.000 |
A |
0.000 |
A |
A |
|