SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    1517, 1518, 1519, 1520, 1521, 1522, 1523, 
    1524, 1525, 1537, 1538, 1539, 1540, 
    1541, 1542, 1543, 1544, 1545, 2217, 
    2218, 2219, 2735, 2863, 2864, 3729, 
    3732, 5220, 5221, 5222, 5223, 5224, 
    5225, 5226, 5227, 5237, 5238, 5239, 
    5240, 5241, 5242, 5243, 5244, 5817, 
    5818, 5819, 6322, 6448, 6449, 7494, 
    7495, 7498, 7499, 7504, 7505, 7526, 
    7527
  )

Query time 0.00081

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "39.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": 56,
      "rows_produced_per_join": 56,
      "filtered": "100.00",
      "index_condition": "(`gaseus`.`cscart_products`.`product_id` in (1517,1518,1519,1520,1521,1522,1523,1524,1525,1537,1538,1539,1540,1541,1542,1543,1544,1545,2217,2218,2219,2735,2863,2864,3729,3732,5220,5221,5222,5223,5224,5225,5226,5227,5237,5238,5239,5240,5241,5242,5243,5244,5817,5818,5819,6322,6448,6449,7494,7495,7498,7499,7504,7505,7526,7527))",
      "cost_info": {
        "read_cost": "33.61",
        "eval_cost": "5.60",
        "prefix_cost": "39.21",
        "data_read_per_join": "365K"
      },
      "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",
        "fiscal_data_1212",
        "mark_code_type",
        "parent_product_id",
        "yml2_brand",
        "yml2_origin_country",
        "yml2_store",
        "yml2_pickup",
        "yml2_delivery",
        "yml2_adult",
        "yml2_delivery_options",
        "yml2_bid",
        "yml2_model",
        "yml2_sales_notes",
        "yml2_type_prefix",
        "yml2_offer_type",
        "yml2_market_category",
        "yml2_manufacturer_warranty",
        "yml2_expiry",
        "yml2_purchase_price",
        "yml2_description",
        "yml2_cpa",
        "buy_now_url",
        "units_in_product",
        "show_price_per_x_units"
      ]
    }
  }
}

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 fiscal_data_1212 mark_code_type parent_product_id yml2_brand yml2_origin_country yml2_store yml2_pickup yml2_delivery yml2_adult yml2_delivery_options yml2_bid yml2_model yml2_sales_notes yml2_type_prefix yml2_offer_type yml2_market_category yml2_manufacturer_warranty yml2_expiry yml2_purchase_price yml2_description yml2_cpa buy_now_url units_in_product show_price_per_x_units
1517 30752120-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1518 30452120-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1519 30352120-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1520 3065212026-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1521 30652120-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1522 30852120-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1523 20752120-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1524 20452120-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1525 20352120-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1537 30752141-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1538 30452141-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1539 30352141-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1540 3065214126-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1541 30652141-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1542 30852141-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1543 20752141-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1544 20452141-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
1545 20352141-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762368326 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
2217 2065212026-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762373579 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
2218 20652120-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762373579 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
2219 20852120-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762373579 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
2735 20852141-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762374370 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
2863 2065214126-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762374370 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
2864 20652141-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762374370 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
3729 3065212026-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762380581 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
3732 3065214126-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762380581 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5220 30752120-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762383037 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5221 30452120-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762383037 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5222 30352120-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762383037 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5223 30652120-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762383037 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5224 30852120-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762383037 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5225 20752120-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762383037 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5226 20452120-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762384103 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5227 20352120-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762384103 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5237 30752141-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762384103 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5238 30452141-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762384103 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5239 30352141-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762384103 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5240 30652141-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762384103 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5241 30852141-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762384103 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5242 20752141-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762384103 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5243 20452141-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762384103 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5244 20352141-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762384103 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5817 2065212026-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762442002 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5818 20652120-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762442002 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
5819 20852120-001 P A 1 0.00 0 0.000 0 0 0 0.00 0 1762442002 1769614474 0 N N N N N N N Y 10 0 N N 0 1 0 N 0 0 Y 0.000 1.000
6322 20852141-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762466996 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
6448 2065214126-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762466996 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
6449 20652141-001 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762466996 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
7494 20652120-0011 V A 1 0.00 0 0.000 0 0 0 0.00 0 1769614594 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
7495 20652120-0021 V A 1 0.00 0 0.000 0 0 0 0.00 0 1769614594 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
7498 20652141-0011 V A 1 0.00 0 0.000 0 0 0 0.00 0 1769614594 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
7499 20652141-0021 V A 1 0.00 0 0.000 0 0 0 0.00 0 1769614594 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
7504 30652120-0011 V A 1 0.00 0 0.000 0 0 0 0.00 0 1769614594 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
7505 30652120-0021 V A 1 0.00 0 0.000 0 0 0 0.00 0 1769614594 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
7526 30652141-0011 V A 1 0.00 0 0.000 0 0 0 0.00 0 1769614594 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000
7527 30652141-0021 V A 1 0.00 0 0.000 0 0 0 0.00 0 1769614594 1769614474 0 N N N N N N N Y 10 0 N N 0 1 5819 N 0 0 Y 0.000 1.000