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 (
    125139, 125138, 125136, 125123, 125652, 
    125492, 125025, 125024, 125020, 125568, 
    125566, 124982, 125496, 124870, 124859, 
    124858, 125412, 125411, 124963, 124733, 
    124731, 124573, 124546, 124358, 124737, 
    124650, 124299, 124231, 124217, 124215
  ) 
  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.00065

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
124215 steven-jay-onda-loca-original-mix-cheeky-tracks 4
124217 the-kat-look-me-in-the-eye-extended-d 4
124231 danny-gibson-we-used-to-party-original-mix-generate-records 4
124299 drax-nelson-van-stoker-give-it-all-you-got-extended-mix-untidy 4
124358 shaun-williams-desire-2024-mix-flaunt 4
124546 nick-hughes-now-or-never-extended-mix-cheeky-tracks 4
124573 anne-savage-i-need-a-man-luvstruck-extended-remix-tidy-trax 4
124650 ribeye-upside-down-carnivore 4
124731 dj-kambel-dj-pulse-adelle-wings-of-love-extended-mix-cheeky-tracks 4
124733 the-kat-hours-only-extended-d 4
124737 dan-madams-feed-your-soul-feersum 4
124858 don-grant-gonna-get-ya-2024-remix-craig-jones-remix-pureaf-records 4
124859 don-grant-gonna-get-ya-the-first-time-mix-pureaf-records 4
124870 jordan-wroth-i-would-like-original-mix-this-is-bounce-uk-music 4
124963 sergio-caubal-ismael-lora-don-t-stop-original-mix-revibe-music 4
124982 vicente-belenguer-pepo-wb-super-base-original-mix-revibe-music 4
125020 danny-gibson-something-original-mix-bouncing-bomb-digital 4
125024 initi8-kymberley-myles-you-give-me-that-feeling-original-mix-this-is-bounce-uk-music 4
125025 danny-gibson-i-won-t-forget-original-mix-generate-records 4
125123 sergio-caubal-miguel-dj-dave-in-the-pool-original-mix-revibe-music 4
125136 kie-hughes-starman-walk-away-extended-mix-cheeky-tracks 4
125138 the-kat-phoenix-extended-d 4
125139 gav-adam-ali-wilson-don-t-stop-original-mix-flaunt 4
125411 nick-rafferty-can-u-dig-it-houserockers-extended-remix-tidy 4
125412 mr-boursin-tweek-freaky-fukkas-uk-gold-extended-remix-tidy 4
125492 12-inch-thumpers-don-t-cross-the-line-the-tidy-boys-extended-remix-tidy-trax 4
125496 rob-cain-everybody-extended-mix-manic-music 4
125566 bk-lucy-fur-get-hot-extended-mix-tidy 4
125568 tara-reynolds-mercy-od404-extended-remix-tidy 4
125652 donut-dotz-open-your-eyes-original-mix-sublime 4