Query time 0.00133
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "185.11"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "102.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": 102,
"rows_produced_per_join": 102,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`a`.`option_id` in (861,857,862,863,865,860)) and (`cscartdb`.`a`.`status` = 'A'))",
"cost_info": {
"read_cost": "37.21",
"eval_cost": "10.20",
"prefix_cost": "47.41",
"data_read_per_join": "4K"
},
"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": 102,
"filtered": "100.00",
"cost_info": {
"read_cost": "25.50",
"eval_cost": "10.20",
"prefix_cost": "83.11",
"data_read_per_join": "78K"
},
"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 |
Flesh-colored beige |
16463 |
857 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
None |
16617 |
863 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
None |
16657 |
862 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
XS |
16701 |
860 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Black |
16708 |
865 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
One-colored |
17172 |
861 |
1 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Flesh-colored pink |
16464 |
857 |
2 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Flesh-colored beige |
16618 |
863 |
2 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Flesh-colored beige |
16658 |
862 |
2 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
S |
16702 |
860 |
2 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Rainbow Braid |
16709 |
865 |
2 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Double-colored |
17173 |
861 |
2 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Fleshy brown dark |
16465 |
857 |
3 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Flesh-colored pink |
16619 |
863 |
3 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Flesh-colored pink |
16659 |
862 |
3 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
M |
16703 |
860 |
3 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Magic World |
16710 |
865 |
3 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Tri-colored |
17174 |
861 |
3 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Fleshy brown light |
16466 |
857 |
4 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Fleshy brown dark |
16620 |
863 |
4 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Fleshy brown dark |
16660 |
862 |
4 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
L |
16704 |
860 |
4 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Skulls & Roses |
16711 |
865 |
4 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Light Blue |
16467 |
857 |
5 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Fleshy brown light |
16621 |
863 |
5 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Fleshy brown light |
16661 |
862 |
5 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
XL |
16705 |
860 |
5 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Light Rose |
16468 |
857 |
6 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Light Blue |
16622 |
863 |
6 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Light Blue |
16662 |
862 |
6 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
2XL |
16706 |
860 |
6 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Black |
16469 |
857 |
7 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Light Rose |
16623 |
863 |
7 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Light Rose |
16663 |
862 |
7 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
3XL |
16707 |
860 |
7 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Blue |
16470 |
857 |
8 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Lavender |
16624 |
863 |
8 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Lavender |
16664 |
862 |
8 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Brown |
16471 |
857 |
9 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Black |
16625 |
863 |
9 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Black |
16665 |
862 |
9 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Clear |
16472 |
857 |
10 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Brown |
16626 |
863 |
10 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
BLue |
16666 |
862 |
10 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Gray |
16473 |
857 |
11 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Clear |
16627 |
863 |
11 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Brown |
16667 |
862 |
11 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Green |
16474 |
857 |
12 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Blue |
16628 |
863 |
12 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Clear |
16668 |
862 |
12 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Orange |
16475 |
857 |
13 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Gray |
16629 |
863 |
13 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Gray |
16669 |
862 |
13 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Pink |
16476 |
857 |
14 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Green |
16630 |
863 |
14 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Green |
16670 |
862 |
14 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Purple |
16477 |
857 |
15 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Orange |
16631 |
863 |
15 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Orange |
16671 |
862 |
15 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Yellow |
16478 |
857 |
16 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Pink |
16632 |
863 |
16 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Pink |
16672 |
862 |
16 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Red |
16479 |
857 |
17 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Purple |
16633 |
863 |
17 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Purple |
16673 |
862 |
17 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
White |
16480 |
857 |
18 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Red |
16634 |
863 |
18 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Red |
16674 |
862 |
18 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Lavender |
16481 |
857 |
19 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
White |
16635 |
863 |
19 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
White |
16675 |
862 |
19 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Yellow |
16636 |
863 |
20 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|
Yellow |
16676 |
862 |
20 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
A |
|