{
"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 (2673,15305,15390,2606,15132,2601,2602,2605,2607,2201,2287,2292,2291,2290,2230,2252,2555,2627,2628,2554,2603,2604,2179,13525) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2179 | underberg-bitters-3-x-20ml | 265/357 |
2201 | tia-maria-liqueur-1-x-750ml-1s | 265/357 |
2230 | tullamore-dew-750ml-whisky-irish-1-x-750ml-1s | 265/357 |
2252 | two-keys-750ml-whisky-scotch-1-x-750ml-bottle | 265/357 |
2287 | toscello-bitters-aromatic-1-x-125ml-1s | 265/357 |
2290 | triple-3-gin-juniper-berries-100-1-x-500ml-1s | 265/357 |
2291 | triple-3-gin-citrus-infusion-1-x-500ml-1s | 265/357 |
2292 | triple-3-gin-african-botanicals-1-x-500ml-1s | 265/357 |
2554 | two-oceans-wine-sav-blanc-1-x-3lt-1s | 265/356 |
2555 | two-oceans-wine-cab-merlot-1-x-3lt-1s | 265/356 |
2601 | three-peaks-wine-cantata-2006-1-x-750ml-1s | 265/356 |
2602 | three-peaks-wine-pinotage-2008-1-x-750ml-1s | 265/356 |
2603 | unbelievable-wine-red-1-x-750ml-1s | 265/356 |
2604 | unbelievable-wine-white-1-x-750ml-1s | 265/356 |
2605 | three-peaks-wine-sauvignon-blanc-1-x-750ml-1s | 265/356 |
2606 | three-peaks-750ml-wine-unwooded-chardonnay-2015-1-x-750ml-1s | 265/356 |
2607 | three-peaks-wine-shiraz-1-x-750ml-1s | 265/356 |
2627 | two-oceans-wine-cabernet-merlot-1-x-750ml-bottle | 265/356 |
2628 | two-oceans-wine-sauvignon-blanc-1-x-750ml-bottle | 265/356 |
2673 | the-wolftrap-750ml-wine-red-1-x-750ml-1s | 265/356 |
13525 | underberg-bitters-20ml | 265 |
15132 | three-peaks-merlot-6-x-750ml | 265 |
15305 | thelema-mountain-white-2023-sauvignon-blanc | 265 |
15390 | thelema-riesling-2019-750ml | 265 |