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 (
    58722, 59121, 58587, 58854, 58778, 58646, 
    58357, 57734, 58959, 58958, 58961, 
    58952, 58951, 58950, 58949, 58948, 
    58947, 58946, 58945, 58944, 58943, 
    58942, 58941, 58940, 58939, 58938, 
    58937, 58936, 58935, 58934, 58933, 
    58932, 58931, 58930, 58929, 58928, 
    58927, 58926, 58925, 58924
  ) 
  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.00063

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
57734 defective-audio-circular-saw-wayne-g-remix-frantic-digital 6
58357 benjamin-collie-elements-original-mix-industry 6
58587 baz-coleman-rawcock-original-mix-xtrahard-records 6
58646 tara-banks-irn-groove-premonition-digital 6
58722 teck071-ffs-original-mix-drop-bear-digital 6
58778 matt-wade-d-fi-the-fear-fireball 6
58854 trauma-higher-eamonn-fevah-remix-vicious-circle 6
58924 theyre-out-to-get-me-original-mix 6
58925 oblivion-alex-penn-remix 6
58926 shout-it-out-original-mix 6
58927 duel-testube-babies-remix-en 6
58928 bigger-and-better-unreleased-mix 6
58929 power-of-the-sun-colin-barratt-remix-en 6
58930 alright-dave-owens-remix 6
58931 fantastic-paul-kings-twisted-t-remix-en 6
58932 its-my-beat-nik-denton-dave-owens-remix 6
58933 son-of-a-bitch-original-mix 6
58934 odyssey-part-2-ilogik-paul-janes-remix 6
58935 the-killer-original-mix 6
58936 smokin-original-mix 6
58937 fierceness-original-mix 6
58938 red-alert-original-mix 6
58939 if-you-want-original-mix 6
58940 spacehopper-ingo-remix 6
58941 meet-fu-yung-nik-denton-remix 6
58942 red-bush-original-mix 6
58943 malice-in-wonderland-2001-vocal-mix 6
58944 out-there-original-mix-en-5 6
58945 gods-child-ben-townsend-remix 6
58946 im-alive-original-mix-en-2 6
58947 turn-it-up-nik-denton-dave-owens-remix 6
58948 stone-rockin-original-mix 6
58949 block-rockin-beats-original-mix 6
58950 deep-swarm-original-mix 6
58951 recoil-paul-glazby-remix 6
58952 fuck-em-all-dr-tre-remix 6
58958 vox-go-keep-it-up-bw-s-big-boogies 6
58959 keep-it-up-bw-s-big-boogies 6
58961 barry-harding-shoot-out-inside-out-digital 6
59121 jondog-in-full-flex-digital-damage-recordings 6