{
"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 (1334,1337,1339,1340,1343,399,195,233,152,160,108,237) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
]
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 108 | due-date-blu-ray | 241/242 |
| 152 | drifter-2 | 203/204/210 |
| 160 | drifter-3 | 203/204/210 |
| 195 | crossroads-guitar-festival-2010-2dvd | 228/232 |
| 233 | crystal-lake-warm-weather-sleeping-bag | 203/215/217 |
| 237 | elite-evanston-8-tent | 203/215/218 |
| 399 | commercial-max-oval-steel-accessory-universal-tiedown-kit | 267 |
| 1334 | commercial-max-oval-steel-accessory-removable-boat-roller-pair | 267 |
| 1337 | commercial-max-oval-steel-accessory-safeclamp-ladder-clamp-pair | 267 |
| 1339 | commercial-max-oval-steel-accessory-shovel-holder | 267 |
| 1340 | commercial-max-oval-steel-accessory-spare-wheel-carrier | 267 |
| 1343 | commercial-max-oval-steel-accessory-steel-wind-deflector | 267 |