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 (
    68974, 68973, 68972, 68971, 68970, 68969, 
    68968, 68967, 68966, 68965, 68964, 
    68963, 68962, 68961, 68960, 68959, 
    68958, 68957, 68956, 68955, 68954, 
    68953, 68952, 68951, 68950, 68949, 
    68948, 68947, 68946, 68945, 68321, 
    68290, 68289, 68288, 68286, 68285, 
    68284, 68283, 68282, 68281
  ) 
  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.00055

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

Result

product_id seo_name seo_path
68281 audox-gilly-flash-paul-maddox-lazer-dub-cheeky-tracks-en 4
68282 kye-shand-jack-butler-body-rock-original-mix-cheeky-tracks-en-2 4
68283 ross-homson-cock-a-hoop-original-mix-cheeky-tracks 4
68284 kye-shand-jack-butler-way-you-move-pick-load-s-mindblowing-remix-cheeky-tracks-en 4
68285 starman-general-bounce-that-whitney-choon-left-eye-remix-cheeky-tracks-en 4
68286 ross-homson-astoria-original-mix-cheeky-tracks 4
68288 starman-dj-saber-nikki-a-feeling-alf-graham-remix-cheeky-tracks 4
68289 ben-stevens-paul-stacey-let-s-hoover-original-mix-cheeky-tracks-en 4
68290 elivate-general-bounce-the-finest-original-mix-cheeky-tracks-en 4
68321 fran-dj-drop-the-hardhouse-beat-original-mix-energy-hard-espana 4
68945 steve-maynard-slipped-disc-original-mix-hard-dance-coalition 4
68946 maddox-townend-higher-ground-original-mix-hard-dance-coalition 4
68947 amp-attack-funky-bandwagon-original-mix-hard-dance-coalition-en 4
68948 swack-hotwire-drum-beats-original-mix-hard-dance-coalition-en 4
68949 ben-stevens-super-groover-original-mix-hard-dance-coalition 4
68950 agent-jack-ambush-original-mix-hard-dance-coalition-en-3 4
68951 foreign-body-power-trip-original-mix-hard-dance-coalition-en 4
68952 rj-ruskul-need-rhythm-original-mix-hard-dance-coalition 4
68953 beat-jammers-how-low-can-you-go-original-mix-hard-dance-coalition 4
68954 ben-stevens-tenchy-amsterdancing-original-mix-hard-dance-coalition 4
68955 andy-farley-ben-stevens-move-your-rover-lox-leigh-green-remix-hard-dance-coalition 4
68956 aftermath-you-got-me-original-mix-hard-dance-coalition 4
68957 groove-complex-jacks-hammer-original-mix-hard-dance-coalition 4
68958 all-boxed-in-these-things-happen-maddox-townend-s-dd-dub-hard-dance-coalition 4
68959 ingo-masmada-diversion-citrus-groove-original-mix-hard-dance-coalition 4
68960 armitage-shanks-coming-out-of-the-wc-original-mix-hard-dance-coalition 4
68961 beat-jammers-funk-inc-original-mix-hard-dance-coalition 4
68962 digital-mafia-get-out-of-my-head-original-mix-hard-dance-coalition 4
68963 ben-stevens-tenchy-scratch-sniff-original-mix-hard-dance-coalition 4
68964 james-devlin-step-up-do-dat-dance-original-mix-hard-dance-coalition 4
68965 olive-grooves-hot-toddy-original-mix-hard-dance-coalition 4
68966 beat-jammers-dutch-n-famous-original-mix-hard-dance-coalition 4
68967 kev-dunkling-heartbreak-original-mix-hard-dance-coalition 4
68968 groove-complex-your-love-original-mix-hard-dance-coalition 4
68969 jp-jukesy-amp-attack-loose-hands-original-mix-hard-dance-coalition 4
68970 beat-jammers-get-it-bwoy-original-mix-hard-dance-coalition-en 4
68971 paul-maddox-ben-stevens-in-your-hands-olive-grooves-danger-dub-hard-dance-coalition-en 4
68972 groove-complex-do-you-hear-the-sound-original-mix-hard-dance-coalition 4
68973 maddox-townend-sweat-down-original-mix-hard-dance-coalition 4
68974 digital-mafia-waiting-4-u-original-mix-hard-dance-coalition-en 4