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 (
    119709, 119708, 119707, 119706, 119705, 
    119704, 119703, 119702, 119701, 119700, 
    119699, 119698, 119697, 119696, 119695, 
    119694, 119693, 119692, 119691, 119690, 
    119689, 119688
  ) 
  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.00040

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_seo_names range PRIMARY,dispatch PRIMARY 210 44 Using where

Result

product_id seo_name seo_path
119688 k8-e-jon-bw-smasha-original-mix-cheeky-tracks-en 4
119689 luke-dj-dirty-cash-base-22-remix-cheeky-tracks-en-2 4
119690 mr-ripley-lisa-abbott-on-a-night-like-this-catchy-s-balearic-remix-cheeky-tracks-en 3
119691 rob-tissera-daz-wood-temptation-original-mix-cheeky-tracks-en-2 3
119692 dave-curtis-enter-the-rave-original-mix-cheeky-tracks-en 4
119693 ste-willo-all-i-need-extended-mix-cheeky-tracks-en 4
119694 ria-d-trust-mikey-remix-cheeky-tracks-en-2 4
119695 agent-jack-left-right-original-mix-cheeky-tracks-en-2 4
119696 the-hiit-company-subrush-thinkin-about-u-extended-mix-cheeky-tracks-en 4
119697 jay-woody-rofo-s-theme-kid-dynamo-remix-cheeky-tracks-en 4
119698 floormover-do-it-original-mix-cheeky-tracks-en 4
119699 g.w.r.-another-level-g.w.r.-cupra-3am-remix-cheeky-tracks 4
119700 mickeyg-mickey-bo-always-pumpin-original-mix-cheeky-tracks-en-2 4
119701 ashton-scott-farrimond-ordinary-world-ben-vennard-remix-cheeky-tracks 4
119702 kid-dynamo-groove-control-make-u-sweat-groove-control-remix-cheeky-tracks-en 4
119703 rosie-b-everytime-you-touch-me-original-mix-cheeky-tracks-en-2 4
119704 steptonic-freda-maybe-shine-forever-smokey-s-2023-remix-cheeky-tracks-en-2 4
119705 jamie-b-you-are-alive-original-mix-cheeky-tracks-en 4
119706 kelle-just-a-little-closer-systemshock-remix-cheeky-tracks 3
119707 catchy-blue-sphere-eyeball-s-theme-original-mix-cheeky-tracks-en-3 3
119708 luke-dj-u-got-my-love-original-mix-cheeky-tracks-en-2 4
119709 steven-jay-pmb-the-sound-of-now-original-mix-cheeky-tracks-en 4