SELECT 
  products.* 
FROM 
  products 
WHERE 
  products.product_id IN (
    273653, 274149, 273584, 274159, 273774, 
    273917, 274014, 274052, 277121, 276772, 
    273782, 274054, 274290, 273809, 273807, 
    285487, 276798, 287053, 285573, 291359, 
    393245, 340444, 333844, 345724
  )

Query time 0.00104

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.84"
    },
    "table": {
      "table_name": "products",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "8.44",
        "eval_cost": "2.40",
        "prefix_cost": "10.84",
        "data_read_per_join": "101K"
      },
      "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 (273653,274149,273584,274159,273774,273917,274014,274052,277121,276772,273782,274054,274290,273809,273807,285487,276798,287053,285573,291359,393245,340444,333844,345724))"
    }
  }
}

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
273584 GI-273584-GIK P A 8692 420.00 1 1.500 0 0 0 1.00 0 1673383008 1676681723 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:21;s:9:"box_width";i:7;s:10:"box_height";i:5;} 1.000 8.000 2147483647
273653 GI-273653-PGL P A 8692 498.00 1 2.625 0 0 0 1.00 0 1673386259 1676681383 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:17;s:9:"box_width";i:8;s:10:"box_height";i:5;} 2.000 10.000 2147483647
273774 GI-273774-ZLZ P A 8692 1400.00 1 4.188 0 0 0 1.00 0 1673457916 1676681575 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:36;s:9:"box_width";i:6;s:10:"box_height";i:4;} 4.000 3.000 2147483647
273782 GI-273782-UPV P A 8692 530.00 1 2.250 0 0 0 1.00 0 1673461356 1676681864 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:23;s:9:"box_width";i:4;s:10:"box_height";i:3;} 2.000 4.000 2147483647
273807 GI-273807-RRM P A 8692 560.00 1 2.188 0 0 0 1.00 0 1673466822 1673466957 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:22;s:9:"box_width";i:4;s:10:"box_height";i:3;} 2.000 3.000 2147483647
273809 GI-273809-YKB P A 8692 510.00 1 3.000 0 0 0 1.00 0 1673467856 1673468211 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:22;s:9:"box_width";i:4;s:10:"box_height";i:3;} 3.000 0.000 2147483647
273917 GI-273917-WFV P A 8692 9.00 30 0.125 0 0 0 0.00 0 1673542588 1674598589 0 N N N B Y 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
274014 GI-274014-XHY P A 8692 77.00 2 0.688 0 0 0 0.00 0 1673564582 1673564891 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:12;s:9:"box_width";i:8;s:10:"box_height";i:2;} 0.000 11.000 2147483647
274052 GI-274052-CBI P A 8692 32.00 2 0.438 0 0 0 0.00 0 1673625543 1673625933 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:8;s:9:"box_width";i:4;s:10:"box_height";i:2;} 0.000 7.000 2147483647
274054 GI-274054-DNP P A 8692 31.00 6 0.375 0 0 0 0.00 0 1673626788 1673627913 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:6;s:9:"box_width";i:3;s:10:"box_height";i:1;} 0.000 6.000 2147483647
274149 GI-274149-ZWE P A 8692 225.00 1 0.688 0 0 0 1.00 0 1673639892 1673640011 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:15;s:9:"box_width";i:3;s:10:"box_height";i:2;} 0.000 11.000 2147483647
274159 GI-274159-APF P A 8692 389.00 1 2.500 0 0 0 1.00 0 1673641700 1676654589 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:20;s:9:"box_width";i:4;s:10:"box_height";i:2;} 2.000 8.000 2147483647
274290 GI-274290-JDX P A 8692 285.00 1 2.625 0 0 0 1.00 0 1673734093 1673734235 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:10;s:9:"box_width";i:6;s:10:"box_height";i:6;} 2.000 10.000 2147483647
276772 GI-276772-WDG P A 8692 12.00 5 0.313 0 0 0 0.25 0 1674412939 1674415836 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:4;s:9:"box_width";i:3;s:10:"box_height";i:2;} 0.000 5.000 2147483647
276798 GI-276798-ALS P A 8692 475.00 1 2.438 0 0 0 1.00 0 1674416965 1674417062 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:20;s:9:"box_width";i:4;s:10:"box_height";i:3;} 2.000 7.000 2147483647
277121 GI-277121-FKK P A 8692 9.00 20 0.000 0 0 0 0.00 0 1674599362 1674601074 0 N N N B Y 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
285487 GI-285487-QDA P A 8692 1225.00 1 6.800 0 0 0 2.00 0 1677020021 1677020432 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:30;s:9:"box_width";i:7;s:10:"box_height";i:4;} 6.800 0.000 2147483647
285573 GI-285573-AOJ P A 8692 589.00 1 3.000 0 0 0 1.00 0 1677089930 1677090163 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:24;s:9:"box_width";i:5;s:10:"box_height";i:3;} 3.000 0.000 2147483647
287053 GI-287053-RLA P A 8692 139.00 1 0.750 0 0 0 1.00 0 1677442032 1677442209 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:3;s:10:"box_height";i:2;} 0.000 12.000 2147483647
291359 GI-291359-CLZ P A 8692 76.00 1 1.000 0 0 0 1.00 0 1678712013 1678712328 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:14;s:9:"box_width";i:5;s:10:"box_height";i:3;} 1.000 0.000 2147483647
333844 GI-333844-RJW P A 8692 77.00 2 0.688 0 0 0 0.00 0 1705937530 1705937530 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:12;s:9:"box_width";i:8;s:10:"box_height";i:2;} 0.000 11.000 2147483647
340444 GI-340444-QYE P A 8692 77.00 2 0.688 0 0 0 0.00 0 1705941073 1705941073 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:12;s:9:"box_width";i:8;s:10:"box_height";i:2;} 0.000 11.000 2147483647
345724 GI-345724-FZN P A 8692 77.00 2 0.688 0 0 0 0.00 0 1705944037 1705944037 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:12;s:9:"box_width";i:8;s:10:"box_height";i:2;} 0.000 11.000 2147483647
393245 GI-393245-OKR P A 8692 77.00 2 0.688 0 0 0 0.00 0 1705976993 1705976993 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:12;s:9:"box_width";i:8;s:10:"box_height";i:2;} 0.000 11.000 2147483647