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 (
    103719, 103718, 103806, 103805, 103804, 
    103803, 103802, 103801, 103800, 103799, 
    103798, 103797, 103796, 103795, 103794, 
    103793, 103792, 103773, 103772, 103771
  ) 
  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.00035

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
103718 untidy-djs-colours-ep-amp-attack-multicoloured-remix-tidy 4
103719 the-handbaggers-u-found-out-scott-fo-shaw-remix-tidy 4
103771 weirdo-beyond-original-mix-tidy 4
103772 rr-fierce-k-live-yamamba-original-mix-tidy 4
103773 hard-house-designer-labels-vicious-circle-tidy 13
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
103806 hard-house-designer-labels-tidy-trax-tidy 13