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, 125349, 113297, 122609, 122624, 
    125406, 109424, 109869, 119155, 119391
  ) 
  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.00052

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
109869 rob-tissera-burning-guyver-remix-tidy-en 3
113297 kym-ayres-technikal-more-more-yoshi-razner-remix-tidy 3
119155 rachel-auburn-screwdriver-extended-mix-tidy 4
119391 tony-de-vit-the-dawn-mark-sherry-extended-remix-tidy 3
122609 ben-stevens-attack-extended-mix-tidy 4
122624 trauma-higher-ben-vennard-cupra-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