{
"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 (2556,2822,2244,2245,2808,2351,2352,2342,2270,2843,2225,2323,2266,13822,2529,2503,2813,2814,13821,4378,2550,2551,13142,15143) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2225 | martini-vermouth-wine-bianco-1-x-750ml-bottle | 265/357 |
2244 | lupini-750ml-sambuca-black-1-x-750ml-bottle | 265/357 |
2245 | lupini-750ml-sambuca-gold-1-x-750ml-bottle | 265/357 |
2266 | martini-vermouth-wine-rosso-1-x-750ml-1s | 265/357 |
2270 | 999-malibu-rum-coconut-1-x-750ml-bottle | 265/357 |
2323 | martini-vermouth-extra-dry-1-x-750ml-1s | 265/357 |
2342 | makers-mark-whiskey-bourbon-1-x-750ml-1s | 265/357 |
2351 | macallan-whisky-scotch-12yr-1-x-750ml-1s | 265/357 |
2352 | macallan-750ml-whisky-single-malt-fine-oak-10yr-1-x-750ml-1s | 265/357 |
2503 | mazoe-orange-2l-case | 265/383 |
2529 | mazoe-blackberry-2l-case | 265/383 |
2550 | moet-and-chandon-750ml-wine-brut-imperial-gift-box-1-x-750ml-ea | 265/356 |
2551 | moet-and-chandon-750ml-wine-brut-imperial-rose-1-x-750ml-1s | 265/356 |
2556 | lomond-wine-syrah-1-x-750ml-1s | 265/356 |
2808 | lutzville-cape-diamond-wine-merlot-1-x-750ml-1s | 265/356 |
2813 | meerlust-wine-chardonnay-2008-1-x-750ml-1s | 265/356 |
2814 | meerlust-wine-rubicon-1-x-750ml-1s | 265/356 |
2822 | lookout-wine-750ml-pinotage-rose-2010-1-x-750ml-1s | 265/356 |
2843 | margaret-wine-rose-1-x-750ml-1s | 265/356 |
4378 | millers-gd-330ml-beer-nrb-24-x-330ml | 265/355 |
13142 | moet-and-chandon-brut-imperial-375ml | 265 |
13821 | miller-genuine-draft-beer-bottles-6-pack-330-ml | 265 |
13822 | mayfair-gin-and-tonic-24-x-440ml | 265 |
15143 | moet-and-chandon-non-vintage-imperial-brut-1-x-750ml | 265 |