{
"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": 48,
"filtered": 100,
"index_condition": "cscart_seo_names.object_id in (64078,64192,64299,64194,64182,64187,64298,64296,64184,64181,64180,64294,64193,64295,64185,64327,64191,64189,64179,64190,64300,64186,64301,64195) 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 |
|---|---|---|
| 64078 | the-original-single-post-mount-light | 1887/1904/1907 |
| 64179 | the-bomber-single-post-mount-exterior-light | 1887/1904/1907 |
| 64180 | the-aero-single-post-mount-exterior-light | 1887/1904/1907 |
| 64181 | avalon-single-post-mount-light | 1887/1904/1907 |
| 64182 | the-seaside-radial-wave-single-post-mount-exterior-light | 1887/1904/1907 |
| 64184 | the-wilcox-single-post-mount-exterior-light | 1887/1904/1907 |
| 64185 | the-union-single-post-mount-exterior-light | 1887/1904/1907 |
| 64186 | the-sterling-deep-cone-reflector-single-post-mount-exterior-light | 1887/1904/1907 |
| 64187 | the-original-double-post-mount-light | 1887/1904/1907 |
| 64189 | the-bomber-double-post-mount-exterior-light | 1887/1904/1907 |
| 64190 | the-aero-double-post-mount-exterior-light | 1887/1904/1907 |
| 64191 | the-avalon-double-post-mount-exterior-light | 1887/1904/1907 |
| 64192 | the-seaside-radial-wave-double-post-mount-exterior-light | 1887/1904/1907 |
| 64193 | the-wilcox-double-post-mount-exterior-light | 1887/1904/1907 |
| 64194 | the-union-double-post-mount-exterior-light | 1887/1904/1907 |
| 64195 | the-sterling-deep-cone-reflector-double-post-mount-exterior-light | 1887/1904/1907 |
| 64294 | the-original-triple-post-mount-light | 1887/1904/1907 |
| 64295 | the-bomber-3-light-post-mount-light | 1887/1904/1907 |
| 64296 | the-aero-3-light-post-mount-light | 1887/1904/1907 |
| 64298 | the-seaside-radial-wave-3-light-post-mount-light | 1887/1904/1907 |
| 64299 | the-wilcox-3-light-post-mount-light | 1887/1904/1907 |
| 64300 | the-union-3-light-post-mount-light | 1887/1904/1907 |
| 64301 | the-sterling-deep-cone-reflector-3-light-post-mount-light | 1887/1904/1907 |
| 64327 | the-avalon-3-light-post-mount-light-en | 1623 |