{
"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 (2532,2533,2534,13416,2357,2807,12976,2305,2304,11806,12980,12740,11117,11787,2587,2588,2591,2590,2553,2589,2581,2592,2576,2685) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2304 | musgrave-750ml-gin-crafted-premium-1-x-750ml-1s | 265/357 |
2305 | musgrave-750ml-gin-crafted-pink-1-x-750ml-1s | 265/357 |
2357 | mount-gay-750ml-barrel-rum-blk-1-x-750ml-1s | 265/357 |
2532 | monster-energy-rossi-vr40-500ml-case | 265/383 |
2533 | monster-energy-zero-ultra-500ml-case | 265/383 |
2534 | monster-predator-500ml-case | 265/383 |
2553 | nederburg-wine-merlot-1-x-750ml-1s | 265/356 |
2576 | nederburg-wine-sparkling-cuvee-brut-1-x-750ml-1s | 265/356 |
2581 | nederburg-wine-sauvignon-blanc-white-1-x-750ml-1s | 265/356 |
2587 | nederburg-wine-baronne-red-1-x-750ml-ea | 265/356 |
2588 | nederburg-wine-cabernet-sauvignon-red-1-x-750ml-bottle | 265/356 |
2589 | nederburg-wine-pinotage-red-1-x-750ml-bottle | 265/356 |
2590 | nederburg-wine-lyric-white-1-x-750ml-bottle | 265/356 |
2591 | nederburg-wine-chardonnay-white-1-x-750ml-bottle | 265/356 |
2592 | nederburg-wine-shiraz-red-1-x-750ml-bottle | 265/356 |
2685 | neethlingshof-wine-750ml-cabernet-merlot-1-x-750ml-1s | 265/356 |
2807 | mulderbosch-wine-chenin-blanc-steep-op-hout-1-x-750ml-1s | 265/356 |
11117 | 999-nederburg-cabernet-sauvignon-5600-wine-1-x-750ml-1s | 265/356 |
11787 | 999-nederburg-anchorman-chenin-blanc-wht-1-x-750ml-1s | 265/356 |
11806 | namaqua-5lt-wine-blanc-de-blanc-white-1-x-5lt-1box | 265/356 |
12740 | product-12740 | 265/357 |
12976 | mulderbosch-sauvignon-blanc-2021-750ml-1 | 265 |
12980 | nartjie-flavoured-sparkling-water | 265 |
13416 | monster-predator-purple-rain-500ml | 265 |