SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    1615, 1616, 2593, 2594, 2595, 2617, 2618, 
    2649, 2650, 2788, 2789, 2790, 2791, 
    2877, 2878, 2879, 2938, 2939, 2940, 
    2941, 3034, 3033, 3104, 3105, 3106, 
    3112, 3113, 3609, 3370, 3371, 3664, 
    3665, 7608, 7279, 7283, 7616, 7285, 
    7620, 7619, 7618, 7617, 7293, 7625, 
    8474, 8475, 2441
  )

Query time 0.00117

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "32.21"
    },
    "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": 46,
      "rows_produced_per_join": 46,
      "filtered": "100.00",
      "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_products`.`product_id` in (1615,1616,2593,2594,2595,2617,2618,2649,2650,2788,2789,2790,2791,2877,2878,2879,2938,2939,2940,2941,3034,3033,3104,3105,3106,3112,3113,3609,3370,3371,3664,3665,7608,7279,7283,7616,7285,7620,7619,7618,7617,7293,7625,8474,8475,2441))",
      "cost_info": {
        "read_cost": "27.61",
        "eval_cost": "4.60",
        "prefix_cost": "32.21",
        "data_read_per_join": "203K"
      },
      "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
1615 200002446 P A 1 0.00 100 0.000 0 0 0 0.00 0 1747643830 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
1616 682AEDFFF3567 V A 1 0.00 100 0.000 0 0 0 0.00 0 1747643907 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 1615 0.000 0.000
2441 P A 1 0.00 100 0.000 0 0 0 0.00 0 1751843862 1764100466 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
2593 JBLT310CRED P A 1 0.00 100 0.000 0 0 0 0.00 0 1752001823 1761654189 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
2594 JBLT310CBLK V A 1 0.00 100 0.000 0 0 0 0.00 0 1752002005 1761654189 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 2593 0.000 0.000
2595 JBLT310CBLU V A 1 0.00 100 0.000 0 0 0 0.00 0 1752002005 1761654189 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 2593 0.000 0.000
2617 JBLT125BTWHT V A 1 0.00 100 0.000 0 0 0 0.00 0 1752007257 1763639643 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 2618 0.000 0.000
2618 JBLT125BTBLK P A 1 0.00 100 0.000 0 0 0 0.00 0 1752007342 1763639643 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
2649 Z2F-00013 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752051213 1764492820 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
2650 Z3H-00013 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752051396 1764492820 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 2649 0.000 0.000
2788 JBLLIVEBEAM3BLK P A 1 0.00 100 0.000 0 0 0 0.00 0 1752232557 1761654190 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
2789 JBLLIVEBEAM3BLU V A 1 0.00 100 0.000 0 0 0 0.00 0 1752232614 1761654190 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 2788 0.000 0.000
2790 JBLLIVEBEAM3SIL V A 1 0.00 100 0.000 0 0 0 0.00 0 1752232614 1761654190 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 2788 0.000 0.000
2791 JBLLIVEBEAM3PUR V A 1 0.00 100 0.000 0 0 0 0.00 0 1752232614 1761654190 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 2788 0.000 0.000
2877 JBLWFLEXBLU P A 1 123000.00 100 0.000 0 0 0 0.00 0 1752352885 1763639582 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
2878 JBLWFLEXWHT V A 1 123000.00 100 0.000 0 0 0 0.00 0 1752352958 1763639582 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 2877 0.000 0.000
2879 JBLWFLEXBEG V A 1 123000.00 100 0.000 0 0 0 0.00 0 1752352958 1763639582 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 2877 0.000 0.000
2938 A31X1111 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752467540 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
2939 A31X1191 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752469162 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 2938 0.000 0.000
2940 A31X1161 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752469162 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 2938 0.000 0.000
2941 A31X11Q1 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752469162 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 2938 0.000 0.000
3033 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752498804 1763967047 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
3034 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752499140 1763967047 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 3033 0.000 0.000
3104 A3035011 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752615324 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
3105 A3035021 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752615896 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 3104 0.000 0.000
3106 A3035031 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752615896 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 3104 0.000 0.000
3112 B2557211 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752650256 1755431694 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
3113 B2557221 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752650496 1755431694 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 3112 0.000 0.000
3370 BPB024hqWH P A 1 0.00 100 0.000 0 0 0 0.00 0 1753552633 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
3371 BPB024hqBK V A 1 0.00 100 0.000 0 0 0 0.00 0 1753552669 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 3370 0.000 0.000
3609 BPB024hqBL V A 1 0.00 100 0.000 0 0 0 0.00 0 1754254267 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 3370 0.000 0.000
3664 A81H5H11 P A 1 0.00 100 0.000 0 0 0 0.00 0 1754320055 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
3665 A81H5H21 V A 1 0.00 100 0.000 0 0 0 0.00 0 1754320121 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 3664 0.000 0.000
7279 85U7Q P A 1 2315000.00 10 0.000 0 0 0 0.00 0 1761850310 1764683913 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
7283 65Q7Q P A 1 935000.00 100 0.000 0 0 0 0.00 0 1761853287 1764683913 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
7285 75A6500N P A 1 1107000.00 100 0.000 0 0 0 0.00 0 1761853574 1764683913 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
7293 43A4Q P A 1 290000.00 100 0.000 0 0 0 0.00 0 1761855775 1764683914 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
7608 75U7Q P A 1 1610000.00 10 0.000 0 0 0 0.00 0 1762254919 1764683913 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
7616 55Q7Q P A 1 750000.00 100 0.000 0 0 0 0.00 0 1762258504 1764683913 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
7617 50A6500N P A 1 450000.00 100 0.000 0 0 0 0.00 0 1762258824 1764683914 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
7618 55A6500N P A 1 490000.00 100 0.000 0 0 0 0.00 0 1762258824 1764683914 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
7619 65A6500N P A 1 780000.00 100 0.000 0 0 0 0.00 0 1762258824 1764683914 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
7620 43A6500N P A 1 395000.00 100 0.000 0 0 0 0.00 0 1762258824 1764683914 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
7625 32A4Q P A 1 205000.00 100 0.000 0 0 0 0.00 0 1762259783 1764683914 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
8474 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763639132 1764100466 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
8475 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763639132 1764100466 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