SELECT 
  products.* 
FROM 
  products 
WHERE 
  products.product_id IN (
    239125, 186231, 168820, 167731, 120747, 
    104426, 103373, 109593, 98810, 98813, 
    98734, 98373, 98342, 90935, 90945, 
    91612, 91613, 96320
  )

Query time 0.00100

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "8.13"
    },
    "table": {
      "table_name": "products",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 18,
      "rows_produced_per_join": 18,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "6.33",
        "eval_cost": "1.80",
        "prefix_cost": "8.13",
        "data_read_per_join": "76K"
      },
      "used_columns": [
        "product_id",
        "product_code",
        "product_type",
        "status",
        "company_id",
        "list_price",
        "amount",
        "weight",
        "length",
        "width",
        "height",
        "shipping_freight",
        "low_avail_limit",
        "timestamp",
        "updated_timestamp",
        "usergroup_ids",
        "is_edp",
        "edp_shipping",
        "unlimited_download",
        "tracking",
        "free_shipping",
        "zero_price_action",
        "is_pbp",
        "is_op",
        "is_oper",
        "is_returnable",
        "return_period",
        "avail_since",
        "out_of_stock_actions",
        "localization",
        "min_qty",
        "max_qty",
        "qty_step",
        "list_qty_count",
        "tax_ids",
        "age_verification",
        "age_limit",
        "options_type",
        "exceptions_type",
        "details_layout",
        "shipping_params",
        "weight_lbs",
        "weight_oz",
        "product_tax_code",
        "deleted_at",
        "archived_at",
        "position"
      ],
      "attached_condition": "(`goimagine`.`products`.`product_id` in (239125,186231,168820,167731,120747,104426,103373,109593,98810,98813,98734,98373,98342,90935,90945,91612,91613,96320))"
    }
  }
}

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp updated_timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params weight_lbs weight_oz product_tax_code deleted_at archived_at position
90935 90935 P A 2457 0.00 10 0.188 0 0 0 0.00 0 1624542008 1628248530 0 N N N B N R N N N Y 10 0 B 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 3.000 2147483647
90945 90945 P A 2457 0.00 10 0.125 0 0 0 0.00 0 1624548117 1625872059 0 N N N B N R N N N Y 10 0 B 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 2.000 2147483647
91612 91612 P A 2457 0.00 1 0.125 0 0 0 0.00 0 1624731751 1625669231 0 N N N D N R N N N Y 10 0 B 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 2.000 2147483647
91613 91613 P A 2457 0.00 1 0.250 0 0 0 0.00 0 1624732524 1625669250 0 N N N D N R N N N Y 10 0 B 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 4.000 2147483647
96320 96320 P A 2457 0.00 10 0.188 0 0 0 0.00 0 1625406101 1628248530 0 N N N B N R N N N Y 10 0 B 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 3.000 2147483647
98342 98342 P A 2457 0.00 20 0.019 0 0 0 0.00 0 1625769016 1625769064 0 N N N B N R N N N Y 10 0 B 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 0.300 2147483647
98373 98373 P A 2457 0.00 1 0.313 0 0 0 0.00 0 1625773293 1625773340 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 5.000 2147483647
98734 98734 P A 2457 0.00 1 0.125 0 0 0 0.00 0 1625842471 1625842777 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 2.000 2147483647
98810 98810 P A 2457 0.00 5 0.063 0 0 0 0.00 0 1625875220 1625875290 0 N N N B N R N N N Y 10 0 B 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 1.000 2147483647
98813 98813 P A 2457 0.00 3 0.188 0 0 0 0.00 0 1625877612 1637507537 0 N N N B N R N N N Y 10 0 S 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 3.000 2147483647
103373 103373 P A 2457 0.00 1 0.094 0 0 0 0.00 0 1626387894 1628248565 0 N N N B N R N N N Y 10 0 B 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 1.500 2147483647
104426 104426 P A 2457 0.00 3 0.031 0 0 0 0.00 0 1626640043 1628248565 0 N N N B N R N N N Y 10 0 S 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 0.500 2147483647
109593 109593 P A 2457 0.00 1 0.031 0 0 0 0.00 0 1627610043 1628248565 0 N N N D N R N N N Y 10 0 B 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 0.500 2147483647
120747 GI-120747-HHI P A 2457 0.00 1 0.000 0 0 0 0.00 0 1629112301 1629415704 0 N N N D N R N N N Y 10 0 B 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 0.000 2147483647
167731 GI-167731-ICM P A 2457 0.00 1 0.063 0 0 0 2.00 0 1642255764 1642265632 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:10;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 1.000 2147483647
168820 GI-168820-GMR P A 2457 0.00 1 0.125 0 0 0 1.00 0 1642630173 1647917129 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 2.000 2147483647
186231 GI-186231-GJD P A 2457 0.00 1 0.094 0 0 0 1.00 0 1646149165 1659889588 0 N N N D N R N N N Y 10 0 N 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 1.500 2147483647
239125 GI-239125-DNZ P A 2457 0.00 1 0.000 0 0 0 0.00 0 1658237770 1658237770 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 0.000 2147483647