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 (
    111663, 111662, 111661, 111660, 111659, 
    111658, 111657, 111656, 111655, 111654, 
    111653, 111652, 111651, 111650, 111649, 
    111648, 111647, 111646, 111645, 111644
  ) 
  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.00041

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
111644 rvrs-memories-radio-edit-karmakontra-records-en 25
111645 rvrs-memories-extended-karmakontra-records-en 25
111646 rvrs-memories-skully-remix-karmakontra-records-en 25
111647 masteroftime-bad-intension-radio-edit-karmakontra-records-en 25
111648 masteroftime-bad-intension-extended-karmakontra-records-en 25
111649 d-effect-once-in-a-lifetime-original-mix-karmakontra-records-en 25
111650 sikusia-celestial-original-mix-karmakontra-records-en 25
111651 bassctrl-survivors-original-mix-karmakontra-records-en 25
111652 south-side-psychoz-corona-original-mix-karmakontra-records-en 25
111653 mbw-save-me-radio-edit-karmakontra-records-en 25
111654 mbw-save-me-extended-karmakontra-records-en 25
111655 jano-take-me-original-mix-karmakontra-records-en 25
111656 anarkic-kobra-radio-edit-karmakontra-records-en 25
111657 anarkic-kobra-extended-karmakontra-records-en 25
111658 d-style-colours-of-life-original-mix-karmakontra-records-en 25
111659 mbw-day-after-day-original-mix-karmakontra-records-en 25
111660 mbw-alone-original-mix-karmakontra-records-en 25
111661 bassfreq-kill-original-mix-karmakontra-records-en 25
111662 equinocz-underground-original-mix-karmakontra-records-en 25
111663 jano-unity-original-mix-karmakontra-records-en 25