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 (
    1344, 1345, 1335, 990, 1346, 1036, 1294, 
    1362, 1361, 1363, 1364, 1360, 1359, 
    1365, 1358, 1357, 1366, 1356, 1355, 
    1354, 1353, 1367, 1352, 1351
  ) 
  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.00139

JSON explain

{
  "query_block": {
    "select_id": 1,
    "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": 48,
      "filtered": 100,
      "index_condition": "cscart_seo_names.object_id in (1344,1345,1335,990,1346,1036,1294,1362,1361,1363,1364,1360,1359,1365,1358,1357,1366,1356,1355,1354,1353,1367,1352,1351) 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)"
    }
  }
}

Result

product_id seo_name seo_path
990 product-990 42
1036 product-1036 42
1294 ruou-whisky-suntory-old-700ml 42
1335 ruou-mo-choya-hop-giay-2000ml 42
1344 bia-asahi-super-dry-350ml-nhat-ban-lon-le 42
1345 ruou-black-nikka 42
1346 ruou-sake-trang 42
1351 t-0018-gio-qua-tet-sac-xuan-3 42
1352 t-0017-gio-qua-tet-sac-xuan-2 42
1353 t-0015-gio-qua-tet-phu-quy-3 42
1354 t-0014-gio-qua-tet-phu-quy-2 42
1355 t-0012-gio-qua-tet-nhu-y-3 42
1356 t-0011-gio-qua-tet-nhu-y-2 42
1357 t-0009-gio-qua-tet-sum-vay-3 42
1358 t-0008-gio-qua-tet-sum-vay-2 42
1359 t-0006-gio-qua-tet-van-phuc-3 42
1360 t-0005-gio-qua-tet-van-phuc-2 42
1361 t-0002-gio-qua-tet-mua-xuan-2 42
1362 t-0001-gio-qua-tet-mua-xuan-1 42
1363 t-0003-gio-qua-tet-mua-xuan-3 42
1364 t-0004-gio-qua-tet-van-phuc-1 42
1365 t-0007-gio-qua-tet-sum-vay-1 42
1366 t-0010-gio-qua-tet-nhu-y-1 42
1367 t-0016-gio-qua-tet-sac-xuan-1 42