{
"query_block": {
"select_id": 1,
"table": {
"table_name": "cscart_seo_names",
"access_type": "range",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "dispatch",
"key_length": "210",
"used_key_parts": [
"dispatch",
"object_id",
"type",
"lang_code",
"company_id"
],
"rows": 24,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (60751,65529,64869,65649,60735,65590,64943,64339,65467,65558,63128,65686) 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 |
|---|---|---|
| 60735 | g7-gooseneck-arm | 1571/1576 |
| 60751 | g25-gooseneck-arm | 1571/1576 |
| 63128 | support-arm | 1571/1576 |
| 64339 | g64-gooseneck-arm | 1571/1576 |
| 64869 | aero-vented-chain-hung-pendant-light | 2002 |
| 64943 | drum-schoolhouse-glass | 1571/1573 |
| 65467 | rochester-vintage-industrial-flush-mount-light | 1646 |
| 65529 | the-original-flush-mount-pendant-light-24-and-28 | 1887/1888/1892 |
| 65558 | loma-adjustable-wall-sconce | 1887/1896/1900 |
| 65590 | lovell-wall-sconce | 1887/1896/1899 |
| 65649 | sinclair-flush-mount-light | 1887/1888/1892 |
| 65686 | barn-light-basics-the-original-warehouse-pendant-light | 1614 |