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 (
    60025, 60024, 60023, 60022, 60021, 60020, 
    60019, 60018, 60017, 60016, 60015, 
    60014, 60013, 60012, 60011, 60010, 
    60009, 60008, 60007, 60006
  ) 
  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.00038

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
60006 dj-ogi-morbid-rapsody-tawa-girl-remix-lw-recordings 22
60007 the-third-c3-original-mix-lw-recordings 22
60008 nezvil-spanish-fly-assuc-remix-lw-recordings 22
60009 halvy-nico-luss-curva-swarm-hp-source-remix-lw-recordings 22
60010 mozzy-the-bionic-atze-ton-remix-lw-recordings 22
60011 patrick-hollo-kontakt-one-original-mix-lw-recordings 22
60012 tito-k.-thx-2209-original-mix-lw-recordings 22
60013 lewis-shephard-the-other-side-of-the-coin-original-mix-lw-recordings 22
60014 andrush-hardflute-joseph-dalik-remix-lw-recordings 22
60015 almir-ljusa-coriolisov-original-mix-lw-recordings 22
60016 kim-damien-minutes-of-darkness-tobias-lueke-remix-lw-recordings 22
60017 grozdanoff-schmutz-d.n.s-remix-lw-recordings 22
60018 dkult-glass-box-frequency-fifty-s-dj-tool-lw-recordings 22
60019 mark-rey-shifting-times-original-mix-lw-recordings 22
60020 peuch-jaja-solo-blur-original-mix-lw-recordings 22
60021 audios3x-anyam-eleszi-elolem-az-etelt-s-meg-a-sajat-szarat-is-megeszi-original-mix-lw-recordings 22
60022 chris-collins-who-is-the-highclere-stud-original-mix-lw-recordings 22
60023 cave-djz-bam-bam-original-mix-lw-recordings 22
60024 mechanic-freakz-sick-original-mix-lw-recordings 22
60025 dj-pheonix-bas-rutten-original-mix-lw-recordings 22