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 (
    92901, 92884, 93763, 93762, 93758, 93743, 
    93741, 93740, 93739, 93738, 93737, 
    93736, 93472, 92820, 92345, 89225, 
    93548, 93517, 93345, 92683
  ) 
  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.00053

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
89225 jeff-payne-digital-mafia-to-my-rhythm-resurrection-digital 6
92345 casey-f-in-control-frantic-digital 6
92683 boris-the-noss-attention-go-korruption 6
92820 g.w.r.-leeroy-they-live-original-mix-drop-bear-digital 6
92884 tom-whyld-hit-harder-hard-house-family 6
92901 dj-clk-subzero-original-mix-bring-the-noise-recordings 6
93345 insanity-josh-b-swingers-club-trip-the-light-fantastic 6
93472 amp-attack-chug-thump-movin-house 6
93517 james-dub-mamba-hi-five-digital 6
93548 base-graffiti-2cool-2dance-spinball-records 6
93736 gaz-pritchard-cant-stop-now-superfly-en-2 6
93737 gaz-pritchard-cant-stop-now-superfly-en-3 6
93738 gaz-pritchard-cant-stop-now-superfly-en-4 6
93739 tribeaut-eaves-drop-tribeaut 6
93740 leeroy-enargee-fruition-records 6
93741 zillin-agent-smith-burning-blade-records 6
93743 boski-tekneak-human-nature-black-dog-records 6
93758 shenton-baseglitz-don-t-be-afraid-original-mix-tuff-groove-recordings 6
93762 mada-fine-day-global-awakening-records 6
93763 gaz-a-phase-one-tempo-trax 6