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, 39342, 113610, 124180, 25405, 
    27370, 27773, 27804, 28091, 28450
  ) 
  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.00035

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
27804 in-da-air-original-mix 22
28091 love-of-my-life-brisk-mix 22
28450 dance-and-spin-original-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
124180 mike-reverie-x-matty-metrix-silence-2024-original-mix-bonkers 22