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 (
    94159, 94158, 94157, 94156, 94155, 94154, 
    94153, 94152, 94151, 94150, 94149, 
    94148, 94147, 94145, 94144, 94143, 
    94142, 94808, 94590, 94588
  ) 
  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.00046

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
94142 bk-insane-ky-jelly-babies-remix-traffic-records-en-2 1
94143 bk-hardstep-original-mix-traffic-records-en 1
94144 bk-systematic-original-mix-traffic-records-en 1
94145 bk-ali-wilson-london-rock-original-mix-traffic-records-en 1
94147 bk-scott-attrill-microwave-original-mix-traffic-records 1
94148 cally-gage-energy-syndicate-music-is-my-life-original-mix-traffic-records 1
94149 carl-nicholson-adrenaline-technikal-remix-traffic-records 1
94150 cut-up-disco-balls-original-mix-traffic-records 1
94151 dan-kelly-born-electrik-original-mix-traffic-records 1
94152 dark-by-design-words-are-not-enough-original-mix-traffic-records-en 1
94153 dave-curtis-up-to-no-good-original-mix-traffic-records 1
94154 diablik-oyaebu-ego-suicide-original-mix-traffic-records-en 1
94155 diving-faces-liquid-child-helen-g-remix-traffic-records 1
94156 dj-generator-little-spys-original-mix-traffic-records-en-2 1
94157 dj-generator-sticky-fingers-original-mix-traffic-records 1
94158 jamie-taylor-feel-free-original-mix-traffic-records-en 1
94159 jason-cortez-magma-original-mix-traffic-records-en 1
94588 dj-bocha-superlove-original-mix-power-tracks-records 1
94590 dj-nelly-thank-u-original-mix-dnz-records 1
94808 kritikal-mass-dj-chris-davies-didgeridoo-original-mix-dnz-records 1