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 (
    105217, 105216, 105215, 105214, 105213, 
    105212, 105211, 105210, 105209
  ) 
  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.00028

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

Result

product_id seo_name seo_path
105209 andy-farley-nick-sentience-checkmate-original-mix-tidy 4
105210 bk-nick-sentience-here-it-comes-original-mix-tidy 4
105211 allnighters-black-is-black-original-mix-tidy-en-2 4
105212 od404-let-me-tell-you-something-original-mix-tidy 4
105213 steve-thomas-higher-original-mix-tidy 4
105214 cortina-music-is-movin-bk-dbm-amber-mix-tidy 4
105215 lisa-lashes-lookin-good-original-mix-tidy-en-8 4
105216 psyclone-good-side-andy-farley-remix-tidy-en-10 4
105217 incisions-beyond-motion-paul-glazby-paul-janes-remix-tidy 4