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 (
    101756, 101755, 101754, 101753, 101752, 
    101751, 101750, 101749, 101748, 101747, 
    101716, 101715, 101469, 101468, 101373, 
    101372, 101954, 101943, 101360, 101359
  ) 
  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.00043

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
101359 stormtrooper-are-you-ready-original-mix-rave-muzik 22
101360 stormtrooper-rock-a-hc-sound-original-mix-rave-muzik 22
101372 tatsunoshin-window-more-fkn-bass-extended-mix-oneseventy 22
101373 tatsunoshin-window-more-fkn-bass-radio-edit-oneseventy 22
101468 monny-dream-original-mix-hell-s-recordings 22
101469 monny-marihuana-original-mix-hell-s-recordings 22
101715 rob-iyf-al-storm-bass-down-low-extended-mix-24-7-hardcore 22
101716 rob-iyf-al-storm-bass-down-low-radio-mix-24-7-hardcore 22
101747 euphony-the-meaning-of-life-uk-dance-mix-24-7-hardcore 22
101748 euphony-space-invader-quest-remix-24-7-hardcore 22
101749 euphony-gimme-some-tin-96-esl-mix-24-7-hardcore 22
101750 euphony-jungle-is-massive-95-bedroom-mix-24-7-hardcore 22
101751 euphony-moove-your-body-original-mix-24-7-hardcore 22
101752 euphony-open-your-mind-original-mix-24-7-hardcore 22
101753 euphony-pumped-up-funk-98-esl-pa-mix-24-7-hardcore 22
101754 euphony-rock-the-jam-96-esl-pa-mix-24-7-hardcore 22
101755 euphony-drum-nature-clubscene-mix-24-7-hardcore 22
101756 euphony-the-flow-92-studio-demo-mix-24-7-hardcore 22
101943 kengo-quiet-pink-original-mix-justice-hardcore 22
101954 lady-dammage-the-dark-horror-loco-extended-mix-darkside-unleashed 22