SELECT 
  products.* 
FROM 
  products 
WHERE 
  products.product_id IN (
    231093, 226634, 257544, 231088, 231090, 
    257552, 231092, 257551, 257744, 257548, 
    257545, 257543, 257546, 257547, 231094, 
    257743, 258068, 257745, 258070
  )

Query time 0.00081

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.18"
    },
    "table": {
      "table_name": "products",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 19,
      "rows_produced_per_join": 19,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "8.28",
        "eval_cost": "1.90",
        "prefix_cost": "10.18",
        "data_read_per_join": "80K"
      },
      "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 (231093,226634,257544,231088,231090,257552,231092,257551,257744,257548,257545,257543,257546,257547,231094,257743,258068,257745,258070))"
    }
  }
}

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
226634 27 P A 6825 40.00 1 0.313 0 0 0 1.00 0 1654304196 1666566547 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:1;s:10:"box_length";i:4;s:9:"box_width";i:6;s:10:"box_height";i:0;} 0.000 5.000 2147483647
231088 jLP1 P A 6825 30.00 1 0.313 0 0 0 1.50 0 1655936993 1666565733 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
231090 jLP2 P A 6825 30.00 1 0.313 0 0 0 1.50 0 1655937775 1666565504 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
231092 jLP3 P A 6825 30.00 1 0.313 0 0 0 1.50 0 1655938434 1666566130 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
231093 jLP4 P A 6825 30.00 1 0.313 0 0 0 1.50 0 1655938552 1666564647 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
231094 45 P A 6825 15.00 1 0.188 0 0 0 1.00 0 1655940124 1666551483 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 3.000 2147483647
257543 lr1 P A 6825 20.00 1 0.313 0 0 0 1.50 0 1666556076 1666556173 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
257544 lr2 P A 6825 20.00 1 0.313 0 0 0 1.50 0 1666556340 1666556772 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
257545 lr3 P A 6825 20.00 1 0.313 0 0 0 1.50 0 1666556880 1666556995 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
257546 lr4 P A 6825 20.00 1 0.313 0 0 0 1.50 0 1666557178 1666557273 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
257547 lr5 P A 6825 20.00 1 0.313 0 0 0 1.50 0 1666557423 1666557547 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
257548 lr6 P A 6825 20.00 1 0.313 0 0 0 1.50 0 1666557710 1666557829 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
257551 lr7 P A 6825 20.00 1 0.313 0 0 0 1.50 0 1666558376 1666558511 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
257552 lr8 P A 6825 20.00 1 0.313 0 0 0 1.50 0 1666558594 1666558793 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
257743 bp1 P A 6825 25.00 1 0.313 0 0 0 1.50 0 1666731446 1666732346 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
257744 fp1 P A 6825 25.00 1 0.313 0 0 0 1.50 0 1666731784 1666732346 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
257745 fp2 P A 6825 25.00 1 0.313 0 0 0 1.50 0 1666732479 1666732632 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
258068 fp5 P A 6825 25.00 1 0.313 0 0 0 1.50 0 1666823825 1666824228 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
258070 fp3 P A 6825 25.00 1 0.313 0 0 0 1.50 0 1666824410 1666824776 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