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 (
    100177, 99746, 99740, 99739, 99738, 
    99737, 99736, 99735, 93037, 100224, 
    100223, 100222, 100221, 100220, 100219, 
    100218, 100217, 100216, 100215, 100214
  ) 
  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.00033

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
93037 paul-glazby-abandon-tortured-craig-jones-remix-vicious-circle 6
99735 kid-dynamo-keep-on-rising-radio-edit-cheeky-tracks 6
99736 kid-dynamo-they-don-t-know-radio-edit-cheeky-tracks 6
99737 kid-dynamo-love-so-deep-grapey-radio-edit-cheeky-tracks 6
99738 kid-dynamo-love-so-deep-grapey-remix-cheeky-tracks 6
99739 kid-dynamo-they-don-t-know-original-mix-cheeky-tracks 6
99740 kid-dynamo-keep-on-rising-original-mix-cheeky-tracks 6
99746 paul-clark-adelile-when-i-look-at-you-frantic-digital 6
100177 shimoxxnz-nurogl-stoned-immaculate-global-awakening-records 6
100214 kelly-ward-turn-up-encoded-nrg 6
100215 dave-neale-wayne-smart-what-s-my-name-wayne-encoded-nrg-en 6
100216 encoded-get-hard-encoded-nrg-en 6
100217 dj-tony-k-make-u-sweat-encoded-nrg 6
100218 selina-jayne-kid-rich-hyper-bolt-encoded-nrg-en 6
100219 smart-mumbles-34-bumps-encoded-nrg-en 6
100220 adam-butler-technik-encoded-nrg-en 6
100221 wayne-smart-bpm-encoded-nrg 6
100222 wayne-smart-a-little-higher-dub-mix-encoded-nrg 6
100223 forbidden-friends-get-it-together-encoded-nrg-en 6
100224 wayne-german-dawn-lee-let-the-beat-encoded-nrg 6