{
"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 (64617,60736,64615,62252,61336,62253,64614,60731,60726,60750,60734,61388) 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 |
|---|---|---|
| 60726 | g1-gooseneck-arm | 1571/1576 |
| 60731 | g3-gooseneck-arm | 1571/1576 |
| 60734 | g6-gooseneck-arm | 1571/1576 |
| 60736 | g8-gooseneck-arm | 1571/1576 |
| 60750 | g24-gooseneck-arm | 1571/1576 |
| 61336 | heavy-duty-square-backing-plate | 1571/1573 |
| 61388 | g36-adjustable-2-arm-heavy-duty-gooseneck-arm | 1571/1576 |
| 62252 | clear-jelly-jar-glass | 1571/1573 |
| 62253 | frosted-jelly-jar-glass | 1571/1573 |
| 64614 | voronoi-i-led-tala-lamp | 1571/1575 |
| 64615 | voronoi-ii-led-tala-lamp | 1571/1575 |
| 64617 | oblo-led-tala-lamp | 1571/1575 |