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 (
    32305, 43852, 4861, 37303, 37288, 38102, 
    2476, 40507, 1851, 4859, 2148, 1840, 
    987, 37954, 41355, 4870, 37287, 36496, 
    41424, 1852, 31644, 1472, 40893, 27054, 
    41360, 44923, 32110, 46587, 932, 2251, 
    41357, 37545
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'vi'

Query time 0.00689

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": "206",
          "used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
          "rows": 36,
          "filtered": 100,
          "index_condition": "cscart_seo_names.object_id in (32305,43852,4861,37303,37288,38102,2476,40507,1851,4859,2148,1840,987,37954,41355,4870,37287,36496,41424,1852,31644,1472,40893,27054,41360,44923,32110,46587,932,2251,41357,37545) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'vi'"
        }
      }
    ]
  }
}