Query time 0.00155
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1217.01"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_product_feature_variants",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"feature_id"
],
"key": "feature_id",
"used_key_parts": [
"feature_id"
],
"key_length": "3",
"rows_examined_per_scan": 35,
"rows_produced_per_join": 35,
"filtered": "100.00",
"index_condition": "(`cscartdb`.`cscart_product_feature_variants`.`feature_id` in (1476,1475,1474))",
"cost_info": {
"read_cost": "13.01",
"eval_cost": "3.50",
"prefix_cost": "16.51",
"data_read_per_join": "39K"
},
"used_columns": [
"variant_id",
"feature_id",
"position"
]
}
},
{
"table": {
"table_name": "cscart_product_feature_variant_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscartdb.cscart_product_feature_variants.variant_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 35,
"filtered": "100.00",
"cost_info": {
"read_cost": "8.75",
"eval_cost": "3.50",
"prefix_cost": "28.76",
"data_read_per_join": "105K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_product_features_values",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"fl",
"variant_id",
"lang_code",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id",
"product_id",
"variant_id",
"lang_code"
],
"key_length": "15",
"ref": [
"cscartdb.cscart_product_feature_variants.feature_id",
"const",
"cscartdb.cscart_product_feature_variants.variant_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 35,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "8.75",
"eval_cost": "3.50",
"prefix_cost": "41.01",
"data_read_per_join": "27K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_product_features",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id"
],
"key_length": "3",
"ref": [
"cscartdb.cscart_product_feature_variants.feature_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 35,
"filtered": "100.00",
"cost_info": {
"read_cost": "8.75",
"eval_cost": "3.50",
"prefix_cost": "53.26",
"data_read_per_join": "15K"
},
"used_columns": [
"feature_id",
"feature_type"
]
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"cscartdb.cscart_product_feature_variants.variant_id",
"const",
"const",
"const"
],
"rows_examined_per_scan": 95,
"rows_produced_per_join": 3325,
"filtered": "100.00",
"cost_info": {
"read_cost": "831.25",
"eval_cost": "332.50",
"prefix_cost": "1217.01",
"data_read_per_join": "5M"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
]
}
}
}
}
Result
variant |
variant_id |
feature_id |
selected |
feature_type |
seo_name |
seo_path |
Small |
5907 |
1474 |
5907 |
S |
|
|
Soft |
5910 |
1475 |
5910 |
S |
|
|
Ultra White |
5913 |
1476 |
5913 |
S |
|
|
Medium |
5908 |
1474 |
|
S |
|
|
Medium |
5911 |
1475 |
|
S |
|
|
Pearl |
5914 |
1476 |
|
S |
|
|
Firm |
5912 |
1475 |
|
S |
|
|
Gun Metal |
5915 |
1476 |
|
S |
|
|
Large |
5909 |
1474 |
|
S |
|
|
Charcoal |
5916 |
1476 |
|
S |
|
|
Onyx |
5917 |
1476 |
|
S |
|
|
Bark Brown |
5918 |
1476 |
|
S |
|
|
Bronze |
5919 |
1476 |
|
S |
|
|
Copper |
5920 |
1476 |
|
S |
|
|
Cooper Brown |
5921 |
1476 |
|
S |
|
|
Pewter |
5922 |
1476 |
|
S |
|
|
Blonde |
5923 |
1476 |
|
S |
|
|
Rose Gold |
5924 |
1476 |
|
S |
|
|
Gold |
5925 |
1476 |
|
S |
|
|
Toffee |
5926 |
1476 |
|
S |
|
|
Wine Red |
5927 |
1476 |
|
S |
|
|
Dark Cherry |
5928 |
1476 |
|
S |
|
|
Pacific Blue |
5929 |
1476 |
|
S |
|
|
Royal Blue |
5930 |
1476 |
|
S |
|
|
Midnight Blue |
5931 |
1476 |
|
S |
|
|
Olive Green |
5932 |
1476 |
|
S |
|
|
Atlantis Green |
5933 |
1476 |
|
S |
|
|
Dark Purple |
5934 |
1476 |
|
S |
|
|
Dragon Scale |
5935 |
1476 |
|
S |
|
|
Amethyst |
5936 |
1476 |
|
S |
|
|
Blue Gold |
5937 |
1476 |
|
S |
|
|
Dream Blue |
5938 |
1476 |
|
S |
|
|
Hot Pink |
5939 |
1476 |
|
S |
|
|
Octarine |
5940 |
1476 |
|
S |
|
|
Tarrot |
5941 |
1476 |
|
S |
|
|
Yale Blue |
5942 |
1476 |
|
S |
|
|