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 (
    94262, 93316, 95080, 94904, 94798, 94060, 
    92913, 94880, 94870, 94869, 94867, 
    94821, 94759, 94686, 94017, 94016, 
    94015, 94014, 94013, 94012
  ) 
  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.00038

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
92913 james-nardi-ostyn-asylum-vicious-circle 6
93316 babzookaz-venus-frantic-digital 6
94012 rebel-frequency-pump-the-alarm-original-mix-alien-technology 6
94013 rebel-frequency-lift-off-original-mix-alien-technology 6
94014 distorted-robocops-rock-n-roll-original-mix-alien-technology 6
94015 rebel-frequency-mad-man-original-mix-alien-technology 6
94016 drome-view-killaz-in-no-sense-defective-audio-remix-alien-technology 6
94017 reloaded-alien-technology 6
94060 noath-the-truth-original-mix-innergize-records 6
94262 kid-dynamo-love-so-deep-radio-edit-cheeky-tracks 6
94686 paul-hunter-malagasy-bezerk 6
94759 mickey-bo-mickey-g-back-on-track-superfly 6
94798 pat-glenny-muttz-don-t-need-you-pitch-drift-records 6
94821 cupra-paul-batten-abomination-original-mix-tuff-groove-recordings 6
94867 random-but-raw-put-it-on-fruition-records 6
94869 gravediggin-visceral-records 6
94870 boski-tekneak-volatile-horn-black-dog-records 6
94880 amp-attack-spiritual-thing-movin-house 6
94904 a-dj-felt-that-hi-five-digital 6
95080 djserenity-can-you-feel-it-energy-source-productions 6