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 (
    446202, 436995, 424216, 416027, 414898, 
    412406, 425747, 406851, 403492, 409045, 
    455469, 459175
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00050

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.0237706,
    "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"],
          "loops": 1,
          "rows": 12,
          "cost": 0.0237706,
          "filtered": 100,
          "attached_condition": "cscart_seo_names.object_id in (446202,436995,424216,416027,414898,412406,425747,406851,403492,409045,455469,459175) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id seo_name seo_path
403492 eco-chair-751 287/304/305
406851 eco-chair-654 287/304/305
409045 eco-chair-798 287/304/305
412406 eco-camera-997 287/304/305
414898 eco-camera-984 287/304/305
416027 eco-camera-574 287/304/305
424216 eco-camera-571 287/304/305
425747 eco-chair-427 287/304/305
436995 eco-camera-548 287/304/305
446202 eco-camera-358 287/304/305
455469 eco-drone-153 287/304/305
459175 eco-drone-607 287/304/305