SELECT 
  products.* 
FROM 
  products 
WHERE 
  products.product_id IN (
    241402, 242084, 238468, 238494, 238463, 
    238437, 238479, 238471, 238457, 238445, 
    238472, 238453, 238444, 238475, 238446, 
    238461, 238465, 238470, 238487, 238492, 
    238440, 238481, 238486, 238467, 238484, 
    238460, 238462, 238477, 238490, 238489, 
    238447, 238485, 238443, 238495, 238448, 
    238442, 238438, 238493, 238454, 238488, 
    238449, 238441, 238480, 238458, 238482, 
    238483, 238439, 238464
  )

Query time 0.00130

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "25.10"
    },
    "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": "20.30",
        "eval_cost": "4.80",
        "prefix_cost": "25.10",
        "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 (241402,242084,238468,238494,238463,238437,238479,238471,238457,238445,238472,238453,238444,238475,238446,238461,238465,238470,238487,238492,238440,238481,238486,238467,238484,238460,238462,238477,238490,238489,238447,238485,238443,238495,238448,238442,238438,238493,238454,238488,238449,238441,238480,238458,238482,238483,238439,238464))"
    }
  }
}

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
238437 GI-238437-JNY P A 7131 0.00 10 0.281 0 0 0 1.00 0 1657808067 1659144371 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 4.500 2147483647
238438 GI-238438-CRG P A 7131 0.00 10 0.281 0 0 0 1.00 0 1657808067 1659144373 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 4.500 2147483647
238439 GI-238439-IYM P A 7131 0.00 5 0.063 0 0 0 1.00 0 1657808067 1659144377 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
238440 GI-238440-COL P A 7131 0.00 5 0.063 0 0 0 1.00 0 1657808067 1659144381 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
238441 GI-238441-WOP P A 7131 0.00 5 0.063 0 0 0 1.00 0 1657808067 1659144383 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
238442 GI-238442-RPI P A 7131 0.00 5 0.063 0 0 0 1.00 0 1657808067 1659144388 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
238443 GI-238443-YPX P A 7131 0.00 5 0.063 0 0 0 1.00 0 1657808067 1659144390 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
238444 GI-238444-JUP P A 7131 0.00 5 0.063 0 0 0 1.00 0 1657808067 1659144398 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
238445 GI-238445-LSG P A 7131 0.00 5 0.563 0 0 0 1.00 0 1657808067 1659144400 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 9.000 2147483647
238446 GI-238446-ODB P A 7131 0.00 10 0.000 0 0 0 0.00 0 1657808067 1673469730 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
238447 GI-238447-XHU P A 7131 0.00 10 0.000 0 0 0 0.00 0 1657808067 1659144755 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
238448 GI-238448-FKI P A 7131 0.00 10 0.094 0 0 0 1.00 0 1657808067 1659145132 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.500 2147483647
238449 GI-238449-RQL P A 7131 0.00 5 0.000 0 0 0 0.00 0 1657808067 1659144406 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
238453 GI-238453-NJC P A 7131 0.00 4 0.000 0 0 0 0.00 0 1657808067 1659144420 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
238454 GI-238454-NLZ P A 7131 0.00 4 0.000 0 0 0 0.00 0 1657808067 1659144422 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
238457 GI-238457-UIT P A 7131 0.00 4 0.000 0 0 0 0.00 0 1657808067 1659144430 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
238458 GI-238458-NGR P A 7131 0.00 5 0.000 0 0 0 0.00 0 1657808067 1659144432 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
238460 GI-238460-QVA P A 7131 0.00 3 0.000 0 0 0 0.00 0 1657808067 1659144437 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
238461 GI-238461-SXO P A 7131 0.00 5 0.000 0 0 0 0.00 0 1657808067 1659144853 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
238462 GI-238462-LXW P A 7131 0.00 5 0.000 0 0 0 0.00 0 1657808067 1659144443 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
238463 GI-238463-ALB P A 7131 0.00 10 0.000 0 0 0 0.00 0 1657808067 1659144897 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
238464 GI-238464-LSY P A 7131 0.00 5 0.000 0 0 0 0.00 0 1657808067 1659144447 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
238465 GI-238465-JQL P A 7131 0.00 4 0.000 0 0 0 0.00 0 1657808067 1659144455 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
238467 GI-238467-JGZ P A 7131 0.00 4 0.000 0 0 0 0.00 0 1657808067 1659144458 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
238468 GI-238468-LCQ P A 7131 0.00 19 0.000 0 0 0 0.00 0 1657808067 1659144459 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
238470 GI-238470-IAM P A 7131 0.00 17 0.000 0 0 0 0.00 0 1657808067 1659144462 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
238471 GI-238471-SDZ P A 7131 0.00 23 0.000 0 0 0 0.00 0 1657808067 1659144467 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
238472 GI-238472-ZPZ P A 7131 0.00 5 0.000 0 0 0 0.00 0 1657808067 1659144473 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
238475 GI-238475-XOU P A 7131 0.00 10 0.000 0 0 0 0.00 0 1657808067 1659145041 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
238477 GI-238477-KUP P A 7131 0.00 6 0.000 0 0 0 0.00 0 1657808067 1659144514 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
238479 GI-238479-QUC P A 7131 0.00 6 0.000 0 0 0 0.00 0 1657808067 1659144520 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
238480 GI-238480-MST P A 7131 0.00 6 0.000 0 0 0 0.00 0 1657808067 1659144522 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
238481 GI-238481-VHZ P A 7131 0.00 6 0.000 0 0 0 0.00 0 1657808067 1659144525 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
238482 GI-238482-TLV P A 7131 0.00 6 0.000 0 0 0 0.00 0 1657808067 1659144528 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
238483 GI-238483-CZS P A 7131 0.00 8 0.000 0 0 0 0.00 0 1657808067 1659144530 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
238484 GI-238484-COX P A 7131 0.00 10 0.000 0 0 0 0.00 0 1657808067 1659144535 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
238485 GI-238485-KHF P A 7131 0.00 10 0.000 0 0 0 0.00 0 1657808067 1659144538 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
238486 GI-238486-LHX P A 7131 0.00 5 0.000 0 0 0 0.00 0 1657808067 1659144545 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
238487 GI-238487-VCS P A 7131 0.00 19 0.063 0 0 0 1.00 0 1657808067 1659144548 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
238488 GI-238488-RZP P A 7131 0.00 12 0.094 0 0 0 1.00 0 1657808067 1659144550 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.500 2147483647
238489 GI-238489-LCR P A 7131 0.00 4 0.563 0 0 0 1.00 0 1657808067 1659144553 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 9.000 2147483647
238490 GI-238490-QKB P A 7131 0.00 9 0.000 0 0 0 0.00 0 1657808067 1659144555 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
238492 GI-238492-CIE P A 7131 0.00 19 0.063 0 0 0 1.00 0 1657808067 1659144560 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
238493 GI-238493-HRG P A 7131 0.00 6 0.094 0 0 0 1.00 0 1657808067 1659144562 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.500 2147483647
238494 GI-238494-EXN P A 7131 0.00 15 0.094 0 0 0 1.00 0 1657808067 1659144564 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.500 2147483647
238495 GI-238495-NIX P A 7131 0.00 3 0.000 0 0 0 0.00 0 1657808067 1668535662 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
241402 GI-241402-CXD P A 7131 0.00 10 0.000 0 0 0 0.00 0 1659128810 1659144368 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
242084 GI-242084-ZGY P A 7131 0.00 1 0.000 0 0 0 0.00 0 1659486332 1659486357 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