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 (
    91767, 91766, 91765, 91763, 92157, 91716, 
    92113, 92112, 92111, 92110, 92109, 
    92108, 92107, 92106, 91627, 91623, 
    91622, 91621, 91620, 91619
  ) 
  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.00046

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
91619 nurogl-livin-a-lie-original-mix-lw-recordings 4
91620 k8-e-psycloud-ob1-original-mix-lw-recordings 4
91621 pat-glenny-s.t.a.y-original-mix-lw-recordings 4
91622 dj-skyr3sh-summer-time-original-mix-lw-recordings 4
91623 mickey-g-such-a-feeling-original-mix-lw-recordings 4
91627 frany-sp-kill-the-king-original-mix-lw-recordings 4
91716 ludo-broken-dreams-original-mix-project-storm-recordings 4
91763 dekade-hold-your-breath-original-mix-btid-music 4
91765 sam-townend-the-dirty-garage-door-original-mix-untidy 4
91766 sam-townend-holy-geezus-original-mix-untidy-en 4
91767 sam-townend-watching-shooting-stars-original-mix-untidy 4
92106 jj-baz-a-eternity-original-mix-dnz-records 4
92107 jj-don-t-you-want-my-love-original-mix-dnz-records 4
92108 jj-dj-oskar-shooting-star-jj-s-bounce-mix-dnz-records 4
92109 kritikal-mass-i-think-we-re-alone-now-jj-s-bounced-up-remix-dnz-records 4
92110 dj-fitzy-rossy-b-laura-stimulated-jj-remix-dnz-records 4
92111 jj-you-guide-me-original-mix-dnz-records-en 4
92112 buzzed-like-a-flower-jj-s-remix-dnz-records 4
92113 jj-take-you-away-original-mix-dnz-records-en 4
92157 dj-joe-craig-the-night-original-mix-dnz-records 4