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 (
    93322, 93321, 93320, 93319, 93318, 93307, 
    93306, 93304, 93223, 93189, 93095, 
    93009, 92836, 92462, 92450, 92448, 
    92447, 92434, 92433, 91822
  ) 
  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.00042

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
91822 hayz-change-the-world-frantic-digital 6
92433 homzy-random-but-raw-lost-in-time-radio-edit-cheeky-tracks 6
92434 homzy-random-but-raw-lost-in-time-original-mix-cheeky-tracks 6
92447 amber-d-adam-taylor-charlie-goddard-namaste-original-mix-d-licious 6
92448 kid-dynamo-up-to-no-good-original-mix-d-licious 6
92450 the-unseen-aduial-original-mix-epidemic-digital 6
92462 spyndl-renegade-original-mix-immortal-noise-recordings 6
92836 g-mix-dance-with-g-tempo-trax 6
93009 ross-farley-back-to-life-visceral-records 6
93095 neil-bee-delhoover-unbounded-traxx 6
93189 kirk-p-move-torque-digital 6
93223 unit-dvsn-wellybob-wet-like-lorraine-superfly 6
93304 g.w.r.-nurogl-juicy-visceral-records 6
93306 dramatik-get-the-fck-out-fruition-records 6
93307 dramatik-kill-them-all-fruition-records 6
93318 shoguns-carbon-based-life-form-burning-blade-records 6
93319 shoguns-got-the-trace-burning-blade-records 6
93320 whoredrey-roberts-good-lines-terrabang-recordings-en 6
93321 whoredrey-roberts-man-love-terrabang-recordings-en 6
93322 whoredrey-roberts-just-pay-hoes-terrabang-recordings-en-2 6