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 (
    60005, 60004, 60003, 59483, 59482, 59481, 
    59480, 59479, 59478, 59477, 59476, 
    59475, 59474, 59473, 59472, 59471, 
    59470, 59469, 59468, 59467
  ) 
  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.00050

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
59467 bassmasters-million-miles-original-mix-lw-recordings 4
59468 cookie-cookie-005-original-mix-lw-recordings 4
59469 mavrik-united-front-original-mix-lw-recordings 3
59470 baz-coleman-glittery-gonads-original-mix-lw-recordings 1
59471 noise-providers-make-you-mine-original-mix-lw-recordings 1
59472 dj-jesu-i-m-feeling-you-original-mix-lw-recordings 1
59473 antix-paranoiz-take-me-back-original-mix-lw-recordings 3
59474 arkett-spyndl-osaka-original-mix-lw-recordings 3
59475 ng-rezonance-matt-draper-spearhead-original-mix-lw-recordings 3
59476 side-e-fect-busho-k.t.b.-original-mix-lw-recordings 1
59477 adam-dixon-trancendence-original-mix-lw-recordings 3
59478 mekk.1-guzheng-original-mix-lw-recordings 1
59479 jbl-rockers-why-so-serious-original-mix-lw-recordings 3
59480 arkett-spyndl-2004-original-mix-lw-recordings 3
59481 v-tonez-plasmid-potential-energy-remix-lw-recordings 3
59482 matt-draper-ascendance-original-mix-lw-recordings 3
59483 hard-dance-anthems-vol.-04-lw-recordings 13
60003 gene-karz-lesia-karz-india-original-mix-lw-recordings 22
60004 hardom-rec-one-original-mix-lw-recordings 22
60005 dj-reversive-rewind-original-mix-lw-recordings 22