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 (
    96572, 96559, 96114, 95928, 92920, 96615, 
    96498, 95750, 95749, 96567, 96499, 
    95897, 95896, 94823, 96556, 96522, 
    96521, 96520, 96519, 96518
  ) 
  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.00048

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
92920 cupra-whitehayz-system-therapist-vicious-circle 6
94823 paul-reeves-lose-myself-korruption 6
95749 inner-city-sumo-dangerous-neighbourhood-original-mix-perennial-recording-network 6
95750 inner-city-sumo-dangerous-neighbourhood-stampatron-s-space-bass-remix-perennial-recording-network 6
95896 ludo-prankin-original-mix-bring-the-noise-recordings 6
95897 ludo-pumping-original-mix-bring-the-noise-recordings 6
95928 spyndl-tantrum-original-mix-immortal-noise-recordings 4
96114 m-series-gsr-praganti-toolbox-recordings 6
96498 tom-whyld-money-hard-house-family 6
96499 kaki-raphael-inner-city-sumo-kaki-trax 6
96518 the-hoover-jocks-rock-the-beat-pitch-drift-records 6
96519 pat-glenny-team-sly-airlock-pitch-drift-records 6
96520 dean-richardson-i-don-t-need-you-pitch-drift-records 6
96521 karl-davies-filthy-kitten-emeht-bezerk 6
96522 batten-brow-that-s-how-we-do-it-original-mix-tuff-groove-recordings 6
96556 g.w.r.-iverson-visceral-records 6
96559 vandalize-pete-maxwell-should-i-go-superfly-en 6
96567 dj-veedr-digital-mafia-rhaspect-hi-five-digital 6
96572 casey-f-move-closer-emmanating-records 6
96615 stu-angus-pat-glenny-defiance-original-resurrection-digital 6