{
"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 (64179,62187,60825,62022,64275,63757,63343,64277,61456,64190,60798,60914) 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 |
|---|---|---|
| 60798 | aero-studio-light | 2002 |
| 60825 | marathon-studio-light | 1887/1888/1889 |
| 60914 | barn-light-hang-straight-ceiling-canopy | 1571/1573 |
| 61456 | mercury-8-light-chandelier | 1887/1888/2010 |
| 62022 | chestnut-wall-sconce | 1887/1896/1899 |
| 62187 | the-original-retro-desk-lamp | 1887/1909/1910 |
| 63343 | blaylock-machine-age-sconce | 1887/1896/1899 |
| 63757 | atomic-topless-dual-sconce | 1887/1896/1899 |
| 64179 | the-bomber-single-post-mount-exterior-light | 1887/1904/1907 |
| 64190 | the-aero-double-post-mount-exterior-light | 1887/1904/1907 |
| 64275 | gladstone-swing-arm-sconce | 1887/1896/1901 |
| 64277 | fluted-shade-swing-arm-sconce | 1887/1896/1901 |