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 (
    809, 5139, 5133, 5132, 5131, 5140, 6256, 
    6257, 6267, 6259, 6224, 6226, 6238, 
    6246, 6235, 6242, 6740, 6244, 6239, 
    6241, 6237, 6208, 6247, 6738, 6255, 
    6243, 6240, 6737, 6206, 6252, 6260, 
    6258, 6207, 6209, 6741, 6266, 6250, 
    6269, 6236, 6268, 4238, 2756, 4239, 
    3913, 3910, 4619, 3916, 3898
  ) 
  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.00165

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "38.11"
    },
    "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": 58,
      "rows_produced_per_join": 58,
      "filtered": "100.00",
      "index_condition": "((`dbggbern`.`cscart_seo_names`.`object_id` in (809,5139,5133,5132,5131,5140,6256,6257,6267,6259,6224,6226,6238,6246,6235,6242,6740,6244,6239,6241,6237,6208,6247,6738,6255,6243,6240,6737,6206,6252,6260,6258,6207,6209,6741,6266,6250,6269,6236,6268,4238,2756,4239,3913,3910,4619,3916,3898)) 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": "32.31",
        "eval_cost": "5.80",
        "prefix_cost": "38.11",
        "data_read_per_join": "98K"
      },
      "used_columns": [
        "name",
        "object_id",
        "company_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
809 card-dividers-multicolor 7
2756 chessex-signature-12mm-d6-with-pips-dice-blocks-36-dice-frosted-clear-w-black 7
3898 chessex-signature-12mm-d6-with-pips-dice-blocks-36-dice-scarab-blue-blood 7
3910 chessex-signature-12mm-d6-with-pips-dice-blocks-36-dice-lustrous-shadow-w-gold 7
3913 chessex-signature-12mm-d6-with-pips-dice-blocks-36-dice-glitter-polyhedral-ruby-gold 7
3916 chessex-signature-12mm-d6-with-pips-dice-blocks-36-dice-nebula-dark-blue-w-white 7
4238 chessex-signature-12mm-d6-with-pips-dice-blocks-36-dice-frosted-caribbean-blue-w-white 7
4239 chessex-signature-12mm-d6-with-pips-dice-blocks-36-dice-gemini-blue-blue-w-light-blue 7
4619 chessex-signature-12mm-d6-with-pips-dice-blocks-36-dice-marble-oxicopper-white 7
5131 chessex-ww2-dice-united-kingdom-gemini-blue-red-white-16mm-d6-dice-block-12-dice 7
5132 chessex-ww2-dice-japan-gemini-opaque-red-white-16mm-d6-dice-block-12-dice 7
5133 chessex-ww2-dice-germany-opaque-dark-grey-16mm-d6-dice-block-12-dice 7
5139 chessex-opaque-pastel-blue-black-16mm-d6-dice-block-12-dice 7
5140 chessex-ww2-dice-united-states-gemini-blue-red-white-16mm-d6-dice-block-12-dice 7
6206 chessex-gemini-12mm-d6-dice-blocks-with-pips-dice-blocks-36-dice-black-purple-w-gold 7
6207 chessex-gemini-12mm-d6-dice-blocks-with-pips-dice-blocks-36-dice-purple-red-w-gold 7
6208 chessex-16mm-d6-with-pips-dice-blocks-12-dice-vortex-blue-w-gold 7
6209 chessex-gemini-12mm-d6-dice-blocks-with-pips-dice-blocks-36-dice-purple-steel-w-white 7
6224 chessex-translucent-12mm-d6-dice-block-36-dice-speckled-fire 7
6226 chessex-12mm-d6-dice-block-36-dice-speckled-ninja 7
6235 chessex-16mm-d6-with-pips-dice-blocks-12-dice-frosted-blue-w-white 7
6236 chessex-opaque-16mm-d6-with-pips-dice-blocks-12-dice-yellow-w-black 7
6237 chessex-16mm-d6-with-pips-dice-blocks-12-dice-scarab-scarlet-w-gold 7
6238 chessex-16mm-d6-with-pips-dice-blocks-12-dice-festive-carousel-w-white 7
6239 chessex-16mm-d6-with-pips-dice-blocks-12-dice-nebula-dark-blue-w-white 7
6240 chessex-borealis-16mm-d6-royal-purple-gold-luminary-dice-block-12-dice 7
6241 chessex-borealis-16mm-d6-royal-purple-gold-luminary-dice-block-12-dice-clone 7
6242 chessex-16mm-d6-with-pips-dice-blocks-12-dice-festive-carousel-w-white-clone 7
6243 chessex-16mm-d6-with-pips-dice-blocks-12-dice-frosted-clear-w-black-clone 7
6244 chessex-16mm-d6-with-pips-dice-blocks-12-dice-marble-green-w-dark-green 7
6246 chessex-16mm-d6-with-pips-dice-blocks-12-dice-festive-vibrant-w-brown 7
6247 chessex-16mm-d6-with-pips-dice-blocks-12-dice-vortex-purple-w-gold 7
6250 chessex-opaque-12mm-d6-dice-blocks-with-pips-36-dice-black-pink 7
6252 chessex-translucent-12mm-d6-with-pips-dice-blocks-36-dice-purple-w-white-clone 7
6255 chessex-borealis-12mm-d6-purple-white-luminary-dice-block-36-dice-de 7
6256 chessex-12mm-d6-blocks-nebula-tm-12mm-d6-oceanic-gold-luminary-dice-block-36-dice 7
6257 chessex-12mm-d6-blocks-nebula-tm-12mm-d6-primary-blue-luminary-dice-block-36-dice 7
6258 chessex-12mm-d6-blocks-nebula-tm-12mm-d6-primary-blue-luminary-dice-block-36-dice-clone 7
6259 chessex-12mm-d6-blocks-nebula-tm-12mm-d6-spring-white-luminary-dice-block-36-dice 7
6260 chessex-gemini-12mm-d6-dice-blocks-with-pips-dice-blocks-36-dice-green-purple-w-gold 7
6266 chessex-speckled-12mm-d6-dice-blocks-with-pips-36-dice-mercury-clone-clone 7
6267 chessex-12mm-d6-blocks-nebula-tm-12mm-d6-red-silver-luminary-dice-block-36-dice 7
6268 chessex-12mm-d6-blocks-nebula-tm-12mm-d6-red-silver-luminary-dice-block-36-dice-clone 7
6269 chessex-opaque-12mm-d6-with-pips-dice-blocks-36-dice-dusty-blue-w-gold 7
6737 chessex-gemini-12mm-d6-dice-blocks-with-pips-dice-blocks-36-dice-black-green-w-gold 7
6738 chessex-borealis-12mm-d6-icicle-light-blue-luminary-dice-block-36-dice 7
6740 chessex-16mm-d6-with-pips-dice-blocks-12-dice-lustrous-gold-w-silver 7
6741 chessex-gemini-12mm-d6-dice-blocks-with-pips-dice-blocks-36-dice-purple-teal-w-gold 7