{
"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": 24,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (2825,2303,2302,2562,2563,2564,11788,2343,11790,12698,2268,2269,2316,4395,2315,2626,2624,11804,11803,2842,2741,12711,12697,11802) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2268 | a-mari-gin-atlantic-ocean-1-x-750ml-1s | 265/357 |
2269 | a-mari-gin-indian-ocean-1-x-750ml-1s | 265/357 |
2302 | 48-gin-platinum-black-1-x-750ml-1s | 265/357 |
2303 | 48-gin-pink-1-x-750ml-1s | 265/357 |
2315 | absolut-750ml-vodka-raspberry-1-x-750ml-1s | 265/357 |
2316 | absolut-750ml-vodka-elyx-1-x-750ml-1s | 265/357 |
2343 | 999-ketel-one-vodka-1-x-750ml-1s | 265/357 |
2562 | 4th-street-3lt-wine-red-natural-sweet-1-x-3lt-disc | 265/356 |
2563 | 4th-street-5lt-wine-red-natural-sweet-1-x-5lt-1s | 265/356 |
2564 | 4th-street-5lt-wine-rose-natural-sweet-1-x-5lt-1s | 265/356 |
2624 | alto-750ml-wine-rouge-1-x-750ml-bottle | 265/356 |
2626 | allesverloren-750ml-port-1-x-750ml-1s | 265/356 |
2741 | alvis-drift-pinotage-1-x-750ml-1s | 265/356 |
2825 | 1659-south-africa-wine-750ml-merlot-cinsault-cab-sauv-1-x-750ml-1s | 265/356 |
2842 | alvis-drift-merlot-1-x-750ml-1s | 265/356 |
4395 | absolut-vodka-kurant-750ml | 265/357 |
11788 | 999-durbanville-hills-wine-chardonnay-1-x-750ml-1s | 265/356 |
11790 | 999-spier-wine-chardonnay-1-x-750ml-bottle | 265/356 |
11802 | alvis-drift-cabernet-sauvignon-1-x-750ml-ea | 265/356 |
11803 | alvis-drift-chenin-blanc-1-x-750ml-ea | 265/356 |
11804 | alvis-drift-chardonnay-1-x-750ml-ea | 265/356 |
12697 | alvis-drift-sauvignon-blanc-1-x-750ml-ea | 265/356 |
12698 | 999-vergelegen-wine-mill-race-red-1-x-750ml-1s | 265/356 |
12711 | alvis-drift-brut-rose-sparkling-1-x-750ml-ea | 265/356 |