SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    8703, 8783, 8804, 8275, 8569, 8724, 8445, 
    8470, 8435, 8801, 8805, 8811, 8815, 
    8441, 8446, 8543, 8245, 8440, 8519, 
    8593, 8595, 8432, 8444, 8471, 8594, 
    8472, 8457, 8806, 8830, 8575, 8828, 
    8269, 8466, 8363, 8459, 8460, 8603, 
    8581, 8709, 8438
  )

Query time 0.00123

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "28.01"
    },
    "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": 40,
      "rows_produced_per_join": 40,
      "filtered": "100.00",
      "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_products`.`product_id` in (8703,8783,8804,8275,8569,8724,8445,8470,8435,8801,8805,8811,8815,8441,8446,8543,8245,8440,8519,8593,8595,8432,8444,8471,8594,8472,8457,8806,8830,8575,8828,8269,8466,8363,8459,8460,8603,8581,8709,8438))",
      "cost_info": {
        "read_cost": "24.01",
        "eval_cost": "4.00",
        "prefix_cost": "28.01",
        "data_read_per_join": "176K"
      },
      "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
8245 Hama-201748 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763006223 1764065877 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
8269 Hama-205006 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763047133 1764065926 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
8275 Hama-118107 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763087824 1764066173 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
8363 Hama-125115 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763396557 1764066511 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
8432 Hama-182699 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763549657 1764068382 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
8435 Hama-188301 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763550814 1764068436 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
8438 Hama-173193 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763552636 1764068487 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
8440 Hama-7003 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763555685 1764068499 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
8441 Hama-227040 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763556230 1764068510 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
8444 Hama-222086 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763572691 1764068561 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
8445 Hama-227002 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763573615 1764068572 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
8446 Hama-227038 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763574024 1764068585 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
8457 Hama-227041 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763585298 1764068619 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
8459 Hama-200103 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763586304 1764068670 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
8460 Hama-200110 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763586755 1764068691 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
8466 Hama-227047 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763595104 1764069611 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
8470 Hama-185663 P A 1 0.00 99 0.000 0 0 0 0.00 0 1763596697 1764069790 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
8471 Hama-227045 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763596971 1764069808 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
8472 Hama-187259 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763597423 1764069831 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
8519 Hama-188237 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763662911 1764069913 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
8543 Hama-54448 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763707846 1764070423 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
8569 Hama-D3045054 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763782093 1764072061 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
8575 Hama-222042 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763787350 1764072187 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
8581 Hama-222060 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763788903 1764072355 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
8593 Hama-217223 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763796164 1764072603 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
8594 Hama-217224 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763796407 1764072614 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
8595 Hama-217226 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763796859 1764072626 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
8603 Hama-184105 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763800702 1764073070 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
8703 Hama-221753 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763872091 1764075493 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
8709 Hama-184169 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763874013 1764075539 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
8724 Hama-123762 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763885521 1764075551 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
8783 Hama-222048 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763923158 1764077888 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
8801 Hama-178257 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763955548 1764078133 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
8804 Hama-220831 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763956802 1764078174 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
8805 Hama-186066 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763960844 1764078194 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
8806 Hama-D3223861 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763961327 1764078310 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
8811 Hama-123749 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763963048 1764078559 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
8815 Hama-PCACC-005-BLK P A 1 0.00 100 0.000 0 0 0 0.00 0 1763964438 1764078635 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
8828 Hama-123765 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763986918 1764078691 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
8830 Hama-136023 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763988304 1764078720 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