SELECT 
  products.* 
FROM 
  products 
WHERE 
  products.product_id IN (
    186231, 109593, 103373, 193286, 90945, 
    168820, 96320, 90935, 120747, 98810, 
    98813, 98373, 91613, 98734, 104426, 
    91612, 167731, 109606, 98342, 155430, 
    239125, 133812, 196685, 168828, 138080, 
    133813, 133814, 138365, 125527, 221443, 
    138079, 111401
  )

Query time 0.00377

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "14.44"
    },
    "table": {
      "table_name": "products",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "11.25",
        "eval_cost": "3.20",
        "prefix_cost": "14.45",
        "data_read_per_join": "135K"
      },
      "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 (186231,109593,103373,193286,90945,168820,96320,90935,120747,98810,98813,98373,91613,98734,104426,91612,167731,109606,98342,155430,239125,133812,196685,168828,138080,133813,133814,138365,125527,221443,138079,111401))"
    }
  }
}

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
109606 109606 P A 2457 0.00 1 0.094 0 0 0 0.00 0 1627615327 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
111401 111401 P A 2457 0.00 48 0.006 0 0 0 0.00 0 1627915551 1628521497 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.100 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
125527 GI-125527-FSL P A 2457 7.00 5 0.031 0 0 0 0.00 0 1629416717 1642631215 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
133812 GI-133812-NUK P A 2457 0.00 1 0.063 0 0 0 0.00 0 1631663266 1632668785 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 1.000 2147483647
133813 GI-133813-ARW P A 2457 0.00 1 0.063 0 0 0 0.00 0 1631663292 1632668773 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 1.000 2147483647
133814 GI-133814-DUI P A 2457 5.00 1 0.063 0 0 0 0.00 0 1631663564 1632668761 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 1.000 2147483647
138079 GI-138079-NXD P A 2457 0.00 1 0.063 0 0 0 0.00 0 1632747730 1658238602 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 1.000 2147483647
138080 GI-138080-PBD P A 2457 0.00 1 0.063 0 0 0 0.00 0 1632748225 1633303173 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 1.000 2147483647
138365 GI-138365-BHP P A 2457 0.00 1 0.063 0 0 0 0.00 0 1632780096 1633303263 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 1.000 2147483647
155430 GI-155430-UZZ P A 2457 0.00 1 0.125 0 0 0 1.00 0 1638116551 1642630735 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
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
168828 GI-168828-CCF P A 2457 0.00 1 0.000 0 0 0 0.00 0 1642631056 1642699706 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
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
193286 GI-193286-IHV P A 2457 0.00 1 0.125 0 0 0 1.00 0 1647294003 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 2.000 2147483647
196685 GI-196685-CDQ P A 2457 0.00 1 0.006 0 0 0 0.00 0 1647748654 1647889258 0 N N N D 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.100 2147483647
221443 GI-221443-NGI P A 2457 0.00 1 0.000 0 0 0 0.00 0 1652892199 1652892624 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 0.000 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