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 (
    93938, 92908, 92679, 93934, 93931, 93930, 
    93929, 93927, 93907, 93906, 93905, 
    93902, 93796, 93784, 93544, 93459, 
    93069, 93068, 93797, 93774
  ) 
  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
92679 james-dub-the-hospital-fireball 6
92908 paul-glazby-loventi-vicious-circle 6
93068 brysi-grapey-4-o-clock-in-the-morning-kirk-p-radio-edit-cheeky-tracks 6
93069 brysi-grapey-4-o-clock-in-the-morning-kirk-p-remix-cheeky-tracks 6
93459 the-hoover-jocks-all-night-raving-original-mix-hot-box-digital 6
93544 gsr-gsr-tough-guy-ode-to-snoopy-lockdown-mix-wlhh 6
93774 paul-clark-razmatazz-hi-five-digital 6
93784 m-series-vs-hayz-eton-mess-kimara-records 6
93796 damien-blanes-sinner-or-saint-unbounded-traxx 6
93797 james-nardi-burning-inside-scorpion-trax 6
93902 pete-warwick-locked-up-sugar-skull-digital 6
93905 kumite-northern-rain-bezerk 6
93906 lance-beneath-the-lasers-toolbox-recordings 6
93907 paul-reeves-hoover-my-dirty-playroom-visceral-records 6
93927 random-but-raw-deep-down-helix-recordings 6
93929 tekneak-ripped-to-pieces-kodokushi-records 6
93930 tara-n-tekneak-into-the-fire-indecision-audio 6
93931 tara-n-home-of-the-bewildered-indecision-audio 6
93934 gary-o-connor-shine-digital-snail 6
93938 aynsley-byrne-touch-me-tempo-trax 6