SELECT 
  cscart_seo_names.object_id AS product_id, 
  cscart_seo_names.name AS seo_name, 
  cscart_seo_names.path AS seo_path 
FROM 
  cscart_seo_names 
WHERE 
  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
  )

Query time 0.00145

JSON explain

{
  "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)"
    }
  }
}

Result

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