SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    62435, 61399, 60975, 59407, 60601, 62039, 
    62841, 64182, 63853, 60604, 64357, 
    63515
  )

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 (62435,61399,60975,59407,60601,62039,62841,64182,63853,60604,64357,63515)"
    }
  }
}

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
59407 BLE-POR-RET-RENO P E N M D A 0 A 1 196.00 1000 0.000 0 0 0 0.00 0 1264309200 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;} 1769455737 Price increased by $63 - DC 4/23/20 Price increased 5% from $170 to $178 - DC 5/27/21 Price increased 10% from $178 to $196 - DC 5/23/22 Y none none 999 BLE-POR-RET-RENO {"22394":1} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
60601 BLE-C-STU-WHU P E C P A A 0 A 1 282.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;} 1769624580 Price increased by $10 - DC 4/15/21 37% commercial discount to base price manually added - DC 4/15/21 Price increased by 5% from $234 to $246 - DC 5/27/21 Price increased 10% from $246 to $271 - DC 5/19/22 Price increased from $271 to $285 - DC 10/28/22 Price decreased from $285 to $282 - DM 9/28/23 Y none none 1140,1141,1142,2852 BLE-C-STU {"22057":1,"21927":2,"23084":4,"21932":5,"21934":6,"21935":6,"21933":6,"21968":7,"21969":7,"21939":7,"21938":7,"21937":7,"21936":7,"21941":8} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
60604 BLE-C-STU-WHB P E C P A A 0 A 1 315.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;} 1769458186 Price increased by $11 - DC 4/5/21 35% commercial discount to base price manually added - DC 4/9/21 Price increased by 5% from $245 to $257 - DC 5/26/21 Price increased 10% from $257 to $283 - DC 5/19/22 Price increased from $283 to $315 - DC 10/24/22 Commercial price increased to $240 - DM 9/12/23 Y none none 1143,1144,1145 BLE-C-STU {"22073":1,"21927":2,"23084":4,"21932":5,"21934":6,"21935":6,"21933":6,"21968":7,"21969":7,"21939":7,"21938":7,"21937":7,"21936":7,"21941":8} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
60975 BLE-WVS2-WHA E C M A A 0 A 1 523.00 1000 0.000 0 0 0 0.00 0 1223438400 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;} 1755706859 Price reduced by $135 - DC 3/25/20 Price increased 5% from $410 to $430 - DC 5/25/21 Price increased by $45 - DC 4/21/22 Price increased 10% from $475 to $523 - DC 5/31/22 Commercial Price increased to $405 - DM 9/12/23 Y none none 1040 BLE-WVS2 {"22996":1,"23010":3,"22040":4} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
61399 BLE-G-WHS24-LED P E C M W D 0 A 1 800.00 1000 0.000 0 0 0 0.00 0 1336017600 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;} 1767808500 Price decreased by $99 to align with standard Original™ LED listing - DC 10/20/20 Price increased by $20 to align with standard Original™ LED listing - DC 9/21/21 Price increased 10% from $683 to $752 - DC 5/24/22 Price increased by $100 to account for shipping increase - DC 9/9/22 Price decreased from $852 to $818 - DC 10/12/22 Price decreased from $818 to $800 - DC 11/9/22 Commercial price adjusted to be $83 increase from commercial base price on standard listing, with $33 upcharge to 28", per CJ - DC 8/28/24 Y none none 850,851 BLE-G {"21970":3,"22650":9,"22643":10,"22644":11,"22645":12} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
62039 BLE-G-2ASFC-G55 E C M W A 0 A 1 540.00 1000 0.000 0 0 0 0.00 0 1354856400 0 N N N D N R 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;} 1753982428 Price decreased by $201 - DC 4/27/21 Price increased 10% from $469 to $516 - DC 5/24/22 Price increased from $516 to $540 - DC 10/28/2022 Y none none 646,647,648 BLE-G {"22787":1,"22772":2,"22773":3,"22786":4,"22774":4,"22775":5,"22779":6,"22782":8,"22783":8,"22784":8,"22397":9} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
62435 BLE-CN-ULW-CN36 P E C M A A 0 A 1 440.00 1000 0.000 0 0 0 0.00 0 1402027200 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;} 1767900959 Base price increase of $26 - DC 4/2/21 37% commercial discount to base price manually added - DC 4/9/21 Price increased by 5% from $286 to $300- DC 5/26/21 Price increased 10% from $300 to $330 - DC 5/23/22 Price increased from $330 to $350 - DC 10/31/22 Price increased from $350 to $389 - DM 9/19/23 Price increased from $389 to $440 - DM 10/26/23 Y none none 978,979 BLE-CN {"22986":2,"22952":3,"21951":4,"21943":7,"21941":11,"22067":8,"23557":6,"22040":9,"23587":9} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
62841 BLE-C-SCP03 P E C M A A 0 A 1 340.00 1000 0.000 0 0 0 0.00 0 1413518400 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;} 1769541689 Price increased 5% from $424 to $445 - DC 5/28/21 Price increased by 10% from $445 to $490 - DC 5/24/22 Price decreased from $490 to $340 - DM 8/9/23 Y none none 1079 BLE-C {"23062":1,"21943":2,"22631":3} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
63515 BLE-L-WL003 P E C M A A 0 A 1 347.00 1000 0.000 0 0 0 0.00 0 1454302800 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;} 1761853988 Price increased 5% from $257 to $270 - DC 5/25/21 Price increased 10% from $270 to $297 - DC 5/24/22 Price increased from $297 to $311 - DC 8/10/22 Price increased from $311 to $320 - DC 10/28/2022 Commercial price increased to $230 - DC 9/12/23 Price decreased from $320 to $315 - DM 9/28/23 Price increased from $315 to $347 - DM 11/28/23 Y none none 622 BLE-L-WL003 {"22685":1,"22682":2,"21954":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
63853 BLE-C-PINDY4-VAN36 P E C M A A 0 A 1 465.00 1000 0.000 0 0 0 0.00 0 1470888000 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;} 1729182434 Price increased 5% from $335 to $352 - DC 5/28/21 Price increased 10% from $352 to $388 - DC 5/24/22 Price increased from $388 to $465 - DC 6/2/22 39% commercial discount to base price manually added - DC 6/2/22 Y none none 585 BLE-C-PINDY4-VAN36 {"22732":2,"21943":2,"23857":4} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64182 BLE-PMS-RWS E C M W A 0 A 1 448.00 1000 0.000 0 0 0 0.00 0 1489464000 0 N N N D N R 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;} 1732203195 Price increased 5% from $388 to $407 - DC 5/28/21 Price increased 10% from $407 to $448 - DC 6/1/22 Y none none 1854,1855,1856,2134 BLE {"21941":10} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
64357 BLE-G-BSL-LED P 0 A 1 480.00 1000 0.000 0 0 0 0.00 0 1514300936 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;} 1732202618 Price increased 5% from $363 to $381 - DC 6/1/21 Price increased 10% from $381 to $420 - DC 6/2/22 Price increased from $420 to $480 - DC 11/8/22 Y none none 2992,2993 BLE-G-BSL {"23462":0,"21970":1,"22579":4,"23493":3,"22580":5,"22581":6,"22582":7,"22583":8} 0 0 0 0 1 0 0 0 0 1 0.00 0