{
"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 (12664,12667,12666,12751,2641,2642,2635,2636,12691,12690,12692,2199,2200,2237,12678,3238,3237,12656,13107,12672,12671,11136,2772,11808) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2199 | bells-1lt-scotch-extra-special-1-x-1lt-bottle | 265/357 |
2200 | bells-750ml-scotch-extra-special-1-x-750ml-bottle | 265/357 |
2237 | belvedere-750ml-vodka-1-x-750ml-1s | 265/357 |
2635 | bellingham-wine-shiraz-cabernet-big-oak-1-x-750ml-1s | 265/356 |
2636 | bellingham-wine-white-pear-tree-2012-1-x-750ml-1s | 265/356 |
2641 | bellingham-750ml-homestead-chardonnay-1-x-750ml-1s | 265/356 |
2642 | bellingham-wine-homestead-pinotage-1-x-750ml-1s | 265/356 |
2772 | beyerskloof-wine-pinotage-1-x-750ml-1s | 265/356 |
3237 | bernini-275ml-cider-nrb-classic-grape-6-x-275ml | 265/392 |
3238 | bernini-275ml-cider-nrb-blush-6-x-275ml | 265/392 |
11136 | beyerskloof-750ml-chenin-pinotage-wine-6-x-750ml | 265/356 |
11808 | beyerskloof-750ml-chenin-pinotage-wine-1-x-750ml-1s | 265/356 |
12656 | bernini-cider-can-blush-6-x-440ml | 265/392 |
12664 | belgravia-gin-pink-tonic-6-x-275ml | 265/392 |
12666 | belgravia-gin-tonic-6-x-275ml | 265/392 |
12667 | belgravia-gin-tonic-24-x-275ml | 265/392 |
12671 | bernini-cider-nrb-classic-grape-24-x-275ml | 265/392 |
12672 | bernini-cider-nrb-blush-24-x-275ml | 265/392 |
12678 | bernini-cider-can-blush-24-x-440ml | 265/392 |
12690 | bellingham-wine-homestead-light-sau-blanc-1-x-750ml-ea | 265/356 |
12691 | bellingham-homestead-light-pinotage-1-x-750ml-ea | 265/356 |
12692 | bellingham-wine-homestead-red-blend-1-x-750ml-ea | 265/356 |
12751 | product-12751 | 265/357 |
13107 | bernini-cider-can-classic-24-x-440ml | 265 |