{
"query_block": {
"select_id": 1,
"cost": 0.01369125,
"nested_loop": [
{
"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"],
"loops": 1,
"rows": 7,
"cost": 0.01369125,
"filtered": 100,
"attached_condition": "cscart_seo_names.object_id in (153,312044,164,12695,12966,12711,312042) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
]
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 153 | ur55-full-size-headphones | 166/177/181 |
| 164 | wb210-10mb-14-megapixel-slim-digital-camera-red | 166/196/198 |
| 12695 | wireless-earbuds | 166 |
| 12711 | wireless-mouse | 166 |
| 12966 | wireless-earbuds-en | 166 |
| 312042 | wireless-mouse-en | 166 |
| 312044 | usb-c-charger | 166 |