SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    1600, 1601, 2314, 2312, 2310, 2333, 2430, 
    2431, 2559, 2560, 3663, 2698, 2822, 
    2823, 2824, 2825, 2826, 2922, 2923, 
    2924, 2925, 2927, 2928, 2929, 3090, 
    3091, 3092, 3093, 3094, 3131, 3132, 
    3133, 3136, 3137, 3138, 3155, 3156, 
    2737, 3255, 3604, 3603, 3605, 3606
  )

Query time 0.00107

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "30.11"
    },
    "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": 43,
      "rows_produced_per_join": 43,
      "filtered": "100.00",
      "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_products`.`product_id` in (1600,1601,2314,2312,2310,2333,2430,2431,2559,2560,3663,2698,2822,2823,2824,2825,2826,2922,2923,2924,2925,2927,2928,2929,3090,3091,3092,3093,3094,3131,3132,3133,3136,3137,3138,3155,3156,2737,3255,3604,3603,3605,3606))",
      "cost_info": {
        "read_cost": "25.81",
        "eval_cost": "4.30",
        "prefix_cost": "30.11",
        "data_read_per_join": "190K"
      },
      "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",
        "facebook_obj_type",
        "parent_product_id",
        "buy_now_url",
        "units_in_product",
        "show_price_per_x_units",
        "ab__stickers_manual_ids",
        "ab__stickers_generated_ids"
      ]
    }
  }
}

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 facebook_obj_type parent_product_id buy_now_url units_in_product show_price_per_x_units ab__stickers_manual_ids ab__stickers_generated_ids
1600 A1657H11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1747638854 1761655495 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
1601 A1657H21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1747638898 1761655495 0 N N N N Y N N Y 3 0 N N 0 default 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 1600 0.000 0.000
2310 200002444 P A 1 0.00 100 0.000 0 0 0 0.00 0 1750762689 1761655495 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
2312 A1259H11 V A 1 0.00 100 0.000 0 0 0 0.00 0 1750763169 1761655495 0 N N N N Y N N Y 3 0 N N 0 default 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 2310 0.000 0.000
2314 200002444_9BBC V A 1 0.00 100 0.000 0 0 0 0.00 0 1750763169 1761655495 0 N N N N Y N N Y 3 0 N N 0 default 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 2310 0.000 0.000
2333 A1618H11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1750937831 1761655495 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
2430 A81F5H11 V A 1 0.00 100 0.000 0 0 0 0.00 0 1751833526 1754909572 0 N N N N Y N N Y 3 0 N N 0 default 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 2431 0.000 0.000
2431 A81F5H21 P A 1 0.00 100 0.000 0 0 0 0.00 0 1751834436 1754909572 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
2559 A3968H11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1751965180 1761661168 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
2560 A3968Z21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1751965743 1761661168 0 N N N N Y N N Y 3 0 N N 0 default 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 2559 0.000 0.000
2698 A80F1HV1 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752074816 1754909572 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
2737 A2331K11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752092712 1754909572 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
2822 A3947H11 P A 1 101000.00 100 0.000 0 0 0 0.00 0 1752331426 1763635476 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
2823 A3947H21 V A 1 101000.00 100 0.000 0 0 0 0.00 0 1752331699 1763635476 0 N N N N Y N N Y 3 0 N N 0 default 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 2822 0.000 0.000
2824 A3947H31 V A 1 101000.00 100 0.000 0 0 0 0.00 0 1752331699 1763635476 0 N N N N Y N N Y 3 0 N N 0 default 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 2822 0.000 0.000
2825 A3947H61 V A 1 101000.00 100 0.000 0 0 0 0.00 0 1752331699 1763635476 0 N N N N Y N N Y 3 0 N N 0 default 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 2822 0.000 0.000
2826 A3947H51 V A 1 101000.00 100 0.000 0 0 0 0.00 0 1752331699 1763635476 0 N N N N Y N N Y 3 0 N N 0 default 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 2822 0.000 0.000
2922 A81B5H11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752414907 1754909572 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
2923 A81B5H21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752414978 1754909572 0 N N N N Y N N Y 3 0 N N 0 default 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 2922 0.000 0.000
2924 A2656K11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752420630 1754909572 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
2925 A2656K21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752420792 1754909572 0 N N N N Y N N Y 3 0 N N 0 default 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 2924 0.000 0.000
2927 A3994H11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752421987 1761661169 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
2928 A3994H21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752422361 1761661169 0 N N N N Y N N Y 3 0 N N 0 default 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 2927 0.000 0.000
2929 A3994H31 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752422361 1761661169 0 N N N N Y N N Y 3 0 N N 0 default 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 2927 0.000 0.000
3090 A3959H11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752606246 1761661168 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
3091 A3959H21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752606875 1761661168 0 N N N N Y N N Y 3 0 N N 0 default 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 3090 0.000 0.000
3092 A3959H61 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752606875 1761661168 0 N N N N Y N N Y 3 0 N N 0 default 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 3090 0.000 0.000
3093 A3959H31 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752606875 1761661168 0 N N N N Y N N Y 3 0 N N 0 default 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 3090 0.000 0.000
3094 A3959H51 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752606875 1761661168 0 N N N N Y N N Y 3 0 N N 0 default 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 3090 0.000 0.000
3131 A1688H11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752695687 1761655494 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
3132 A1688H21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752696203 1761655494 0 N N N N Y N N Y 3 0 N N 0 default 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 3131 0.000 0.000
3133 A1688H31 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752696203 1761655494 0 N N N N Y N N Y 3 0 N N 0 default 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 3131 0.000 0.000
3136 A3004H12 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752785074 1761661168 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
3137 A3004H22 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752786081 1761661168 0 N N N N Y N N Y 3 0 N N 0 default 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 3136 0.000 0.000
3138 A3004H32 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752786081 1761661168 0 N N N N Y N N Y 3 0 N N 0 default 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 3136 0.000 0.000
3155 A2642K11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752786000 1754909572 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
3156 A2642K21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752872741 1754909572 0 N N N N Y N N Y 3 0 N N 0 default 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 3155 0.000 0.000
3255 A2331K21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1753047455 1754909572 0 N N N N Y N N Y 3 0 N N 0 default 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 2737 0.000 0.000
3603 A2698K11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1754226679 1754302992 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
3604 A2698K21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1754226722 1754302992 0 N N N N Y N N Y 3 0 N N 0 default 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 3603 0.000 0.000
3605 A2699K11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1754227489 1761640318 0 N N N N Y N N Y 3 0 N N 0 default 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 0.000 0.000
3606 A2699K21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1754227534 1761640318 0 N N N N Y N N Y 3 0 N N 0 default 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 3605 0.000 0.000
3663 A3968Z61 V A 1 0.00 100 0.000 0 0 0 0.00 0 1754318595 1761661168 0 N N N N Y N N Y 3 0 N N 0 default 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 2559 0.000 0.000