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 (
    76145, 76144, 76143, 76142, 76141, 76140, 
    76139, 76138, 76137, 76136, 76135, 
    76134, 76133, 76132, 76095, 77060, 
    76155, 76523, 76522, 76489
  ) 
  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.00042

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
76095 ip-eternity-original-mix-fatal-energy-records 1
76132 al-storm-x-mc-whizzkid-trigger-original-mix-24-7-hardcore 1
76133 fracus-darwin-drop-dead-original-mix-24-7-hardcore 1
76134 squad-e-friday-the-13th-original-mix-24-7-hardcore 1
76135 al-storm-iyf-nobody-the-monster-project-original-mix-24-7-hardcore 1
76136 al-storm-m-project-distorted-chaos-original-mix-24-7-hardcore 1
76137 macks-wolf-the-spider-original-mix-24-7-hardcore 1
76138 eufeion-masquerade-of-the-damned-original-mix-24-7-hardcore 1
76139 darkman-deadhead-the-mummy-original-mix-24-7-hardcore 1
76140 dj-demand-dark-light-re-con-remix-24-7-hardcore 1
76141 my3r5-al-storm-jack-the-ripper-original-mix-24-7-hardcore 1
76142 rob-iyf-x-mc-riddle-murder-ride-original-mix-24-7-hardcore 1
76143 daniel-seven-juggernaut-original-mix-24-7-hardcore 1
76144 al-storm-dj-dreem-phantasm-original-mix-24-7-hardcore 1
76145 mizel-x-wilsxn-gods-monsters-original-mix-24-7-hardcore 1
76155 scott-attrill-slammer-mike-reverie-remix-riot-recordings 1
76489 garbie-project-maniac-original-mix-dnz-records 1
76522 kritikal-mass-emotions-radio-edit-dnz-records 1
76523 kritikal-mass-emotions-original-mix-dnz-records 1
77060 j.-jblack-go-away-original-mix-power-tracks-records 1