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 (
    101603, 101602, 101601, 101599, 101598, 
    101596, 101595, 101594, 101593, 101592, 
    101591, 101590, 101585, 101583, 101582, 
    101544, 102132, 102131, 102130, 102129
  ) 
  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.00049

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
101544 oo-sweetman-ruben-fernandez-003-original-mix-qdance-records 4
101582 dj-veedr-digital-mafia-rhaspect-original-mix-lw-recordings 4
101583 pulse-fiction-you-can-t-tell-us-radio-edit-lw-recordings 4
101585 d-fi-dj-miss-vixen-hanging-tree-original-mix-lw-recordings 4
101590 ross-homson-clusterfunk-edit-lw-recordings 4
101591 munkjack-damien-blanes-churchill-damien-blanes-extended-remix-lw-recordings 4
101592 lo-pan-james-nardi-condor-original-mix-lw-recordings 4
101593 dj-rayne-reaction-original-mix-lw-recordings 4
101594 david-morrish-love-is-blind-radio-edit-lw-recordings 4
101595 cupra-kelly-ward-faster-original-mix-lw-recordings 4
101596 sam-e-filth-furious-down-radio-edit-lw-recordings 4
101598 inner-city-sumo-dangerous-neighbourhood-original-mix-lw-recordings 4
101599 ludo-prankin-original-mix-lw-recordings 4
101601 ben-stevens-tenchy-moonshine-pat-glenny-hayz-remix-radio-edit-lw-recordings 4
101602 damien-blanes-sinner-or-saint-original-mix-lw-recordings 4
101603 unit-dvsn-give-me-something-boski-remix-lw-recordings 4
102129 matt-capitani-equilibrium-original-mix-hard-dance-coalition 4
102130 matt-clarkson-jay-lowe-i-got-ya-rich-resonate-remix-hard-dance-coalition 4
102131 leon-allen-falling-apart-original-mix-hard-dance-coalition 4
102132 matt-clarkson-random-but-raw-judder-original-mix-hard-dance-coalition-en 4