{
"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": 26,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (2241,2238,2164,2283,11114,14589,15137,2743,2742,2687,11797,11796,2688,11899,11898,2756,2755,15156,11810,2189,2328,12694,12696,12695) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2164 | courvoisier-750ml-brandy-cognac-vs-1-x-750ml-1s | 265/357 |
2189 | dimple-haig-750ml-whisky-15yr-1-x-750ml-bottle | 265/357 |
2238 | count-pushkin-vodka-12-x-50ml | 265/357 |
2241 | count-pushkin-750ml-vodka-rb-1-x-750ml-1s | 265/357 |
2283 | cruxland-gin-varient-1-x-750ml-1s | 265/357 |
2328 | disaronno-amaretto-liqueur-ltd-edt-trussardi-1-x-750ml-1s | 265/357 |
2687 | delheim-750ml-wine-cabernet-sauvignon-shiraz-1-x-750ml-bottle | 265/356 |
2688 | delheim-wine-shiraz-1-x-750ml-1s | 265/356 |
2742 | de-krans-750ml-wine-ruby-port-1-x-750ml-1s | 265/356 |
2743 | de-krans-wine-cape-tawny-port-1-x-750ml-1s | 265/356 |
2755 | diemersdal-wine-sauvignon-blanc-1-x-750ml-1s | 265/356 |
2756 | diemersdal-wine-merlot-1-x-750ml-1s | 265/356 |
11114 | cruz-750ml-fvodka-wmelon-1-x-750ml-1s | 265/357 |
11796 | delheim-wine-pintotage-rose-1-x-750ml-1s | 265/356 |
11797 | delheim-750ml-wine-merlot-1-x-750ml-1s | 265/356 |
11810 | diemersfontein-wine-pinotage-1-x-750ml-1s | 265/356 |
11898 | dias-cordial-750ml-lime-1-x-750ml-1s | 265/383 |
11899 | dias-cordial-750ml-grenadine-1-x-750ml-1s | 265/383 |
12694 | douglas-green-v-yard-friends-chenin-blanc-1-x-750ml-ea | 265/356 |
12695 | douglas-green-vineyard-friends-pinotage-1-x-750ml-ea | 265/356 |
12696 | douglas-green-vineyard-friends-merlot-malbec-1-x-750ml-ea | 265/356 |
14589 | da-luca-prosecco-1-x-750-ml | 265 |
15137 | de-grendel-merlot-2016-1-x-750ml | 265 |
15156 | diemersfontein-cabernet-sauvignon-2019-1-x-750ml | 265 |