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 (
    121273, 121272, 121271, 121270, 121269, 
    121268, 121267, 121266, 121265, 121264, 
    121263, 121262, 121261, 121260, 121259, 
    121258, 121257, 121256, 121255, 121254, 
    121253, 121252, 121251
  ) 
  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.00054

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
121251 the-hiit-company-subrush-that-feeling-extended-mix-cheeky-tracks-en 4
121252 catchy-tone-twister-original-mix-cheeky-tracks-en-3 3
121253 dj-kambel-can-t-let-go-original-mix-cheeky-tracks-en-2 4
121254 greedy-djs-luv-u-more-the-punterz-remix-cheeky-tracks-en 4
121255 kid-dynamo-groove-control-make-u-sweat-groove-control-remix-cheeky-tracks-en-2 4
121256 starman-italo-bounce-music-sets-you-free-original-mix-cheeky-tracks-en-2 4
121257 eezy-inc-kelle-together-again-catchy-presents-projekt-b-remix-cheeky-tracks-en-2 4
121258 the-r.y.e-by-your-side-original-mix-cheeky-tracks-en-2 4
121259 micky-modelle-darren-glancy-thursday-axel-gear-remix-cheeky-tracks-en-2 4
121260 klubbhammer-adf-party-time-original-mix-cheeky-tracks-en-2 4
121261 catchy-come-fly-with-me-groove-control-remix-cheeky-tracks-en 4
121262 scott-farrimond-adelle-dancing-in-the-rain-original-mix-cheeky-tracks-en-2 4
121263 harry-hard-general-bounce-tiffany-jackson-we-don-t-talk-initi8-remix-cheeky-tracks-en-2 4
121264 jamie-b-great-feelings-original-mix-cheeky-tracks-en-2 4
121265 groove-control-over-for-me-150-remix-cheeky-tracks-en 4
121266 luke-dj-break-it-up-original-mix-cheeky-tracks-en-2 4
121267 scott-farrimond-inspiration-original-mix-cheeky-tracks-en 4
121268 steven-jay-blowout-original-mix-cheeky-tracks-en 4
121269 charlie-bosh-gem-harrison-somebody-to-touch-me-bounce-assassins-remix-cheeky-tracks 4
121270 ashton-scott-farrimond-ordinary-world-original-mix-cheeky-tracks-en 4
121271 groove-control-time-to-get-funky-hardy-m-remix-cheeky-tracks-en-2 4
121272 kelle-just-a-little-closer-original-mix-cheeky-tracks-en-2 4
121273 catchy-scott-farrimond-jodie-poye-euphoria-original-mix-cheeky-tracks-en 3