Query time 0.00044
JSON explain
{
"query_block": {
"select_id": 1,
"filesort": {
"sort_key": "fd.description, fv.position",
"temporary_table": {
"table": {
"table_name": "v",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"fl",
"variant_id",
"lang_code",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "product_id",
"key_length": "3",
"used_key_parts": ["product_id"],
"rows": 12,
"filtered": 99.97067261,
"index_condition": "v.product_id in (2573,2596,2702,12710,2584,11811,2818,11813,11812,2817,2820,2821)",
"attached_condition": "v.lang_code = 'en'"
},
"table": {
"table_name": "f",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "status"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["feature_id"],
"ref": ["ymonline_livedata.v.feature_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "f.`status` = 'A' and f.display_on_catalog = 'Y' and (f.categories_path = '' or find_in_set(265,f.categories_path) or find_in_set(356,f.categories_path)) and if(f.parent_id,(subquery#2),'A') = 'A' and (v.variant_id <> 0 or f.feature_type <> 'C' and v.`value` <> '' or f.feature_type = 'C' or v.value_int <> '')"
},
"table": {
"table_name": "fd",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["feature_id", "lang_code"],
"ref": ["ymonline_livedata.v.feature_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(fd.lang_code = 'en')"
},
"table": {
"table_name": "fv",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["variant_id"],
"ref": ["ymonline_livedata.v.variant_id"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "vd",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["variant_id", "lang_code"],
"ref": ["ymonline_livedata.fv.variant_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(vd.lang_code = 'en' and trigcond(fv.variant_id is not null))"
},
"table": {
"table_name": "gf",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["feature_id"],
"ref": ["ymonline_livedata.f.parent_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(gf.feature_type = 'G')"
},
"subqueries": [
{
"expression_cache": {
"state": "uninitialized",
"query_block": {
"select_id": 2,
"table": {
"table_name": "df",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["feature_id"],
"ref": ["ymonline_livedata.f.parent_id"],
"rows": 1,
"filtered": 100
}
}
}
}
]
}
}
}
}