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 (
    98240, 98239, 98238, 98237, 98236, 98234, 
    98233, 98218, 97607, 98225, 98224, 
    98217, 98200, 98179, 98176, 98165, 
    98078, 97968, 97967, 97537
  ) 
  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.00047

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
97537 renshi-nurogl-hold-me-high-original-mix-beast-mode-recordings 6
97607 martynb-from-the-shadows-original-mix-bring-the-noise-recordings 6
97967 rebel-frequency-tom-whyld-necessary-evil-toolbox-recordings 6
97968 mada-unit-dvsn-dean-richardson-this-dream-global-awakening-records 6
98078 kazzy-eff-baby-i-trip-the-light-fantastic 6
98165 tribeaut-good-habits-tribeaut 6
98176 diss-cuss-save-the-day-andy-farley-remix-toolbox-recordings 6
98179 homzy-random-but-raw-4-the-kill-full-circle-productions 6
98200 boris-the-noss-24-7-pitch-drift-records 6
98217 buzzbass-rio-sexy-baby-tempo-trax 6
98218 dj-serenity-together-energy-source-productions 6
98224 narc-disturbed-the-torture-thing-raw-power-en 6
98225 gem-stone-chloroform-raw-power 6
98233 vennard-valentine-losing-control-hi-five-digital 6
98234 ben-vennard-what-does-a-dj-do-hi-five-digital 6
98236 ben-stevens-gary-o-connor-in-my-mind-digital-snail-en 6
98237 dave-curtis-gary-o-connor-you-make-me-digital-snail 6
98238 gary-o-connor-animalia-digital-snail-en 6
98239 gary-o-connor-fantastic-mr-fanny-fox-digital-snail 6
98240 gary-o-connor-over-the-limit-digital-snail 6