SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    60403, 60362, 60371, 60401, 60357, 60402, 
    60358, 60375, 60376, 60377, 60373, 
    60383, 60359, 60392, 60393, 60381, 
    60385, 60394, 60386, 60391, 60408, 
    60407, 60384, 60397
  )

Query time 0.00096

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "16.81"
    },
    "table": {
      "table_name": "cscart_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",
      "index_condition": "(`cscartdb`.`cscart_products`.`product_id` in (60403,60362,60371,60401,60357,60402,60358,60375,60376,60377,60373,60383,60359,60392,60393,60381,60385,60394,60386,60391,60408,60407,60384,60397))",
      "cost_info": {
        "read_cost": "14.41",
        "eval_cost": "2.40",
        "prefix_cost": "16.81",
        "data_read_per_join": "128K"
      },
      "used_columns": [
        "product_id",
        "lead_time",
        "etsy_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",
        "facebook_obj_type",
        "parent_product_id",
        "allow_notes",
        "buy_now_url",
        "master_product_id",
        "master_product_status",
        "master_product_offers_count",
        "variation_sku",
        "has_color",
        "color_feature_id",
        "featured",
        "shopify_parent_product_id",
        "shopify_variant_product_id"
      ]
    }
  }
}

Result

product_id lead_time etsy_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 facebook_obj_type parent_product_id allow_notes buy_now_url master_product_id master_product_status master_product_offers_count variation_sku has_color color_feature_id featured shopify_parent_product_id shopify_variant_product_id
60357 {"from":"21","to":"21"} fc73f1f5-036a-4977-91a4-2e75db708d0c P A 99 234.00 999 0.000 0 0 0 0.00 0 1724455226 1724473860 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 Y 0 A 0 fc73f1f5-036a-4977-91a4-2e75db708d0c 1 1529 0
60358 {"from":"21","to":"21"} 2cf98372-1b4e-4434-a985-8ac06d217004 P A 99 234.00 999 0.000 0 0 0 0.00 0 1724463945 1724473996 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 Y 0 A 0 2cf98372-1b4e-4434-a985-8ac06d217004 1 1529 0
60359 {"from":"21","to":"21"} 814bcd02-221a-4d75-affb-c2f522a9476f P A 99 234.00 999 0.000 0 0 0 0.00 0 1724464424 1724474118 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 Y 0 A 0 814bcd02-221a-4d75-affb-c2f522a9476f 1 1529 0
60362 {"from":"21","to":"21"} 85acbb06-d431-414d-9e5a-a97cdf219057 P A 99 140.00 999 0.000 0 0 0 0.00 0 1724464608 1724474068 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 Y 0 A 0 85acbb06-d431-414d-9e5a-a97cdf219057 1 1529 0
60371 {"from":"21","to":"21"} 63dab98a-d32f-46c1-a762-03ca45cbda82 P A 99 140.00 999 0.000 0 0 0 0.00 0 1724464889 1724474142 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 Y 0 A 0 63dab98a-d32f-46c1-a762-03ca45cbda82 1 1529 0
60373 {"from":"21","to":"21"} a157d399-a5de-4ceb-8b10-3f321017d29b P A 99 33.00 999 0.000 0 0 0 0.00 0 1724473352 1724473377 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 a157d399-a5de-4ceb-8b10-3f321017d29b 1 1529 0
60375 {"from":"21","to":"21"} d30ce803-ed0f-45bf-8796-5d791dde3847 P A 99 33.00 999 0.000 0 0 0 0.00 0 1724473522 1724827549 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 d30ce803-ed0f-45bf-8796-5d791dde3847 1 1529 0
60376 {"from":"21","to":"21"} 6100b4f4-1d35-4093-9022-daf70e7d7759 P A 99 33.00 999 0.000 0 0 0 0.00 0 1724471775 1724471864 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 6100b4f4-1d35-4093-9022-daf70e7d7759 1 1529 0
60377 {"from":"21","to":"21"} 80744d1d-04b4-4bfc-819b-5244e2377288 P A 99 116.00 999 0.000 0 0 0 0.00 0 1724470045 1724471296 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 80744d1d-04b4-4bfc-819b-5244e2377288 1 1527 0
60381 {"from":"21","to":"21"} 411074ff-b000-4138-99ad-e5873edcf21f P A 99 103.00 999 0.000 0 0 0 0.00 0 1724469887 1724471353 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 411074ff-b000-4138-99ad-e5873edcf21f 1 1527 0
60383 {"from":"21","to":"21"} d9ca9f88-adcf-4fbb-ab57-db5b6f0d20dd P A 99 140.00 999 0.000 0 0 0 0.00 0 1724474370 1724474435 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 Y 0 A 0 d9ca9f88-adcf-4fbb-ab57-db5b6f0d20dd 1 1529 0
60384 {"from":"21","to":"21"} 3e164c3e-f68e-4347-b39c-621ae964fbc8 P A 99 51.00 999 0.000 0 0 0 0.00 0 1724473719 1724473746 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 0 0 0
60385 {"from":"21","to":"21"} 70a0c0f0-9536-4b6f-9020-3a808b5dbc33 P A 99 107.00 999 0.000 0 0 0 0.00 0 1724469718 1724471368 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 70a0c0f0-9536-4b6f-9020-3a808b5dbc33 1 1527 0
60386 {"from":"21","to":"21"} c60b67ad-fb50-4cdb-aa70-d3ec1e6a8ce5 P A 99 103.00 999 0.000 0 0 0 0.00 0 1724469394 1724471387 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 c60b67ad-fb50-4cdb-aa70-d3ec1e6a8ce5 1 1527 0
60391 {"from":"21","to":"21"} 2753a5dd-efa8-4a64-8cdd-5bb77d92974c P A 99 56.00 999 0.000 0 0 0 0.00 0 1724469187 1724471402 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 2753a5dd-efa8-4a64-8cdd-5bb77d92974c 1 1527 0
60392 {"from":"21","to":"21"} 55459ef8-2c11-4d09-9cd7-047a6433dca9 P A 99 68.00 999 0.000 0 0 0 0.00 0 1724468798 1724471418 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 55459ef8-2c11-4d09-9cd7-047a6433dca9 1 1527 0
60393 {"from":"21","to":"21"} 79bb53b7-759a-4739-b60a-f0b64dfc806b P A 99 47.00 999 0.000 0 0 0 0.00 0 1724468647 1724471436 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 79bb53b7-759a-4739-b60a-f0b64dfc806b 1 1527 0
60394 {"from":"21","to":"21"} ab727167-5295-4a93-a303-5f3c5252652f P A 99 60.00 999 0.000 0 0 0 0.00 0 1724468289 1724471480 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 ab727167-5295-4a93-a303-5f3c5252652f 1 1527 0
60397 {"from":"21","to":"21"} 0d616794-2881-462a-a794-8b8c188b338d P A 99 205.00 999 0.000 0 0 0 0.00 0 1724474640 1724474767 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 0 0 0
60401 {"from":"21","to":"21"} 04c0c5fa-121d-4643-b356-182267999be4 P A 99 140.00 999 0.000 0 0 0 0.00 0 1724465027 1724827801 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 Y 0 A 0 04c0c5fa-121d-4643-b356-182267999be4 1 1529 0
60402 {"from":"21","to":"21"} d0dad17f-31a3-4c0a-96ca-5f7a93960c64 P A 99 140.00 999 0.000 0 0 0 0.00 0 1724465148 1724827840 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 Y 0 A 0 d0dad17f-31a3-4c0a-96ca-5f7a93960c64 1 1529 0
60403 {"from":"21","to":"21"} f1763353-c093-4d6c-9f2e-88f43f3e530e P A 99 140.00 999 0.000 0 0 0 0.00 0 1724465918 1724473952 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 Y 0 A 0 f1763353-c093-4d6c-9f2e-88f43f3e530e 1 1529 0
60407 {"from":"21","to":"21"} 32b496dd-d321-47cc-8e53-61b2bb3c3318 P A 99 88.00 999 0.000 0 0 0 0.00 0 1724472811 1724473144 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 0 0 0
60408 {"from":"21","to":"21"} 446c2316-e46d-4750-a022-231b8969654c P A 99 130.00 999 0.000 0 0 0 0.00 0 1724473112 1724473149 0 N N N N P N N N Y 10 0 N N 0 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;} activity 0 N 0 A 0 0 0 0