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 (
    92910, 92680, 94278, 94277, 94276, 94207, 
    94191, 94140, 93939, 93932, 93760, 
    93525, 93451, 93346, 94187, 94185, 
    94184, 94183, 93378, 94141
  ) 
  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.00048

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
92680 mada-if-you-know-fireball 6
92910 matt-clarkson-pure-intoxication-vicious-circle 6
93346 renshi-nurogl-bang4bucks-original-mix-beast-mode-recordings 6
93378 ben-kaye-star-girl-original-mix-bring-the-noise-recordings 6
93451 tom-stock-damien-blanes-bumper-hammerheads 6
93525 dean-richardson-the-moment-original-mix-global-hard-house 6
93760 brow-hoi-polloi-tuff-groove-recordings 6
93932 grady-g-freak-classic-grady-g-twisted-trax 6
93939 dean-richardson-crowded-world-tempo-trax 6
94140 dark-suspects-diva-trip-the-light-fantastic-en 6
94141 amp-attack-gender-blender-ross-homson-remix-terrabang-recordings 6
94183 leigh-day-unit-dvsn-tommy-hi-five-digital 6
94184 valex-james-nardi-freaks-among-monsters-dark-suspects-remix-nitrox 6
94185 valex-james-nardi-freaks-among-monsters-brendan-ashley-remix-nitrox 6
94187 james-nardi-tekneak-monster-burning-blade-records 6
94191 m-series-vs-base-22-give-it-up-kimara-records 6
94207 slenderman-these-eyes-visceral-records 6
94276 paul-luffman-random-but-raw-frack-off-nikkdbubble-remix-fruition-records 6
94277 carl-pearce-cheryl-pearce-operatic-sugar-skull-digital 6
94278 homzy-ice-cold-global-awakening-records 6