SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    10982, 10983, 10978, 10996, 10995, 10993, 
    11008, 11033, 11032, 11031, 11034, 
    11028, 11029, 11027, 11107, 11106, 
    11105, 11104, 11122, 11121, 11133, 
    11135, 11140, 11139, 11142, 11141, 
    11356, 11357, 11358, 11359, 11464, 
    11466, 11468, 11549, 11554, 11556, 
    11550, 11552, 11553, 11557, 11558, 
    11568, 11569
  )

Query time 0.00123

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 (10982,10983,10978,10996,10995,10993,11008,11033,11032,11031,11034,11028,11029,11027,11107,11106,11105,11104,11122,11121,11133,11135,11140,11139,11142,11141,11356,11357,11358,11359,11464,11466,11468,11549,11554,11556,11550,11552,11553,11557,11558,11568,11569))",
      "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
10978 RB0316S 50 6826J5 P A 1 451250.00 100 0.000 0 0 0 0.00 0 1768838461 1768855711 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
10982 RB0316S 50 901/31 V A 1 327750.00 100 0.000 0 0 0 0.00 0 1768840100 1768855711 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 10978 0.000 0.000
10983 RB0316S 50 990/31 V A 1 451250.00 100 0.000 0 0 0 0.00 0 1768840143 1768855711 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 10978 0.000 0.000
10993 RB0316S 53 136678 P A 1 418750.00 100 0.000 0 0 0 0.00 0 1768852505 1768855381 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
10995 RB0316S 53 901/31 V A 1 321750.00 100 0.000 0 0 0 0.00 0 1768853923 1768855381 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 10993 0.000 0.000
10996 RB0316S 53 990/31 V A 1 321750.00 100 0.000 0 0 0 0.00 0 1768853923 1768855381 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 10993 0.000 0.000
11008 RB0316S 53 136678_FA9A V A 1 418750.00 100 0.000 0 0 0 0.00 0 1768856466 1768855381 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 10993 0.000 0.000
11027 RB2140 50 127771 V A 1 321750.00 100 0.000 0 0 0 0.00 0 1768869567 1768908438 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 11033 0.000 0.000
11028 RB2140 50 901/58 V A 1 386500.00 100 0.000 0 0 0 0.00 0 1768870236 1768908438 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 11033 0.000 0.000
11029 RB2140 50 135931 V A 1 321750.00 100 0.000 0 0 0 0.00 0 1768870236 1768908438 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 11033 0.000 0.000
11031 RB2140 50 1355R5 V A 1 321750.00 100 0.000 0 0 0 0.00 0 1768870236 1768908438 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 11033 0.000 0.000
11032 RB2140 50 1387GG V A 1 321750.00 100 0.000 0 0 0 0.00 0 1768870236 1768908438 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 11033 0.000 0.000
11033 RB2140 50 1409B1 P A 1 321750.00 100 0.000 0 0 0 0.00 0 1768870432 1768908438 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
11034 RB2140 50 1446R5 V A 1 321750.00 100 0.000 0 0 0 0.00 0 1768870547 1768908438 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 11033 0.000 0.000
11104 RB2193 53 138085 P A 1 334500.00 100 0.000 0 0 0 0.00 0 1769019955 1769032409 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
11105 RB2193 53 902/31 V A 1 312000.00 100 0.000 0 0 0 0.00 0 1769020274 1769032409 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 11104 0.000 0.000
11106 RB2193 53 901/31 V A 1 316500.00 100 0.000 0 0 0 0.00 0 1769020274 1769032409 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 11104 0.000 0.000
11107 RB2193 53 138171 V A 1 334500.00 100 0.000 0 0 0 0.00 0 1769020274 1769032409 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 11104 0.000 0.000
11121 RB2198 60 901/31 P A 1 312000.00 100 0.000 0 0 0 0.00 0 1769031006 1769034991 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
11122 RB2198 60 902/R5 V A 1 316500.00 100 0.000 0 0 0 0.00 0 1769031140 1769034991 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 11121 0.000 0.000
11133 RB3136 55 001 P A 1 312000.00 100 0.000 0 0 0 0.00 0 1769034527 1769035520 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
11135 RB3136 55 004 V A 1 312000.00 100 0.000 0 0 0 0.00 0 1769034894 1769035520 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 11133 0.000 0.000
11139 RB2230 53 901/31 P A 1 312000.00 100 0.000 0 0 0 0.00 0 1769035940 1769036918 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
11140 RB2230 53 902/51 V A 1 334500.00 100 0.000 0 0 0 0.00 0 1769036185 1769036918 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 11139 0.000 0.000
11141 RB3136 58 001 P A 1 312000.00 100 0.000 0 0 0 0.00 0 1769036241 1769036791 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
11142 RB3136 58 004 V A 1 312000.00 100 0.000 0 0 0 0.00 0 1769036445 1769036791 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 11141 0.000 0.000
11356 RB3728 58 004/84 P A 1 268500.00 100 0.000 0 0 0 0.00 0 1769450768 1769450874 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
11357 RB3728 58 92136V V A 1 303000.00 100 0.000 0 0 0 0.00 0 1769451034 1769450874 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 11356 0.000 0.000
11358 RB3728 55 004/1A P A 1 268500.00 100 0.000 0 0 0 0.00 0 1769451536 1769451719 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
11359 RB3728 55 004/84 V A 1 268500.00 100 0.000 0 0 0 0.00 0 1769451792 1769451719 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 11358 0.000 0.000
11464 RB3758 54 003/81 P A 1 322500.00 100 0.000 0 0 0 0.00 0 1769641059 1769641210 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
11466 RB3758 54 004/84 V A 1 268500.00 100 0.000 0 0 0 0.00 0 1769641297 1769641210 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 11464 0.000 0.000
11468 RB3758 54 9213/2 V A 1 268500.00 100 0.000 0 0 0 0.00 0 1769641519 1769641210 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 11464 0.000 0.000
11549 RB4441D 53 667771 P A 1 268500.00 100 0.000 0 0 0 0.00 0 1769961299 1769961453 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
11550 RB4457D 55 667711 P A 1 286500.00 100 0.000 0 0 0 0.00 0 1769961383 1769961465 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
11552 RB4457D 55 677287 V A 1 268500.00 100 0.000 0 0 0 0.00 0 1769961585 1769961465 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 11550 0.000 0.000
11553 RB4457D 55 667787 V A 1 268500.00 100 0.000 0 0 0 0.00 0 1769961585 1769961465 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 11550 0.000 0.000
11554 RB4441D 53 677787 V A 1 268500.00 100 0.000 0 0 0 0.00 0 1769962035 1769961453 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 11549 0.000 0.000
11556 RB4441D 53 677973 V A 1 268500.00 100 0.000 0 0 0 0.00 0 1769962406 1769961453 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 11549 0.000 0.000
11557 RB3845 60 9035R5 P A 1 312000.00 100 0.000 0 0 0 0.00 0 1769962935 1769963011 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
11558 RB3845 60 919631 V A 1 312000.00 100 0.000 0 0 0 0.00 0 1769963094 1769963011 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 11557 0.000 0.000
11568 RB3565 53 002/48 P A 1 394500.00 100 0.000 0 0 0 0.00 0 1770072329 1770072417 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
11569 RB3565 53 003/3F V A 1 328500.00 100 0.000 0 0 0 0.00 0 1770072461 1770072417 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 11568 0.000 0.000