SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    62450, 64984, 64931, 62396, 64965, 64988, 
    64977, 64971, 64961, 62648, 63088, 
    64970
  )

Query time 0.00070

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 (62450,64984,64931,62396,64965,64988,64977,64971,64961,62648,63088,64970)"
    }
  }
}

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
62396 BLE-S-CGG2-LED P E C M W D 0 A 1 770.00 1000 0.000 0 0 0 0.00 0 1401422400 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;} 1732201036 Price increased 5% from $770 to $808 - DC 6/2/21 Price increased 10% from $808 to $889 - DC 6/2/22 Price decreased from $889 to $770 - DC 11/4/22 Y images/category_images/more-styles-available-merger-black.jpg none none 1097,1098 BLE-S-CGG2 {"23050":1,"22394":2,"23041":4,"23015":5,"23016":6,"23021":7,"23023":7,"23022":7,"23116":8,"22644":9} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62450 BLE-C-ULBR-LED P E C M A D 0 A 1 475.00 1000 0.000 0 0 0 0.00 0 1402891200 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;} 1770043493 Price increased 5% from $363 to $381 - DC 6/1/21 Price increased 10% from $381 to $420 - DC 6/1/22 Price increased from $420 to $475 - DC 11/3/22 Y none none 1003,1004 BLE-C-ULBR {"22117":1,"21943":2,"22703":3,"23006":4,"22644":6,"21954":2,"23116":5,"23857":2,"23858":2,"23859":2,"23860":2} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62648 BLE-C-WGGWS-CN36-LED P E C M A D 0 A 1 495.00 1000 0.000 0 0 0 0.00 0 1407470400 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;} 1747928087 Price increased 5% from $402 to $422 - DC 6/1/21 Price increased 10% from $422 to $465 - DC 6/2/22 Price increased from $465 to $495 - DC 11/3/22 Y none none 1600,1601 BLE-C {"21970":3,"21951":4,"21954":6,"22587":8,"23116":9,"22644":10} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
63088 BLE-C-CBY-LED P E C M A D 0 A 1 440.00 1000 0.000 0 0 0 0.00 0 1427083200 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;} 1770045504 Price increased 5% from $378 to $397 - DC 6/1/21 Price increased 10% from $397 to $437 - DC 6/1/22 Price increased from $437 to $440 - DC 11/3/22 Y none none 1268,1269 BLE-C-CBY {"22117":1,"21943":2,"22703":3,"22675":4,"22644":5,"22645":6,"21954":2,"23857":2,"23858":2,"23859":2,"23860":2} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64931 BLE-C-SBD-LED P E C M A D 0 A 1 370.00 1000 0.000 0 0 0 0.00 0 1574103847 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;} 1775140310 Price increased 5% from $410 to $430 - DC 6/1/21 Price increased 10% from $430 to $473 - DC 6/2/22 Price decreased from $473 to $370 - DC 10/31/22 Y none none 962,963,964 BLE-C {"21954":4,"21979":10,"21978":10,"21946":6,"21945":6,"22646":7,"22643":11,"22644":12,"22645":13,"22254":8,"23863":4,"23862":4,"23861":4,"21938":9,"21939":9} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64961 BLE-CN-DBW-LED P E C M A D 0 A 1 495.00 1000 0.000 0 0 0 0.00 0 1577821743 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;} 1769197861 Price increased 5% from $450 to $472 - DC 6/1/21 Price increased 10% from $472 to $520 - DC 6/2/22 Price decreased from $520 to $435 - DC 10/17/22 Price increased from $435 to $495 - DM 8/22/23 Y none none 1207,1208,1209 BLE-CN {"21951":4,"21954":7,"23102":8,"22643":10,"22644":12,"22645":13,"23143":11,"23138":11,"23137":11,"23136":11,"22174":6,"22175":6,"22155":9,"22153":9,"22154":9,"22151":9} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64965 BLE-C-WHB-LED P E C M A D 0 A 1 420.00 1000 0.000 0 0 0 0.00 0 1578328698 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;} 1771947367 Price increased 5% from $383 to $402 - DC 6/1/21 Price increased by $24 - DC 10/28/21 Price increased 10% from $426 to $469 - DC 6/1/22 Price decreased from $469 to $420 - DC 10/24/22 Y none none 1216,1217,1218 BLE-C {"21954":4,"21979":9,"21978":9,"21946":6,"21945":6,"22646":7,"22643":10,"22644":12,"22645":13,"23144":11,"23137":10,"23136":10,"22254":8,"23857":5,"23858":4,"23859":4,"23860":4,"21938":9,"21939":9} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64970 BLE-S-WHU-LED P E C M A D 0 A 1 415.00 1000 0.000 0 0 0 0.00 0 1578515702 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;} 1775140034 Price increased 5% from $405 to $425 - DC 6/1/21 Price decreased from $425 to $372 - DC 12/13/21 Price increased 10% from $372 to $410 - DC 6/2/22 Price increased from $410 to $415 - DC 10/28/22 Y none none 1237,1238,1239 BLE-S {"22944":10,"22945":10,"22946":10,"22646":8,"22948":9,"22947":9,"22643":10,"22644":12,"22645":13,"23140":11,"23136":11,"23137":11,"22650":9,"21948":6,"21949":6,"22008":6,"21969":9,"21938":9,"21968":9,"21939":9} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64971 BLE-C-WHU-LED P E C M A D 0 A 1 390.00 1000 0.000 0 0 0 0.00 0 1578582365 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;} 1775138516 Price increased 5% from $373 to $392 - DC 6/1/21 Price decreased from $392 to $364 - DC 12/13/21 Price increased 10% from $364 to $401 - DC 5/19/22 Price decreased from $401 to $390 - DC 10/28/22 Y none none 1240,1241,1242 BLE-C {"21954":4,"21979":10,"21978":10,"21946":6,"21945":6,"22646":8,"22643":10,"22644":12,"22645":13,"23140":11,"23137":11,"23136":11,"21969":9,"21938":9,"21968":9,"21939":9,"23861":4,"23862":4,"23863":4} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64977 BLE-C-RWS-LED P E C M A D 0 A 1 400.00 1000 0.000 0 0 0 0.00 0 1579189283 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;} 1770047270 Price increased 5% from $395 to $415 - DC 6/1/21 Price decreased by $43 - DC 10/28/21 Price increased 10% from $372 to $410 - DC 6/1/22 Price decreased from $410 to $400 - DC 10/28/22 Y none none 1260,1261,1262 BLE-C {"21954":4,"21979":7,"21978":7,"21946":5,"21945":5,"22646":7,"22643":8,"22644":9,"22645":10,"22126":2,"22675":8,"23858":4,"23859":4,"23860":4,"23857":4} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
64984 BLE-S-FCC-LED P E C M A D 0 A 1 390.00 1000 0.000 0 0 0 0.00 0 1579703843 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;} 1769540756 Price increased 5% from $390 to $409 - DC 6/1/21 Price decreased from $409 - DC 12/16/21 Price increased 10% from $370 to $407 - DC 6/2/22 Price increased by $13 to account for removing 10" shade - DC 6/22/22 Price decreased from $420 to $390 - DC 11/1/22 Y none none 1286,1287,1288 BLE-S {"22944":9,"22945":9,"22946":9,"22646":7,"22948":9,"22947":9,"22643":10,"22644":9,"22645":10,"23129":7,"23127":7,"23128":7,"23131":7,"23130":7,"23132":8} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64988 BLE-S-SBS-LED P E C M A D 0 A 1 390.00 1000 0.000 0 0 0 0.00 0 1579793677 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;} 1768317254 Price increased 5% from $410 to $430 - DC 6/1/21 Price decreased from $430 to $384 - DC 12/10/21 Price increased 10% from $384 to $423 - DC 6/2/22 Price decreased from $423 to $390 - DC 11/1/22 Y none none 1298,1299,1300 BLE-S {"22944":9,"22945":9,"22946":9,"22646":7,"22948":9,"22947":9,"22643":10,"22644":11,"22645":12,"23129":9,"23127":9,"23128":9,"23131":9,"23130":9,"23132":10,"22254":7} 1008383 0 0 0 1 0 0 0 0 1 0.00 0