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 (
    97918, 97916, 97215, 97911, 97900, 97899, 
    97896, 97757, 97670, 97165, 97164, 
    97106, 92927, 96739, 97748, 97747, 
    97746, 92926, 97705, 97704
  ) 
  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.00048

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
92926 defective-audio-underkut-vicious-circle 6
92927 fickletwitch-the-sound-vicious-circle 6
96739 baseglitz-james-nardi-what-you-need-scorpion-trax 6
97106 criostasis-trigger-point-frantic-digital 6
97164 flashboy-dim-digital-mafia-you-re-the-one-radio-edit-cheeky-tracks 6
97165 flashboy-dim-digital-mafia-you-re-the-one-original-mix-cheeky-tracks 6
97215 dj-goa-clare-marie-ana-original-mix-bring-the-noise-recordings 6
97670 cupra-matt-clarkson-another-dimension-hi-freak1c-remix-tempo-trax 6
97704 g.m.k-indecision-audio 6
97705 abduction-scorpion-trax 6
97746 danny-gibson-feel-my-body-hi-five-digital 6
97747 danny-gibson-kick-those-feet-hi-five-digital 6
97748 boris-the-noss-acidmath-black-dog-records 6
97757 adam-bellew-nurogl-incredible-global-awakening-records 6
97896 sinobe-eavesdropping-burning-blade-records 6
97899 nervous-energy-we-have-contact-indecision-audio 6
97900 pat-glenny-kid-dynamo-taking-back-control-pitch-drift-records 6
97911 paul-hunter-one-angry-bitch-black-dog-records 6
97916 fiveone-feat-summer-c-lust-4-dust-hi-five-digital 6
97918 dj-serenity-be-there-energy-source-productions 6