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 (
    105207, 105206, 105205, 105204, 105203, 
    105202, 105201, 105200, 105199, 105198, 
    105197
  ) 
  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.00025

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

Result

product_id seo_name seo_path
105197 andy-farley-olive-grooves-feel-original-mix-tidy-en-3 4
105198 andy-farley-colin-barratt-crashed-original-mix-tidy-en 4
105199 trauma-higher-original-mix-tidy-en-7 4
105200 andy-farley-barriers-original-mix-tidy-en-6 4
105201 nik-denton-freak-right-out-original-mix-tidy 4
105202 andy-farley-the-killer-original-mix-tidy-en 4
105203 marc-johnson-hoof-nik-denton-remix-tidy 4
105204 trauma-ian-m-deep-swarm-original-mix-tidy-en-4 4
105205 defective-audio-freakin-it-original-mix-tidy-en-2 4
105206 tony-de-vit-are-you-all-ready-original-mix-tidy-en-12 4
105207 riggsy-steve-nrg-stack-the-galli-original-mix-tidy 4