SELECT 
  q_seo_names.object_id AS product_id, 
  q_seo_names.name AS seo_name, 
  q_seo_names.path AS seo_path 
FROM 
  q_seo_names 
WHERE 
  q_seo_names.object_id IN (
    30896, 30897, 30898, 30899, 30900, 30901, 
    30902, 30903, 30904, 30905, 30906, 
    30907, 30908, 30909, 30910, 30911, 
    30912, 30913, 30914, 30915, 30916, 
    30917, 30918, 30919, 30920, 30921, 
    30922, 30923, 30924, 30925, 30926, 
    30927
  ) 
  AND q_seo_names.type = "p" 
  AND q_seo_names.dispatch = "" 
  AND q_seo_names.lang_code = 'en'

Query time 0.00182

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "82.41"
    },
    "table": {
      "table_name": "q_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": 36,
      "rows_produced_per_join": 36,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_seo_names`.`object_id` in (30896,30897,30898,30899,30900,30901,30902,30903,30904,30905,30906,30907,30908,30909,30910,30911,30912,30913,30914,30915,30916,30917,30918,30919,30920,30921,30922,30923,30924,30925,30926,30927)) and (`portal`.`q_seo_names`.`type` = 'p') and (`portal`.`q_seo_names`.`dispatch` = '') and (`portal`.`q_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "75.21",
        "eval_cost": "7.20",
        "prefix_cost": "82.41",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
30896 wooden-cup-wood-coffee-tea-beer-juice-milk-water-mug-primitive-handmade-natural 6/438/454
30897 100pcs-clear-disposable-plastic-shower-bath-caps-for-spa-hair-salon-wh 6/7/147/584
30898 waterproof-canvas-laundry-clothes-basket-storage-basket-folding-storage-box-b 6/184/189
30899 faucet-extender-sink-handle-extension-toddler-kid-bathroom-children-hand-wash 6/168/183
30900 5-inch-deluxe-large-blue-and-white-floating-swimming-pool-chlorine-dispenser 6/184/378
30901 2-pcs-large-bright-colour-plastic-beach-towel-pegs-clips-to-sunbed-quilt-clips 6/445
30902 activated-carbon-front-loading-water-clean-filter-tap-purifier-head-kitchen 6/184/378
30903 rose-gold-pink-cushion-cover-square-pillowcase-home-decoration-30cm-x-50cm 6/7/61/64
30904 nest-dox-nest-house-bird-house-bird-house-bird-box-bird-box-wooden-box-en 6/367/371
30905 steel-watch-bracelet-spring-bar-standard-plier-6825-remover-adjuster-tool 12/95/597
30906 2pc-insulated-foam-lined-heavy-thick-blackout-grommet-window-curtain-panels 6/184
30907 neoprene-lunch-tote-bag-insulated-waterproof-lunch-box-for-women-adults-kids-bk 6/438/476/478
30908 pedicure-tools-2pcs-natural-pumice-stone-hard-skin-callus-remover-for-feet 2/10/136
30909 mini-butterfly-beetle-folding-hanger-holder-table-hook-for-purse-handbag-utility 12/13/44
30910 3pcs-set-no.7404-series-watch-hand-setter-presser-setting-fitting-tool-0.9-1.4mm 6/184
30911 household-waterproof-microwave-oven-dust-cover-with-storage-bag-for-kitchen-b 6/168/183
30912 marble-effect-counter-top-contact-paper-vinyl-self-adhesive-decor-wallpaper-new 6/159/160
30913 flag-patch-tactical-military-morale-patch-flag-magic-stickers-badge-decoration 248/249/255
30914 new-cute-mini-contact-lens-easy-carry-case-travel-kit-hot 12/555/564
30915 baby-stroller-mosquito-net-full-insect-cover-carriage-kid-foldable-kids-netting 248/361/364
30916 double-layer-storage-tray-jewelry-storage-organizer-dessert-tray-cosmetic-tray 6/184/189
30917 seagrass-wicker-basket-wicker-basket-flower-pot-folding-basket-dirty-basket-stor 6/184/187
30918 classic-solar-led-candle-light-outdoor-hanging-smokeless-lantern-lamp-warm-white 207/469/470/473
30919 mi-ciga-design-mechanical-watch-my-series-black 12/95
30920 2pc-kitchen-refrigerator-space-saver-organizer-slide-shelf-rack-rack-storage 6/168/183
30921 3d-diy-roman-numbers-acrylic-mirror-wall-sticker-clock-home-decor-mural-decals 6/159/160
30922 xiaomi-mijia-anti-blue-light-goggles-pro-blue-ink-color 12/604/91
30923 led-lights-meteor-shower-rain-snowfall-xmas-tree-garden-outdoor-blue 6/596
30924 drill-brush-scrub-pads-8-piece-power-scrubber-cleaning-kit-all-purpose-cleaner-scrubbing-cordless-drill-for-cleaning-pool 6/445/446
30925 car-motor-gps-tracker-kids-pets-wallet-keys-alarm-locator-realtime-finder-device 2/432
30926 pattern-hanging-wall-tapestry-bohemian-hippie-bedspread-home-decor 6
30927 for-women-kids-men-insulated-canvas-box-tote-bag-thermal-cooler-food-lunch-bags 6/438/476/478