SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    65095, 64759, 64874, 62669, 29989, 64788, 
    64791, 64946, 62666, 64785, 64847, 
    64751
  )

Query time 0.00082

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_products",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 12,
      "filtered": 100,
      "attached_condition": "cscart_products.product_id in (65095,64759,64874,62669,29989,64788,64791,64946,62666,64785,64847,64751)"
    }
  }
}

Result

product_id product_code product_type trustmark_origin trustmark_certified trustmark_leadtime trustmark_location trustmark_return owner_id status company_id list_price amount weight length width height shipping_freight low_avail_limit 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 updated_timestamp pricing_note use_new_layout category_image tax_code upc_code product_detail_ids nav_sku sku_columns nav_review_user_id hide_price vendor_fulfilled hide_commercial_price non_returnable ble_basics commercial_hidden allow_configurator enable_customize enable_buy_american base_cost redline_p
29989 BLE-SC E N M N A 0 A 1 43.00 1000 0.000 0 0 0 0.00 0 1224561600 0 N N N D N P N N N Y 30 0 N 0 0 0 0 13 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;} 1654110069 Price increased 10% from $27 to $43 - DC 6/1/22 Y none none BLE-SC {"21970":1} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
62666 BLE-S-CH016 P E C M A A 0 A 1 1011.00 1000 0.000 0 0 0 0.00 0 1409716800 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1779997847 Price decreased by $23 - DC 4/14/21 40% commercial discount to base price manually added - DC 4/14/21 Price increased 5% from $875 to $919 - DC 5/28/21 Price increased 10% from $919 to $1011 - DC 5/24/22 Y none none 394,2706 BLE-S-CH016 {"22952":1,"23120":2,"22224":3,"21941":5} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
62669 BLE-S-CH018 P E C M W A 0 A 1 460.00 1000 0.000 0 0 0 0.00 0 1409716800 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1732215332 Price decreased by $79 - DC 4/14/21 40% commercial discount to base price manually added - DC 4/14/21 Price increased 5% from $638 to $670 - DC 5/28/21 Price increased 10% from $670 to $737 - DC 5/20/22 Price decreased from $737 to $460 - DC 10/31/22 Commercial price increased to $400 - DM 9/12/23 Y none none 388,2564 BLE-S-CH018 {"22952":1,"23120":2,"22037":4,"22224":3,"22938":2,"22397":5} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64751 BLE-S-WHE P E C P W A 0 A 1 265.00 1000 0.000 0 0 0 0.00 0 1563902814 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1769544626 Price increased by $31 - DC 4/21/21 35% commercial discount to base price manually added - DC 4/21/21 Price increased 5% from $192 to $202 - DC 5/27/21 Price increased 10% from $202 to $223 - DC 5/23/22 Price increased from $223 to $235 - DC 11/1/22 Price increased from $235 to $265 - DM 9/26/23 Y none none 286,287,288 BLE-S {"22017":10,"22016":10,"21950":10,"22067":8,"21977":10,"21976":10,"21941":11,"21948":6,"21949":6,"22008":6,"21938":9,"21939":9,"21969":9,"21968":9} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64759 BLE-C-FCC P E C M A A 0 A 1 205.00 1000 0.000 0 0 0 0.00 0 1564431124 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1769799475 Price increased by 5% from $120 to $126 - DC 5/27/21 Price increased from $126 to $208 - DC 12/10/21 Price increased by 10% from $208 to $229 - DC 5/20/22 Price decreased from $229 to $205 - DC 11/1/22 Y none none 307,308,309 BLE-C {"21943":4,"22277":7,"22163":7,"21941":8,"23857":4,"23858":4,"23859":4,"23860":4} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
64785 BLE-S-CI P E C P W A 0 A 1 315.00 1000 0.000 0 0 0 0.00 0 1565872332 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1769542795 Price increased by $10 - DC 5/12/21 38% commercial discount to base price manually added - DC 5/12/21 Price increased 5% from $252 to $265 - DC 5/27/21 Price increased 10% from $265 to $292 - DC 5/23/22 Price increased from $292 to $315 - DC 11/4/22 Y none none 395,396 BLE-S {"22352":8,"22350":6,"22351":6,"22365":9,"22355":10,"22356":10,"22357":11,"22358":11,"22359":11,"22360":11,"21941":12} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64788 BLE-G-AI P E C P W A 0 A 1 340.00 1000 0.000 0 0 0 0.00 0 1565888207 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1769626985 Price increased 5% from $288 to $302 - DC 5/24/21 Price decreased from $302 to $299 - DC 6/3/21 Price increased 10% from $299 to $329 - DC 5/24/22 Price increased from $329 to $340 - DC 11/7/22 Y none none 403,404 BLE-G {"22348":6,"22349":6,"22353":8,"22365":9,"22355":10,"22356":10,"22357":11,"22358":11,"22359":11,"22360":11,"21941":12} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64791 BLE-C-AI P E C P A A 0 A 1 290.00 1000 0.000 0 0 0 0.00 0 1565965645 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1753285355 Price increased by 5% from $220 to $231 - DC 5/27/21 Price increased from $231 to $268 - DC 6/3/21 Price increased 10% from $268 to $295 - DC 5/19/22 Price decreased from $295 to $290 - DC 11/7/22 Y none none 419,2066 BLE-C {"21943":4,"22388":6,"22389":6,"22365":9,"22355":10,"22356":10,"22357":11,"22358":11,"22359":11,"22360":11,"21941":12,"23860":4,"23859":4,"23858":4} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64847 BLE-S-SL-SBS P E C P D A 0 A 1 359.00 1000 0.000 0 0 0 0.00 0 1567691396 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1769626904 Price increased by $66 - DC 5/10/21 35% commercial discount to base price manually added - DC 5/10/21 Price increased from $244 to $270 - DC 12/10/21 Price increased 10% from $270 to $297 - DC 5/23/22 Price increased from $297 to $359 - DM 9/27/23 Y none none 524 BLE-S-SL {"22305":1,"22611":2,"22612":3,"22613":4,"22614":5} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64874 BLE-C-RND P E C M A A 0 A 1 374.00 1000 0.000 0 0 0 0.00 0 1571761954 0 N N N D N P N N N Y 10 1355979600 N 0 0 0 0 13 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;} 1769028791 Price increased by 5% from $242 to $254 - DC 5/27/21 Price increased 10% from $254 to $280 - DC 5/19/22 Price increased from $280 to $374 - DM 9/26/23 Y none none 661,662,663,664,3269 BLE-C {"22806":3,"21943":4,"22641":11,"22640":11,"21941":12,"22923":9,"22924":9,"22798":10,"23858":4,"23859":4,"23860":4,"23857":5} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
64946 BLE-W-WDME P E C M A A 0 A 1 284.00 1000 0.000 0 0 0 0.00 0 1575309971 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1761854030 Price increased 5% from $246 to $258 - DC 5/25/21 Price increased 10% from $258 to $284 - DC 5/26/22 Y none none 1008 BLE-W-WDME {"22834":1,"22838":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
65095 BLE-CCS-FCC P E C M D A 0 A 1 242.00 1000 0.000 0 0 0 0.00 0 1582915388 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1769797422 Price increased by 5% from $153 to $161 - DC 5/27/21 Price increased from $161 to $220 - DC 12/10/21 Price increased by 10% from $220 to $242 - DC 5/20/22 Y none none 1736,1737 BLE-CCS {"22287":1,"22703":6,"22991":4,"22992":5,"23000":2,"23001":6,"23002":6,"21927":2,"21945":6,"21946":6,"23857":3} 1056013 0 0 0 0 0 0 0 0 1 0.00 0