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 (
    2022, 2023, 2024, 2025, 2026, 2027, 2028, 
    2029, 2030, 2031, 2032, 2033, 2034, 
    2035, 2036, 2037, 2038, 5668, 5669, 
    5670, 5671, 5672, 5673, 5674, 5675, 
    5676, 5677, 5678, 5679, 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
  ) 
  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.00134

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 (2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,5668,5669,5670,5671,5672,5673,5674,5675,5676,5677,5678,5679,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)) 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"
      ]
    }
  }
}