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 (
    88095, 88094, 88093, 88092, 88091, 88090, 
    88089, 88088, 88087, 88086, 88082, 
    88081, 87851, 87731, 87730, 87729, 
    87728, 88625, 88624, 88623, 88039, 
    88532, 88531, 88530, 88406, 88405, 
    88404, 88403, 88402, 88401, 87762, 
    87678, 88629, 88628, 88627, 88626, 
    88575, 88574, 88573, 88149
  ) 
  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.00066

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
87678 solo-never-agent-original-mix-stomp-inc-uk 22
87728 nordcore-gmbh-pandemic-original-mix-mokum-records 22
87729 nordcore-gmbh-xtc-original-mix-mokum-records 22
87730 nordcore-gmbh-hartcore-factory-original-mix-mokum-records 22
87731 nordcore-gmbh-reign-of-terror-909-junkies-remix-mokum-records 22
87762 solo-jimmy-the-bastard-original-mix-stomp-inc-uk 22
87851 mark-ridjel-maltezer-original-mix-stomp-inc-uk 22
88039 dj-darroo-screamerz-original-mix-infused-traxx 22
88081 two-minds-project-scared-extended-mix-oneseventy 22
88082 two-minds-project-scared-radio-edit-oneseventy 22
88086 angstfrai-baiz-original-mix-core-rebelz-records 22
88087 c-devastator-my-name-is-hardcore-original-mix-core-rebelz-records 22
88088 droonix-isolation-original-mix-core-rebelz-records 22
88089 fifthy-memorized-original-mix-core-rebelz-records 22
88090 fucking-paranoid-creampie-original-mix-core-rebelz-records 22
88091 gabbanatic-fucked-frequencies-original-mix-core-rebelz-records 22
88092 mrna-take-me-away-original-mix-core-rebelz-records 22
88093 sneith-bloodle-vortex-original-mix-core-rebelz-records 22
88094 those-early-gabber-guys-heads-original-mix-core-rebelz-records 22
88095 preacker-morfina-original-mix-core-rebelz-records 22
88149 surgery-anarchy-original-mix-recharged 22
88401 imperium-bass-d-ohmicyd-rude-killaz-original-mix-exode-records 22
88402 imperium-bass-s-aphira-hardcore-bastardz-original-mix-exode-records 22
88403 d-ohmicyd-wars-industry-a.c.a.b-original-mix-exode-records 22
88404 d-ohmicyd-wars-industry-docside-original-mix-exode-records 22
88405 d-ohmicyd-wars-industry-kill-cop-s-original-mix-exode-records 22
88406 d-ohmicyd-wars-industry-kill-cop-s-the-loading-project-remix-exode-records 22
88530 the-sequel-let-it-out-original-mix-bombs-bullets-records 22
88531 the-sequel-hyrule-war-no-antidote-original-mix-bombs-bullets-records 22
88532 the-sequel-sinister-seven-the-holy-one-original-mix-bombs-bullets-records 22
88573 m1dlet-get-louder-original-mix-bounce-back-records 22
88574 m1dlet-dope-track-original-mix-bounce-back-records 22
88575 m1dlet-sipping-on-hate-original-mix-bounce-back-records 22
88623 mansy-lara-b-summer-time-original-mix-scarred-digital 22
88624 mansy-lara-b-summer-time-x-cyte-hardcore-mix-scarred-digital 22
88625 mansy-lara-b-summer-time-old-skool-junkies-breakbeat-remix-scarred-digital 22
88626 dj-thera-stormtrooper-part-e-time-original-mix-rave-muzik 22
88627 stormtrooper-dj-thera-all-over-again-original-mix-rave-muzik 22
88628 dj-thera-stormtrooper-part-e-time-radio-edit-rave-muzik 22
88629 stormtrooper-dj-thera-all-over-again-radio-edit-rave-muzik 22