{
"query_block": {
"select_id": 1,
"table": {
"table_name": "cscart_seo_names",
"access_type": "range",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "210",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code",
"company_id"
],
"rows": 28,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (4116,4136,4115,4127,4087,4126,4086,4128,4089,4091,4108,4085,4090,4971) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en' and (cscart_seo_names.company_id = 1 or cscart_seo_names.company_id = 0)"
}
}
}
| product_id | seo_name | seo_path |
|---|---|---|
| 4085 | motorola-pmln4294-earbud-with-mic-and-ptt-combined | 405/1/198/2466 |
| 4086 | motorola-pmln4442-earbud-with-in-line-microphone | 405/1/198/2466 |
| 4087 | motorola-pmln4443-ear-receiver-with-in-line-microphone | 405/1/198/2466 |
| 4089 | motorola-pmln4605-replacement-clear-acoustic-tube | 405/1/198/2466 |
| 4090 | motorola-pmln4606-2-wire-surveillance-kit-with-clear-acoustic-tube | 405/1/198/2466 |
| 4091 | motorola-pmln5001-d-shell-earpiece-with-ptt-mic. | 405/1/198/2466 |
| 4108 | motorola-pmmn4001-ultra-light-earpiece-w-boom-mic | 405/1/198/2466 |
| 4115 | motorola-rln4895-earpiece-w-mic-and-ptt-comb-blk | 405/1/198/2466 |
| 4116 | motorola-rln4941-receive-only-earpiece-with-translucent-tube-and-rubber-eartip | 405/1/198/2466 |
| 4126 | motorola-pmln4445-ultra-lightweight-headset-w-ptt | 405/1/198/2466 |
| 4127 | motorola-pmln5003-lightweight-temple-transducer-headset | 405/1/198/2466 |
| 4128 | motorola-pmln5011-temple-transducer-headset | 405/1/198/2466 |
| 4136 | motorola-pmln4620-receive-only-d-shell-earpiece | 405/1/198/2466 |
| 4971 | motorola-rln4894-earpiece-without-volume-control-black-single-wire | 405/1/198/2466 |