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 (
    111882, 111881, 111880, 111878, 112552, 
    111863, 111845, 114692, 114691, 114690, 
    114689, 112371, 112370, 112369, 112017, 
    112010, 111861, 111860, 111859, 111858
  ) 
  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 40 Using where

Result

product_id seo_name seo_path
111845 sarah-garlot-darkdomina-hardcore-mecanick-original-mix-pink-unicorn-records 22
111858 k-wire-lost-faith-warrior-chief-original-mix-stamina-records-en 22
111859 rick-chubbs-bass-check-original-mix-stamina-records-en 22
111860 tamerax-roomshaker-tamerax-remix-stamina-records-en 22
111861 a.b-best-of-stamina-records-2022-continuous-dj-mix-stamina-records 22
111863 darren-tyler-donna-summer-body-extended-mix-24-7-hardcore 22
111878 benaddikt-oddball-savage-drop-the-bassline-original-mix-addiktive-sounds-digital 22
111880 noctyz-ching-chime-original-mix-twisted-hardcore-records 22
111881 noctyz-ching-chime-radio-edit-twisted-hardcore-records 22
111882 ben-fraser-acid-everything-original-mix-triple-a-acid-artists-in-action 22
112010 dune-m-project-i-got-what-u-like-original-mix-keeping-the-rave-alive 22
112017 winterlake-close-to-you-extended-mix-the-world-of-obsession-recordings 22
112369 mozz-victim-original-mix-violent-disorder-records 22
112370 mozz-you-dare-original-mix-violent-disorder-records 22
112371 mozz-dangerous-original-mix-violent-disorder-records 22
112552 deathroar-on-the-way-original-mix-peacock-records 22
114689 get-han-emporte-par-la...-original-mix-dtk-records 22
114690 get-han-my-name-is-original-mix-dtk-records 22
114691 ergoth-dr-satan-original-mix-dtk-records 22
114692 ergoth-symbiote-original-mix-dtk-records 22