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 (
    3656, 1610, 1606, 1608, 491, 1609, 1676, 
    1675, 1607, 1677, 3582, 1737, 1736, 
    1620, 1520, 1519, 858, 2692, 2988, 3580, 
    3581, 3587, 3639, 3579, 3642, 3627, 
    3178, 5225, 3453, 3452, 5220, 5223, 
    3577, 3451, 3450, 3449, 5226, 5227, 
    5219, 5217, 5221, 3179, 3138, 3448, 
    5224, 5218, 100, 95
  ) 
  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.00110

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "37.66"
    },
    "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": 57,
      "rows_produced_per_join": 57,
      "filtered": "100.00",
      "index_condition": "((`dbggbern`.`cscart_seo_names`.`object_id` in (3656,1610,1606,1608,491,1609,1676,1675,1607,1677,3582,1737,1736,1620,1520,1519,858,2692,2988,3580,3581,3587,3639,3579,3642,3627,3178,5225,3453,3452,5220,5223,3577,3451,3450,3449,5226,5227,5219,5217,5221,3179,3138,3448,5224,5218,100,95)) 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.96",
        "eval_cost": "5.70",
        "prefix_cost": "37.66",
        "data_read_per_join": "96K"
      },
      "used_columns": [
        "name",
        "object_id",
        "company_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}