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 (
    103857, 103856, 103855, 103854, 103853, 
    103852, 103851, 103850, 103849, 103848, 
    103847, 103846, 103845, 103844, 103843, 
    103842, 103841, 103840, 103839, 103838
  ) 
  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.00065

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
103838 flashheadz-wizards-of-the-sonic-original-mix-tidy-en-6 4
103839 jon-bishop-in-control-colin-barratt-remix-tidy-en-2 4
103840 trauma-higher-original-mix-tidy-en-4 4
103841 nick-rowland-be-alive-original-mix-tidy-en-4 4
103842 hyperlogic-only-me-stimulant-djs-remix-tidy-en-9 4
103843 ingo-ready-4-dis-original-mix-tidy-en-5 4
103844 lee-pasch-hybridize-original-mix-tidy-en-5 4
103845 colin-barratt-phil-york-stronger-original-mix-tidy-en-4 4
103846 psyclone-good-side-andy-farley-remix-tidy-en-6 4
103847 lisa-lashes-what-can-you-do-4-me-tidy-boys-remix-tidy-en-2 4
103848 stimulator-take-off-original-mix-tidy-en-5 3
103849 od404-9-bar-dark-by-design-remix-tidy 4
103850 organ-donors-turntablism-original-mix-tidy-en-5 4
103851 dutch-courage-slammin-flash-harry-remix-tidy 4
103852 colin-barratt-critical-mass-original-mix-tidy-en-2 4
103853 carl-nicholson-blueprint-tara-s-theme-original-mix-tidy-en-6 3
103854 heaven-s-cry-til-tears-do-us-part-stimulant-djs-remix-tidy-en 4
103855 guyver-serious-sound-original-mix-tidy-en-6 3
103856 lee-haslam-music-is-the-drug-original-mix-tidy-en-7 3
103857 guyver-man-on-the-moon-original-mix-tidy-en-9 3