{
"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": 30,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (11917,11916,15106,15071,11664,2616,2615,2552,11121,2570,2617,2618,2703,2706,2708,2701,2329,12686,12687,11800,11801,2738,2739,2740,2737,2845,2643,12708,12707,2347) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2329 | frangelico-750ml-liqueur-cream-1-x-750ml-bottle | 265/357 |
2347 | galliano-liqueur-authentico-1-x-500ml-1s | 265/357 |
2552 | fleur-du-cap-chenin-blanc-wine-1-x-750ml-ea | 265/356 |
2570 | fleur-de-cap-wine-rose-nat-light-1-x-750ml-1s | 265/356 |
2615 | fleur-du-cap-chardonnay-wine-1-x-750ml-ea | 265/356 |
2616 | fleur-du-cap-cabernet-sauvignon-wine-1-x-750ml-1s-.jpeg | 265/356 |
2617 | fleur-de-cap-750ml-pinotage-wine-1-x-750ml-bottle | 265/356 |
2618 | fleur-du-cap-sauvignon-blanc-wine-1-x-750ml-bottle | 265/356 |
2643 | french-quarter-wine-white-1-x-750ml-1s | 265/356 |
2701 | four-cousins-wine-sweet-rose-1-x-1.5lt-bottle | 265/356 |
2703 | four-cousins-1.5lt-wine-dry-red-1-x-1.5lt-bottle | 265/356 |
2706 | four-cousins-1.5lt-wine-dry-white-1-x-1.5lt-bottle | 265/356 |
2708 | four-cousins-wine-natural-sweet-red-1-x-750ml-bottle | 265/356 |
2737 | franschoek-750ml-wine-cellar-sauvignon-blanc-1-x-750ml-1s | 265/356 |
2738 | franschoek-750ml-wine-cellar-shiraz-1-x-750ml-1s | 265/356 |
2739 | franschoek-750ml-wine-cellar-cabernet-sauvignon-1-x-750ml-1s | 265/356 |
2740 | franschoek-750ml-wine-cellar-merlot-1-x-750ml-1s | 265/356 |
2845 | french-quarter-wine-red-1-x-750ml-1s | 265/356 |
11121 | fleur-du-cap-merlot-wine-1-x-750ml-1s | 265/356 |
11664 | fitch-and-leeds-soda-water-200ml-x-24-cans | 265 |
11800 | franschoek-750ml-wine-cellar-chenin-blanc-1-x-750ml-1s | 265/356 |
11801 | franschoek-wine-cellar-pinotage-1-x-750ml-ea | 265/356 |
11916 | fitch-and-leedes-sdrink-pink-tonic-sfree-6-x-200ml | 265/383 |
11917 | fitch-and-leedes-sdrink-pink-tonic-sfree-24-x-200ml | 265/383 |
12686 | franschhoek-cellar-brut-rose-nv-1-x-750ml-ea | 265/356 |
12687 | franschhoek-cellar-cellar-brut-royale-1-x-750ml-ea | 265/356 |
12707 | freyers-cove-doringbay-sauv-blanc-1-x-750ml-ea | 265/356 |
12708 | freyers-cove-doringbay-pinot-noir-1-x-750ml-ea | 265/356 |
15071 | fitch-and-leedes-energy-mixer-24x200ml | 265 |
15106 | fitch-and-leedes-energy-mixer-200ml-6-pack | 265 |