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 (
    96513, 96512, 96511, 96510, 96503, 96384, 
    96086, 95838, 94773, 95878, 96342, 
    96341, 96340, 96343, 96337, 96336, 
    96335, 96322, 96313, 96182
  ) 
  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.00059

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
94773 mick-doyle-hayley-duggan-never-give-up-frantic-digital 6
95838 jud-roper-headshot-sugar-skull-digital 6
95878 dean-richardson-stu-angus-set-you-free-original-resurrection-digital 6
96086 dean-richardson-hooligan-original-mix-hot-box-digital 6
96182 hemlock-joe-90-cue-tip-hammerheads 6
96313 tara-n-phew-fruition-records 6
96322 tekneak-nowhere-to-hide-burning-blade-records 6
96335 slenderman-saws-swords-visceral-records 6
96336 g-mix-g-s-gem-tempo-trax 6
96337 trevor-wilson-random-but-raw-bring-it-tempo-trax 6
96340 hayz-and-rick-james-go-down-hi-five-digital 6
96341 hayz-and-rick-james-transform-hi-five-digital 6
96342 hayz-and-rick-james-no-more-hi-five-digital 6
96343 ben-stevens-tenchy-moonshine-pat-glenny-hayz-remix-fireball 6
96384 jonni-bryant-clk-dreams-trip-the-light-fantastic 6
96503 substance-d-paul-luffman-random-but-raw-stop-crying-fruition-records 6
96510 boski-evilescence-black-dog-records 6
96511 tara-n-the-resistance-rework-indecision-audio 6
96512 tekneak-bass-scanner-rebooted-indecision-audio 6
96513 insidious-the-menu-kodokushi-records 6