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 (
    102379, 102378, 102377, 102376, 102375, 
    102374, 102373, 102372, 102371, 102370, 
    102369, 102348, 102346, 102345, 102344, 
    102343, 102342, 102341, 102340, 102339
  ) 
  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 40 Using where

Result

product_id seo_name seo_path
102339 ingo-strobelight-original-mix-tidy-en-2 4
102340 bulletproof-wanna-hear-ya-original-mix-tidy-en-4 4
102341 ben-stevens-take-me-back-original-mix-tidy-en 4
102342 andy-naylor-hayley-colleen-your-energy-original-mix-tidy 4
102343 starquake-hold-me-hostage-original-mix-tidy-en-2 4
102344 max-mozart-lia-b-runnin-original-mix-tidy-en 4
102345 bass-jumper-underground-sound-original-mix-tidy-en-2 4
102346 nick-rafferty-velos-i-need-a-fix-velos-extended-remix-d4-tidy 4
102348 ng-rezonance-phd-hayley-colleen-worlds-collide-stimulant-djs-remix-tidy-en-2 4
102369 sam-townend-holy-geezus-original-mix-tidy 4
102370 james-revill-belgium-durt-original-mix-tidy 4
102371 ben-stevens-take-me-back-sam-townend-s-untidy-remix-tidy 4
102372 nicholson-sunstroke-original-mix-tidy 4
102373 eamonn-fevah-nurogl-inside-of-me-original-mix-tidy 4
102374 ng-rezonance-phd-acid-drop-original-mix-tidy 4
102375 the-tidy-boys-pump-it-up-original-mix-tidy-en-2 4
102376 colin-barratt-let-it-rip-original-mix-tidy-en-2 4
102377 digital-mafia-jlf-doin-that-energy-original-mix-tidy-en 4
102378 tidy-dj-s-jon-bw-release-me-original-mix-tidy-en-3 4
102379 paul-maddox-slightly-mad-original-mix-tidy-en-5 4