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 (
    97107, 92929, 97862, 98142, 98141, 98140, 
    98083, 98082, 98081, 98080, 98079, 
    98071, 98069, 98028, 98027, 98026, 
    98025, 98024, 98023, 98022
  ) 
  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.00056

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
92929 captain-tinrib-max-alien-acid-gate-scandal-paul-janes-remix-vicious-circle 6
97107 pete-mac-rob-tissera-set-free-frantic-mix-frantic-digital 6
97862 nurogl-storm-2021-dean-richardson-remix-beast-mode-recordings 6
98022 gaz-pritchard-cant-stop-now-the-hoover-jocks-remix-superfly 6
98023 bizarre-q-hard-house-mofo-superfly-en 6
98024 mickey-g-wicked-superfly-en 6
98025 gaz-pritchard-cant-stop-now-dean-richardson-remix-superfly 6
98026 dan-dyson-kalisto-superfly-en 6
98027 lance-the-wop-bam-boogie-superfly-en 6
98028 unit-dvsn-wellybob-wet-like-lorraine-superfly-en 6
98069 tara-n-lok-e-dead-by-dawn-visceral-records 6
98071 alan-james-much-better-full-circle-productions 6
98079 tekneak-line-after-line-burning-blade-records 6
98080 roosta-breathe-x-ite-audio 6
98081 no-comment-get-get-get-get-soft-indecision-audio 6
98082 tara-n-ready-to-fight-black-dog-records 6
98083 tara-n-ready-to-fight-boski-remix-black-dog-records 6
98140 jlf-power-hi-five-digital 6
98141 jlf-the-power-hi-five-digital 6
98142 jlf-power-hi-five-digital-en 6