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 (
    112082, 112081, 112080, 112079, 112078, 
    112077, 112076, 112075, 112074, 112073, 
    112072, 112071, 112070, 112069, 112068, 
    112067, 112066, 112065, 112064, 112063
  ) 
  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.00045

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
112063 vinylgroover-hands-up-original-mix-the-world-of-obsession-recordings-en 22
112064 apple-mac-real-high-real-fast-fracus-darwin-remix-the-world-of-obsession-recordings-en 22
112065 vinylgroover-dat-bass-extended-mix-the-world-of-obsession-recordings-en 22
112066 rick-chubbs-just-fuck-extended-mix-the-world-of-obsession-recordings-en 22
112067 rick-chubbs-acid-melody-extended-mix-the-world-of-obsession-recordings-en 22
112068 rick-chubbs-freeforming-extended-mix-the-world-of-obsession-recordings-en 22
112069 vinylgroover-shake-it-extended-mix-the-world-of-obsession-recordings-en 22
112070 sound-assassins-saved-my-life-extended-mix-the-world-of-obsession-recordings-en 22
112071 winterlake-can-t-sleep-alone-extended-mix-the-world-of-obsession-recordings-en 22
112072 vinylgroover-don-t-go-extended-mix-the-world-of-obsession-recordings-en 22
112073 winterlake-like-those-stars-extended-mix-the-world-of-obsession-recordings-en 22
112074 midas-can-t-stop-easyvibe-stompy-darren-tyler-2022-extended-remix-the-world-of-obsession-recordings-en 22
112075 aos-light-the-fire-extended-mix-the-world-of-obsession-recordings-en 22
112076 aos-live-2-b-free-extended-mix-the-world-of-obsession-recordings-en 22
112077 joe-rogers-let-me-hear-you-shout-vinylgroover-extended-remix-the-world-of-obsession-recordings-en 22
112078 winterlake-hot-on-your-heels-extended-mix-the-world-of-obsession-recordings-en 22
112079 vinylgroover-without-you-extended-mix-the-world-of-obsession-recordings-en 22
112080 samba-d-dionne-together-again-extended-mix-the-world-of-obsession-recordings-en 22
112081 artisan-us-need-to-say-i-love-you-extended-mix-the-world-of-obsession-recordings-en 22
112082 artisan-us-puzzle-pieces-extended-mix-the-world-of-obsession-recordings-en 22