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 (
    103655, 103654, 103653, 103652, 103651, 
    103650, 103649, 103648, 103647, 103646, 
    103645, 103644, 103643, 103642, 103641, 
    103640, 103639, 103638
  ) 
  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.00042

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_seo_names range PRIMARY,dispatch PRIMARY 210 36 Using where

Result

product_id seo_name seo_path
103638 colin-barratt-phil-york-stronger-original-mix-tidy-en-2 4
103639 organ-donors-vinylgroover-techno-shock-original-mix-tidy-en 1
103640 ali-wilson-matt-smallwood-i-ll-take-you-there-original-mix-tidy-en-2 4
103641 the-tidy-boys-bk-shadows-original-mix-tidy-en-3 4
103642 euphonic-sessions-shindig-kronos-remix-tidy-en 4
103643 lox-dark-by-design-strapped-in-original-mix-tidy-en 4
103644 flashheadz-wizards-of-the-sonic-original-mix-tidy-en-5 4
103645 captain-tinrib-sol-ray-attack-of-the-50-foot-dj-original-mix-tidy-en-2 4
103646 jon-bw-alpha-original-mix-tidy-en-2 4
103647 shaun-m-abandon-another-man-s-language-original-mix-tidy-en-3 4
103648 paul-maddox-feelin-94-original-mix-tidy-en 4
103649 lee-pasch-i-don-t-need-you-base-graffiti-remix-tidy-en 4
103650 gaz-west-playing-with-fire-original-mix-tidy-en 4
103651 wid-ben-p01nt-blank-original-mix-tidy-en-3 3
103652 chris-c-madam-zu-ben-kaye-fierce-the-lovetribe-theme-original-mix-tidy-en 4
103653 guyver-persistence-original-mix-tidy-en-3 4
103654 ingo-caroline-banx-a-paradox-original-mix-tidy-en-2 4
103655 flashheadz-who-wins-original-mix-tidy-en-2 4