SELECT 
  seo_names.object_id AS product_id, 
  seo_names.name AS seo_name, 
  seo_names.path AS seo_path 
FROM 
  seo_names 
WHERE 
  seo_names.object_id IN (
    253997, 263740, 261960, 263454, 255355, 
    257117, 253991, 263431, 254003, 253996, 
    268001, 253999, 268000, 255360, 263451, 
    263452, 262071, 257118, 262069, 262067, 
    263455, 260871, 263450, 263737
  ) 
  AND seo_names.type = "p" 
  AND seo_names.dispatch = "" 
  AND seo_names.lang_code = 'en'

Query time 0.00156

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "25.75"
    },
    "table": {
      "table_name": "seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code"
      ],
      "key_length": "206",
      "rows_examined_per_scan": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "23.35",
        "eval_cost": "2.40",
        "prefix_cost": "25.75",
        "data_read_per_join": "40K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`goimagine`.`seo_names`.`object_id` in (253997,263740,261960,263454,255355,257117,253991,263431,254003,253996,268001,253999,268000,255360,263451,263452,262071,257118,262069,262067,263455,260871,263450,263737)) and (`goimagine`.`seo_names`.`type` = 'p') and (`goimagine`.`seo_names`.`dispatch` = '') and (`goimagine`.`seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
253991 3-pack-of-15-min-distance-reiki-clone-en 4/179/262
253996 12-pack-of-30-min-distance-reiki-clone 4/179/262
253997 12-pack-of-45-min-distance-reiki-clone 4/179/262
253999 3-pack-of-30-min-distance-reiki-clone-en 4/179/262
254003 2-pack-of-90-min-distance-reiki-clone 4/179/262
255355 tranquility-and-harmony-soap 12/54/295
255360 balance-umbrella-soap 12/54/295
257117 copper-pendant-necklace-clone 2/15
257118 copper-pendant-necklace-clone-en 2/15
260871 intuition-guardian-soap 12/54/295
261960 quartz-earrings 2
262067 large-crystal-quartz-and-amazonite-buddha-statement-necklace 2/15
262069 large-kyanite-statement-necklace 2/15
262071 crystal-quartz-and-citrine-necklace 2/15
263431 moisturizing-phoenix-rising-spa-bar 12/54/295
263450 raw-citrine-and-peruvian-clay-sun-earrings 2
263451 chevron-amethyst-rose-quartz-necklace 2/15
263452 crystal-quartz-and-aquamarine-necklace 2/15
263454 sleeping-beauty-turquoise-hair-pins 3/85/387
263455 aquamarine-bracelet 2
263737 carnelian-and-vintage-metal-hair-pins 3/85/387
263740 vintage-african-trade-bead-hair-pins 3/85/387
268000 healthy-relationships-bees-wax-candle 4/179/261
268001 self-empowerment-bees-wax-candle 4/179/261