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 (
    103863, 103862, 103861, 103860, 103859, 
    103858, 103857, 103856, 103855, 103854, 
    103853, 103852, 103851, 103850, 103849, 
    103848, 103847, 103846, 103845, 103844, 
    103843, 103842, 103841, 103840, 103839, 
    103838, 103837, 103836, 103835
  ) 
  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.00046

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

Result

product_id seo_name seo_path
103835 kutski-nightmare-man-original-mix-tidy-en 1
103836 nr2-i-want-it-original-mix-tidy 4
103837 lee-pasch-emotion-original-mix-tidy-en-5 3
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
103858 tony-de-vit-the-dawn-paul-janes-remix-tidy-en-6 4
103859 anne-savage-hellraiser-original-mix-tidy-en-5 4
103860 paul-maddox-in-it-for-kicks-original-mix-tidy-en-2 4
103861 tony-de-vit-are-you-all-ready-original-mix-tidy-en-7 4
103862 tony-de-vit-i-don-t-care-original-mix-tidy-en-7 4
103863 guyver-differences-original-mix-tidy-en-2 3