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 (
    88200, 88199, 88198, 88197, 88182, 88181, 
    88180, 88179, 88178, 88177, 88176, 
    88175, 88174, 88139, 88324, 88043, 
    88042, 88041, 88040, 88038
  ) 
  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
88038 zone-one-future-dj-darroo-remix-infused-traxx 1
88040 dj-darroo-utopian-original-mix-infused-traxx 1
88041 dj-darroo-ausdauer-original-mix-infused-traxx 1
88042 dj-darroo-don-t-forget-miracle-mix-infused-traxx 1
88043 rainer-nrg-dj-darroo-life-is-2-short-original-mafia-remix-infused-traxx 1
88139 transcend-mystic-original-mix-energy-field 1
88174 jordan-duke-near-me-original-mix-traffic-records 1
88175 jordan-duke-the-pulse-original-mix-traffic-records 1
88176 judge-jules-bk-rumble-original-mix-traffic-records 1
88177 leon-b-hazard-original-mix-traffic-records 1
88178 leon-b-no-return-original-mix-traffic-records 1
88179 leon-clarke-sandstorm-original-mix-traffic-records-en 1
88180 leon-clarke-diving-faces-original-mix-traffic-records 1
88181 loop-loop-4-original-mix-traffic-records 1
88182 luca-antolini-powerfull-scott-attrill-remix-abum-edit-traffic-records 1
88197 bk-ali-wilson-london-rock-club-mix-riot-recordings 1
88198 bk-d.a.v.e.-the-drummer-soul-image-club-mix-riot-recordings 1
88199 joe-e-ethos-scott-attrill-remix-riot-recordings 1
88200 lee-mac-visual-distortion-club-mix-riot-recordings 1
88324 gringro-escape-from-my-dreams-original-mix-dnz-records 1