SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    514, 1505, 1506, 1507, 1508, 1509, 1510, 
    1511, 1512, 1513, 1514, 1515, 1516, 
    1526, 1527, 1528, 1529, 1530, 1531, 
    1532, 1533, 1534, 1535, 1536, 3675, 
    3727, 3728, 3730, 3731, 5210, 5211, 
    5212, 5213, 5214, 5215, 5216, 5217, 
    5218, 5219, 5228, 5229, 5230, 5231, 
    5232, 5233, 5234, 5235, 5236, 7496, 
    7497, 7500, 7501, 7506, 7507, 7528, 
    7529
  )

Query time 0.00074

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 (514,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,3675,3727,3728,3730,3731,5210,5211,5212,5213,5214,5215,5216,5217,5218,5219,5228,5229,5230,5231,5232,5233,5234,5235,5236,7496,7497,7500,7501,7506,7507,7528,7529))",
      "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
514 30452241-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762276541 1769614474 0 N N N N N N N Y 10 0 N N 0 1 1516 N 0 0 Y 0.000 1.000
1505 30752220-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 1516 N 0 0 Y 0.000 1.000
1506 30452220-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 1516 N 0 0 Y 0.000 1.000
1507 30352220-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 1516 N 0 0 Y 0.000 1.000
1508 3065222026-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 1516 N 0 0 Y 0.000 1.000
1509 30652220-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 1516 N 0 0 Y 0.000 1.000
1510 30852220-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 1516 N 0 0 Y 0.000 1.000
1511 20752220-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 1516 N 0 0 Y 0.000 1.000
1512 20452220-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 1516 N 0 0 Y 0.000 1.000
1513 20352220-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 1516 N 0 0 Y 0.000 1.000
1514 2065222026-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 1516 N 0 0 Y 0.000 1.000
1515 20652220-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 1516 N 0 0 Y 0.000 1.000
1516 20852220-001 P 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 0 N 0 0 Y 0.000 1.000
1526 30752241-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 1516 N 0 0 Y 0.000 1.000
1527 30352241-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 1516 N 0 0 Y 0.000 1.000
1528 3065224126-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 1516 N 0 0 Y 0.000 1.000
1529 30652241-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 1516 N 0 0 Y 0.000 1.000
1530 30852241-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 1516 N 0 0 Y 0.000 1.000
1531 20752241-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 1516 N 0 0 Y 0.000 1.000
1532 20452241-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 1516 N 0 0 Y 0.000 1.000
1533 20352241-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 1516 N 0 0 Y 0.000 1.000
1534 2065224126-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 1516 N 0 0 Y 0.000 1.000
1535 20652241-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 1516 N 0 0 Y 0.000 1.000
1536 20852241-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 1516 N 0 0 Y 0.000 1.000
3675 30452241-001 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 1516 N 0 0 Y 0.000 1.000
3727 3065222026-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 1516 N 0 0 Y 0.000 1.000
3728 2065222026-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 1516 N 0 0 Y 0.000 1.000
3730 3065224126-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 1516 N 0 0 Y 0.000 1.000
3731 2065224126-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 1516 N 0 0 Y 0.000 1.000
5210 30752220-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762382561 1769614474 0 N N N N N N N Y 10 0 N N 0 1 1516 N 0 0 Y 0.000 1.000
5211 30452220-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762382561 1769614474 0 N N N N N N N Y 10 0 N N 0 1 1516 N 0 0 Y 0.000 1.000
5212 30352220-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762382561 1769614474 0 N N N N N N N Y 10 0 N N 0 1 1516 N 0 0 Y 0.000 1.000
5213 30652220-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762382561 1769614474 0 N N N N N N N Y 10 0 N N 0 1 1516 N 0 0 Y 0.000 1.000
5214 30852220-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762382561 1769614474 0 N N N N N N N Y 10 0 N N 0 1 1516 N 0 0 Y 0.000 1.000
5215 20752220-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762382561 1769614474 0 N N N N N N N Y 10 0 N N 0 1 1516 N 0 0 Y 0.000 1.000
5216 20452220-002 V A 1 0.00 0 0.000 0 0 0 0.00 0 1762382561 1769614474 0 N N N N N N N Y 10 0 N N 0 1 1516 N 0 0 Y 0.000 1.000
5217 20352220-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 1516 N 0 0 Y 0.000 1.000
5218 20652220-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 1516 N 0 0 Y 0.000 1.000
5219 20852220-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 1516 N 0 0 Y 0.000 1.000
5228 30752241-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 1516 N 0 0 Y 0.000 1.000
5229 30352241-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 1516 N 0 0 Y 0.000 1.000
5230 30652241-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 1516 N 0 0 Y 0.000 1.000
5231 30852241-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 1516 N 0 0 Y 0.000 1.000
5232 20752241-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 1516 N 0 0 Y 0.000 1.000
5233 20452241-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 1516 N 0 0 Y 0.000 1.000
5234 20352241-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 1516 N 0 0 Y 0.000 1.000
5235 20652241-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 1516 N 0 0 Y 0.000 1.000
5236 20852241-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 1516 N 0 0 Y 0.000 1.000
7496 20652220-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 1516 N 0 0 Y 0.000 1.000
7497 20652220-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 1516 N 0 0 Y 0.000 1.000
7500 20652241-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 1516 N 0 0 Y 0.000 1.000
7501 20652241-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 1516 N 0 0 Y 0.000 1.000
7506 30652220-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 1516 N 0 0 Y 0.000 1.000
7507 30652220-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 1516 N 0 0 Y 0.000 1.000
7528 30652241-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 1516 N 0 0 Y 0.000 1.000
7529 30652241-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 1516 N 0 0 Y 0.000 1.000