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 (
    81101, 81100, 81099, 81098, 81053, 81494, 
    81072, 81042, 81039, 81038, 81037, 
    81034, 81019, 81493, 81492, 81062, 
    81060, 80976, 80965, 80880
  ) 
  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.00049

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
80880 pete-untitled-winner-loser-d-railed-x-over-remix-fatal-energy-records 1
80965 d-railed-private-horrorshow-original-mix-fatal-energy-records 1
80976 human-aether-the-executioner-minor-code-remix-neurotoxin-cobra-records 1
81019 f.dj-f-detector-original-mix-fatal-energy-records 1
81034 substanced-heart-of-time-original-mix-stamina-records 1
81037 substanced-ambush-original-mix-stamina-records 1
81038 substanced-humanity-original-mix-stamina-records 1
81039 substanced-inside-original-mix-stamina-records 1
81042 substanced-f.e.a.r-original-mix-stamina-records 1
81053 f.dj-f-lost-frequency-original-mix-fatal-energy-records 1
81060 jon-doe-original-bad-boy-original-mix-g-core 1
81062 jon-doe-live-the-dream-original-mix-g-core 1
81072 anthony-atcherley-in-my-house-jon-doe-remix-g-core 1
81098 a.b-awaken-original-mix-stamina-records 1
81099 a.b-kevin-energy-samsara-original-mix-stamina-records 1
81100 a.b-douglas-tiwwa-original-mix-stamina-records 1
81101 a.b-substanced-injustice-original-mix-stamina-records 1
81492 garbie-project-kick-your-legs-radio-edit-dnz-records 1
81493 garbie-project-kick-your-legs-extended-mix-dnz-records 1
81494 que-rkay-you-belong-with-me-original-mix-dnz-records 1