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 (
    104633, 104632, 104631, 104630, 104629, 
    104628, 104627, 104626, 104625, 104624, 
    104623, 104622, 104621, 104620, 104619, 
    104618, 104617, 104616, 104615, 104614
  ) 
  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.00034

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
104614 gsr-matt-clarkson-recommunicate-original-mix-hard-dance-coalition 4
104615 team-sly-i-wanna-love-original-mix-hard-dance-coalition-en 4
104616 matt-clarkson-team-sly-feat-sam-sly-find-me-original-mix-hard-dance-coalition 4
104617 team-sly-feel-right-original-mix-hard-dance-coalition 4
104618 paul-king-k8-e-go-on-gurl-original-mix-hard-dance-coalition 4
104619 unit-dvsn-the-rhythum-original-mix-hard-dance-coalition 4
104620 matt-clarkson-miric-make-you-wanna-move-original-mix-hard-dance-coalition 4
104621 equinox-flow-adam-m-remix-hard-dance-coalition-en 4
104622 paul-glazby-you-won-t-last-original-mix-hard-dance-coalition 4
104623 tom-parr-kev-pickford-vicious-original-mix-hard-dance-coalition-en 4
104624 frank-farrell-ben-stevens-mugged-off-original-mix-hard-dance-coalition-en-2 4
104625 adam-butler-back-to-earth-original-mix-hard-dance-coalition 4
104626 kaki-raphael-jackanackanory-original-mix-hard-dance-coalition 4
104627 ram-terminator-original-mix-hard-dance-coalition-en 4
104628 kaki-raphael-hotter-than-the-sun-original-mix-hard-dance-coalition 4
104629 paul-glazby-kick-it-wayne-german-remix-hard-dance-coalition-en 4
104630 kaki-raphael-comatosed-original-mix-hard-dance-coalition 4
104631 paul-glazby-hostile-scallywags-remix-hard-dance-coalition-en 4
104632 ben-stevens-abandon-traumatic-random-but-raw-remix-hard-dance-coalition-en 4
104633 best-of-2019-hard-dance-coalition 13