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 (
    21626, 18985, 18986, 19418, 18988, 21627, 
    18987, 18908, 18989, 18990, 18991, 
    18992, 21628, 18994, 21630, 21629, 
    21631, 21632, 18961, 21634, 18995, 
    19007, 9348, 9347, 18960, 18959, 20565, 
    18970, 18971, 18973, 21641, 18975, 
    18976, 18977, 21640, 22461, 21639, 
    18958, 18981, 18982, 21637, 18984, 
    22048, 22055, 22052, 22054, 22064, 
    22063, 22062, 22056, 22061, 22058, 
    22044, 22046, 22060, 18998, 18996, 
    18997, 18999, 19000, 19001, 19002, 
    19003, 19004, 19006, 19005, 22051, 
    22053, 22047, 22050, 22045, 22479, 
    22049, 22057, 22059, 21638, 21635, 
    18911, 18912, 19011, 18913, 19066, 
    21636, 19013, 18915, 19014, 20602, 
    18917, 18918, 21642, 19016, 18920, 
    19017, 20603, 20601, 18924, 18914, 
    18925, 18926
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'uk' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00237

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_seo_names",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "dispatch"],
          "key": "PRIMARY",
          "key_length": "210",
          "used_key_parts": [
            "object_id",
            "type",
            "dispatch",
            "lang_code",
            "company_id"
          ],
          "rows": 198,
          "filtered": 100,
          "index_condition": "cscart_seo_names.object_id in (21626,18985,18986,19418,18988,21627,18987,18908,18989,18990,18991,18992,21628,18994,21630,21629,21631,21632,18961,21634,18995,19007,9348,9347,18960,18959,20565,18970,18971,18973,21641,18975,18976,18977,21640,22461,21639,18958,18981,18982,21637,18984,22048,22055,22052,22054,22064,22063,22062,22056,22061,22058,22044,22046,22060,18998,18996,18997,18999,19000,19001,19002,19003,19004,19006,19005,22051,22053,22047,22050,22045,22479,22049,22057,22059,21638,21635,18911,18912,19011,18913,19066,21636,19013,18915,19014,20602,18917,18918,21642,19016,18920,19017,20603,20601,18924,18914,18925,18926) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'uk' and (cscart_seo_names.company_id = 1 or cscart_seo_names.company_id = 0)"
        }
      }
    ]
  }
}