SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    2726, 2727, 15544, 16335, 15151, 15150, 
    15423, 3216, 2718, 2721, 2678, 15973, 
    15426, 2567, 2557, 2569, 2556, 2822, 
    2808, 2843, 2813, 2814, 2600, 2597
  )

Query time 0.00076

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "16.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": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "index_condition": "(`dev_yourmart_co_bw`.`cscart_products`.`product_id` in (2726,2727,15544,16335,15151,15150,15423,3216,2718,2721,2678,15973,15426,2567,2557,2569,2556,2822,2808,2843,2813,2814,2600,2597))",
      "cost_info": {
        "read_cost": "14.41",
        "eval_cost": "2.40",
        "prefix_cost": "16.81",
        "data_read_per_join": "124K"
      },
      "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",
        "is_stock_split_by_warehouses",
        "is_view_only",
        "ab__stickers_manual_ids",
        "ab__stickers_generated_ids",
        "is_discount",
        "xero_product_id",
        "is_tookan_sameday",
        "cost_price",
        "sg_extra",
        "updated_by",
        "sg_old_product",
        "sg_locations"
      ]
    }
  }
}

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 is_stock_split_by_warehouses is_view_only ab__stickers_manual_ids ab__stickers_generated_ids is_discount xero_product_id is_tookan_sameday cost_price sg_extra updated_by sg_old_product sg_locations
2556 6001108028860 P A 90 0.00 0 0.000 54 28 21 0.00 0 1600176297 1705592806 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N 4322a056-772c-4531-9f81-ee0f16fbb7ec Y 0.00 V N
2557 6001108029157 P A 90 0.00 0 0.000 54 28 21 0.00 0 1600176297 1735839080 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N d260adf7-807c-4a27-85c7-9b4e917c879c Y 0.00 V N
2567 6001108066275 P A 90 0.00 0 0.000 54 28 21 0.00 0 1600176297 1705592625 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N 77660d37-a303-49ee-b207-bf03bc290cf2 Y 0.00 V N
2569 6001108075994 P A 90 0.00 0 0.000 54 28 21 0.00 0 1600176297 1701526983 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N 283206a8-82e2-4585-89c5-d56fd57b3459 Y 0.00 V N
2597 6001452611008 P A 90 0.00 0 0.000 54 28 21 0.00 0 1600176297 1733841453 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N 706b821e-e8a3-4241-954e-500c2f5e9a7b Y 0.00 V N
2600 6001452641005 P A 90 0.00 0 0.000 54 28 21 0.00 0 1600176297 1705594408 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N 0589c327-dbe8-4b3a-a3fd-99ac30b22f8b Y 0.00 V N
2678 6002039009492 P A 90 0.00 0 0.000 54 28 21 0.00 0 1600176297 1701526983 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N 4db710ab-9d0b-415f-9ec2-401960b05e10 Y 0.00 V N
2718 LAN13 P A 90 120.15 60 0.000 54 28 21 0.00 0 1600176297 1744874132 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N c5a1630d-3857-4fa3-becf-90049461595d Y 0.00 V N
2721 LAN03 P A 90 87.10 96 0.000 54 28 21 0.00 0 1600176297 1744100456 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N dcdeeef0-25eb-4c71-987e-832662aaee58 Y 0.00 V N
2726 K900144 P A 90 111.15 100 0.000 54 28 21 0.00 0 1600176297 1743426989 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N e2abe3bd-5224-4809-88d3-8f5c2db8553e Y 0.00 V N
2727 K900146 P A 90 87.00 84 0.000 54 28 21 0.00 0 1600176297 1743427044 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N cc037ff9-b5de-4b5b-ad16-20b9911f8e5f Y 0.00 V N
2808 6009631320697 P A 90 0.00 0 0.000 54 28 21 0.00 0 1600176297 1701526983 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N 6cbed591-08b2-44ce-aae4-93cb7302d655 Y 0.00 V N
2813 6009648622180 P A 90 381.05 0 0.000 54 28 21 0.00 0 1600176297 1744282311 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N cdfdd8c5-6d08-4694-a1b4-6bfeeae66d21 Y 0.00 V N
2814 6009648622647 P A 90 607.10 12 0.000 54 28 21 0.00 0 1600176297 1744282363 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N da2bbec9-4063-45b7-b011-5dce7a52dc8f Y 0.00 V N
2822 6009692410030 P A 90 0.00 0 0.000 54 28 21 0.00 0 1600176297 1701526983 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N 609aba0c-301f-4ad7-9c7f-61c443c8e7a5 Y 0.00 V N
2843 6009880821143 P A 90 0.00 0 0.000 54 28 21 0.00 0 1600176297 1705592998 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N d0648f28-94db-4374-a6bd-a018033b20f9 Y 0.00 V N
3216 LAN09 P A 90 96.15 30 0.000 54 28 21 0.00 0 1600759115 1744100339 0,24 N N N B N R Y N N Y 10 0 S 0 0 0 0 9 N 0 P F 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;} 0 Y N N Y 0.00 V N
15150 LAN10 P A 90 120.15 192 0.000 54 28 21 0.00 0 1724928958 1744100200 0 N N N B N R N N N Y 10 0 N 0 0 0 0 9 N 0 P F 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;} 0 Y N N c6b073a7-9ef6-45d4-9bc0-90d54cd77f2d N 0.00 V N
15151 LAN12 P A 90 120.15 522 0.000 54 28 21 0.00 0 1724929142 1744726674 0 N N N B N R N N N Y 10 0 N 0 0 0 0 9 N 0 P F 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;} 0 N N N 22f41615-6285-4d2c-aaec-005d131cd80e N 0.00 V N
15423 LAN11 P A 90 120.15 2 0.000 54 28 21 0.00 0 1727349262 1744726718 0 N N N B N R N N N Y 10 0 N 0 0 0 0 9 N 0 P F 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;} 0 Y N N a46a5c68-e9f5-45c7-84b6-642ae3067f06 N 0.00 V N
15426 P A 90 0.00 1 0.000 54 28 21 0.00 0 1727350102 1727350102 0 N N N B N R N N N Y 10 0 N 0 0 0 0 9 N 0 P F 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;} 0 N N N N 0.00 V N
15544 LIQ0027 P A 119 758.00 82 0.000 54 28 21 0.00 0 1730152800 1748436076 0 N N N B N R N N N Y 10 0 N 0 0 0 0 9 N 0 P F 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;} 0 N N N N 443.76 V N {"CD":{"state":"CD","price":"758"},"CHD":{"state":"CHD","price":"758"},"GD":{"state":"GD","price":"758"},"KGD":{"state":"KGD","price":"758"},"KAD":{"state":"KAD","price":"758"},"KWD":{"state":"KWD","price":"758"},"NED":{"state":"NED","price":"758"},"NWD":{"state":"NWD","price":"758"},"SED":{"state":"SED","price":"758"},"SD":{"state":"SD","price":"758"}}
15973 LEO09 P A 90 134.85 6 0.000 0 0 0 0.00 0 1731676599 1740484602 0 N N N B N R N N N Y 10 0 N 0 0 0 0 9 N 0 P F 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;} 0 Y N N 17df6395-4293-40a3-b9fb-161e6191276d N 0.00 V N
16335 LIQ0026 P A 119 938.00 38 0.000 0 0 0 0.00 0 1736863205 1737030210 0 N N N B N R N N N Y 10 0 N 0 0 0 0 9 N 0 P F 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;} 0 N N N N 704.00 V N