SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    65424, 65650, 65681, 60738, 65793, 62671, 
    64340, 61386, 65672, 65425, 65300, 
    65534
  )

Query time 0.00078

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 (65424,65650,65681,60738,65793,62671,64340,61386,65672,65425,65300,65534)"
    }
  }
}

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
60738 BLE-G10 P E N M N A 0 A 1 181.00 1000 0.000 0 0 0 0.00 0 1343880000 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;} 1769546237 Price increased 5% from $156 to $164 - DC 6/3/21 Price increased 10% from $164 to $181 - DC 6/1/22 Y none none BLE-G10 {"21928":1} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
61386 BLE-G35 P E N M N A 0 A 1 126.00 1000 0.000 0 0 0 0.00 0 1343880000 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;} 1696430691 Price increased 5% from $109 to $114 - DC 6/3/21 Price increased 10% from $114 to $126 - DC 6/1/22 Y none none BLE-G35 {"21928":1} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
62671 BLE-LDBPC P E C S W A 0 A 1 44.00 1000 0.000 0 0 0 0.00 0 1358744400 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;} 1654109962 Price increased 10% from $40 to $44 - DC 6/1/22 Y none none BLE-LDBPC {"22901":1} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64340 BLE-G65 P E N M N A 0 A 1 350.00 1000 0.000 0 0 0 0.00 0 1509638205 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;} 1769541579 Price increased 5% from $303 to $318 - DC 6/3/21 Price increased 10% from $318 to $350 - DC 6/1/22 Y none none BLE-G65 {"21928":1,"23414":1} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
65300 BLE-F-FCC P E C P W A 0 A 1 220.00 1000 0.000 0 0 0 0.00 0 1592404926 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;} 1732205889 Price increased by 10% from $224 to $247 - DC 5/24/22 Price decreased from $247 to $220 - DC 11/1/22 Commercial price increased to $185 - DM 9/12/23 Y none none 2787,2788,2789,2790 BLE-F {"22272":7,"22273":7,"22271":7,"22275":7,"22274":7,"21941":8} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
65424 BLE-F-WHB P E C P W A 0 A 1 275.00 1000 0.000 0 0 0 0.00 0 1597857301 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 $215 to $237 - DC 5/24/22 Price increased from $237 to $275 - DC 10/24/22 Commercial price increased to $190 - DM 9/12/23 Y none none 3021,3022,3023,3024 BLE-F 1056013 0 0 0 0 0 0 0 0 1 0.00 0
65425 BLE-F-YDM P E C P W A 0 A 1 225.00 1000 0.000 0 0 0 0.00 0 1597859004 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;} 1732205889 Price increased by 10% from $215 to $237 - DC 5/24/22 Price decreased from $237 to $225 - DC 10/31/22 Y none none 3025,3026,3027,3028 BLE-F 1056013 0 0 0 0 0 0 0 0 1 0.00 0
65534 BLE-C-ACN-KAO P E C M A A 0 A 1 335.00 1000 0.000 0 0 0 0.00 0 1619187388 0 N N N D N P N N N Y 10 1422594000 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;} 1769616365 Price increased by 5% from $249 to $261 - DC 5/26/21 Price increased 10% from $261 to $288 - DC 5/19/22 Price increased from $288 to $335 - DC 11/3/22 Y none none 3397,3398,3399,3400 BLE-C {"22816":1,"22805":2,"22815":5,"22797":5,"22796":5,"22794":5,"22795":5,"22798":7,"21941":9,"23591":1,"22927":6,"22928":6,"23857":4} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
65650 BLE-CC-HSP-AMB P E C M D A 0 A 1 314.00 1 0.000 0 0 0 0.00 0 1661261311 0 N N N B 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;} 1769779542 Price increased by $86 - DC 5/18/20 Price increased by 5% from $220 to $231 - DC 5/27/21 Price increased by $21 - DC 7/7/21 38% commercial discount to base price manually added - DC 7/7/21 Price increased 10% from $252 to $278 - DC 5/19/22 Listing separated, $36.00 amber glass upcharge added - DC 8/23/22 Y none none 3561 BLE-CC-HSP-AMB {"22972":1,"21943":2,"22973":3,"22991":4,"22992":5} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
65672 BLE-S-ASFC P E C M W A 0 A 1 314.00 1000 0.000 0 0 0 0.00 0 1664904122 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;} 1777912115 Price increased from $290 to $314 - DM 9/28/23 Y none none 3600,3601 BLE-S {"21936":9,"21937":9,"21938":9,"21939":9,"21935":8,"21934":8,"21933":8} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
65681 BLE-C-STU-WHS24 P E C P A A 0 A 1 660.00 1000 0.000 0 0 0 0.00 0 1667409485 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;} 1769627566 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 3620,3621,3624 BLE-C-STU {"23086":1,"21927":2,"23084":4,"21932":5,"21934":6,"21935":6,"21933":6,"21969":7,"21968":7,"21939":7,"21938":7,"21937":7,"21936":7,"21941":8,"21926":1,"22029":6,"22030":6,"22031":6,"22034":7,"22028":5,"22032":1} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
65793 BLE-S-ST2-DBL12 P E C P W A 0 A 1 1049.00 1000 0.000 0 0 0 0.00 0 1696425160 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;} 1779997847 Y none none 3752,3753,3754 BLE-S-ST2 {"22733":1,"22734":4,"22735":5,"22810":6,"22736":6,"22737":6,"22807":7,"22808":7,"22809":7,"22738":6,"22741":7,"22740":7,"22739":7,"22397":8,"23580":6,"23837":1,"22525":2,"22960":3,"22961":3,"23533":3,"22938":4,"24037":6} 1051256 0 0 0 0 0 0 0 0 1 0.00 0