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 (
    112062, 112061, 112060, 112059, 112058, 
    112057, 112056, 112055, 112054, 112052, 
    112051, 112435, 112434, 112290, 112289, 
    112536, 112535, 112534, 112533, 112532
  ) 
  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.00039

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
112051 technikore-jts-with-no-heart-extended-mix-oneseventy 22
112052 technikore-jts-with-no-heart-radio-edit-oneseventy 22
112054 beefy-rage-signal-original-mix-the-chop-shop-digital 22
112055 vinylgroover-hurt-original-mix-the-world-of-obsession-recordings-en 22
112056 vinylgroover-sanna-hartfield-like-the-sunshine-original-mix-the-world-of-obsession-recordings-en 22
112057 vinylgroover-open-the-light-original-mix-the-world-of-obsession-recordings-en 22
112058 vinylgroover-dionne-got-me-burning-original-mix-the-world-of-obsession-recordings-en 22
112059 renegade-rave-machine-fracus-darwin-remix-the-world-of-obsession-recordings-en 22
112060 rick-chubbs-raveform-original-mix-the-world-of-obsession-recordings-en 22
112061 vinylgroover-mc-freestyle-bassface-original-mix-the-world-of-obsession-recordings-en 22
112062 vinylgroover-sanna-hartfield-mike-reverie-like-the-sunshine-mike-reverie-remix-the-world-of-obsession-recordings-en 22
112289 kel-x-cyte-like-this-original-mix-scarred-digital 22
112290 kel-x-cyte-heaven-on-earth-ade-square-remix-scarred-digital 22
112434 streiks-kratchs-give-a-f-ck-extended-mix-darkside-unleashed 22
112435 streiks-kratchs-mashed-up-extended-mix-darkside-unleashed 22
112532 hoodzie-shine-stomp-mix-tryed-n-tested 22
112533 hoodzie-take-me-original-mix-tryed-n-tested 22
112534 hoodzie-i-m-the-devil-alton-towers-mix-tryed-n-tested-en 22
112535 hoodzie-v-star-waking-up-original-mix-tryed-n-tested-en 22
112536 hoodzie-i-am-the-party-original-mix-tryed-n-tested-en 22