{
"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 (61390,64687,64713,63430,61416,61624,61519,64700,61079,61411,61433,63087) 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 |
|---|---|---|
| 61079 | marathon-soho-sconce | 1887/1896/1899 |
| 61390 | streamline-industrial-guard-sconce | 1887/1896/1899 |
| 61411 | laramie-wall-sconce | 1887/1896/1899 |
| 61416 | double-market-industrial-guard-sconce | 1887/1896/1899 |
| 61433 | industrial-guard-sconce | 1887/1896/1899 |
| 61519 | barn-light-mini-eclipse-wall-sconce | 1887/1896/1899 |
| 61624 | primary-schoolhouse-sconce | 1887/1896/1899 |
| 63087 | colby-wall-sconce | 1887/1896/1899 |
| 63430 | lang-machine-age-4-light-wall-sconce | 1887/1896/1902 |
| 64687 | the-original-wall-sconce-light | 1887/1896/1899 |
| 64700 | bantam-union-wall-sconce | 1887/1896/1899 |
| 64713 | bowie-wall-sconce | 1887/1896/1899 |