{
"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 (2686,2568,15042,14456,2188,13664,12195,14044,15057,12955,2645,2646,2333,2331,2330,2792,2793,11131,2794,11132,2798,2795,2797,11890) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2188 | 999-oban-whisky-1-x-750ml-1s | 265/357 |
2330 | olmeca-tequila-supremo-reposado-1-x-750ml-1s | 265/357 |
2331 | olmeca-750ml-tequila-fusion-dark-choc-999-1-x-750ml-1s | 265/357 |
2333 | olmeca-tequila-blanco-1-x-750ml-1s | 265/357 |
2568 | neethlingshof-750ml-6-flowers-white-blend-wine-1-x-750ml-1s | 265/356 |
2645 | old-road-wine-white-juliette-sauvignon-blanc-1-x-750ml-1s | 265/356 |
2646 | old-road-wine-red-the-butcher-and-clever-1-x-750ml-1s | 265/356 |
2686 | 999-neethlingshof-cabernet-sauvignon-wine-1-x-750ml-1s | 265/356 |
2792 | orange-river-cellars-wine-750ml-colombard-1-x-750ml-1s | 265/356 |
2793 | orange-river-cellars-wine-750ml-nouveau-1-x-750ml-1s | 265/356 |
2794 | orange-river-cellars-wine-750ml-ruby-cabernet-1-x-750ml-1s | 265/356 |
2795 | orange-river-cellars-wine-750ml-sparkling-rose-1-x-750ml-1s | 265/356 |
2797 | orange-river-cellars-wine-750ml-sparkling-doux-1-x-750ml-1s | 265/356 |
2798 | orange-river-cellars-wine-750ml-sparkling-brut-1-x-750ml-1s | 265/356 |
11131 | orange-river-cellars-wine-750ml-pinotage-1-x-750ml-1s | 265/356 |
11132 | orange-river-cellars-wine-750ml-shiraz-1-x-750ml-1s | 265/356 |
11890 | orijin-gin-marula-1-x-750ml-ea | 265/357 |
12195 | okavango-gin | 265 |
12955 | old-bull-stout-24-x-330-ml | 265 |
13664 | okavango-gin-the-forager-1-x-750ml | 265/357 |
14044 | the-sentinel-50-ml-miniature | 265/357 |
14456 | o3-purified-still-water-500ml-case | 265 |
15042 | o3-purified-sparkling-water-500ml-case | 265 |
15057 | old-buck-dry-gin-bottle-750ml | 265 |