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 (
    79485, 79484, 79483, 79482, 79481, 79480, 
    79479, 79473, 79472, 79475, 79474, 
    78864, 79371, 79362, 78850, 78630, 
    79249, 79248, 79247, 79243
  ) 
  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
78630 dj-darroo-secrets-of-the-universe-extended-mix-infused-traxx 1
78850 d-railed-shadow-warrior-hagane-shizuka-remix-fatal-energy-records 1
78864 lezamaboy-new-clear-device-original-mix-fatal-energy-records 1
79243 susumu-live-without-you-extended-mix-lw-recordings 1
79247 forza-duo-elemental-darren-hall-remix-lw-recordings 1
79248 nina-suerte-let-s-get-down-original-mix-lw-recordings 1
79249 cutoff-sky-comeback-of-the-hero-original-mix-lw-recordings 1
79362 garbie-project-if-you-love-me-original-mix-dnz-records 1
79371 t-jay-angel-original-mix-dnz-records 1
79472 jamie-b-dj-oskar-high-jamie-b-mix-dnz-records 1
79473 jamie-b-dj-oskar-high-dj-oskar-s-hdm-mix-dnz-records 1
79474 jamie-b-nova-scotia-mcsb-scotland-get-your-hands-up-original-mix-dnz-records 1
79475 jamie-b-in-my-head-garbie-project-remix-dnz-records 1
79479 robbie-rivera-dreamfreak-the-stars-extended-mix-lw-recordings 1
79480 krime-mind-free-radio-mix-lw-recordings 1
79481 dj-5l45h-ltk-original-mix-lw-recordings 1
79482 sean-norvis-kp-london-irina-reborn-babilonia-catch-the-blast-remix-lw-recordings 1
79483 alex-spite-need-to-live-original-mix-lw-recordings 1
79484 simon-cardona-take-u-there-original-mix-lw-recordings 1
79485 brialmont-better-on-my-own-original-mix-lw-recordings 1