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 (
    125591, 122624, 125349, 113297, 122609, 
    122620, 125406, 122622, 122626, 109424
  ) 
  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.00038

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
109424 paul-glazby-beautiful-extended-mix-tidy 4
113297 kym-ayres-technikal-more-more-yoshi-razner-remix-tidy 3
122609 ben-stevens-attack-extended-mix-tidy 4
122620 trauma-you-ll-know-dan-madams-extended-remix-tidy 4
122622 kriess-guyte-xtc-extended-mix-tidy 1
122624 trauma-higher-ben-vennard-cupra-extended-remix-tidy 4
122626 tony-de-vit-i-don-t-care-paul-king-trade-club-extended-remix-tidy 4
125349 renegade-system-i-won-t-let-you-get-away-extended-mix-tidy 3
125406 carl-nicholson-james-lawson-times-like-these-extended-mix-tidy 3
125591 harder-faster-vol-1-tidy 13