SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    61694, 61466, 58117, 60120, 62060, 62230, 
    64351, 59417, 64350, 61528, 61081, 
    61468
  )

Query time 0.00063

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 (61694,61466,58117,60120,62060,62230,64351,59417,64350,61528,61081,61468)"
    }
  }
}

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
58117 BLE-S-CGG2H E U M W A 0 A 1 422.00 1000 0.000 0 0 0 0.00 0 1240977600 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;} 1776883176 Price increased by $59 - DC 4/22/20 Price increased 5% from $381 to $400 - DC 5/27/21 Price decreased by $17 - DC 6/16/21 Price increased 10% from $383 to $422 - DC 5/20/22 Y none none BLE-S-CGG2H {"21970":1,"23015":2,"23021":3,"23022":3,"23023":3,"22397":6,"23603":5,"24042":4} 1008383 0 0 0 0 0 0 0 0 1 65.97 20
59417 BLE-POR-RET-BASIC P E N M D A 0 A 1 180.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;} 1704813132 Price increased by $61 - DC 4/23/20 Price increased 5% from $155 to $163 - DC 5/27/21 Price increased 10% from $163 to $180 - DC 5/23/22 Y none none 1000 BLE-POR-RET-BASIC {"22394":1} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
60120 BLE-S-ST3-WHS16 P E C P W A 0 A 1 620.00 1000 0.000 0 0 0 0.00 0 1274414400 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 increased 5% from $795 to $835 - DC 5/28/21 Price increased by 10% from $835 to $919 - DC 5/20/22 Price decreased from $919 to $620 - DC 10/28/2022 Y none none 628,629,630 BLE-S-ST3-WHS16 {"22759":1,"22734":2,"22760":3,"22811":4,"22761":4,"22762":4,"22812":5,"22813":5,"22814":5,"22763":6,"22766":7,"22765":7,"22764":7,"22396":9,"23583":6} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
61081 BLE-W-SOH-CAN P E C M W A 0 A 1 375.00 1000 0.000 0 0 0 0.00 0 1352178000 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;} 1732203933 Price decreased by $60 - DC 4/1/20 Price decreased by $38 - DC 5/19/21 38% commercial discount to base price manually added - DC 5/19/21 Price increased 5% from $302 to $317 - DC 5/25/21 Price increased 10% from $317 to $349 - DC 5/24/22 Price increased from $349 to $375 - DC 11/8/22 Y none none 191 BLE-W-SOH-CAN {"21970":1,"22952":1,"22037":2,"21973":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
61466 BLE-S-CGG-CH009 P E C M W A 0 A 1 990.00 1000 0.000 0 0 0 0.00 0 1359954000 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 increased 5% from $952 to $1000 - DC 5/28/21 Price decreased by $101 - DC 6/16/21 Price increased 10% from $899 to $989 - DC 5/24/22 Price increased from $989 to $990 - DC 11/8/22 Y none none 1111,1112 BLE-S-CGG-CH009 {"22394":2,"23015":4,"23016":5,"23032":6,"23031":6,"23030":6,"23075":7,"24039":5,"24041":5} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
61468 BLE-S-CGG-CH010 P E C M A A 0 A 1 1015.00 1000 0.000 0 0 0 0.00 0 1359954000 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 increased 5% from $880 to $924 - DC 5/28/21 Price decreased by $5 - DC 6/16/21 Price increased from $1011 to $1015 - DC 11/8/22 Y none none 1879,1880 BLE-S-CGG-CH010 {"23052":1,"22394":2,"23015":4,"23016":5,"23027":6,"23028":6,"23029":6,"22395":7,"22746":2,"24038":5,"24040":5} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
61528 BLE-PMS-TGG-WHU P E C M W A 0 A 1 385.00 1000 0.000 0 0 0 0.00 0 1364529600 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;} 1732203933 Price increased 5% from $333 to $350 - DC 5/28/21 Price increased 10% from $350 to $385 - DC 6/1/22 Y none none 1197,1198 BLE-PMS-TGG {"23098":1,"23078":3,"23079":4,"23080":5,"21941":6,"22066":1,"23602":1} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
61694 BLE-S-HIB P E C M W A 0 A 1 275.00 1000 0.000 0 0 0 0.00 0 1366603200 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;} 1732205629 Price increased by $9 - DC 5/19/21 38% commercial discount to base price manually added - DC 5/19/21 Price increased 5% from $223 to $234 - DC 5/27/21 Price increased 10% from $234 to $258 - DC 5/23/22 Price increased from $258 to $275 - DC 11/1/22 Y none none 537,3314 BLE-S-HIB {"21947":3,"22037":4,"22224":5,"21941":6,"23551":4} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
62060 BLE-C-VSBA P E C M A A 0 A 1 290.00 1000 0.000 0 0 0 0.00 0 1386046800 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;} 1747245023 Price increased by $43 - DC 5/14/21 36% commercial discount to base price manually added - DC 5/14/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 decreased from $260 to $255 - DC 10/28/2022 Price increased from $255 to $290 - DM 9/28/23 Y none none 831,832,833,2814 BLE-C {"22117":3,"21943":5,"22608":11,"22607":11,"22609":7,"22911":9,"22912":10,"21941":12,"23857":6,"23858":5,"23859":5,"23860":5} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
62230 BLE-S-CH013 P E C M A A 0 A 1 457.00 1000 0.000 0 0 0 0.00 0 1395028800 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;} 1732285982 Price increased 5% from $395 to $415 - DC 5/28/21 Price increased 10% from $415 to $457 - DC 5/24/22 Y none none BLE-S-CH013 {"22952":1,"22310":2,"21973":3} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
64350 BLE-S-PINDY P E C M D A 0 A 1 310.00 1000 0.000 0 0 0 0.00 0 1511967875 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;} 1737393886 Price increased 5% from $148 to $155 - DC 5/27/21 Price increased 10% from $155 to $171 - DC 5/23/22 Price increased from $171 to $225 - DC 10/28/2022 Commercial price increased to $190 - DM 9/12/23 Price increased from $225 to $266 - DM 9/28/23 Price increased from $266 to $310 - DM 11/27/23 Y none none 620 BLE-S-PINDY {"22683":1,"22684":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64351 BLE-S-CH028 P E C M D A 0 A 1 1400.00 1000 0.000 0 0 0 0.00 0 1511969068 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 reduced from $1452 to $949 per SG - DC 11/11/19 Price increased 5% from $949 to $997 - DC 5/28/21 Price increased 10% from $997 to $1097 - DC 5/24/22 Price increased by $203 to account for shipping - DC 11/17/22 Y none none 742 BLE-S-CH028 {"22879":1,"21970":2} 1008383 0 0 0 0 0 0 0 0 1 0.00 0