{
"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 (61694,61466,58117,60120,62060,62230,64351,59417,64350,61528,61081,61468) 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 |
|---|---|---|
| 58117 | industrial-loft-double-pendant | 1887/1888/1890 |
| 59417 | retro-basic-porcelain-and-galvanized-pendant | 1887/1888/1890 |
| 60120 | the-original-3-light-stem-mount-pendant | 1887/1888/2010 |
| 61081 | canal-soho-sconce | 1887/1896/1899 |
| 61466 | apollo-5-light-chandelier | 1887/1888/2010 |
| 61468 | the-saturn-vega-4-light-chandelier | 1887/1888/2010 |
| 61528 | union-industrial-guard-post-mount-light | 1887/1904/1908 |
| 61694 | canal-stem-mount-pendant-light | 1887/1888/1890 |
| 62060 | aero-vented-pendant-light | 1887/1888/1889 |
| 62230 | parabolic-3-light-chandelier | 1887/1888/1894 |
| 64350 | downtown-minimalist-stem-mount-pendant | 1887/1888/1890 |
| 64351 | bubble-5-light-chandelier | 1887/1888/2010 |