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 (
    98339, 97666, 98898, 89236, 98794, 98793, 
    98791, 98393, 98772, 98771, 98769, 
    98736, 98734, 98672, 98622, 98523, 
    98170, 92934, 98770, 98161
  ) 
  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.00054

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_seo_names range PRIMARY,dispatch PRIMARY 210 40 Using where

Result

product_id seo_name seo_path
89236 matt-pickup-mini-minx-frizz-bomb-original-resurrection-digital 6
92934 pat-glenny-gary-cooke-the-gromble-vicious-circle 6
97666 gary-o-connor-it-s-not-the-same-honestly-it-s-not-ben-stevens-remix-digital-snail 6
98161 spyndl-spread-ur-wings-original-mix-immortal-noise-recordings 6
98170 joe-longbottom-i-lift-you-up-original-mix-pumped 6
98339 lok-e-vadermonkey-broken-toys-original-mix-epidemic-digital 6
98393 paul-clark-clk-house-is-a-feeling-original-mix-bring-the-noise-recordings 6
98523 riksta-random-but-raw-o-my-dirtyboy-productions 6
98622 lucy-fur-shake-it-up-lucy-fur-bass-jumper-emix-toolbox-recordings 6
98672 naughty-tempo-flying-high-global-awakening-records 6
98734 gaz-f-ginge-p.a-amazonian-darkness-frantic-digital 6
98736 valex-save-me-damien-blanes-remix-bezerk 6
98769 toxic-toadz-random-but-raw-remix-burning-blade-records 6
98770 teck071-buttered-chops-kodokushi-records 6
98771 karl-davies-jase-h-house-in-for-the-kill-pitch-drift-records 6
98772 pretty-handsome-pretty-handsome-pitch-drift-records 6
98791 jud-roper-bells-hi-five-digital 6
98793 jud-roper-acid-staircase-hi-five-digital 6
98794 zillin-kevlaar-hard-to-breathe-full-circle-productions 6
98898 pat-glenny-desolate-pitch-drift-records 6