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 (
    103819, 103818, 103817, 103816, 103815, 
    103814, 103813, 103812, 103811, 103810, 
    103809, 103808, 103807, 103864, 103863, 
    103862, 103861, 103860, 103859, 103858
  ) 
  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 40 Using where

Result

product_id seo_name seo_path
103807 amber-d-attack-warning-the-sound-original-mix-tidy-en-3 4
103808 judge-jules-bk-i-don-t-know-original-mix-tidy-en 4
103809 colin-barratt-phil-york-stronger-original-mix-tidy-en-3 4
103810 sam-townend-jon-bw-scream-for-daddy-original-mix-tidy-en-4 4
103811 colin-barratt-ali-wilson-clueless-original-mix-tidy 4
103812 base-graffiti-freakin-it-original-mix-tidy 4
103813 carl-nicholson-shining-original-mix-tidy 4
103814 jason-cortez-finally-original-mix-tidy 4
103815 colin-barratt-out-of-control-original-mix-tidy 4
103816 anne-savage-vinylgroover-the-red-hed-the-pod-original-mix-tidy 4
103817 frank-farrell-dokalis-original-mix-tidy 4
103818 amber-d-voodoo-original-mix-tidy-en-2 4
103819 tony-de-vit-i-don-t-care-leigh-green-steve-o-brady-remix-tidy-en-3 4
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
103864 ultimate-tidy-downunder-tidy 13