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 (
    95922, 95921, 95839, 94774, 96891, 96733, 
    95876, 96757, 96756, 96755, 96754, 
    96753, 96752, 96751, 96750, 96749, 
    96748, 96743, 96715, 96711
  ) 
  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.00044

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
94774 jason-nawty-direct-drive-everything-changed-frantic-digital 6
95839 boris-the-noss-mofo-sugar-skull-digital 6
95876 rick-james-no-stopping-original-resurrection-digital 6
95921 steve-thornton-digital-mafia-revenge-porn-radio-edit-cheeky-tracks 6
95922 steve-thornton-digital-mafia-revenge-porn-original-mix-cheeky-tracks 6
96711 james-dub-i-won-t-ask-for-mercy-burning-blade-records 6
96715 dj-serenity-higher-and-higher-energy-source-productions 6
96733 james-nardi-m-series-stay-strong-scorpion-trax 6
96743 red-city-dianna-s-love-child-hi-five-digital 6
96748 ben-vennard-delta-city-cop-hi-five-digital 6
96749 barbs-haus-pretty-bitch-hi-five-digital 6
96750 dylan-foley-take-control-hi-five-digital-en 6
96751 dj-lolly-griffiths-vs-bass-jumper-gold-skies-hi-five-digital 6
96752 digital-mafia-david-timothy-keep-on-rising-hi-five-digital 6
96753 g-mix-g-bass-hi-five-digital 6
96754 rick-james-general-bounce-what-we-re-gonna-do-hi-five-digital 6
96755 k8-e-psycloud-ob1-hi-five-digital-en 6
96756 hayz-funky-arse-beatz-hi-five-digital 6
96757 james-dub-trip-hi-five-digital-en 6
96891 pat-glenny-split-groove-pitch-drift-records 6