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 (
    101300, 101299, 101298, 101297, 101296, 
    101295, 101294, 101293, 101292, 101291, 
    101290, 101289, 101288, 101287, 101286, 
    101285, 101284, 101283, 101282, 101281
  ) 
  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.00056

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
101281 adam-dixon-tension-original-mix-tidy-two 3
101282 nicholson-quake-life-s-a-dream-original-mix-tidy-two 3
101283 nicholson-emoiryah-now-we-are-free-original-mix-tidy-two-en-2 3
101284 technikal-nicholson-system-shock-dan-thompson-remix-tidy-two-en 3
101285 lee-haslam-the-power-original-mix-tidy-two-en 3
101286 ng-rezonance-thermite-2021-original-mix-tidy-two-en 3
101287 bryn-whiting-velvet-sky-original-mix-tidy-two-en 3
101288 lee-haslam-liberate-bryn-whiting-remix-tidy-two-en 3
101289 adam-dixon-tomorrow-original-mix-tidy-two 3
101290 bryn-whiting-you-are-still-alive-nicholson-remix-tidy-two-en 3
101291 nicholson-music-is-everywhere-original-mix-tidy-two-en 3
101292 ng-rezonance-phd-acid-drop-original-mix-tidy-two-en 3
101293 technikal-cubik-original-mix-tidy-two-en 3
101294 nicholson-paul-skelton-light-it-up-original-mix-tidy-two-en 3
101295 ng-rezonance-hypersonic-original-mix-tidy-two-en 3
101296 nicholson-the-head-master-original-mix-tidy-two-en 3
101297 eamonn-fevah-nurogl-inside-of-me-original-mix-tidy-two-en 3
101298 prime-mover-feel-what-i-feel-prime-mover-2021-remix-tidy-two-en 3
101299 yusef-kifah-energy-feel-what-i-m-feeling-original-mix-tidy-two-en 3
101300 paul-clark-clk-elle-mariachi-lullaby-original-mix-tidy-two 3