{
"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 (64941,62258,60732,60733,60737,64621,61385,64942,60751,60735,64943,64339,63128,60738,62671,64340,61386,64620,64815,65519,65568,65851,65870,65875) 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 |
|---|---|---|
| 60732 | g4-gooseneck-arm | 1571/1576 |
| 60733 | g5-gooseneck-arm | 1571/1576 |
| 60735 | g7-gooseneck-arm | 1571/1576 |
| 60737 | g9-gooseneck-arm | 1571/1576 |
| 60738 | g10-gooseneck-arm | 1571/1576 |
| 60751 | g25-gooseneck-arm | 1571/1576 |
| 61385 | g34-gooseneck-arm | 1571/1576 |
| 61386 | g35-gooseneck-arm | 1571/1576 |
| 62258 | heavy-duty-cast-guard | 1571/1573 |
| 62671 | led-decorative-backing-plate-cover | 1571/1573 |
| 63128 | support-arm | 1571/1576 |
| 64339 | g64-gooseneck-arm | 1571/1576 |
| 64340 | g65-gooseneck-arm | 1571/1576 |
| 64620 | elva-led-tala-lamp | 1571/1575 |
| 64621 | globe-led-tala-lamp | 1571/1575 |
| 64815 | green-jelly-jar-glass | 1571/1573 |
| 64941 | acorn-schoolhouse-glass | 1571/1573 |
| 64942 | round-schoolhouse-glass | 1571/1573 |
| 64943 | drum-schoolhouse-glass | 1571/1573 |
| 65519 | glass-ball-globes | 1571/1573 |
| 65568 | replacement-gu24-socket-and-cord-kit | 1571/1573 |
| 65851 | led-amber-st19-250-lumen-bulb | 1920/1942/1943 |
| 65870 | led-clear-g40-500-lumen-bulb | 1920/1942/1943 |
| 65875 | led-frosted-b11-300-lumen-bulb | 1920/1942/1943 |