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 (
    93059, 93057, 92492, 92956, 92883, 92900, 
    92899, 92898, 92897, 92895, 92834, 
    92808, 92789, 92788, 92765, 92758, 
    92675, 92673, 92291, 92238
  ) 
  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.00039

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
92238 dean-richardson-feel-your-soul-original-mix-hot-box-digital 6
92291 filterfreakz-partycrash-original-mix-epidemic-digital 6
92492 fiveone-nurogl-taken-extended-mix-beast-mode-recordings 6
92673 space-sentinelz-let-it-hit-em-bounce-classic-twisted-trax 6
92675 kelly-ward-chaney-come-with-me-visceral-records 6
92758 casey-f-emma-nate-get-it-right-re-form-recordings 6
92765 narc-disturbed-the-torture-thing-raw-power 6
92788 cupra-daimon-hellstrom-worldwide-normality-hellstorm-trax 6
92789 bizarre-q-hard-house-mofo-superfly 6
92808 trimjim-trimtergalactic-global-awakening-records 6
92834 paul-hunter-peter-davidson-panic-tempo-trax 6
92883 em-party-further-instructions-hard-house-family 6
92895 tom-whyld-superdom-tw-digital 6
92897 boski-i-like-mofos-burning-blade-records 6
92898 batten-brow-vs-matt-cox-um-bongo-original-mix-tuff-groove-recordings 6
92899 tekneak-i-need-you-indecision-audio 6
92900 tara-n-people-get-sick-indecision-audio 6
92956 g-mix-g-o-hi-five-digital 6
93057 dj-serenty-rush-em-energy-source-productions 6
93059 nikkdbubble-it-s-gotta-be-tough-digital-damage-recordings 6