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 (
    100759, 100758, 100757, 100756, 100755, 
    100727, 100648, 100647, 100645, 99651, 
    98893, 92945, 100368, 100629, 100176, 
    100627, 100625, 100624, 100623, 100596
  ) 
  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.00042

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
92945 eufex-hit-the-beat-discam-remix-vicious-circle 6
98893 the-panama-playboys-overdose-overdose-records 6
99651 firefox-back-in-action-twisted-trax 6
100176 fat-controller-dj-deluxe-always-forever-hardcore-history 6
100368 matt-wade-marc-coyne-disco-biscuit-original-mix-hot-box-digital 6
100596 dave-holmes-samsara-ben-stevens-remix-d8-tidy 4
100623 homzy-one-for-tara-indecision-audio 6
100624 alan-james-8-15-full-circle-productions 6
100625 tara-n-pin-eyes-burning-blade-records 6
100627 boski-quantum-control-black-dog-records 6
100629 paul-clark-bruk-out-original-resurrection-digital 6
100645 sjaan-what-you-need-trip-the-light-fantastic 6
100647 kazzy-eff-martyn-b-twangerz-trip-the-light-fantastic 6
100648 kazzy-eff-martyn-b-thumpz-trip-the-light-fantastic 6
100727 cdy-panic-global-awakening-records 6
100755 dave-owens-tonight-unbounded-traxx 6
100756 random-but-raw-closed-racquet-fruition-records 6
100757 tara-n-kp-vibrationz-indecision-audio 6
100758 djone7tout-aim-to-misbehave-full-circle-productions 6
100759 boski-dave-g-emergency-broadcast-black-dog-records 6