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 (
    66199, 66198, 66197, 66196, 66195, 66194, 
    66193, 66192, 66191, 66190, 66189, 
    66188, 66187, 66186, 66185, 66184, 
    66183, 66182, 66019, 66018
  ) 
  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.00036

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
66018 shadym-uncivilized-hour-original-mix-lw-recordings 22
66019 hard-techno-anthems-vol.-09-lw-recordings 13
66182 kid-rich-random-but-raw-frank-farrell-bug-hunt-original-mix-lw-recordings 4
66183 kris-o-rourke-mobius-original-mix-lw-recordings 4
66184 danny-gilligan-just-let-go-original-mix-lw-recordings 4
66185 mavrik-the-night-original-mix-lw-recordings 4
66186 joe-longbottom-2-the-top-original-mix-lw-recordings 4
66187 hilly-baby-gravy-original-mix-lw-recordings 4
66188 little-miss-natalie-the-testube-babies-are-you-awake-original-mix-lw-recordings 4
66189 lee-mills-from-my-lerv-original-mix-lw-recordings 4
66190 bowie666-on-fire-original-mix-lw-recordings 4
66191 irra-dj-dj-moix-cocaina-original-mix-lw-recordings 4
66192 insidious-the-horror-2017-rework-lw-recordings 4
66193 gaz-f-ben-stevens-existence-is-futile-original-mix-lw-recordings 4
66194 cupra-freak-matt-clarkson-remix-lw-recordings 4
66195 baz-coleman-rawcock-original-mix-lw-recordings 4
66196 sergio-caubal-party-bumping-remix-lw-recordings 4
66197 dj-nillos-excuse-me-original-mix-lw-recordings 4
66198 cally-gage-audox-head-up-high-charlie-goddard-remix-lw-recordings 4
66199 leeroy-dosing-up-original-mix-lw-recordings 4