{
"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": 8,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (6234,6302,6301,6303) 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 |
|---|---|---|
| 6234 | sti-go-fpak-1-vhf-kit-with-one-field-tunable-vhf-antenna-140-174-mhz | 554/3694 |
| 6301 | sti-go-fpak-1-uhf-kit-with-one-uhf-antenna-400-440-mhz | 554/3694 |
| 6302 | sti-go-fpak-1-cel-kit-with-one-field-tunable-cel-antenna-806-896mhz | 554/3694 |
| 6303 | sti-go-vtab-sf-handheld-vest-antenna-harness | 554/3694 |