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 (
    103805, 103804, 103803, 103802, 103801, 
    103800, 103799, 103798, 103797, 103796, 
    103795, 103794, 103793, 103792
  ) 
  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.00043

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

Result

product_id seo_name seo_path
103792 12-inch-thumpers-don-t-cross-the-line-olive-grooves-remix-tidy-en-3 4
103793 paul-maddox-feelin-94-original-mix-tidy-en-2 4
103794 untidy-dubs-show-the-people-original-mix-tidy-en 4
103795 andy-farley-olive-grooves-feel-original-mix-tidy-en-2 4
103796 jon-bw-cutting-shapes-original-mix-tidy-en 4
103797 sam-townend-jon-bw-scream-for-daddy-original-mix-tidy-en-3 4
103798 kym-ayres-technikal-more-more-untidy-dub-tidy-en-2 4
103799 omega-3-what-we-waiting-for-vox-go-remix-tidy-en 4
103800 olive-grooves-organ-grinder-original-mix-tidy-en 4
103801 organ-donors-turntablism-original-mix-tidy-en-4 4
103802 untidy-dubs-feel-alright-original-mix-tidy 4
103803 andy-farley-barriers-original-mix-tidy-en-5 4
103804 sam-townend-jon-bw-how-can-i-love-you-take-you-back-original-mix-tidy-en-2 4
103805 rumble-maddox-party-people-original-mix-tidy-en-6 4