Query time 0.00108
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "27.30"
},
"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": 39,
"rows_produced_per_join": 39,
"filtered": "100.00",
"cost_info": {
"read_cost": "9.75",
"eval_cost": "3.90",
"prefix_cost": "13.65",
"data_read_per_join": "1K"
},
"used_columns": [
"variant_id",
"option_id",
"position",
"modifier",
"modifier_type",
"weight_modifier",
"weight_modifier_type",
"status"
]
}
},
{
"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": 39,
"filtered": "100.00",
"cost_info": {
"read_cost": "9.75",
"eval_cost": "3.90",
"prefix_cost": "27.30",
"data_read_per_join": "29K"
},
"used_columns": [
"variant_id",
"lang_code",
"variant_name"
]
}
}
]
}
}
}
Result
variant_id |
position |
modifier |
modifier_type |
weight_modifier |
weight_modifier_type |
variant_name |
10287 |
1 |
0.000 |
A |
0.000 |
A |
None |
10288 |
2 |
10.000 |
A |
0.000 |
A |
Burgundy - Pearlescent |
10289 |
3 |
10.000 |
A |
0.000 |
A |
French Rose – Pearlescent |
10290 |
4 |
10.000 |
A |
0.000 |
A |
Tiger Orange – Pearlescent |
10291 |
5 |
10.000 |
A |
0.000 |
A |
Deep Pink – Pearlescent |
10292 |
6 |
10.000 |
A |
0.000 |
A |
Creamy Pink – Pearlescent |
10293 |
7 |
10.000 |
A |
0.000 |
A |
Blue Iris – Pearlescent |
10294 |
8 |
10.000 |
A |
0.000 |
A |
Blue Du France – Pearlescent |
10295 |
9 |
10.000 |
A |
0.000 |
A |
Turquoise – Pearlescent |
10296 |
10 |
10.000 |
A |
0.000 |
A |
Pearl White – Pearlescent |
10297 |
11 |
10.000 |
A |
0.000 |
A |
Copper – Pearlescent |
10298 |
12 |
10.000 |
A |
0.000 |
A |
Aureolin Yellow – Pearlescent |
10299 |
13 |
10.000 |
A |
0.000 |
A |
Purple Heart – Pearlescent |
10300 |
14 |
10.000 |
A |
0.000 |
A |
Robin Egg – Pearlescent |
10301 |
15 |
10.000 |
A |
0.000 |
A |
Fandango Pink – Pearlescent |
10302 |
16 |
10.000 |
A |
0.000 |
A |
Scarlet – Pearlescent |
10303 |
17 |
10.000 |
A |
0.000 |
A |
Gold – Pearlescent |
10304 |
18 |
10.000 |
A |
0.000 |
A |
Lilac – Pearlescent |
10305 |
19 |
10.000 |
A |
0.000 |
A |
Maya Blue – Pearlescent |
10306 |
20 |
10.000 |
A |
0.000 |
A |
Electric Blue – Pearlescent |
10307 |
21 |
10.000 |
A |
0.000 |
A |
Persian Green – Pearlescent |
10308 |
22 |
10.000 |
A |
0.000 |
A |
Parakeet Green – Pearlescent |
10309 |
23 |
10.000 |
A |
0.000 |
A |
Blue Heart – Pearlescent |
10310 |
24 |
10.000 |
A |
0.000 |
A |
Borealis Pink – Pearlescent |
10311 |
25 |
10.000 |
A |
0.000 |
A |
Celeste Blue – Pearlescent |
10312 |
26 |
10.000 |
A |
0.000 |
A |
Double Peony – Pearlescent |
10313 |
27 |
10.000 |
A |
0.000 |
A |
Egyptian Green – Pearlescent |
10314 |
28 |
10.000 |
A |
0.000 |
A |
Graphite Black – Pearlescent |
10315 |
29 |
10.000 |
A |
0.000 |
A |
Snowflake White – Pearlescent |
10316 |
30 |
10.000 |
A |
0.000 |
A |
Purple Flame – Pearlescent |
10317 |
31 |
10.000 |
A |
0.000 |
A |
Coral Rose – Pearlescent |
10318 |
32 |
10.000 |
A |
0.000 |
A |
Olive Gold – Pearlescent |
10319 |
33 |
10.000 |
A |
0.000 |
A |
Canary Yellow – Pearlescent |
10320 |
34 |
10.000 |
A |
0.000 |
A |
Turmeric Gold – Pearlescent |
10321 |
35 |
10.000 |
A |
0.000 |
A |
Silver Ash – Pearlescent |
10322 |
36 |
10.000 |
A |
0.000 |
A |
UV Orange |
10323 |
37 |
10.000 |
A |
0.000 |
A |
UV Lemon |
10324 |
38 |
10.000 |
A |
0.000 |
A |
UV Pink |
10325 |
39 |
10.000 |
A |
0.000 |
A |
UV Green |
10326 |
40 |
10.000 |
A |
0.000 |
A |
UV Blue |
10327 |
41 |
10.000 |
A |
0.000 |
A |
UV Purple |
10328 |
42 |
10.000 |
A |
0.000 |
A |
UV Lime |
10329 |
43 |
10.000 |
A |
0.000 |
A |
UV Red |
10330 |
44 |
10.000 |
A |
0.000 |
A |
Flat Black |
10331 |
45 |
10.000 |
A |
0.000 |
A |
Flat Red |
10332 |
46 |
10.000 |
A |
0.000 |
A |
Flat White |
10333 |
47 |
10.000 |
A |
0.000 |
A |
Flat Purple |
10334 |
48 |
10.000 |
A |
0.000 |
A |
Flat Blue |
10335 |
49 |
10.000 |
A |
0.000 |
A |
Flat Green |
10336 |
50 |
10.000 |
A |
0.000 |
A |
Flat Cyan |
10337 |
51 |
10.000 |
A |
0.000 |
A |
Flat Yellow |