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 (
    27405, 28091, 39342, 113610, 123944, 
    124180, 124301, 25405, 27370, 27773
  ) 
  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 20 Using where

Result

product_id seo_name seo_path
25405 closer-original-mix-en-3 22
27370 shooting-star-al-storms-bangin-remix 22
27405 the-weekend-has-landed-original-mix-en-2 22
27773 hearts-desire-brisk-and-vagabond-mix 22
28091 love-of-my-life-brisk-mix 22
39342 scott-brown-definition-of-a-badboy-original-mix-evolution-records 22
113610 kevin-energy-afterburner-solar-flare-original-mix-nu-energy-records 22
123944 chan.-i-m-done-waiting-extended-mix-oneseventy 22
124180 mike-reverie-x-matty-metrix-silence-2024-original-mix-bonkers 22
124301 midas-groove-control-eufeion-extended-remix-the-world-of-obsession-recordings 22