SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    2112, 2111, 2110, 2258, 2257, 2256, 2255, 
    2305, 2304, 2373, 2374, 2393, 2394, 
    2499, 2500, 2517, 2518, 2519, 2581, 
    2585, 2586, 2623, 2624, 2625, 2626, 
    2631, 2632, 2633, 2685, 2686, 2687, 
    8417, 8418, 8419, 8420, 8398, 8415, 
    8416, 8421, 2432, 8485, 8484, 8483, 
    2455, 8488, 8487, 8486, 8490, 8489, 
    2438, 2459, 8492, 8491, 8493
  )

Query time 0.01136

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "37.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": 54,
      "rows_produced_per_join": 54,
      "filtered": "100.00",
      "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_products`.`product_id` in (2112,2111,2110,2258,2257,2256,2255,2305,2304,2373,2374,2393,2394,2499,2500,2517,2518,2519,2581,2585,2586,2623,2624,2625,2626,2631,2632,2633,2685,2686,2687,8417,8418,8419,8420,8398,8415,8416,8421,2432,8485,8484,8483,2455,8488,8487,8486,8490,8489,2438,2459,8492,8491,8493))",
      "cost_info": {
        "read_cost": "32.41",
        "eval_cost": "5.40",
        "prefix_cost": "37.81",
        "data_read_per_join": "238K"
      },
      "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
2110 683D8C3A9AFC9 P A 1 130000.00 100 0.000 0 0 0 0.00 0 1748863738 1765969288 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
2111 V A 1 130000.00 100 0.000 0 0 0 0.00 0 1748864087 1765969288 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 2110 0.000 0.000
2112 683D8C3A9AFCD V A 1 130000.00 100 0.000 0 0 0 0.00 0 1748864087 1765969288 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 2110 0.000 0.000
2255 P A 1 0.00 100 0.000 0 0 0 0.00 0 1750253592 1764100468 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
2256 6852C2CF21E5D V A 1 0.00 100 0.000 0 0 0 0.00 0 1750254296 1764100468 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 2255 0.000 0.000
2257 6852C2D61B0D2 V A 1 0.00 100 0.000 0 0 0 0.00 0 1750254296 1764100468 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 2255 0.000 0.000
2258 6852C2D29E1BE V A 1 0.00 99 0.000 0 0 0 0.00 0 1750254296 1764100468 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 2255 0.000 0.000
2304 685A7C3C6CA4E P A 1 0.00 100 0.000 0 0 0 0.00 0 1750760460 1764100467 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
2305 685A7C3C6CA4E_3BC4 V A 1 0.00 100 0.000 0 0 0 0.00 0 1750760512 1764100467 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 2304 0.000 0.000
2373 V A 1 0.00 100 0.000 0 0 0 0.00 0 1751463423 1764100469 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 2374 0.000 0.000
2374 68653696AE33F P A 1 0.00 100 0.000 0 0 0 0.00 0 1751463576 1764100469 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
2393 P A 1 0.00 100 0.000 0 0 0 0.00 0 1751542251 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
2394 68666B0A98B20 V A 1 0.00 100 0.000 0 0 0 0.00 0 1751542540 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 2393 0.000 0.000
2432 L75MB‑APEU P A 1 0.00 100 0.000 0 0 0 0.00 0 1751836933 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
2438 L50MB‑ASEA P A 1 0.00 100 0.000 0 0 0 0.00 0 1751841661 1764100830 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
2455 P A 1 0.00 100 0.000 0 0 0 0.00 0 1751874170 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
2459 P A 1 0.00 100 0.000 0 0 0 0.00 0 1751875186 1766757902 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
2499 P A 1 0.00 100 0.000 0 0 0 0.00 0 1751889928 1764100469 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
2500 V A 1 0.00 100 0.000 0 0 0 0.00 0 1751890267 1764100469 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 2499 0.000 0.000
2517 V A 1 0.00 100 0.000 0 0 0 0.00 0 1751894266 1764100468 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 2519 0.000 0.000
2518 V A 1 0.00 100 0.000 0 0 0 0.00 0 1751894738 1764100468 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 2519 0.000 0.000
2519 P A 1 0.00 100 0.000 0 0 0 0.00 0 1751894738 1764100468 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
2581 P A 1 0.00 100 0.000 0 0 0 0.00 0 1751980713 1764100468 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
2585 V A 1 0.00 100 0.000 0 0 0 0.00 0 1751981104 1764100468 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 2581 0.000 0.000
2586 V A 1 0.00 100 0.000 0 0 0 0.00 0 1751981104 1764100468 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 2581 0.000 0.000
2623 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752009807 1764100468 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
2624 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752010144 1764100468 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 2623 0.000 0.000
2625 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752010144 1764100468 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 2623 0.000 0.000
2626 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752010144 1764100468 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 2623 0.000 0.000
2631 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752041639 1764100468 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
2632 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752042018 1764100468 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 2631 0.000 0.000
2633 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752042018 1764100468 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 2631 0.000 0.000
2685 P A 1 0.00 100 0.000 0 0 0 0.00 0 1752068116 1764100468 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
2686 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752068311 1764100468 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 2685 0.000 0.000
2687 V A 1 0.00 100 0.000 0 0 0 0.00 0 1752068311 1764100468 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 2685 0.000 0.000
8398 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763485207 1764100467 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
8415 V A 1 0.00 100 0.000 0 0 0 0.00 0 1763537106 1764100467 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 8398 0.000 0.000
8416 V A 1 0.00 100 0.000 0 0 0 0.00 0 1763537106 1764100467 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 8398 0.000 0.000
8417 V A 1 0.00 100 0.000 0 0 0 0.00 0 1763537106 1764100467 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 8398 0.000 0.000
8418 V A 1 0.00 100 0.000 0 0 0 0.00 0 1763537106 1764100467 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 8398 0.000 0.000
8419 V A 1 0.00 100 0.000 0 0 0 0.00 0 1763537106 1764100467 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 8398 0.000 0.000
8420 V A 1 0.00 100 0.000 0 0 0 0.00 0 1763537106 1764100467 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 8398 0.000 0.000
8421 V A 1 0.00 100 0.000 0 0 0 0.00 0 1763537106 1764100467 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 8398 0.000 0.000
8483 L43MB‑APEU P A 1 0.00 100 0.000 0 0 0 0.00 0 1763645434 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
8484 L55MB‑APEU P A 1 0.00 100 0.000 0 0 0 0.00 0 1763645434 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
8485 L65MB‑APEU P A 1 0.00 100 0.000 0 0 0 0.00 0 1763645434 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
8486 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763645597 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
8487 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763645597 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
8488 P A 1 625000.00 100 0.000 0 0 0 0.00 0 1763645597 1766060922 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
8489 L55MB‑ASEA P A 1 0.00 100 0.000 0 0 0 0.00 0 1763645765 1764100830 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
8490 L65MB‑ASEA P A 1 0.00 100 0.000 0 0 0 0.00 0 1763645765 1764100783 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
8491 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763645958 1766757903 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
8492 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763645958 1766757903 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
8493 P A 1 0.00 100 0.000 0 0 0 0.00 0 1763645958 1766757902 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