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 (
    76582, 124500, 13315, 31964, 122622, 
    124267, 76718, 78107, 113387, 113408
  ) 
  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.00048

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_seo_names range PRIMARY,dispatch PRIMARY 210 20 Using where

Result

product_id seo_name seo_path
13315 ayla-original-mix-en-2-3-4-5-6 1
31964 hardwhores-original-mix-en 1
76582 alf-graham-bring-me-to-life-original-mix-hard-dance-coalition 1
76718 danny-harris-five-dollar-bill-original-mix-hard-dance-coalition-en 1
78107 cupra-acid-movement-original-mix-hard-dance-coalition 1
113387 shugz-klaus-kaz-the-path-original-mix-keeping-the-rave-alive 1
113408 tek-fast-summer-cocktail-original-mix-lw-recordings 1
122622 kriess-guyte-xtc-extended-mix-tidy 1
124267 kidd-kaos-heart-that-s-only-yours-original-mix-k405-records 1
124500 vinylgroover-the-red-hed-live-for-the-weekend-bk-remix-traffic-records-en-2 1