Query time 0.00145
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "83.24"
},
"nested_loop": [
{
"table": {
"table_name": "pfvd",
"access_type": "range",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"rows_examined_per_scan": 32,
"rows_produced_per_join": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "38.45",
"eval_cost": "6.40",
"prefix_cost": "44.85",
"data_read_per_join": "144K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
],
"attached_condition": "((`webmarco`.`pfvd`.`variant_id` in (64682,64581,64539,64557,64558,64575,64475,67794,65265,64559,64560,64537,64544,64692,64677,64561,64562,64563,60615,64062,64477,64732,64753,66261,67568,64236,66121,64545,64691,67603,67642,67643)) and (`webmarco`.`pfvd`.`lang_code` = 'en'))"
}
},
{
"table": {
"table_name": "pfv",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"ref": [
"webmarco.pfvd.variant_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "32.00",
"eval_cost": "6.40",
"prefix_cost": "83.25",
"data_read_per_join": "36K"
},
"used_columns": [
"variant_id",
"position"
]
}
}
]
}
}
Result
variant_id |
position |
variant |
60615 |
0 |
Blue |
64062 |
0 |
Black |
64236 |
0 |
Pink |
64475 |
0 |
White |
64477 |
0 |
Brown |
64537 |
0 |
Dark Navy-Blue |
64539 |
0 |
Red |
64544 |
0 |
Grey |
64545 |
0 |
Green |
64557 |
10 |
62cm / 3 – 6 (Months) |
64558 |
20 |
68cm / 6 – 9 (Months) |
64559 |
30 |
74cm / 9 – 12 (Months) |
64560 |
40 |
80cm / 12-18 (Months) |
64561 |
50 |
86cm / 18-24 (Months) – 1/2 (Years) |
64562 |
60 |
92cm / 24-36 (Months) – 2/3 (Years) |
64563 |
70 |
98cm / 36-48 (Months) – 3/4 (Years) |
64575 |
0 |
Yellow |
64581 |
0 |
56cm / 0-3 (Months) |
64677 |
0 |
Orange |
64682 |
0 |
Blue Baby |
64691 |
0 |
Purple |
64692 |
0 |
Light Blue |
64732 |
0 |
Cream |
64753 |
0 |
Beige |
65265 |
0 |
Baby Pink |
66121 |
0 |
Salmon |
66261 |
0 |
Lacivert |
67568 |
0 |
White |
67603 |
0 |
6- 12 (Months) |
67642 |
0 |
6-12 Months |
67643 |
0 |
12-18 Months |
67794 |
0 |
Blue and Grey |