{
"query_block": {
"select_id": 1,
"cost": 0.0237706,
"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": 12,
"cost": 0.0237706,
"filtered": 100,
"attached_condition": "cscart_seo_names.object_id in (212,1810,1811,102,176,138,110,36,28,93,87,139) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
]
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 28 | run-perf-7-8-ti | 223/225 |
| 36 | routing-protocols-and-concepts-ccna-exploration-companion-guide | 219/220 |
| 87 | sesame-street-cookies-counting-carnival-wii | 245/246 |
| 93 | scene-it-bright-lights-big-screen-x360 | 245/248 |
| 102 | pr-100-womens-white-quartz-watch | 223/227 |
| 110 | roots-30th-anniversary-special-edition-dvd | 241/243 |
| 138 | ridge-racer | 245/249 |
| 139 | shinobido-2-revenge-of-zen | 245/249 |
| 176 | quartet-euro-magnetic-porcelain-total-erase-mobile-easel | 250/252 |
| 212 | panasonic-kx-mb2000-24ppm-3-in-1-monochrome-laser-mfp | 167/172 |
| 1810 | platform-lightbar-extension-to-suit-crafter-lwb | 267 |
| 1811 | platform-lightbar-extension-to-suit-crafter-mwb | 267 |