SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    61519, 64754, 64750, 61516, 62981, 60800, 
    64753, 64751, 64752, 65426
  )

Query time 0.00056

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": 10,
      "filtered": 100,
      "attached_condition": "cscart_products.product_id in (61519,64754,64750,61516,62981,60800,64753,64751,64752,65426)"
    }
  }
}

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
60800 BLE-C-STU-WHE10 P E C P A A 0 A 1 390.00 1000 0.000 0 0 0 0.00 0 1336449600 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;} 1769626105 Price increased by $11 - DC 4/21/21 35% commercial discount to base price manually added - DC 4/21/21 Price increased by 5% from $225 to $236 - DC 5/27/21 Price increased 10% from $236 to $260 - DC 5/20/22 Price increased from $260 to $265 - DC 11/1/22 Price increased from $265 to $390 - DM 9/26/23 Y none none 1149,1151,1255 BLE-C-STU-WHE10 {"21927":1,"21954":2,"21932":4,"22254":4,"21938":5,"21939":5,"21941":6} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
61516 BLE-C-WHEM P E C M A A 0 A 1 185.00 1000 0.000 0 0 0 0.00 0 1354856400 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;} 1769799876 Price increased by 5% from $97 to $102 - DC 5/27/21 Price increased by $79 - DC 7/9/21 37% commercial discount to base price manually added - DC 7/9/21 Price increased by 10% from $181 to $200 - DC 5/20/22 Price decreased from $200 to $185 - DC 11/3/22 Y none none BLE-C-WHEM {"21970":1,"21943":2,"22033":3,"21941":4,"23553":3,"23858":2,"23859":2,"23860":2,"23857":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
61519 BLE-W-WHEM P E C M A A 0 A 1 245.00 1000 0.000 0 0 0 0.00 0 1354856400 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;} 1753279242 Price increased 5% from $182 to $191 - DC 5/25/21 Price increased by $18 - DC 7/9/21 37% commercial discount to base price manually added - DC 7/9/21 Price increased 10% from $209 to $230 - DC 5/31/22 Price increased from $230 to $245 - DC 11/3/22 Y none none 1273,3366 BLE-W-WHEM {"21970":1,"22895":2,"21941":3,"22246":0} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
62981 BLE-C-WHE/KAO P E C M A A 0 A 1 338.00 1000 0.000 0 0 0 0.00 0 1422594000 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;} 1769616277 Price increased by $56 - DC 4/21/21 35% commercial discount to base price manually added - DC 4/21/21 Price increased by 5% from $228 to $239 - DC 5/27/21 Price decreased by $4 - DC 4/5/22 Price increased 10% from $235 to $259 - DC 5/20/22 Price decreased from $259 to $255 - DC 11/1/22 Price increased from $255 to $338 - DM 9/26/23 Y none none 935,1934 BLE-C {"22985":1,"21927":2,"22911":5,"21938":6,"21939":6,"23857":3} 0 0 0 0 0 0 0 0 0 1 0.00 0
64750 BLE-G-WHE P E C P W A 0 A 1 290.00 1000 0.000 0 0 0 0.00 0 1563894069 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;} 1769623358 Price increased by $44 - DC 4/21/21 35% commercial discount to base price manually added - DC 4/21/21 Price increased 5% from $219 to $230 - DC 5/24/21 Price increased 10% from $230 to $253 - DC 5/24/22 Price decreased from $253 to $245 - DC 11/1/22 Price increased from $245 to $290 - DM 9/26/23 Y none none 283,284,285 BLE-G {"22067":8,"22052":10,"21975":10,"21974":10,"21930":6,"21931":6,"22012":6,"21938":9,"21939":9,"21968":9,"21969":9} 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
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
64753 BLE-C-WHE P E C P A A 0 A 1 252.00 1000 0.000 0 0 0 0.00 0 1563981828 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;} 1769545146 Price increased by $77 - DC 4/21/21 35% commercial discount to base price manually added - DC 4/21/21 Price increased by 5% from $184 to $193 - DC 5/27/21 Price increased by 10% from $193 to $213 - DC 5/20/22 Price decreased from $213 to $210 - DC 11/1/22 Price increased from $210 to $252 - DM 9/26/23 Y none none 292,293,294 BLE-C {"21943":4,"21978":10,"21979":10,"21946":6,"21945":6,"22067":8,"21941":11,"23858":4,"23859":4,"23860":4,"21938":9,"21939":9,"21968":9,"21969":9} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64754 BLE-W-WHE P E C P W A 0 A 1 267.00 1000 0.000 0 0 0 0.00 0 1563986470 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;} 1769544361 Price increased by $65 - DC 4/21/21 35% commercial discount to base price manually added - DC 4/21/21 Price increased 5% from $193 to $203 - DC 5/25/21 Price increased 10% from $203 to $224 - DC 5/31/22 Price increased from $264 to $270 - DC 11/1/22 Price decreased from $270 to $267 - DM 9/26/23 Y none none 295,297,2627 BLE-W {"22240":1,"22024":4,"22025":4,"22021":4,"22020":4} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
65426 BLE-F-WHE P E C P W A 0 A 1 249.00 1000 0.000 0 0 0 0.00 0 1597864050 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 $208 to $229 - DC 5/24/22 Price decreased from $229 to $225 - DC 11/1/22 Price increased from $225 to $249 - DM 9/26/23 Y none none 3029,3030,3031,3032 BLE-F {"22254":8,"23427":6,"23428":6,"23435":9,"23436":9} 1056013 0 0 0 0 0 0 0 0 1 0.00 0