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 (
    60679, 60678, 60677, 60676, 60675, 60674, 
    60673, 60672, 60671, 60670, 60669, 
    60668, 60667, 60312, 60311, 60310, 
    60309, 60308, 60307, 60306
  ) 
  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.00033

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
60306 mick-doyle-jim-morris-decidability-original-mix-lw-recordings 4
60307 delusion-delusion-13b-original-mix-lw-recordings 4
60308 dave-owens-cheddar-original-mix-lw-recordings 4
60309 rowdie-can-t-stop-original-mix-lw-recordings 4
60310 ian-m-dark-element-exquiste-original-mix-lw-recordings 4
60311 sound-forces-pain-into-purpose-alphatech-5-into-darkness-mix-lw-recordings 4
60312 essential-guide-hard-house-vol.-11-lw-recordings 13
60667 groove-complex-do-you-hear-the-sound-original-mix-lw-recordings 1
60668 andy-whitby-audox-to-the-weekend-2017-remix-lw-recordings 1
60669 just-jack-kane-hero-ganar-remix-lw-recordings 1
60670 blooddropz-love-unlimited-club-mix-lw-recordings 1
60671 fantoman-last-love-cj-alexis-remix-lw-recordings 1
60672 arkett-spyndl-do-for-love-original-mix-lw-recordings 1
60673 danny-fierce-skanka-original-mix-lw-recordings 1
60674 haaradak-nightmare-extended-mix-lw-recordings 1
60675 ip-aura-original-mix-lw-recordings 1
60676 splinta-vthekid-legends-never-die-original-mix-lw-recordings 1
60677 rr-reject-hood-anthem-original-mix-lw-recordings 1
60678 project-d-dont-stop-moving-original-mix-lw-recordings 1
60679 scott-brown-yeah-oh-yeah-a.b-remix-lw-recordings 1