SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    63384, 64356, 62020, 63510, 61621, 60976, 
    62038, 64772, 64362, 61399, 60975, 
    62039
  )

Query time 0.00061

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 (63384,64356,62020,63510,61621,60976,62038,64772,64362,61399,60975,62039)"
    }
  }
}

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
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
60976 BLE-WVG2-WHA E C M A A 0 A 1 534.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;} 1755544376 Price increased 5% from $640 to $672 - DC 5/24/21 Price decreased by $187 - DC 4/21/22 Price increased 10% from $485 to $534 - DC 5/31/22 Commercial price increased to $385 - DM 9/12/23 Y none none 1870 BLE-WVG2 {"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
61621 BLE-W-SCH10-36VAN P E C M A A 0 A 1 1126.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;} 1753110148 Price increased 5% from $974 to $1023 - DC 5/24/21 Price increased 10% from $1023 to $1126 - DC 5/31/22 Y none none 685,686,687 BLE-W {"22822":1,"22818":2,"22796":3,"22794":3,"22798":4,"22396":5} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
62020 BLE-G-CLAR P E C M W A 0 A 1 305.00 1000 0.000 0 0 0 0.00 0 1384405200 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;} 1753278838 Price updated from $169 to $237 to include G3 gooseneck arm in base price - DC 9/16/19 Price increased by $18 - DC 4/19/21 36% commercial discount to base price manually added - DC 4/19/21 Price increased 10% from $255 to $281 - DC 5/24/22 Price increased from $281 to $305 - DC 10/31/22 Y none none 565,566,567,2295 BLE-G {"22117":3,"22031":9,"22029":9,"22030":9,"22695":7,"22028":6,"22698":9,"22696":9,"22697":9,"21941":11,"22345":9,"22995":3,"23304":9,"23191":3,"22039":7,"22910":7,"21970":3,"22040":8,"22034":8,"22035":6,"23537":10} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
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
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
63510 BLE-W-PINDY2H P E U M A A 0 A 1 395.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 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;} 1739993623 Price increased 5% from $233 to $245 - DC 5/25/21 Price increased 10% from $245 to $270 - DC 5/256/22 Price increased from $270 to $340 - DC 10/28/2022 Price increased from $340 to $345 - DM 9/28/23 Price increased from $345 to $400 - DM 11/14/23 Price decreased from $400 to $395 - DM 11/28/23 Y none none 623 BLE-W-PINDY2H {"22688":1} 1051256 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
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
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