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 (
    98376, 98365, 98364, 98362, 98353, 98226, 
    98177, 97708, 97684, 97679, 97678, 
    97664, 98178, 98267, 98266, 98265, 
    98264, 98263, 98262, 98261
  ) 
  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.00039

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
97664 gary-o-connor-animalia-digital-snail 6
97678 alpha-a-this-world-original-mix-epidemic-digital 6
97679 alpha-a-get-mad-original-mix-epidemic-digital 6
97684 jay-goodall-legion-crooks-original-mix-epidemic-digital 6
97708 drake-liddell-break-life-original-mix-pumped 6
98177 andy-farley-ross-homson-bmf-ram-remix-toolbox-recordings 6
98178 mobi-d-power-junkie-bass-jumper-remix-resurrection-digital 6
98226 tekneak-i-stay-awake-global-awakening-records 6
98261 gary-o-connor-discam-big-d-ck-the-bass-digital-snail-en 6
98262 gary-o-connor-wayne-smart-kokaine-digital-snail-en 6
98263 henry-trotton-charlie-the-hoover-factory-digital-snail 6
98264 team-gb-going-for-gold-200m-mix-digital-snail-en 6
98265 the-pet-detectives-molehill-ode-to-joel-digital-snail-en 6
98266 the-snail-another-chance-digital-snail-en 6
98267 the-snail-u-aye-digital-snail-en 6
98353 boris-the-noss-rave-eat-frisky 6
98362 tara-n-cactus-sugar-skull-digital 6
98364 dynamic-intervention-rich-gordi-move-it-2001-original-mix-dip-recordings 6
98365 dynamic-intervention-rich-gordi-move-it-wayne-g-remix-dip-recordings 6
98376 mada-taste-the-acid-full-circle-productions 6