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 (
    94130, 94129, 92909, 94092, 94091, 94090, 
    94089, 94048, 93759, 93510, 93264, 
    93263, 93262, 93261, 93260, 93259, 
    93258, 89226, 93946, 93940
  ) 
  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.00132

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
89226 mr-bear-let-it-hit-em-original-resurrection-digital 6
92909 jody-6-dance-m.fs-vicious-circle 6
93258 danny-gibson-mint-beat-radio-edit-cheeky-tracks 6
93259 danny-gibson-rush-radio-edit-cheeky-tracks 6
93260 danny-gibson-2-hard-radio-edit-cheeky-tracks 6
93261 danny-gibson-2-hard-original-mix-cheeky-tracks 6
93262 danny-gibson-rush-original-mix-cheeky-tracks 6
93263 danny-gibson-mint-beat-original-mix-cheeky-tracks 6
93264 stuartm-one-dance-original-mix-hot-box-digital 6
93510 mobi-d-the-outer-limits-frantic-digital 6
93759 the-prophet-get-a-grip-original-mix-tuff-groove-recordings 6
93940 homzy-mada-darkness-global-awakening-records 6
93946 jason-nawty-back-again-hi-five-digital 6
94048 ross-farley-gun-smoke-visceral-records 6
94089 random-but-raw-pick-up-vibes-orrible-noize 6
94090 chaney-nightmares-bitch-fruition-records 6
94091 boski-screaming-jim-black-dog-records 6
94092 dj-serenity-be-with-you-energy-source-productions 6
94129 pat-glenny-ben-vennard-rupture-pitch-drift-records 6
94130 pat-glenny-ben-vennard-rupture-pitch-drift-records-en 6