SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    64682, 62040, 64363, 64356, 62038, 64772, 
    64362, 62039, 64357, 64773, 64774
  )

Query time 0.00074

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": 11,
      "filtered": 100,
      "attached_condition": "cscart_products.product_id in (64682,62040,64363,64356,62038,64772,64362,62039,64357,64773,64774)"
    }
  }
}

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
62038 BLE-G-2ASE-G55 E C M W A 0 A 1 585.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;} 1753982340 Price decreased by $158 - DC 5/7/21 37% commercial discount to base price manually added - DC 5/7/21 Price decreased from $512 to $482 - DC 12/13/21 Price increased 10% from $482 to $531 - DC 5/24/22 Price increased from $531 to $585 - DM 9/28/23 Y none none 643,644,645 BLE-G {"22785":1,"22772":2,"22773":3,"22786":4,"22774":4,"22776":5,"22779":6,"22784":8,"22782":8,"22783":8,"22397":9} 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
62040 BLE-G-2WHS-G55 E C M W A 0 A 1 458.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;} 1767729163 Price decreased by $254 - DC 4/14/20 Price increased 10% from $416 to $458 - DC 5/24/22 Y none none 640,641,642 BLE-G {"22771":1,"22772":2,"22773":3,"22786":4,"22774":4,"22778":5,"22779":6,"22784":8,"22782":8,"22783":8,"22397":9,"23607":6,"22040":7,"23587":7} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
64356 BLE-G-BDSL-LED P 0 A 1 699.00 1000 0.000 0 0 0 0.00 0 1514298586 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;} 1777319946 Price increased 5% from $605 to $635 - DC 6/1/21 Price increased 10% from $635 to $699 - DC 6/2/22 Y none none 2984,2985 BLE-G-BDSL {"23461":0,"21970":1} 0 0 0 0 1 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
64362 BLE-S-BSL-LED P 0 A 1 470.00 1000 0.000 0 0 0 0.00 0 1515686956 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;} 1732202909 Price increased 5% from $383 to $402 - DC 6/2/21 Price increased 10% from $402 to $443 - DC 6/2/22 Price increased from $443 to $470 - DC 11/8/22 Y none none 2990,2991 BLE-S-BSL {"23463":0,"23464":0,"21970":1,"22938":2,"22579":4,"22580":5,"22581":6,"22582":7,"22583":8} 0 0 0 0 1 0 0 0 0 1 0.00 0
64363 BLE-F-BSL-LED P 0 A 1 460.00 1000 0.000 0 0 0 0.00 0 1515688471 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;} 1732202910 Price increased 5% from $390 to $409 - DC 6/1/21 Price increased 10% from $409 to $450 - DC 6/2/22 Price increased from $450 to $460 - DC 11/8/22 Y none none 2988,2989 BLE-F-BSL {"23469":0,"21970":1,"22579":2,"22580":3,"22581":4,"22582":5,"22583":6} 0 0 0 0 1 0 0 0 0 1 0.00 0
64682 BLE-G-WHS P E C M W A 0 A 1 255.00 1000 0.000 0 0 0 0.00 0 1559753775 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;} 1775761994 Price updated from $106 to $174 to include G3 gooseneck arm in base price - DC 6/6/19 24" shade decreased by $73 - DC 6/15/20 28" shade decreased by $162 - DC 6/15/20 Price increased 5% from $174 to $183 - DC 5/24/21 Price increased 10% from $183 to $202 - DC 5/24/22 Price increased from $202 to $255 - DC 10/12/22 Y none none 3,4,5 BLE-G {"21930":6,"21931":6,"22012":6,"21932":8,"21935":10,"21934":10,"21933":10,"21936":9,"21937":9,"21938":9,"21969":9,"21939":9,"21968":9,"21974":11,"21975":11,"22052":11,"21941":12} 1051256 0 0 0 0 0 0 1 0 1 45.96 20
64772 BLE-G-ASFC E C M W A 0 A 1 316.00 1000 0.000 0 0 0 0.00 0 1565198483 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;} 1777912054 Price increased by $111 - DC 5/18/20 Price increased by $5 - DC 4/27/21 Price increased 10% from $265 to $292 - DC 5/24/22 Price increased from $292 to $300 - DC 10/28/2022 Price increased from $300 to $316 - DM 9/28/23 Y none none 344,345,346 BLE-G {"22330":1,"21927":2,"22332":3,"22012":4,"21931":4,"21930":4,"22039":6,"21935":7,"21934":7,"21933":7,"22052":9,"21975":9,"21974":9,"21941":10} 1051256 0 0 0 0 0 0 0 0 1 44.97 20
64773 BLE-G-ASE E C M W A 0 A 1 318.00 1000 0.000 0 0 0 0.00 0 1565209445 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;} 1769542725 Price increased by $60 - DC 5/7/21 37% commercial discount to base price manually added - DC 5/7/21 Price increased 5% from $238 to $250 - DC 5/24/21 Price increased by $6 to account for G16/G17 base gooseneck price - DC 12/10/21 Price increased 10% from $256 to $282 - DC 5/24/22 Price decreased from $282 to $280 - DC 11/1/22 Price increased from $280 to $320 - DC 7/10/23 Price decreased from $320 to $318 - DM 9/28/23 Y none none 347,348,349 BLE-G {"22339":1,"21927":2,"22340":3,"22012":4,"21931":4,"21930":4,"22254":6,"21939":7,"21938":7,"22052":8,"21974":8,"21975":8,"21941":9} 1008383 0 0 0 0 0 0 0 0 1 46.20 20
64774 BLE-G-ASL E C M W A 0 A 1 385.00 1000 0.000 0 0 0 0.00 0 1565292223 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;} 1732203933 Price increased of $89 - DC 4/28/21 35% commercial discount to base price manually added - DC 4/28/21 Price increased 10% from $230 to $253 - DC 5/24/22 Price increased from $253 to $260 - DC 11/1/22 Price increased from $260 to $385 - DM 10/18/23 Y none none 355,356,357 BLE-G {"22342":1,"22343":3,"22035":4,"22345":6,"21941":7,"23537":6} 1051256 0 0 0 0 0 0 0 0 1 0.00 0