{
"query_block": {
"select_id": 1,
"table": {
"table_name": "p",
"access_type": "range",
"possible_keys": ["PRIMARY", "idx_group_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"rows": 30,
"filtered": 100,
"index_condition": "p.product_id in (4070,4154,4144,4152,4153,4029,4026,3999,4003,4005,4155,4156,4157,4158,4159,4160,4114,4112,4204,4208,4209,4210,4110,4111,4130,4132,4133,4134,3977,4055)"
},
"table": {
"table_name": "g",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["id"],
"ref": ["ymonline_livedata.p.group_id"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "f",
"access_type": "ref",
"possible_keys": ["idx_group_id"],
"key": "idx_group_id",
"key_length": "3",
"used_key_parts": ["group_id"],
"ref": ["ymonline_livedata.p.group_id"],
"rows": 1,
"filtered": 100
}
}
}
feature_id | purpose | product_id | parent_product_id | id | code |
---|---|---|---|---|---|
578 | group_variation_catalog_item | 3977 | 0 | 324 | TBMCCF178 |
551 | group_variation_catalog_item | 3999 | 0 | 329 | TBMCJN13 |
551 | group_variation_catalog_item | 4003 | 0 | 330 | TBMCJN14 |
551 | group_variation_catalog_item | 4005 | 0 | 331 | TBMCC293 |
551 | group_variation_catalog_item | 4026 | 0 | 335 | TBMCABU68 |
551 | group_variation_catalog_item | 4055 | 0 | 340 | TBMCABU64 |
551 | group_variation_catalog_item | 4070 | 0 | 347 | TBMCABU23 |
578 | group_variation_catalog_item | 4110 | 0 | 387 | TBMCKT01 |
578 | group_variation_catalog_item | 4111 | 0 | 388 | TBMCKT02 |
551 | group_variation_catalog_item | 4130 | 0 | 353 | TBMCMY161 |
551 | group_variation_catalog_item | 4204 | 0 | 361 | TBMCAN87 |