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 (
    460958, 460957, 460955, 460952, 460951, 
    460948, 460947, 460946, 460918, 460921, 
    460936, 460804
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00047

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 (460958,460957,460955,460952,460951,460948,460947,460946,460918,460921,460936,460804) 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
460804 lite-headphones-265 219/495
460918 pro-router-777 219/495
460921 ultra-camera-719 287/288/289
460936 smart-book-218 203/500
460946 allen-solly-mens-cotton-regular-fit-polo-t-shirt-clone 287
460947 apple-ipad-with-retina-display-wi-fi-64gb-black-clone 167/165
460948 18-55mm-portrait-lens-clone 166/196/200
460951 biba-women-cotton-anarkali-kurta-palazzo-suit-set-clone 287
460952 mi-smart-watch-clone 223/227
460955 apple-iphone-15-128-gb-blue-clone 166
460957 resell-product 501
460958 resell-product-test 501