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 (
    96060, 95699, 95231, 93055, 89231, 96061, 
    95337, 92918, 96004, 96003, 96002, 
    95999, 95972, 95837, 95802, 95740, 
    95700, 95697, 95062, 95040
  ) 
  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.00061

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
89231 mr-bear-dave-owens-pinky-the-brain-original-resurrection-digital 6
92918 tenchy-jeff-payne-the-sizzler-vicious-circle 6
93055 amp-attack-adrenaline-junky-vicious-circle 6
95040 joe-longbottom-fidget-pants-original-mix-pumped 6
95062 boski-eternal-sleep-vadermonkey-remix-ultratech 6
95231 rick-james-make-ya-jump-original-mix-pumped 6
95337 rick-james-work-together-original-mix-bring-the-noise-recordings 6
95697 leighton-smith-damien-blanes-organik-unbounded-traxx 6
95699 leeroy-if-only-original-mix-drop-bear-digital 6
95700 jonni-bryant-v-baseglitz-viral-rhythm-trip-the-light-fantastic 6
95740 shane-rhyno-high-on-life-emmanating-records 6
95802 homzy-proxima-b-global-awakening-records 6
95837 kez-drake-liddell-you-broke-me-sugar-skull-digital 6
95972 valex-dave-owens-put-it-on-me-nitrox 6
95999 roosta-blinding-x-ite-audio 6
96002 legion-calling-cue-black-dog-records 6
96003 random-but-raw-sinobe-everyone-wants-fruition-records 6
96004 random-but-raw-sinobe-for-a-kick-fruition-records 6
96060 paul-hunter-lost-mind-global-awakening-records 6
96061 aron-hammond-moving-on-hi-five-digital 6