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 (
    65926, 65925, 65924, 65923, 65922, 65921, 
    65920, 65919, 65918, 65917, 65916, 
    65915, 65914, 65913, 65912, 65911, 
    65910, 65909, 65908, 65907, 65906, 
    65905, 65904, 65903, 65902, 65901, 
    65900, 65899, 65898, 65897
  ) 
  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.00037

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

Result

product_id seo_name seo_path
65897 ben-stevens-rodi-style-u-got-2-know-original-mix-hard-dance-coalition 4
65898 alf-graham-when-i-m-gone-original-mix-hard-dance-coalition 4
65899 bulletproof-mistakes-ilogik-remix-hard-dance-coalition-en 4
65900 sean-inside-out-.-tom-parr-the-night-original-mix-hard-dance-coalition 4
65901 discam-the-ultimate-original-mix-hard-dance-coalition 4
65902 brendan-ashley-dave-owens-surreal-original-mix-hard-dance-coalition 4
65903 rattez-ben-stevens-enigmatic-emotions-original-mix-hard-dance-coalition-en 4
65904 hard-jeli-high-five-original-mix-hard-dance-coalition 4
65905 leighton-smith-buddy-love-original-mix-hard-dance-coalition 4
65906 rattez-ben-stevens-essential-tremor-original-mix-hard-dance-coalition-en-2 4
65907 chucky-a-little-more-original-mix-hard-dance-coalition 4
65908 hard-jeli-two-of-a-kind-original-mix-hard-dance-coalition 4
65909 leighton-smith-stop-the-tunage-original-mix-hard-dance-coalition 4
65910 fabio-seramota-joe-90-deep-down-original-mix-hard-dance-coalition 4
65911 alf-graham-waiting-for-original-mix-hard-dance-coalition 4
65912 sam-deano-strings-for-yasmin-original-mix-hard-dance-coalition 4
65913 ben-stevens-paul-maddox-let-the-music-play-original-mix-hard-dance-coalition 4
65914 lee-pasch-emotion-technikal-s-tidy-two-remix-hard-dance-coalition-en 3
65915 leighton-smith-feel-the-same-original-mix-hard-dance-coalition-en-2 4
65916 miss-behavin-such-a-good-feeling-the-freak-brothers-remix-hard-dance-coalition 4
65917 discam-dave-owens-round-round-original-mix-hard-dance-coalition 4
65918 alf-graham-bad-habits-original-mix-hard-dance-coalition 4
65919 valex-feel-donna-s-love-original-mix-hard-dance-coalition 4
65920 elle-mind-twister-original-mix-hard-dance-coalition 4
65921 rattez-ben-stevens-thunderstruck-original-mix-hard-dance-coalition-en 4
65922 leighton-smith-lovin-like-original-mix-hard-dance-coalition 4
65923 banks-taylor-wastin-time-original-mix-hard-dance-coalition 4
65924 leighton-smith-out-of-the-blues-original-mix-hard-dance-coalition 4
65925 alf-graham-hold-me-tight-original-mix-hard-dance-coalition 4
65926 leighton-smith-love-comes-down-original-mix-hard-dance-coalition 4