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 (
    91344, 91340, 91339, 91338, 91337, 91336, 
    91335, 91334, 91333, 91329, 91961, 
    91761, 91760, 91759, 91758, 91265, 
    102383, 102382, 102381, 102380
  ) 
  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.00053

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
91265 bridson-laurence-c-c-save-you-anahera-original-mix-rave-essentials 4
91329 vadermonkey-freak-of-the-tech-album-edit-ultratech 4
91333 vadermonkey-my-ting-album-edit-ultratech 4
91334 vadermonkey-natural-born-offnzive-album-edit-ultratech 4
91335 vadermonkey-covid-breath-album-edit-ultratech 4
91336 vadermonkey-dance-music-junkie-album-edit-ultratech 4
91337 vadermonkey-stompalott-mangina-album-edit-ultratech 4
91338 vadermonkey-lok-e-doll-step-album-edit-ultratech 4
91339 vadermonkey-neon-monkey-album-edit-ultratech 4
91340 vadermonkey-isolated-album-edit-ultratech 4
91344 mikey-dee-uk-give-it-to-me-baby-radio-edit-cheeky-tracks 4
91758 power-tracks-team-skibidi-original-mix-power-tracks-records-en 4
91759 dj-ruiz-dj-kano-poky-rumble-original-mix-power-tracks-records-en 4
91760 two-beats-to-the-top-j.-jblack-jaime-guerrero-power-tracks-records 4
91761 isaac-sanchez-jaime-guerrero-poky-dreams-original-mix-power-tracks-records-en-2 4
91961 dj-serenity-spangled-sensual-soundz 4
102380 ingo-bless-you-original-mix-tidy-en-3 4
102381 digital-mafia-mike-taylor-rave-to-the-grave-original-mix-tidy-en 4
102382 rob-tissera-paul-priestley-aspirations-original-mix-tidy 4
102383 hayley-colleen-leigh-green-together-original-mix-tidy-en-3 4