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 (
    125018, 125017, 125016, 125015, 125014, 
    125013, 125012, 125011, 125010, 125009, 
    125008, 125007, 125006, 125005, 125004, 
    125003, 125002, 125001, 125000, 124999, 
    124998, 124997, 124996
  ) 
  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.00047

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

Result

product_id seo_name seo_path
124996 g.w.r.-gangster-feels-original-mix-cheeky-tracks 4
124997 base-22-courage-groove-control-remix-cheeky-tracks-en 4
124998 ross-homson-gaslight-gatekeep-girlboss-original-mix-cheeky-tracks 4
124999 ste-willo-all-i-need-extended-mix-cheeky-tracks-en-2 4
125000 the-hiit-company-subrush-that-feeling-extended-mix-cheeky-tracks-en-2 4
125001 ross-homson-snakes-gonna-snake-original-mix-cheeky-tracks 4
125002 kid-dynamo-let-me-tell-ya-original-mix-cheeky-tracks 4
125003 g.w.r.-christiana-in-time-original-mix-cheeky-tracks-en-2 4
125004 charlie-bosh-bethany-feeling-me-original-mix-cheeky-tracks-en-2 4
125005 yusef-kifah-pleasure-luke-dj-remix-cheeky-tracks-en 4
125006 mobi-d-kick-the-rhythm-extended-mix-cheeky-tracks 4
125007 jamie-b-rise-original-mix-cheeky-tracks-en 4
125008 coccium-luke-dj-my-heart-went...-luke-dj-remix-cheeky-tracks-en 4
125009 smokey-bit-my-lemon-original-mix-cheeky-tracks-en 4
125010 vinyl-vandal-starman-nikki-when-i-call-your-name-groove-control-remix-cheeky-tracks-en-2 4
125011 fnktion-ii-kelle-on-and-on-original-mix-cheeky-tracks-en-2 4
125012 catchy-galaxia-original-mix-cheeky-tracks-en-2 3
125013 steven-jay-blowout-original-mix-cheeky-tracks-en-2 4
125014 starman-italo-bounce-with-feeling-original-mix-cheeky-tracks-en-3 4
125015 ry-n-t-dreams-come-alive-original-mix-cheeky-tracks-en 4
125016 eezy-inc-kelle-together-again-original-mix-cheeky-tracks-en-3 1
125017 digital-mafia-justin-daniels-jamie-r-i-won-t-tell-original-mix-cheeky-tracks-en-2 4
125018 matt-alliss-get-this-plane-original-mix-cheeky-tracks-en 1