{
"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": 31,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (12669,12975,2299,2297,2298,2203,2566,3215,3214,11118,12685,13990,2340,11888,2339,2338,2180,2181,13661,15141,2228,2226,2227,2336,12743,2185,14298,15154,13222,15155) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2180 | jagermeister-1lt-liqueur-1-x-1lt-1s | 265/357 |
2181 | jagermeister-700ml-liqueur-1-x-700ml-1s | 265/357 |
2185 | johnnie-walker-750ml-whiskey-red-label-1-x-750ml-1s | 265/357 |
2203 | j-and-b-750ml-whisky-scotch-rare-1-x-750ml-bottle | 265/357 |
2226 | jameson-750ml-whisky-irish-triple-dist-1-x-750ml-bottle | 265/357 |
2227 | jameson-50ml-whisky-irish-triple-dist-1-x-50ml-1s | 265/357 |
2228 | jameson-750ml-whisky-select-reserve-1-x-750ml-1s | 265/357 |
2297 | inverroche-gin-750ml-classic-1-x-750ml-1s | 265/357 |
2298 | inverroche-gin-verdant-1-x-750ml-1s | 265/357 |
2299 | inverroche-gin-750ml-amber-1-x-750ml-1s | 265/357 |
2336 | jim-beam-whisky-bourbon-white-label-1-x-750ml-bottle | 265/357 |
2338 | jack-daniels-750ml-whisky-bourbon-honey-1-x-750ml-1s | 265/357 |
2339 | jack-daniels-750ml-whisky-bourbon-fire-1-x-750ml-1s | 265/357 |
2340 | jack-daniels-whiskey-bourbon-1-x-750ml-bottle | 265/357 |
2566 | 999-j.c.le-roux-non-alcoholic-le-domaine-1-x-750ml-1s | 265/356 |
3214 | j.c.le-roux-spark-wine-le-domaine-1-x-750ml-bottle | 265/356 |
3215 | j.c.le-roux-spark-wine-la-chanson-1-x-750ml-bottle | 265/356 |
11118 | j.c.le-roux-vibrazio-demi-sec-1-x-750ml-1s | 265/356 |
11888 | jack-daniels-750ml-whisky-bourbon-single-barrel-1-x-750ml-bottle | 265/357 |
12669 | ice-tropez-275ml-french-rose-wine-based-ctail-6.5-6-x-275ml | 265/392 |
12685 | j.c.le-roux-spark-wine-demi-sec-nectar-rose-1-x-750ml-ea | 265/356 |
12743 | product-12743 | 265/357 |
12975 | indaba-chardonnay | 265/356 |
13222 | jordan-chameleon-750ml-wine-red-1-x-750ml | 265 |
13661 | jameson-black-barrel-1-x-750-ml | 265/357 |
13990 | jack-daniels-whiskey-and-cola-cooler-bottles-4-x-330ml | 265 |
14298 | jordan-chenin-blanc-2023 | 265 |
15141 | jameson-caskmates-ipa-edition-jameson-irish-whiskey-1-x-750ml | 265 |
15154 | jordan-black-magic-merlot-2022-1-x-750ml | 265 |
15155 | jordan-nine-yards-reserve-chardonnay-2020-wine-co-za | 265 |