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 (
    6763, 6761, 4583, 4591, 5943, 4869, 4870, 
    4871, 4882, 4873, 4880, 4858, 7105, 
    7099, 7085, 7107, 7083, 7127, 7131, 
    7114, 5780, 5781, 5589, 6951, 6324, 
    4579, 4580, 5419, 5180, 5420, 5711, 
    5714, 5866, 6033, 5157, 4749, 5636, 
    6408, 7427, 6387, 4969, 4968, 5721, 
    7641, 2626, 2627, 5784, 5782
  ) 
  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.00180

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "37.21"
    },
    "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": 56,
      "rows_produced_per_join": 56,
      "filtered": "100.00",
      "index_condition": "((`dbggbern`.`cscart_seo_names`.`object_id` in (6763,6761,4583,4591,5943,4869,4870,4871,4882,4873,4880,4858,7105,7099,7085,7107,7083,7127,7131,7114,5780,5781,5589,6951,6324,4579,4580,5419,5180,5420,5711,5714,5866,6033,5157,4749,5636,6408,7427,6387,4969,4968,5721,7641,2626,2627,5784,5782)) 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": "31.61",
        "eval_cost": "5.60",
        "prefix_cost": "37.21",
        "data_read_per_join": "94K"
      },
      "used_columns": [
        "name",
        "object_id",
        "company_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
2626 up-satin-tower-boombox 7/9
2627 up-satin-tower-glitter-black 7/9
4579 up-magic-the-gathering-the-lost-caverns-of-ixalan-12-pocket-pro-binder 7
4580 up-magic-the-gathering-the-lost-caverns-of-ixalan-9-pocket-premium-zippered-pro-binder 7
4583 up-elite-series-charizard-12-pocket-zippered-pro-binder 7/16
4591 up-elite-series-charizard-alcove-flip-for-pokemon 7/9
4749 up-page-for-psa-black-1ct 7/22/23
4858 up-fallout-spiral-life-pad-for-magic-the-gathering 7
4869 up-fallout-12-pocket-pro-binder-z-for-magic-the-gathering 7
4870 up-fallout-6ft-table-playmat-for-magic-the-gathering 7
4871 up-fallout-8ft-table-playmat-for-magic-the-gathering 7
4873 up-fallout-playmat-b-for-magic-the-gathering 7
4880 up-fallout-playmat-v5-for-magic-the-gathering 7
4882 up-fallout-black-stitched-playmat-w-for-magic-the-gathering 7
4968 up-pokemon-trick-room-pro-binder-9-pocket 7
4969 up-pokemon-trick-room-alcove-click-box 7
5157 up-outlaws-of-thunder-junction-ar-enhanced-holofoil-playmat-z-for-magic-the-gathering 7
5180 up-mana-8-12-pocket-zip-pro-binder-lotus-for-magic-the-gathering 7
5419 up-mana-8-12-pocket-zip-pro-binder-island-for-magic-the-gathering 7
5420 up-mana-8-12-pocket-zip-pro-binder-swamp-for-magic-the-gathering 7
5589 up-foundations-learn-to-play-1-player-battlemat-for-magic-the-gathering 7
5636 page-for-psa-black-3-hole-40 7/39
5711 up-mana-8-dropship-storage-box-lotus-for-magic-the-gathering 7
5714 up-mana-8-premium-duo-deck-box-lotus-for-magic-the-gathering 7
5721 up-regular-toploader 7
5780 up-foundations-105ct-apex-deck-protector-sleeves-for-magic-the-gathering 7
5781 up-foundations-alcove-flip-deck-box-for-magic-the-gathering 7
5782 up-secret-lair-sale-5-2024-julie-bell-playmat-elves-of-deep-shadow-for-magic-the-gathering 7
5784 up-secret-lair-sale-5-2024-julie-bell-playmat-coat-of-arms-for-magic-the-gathering 7
5866 up-mountain-retreat-105ct-apex-deck-protector-sleeves-for-bob-ross 7
5943 up-elite-series-pikachu-playmat 36
6033 up-one-touch-wall-display 7/22/23
6324 up-innistrad-remastered-black-stitched-playmat-pw-b-for-magic-the-gathering 7
6387 up-pokemon-pikachu-play-mat 36
6408 up-pikachu-pro-binder-9-pocket 36
6761 up-elite-gengar-premium-alcove-flip-for-pokemon 7
6763 up-elite-gengar-9-pocket-zippered-pro-binder-for-pokemon 7
6951 up-graded-card-box 7/22/23
7083 up-final-fantasy-holofoil-playmat-premium-for-magic-the-gathering 7/22/23
7085 up-final-fantasy-black-stitched-playmat-premium-y-for-magic-the-gathering 7/22/23
7099 up-final-fantasy-100ct-deck-protector-sleeves-v7-for-magic-the-gathering 7
7105 up-final-fantasy-100ct-deck-protector-sleeves-v1-for-magic-the-gathering 7
7107 up-final-fantasy-double-sided-playmat-premium-t-for-magic-the-gathering 7/22/23
7114 up-final-fantasy-playmat-v3-for-magic-the-gathering 7/22/23
7127 up-final-fantasy-playmat-h-for-magic-the-gathering 7/22/23
7131 up-final-fantasy-playmat-m-for-magic-the-gathering 7/22/23
7427 up-pokemon-pikachu-alcove-tower-deck 7
7641 up-return-to-tarkir-q2-2025-105ct-apex-deck-protector-sleeves-jeskai-for-magic-the-gathering 7