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 (
    98472, 98471, 98470, 98469, 98468, 98467, 
    98430, 98392, 98377, 97901, 97817, 
    97108, 92932, 92931, 98391, 98386, 
    92930, 98380, 98379, 98378
  ) 
  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.00041

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
92930 joe-bloggs-nebulizer-vicious-circle 6
92931 tim-clewz-dimensional-vicious-circle 6
92932 tim-clewz-of-we-because-vicious-circle 6
97108 carl-pearce-cheryl-pearce-the-universe-frantic-digital 6
97817 joe-longbottom-i-never-thought-original-mix-pumped 6
97901 tara-n-bounce-original-mix-ultratech 6
98377 insanity-josh-b-josh-b-insanity-bullets-trip-the-light-fantastic 6
98378 pat-glenny-haus-musik-pitch-drift-records 6
98379 shoguns-without-leaders-burning-blade-records 6
98380 sam-e-vs-filth-furious-bang-black-dog-records 6
98386 peter-edwards-initiation-full-circle-productions 6
98391 vandalize-pete-maxwell-irregardless-hi-five-digital 6
98392 see-me-in-the-club-global-awakening-records 6
98430 kaki-raphael-20-year-old-scorcher-kaki-trax 6
98467 ross-homson-piff-paff-poff-terrabang-recordings 6
98468 ross-homson-cream-doughnut-terrabang-recordings 6
98469 ross-homson-got-the-flow-terrabang-recordings 6
98470 ross-homson-galvez-groove-terrabang-recordings 6
98471 ross-homson-clusterfunk-terrabang-recordings 6
98472 ross-homson-gold-leaf-terrabang-recordings 6