SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    62862, 62365, 62658, 62428, 64363, 62412, 
    62420, 65530, 65443, 65429, 65430, 
    65446
  )

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 (62862,62365,62658,62428,64363,62412,62420,65530,65443,65429,65430,65446)"
    }
  }
}

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
62365 BLE-F-CGG-LED P E C M W D 0 A 1 490.00 1000 0.000 0 0 0 0.00 0 1401336000 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;} 1729003299 Price increased 5% from $371 to $390 - DC 6/1/21 Price increased 10% from $390 to $429 - DC 6/2/22 Price increased from $429 to $490 - DC 11/8/22 Y none none 1024 BLE-F-CGG {"21970":1,"23015":2,"23020":3,"23018":3,"23019":3,"23116":4,"22644":5} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62412 BLE-F-ULS-LED P E C M W D 0 A 1 505.00 1000 0.000 0 0 0 0.00 0 1401681600 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;} 1753285516 Price increased 5% from $402 to $422 - DC 6/1/21 Price decreased by $49 - DC 12/10/21 Price increased $18 to align with stem mount listing - DC 3/7/22 Price increased 10% from $391 to $431 - DC 6/2/22 Price increased from $431 to $505 - DC 10/31/22 Y none none 1657,1658,1659 BLE-F {"23116":12,"22644":13,"22869":8,"22870":8,"22871":8,"22872":9,"22852":10} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62420 BLE-F-ULM-LED P E C M W D 0 A 1 495.00 1000 0.000 0 0 0 0.00 0 1401681600 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;} 1753285852 Price increased 5% from $383 to $402 - DC 6/1/21 Price decreased from $402 to $369 - DC 12/10/21 Price increased 10% from $369 to $406 - DC 6/2/22 Price increased from $406 to $495 - DC 10/31/22 Y none none 1641,1642,1643 BLE-F {"23116":12,"22644":13,"22869":8,"22870":8,"22871":8,"22872":9,"22852":10} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62428 BLE-F-ULA-LED P E C M W D 0 A 1 575.00 1000 0.000 0 0 0 0.00 0 1401681600 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;} 1753286538 Price increased 5% from $395 to $415 - DC 6/1/21 Price decreased from $415 to $368 - DC 12/10/21 Price increased 10% from $368 to $405 - DC 6/2/22 Price increased from $405 to $575 - DC 10/26/22 Y none none 1614,1615,1616 BLE-F {"22899":2,"23116":12,"22644":13,"22869":8,"22870":8,"22871":8,"22872":9,"22852":10} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62658 BLE-F-ULO-LED P E C M W D 0 A 1 565.00 1000 0.000 0 0 0 0.00 0 1402804800 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;} 1732201268 Price increased 5% from $395 to $415 - DC 6/1/21 Price increased 10% from $415 to $457 - DC 6/2/22 Price increased from $457 to $565 - DC 10/31/22 Y none none 1629,1630,1631 BLE-F {"23116":12,"22644":13,"22869":8,"22870":8,"22871":8,"22872":9,"22852":10} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62862 BLE-FSF-SCH-LED P E C M A D 0 A 1 495.00 1000 0.000 0 0 0 0.00 0 1418878800 0 N N N D N P N N N Y 10 1418878800 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;} 1776715528 Price increased 5% from $462 to $485 - DC 6/1/21 Price increased 10% from $485 to $534 - DC 6/2/22 Price decreased from $534 to $425 - DC 11/3/22 Price increased from $425 to $495 - DC 2/24/23 Y none none 1586,1587,1588 BLE-FSF {"22806":3,"22797":9,"22796":9,"22794":9,"22795":9,"22798":10,"22675":12,"22644":13} 1056013 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
65429 BLE-F-WHS-LED P E C P W A 0 A 1 395.00 1000 0.000 0 0 0 0.00 0 1597942156 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;} 1773169419 Price increased 10% from $380 to $418 - DC 6/2/22 Price decreased from $418 to $395 - DC 10/12/22 Y none none 3041,3042,3043 BLE-F {"23136":11,"23137":10,"23138":11,"23143":10,"22644":12,"22645":13,"22254":8,"23139":11,"23427":6,"23428":6,"23435":9,"23436":9} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65430 BLE-F-WHA-LED P E C P W A 0 A 1 395.00 1000 0.000 0 0 0 0.00 0 1597948849 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;} 1777899919 Price increased 10% from $419 to $461 - DC 6/2/22 Price decreased from $461 to $395 - DC 10/28/2022 Y none none 3045,3046,3047,3048 BLE-F {"23136":10,"23137":10,"23138":10,"23143":10,"22644":12,"22645":13,"23141":11,"22254":8,"23427":6,"23428":6,"23435":9,"23436":9} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65443 BLE-F-WHS-CGG-LED P E C P W A 0 A 1 455.00 1000 0.000 0 0 0 0.00 0 1598288594 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;} 1774379387 Price increased 5% from $464 to $487 - DC 6/1/21 Price increased 10% from $487 to $536 - DC 6/2/22 Price decreased from $536 to $455 - DC 10/17/22 Y none none 3097,3098,3099 BLE-F {"22659":8,"23116":12,"22644":13,"23427":6,"23428":6,"23328":10,"23430":10,"23431":10,"23432":10,"23433":9,"23434":9} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65446 BLE-F-WHU-CGG-LED P E C P W A 0 A 1 465.00 1000 0.000 0 0 0 0.00 0 1598363515 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 10% from $493 to $543 - DC 6/2/22 Price decreased from $534 to $465 - DC 10/28/22 Y none none 3109,3110,3111,3112 BLE-F {"22659":8,"23116":12,"22644":13,"23427":6,"23428":6,"23328":10,"23430":10,"23431":10,"23432":10,"23433":9,"23434":9} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65530 BLE-F-WHS24-LED P E C M A D 0 A 1 780.00 1000 0.000 0 0 0 0.00 0 1618406903 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;} 1743690667 Price increased 5% from $636 to $668 - DC 6/1/21 Price increased 10% from $668 to $721 - DC 6/2/22 Price increased by $100 to account for shipping increase - DC 9/9/22 Price decreased from $821 to $780 - DC 10/12/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 3388,3389 BLE-F {"21970":3,"22944":9,"22643":10,"22644":11,"22645":12} 1056013 0 0 0 1 0 0 0 0 1 0.00 0