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 (
    105261, 105260, 105259, 105258, 105257, 
    105256, 105255, 105254, 105253, 105252, 
    105251
  ) 
  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.00026

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
105251 nick-rafferty-nick-rowland-hold-that-sucker-original-mix-tidy 4
105252 the-tidy-boys-swinging-original-mix-tidy-en 4
105253 organ-donors-vinylgroover-techno-shock-original-mix-tidy 4
105254 terrence-phillip-red-alert-original-mix-tidy 4
105255 lee-pasch-emotion-original-mix-tidy-en-3 4
105256 trauma-higher-original-mix-tidy-en-9 4
105257 base-graffiti-la-crunch-original-mix-tidy-en 4
105258 bk-revolution-original-mix-tidy-en 4
105259 stimulator-play-original-mix-tidy-en-2 3
105260 k-series-binary-finary-k2-original-mix-tidy-en 4
105261 sebanelli-oddbod-your-ass-is-mine-original-mix-tidy-en-5 4