{
"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": 30,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (4340,2364,13765,13826,13993,2218,2349,2178,2177,11786,2827,2640,2312,2309,2310,2311,3236,4344,3221,3225,3218,3246,3222,4347,3242,12675,11361,12647,12880,12670) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2177 | hennessy-750ml-cognac-vsop-moved-to-ac-91809-1-x-750ml-1s | 265/357 |
2178 | hennessy-cognac-vs-gift-box-1-x-750ml-1s | 265/357 |
2218 | hendricks-750ml-gin-1-x-750ml-1s | 265/357 |
2309 | hope-on-hopkins-750ml-gin-london-dry-1-x-750ml-1s | 265/357 |
2310 | hope-on-hopkins-750ml-gin-mediterranean-1-x-750ml-1s | 265/357 |
2311 | hope-on-hopkins-750ml-gin-salt-river-1-x-750ml-1s | 265/357 |
2312 | hope-on-hopkins-500ml-gin-esperanza-agave-1-x-500ml-1s | 265/357 |
2349 | henkes-gin-1-x-750ml-1s | 265/357 |
2364 | heineken-330ml-beer-nrb-24-x-330ml | 265/355 |
2640 | 999-homestead-wine-sauvignon-blanc-1-x-750ml-1s | 265/356 |
2827 | historic-wine-savignon-blanc-1659-1-x-750ml-1s | 265/356 |
3218 | extreme-extreme-nrb-6-x-275ml | 265/392 |
3221 | hunters-cider-330ml-dry-nrb-6-x-330ml | 265/392 |
3222 | hunters-cider-330ml-gold-nrb-6-x-330ml | 265/392 |
3225 | hunters-cider-can-dry-6-x-440ml | 265/392 |
3236 | hunters-cider-330ml-hard-lemon-nrb-6-x-330ml | 265/392 |
3242 | hunters-440ml-cider-can-gold-6-x-440ml | 265/392 |
3246 | extreme-cider-can-6-x-250ml | 265/392 |
4340 | heineken-440ml-beer-can-24-x-440ml | 265/355 |
4344 | hunters-cider-can-hard-lemon-6-x-440ml | 265/392 |
4347 | hunters-cider-can-gold-6-x-330ml | 265/392 |
11361 | hunters-dry-12-x-660ml | 265/392 |
11786 | 999-hill-and-dale-wine-sauvignon-blanc-1-x-750ml-1s | 265/356 |
12647 | extreme-extreme-nrb-6-x-275ml-en | 265/392 |
12670 | ice-tropez-275ml-french-rose-wine-based-ctail-0-6-x-275ml | 265/392 |
12675 | hunters-cider-can-gold-24-x-330ml | 265/392 |
12880 | hunters-gold-12-x-660ml | 265/392 |
13765 | heineken-silver-330ml-case | 265 |
13826 | heineken-silver-6x330ml-nrb | 265 |
13993 | heineken-silver-beer-cans-6-x-440ml | 265 |