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 (
    98892, 100136, 100131, 100045, 100011, 
    100035, 100010, 100009, 100002, 100001, 
    99991, 99966, 99863, 99862, 99436, 
    99430, 99427, 99280, 98828, 92941
  ) 
  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.00056

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
92941 equinox-delinquents-get-up-delinquents-remix-vicious-circle 6
98828 niztrip-heresey-korruption 6
98892 lukas-ryker-cheap-boys-don-t-pay-rent-overdose-records 6
99280 nik-denton-true-blood-dawn-lee-remix-toolbox-recordings 6
99427 boris-the-noss-catalyst-original-mix-drop-bear-digital 6
99430 direct-drive-iyan-frantic-digital 6
99436 simon-williams-part-of-the-plan-fireball 6
99862 dean-richardson-you-cannot-run-global-awakening-records 6
99863 slenderman-lok-e-crooked-wrath-global-awakening-records 6
99966 dj-serenity-lets-go-energy-source-productions 6
99991 david-marsh-random-but-raw-my-calculations-fruition-records 6
100001 tara-n-kp-mr-witcher-sugar-skull-digital 6
100002 mr.mr-do-you-really-like-it-indecision-audio 6
100009 boris-the-noss-twisted-timetrip-black-dog-records 6
100010 gary-o-connor-the-story-digital-snail 6
100011 dj-serenity-time-to-party-energy-source-productions 6
100035 eufex-little-miss-natalie-clausura-buzz 6
100045 leigh-day-caravan-hi-five-digital 6
100131 retrobate-supercharged 6
100136 slenderman-team-sly-elements-sugar-skull-digital 6