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 (
    91827, 91796, 91825, 91824, 91823, 91808, 
    91807, 91806, 91805, 91804, 91803, 
    91639, 91600, 91537, 91535, 91425, 
    91025, 90894, 90888, 90881
  ) 
  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.00045

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
90881 matt-wade-matty-tweed-blinded-original-mix-epidemic-digital 6
90888 dave-h-joe-longbottom-let-s-go-original-mix-pumped 6
90894 paul-reeves-give-it-to-me-original-mix-hot-box-digital 6
91025 boski-eternal-sleep-original-mix-ultratech 6
91425 narc-triplexxx-delusions-original-mix-drop-bear-digital 6
91535 leigh-day-paul-hunter-missing-you-hooverweight-records 6
91537 kaki-raphael-bangkok-chickboys-kaki-trax 6
91600 grady-g-pharmakia-raw-power 6
91639 will-shepherd-lee-mills-fk-god-vicious-circle 6
91796 paul-batten-featuring-daddy-old-skool-let-s-have-it-original-mix-tuff-groove-recordings 6
91803 dean-richardson-that-s-lovely-hi-five-digital 6
91804 kid-dynamo-warm-it-up-hi-five-digital-en 6
91805 dynamic-intervention-time-dip-recordings 6
91806 tara-n-wake-up-burning-blade-records 6
91807 tara-n-dust-sucker-burning-blade-records 6
91808 tekneak-the-seance-tara-n-remix-burning-blade-records 6
91823 ross-homson-the-commander-terrabang-recordings 6
91824 ross-homson-got-the-flow-2011-remix-terrabang-recordings 6
91825 ross-homson-run-for-cover-2011-remix-terrabang-recordings 6
91827 dark-by-design-dance-with-the-devil-digital-damage-recordings 6