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 (
    91821, 92682, 89223, 92807, 92769, 92768, 
    92767, 92760, 92759, 92757, 92256, 
    92572, 92523, 92280, 92259, 92237, 
    92674, 92571, 92524, 92460
  ) 
  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.00060

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
89223 matt-pickup-booth-riggsy-strange-morning-resurrection-digital 6
91821 inner-city-sumo-look-back-frantic-digital 6
92237 dean-richardson-another-half-original-mix-global-hard-house 6
92256 renshi-lick-it-original-mix-beast-mode-recordings 6
92259 team-sly-bizarre-q-losing-your-head-original-mix-hot-box-digital 6
92280 simon-williams-free-your-mind-fireball 6
92460 jay-lyth-vs-cupra-belt-up-slingshot 6
92523 g.w.r.-paper-tiger-sugar-skull-digital 6
92524 bryn-whiting-the-devils-opinion-hi-five-digital 6
92571 base-graffiti-band-saw-suzy-kaktai-records 6
92572 andy-naylor-sweat-vicious-circle 6
92674 ross-farley-nurogl-slenderman-linkin-speaks-visceral-records 6
92682 puddle-of-pumping-kickin-in-the-beat-dirtyboy-productions 6
92757 tomcat-state-of-motion-pat-glenny-remix-kaktai-records 6
92759 od404-9bar-weekend-mix-kaktai-records 6
92760 lo-pan-joyful-destruction-burning-blade-records 6
92767 hayz-and-rick-james-keep-on-hi-five-digital 6
92768 hayz-and-rick-james-move-ya-body-hi-five-digital 6
92769 hayz-and-rick-james-to-da-beat-hi-five-digital 6
92807 random-but-raw-drone-on-fruition-records 6