Query time 0.00123
JSON explain
{
"query_block": {
"select_id": 1,
"filesort": {
"sort_key": "cscart_product_feature_variants.position, cscart_product_feature_variant_descriptions.variant",
"temporary_table": {
"table": {
"table_name": "cscart_product_features_values",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"fl",
"variant_id",
"lang_code",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "idx_product_feature_variant_id",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 3,
"filtered": 100,
"index_condition": "cscart_product_features_values.lang_code = 'ru'",
"attached_condition": "cscart_product_features_values.product_id <=> 7802"
},
"table": {
"table_name": "cscart_product_feature_variants",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "feature_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["variant_id"],
"ref": ["admin_test.cscart_product_features_values.variant_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "cscart_product_feature_variants.feature_id = cscart_product_features_values.feature_id and cscart_product_feature_variants.feature_id in (835,837,834,836)"
},
"table": {
"table_name": "cscart_product_features",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["feature_id"],
"ref": ["admin_test.cscart_product_features_values.feature_id"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_product_feature_variant_descriptions",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["variant_id", "lang_code"],
"ref": ["admin_test.cscart_product_features_values.variant_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_product_feature_variant_descriptions.lang_code = 'ru')"
},
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "206",
"used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
"ref": [
"admin_test.cscart_product_features_values.variant_id",
"const",
"const",
"const"
],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_seo_names.`type` = 'e' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'ru')"
}
}
}
}
}
Result
variant |
variant_id |
feature_id |
selected |
feature_type |
seo_name |
seo_path |
color |
value_int |
1 |
9184 |
835 |
9184 |
S |
|
|
|
|
10.5 W |
9175 |
834 |
9175 |
S |
|
|
|
|
USB A |
9190 |
836 |
9190 |
S |
|
|
|
|
Кабель Type C |
9194 |
837 |
9194 |
S |
|
|
|
|