SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    62986, 61699, 63855, 63334, 64854, 60602, 
    64366, 64369, 61620, 63384, 64908, 
    62447
  )

Query time 0.00087

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 (62986,61699,63855,63334,64854,60602,64366,64369,61620,63384,64908,62447)"
    }
  }
}

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
60602 BLE-C-STU-WHS P E C P A A 0 A 1 275.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;} 1774379167 Price increased by 5% from $227 to $238 - DC 5/27/21 Price increased 10% from $238 to $262 - DC 5/20/22 Price increased from $262 to $275 - DC 10/12/22 Y none none 1137,1138,1139,2844 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} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
61620 BLE-W-SCH10-24VAN P E C M A A 0 A 1 849.00 1000 0.000 0 0 0 0.00 0 1365998400 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;} 1753110168 Price increased 5% from $734 to $771 - DC 5/24/21 Price increased 10% from $771 to $849 - DC 5/31/22 Y none none 682,683,684,689 BLE-W {"22821":1,"22818":2,"22796":3,"22794":3,"22798":4,"22397":5} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
61699 BLE-G-BIS P E C M W A 0 A 1 295.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;} 1732205373 Price increased by $128 - DC 4/1/22 Commercial discount of 38% added - 4/1/22 Price increased 10% from $264 to $291 - DC 5/24/22 Price decreased from $291 to $295 - DC 10/28/2022 Y none none 523,3252 BLE-G-BIS {"22615":3,"22035":4,"22345":5,"21941":6,"23537":5} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
62447 BLE-S-ST3-WHB17 P E C P W A 0 A 1 660.00 1000 0.000 0 0 0 0.00 0 1402891200 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;} 1780004650 Price decreased by $216 - DC 4/5/21 35% commercial discount to base price manually added - DC 4/9/21 Price increased 5% from $639 to $671 - DC 5/28/21 Price increased 10% from $671 to $739 - DC 5/24/22 Price decreased from $739 to $660 - DC 10/28/2022 Commercial price increased to $510 - DM 9/12/23 Y none none 634,635,636 BLE-S-ST3-WHB17 {"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} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
62986 BLE-C-SCH-KAO P E C M A A 0 A 1 340.00 1000 0.000 0 0 0 0.00 0 1422594000 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;} 1769616093 Price increased by 5% from $242 to $254 - DC 5/27/21 Price increased by $13 - DC 4/5/22 Price increased 10% from $267 to $294 - DC 5/19/22 Price increased from $294 to $295 - DC 11/3/22 Price increased from $295 to $340 - DC 2/24/23 Y none none 665,666,667,668 BLE-C {"22816":1,"22805":2,"22815":5,"22797":6,"22796":6,"22794":6,"22795":6,"22798":7,"21941":9,"23858":3,"23859":3,"23860":3,"23857":4} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
63334 BLE-S-ST2-WHU16 P E C P W A 0 A 1 542.00 1000 0.000 0 0 0 0.00 0 1438660800 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 Price decreased by $68 - DC 4/15/21 37% commercial discount to base price manually added - DC 4/15/21 Price increased 10% from $520 to $572 - DC 5/20/22 Price decreased from $572 to $480 - DC 10/28/22 Commercial price increased to $290 - DM 9/12/23 Price increased from $480 to $542 - DM 9/28/23 Y none none 611,612,613 BLE-S-ST2-WHU16 {"22733":1,"22734":2,"22735":3,"22810":4,"22736":4,"22737":4,"22807":5,"22808":5,"22809":5,"22738":6,"22741":7,"22740":7,"22739":7,"22745":8,"22397":9,"23580":6} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
63384 BLE-W-DBG P E C M D A 0 A 1 285.00 1000 0.000 0 0 0 0.00 0 1445486400 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;} 1769543380 Price increased 5% from $141 to $148- DC 5/25/21 Price increased by $86 - DC 7/7/21 38% commercial discount to base price manually added - DC 7/7/21 Price increased 10% from $234 to $258 - DC 5/31/22 Price increased from $258 to $280 - DC 11/3/22 Price increased from $280 to $285 - DM 9/28/23 Y none none 1746,1747 BLE-W {"22955":1,"22037":3,"22939":4,"23419":3} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
63855 BLE-C-PINDY6-VAN36 P E C M A A 0 A 1 618.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;} 1779997847 Price increased 5% from $424 to $445 - DC 5/28/21 Price increased 10% from $445 to $490 - DC 5/24/22 Price increased from $490 to $618 - DC 6/2/22 39% commercial discount to base price manually added - DC 6/2/22 Y none none 583 BLE-C-PINDY6-VAN36 {"22732":2,"21943":2,"23857":4} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64366 BLE-S-CYLM P E C M A A 0 A 1 225.00 1000 0.000 0 0 0 0.00 0 1516122335 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;} 1732217662 Price increased 5% from $190 to $199 - DC 5/27/21 Price increased 10% from $199 to $219 - DC 5/23/22 Price increased from $219 to $225 - DC 11/1/22 Y none none 719,720 BLE-S-CYLM {"21970":3,"22853":5,"21973":6,"22224":9,"22903":8,"21941":10,"23551":6} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64369 BLE-CN-CYLV P E C M A A 0 A 1 265.00 1000 0.000 0 0 0 0.00 0 1516124120 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;} 1747925754 Price increased by 5% from $208 to $218 - DC 5/26/21 Price increased by 10% from $218 to $240 - DC 5/24/22 Price increased from $240 to $265 - DC 11/1/22 Y none none 714,715 BLE-CN-CYLV {"21970":3,"21951":5,"22588":6,"21954":7,"22903":8,"21941":10} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64854 BLE-L-WL001 P E C M D A 0 A 1 260.00 1000 0.000 0 0 0 0.00 0 1567794780 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;} 1769545094 Price increased by $35 - DC 4/27/20 Price increased 5% from $195 to $205 - DC 5/25/21 Price increased by $31 - DC 7/9/21 38% commercial discount to base price manually added - DC 7/9/21 Price increased 10% from $236 to $260 - DC 5/26/22 Y none none 543,544,892 BLE-L-WL001 {"22655":1,"22656":2,"22571":3,"22572":4} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64908 BLE-FSF-DRM P E C M A A 0 A 1 355.00 1000 0.000 0 0 0 0.00 0 1571852723 0 N N N D N P N N N Y 10 1355979600 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;} 1760030087 Price increased by 5% from $246 to $258 - DC 5/27/21 Price increased by 10% from $258 to $284 - DC 5/24/22 Price increased from $284 to $300 - DC 11/3/22 Price increased from $300 to $355 - DM 9/6/23 Y none none 657,658,659,660,3306 BLE-FSF {"22806":3,"21941":12,"22931":9,"22932":9,"22798":10} 1056013 0 0 0 0 0 0 0 0 1 0.00 0