Query time 0.00157
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "309.61"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "q_product_feature_variants",
"access_type": "range",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"rows_examined_per_scan": 86,
"rows_produced_per_join": 86,
"filtered": "100.00",
"index_condition": "(`portal`.`q_product_feature_variants`.`variant_id` in (35,36,37,39,41,42,43,48,132,133,134,135,136,137,138,139,140,143,148,154,157,160,161,183,193,194,198,210,256,272,273,274,275,276,277,278,279,288,289,5776,5777,5778,5862,5932,5994,6047,6141,6173,6205,6213,6311,6448,6632,6760,7594,7604,7605,7607,7613,7987,8152,8478,8486,8496,8532,8533,8534,8535,8536,8537,8538,8539,8540,8555,8646,8748,8949,9222,9365,9442,9632,9697,9712,9713,9714,9716))",
"cost_info": {
"read_cost": "189.21",
"eval_cost": "17.20",
"prefix_cost": "206.41",
"data_read_per_join": "98K"
},
"used_columns": [
"variant_id",
"color",
"position"
]
}
},
{
"table": {
"table_name": "q_product_feature_variant_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"ref": [
"portal.q_product_feature_variants.variant_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 86,
"filtered": "100.00",
"cost_info": {
"read_cost": "86.00",
"eval_cost": "17.20",
"prefix_cost": "309.61",
"data_read_per_join": "260K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
]
}
}
]
}
}
}
Result
variant_id |
position |
color |
variant |
6448 |
0 |
|
blue |
9222 |
0 |
|
Color Red |
7987 |
0 |
|
Cool Red |
8535 |
0 |
|
Dark Auburn |
7613 |
0 |
|
Generic |
8533 |
0 |
|
Light Natural Blonde |
8496 |
0 |
|
Medium Brown |
8555 |
0 |
|
Smart Innovation |
8748 |
0 |
|
White Grey |
154 |
0 |
|
Adrien Gagnon |
288 |
0 |
|
Aliver |
8486 |
0 |
|
Ash Blonde |
8532 |
0 |
|
Auburn Brown |
9697 |
0 |
|
b |
140 |
0 |
|
Beige |
5778 |
0 |
|
BeLUX |
36 |
0 |
|
Black |
8646 |
0 |
|
Blue |
8152 |
0 |
|
Blue & Red |
39 |
0 |
|
Brown |
194 |
0 |
|
Burt's Bees |
9365 |
0 |
|
Celebrat |
8537 |
0 |
|
Chestnut Brown |
9716 |
0 |
|
Colgate |
135 |
0 |
|
Crest |
6047 |
0 |
|
Dark Brown |
8536 |
0 |
|
Dark Mahogany Brown |
133 |
0 |
|
Dove |
7607 |
0 |
|
DOWIN |
6141 |
0 |
|
Durex |
278 |
0 |
|
Earldom |
183 |
0 |
|
Generic |
134 |
0 |
|
Gillette |
157 |
0 |
|
Gold |
279 |
0 |
|
Golf Shuttle |
9714 |
0 |
|
gree |
139 |
0 |
|
Green |
9632 |
0 |
|
grey |
5994 |
0 |
|
HBQ |
5777 |
0 |
|
iPega |
274 |
0 |
|
Johnson's |
272 |
0 |
|
Klorane |
6632 |
0 |
|
L'Oreal |
6760 |
0 |
|
L'Oreal Paris |
8539 |
0 |
|
Light Ash Blonde |
148 |
0 |
|
Light Blue |
8478 |
0 |
|
Light Brown |
132 |
0 |
|
L`oreal |
8538 |
0 |
|
Medium Blonde |
48 |
0 |
|
multicolor |
276 |
0 |
|
Nair |
138 |
0 |
|
Nivea |
9713 |
0 |
|
off White |
160 |
0 |
|
OGX |
136 |
0 |
|
Olay |
273 |
0 |
|
Oral-B |
43 |
0 |
|
Orange |
42 |
0 |
|
Peach |
41 |
0 |
|
Pink |
198 |
0 |
|
Polident |
5932 |
0 |
|
Polysporin |
7604 |
0 |
|
Pond's |
9442 |
0 |
|
Ponds |
143 |
0 |
|
Purple |
37 |
0 |
|
Red |
137 |
0 |
|
Revlon |
7605 |
0 |
|
Saeed Ghani |
6311 |
0 |
|
Sensodyne |
256 |
0 |
|
silver |
6213 |
0 |
|
Silver & Black |
6173 |
0 |
|
Smart Innovation |
8534 |
0 |
|
Soft Black |
8540 |
0 |
|
Soft Sable |
289 |
0 |
|
Tampax |
161 |
0 |
|
Tanbaby |
210 |
0 |
|
The Body Shop |
275 |
0 |
|
Trojan |
193 |
0 |
|
Trojan Magnum |
5862 |
0 |
|
Unbranded |
277 |
0 |
|
Veet |
9712 |
0 |
|
Vital |
8949 |
0 |
|
Vital Ginger |
35 |
0 |
|
white |
7594 |
0 |
|
White & Black |
6205 |
0 |
|
White & Blue |
5776 |
0 |
|
YunTeng |