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 (
    99969, 99955, 99968, 99967, 99952, 99948, 
    99923, 99922, 99917, 99915, 99914, 
    99913, 99906, 99867, 99791, 99788, 
    99694, 99678, 99519, 99435
  ) 
  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.00054

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
99435 dylan-foley-from-whence-we-came-fireball 6
99519 paul-hunter-matt-clarkson-tension-tempo-trax 6
99678 dylan-foley-regulate-frisky 6
99694 nurogl-don-t-let-me-go-global-awakening-records 6
99788 cupra-horsepower-slingshot 6
99791 leigh-day-atomic-girl-system-crusher-trip-the-light-fantastic 6
99867 aron-hammond-take-me-there-unbounded-traxx 6
99906 boski-these-are-the-eyes-black-dog-records 6
99913 direct-drive-the-bond-emmanating-records 6
99914 alpha-a-for-hours-full-circle-productions 6
99915 dean-richardson-eliminated-pitch-drift-records 6
99917 matt-wade-cerberus-burning-blade-records 6
99922 djone7tout-second-sermon-indecision-audio 6
99923 djone7tout-second-sermon-from-the-pulpit-mix-indecision-audio 6
99948 kaki-raphael-power-pack-kaki-trax 6
99952 dj-serenity-magic-wand-energy-source-productions 6
99955 danny-gibson-ohh-yeahh-hi-five-digital 6
99967 dj-serenity-magic-wand-energy-source-productions-en 6
99968 dj-serenity-magic-wand-energy-source-productions-en-2 6
99969 mfs-dark-by-design-rapid-chemical-reaction-pulse-8-records 6