{
"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 (13713,2698,15125,15133,2699,2704,2705,2700,2707,14270,2195,12699,2548,15145,2549,15299,2811,2812,2809,2810,2644,2760,2761,2757) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2195 | vat-69-750ml-whisky-scotch-1-x-750ml-bottle | 265/357 |
2548 | veuve-clicquot-750ml-wine-ylw-label-1-x-750ml-1s | 265/356 |
2549 | veuve-clicquot-750ml-wine-rich-1-x-750ml-1s | 265/356 |
2644 | waterside-wine-chardonnay-unoaked-1-x-750ml-1s | 265/356 |
2698 | van-loveren-750ml-wine-neils-pick-colombard-chardonnay-1-x-750ml-1s | 265/356 |
2699 | van-loveren-750ml-wine-blanc-de-noirshiraz-1-x-750ml-1s | 265/356 |
2700 | van-loveren-wine-river-red-1-x-750ml-bottle | 265/356 |
2704 | van-loveren-wine-chardonnay-unwooded-1-x-750ml-bottle | 265/356 |
2705 | van-loveren-wine-pinotage-african-java-1-x-750ml-bottle | 265/356 |
2707 | van-loveren-wine-sauvignon-blanc-1-x-750ml-1s | 265/356 |
2757 | welmoed-heritage-wine-750ml-chenin-blanc-1-x-750ml-1s | 265/356 |
2760 | welmoed-heritage-wine-750ml-cabernet-sauvignon-1-x-750ml-1s | 265/356 |
2761 | welmoed-heritage-wine-750ml-chardonnay-1-x-750ml-1s | 265/356 |
2809 | warwick-wine-first-lady-1-x-750ml-1s | 265/356 |
2810 | warwick-wine-first-lady-chardonnay-1-x-750ml-1s | 265/356 |
2811 | warwick-750ml-wine-first-lady-rose-1-x-750ml-1s | 265/356 |
2812 | warwick-750ml-wine-first-lady-sauvignon-blanc-1-x-750ml-1s | 265/356 |
12699 | vergelegen-750ml-wine-shiraz-1-x-750ml-1s | 265/356 |
13713 | underberg-bitters-20ml-en | 265 |
14270 | van-ryns-10yr-single-potstill-brandy-750ml | 265 |
15125 | van-loveren-chenin-no-5-1-x-750ml | 265 |
15133 | van-loveren-merlot-1-x-750ml | 265 |
15145 | veuve-clicquot-brut-rose-1-x750-ml | 265 |
15299 | villiera-down-to-earth-white-chenin-blanc-2023-750ml | 265 |