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 (
    94351, 94332, 93035, 92516, 94682, 92885, 
    94581, 94559, 93751, 94131, 92911, 
    94523, 94521, 94520, 94519, 94518, 
    94517, 94516, 94511, 94510
  ) 
  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.00053

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
92516 a-dj-desse-barama-frantic-digital 6
92885 rouble-trouble-busta-hard-house-family 6
92911 eufex-lockstep-vicious-circle 6
93035 hilz-e-possessed-fireball 6
93751 mobi-d-nightcrawler-original-mix-bring-the-noise-recordings 6
94131 mada-deus-pitch-drift-records 6
94332 dawn-lee-k8-e-kicks-4-free-toolbox-recordings 6
94351 amp-attack-feels-good-wlhh 6
94510 kazzy-eff-martyn-b-be-real-kimara-records 6
94511 paul-luffman-leigh-day-random-but-raw-talking-money-dirty-gash-fruition-records 6
94516 nurogl-sin-sinner-burning-blade-records 6
94517 nurogl-resuscitate-nurogl-remix-burning-blade-records 6
94518 tekneak-guttural-kodokushi-records 6
94519 boski-zillin-enough-is-enough-black-dog-records 6
94520 alchemiist-hit-it-raw-power 6
94521 amp-attack-back-2-99-movin-house 6
94523 start-rockin-speak-up-records 6
94559 pete-maxwell-tom-parr-well-wishes-hi-five-digital 6
94581 homzy-take-me-away-global-awakening-records 6
94682 roosta-mumbles-i-feel-the-rush-x-ite-audio 6