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 (
    4414, 4412, 4416, 7588, 7589, 7590, 7591, 
    7592, 7240, 7237, 7236, 7238, 7239, 
    5875, 5877, 5874, 5879, 5880, 5873, 
    5876, 5878, 5881, 5872, 3999, 4004, 
    4005, 4003, 4002, 4006, 4001, 4000, 
    4598, 2510, 2507, 2508, 2511, 2509, 
    3753, 489, 493, 494, 488, 492, 416, 497, 
    495, 3182, 3181
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'de' 
  AND (
    1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00207

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "36.31"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code"
      ],
      "key_length": "206",
      "rows_examined_per_scan": 54,
      "rows_produced_per_join": 54,
      "filtered": "100.00",
      "index_condition": "((`dbggbern`.`cscart_seo_names`.`object_id` in (4414,4412,4416,7588,7589,7590,7591,7592,7240,7237,7236,7238,7239,5875,5877,5874,5879,5880,5873,5876,5878,5881,5872,3999,4004,4005,4003,4002,4006,4001,4000,4598,2510,2507,2508,2511,2509,3753,489,493,494,488,492,416,497,495,3182,3181)) and (`dbggbern`.`cscart_seo_names`.`type` = 'p') and (`dbggbern`.`cscart_seo_names`.`dispatch` = '') and (`dbggbern`.`cscart_seo_names`.`lang_code` = 'de'))",
      "cost_info": {
        "read_cost": "30.91",
        "eval_cost": "5.40",
        "prefix_cost": "36.31",
        "data_read_per_join": "91K"
      },
      "used_columns": [
        "name",
        "object_id",
        "company_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
416 ultimate-guard-boulder-deck-case-100-standardgroese-onyx 7/9
488 ultimate-guard-boulder-deck-case-100-standardgroese-frosted 7/9
489 ultimate-guard-boulder-deck-case-100-standardgroese-amber 7/9
492 ultimate-guard-boulder-deck-case-100-standardgroese-malachite 7/9
493 ultimate-guard-boulder-deck-case-100-standardgroese-amethyst 7/22/24
494 ultimate-guard-boulder-deck-case-100-standardgroese-clear 7/9
495 ultimate-guard-boulder-deck-case-100-standardgroese-ruby 7/9
497 ultimate-guard-boulder-deck-case-100-standardgroese-topaz 7/9
2507 ultimate-guard-boulderntray-100-frosted 7
2508 ultimate-guard-boulderntray-100-onyx 7
2509 ultimate-guard-boulderntray-100-sapphire 7
2510 ultimate-guard-boulderntray-100-emerald 7
2511 ultimate-guard-boulderntray-100-ruby 7
3181 ultimate-guard-boulder-deck-case-100-standardgroese-synergy-rot-schwarz 7/9
3182 ultimate-guard-boulder-deck-case-100-standardgroese-synergy-grun-schwarz 7
3753 ultimate-guard-boulder-deck-case-100-standardsize-emerald 7/9
3999 ultimate-guard-boulder-deck-case-100-solid-black 7
4000 ultimate-guard-boulder-deck-case-100-solid-white 7
4001 ultimate-guard-boulder-deck-case-100-solid-red 7
4002 ultimate-guard-boulder-deck-case-100-solid-petrol 7
4003 ultimate-guard-boulder-deck-case-100-solid-grey 7
4004 ultimate-guard-boulder-deck-case-100-solid-blue 7
4005 ultimate-guard-boulder-deck-case-100-solid-green 7
4006 ultimate-guard-boulder-deck-case-100-solid-purple 7
4412 ultimate-guard-boulder-100-druidic-secrets-nubis-lavendel 7/9
4414 ultimate-guard-boulder-100-druidic-secrets-impetus-dunkelorange 7/9
4416 ultimate-guard-boulder-100-druidic-secrets-sol-sand 7/9
4598 ultimate-guard-boulderntray-100-clear 7
5872 ultimate-guard-boulder-100-magic-the-gathering-guild-summit-simic 7
5873 ultimate-guard-boulder-100-magic-the-gathering-guild-summit-izzet 7
5874 ultimate-guard-boulder-100-magic-the-gathering-guild-summit-dimir 7
5875 ultimate-guard-boulder-100-magic-the-gathering-guild-summit-azorius 7
5876 ultimate-guard-boulder-100-magic-the-gathering-guild-summit-orzhov 7
5877 ultimate-guard-boulder-100-magic-the-gathering-guild-summit-boros 7
5878 ultimate-guard-boulder-100-magic-the-gathering-guild-summit-rakdos 7
5879 ultimate-guard-boulder-100-magic-the-gathering-guild-summit-golgari 7
5880 ultimate-guard-boulder-100-magic-the-gathering-guild-summit-gruul 7
5881 ultimate-guard-boulder-100-magic-the-gathering-guild-summit-selesnya 7
7236 ultimate-guard-boulder-100-magic-the-gathering-edge-of-eternities-design-05 7
7237 ultimate-guard-boulder-100-magic-the-gathering-edge-of-eternities-design-04 7
7238 ultimate-guard-boulder-100-magic-the-gathering-edge-of-eternities-design-03 7
7239 ultimate-guard-boulder-100-magic-the-gathering-edge-of-eternities-design-02 7
7240 ultimate-guard-boulder-100-magic-the-gathering-edge-of-eternities-design-01 7
7588 ultimate-guard-boulder-100-hybrid-magic-the-gathering-mana-edition-forest 7
7589 ultimate-guard-boulder-100-hybrid-magic-the-gathering-mana-edition-island 7
7590 ultimate-guard-boulder-100-hybrid-magic-the-gathering-mana-edition-mountain 7
7591 ultimate-guard-boulder-100-hybrid-magic-the-gathering-mana-edition-plains 7
7592 ultimate-guard-boulder-100-hybrid-magic-the-gathering-mana-edition-swamp 7