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 (
    104, 2593, 2711, 2710, 2693, 2709, 2976, 
    2735, 2694, 3187, 2990, 4735, 2991, 
    2989, 863, 1478, 1479, 781, 862, 3175, 
    7926, 1480, 1482, 2446, 1481, 6430, 
    6431, 7254, 7255, 4050, 4051, 4602, 
    4049, 4034, 4048, 4419, 4601, 4422, 
    4418, 4421, 4420, 4423, 4600, 5961, 
    5960, 5958, 5959, 5213, 621, 860, 619, 
    861, 5653, 59, 122, 5662, 61, 2992, 5663, 
    123, 63, 58, 121, 124, 62, 785, 784, 786, 
    782, 787, 783, 1511, 3586, 1924, 1773, 
    3665, 3666, 4625, 6421, 7262, 5971, 
    1727, 5957, 6422, 6423, 6424, 7252, 
    7253, 7250, 6717, 6719, 6718, 7251, 
    4614, 3869, 1772
  ) 
  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.00137

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "72.61"
    },
    "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": 108,
      "rows_produced_per_join": 108,
      "filtered": "100.00",
      "index_condition": "((`dbggbern`.`cscart_seo_names`.`object_id` in (104,2593,2711,2710,2693,2709,2976,2735,2694,3187,2990,4735,2991,2989,863,1478,1479,781,862,3175,7926,1480,1482,2446,1481,6430,6431,7254,7255,4050,4051,4602,4049,4034,4048,4419,4601,4422,4418,4421,4420,4423,4600,5961,5960,5958,5959,5213,621,860,619,861,5653,59,122,5662,61,2992,5663,123,63,58,121,124,62,785,784,786,782,787,783,1511,3586,1924,1773,3665,3666,4625,6421,7262,5971,1727,5957,6422,6423,6424,7252,7253,7250,6717,6719,6718,7251,4614,3869,1772)) 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": "61.81",
        "eval_cost": "10.80",
        "prefix_cost": "72.61",
        "data_read_per_join": "183K"
      },
      "used_columns": [
        "name",
        "object_id",
        "company_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
58 ultimate-guard-katana-sleeves-standardgroese-transparent-100 7/8
59 ultimate-guard-katana-sleeves-standardgroese-blau-100 7/8
61 ultimate-guard-katana-sleeves-standardgroese-grun-100 7/8
62 ultimate-guard-katana-sleeves-standardgroese-weiss-100 7/8
63 ultimate-guard-katana-sleeves-standardgroese-schwaz-100 7/8
104 ultimate-guard-digital-life-pad-9 7/28
121 ultimate-guard-katana-sleeves-standardgroese-turkis-100 7
122 ultimate-guard-katana-sleeves-standardgroese-gelb-100 7
123 ultimate-guard-katana-sleeves-standardgroese-orange-100 7
124 ultimate-guard-katana-sleeves-standardgroese-violett-100 7/8
619 ultimate-guard-katana-sleeves-japanische-groesse-blau-60 7/8
621 ultimate-guard-katana-sleeves-japanische-groesse-blau-60-de 7/8
781 ultimate-guard-flexxfolio-360-18-pocket-xenoskin-schwarz 7
782 ultimate-guard-magnetic-card-case-35-pt 7
783 ultimate-guard-magnetic-card-case-55-pt 7
784 ultimate-guard-magnetic-card-case-130-pt-de 7
785 ultimate-guard-magnetic-card-case-100-pt 7
786 ultimate-guard-magnetic-card-case-100-pt-clone 7
787 ultimate-guard-magnetic-card-case-360-pt 7
860 ultimate-guard-katana-sleeves-japanische-groesse-rot-60 7/8
861 ultimate-guard-katana-sleeves-japanische-groesse-turquiose-60 7/8
862 ultimate-guard-flexxfolio-360-18-pocket-xenoskin-white 7/22/24
863 ultimate-guard-flexxfolio-360-18-pocket-xenoskin-blue 7
1478 ultimate-guard-flexxfolio-360-18-pocket-xenoskin-grun 7/16
1479 ultimate-guard-flexxfolio-360-18-pocket-xenoskin-rot 7/16
1480 ultimate-guard-flexxfolio-480-24-pocket-quadrow-blau 7
1481 ultimate-guard-flexxfolio-480-24-pocket-quadrow-weiss 7
1482 ultimate-guard-flexxfolio-480-24-pocket-quadrow-rot 7
1511 ultimate-guard-magnetic-card-case-75-pt 7
1727 ultimate-guard-play-mat-design-wordmark 7
1772 ultimate-guard-precise-fit-japanese-size 7
1773 ultimate-guard-omnihive-1000-pastelgrun-limited-2022 7
1924 ultimate-guard-multi-tokens-25er-pack 7
2446 ultimate-guard-flexxfolio-480-24-pocket-quadrow-rot-de 7
2593 ultimate-guard-flexxfolio-160-8-pocket-blau 7
2693 ultimate-guard-flexxfolio-160-8-pocket-schwarz 7
2694 ultimate-guard-flexxfolio-20-2-pocket-schwarz 7
2709 ultimate-guard-flexxfolio-160-8-pocket-weiss 7
2710 ultimate-guard-flexxfolio-160-8-pocket-rot 7
2711 ultimate-guard-flexxfolio-160-8-pocket-rot-clone 7
2735 ultra-pro-binder-eclipse-2-pocket-grun 7
2976 ultimate-guard-flexxfolio-20-2-pocket-blau 7
2989 ultimate-guard-flexxfolio-360-18-pocket-weiss 7
2990 ultimate-guard-flexxfolio-360-18-pocket-green 7/16
2991 ultimate-guard-flexxfolio-360-18-pocket-orange 7/22/24
2992 ultimate-guard-katana-sleeves-standardgroese-inner-sleeves-100 7/8
3175 ultimate-guard-flexxfolio-360-18-pocket-black 7
3187 ultimate-guard-flexxfolio-360-18-pocket-blau 7
3586 ultimate-guard-matpod-blau 7
3665 ultimate-guard-omnihive-1000-blue 7
3666 ultimate-guard-omnihive-1000-grey 7
3869 ultimate-guard-portfolio-480-24-pocket-xenoskin-quadrow-schwarz 7/22/24
4034 ultimate-guard-flipntray-deck-case-100-standardgroese-xenoskin-grau-clone 7
4048 ultimate-guard-flipntray-100-xenoskin-monocolor-weis 7/22/24
4049 ultimate-guard-flipntray-100-xenoskin-monocolor-rot 7
4050 ultimate-guard-flipntray-100-xenoskin-monocolor-blau 7/22/24
4051 ultimate-guard-flipntray-100-xenoskin-monocolor-grau 7
4418 ultimate-guard-flipntray-133-xenoskin-lila 7/9
4419 ultimate-guard-flipntray-133-xenoskin-blau 7/9
4420 ultimate-guard-flipntray-133-xenoskin-rot 7/9
4421 ultimate-guard-flipntray-133-xenoskin-petrol 7
4422 ultimate-guard-flipntray-133-xenoskin-grun 7/9
4423 ultimate-guard-flipntray-133-xenoskin-schwarz 7/9
4600 ultimate-guard-flipntray-133-xenoskin-weiss 7/9
4601 ultimate-guard-flipntray-133-xenoskin-grey 7/9
4602 ultimate-guard-flipntray-100-xenoskin-monocolor-green 7
4614 ultimate-guard-portfolio-480-24-pocket-xenoskin-quadrow-blau 7
4625 ultimate-guard-omnihive-1000-petrol 7
4735 ultimate-guard-flexxfolio-360-18-pocket-mystic-space-edition 7
5213 ultimate-guard-katana-inner-sleeves-japanese-size-transparent-100 7
5653 ultimate-guard-katana-sleeves-standard-size-jade-garden-100 7
5662 ultimate-guard-katana-sleeves-standardgroese-great-wave-100 7
5663 ultimate-guard-katana-sleeves-standardgroese-mountain-haze-100 7
5957 ultimate-guard-play-mat-rainforest-green 7
5958 ultimate-guard-flipntray-80-xenoskin-monocolor-schwarz 7
5959 ultimate-guard-flipntray-80-xenoskin-monocolor-weiss 7
5960 ultimate-guard-flipntray-80-xenoskin-monocolor-rot 7
5961 ultimate-guard-flipntray-80-xenoskin-monocolor-blau 7
5971 ultimate-guard-play-mat-canary-orange 7
6421 ultimate-guard-omnihive-1000-xenoskin-magic-the-gathering-aetherdrift 1
6422 ultimate-guard-play-mat-magic-the-gathering-aetherdrift-hazoret-godseeker 1
6423 ultimate-guard-play-mat-magic-the-gathering-aetherdrift-ketramose-the-new-dawn 1
6424 ultimate-guard-play-mat-magic-the-gathering-aetherdrift-sab-sunen-luxa-embodied 1
6430 ultimate-guard-flipntray-100-xenoskin-magic-the-gathering-aetherdrift-hazoret-godseeker 1
6431 ultimate-guard-flipntray-100-xenoskin-magic-the-gathering-aetherdrift-sab-sunen-luxa-embodied 1
6717 ultimate-guard-play-mat-magic-the-gathering-tarkir-dragonstorm-abzan-devotee 1
6718 ultimate-guard-play-mat-magic-the-gathering-tarkir-dragonstorm-mystic-monastery 1
6719 ultimate-guard-play-mat-magic-the-gathering-tarkir-dragonstorm-mystic-monastery-clone 1
7250 ultimate-guard-play-mat-magic-the-gathering-edge-of-eternities-the-endstone 7
7251 ultimate-guard-play-mat-magic-the-gathering-watery-grave 7
7252 ultimate-guard-play-mat-magic-the-gathering-edge-of-eternities-godless-shrine 7
7253 ultimate-guard-play-mat-magic-the-gathering-edge-of-eternities-haliya-and-tezzeret 7
7254 ultimate-guard-flipntray-100-xenoskin-magic-the-gathering-edge-of-eternities-the-endstone 7
7255 ultimate-guard-flipntray-133-xenoskin-magic-the-gathering-edge-of-eternities-haliya-and-tezzeret 7
7262 ultimate-guard-omnihive-1000-xenoskin-magic-the-gathering-edge-of-eternities 7/22/24
7926 ultimate-guard-flexxfolio-360-18-pocket-red 7