{
"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 (62665,64301,62018,64902,62625,29983,64735,64944,64756,62575,64903,63344) 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 |
|---|---|---|
| 29983 | 1-2-and-3-4-ip-stem-ceiling-extensions | 1571/1573 |
| 62018 | chestnut-pendant-light | 1887/1888/1889 |
| 62575 | streamline-industrial-ring-sconce | 1887/1896/1899 |
| 62625 | sydney-chain-hung-pendant-light | 1887/1888/1891 |
| 62665 | lafayette-soho-4-light-chandelier | 1887/1888/2010 |
| 63344 | the-victoria-machine-age-sconce | 1887/1896/1899 |
| 64301 | the-sterling-deep-cone-reflector-3-light-post-mount-light | 1887/1904/1907 |
| 64735 | aero-stem-mount-pendant-light | 1887/1888/1890 |
| 64756 | conoco-gooseneck-light | 1887/1896/1897 |
| 64902 | acorn-schoolhouse-semi-flush-mount-light | 1887/1888/1892 |
| 64903 | acorn-schoolhouse-flush-mount-light | 2002 |
| 64944 | conoco-draftsman-wooden-top-pendant | 1887/1888/1889 |