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 (
    104248, 104288, 104287, 102289, 102288, 
    102287, 102286, 102285, 102284, 102283, 
    102282, 102278, 104481, 104480, 104479, 
    104478, 104477, 104476, 104475, 104474
  ) 
  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.00042

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
102278 rob-iyf-al-storm-whizzkid-blow-the-house-down-extended-mix-voodoo-panda 22
102282 eufeion-new-day-extended-mix-24-7-hardcore 22
102283 eufeion-new-day-radio-mix-24-7-hardcore 22
102284 eufeion-maze-runner-extended-mix-24-7-hardcore 22
102285 eufeion-maze-runner-radio-mix-24-7-hardcore 22
102286 eufeion-conquer-the-world-extended-mix-24-7-hardcore 22
102287 eufeion-conquer-the-world-radio-mix-24-7-hardcore 22
102288 eufeion-speaking-in-silence-extended-mix-24-7-hardcore 22
102289 eufeion-speaking-in-silence-radio-mix-24-7-hardcore 22
104248 d-tempo-dance-with-the-devil-original-mix-hell-s-recordings 22
104287 tambat-losing-you-extended-mix-oneseventy 22
104288 tambat-losing-you-radio-edit-oneseventy 22
104474 edub-contagious-madness-fakers-original-mix-motormouth-recordz 22
104475 dolphin-alright-original-mix-motormouth-recordz 22
104476 dataklysm-rave-resistance-tugie-wave-molester-remix-motormouth-recordz 22
104477 khaoz-engine-nuke-cop-killer-original-mix-motormouth-recordz 22
104478 detest-back-to-the-motherfucking-matt-green-as-sieben-stein-gb-rmx-motormouth-recordz-en 22
104479 hellfish-bryan-fury-black-alert-original-mix-motormouth-recordz 22
104480 deathmachine-kick-force-original-mix-motormouth-recordz-en 22
104481 doormouse-spring-break-forever-original-mix-motormouth-recordz-en 22