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 (
    103946, 103945, 103944, 103943, 103942, 
    103941, 103940, 103939, 103938, 103937
  ) 
  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.00030

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

Result

product_id seo_name seo_path
103937 rob-tissera-vinylgroover-the-red-hed-stay-lee-haslam-remix-tidy-en-2 3
103938 lee-haslam-liberate-original-mix-tidy-en-3 3
103939 matar-feeling-guyver-remix-tidy-en-4 3
103940 yoda-inc.-definitely-mixed-lee-haslam-remix-tidy 3
103941 enermatic-mastermind-original-mix-tidy-en-2 3
103942 euphony-carte-blanche-original-mix-tidy-en-3 3
103943 steve-blake-expression-lee-pasch-remix-tidy-en-2 4
103944 billy-daniel-bunter-a-project-can-t-wait-lee-haslam-remix-tidy 4
103945 barely-legal-the-future-guyver-remix-tidy-en 4
103946 lee-haslam-here-comes-the-pain-euphony-remix-tidy-en 4