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 (
    54127, 54126, 54125, 54124, 54123, 54122, 
    54121, 54120, 54119, 54118, 54117, 
    54116, 54115, 54114, 54113
  ) 
  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 30 Using where

Result

product_id seo_name seo_path
54113 the-change-fruit-machine-remix 4
54114 2p-a-go-original-mix-en 4
54115 7th-heaven-original-mix-en-2 4
54116 tatty-bojangles-fruit-machine-remix-en-2 4
54117 jackpot-original-mix-en 4
54118 what-happens-in-vegas-original-mix-en 4
54119 hells-bells-original-mix-en 4
54120 game-over-original-mix-en-12 4
54121 one-arm-bandit-original-mix-en-3 4
54122 electric-disco-fruit-machine-remix 4
54123 youre-fired-original-mix-en 4
54124 top-of-the-cherry-original-mix-en 4
54125 99-nudges-original-mix-en 4
54126 bars-all-the-way-original-mix-en 4
54127 spacehopper-fruit-machine-remix-en-2 4