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 (
    74072, 74071, 74056, 73996, 73977, 73815, 
    73673, 73599, 73598, 73821, 73994, 
    73976, 73740, 73734, 73880, 73819, 
    73484, 73483, 73820, 73874, 73626, 
    73873, 73872, 73871, 73870, 73869, 
    73868, 73867, 73866, 73865, 73864, 
    73863, 73862, 73861, 73860, 73859, 
    73858, 73857, 73856, 73855
  ) 
  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.00078

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
73483 one-foot-in-the-rave-bring-you-joy-radio-edit-cheeky-tracks 6
73484 one-foot-in-the-rave-bring-you-joy-original-mix-cheeky-tracks 6
73598 equinox-condemned-original-mix-vicious-circle 6
73599 equinox-condemned-matt-clarkson-remix-vicious-circle 6
73626 rat-e-brain-ticket-original-mix-hot-box-digital 6
73673 mr.-e-dj-ben-banga-matt-forgotten-requiem-asylum-2019-rework-drop-bear-digital 6
73734 ant-hornsby-elevate-original-mix-tuff-groove-recordings 6
73740 fredrik-redegard-omg-original-mix-the-filth-foundry 6
73815 ben-stevens-gary-o-connor-in-my-mind-digital-snail 6
73819 martyn-curran-the-bullet-class-a-digital 6
73820 steve-clack-roll-away-inside-out-digital 6
73821 sean-inside-out-cuttin-class-inside-out-digital 6
73855 third-degree-gurns-99-beans-and-a-gurn-ain-t-1-fireball-en 6
73856 dean-rooker-lee-mills-live-for-the-weekend-fireball-en 6
73857 james-valentine-ben-stevens-extermination-fireball-en 6
73858 d-fi-matt-wade-beltrofix-artificial-intelligence-fireball-en 6
73859 manik-feat-emma-hand-sanctify-fireball 6
73860 marc-lewis-old-school-experience-fireball-en 6
73861 shenton-baseglitz-no-pity-fireball-en 6
73862 dina-watson-si-stevens-reggie-fag-ash-charlie-goddard-remix-fireball-en 6
73863 dina-watson-si-stevens-reggie-fag-ash-teck071-remix-fireball-en 6
73864 darren-em-elliot-fletcher-that-hurt-fireball-en 6
73865 dan-joseph-the-architect-fireball-en 6
73866 craig-jones-wonky-horror-show-fireball-en 6
73867 ultranova-one-last-time-fireball-en 6
73868 dark-matter-hoover-jam-fireball-en 6
73869 ultranova-major-rager-fireball-en 6
73870 rattez-ben-stevens-astral-projection-fireball-en 6
73871 rick-james-seam-zodd-end-of-days-fireball-en 6
73872 mikey-8-rules-fireball-en 6
73873 pat-kelly-resonator-fireball 6
73874 nippy-baines-gorilla-warfare-style-digital-damage-recordings 6
73880 one-foot-in-the-rave-catch-the-light-original-mix-digital-elements-recordings 6
73976 kumite-cannonball-run-nitrox 6
73977 manik-simplicity-fruition-records 6
73994 nico-ahlqvist-matt-clarkson-born-ready-tempo-trax 6
73996 kirk-p-different-forever-whatever-premonition-digital 6
74056 frank-farrell-fickletwitch-stop-my-heart-fireball 6
74071 karim-love-twist-trax 6
74072 james-nardi-last-dance-twist-trax 6