SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    64790, 64849, 64845, 64752, 64848, 64975, 
    64659, 65092, 65422, 64850, 65416, 
    64964
  )

Query time 0.00064

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 (64790,64849,64845,64752,64848,64975,64659,65092,65422,64850,65416,64964)"
    }
  }
}

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
64659 BLE-S-DBE P E C M W A 0 A 1 370.00 1000 0.000 0 0 0 0.00 0 1557418578 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;} 1739989209 Price increased 5% from $350 to $368 - DC 5/27/21 Price increased 10% from $368 to $405 - DC 5/20/22 Price decreased from $405 to $365 - DC 11/8/22 Price increased from $365 to $370 - DM 9/21/23 Y none none 551 BLE-S {"22670":4,"22669":3,"22673":6} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
64752 BLE-CN-WHE10 P E C P A A 0 A 1 330.00 1000 0.000 0 0 0 0.00 0 1563973604 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;} 1769542441 Price increased by $70 - DC 4/21/21 35% commercial discount to base price manually added - DC 4/21/21 Price increased by 5% from $242 to $254 - DC 5/26/21 Price increased 10% from $254 to $280 - DC 5/24/22 Price decreased from $280 to $275 - DC 11/1/22 Price increased from $275 to $330 - DM 9/26/23 Y none none 289,290,3263 BLE-CN-WHE10 {"21951":4,"21954":7,"22067":8,"21941":11,"21952":6,"21953":6,"21938":9,"21939":9,"21968":9,"21969":9} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64790 BLE-CN-AI P E C P A A 0 A 1 355.00 1000 0.000 0 0 0 0.00 0 1565963283 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;} 1769541433 Price increased by 5% from $281 to $295 - DC 5/26/21 Price increased from $295 to $305 - DC 6/3/21 Price increased 10% from $305 to $336 - DC 5/23/22 Price increased from $336 to $355 - DC 11/7/22 Y none none 417,418 BLE-CN {"21951":4,"21954":7,"22386":6,"22387":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
64845 BLE-C-CH012 P E C M D A 0 A 1 1402.00 1000 0.000 0 0 0 0.00 0 1567013890 0 N N N D N R Y 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 increased 5% from $1213 to $1274 - DC 5/28/21 Price increased 10% from $1274 to $1402 - DC 5/24/22 Y none none 478 BLE-C-CH012 {"21970":1,"22557":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64848 BLE-S-SL-FCC P E C P D A 0 A 1 296.00 1000 0.000 0 0 0 0.00 0 1567697305 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;} 1769543195 Price increased from $178 to $269 - DC 12/10/21 Price increased 10% from $269 to $296 - DC 5/23/22 Y none none 525 BLE-S-SL {"22287":1,"22611":2,"22612":3,"22613":4,"22614":5} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
64849 BLE-C-MLP3-MIG P E C M A A 0 A 1 525.00 1000 0.000 0 0 0 0.00 0 1567703504 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;} 1738599006 Price increased 5% from $454 to $477 - DC 5/28/21 Price increased 10% from $477 to $525 - DC 5/24/22 Y none none 467,2311 BLE-C-MLP3-MIG {"22628":1,"22630":3,"21943":4,"21941":7,"23858":4,"23859":4,"23860":4,"22631":6} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64850 BLE-C-CV24-MIG P E C M A A 0 A 1 469.00 1000 0.000 0 0 0 0.00 0 1567705929 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;} 1739811565 Price increased 5% from $406 to $426 - DC 5/28/21 Price increased 10% from $426 to $469 - DC 5/24/22 Y none none 467,2312 BLE-C-CV24-MIG {"22715":1,"21943":2,"22719":4,"22717":4,"21941":5,"23857":3,"23858":2,"23859":2,"23860":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64964 BLE-C-GLB P E C M D A 0 A 1 315.00 1000 0.000 0 0 0 0.00 0 1578326264 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;} 1769616774 Price increased by 5% from $230 to $241 - DC 5/27/21 Price increased by $44 - DC 3/18/22 Price increased 10% from $215 to $314 - DC 5/19/22 Price increased from $314 to $315 - DC 11/8/22 Y none none 1215 BLE-C {"23112":3,"21943":4,"23857":4,"23858":4,"23859":4,"23860":4} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64975 BLE-C-SOH-WLAF P E C M A A 0 A 1 509.00 1000 0.000 0 0 0 0.00 0 1579028339 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;} 1769025164 Price increased by 5% from $440 to $462 - DC 5/26/21 Price increased 10% from $462 to $509 - DC 5/19/22 Y none none 1256 BLE-C-SOH-WLAF {"22834":1,"21943":2,"22835":3,"23118":1,"23117":2,"23150":4,"23857":3} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
65092 BLE-C-BUK P E C M A A 0 A 1 260.00 1000 0.000 0 0 0 0.00 0 1582740677 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;} 1769621326 Price increased by 5% from $199 to $209 - DC 5/27/21 Price increased by $29 - DC 7/7/21 35% commercial discount to base price manually added - DC 7/7/21 Price increased 10% from $238 to $262 - DC 5/20/22 Price decreased from $262 to $260 - DC 11/8/22 Y none none 1732 BLE-C-BUK {"22033":4,"21941":7,"23553":4,"23857":3} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
65416 BLE-C-EGT P E C M A A 0 A 1 245.00 1000 0.000 0 0 0 0.00 0 1597415413 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;} 1769792461 Price increased by 5% from $200 to $210 - DC 5/27/21 Price increased by 10% from $210 to $231 - DC 5/20/22 Price decreased from $231 to $230 - DC 11/8/22 Price increased from $230 to $245 - DM 9/12/23 Y none none 2994 BLE-C {"22679":1,"22682":2,"22681":3,"23494":1,"21943":5,"21941":6,"23858":5,"23859":5,"23860":5} 0 0 0 0 0 0 0 0 0 1 0.00 0
65422 BLE-F-RWS P E C M W A 0 A 1 255.00 1000 0.000 0 0 0 0.00 0 1597845711 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;} 1732205629 Price increased by 10% from $231 to $255 - DC 5/24/22 Y none none 3013,3014,3015,3016 BLE-F 1008383 0 0 0 0 0 0 0 0 1 0.00 0