{
"query_block": {
"select_id": 1,
"table": {
"table_name": "cscart_seo_names",
"access_type": "range",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "206",
"used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
"rows": 4,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (15430,13108,13825,11920) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
11920 | black-and-white-scotch-whiskey-1-x-750-ml | 265/357 |
13108 | belgravia-dry-lemon-and-gin-24-x-275ml | 265 |
13825 | belgravia-gin-and-dry-lemon-cans-6-x-440ml | 265 |
15430 | bahama-margarita-440ml-can-case | 265 |