{
"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": 25,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (15298,2806,2805,2710,2709,2712,2711,4211,4353,11891,11835,2253,2676,2672,2667,11126,11125,2668,2662,2660,2670,2671,2666,2661) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2253 | richelieu-brandy-export-12-x-50ml | 265/357 |
2660 | robertson-750ml-wine-pinotage-1-x-750ml-1s | 265/356 |
2661 | robertson-wine-cabernet-ruby-1-x-750ml-bottle | 265/356 |
2662 | robertson-750ml-wine-merlot-1-x-750ml-1s | 265/356 |
2666 | robertson-2lt-wine-chardonnay-1-x-2lt-bottle | 265/356 |
2667 | robertson-2lt-wine-sauvignon-blanc-1-x-2lt-box | 265/356 |
2668 | robertson-750ml-wine-chenin-blanc-1-x-750ml-1s | 265/356 |
2670 | robertson-750ml-wine-shiraz-1-x-750ml-bottle | 265/356 |
2671 | robertson-2lt-wine-cabernet-ruby-1-x-2lt-1s | 265/356 |
2672 | robertson-2lt-wine-chenin-blanc-1-x-2lt-1s | 265/356 |
2676 | robertson-2lt-wine-cabernet-sauvignon-1-x-2lt-1s | 265/356 |
2709 | rhino-run-750ml-chardonnay-wine-1-x-750ml-1s | 265/356 |
2710 | rhino-run-750ml-cabernet-sauvignon-wine-1-x-750ml-1s | 265/356 |
2711 | rhino-run-750ml-pinotage-wine-1-x-750ml-1s | 265/356 |
2712 | rhino-run-750ml-ian-player-wine-1-x-750ml-1s | 265/356 |
2805 | reyneke-wine-shiraz-cabernet-red-1-x-750ml-1s | 265/356 |
2806 | reyneke-wine-sauvignon-blanc-semillon-white-1-x-750ml-1s | 265/356 |
4211 | rib-shack-red | 265 |
4353 | 999-ricard-liqueur-apretif-1-x-750ml-1s | 265/357 |
11125 | robertson-750ml-wine-chapel-natural-sweet-rose-1-x-750ml-1s | 265/356 |
11126 | robertson-500ml-wine-chapel-white-1-x-500ml-1s | 265/356 |
11835 | richelieu-brandy-export-1-x-750-ml | 265/357 |
11891 | richelieu-brandy-750ml-10yr-1-x-750ml-1s | 265/357 |
15298 | reyneke-organic-chenin-blanc-2022 | 265 |