{
"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 (2341,15088,15052,15053,15054,15055,15087,15056,15050,15049,15048,15047,11134,2816,2815,13609,13514,2214,15387,2451,2453,2162,12741,11785) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2162 | remy-martin-750ml-cognac-vsop-1-x-750ml-1s | 265/357 |
2214 | red-heart-750ml-rum-1-x-750ml-bottle | 265/357 |
2341 | pravda-vodka-plain-1-x-750ml-1s | 265/357 |
2451 | redds-vodka-lemon-can-500ml | 265/355 |
2453 | redds-vodka-lemon-rb-660ml | 265/355 |
2815 | radford-dale-syrah-towgh-mount-side-1-x-750ml-1s | 265/356 |
2816 | radford-dale-chenin-bushvine-1-x-750ml-1s | 265/356 |
11134 | protea-wine-cabernet-sauvignon-2008-1-x-750ml-1s | 265/356 |
11785 | remy-martin-cognac-champagne-fine-1-x-750ml-1s | 265/356 |
12741 | product-12741 | 265/357 |
13514 | red-bull-24x250ml | 265/383 |
13609 | raspberry-apple-flavoured-sparkling-water | 265 |
15047 | priestly-gin-and-tonic-275ml-case | 265 |
15048 | priestly-gin-and-blue-tonic-275ml-case | 265 |
15049 | priestley-rum-and-raspberry-24-x-440ml-can | 265 |
15050 | priestley-rum-and-cola-6-x-440ml-can | 265 |
15052 | prieslty-dry-lemon-250ml-case | 265 |
15053 | priestley-club-soda-250ml-case | 265 |
15054 | priestley-energy-drink-250ml-case | 265 |
15055 | priestley-indian-tonic-250ml-case | 265 |
15056 | priestley-pink-tonic-250ml-case | 265 |
15087 | priestley-pink-tonic-250ml-6-pack | 265 |
15088 | prieslty-dry-lemon-250ml-6-pack | 265 |
15387 | redbull-case-24-250ml | 265 |