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 (
    90484, 89456, 89455, 91443, 90822, 91441, 
    91440, 91439, 91438, 91437, 91436, 
    91433, 91427, 91426, 89707, 91424, 
    91423, 91422, 91400, 91375
  ) 
  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
89455 aaron-james-the-urge-toolbox-recordings 6
89456 aaron-james-twelve-kinds-of-crazy-toolbox-recordings 6
89707 andy-naylor-hayley-colleen-your-energy-vicious-circle 6
90484 pants-corset-dammit-janet-manik-remix-wlhh 6
90822 mobi-d-voy-a-venir-pitch-drift-records 6
91375 sean-inside-out-ready-to-rumble-dark-suspects-remix-hooverweight-records 6
91400 matt-rush-pez-vs-hilz-e-stop-the-2020-beat-torque-digital 6
91422 james-nardi-love-is-scorpion-trax 6
91423 pretty-bitch-hi-five-digital 6
91424 the-hoover-jocks-pill-trippin-hi-five-digital 6
91426 fickletwitch-mercy-tempo-trax 6
91427 pete-maxwell-matt-clarkson-spirits-tempo-trax 6
91433 dj-serenity-candyman-energy-source-productions 6
91436 megaman-rushin-over-me-terrabang-recordings-en 6
91437 megaman-the-hook-terrabang-recordings 6
91438 megaman-disco-damage-terrabang-recordings 6
91439 megaman-dtf-terrabang-recordings-en 6
91440 megaman-wobble-ya-head-terrabang-recordings 6
91441 ross-homson-snakehead-megaman-remix-terrabang-recordings 6
91443 dj-serenity-ravers-revival-energy-source-productions 6