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 (
    98223, 98219, 109022, 98171, 98168, 
    98167, 98166, 98433, 98133, 98124, 
    108919, 98089, 108951, 108874, 98375, 
    98013, 97984, 97977, 97974, 97973
  ) 
  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.00038

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
97973 mynax-reflection-original-mix-lussive-music 25
97974 mynax-state-of-mind-original-mix-lussive-music 25
97977 d-fuse-stay-right-there-original-mix-keeping-the-rave-alive 25
97984 eternize-ad-astra-original-mix-hard-music-records 25
98013 limitless-tear-me-down-original-mix-upcoming-records 25
98089 sash-dee-senpai-song-original-mix-bassface-recordings 25
98124 alphachoice-prosphere-find-you-pro-mix-blackbox-digital 25
98133 krb-leagan-distant-dream-extended-mix-akkros-records 25
98166 twisted-mindz-erase-you-original-mix-kickdrum-records 25
98167 nutty-t-the-fallen-lust-4-blood-original-mix-nutty-traxx 25
98168 nutty-t-the-fallen-lust-4-blood-radio-edit-nutty-traxx 25
98171 rebelnoise-wake-up-original-mix-upcoming-records 25
98219 eternate-stargazer-like-a-phoenix-ephoric-remix-blackbox-digital 25
98223 arseen-never-giving-in-extended-mix-akkros-records 25
98375 dom-livez-no-more-pain-extended-mix-wardog-records 25
98433 blockbusterz-p-please-bob-original-mix-dnz-records 25
108874 bassctrl-mightiest-warrior-original-mix-karmakontra-records 25
108919 subronz-pray-for-me-original-mix-karmakontra-records 25
108951 frenetik-lux3l-the-galaxy-original-mix-karmakontra-records 25
109022 disaster-mind-voices-in-my-head-original-mix-karmakontra-records 25