Query time 0.00080
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "97.21"
},
"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": 27,
"rows_produced_per_join": 27,
"filtered": "100.00",
"index_condition": "(`portal`.`q_product_feature_variants`.`variant_id` in (5954,5978,6068,6426,6527,6704,6706,6848,7338,7376,7425,7426,7427,7434,7449,7613,7837,8765,8813,9081,9082,9083,9087,9117,9296,9383,9557))",
"cost_info": {
"read_cost": "59.41",
"eval_cost": "5.40",
"prefix_cost": "64.81",
"data_read_per_join": "30K"
},
"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": 27,
"filtered": "100.00",
"cost_info": {
"read_cost": "27.00",
"eval_cost": "5.40",
"prefix_cost": "97.21",
"data_read_per_join": "81K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
]
}
}
]
}
}
}
Result
variant_id |
position |
color |
variant |
7613 |
0 |
|
Generic |
7837 |
0 |
|
Godox |
9081 |
0 |
|
AnyCast |
5954 |
0 |
|
Apple |
8765 |
0 |
|
Brinonac |
7427 |
0 |
|
C2G |
5978 |
0 |
|
Case Logic |
7425 |
0 |
|
Cellet |
8813 |
0 |
|
Conwork |
9082 |
0 |
|
Cwk |
6706 |
0 |
|
e-flite |
9383 |
0 |
|
Ebags |
7434 |
0 |
|
Exinoz |
7449 |
0 |
|
HP Stream |
6527 |
0 |
|
ILuv |
9557 |
0 |
|
LattePanda |
7376 |
0 |
|
Mobile Edge |
6426 |
0 |
|
Monoprice |
6848 |
0 |
|
Monoprice |
9087 |
0 |
|
Mosiso |
6068 |
0 |
|
Samsung |
7426 |
0 |
|
Times Microwave |
9296 |
0 |
|
Trakdot |
6704 |
0 |
|
Vangoddy |
9083 |
0 |
|
Wavlink |
7338 |
0 |
|
Zalman |
9117 |
0 |
|
Zerkar |