{
"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": 90,
"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,65853,65864,65877,65874,65863,65869,65868,65862,65850,65880,65852,65855,65854,65866,65857,65876,65858,65856,65860,65859,65861) 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 |
| 65850 | led-clear-st19-250-lumen-bulb | 1920/1942/1943 |
| 65851 | led-amber-st19-250-lumen-bulb | 1920/1942/1943 |
| 65852 | led-smoky-st19-150-lumen-bulb | 1920/1942/1943 |
| 65853 | led-clear-g40-250-lumen-bulb | 1920/1942/1943 |
| 65854 | led-clear-a50-300-lumen-bulb | 1920/1942/1943 |
| 65855 | led-amber-a50-300-lumen-bulb | 1920/1942/1943 |
| 65856 | led-smoky-a50-150-lumen-bulb | 1920/1942/1943 |
| 65857 | led-clear-g63-300-lumen-bulb | 1920/1942/1943 |
| 65858 | led-amber-g63-300-lumen-bulb | 1920/1942/1943 |
| 65859 | led-smoky-g63-150-lumen-bulb | 1920/1942/1943 |
| 65860 | led-smoky-ombre-e53-110-lumen-bulb | 1920/1942/1943 |
| 65861 | led-double-layer-g40-250-lumen-bulb | 1920/1942/1943 |
| 65862 | led-ribbed-r32-500-lumen-bulb | 1920/1942/1943 |
| 65863 | led-crystal-clear-c35-500-lumen-bulb | 1920/1942/1943 |
| 65864 | led-amber-t10-450-lumen-bulb | 1920/1942/1943 |
| 65866 | led-clear-a19-1150-lumen-bulb | 1920/1942/1943 |
| 65868 | led-silver-bowl-g25-400-lumen-bulb | 1920/1942/1943 |
| 65869 | led-clear-g25-350-lumen-bulb | 1920/1942/1943 |
| 65870 | led-clear-g40-500-lumen-bulb | 1920/1942/1943 |
| 65874 | led-clear-b11-200-lumen-bulb | 1920/1942/1943 |
| 65875 | led-frosted-b11-300-lumen-bulb | 1920/1942/1943 |
| 65876 | led-clear-b11-500-lumen-bulb | 1920/1942/1943 |
| 65877 | led-clear-b11-500-lumen-bulb-e26-base | 1920/1942/1943 |
| 65880 | led-silver-bowl-a19-700-lumen-bulb | 1920/1942/1943 |