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 (
    97698, 97697, 97696, 97695, 97669, 97655, 
    97558, 97393, 96323, 96738, 89235, 
    97593, 97584, 97095, 97094, 97582, 
    97562, 97561, 97511, 94776
  ) 
  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.00044

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
89235 andy-farley-matt-pickup-kneed-your-growler-original-resurrection-digital 6
94776 daiv-morrish-love-is-blind-frantic-digital 6
96323 lo-pan-faith-hammerheads 6
96738 james-nardi-feat-kenei-b-tears-scorpion-trax 6
97094 jason-nawty-laura-skelton-p.l.u.r.-peace-love-unity-respect-vocal-mix-bring-the-noise-recordings 6
97095 jason-nawty-laura-skelton-p.l.u.r.-peace-love-unity-respect-instrumental-mix-bring-the-noise-recordings 6
97393 tara-n-for-me-us-everyone-hooverweight-records 6
97511 homzy-fall-forward-global-awakening-records 6
97558 ben-warren-rooms-hot-wlhh 6
97561 tara-n-not-superior-burning-blade-records 6
97562 boski-bizarre-q-i-m-one-of-them-indecision-audio 6
97582 eufex-chained-tom-whyld-remix-buzz 6
97584 dj-serenity-u-wanna-play-energy-source-productions 6
97593 digital-mafia-danny-clark-feelings-hi-five-digital 6
97655 dean-richardson-paul-hunter-clear-your-mind-global-awakening-records 6
97669 karl-davies-wayne-g-bad-shit-tempo-trax 6
97695 homzy-vs-random-but-raw-let-us-all-unite-full-circle-productions 6
97696 boski-machine-gun-hoover-sugar-skull-digital 6
97697 dexitron-acetate-dip-recordings 6
97698 dexitron-drop-the-needle-dip-recordings 6