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 (
    5680, 5681, 5682, 5683, 5684, 5685, 5686, 
    5687, 5688, 5689, 5690, 5691, 5692, 
    5693, 5694, 5695, 5696, 5697, 5698, 
    5699, 5700, 5701, 5702, 5703, 5704, 
    5705, 5706, 5707, 5708, 5709, 5710, 
    5711, 5712, 5713, 5714, 5715, 5716, 
    5717, 5718, 5719, 5720, 5721, 1479, 
    1480, 1481, 1482, 1483, 5188, 5189, 
    5190, 5191, 5192, 5193, 1467, 1468, 
    1469, 1470, 1471, 5176, 5177, 5178, 
    5179, 5180, 5181, 447, 448, 449, 450, 
    451, 452, 453, 454, 455, 1932, 1933, 
    1934, 1935, 1936, 1937, 1938, 1939, 
    1940, 1941, 1942, 1943, 1944, 1945, 
    1946, 1947, 1948, 1949, 1950, 1951, 
    1952, 1953, 1954
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00138

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "134.41"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code",
        "company_id"
      ],
      "key_length": "210",
      "rows_examined_per_scan": 192,
      "rows_produced_per_join": 192,
      "filtered": "100.00",
      "index_condition": "((`gaseus`.`cscart_seo_names`.`object_id` in (5680,5681,5682,5683,5684,5685,5686,5687,5688,5689,5690,5691,5692,5693,5694,5695,5696,5697,5698,5699,5700,5701,5702,5703,5704,5705,5706,5707,5708,5709,5710,5711,5712,5713,5714,5715,5716,5717,5718,5719,5720,5721,1479,1480,1481,1482,1483,5188,5189,5190,5191,5192,5193,1467,1468,1469,1470,1471,5176,5177,5178,5179,5180,5181,447,448,449,450,451,452,453,454,455,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954)) and (`gaseus`.`cscart_seo_names`.`type` = 'p') and (`gaseus`.`cscart_seo_names`.`dispatch` = '') and (`gaseus`.`cscart_seo_names`.`lang_code` = 'en') and ((`gaseus`.`cscart_seo_names`.`company_id` = 1) or (`gaseus`.`cscart_seo_names`.`company_id` = 0)))",
      "cost_info": {
        "read_cost": "115.21",
        "eval_cost": "19.20",
        "prefix_cost": "134.41",
        "data_read_per_join": "325K"
      },
      "used_columns": [
        "name",
        "object_id",
        "company_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}