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 (
    109666, 109665, 109664, 109663, 109662, 
    109661, 109660, 109659, 109658, 109657, 
    110313, 110312, 110311, 110304, 110303, 
    110302, 110301, 110300, 110299, 110298
  ) 
  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.00048

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
109657 solo-my-style-original-mix-stomp-inc-uk 22
109658 solo-let-s-go-original-mix-stomp-inc-uk 22
109659 solo-dance-floor-diva-ft-gavalar-original-mix-stomp-inc-uk 22
109660 solo-get-your-hands-up-original-mix-stomp-inc-uk 22
109661 solo-bass-drop-original-mix-stomp-inc-uk 22
109662 solo-in-the-shadows-original-mix-stomp-inc-uk 22
109663 solo-the-world-has-changed-original-mix-stomp-inc-uk 22
109664 solo-welcome-to-the-after-life-original-mix-stomp-inc-uk 22
109665 solo-be-just-fine-original-mix-stomp-inc-uk 22
109666 solo-something-wonderful-original-mix-stomp-inc-uk 22
110298 s3rl-scary-movie-kinn-remix-24-7-hardcore 22
110299 rob-iyf-al-storm-go-find-your-next-victim-original-mix-24-7-hardcore 22
110300 al-storm-trick-or-treat-rob-iyf-al-storm-remix-24-7-hardcore 22
110301 daniel-seven-y2038-exterminator-original-mix-24-7-hardcore 22
110302 dj-shimamura-d.y.l.y.h.c-2022-mix-24-7-hardcore 22
110303 sethrow-time-bomb-original-mix-24-7-hardcore 22
110304 rob-iyf-al-storm-jack-skipper-zoot-goldilox-original-mix-24-7-hardcore 22
110311 the-3eyed-work-it-original-mix-underground-industry-records 22
110312 the-3eyed-work-it-vip-underground-industry-records 22
110313 the-3eyed-work-it-mykoz-remix-underground-industry-records 22