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 (
    95010, 95009, 93344, 95875, 95866, 95836, 
    95164, 92917, 95835, 95801, 95800, 
    95852, 95744, 95743, 95742, 95741, 
    95701, 95547, 95538, 95302
  ) 
  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
92917 wayne-german-circular-movement-vicious-circle 6
93344 j2s-james-nardi-tough-business-frantic-digital 6
95009 rick-james-general-bounce-ibuleve-radio-edit-cheeky-tracks 6
95010 rick-james-general-bounce-ibuleve-original-mix-cheeky-tracks 6
95164 team-sly-for-the-music-original-mix-hot-box-digital 6
95302 james-dub-hard-tech-toolbox-recordings 6
95538 andy-naylor-i-gotta-have-wlhh-en 6
95547 homzy-mada-dale-dean-deadpool-global-awakening-records 6
95701 dramatik-leebanga-helix-recordings 6
95741 tribeaut-love-music-tribeaut 6
95742 m-series-stu-cowper-support-mechanism-kimara-records 6
95743 m-series-stu-cowper-support-mechanism-kimara-records-en 6
95744 m-series-stu-cowper-support-mechanism-kimara-records-en-2 6
95800 lance-get-messy-indecision-audio 6
95801 tara-n-just-begun-indecision-audio 6
95835 tara-n-tekneak-evacuate-burning-blade-records 6
95836 carl-pearce-cheryl-pearce-worth-it-sugar-skull-digital 6
95852 ross-farley-slenderman-make-it-count-visceral-records 6
95866 paul-reeves-i-m-in-hi-five-digital 6
95875 tim-clewz-tim-clewz-takoyaki-resurrection-digital 6