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 (
    110297, 110296, 110295, 110294, 110293, 
    110292, 110291, 109632, 109631, 109630, 
    109629, 109627, 110150, 110091, 109592, 
    110153, 110152, 110151, 109581, 110038
  ) 
  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.00058

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
109581 solo-falling-down-original-mix-stomp-inc-uk 22
109592 rpl-supernova-original-mix-stomp-inc-uk 22
109627 mikey-p-gee-this-is-the-future-original-mix-stomp-inc-uk 22
109629 artisan-us-need-to-say-i-love-you-extended-mix-the-world-of-obsession-recordings 22
109630 artisan-us-puzzle-pieces-extended-mix-the-world-of-obsession-recordings 22
109631 artisan-us-take-my-hand-extended-mix-the-world-of-obsession-recordings 22
109632 hooch-face-and-ass-original-mix-the-chop-shop-digital 22
110038 tanukichi-jkll-e-coli-dirty-swing-original-mix-peacock-records 22
110091 psychoweapon-sasha-f-ground-shake-extended-mix-darkside-unleashed 22
110150 meccano-twins-this-is-no-dream-original-mix-meccano-music 22
110151 the-yakuzah-c-viruz-frenchfaces-remix-bombs-bullets-records 22
110152 the-yakuzah-the-loco-gangsters-2022-refix-bombs-bullets-records 22
110153 the-yakuzah-shake-that-defiant-remix-bombs-bullets-records 22
110291 rob-iyf-al-storm-tarantulaaargh-original-mix-24-7-hardcore 22
110292 alaguan-the-banshee-original-mix-24-7-hardcore 22
110293 eufeion-cape-fear-original-mix-24-7-hardcore 22
110294 rob-iyf-al-storm-paralysis-original-mix-24-7-hardcore 22
110295 alaguan-the-cougar-original-mix-24-7-hardcore 22
110296 darren-tyler-rob-iyf-al-storm-smoke-suckaaah-original-mix-24-7-hardcore 22
110297 teddy-boy-s-hunter-original-mix-24-7-hardcore 22