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 (
    105210, 105209, 105250, 105249, 105248, 
    105247, 105246, 105245, 105244, 105243, 
    105242, 105241, 105240, 105208, 105207, 
    105206, 105205, 105204, 105203, 105202
  ) 
  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.00057

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
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
105208 tidy-weekender-10-the-mission-andy-farley-tidy 13
105209 andy-farley-nick-sentience-checkmate-original-mix-tidy 4
105210 bk-nick-sentience-here-it-comes-original-mix-tidy 4
105240 defective-audio-beat-freak-original-mix-tidy 4
105241 steve-maynard-wmd-bust-that-original-mix-tidy 4
105242 andy-farley-burn-it-up-original-mix-tidy-en 4
105243 karl-davis-wmd-skoolz-out-captain-tinrib-remix-tidy 4
105244 munkjack-churchill-original-mix-tidy 4
105245 rr-fierce-you-don-t-know-original-mix-tidy 4
105246 steve-maynard-wmd-follow-the-leader-original-mix-tidy 4
105247 dj-opel-wmd-only-one-original-mix-tidy 4
105248 defective-audio-control-fx-original-mix-tidy 4
105249 hyperlogic-only-me-stimulant-djs-remix-tidy-en-13 4
105250 tidy-weekender-10-the-mission-jp-jukesy-tidy 13