SELECT 
  products.* 
FROM 
  products 
WHERE 
  products.product_id IN (
    36672, 36758, 57792, 36754, 36692, 150992, 
    54764, 36683, 49009, 36870, 36707, 
    61058, 36687, 36716, 61982, 36827, 
    36704, 36677, 77482, 36755, 36664, 
    36688, 36798, 36690, 36680, 47619, 
    36665, 36732, 36773, 36669, 36739, 
    36822, 36765, 76558, 36679, 36691, 
    54762, 36678, 36844, 36702, 36756, 
    36768, 36714, 61979, 36772, 36823, 
    36731, 36807
  )

Query time 0.00149

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.66"
    },
    "table": {
      "table_name": "products",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.86",
        "eval_cost": "4.80",
        "prefix_cost": "21.66",
        "data_read_per_join": "202K"
      },
      "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 (36672,36758,57792,36754,36692,150992,54764,36683,49009,36870,36707,61058,36687,36716,61982,36827,36704,36677,77482,36755,36664,36688,36798,36690,36680,47619,36665,36732,36773,36669,36739,36822,36765,76558,36679,36691,54762,36678,36844,36702,36756,36768,36714,61979,36772,36823,36731,36807))"
    }
  }
}

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
36664 22 P A 1011 15.95 49 0.000 0 0 0 0.00 0 1596843010 1657466334 0 N N N B N R N N N Y 10 0 S 0 0 0 0 N 0 S 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:4;s:10:"box_height";i:4;} 0.000 0.000 2147483647
36665 23 P A 1011 0.00 1 0.000 0 0 0 0.00 0 1596843010 1612372042 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
36669 27 P A 1011 0.00 1 1.000 0 0 0 0.00 0 1596843010 1612372481 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:7;s:9:"box_width";i:5;s:10:"box_height";i:2;} 0.000 0.000 2147483647
36672 30 P A 1011 0.00 10 1.000 0 0 0 0.00 0 1596843010 1624047054 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36677 35 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1624047409 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36678 36 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1624047451 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36679 37 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1624047791 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36680 38 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1624047829 0 N N N B Y R N N N Y 10 0 S 0 0 0 0 N 0 S 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:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36683 41 P A 1011 0.00 1 4.000 0 0 0 0.00 0 1596843010 1624047525 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:4;s:16:"max_items_in_box";i:0;s:10:"box_length";i:6;s:9:"box_width";i:6;s:10:"box_height";i:6;} 0.000 0.000 2147483647
36687 45 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1624047621 0 N N N B Y R N N N Y 10 0 S 0 0 0 0 N 0 S 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:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36688 46 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1624047895 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36690 48 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1624046826 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36691 49 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1624048030 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36692 50 P A 1011 0.00 25 1.000 0 0 0 0.00 0 1596843010 1624047647 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36702 60 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1624048206 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36704 62 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1632097062 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:6;s:9:"box_width";i:6;s:10:"box_height";i:6;} 0.000 0.000 2147483647
36707 65 P A 1011 0.00 1 4.000 0 0 0 0.00 0 1596843010 1599018166 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:12;s:9:"box_width";i:12;s:10:"box_height";i:6;} 0.000 0.000 2147483647
36714 72 P A 1011 0.00 8 1.000 0 0 0 0.00 0 1596843010 1632097064 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:7;s:9:"box_width";i:5;s:10:"box_height";i:2;} 0.000 0.000 2147483647
36716 74 P A 1011 0.00 79 1.000 0 0 0 0.00 0 1596843010 1657466231 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:7;s:9:"box_width";i:5;s:10:"box_height";i:2;} 0.000 0.000 2147483647
36731 89 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1657466447 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:6;s:9:"box_width";i:6;s:10:"box_height";i:6;} 0.000 0.000 2147483647
36732 90 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1632097062 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:6;s:9:"box_width";i:6;s:10:"box_height";i:6;} 0.000 0.000 2147483647
36739 97 P A 1011 0.00 1 1.000 0 0 0 0.00 0 1596843010 1626015064 0 N N N B N R N N N Y 10 0 N 0 0 0 0 N 0 S F a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:7;s:9:"box_width";i:5;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36754 112 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1624048681 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:2;} 0.000 0.000 2147483647
36755 113 P A 1011 0.00 5 1.000 0 0 0 0.00 0 1596843010 1624046808 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:2;} 0.000 0.000 2147483647
36756 114 P A 1011 0.00 1 1.000 0 0 0 0.00 0 1596843010 1624048698 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:7;s:9:"box_width";i:5;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36758 116 P A 1011 0.00 1 1.000 0 0 0 0.00 0 1596843010 1599018169 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:6;s:10:"box_height";i:2;} 0.000 0.000 2147483647
36765 123 P A 1011 0.00 1 4.000 0 0 0 0.00 0 1596843010 1626015230 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:16;s:10:"box_height";i:12;} 0.000 0.000 2147483647
36768 126 P A 1011 0.00 25 1.000 0 0 0 0.00 0 1596843010 1626015296 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36772 130 P A 1011 0.00 2 1.000 0 0 0 0.00 0 1596843010 1605312399 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36773 131 P A 1011 0.00 1 2.000 0 0 0 0.00 0 1596843010 1612373483 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:12;s:10:"box_height";i:9;} 0.000 0.000 2147483647
36798 156 P A 1011 0.00 1 2.000 0 0 0 0.00 0 1596843010 1611021589 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:10;s:10:"box_height";i:10;} 0.000 0.000 2147483647
36807 165 P A 1011 0.00 140 1.000 0 0 0 0.00 0 1596843010 1657467051 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:5;s:9:"box_width";i:3;s:10:"box_height";i:1;} 0.000 0.000 2147483647
36822 180 P A 1011 24.95 4 5.000 0 0 0 0.00 0 1596843010 1657466288 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:2;s:16:"max_items_in_box";i:0;s:10:"box_length";i:6;s:9:"box_width";i:6;s:10:"box_height";i:6;} 5.000 0.000 2147483647
36823 181 P A 1011 0.00 1 1.000 0 0 0 0.00 0 1596843010 1605920956 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:4;s:10:"box_height";i:4;} 0.000 0.000 2147483647
36827 185 P A 1011 14.95 3 3.000 0 0 0 0.00 0 1596843010 1657466196 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:6;s:9:"box_width";i:6;s:10:"box_height";i:6;} 3.000 0.000 2147483647
36844 202 P A 1011 14.95 1 3.000 0 0 0 0.00 0 1596843010 1657466312 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:6;s:10:"box_height";i:6;} 3.000 0.000 2147483647
36870 228 P A 1011 24.95 5 1.000 0 0 0 0.00 0 1596843010 1621598746 0 N N N B Y R N N N Y 10 0 S 0 0 0 0 N 0 S 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:8;s:10:"box_height";i:1;} 1.000 0.000 2147483647
47619 P A 1011 0.00 1 2.000 0 0 0 0.00 0 1601952443 1624048891 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:9;s:10:"box_height";i:2;} 0.000 0.000 2147483647
49009 P A 1011 0.00 1 1.000 0 0 0 0.00 0 1603247441 1669557593 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:16;s:9:"box_width";i:12;s:10:"box_height";i:6;} 0.000 0.000 2147483647
54762 P A 1011 0.00 1 1.000 0 0 0 0.00 0 1606519902 1626015523 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:6;s:9:"box_width";i:6;s:10:"box_height";i:6;} 0.000 0.000 2147483647
54764 P A 1011 0.00 3 1.000 0 0 0 0.00 0 1606520301 1626015544 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:6;s:9:"box_width";i:6;s:10:"box_height";i:6;} 0.000 0.000 2147483647
57792 P A 1011 29.95 2 2.000 0 0 0 0.00 0 1610339863 1612370324 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:9;s:10:"box_height";i:2;} 0.000 0.000 2147483647
61058 210 P A 1011 6.95 67 1.000 0 0 0 0.00 0 1612051157 1657466266 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:5;s:9:"box_width";i:3;s:10:"box_height";i:1;} 0.000 0.000 2147483647
61979 P A 1011 24.95 1 1.000 0 0 0 0.00 0 1612917765 1612917960 0 N N N B Y 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:11;s:9:"box_width";i:8;s:10:"box_height";i:2;} 0.000 0.000 2147483647
61982 P A 1011 15.95 1 2.000 0 0 0 0.00 0 1612918779 1632096874 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:4;s:9:"box_width";i:4;s:10:"box_height";i:4;} 0.000 0.000 2147483647
76558 P A 1011 14.95 3 1.000 0 0 0 0.00 0 1617546326 1657466517 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:6;s:9:"box_width";i:6;s:10:"box_height";i:6;} 1.000 0.000 2147483647
77482 P A 1011 49.95 3 2.000 0 0 0 0.00 0 1618080872 1618082668 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:1;s:16:"max_items_in_box";i:0;s:10:"box_length";i:21;s:9:"box_width";i:9;s:10:"box_height";i:2;} 2.000 0.000 2147483647
150992 GI-150992-IUF P A 1011 34.95 1 2.000 0 0 0 0.00 0 1636355350 1636355717 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:14;s:10:"box_height";i:3;} 2.000 0.000 2147483647