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 (
    100888, 100887, 100886, 100885, 100884, 
    100883, 100882, 100881, 100880, 100878, 
    100844, 100843, 100809, 100780, 100646, 
    100483, 99747, 100808, 100367, 100779
  ) 
  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
99747 mischief-duo-love-me-frantic-digital 6
100367 andy-naylor-avidure-original-mix-bring-the-noise-recordings 6
100483 spyndl-climax-original-mix-immortal-noise-recordings 6
100646 l.a.b.-don-t-get-scared-trip-the-light-fantastic 6
100779 tekneak-revenge-kodokushi-records 6
100780 jay-key-jus-do-another-one-visceral-records 6
100808 m-series-side-effects-kimara-records 6
100809 dean-richardson-nice-global-awakening-records 6
100843 tribeaut-make-a-wish-tribeaut 6
100844 agent-jack-the-snail-u-got-my-glove-slingshot-en 6
100878 tara-n-really-don-t-matter-full-circle-productions 6
100880 niztrip-teddy-bear-black-dog-records 6
100881 triac-ride-the-wave-indecision-audio 6
100882 gary-o-connor-your-serve-toolbox-recordings 6
100883 snail-attack-awesome-e-toolbox-recordings 6
100884 the-snail-cast-a-spell-toolbox-recordings 6
100885 gary-o-connor-team-sly-don-t-ever-stop-toolbox-recordings 6
100886 gary-o-connor-all-this-love-toolbox-recordings 6
100887 gary-o-connor-what-the-fox-toolbox-recordings 6
100888 the-pet-detectives-take-it-to-the-top-toolbox-recordings 6