SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    65146, 65416, 64964, 65104, 64870, 64858, 
    64846, 65093, 65497, 61337, 64851, 
    64616
  )

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": 12,
      "filtered": 100,
      "attached_condition": "cscart_products.product_id in (65146,65416,64964,65104,64870,64858,64846,65093,65497,61337,64851,64616)"
    }
  }
}

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
61337 BLE-DBPC P E C S W A 0 A 1 39.00 1000 0.000 0 0 0 0.00 0 1358744400 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;} 1739815348 Price increased 10% from $35 to $39 - DC 6/1/22 Y none none BLE-DBPC {"22901":2,"22949":3} 0 0 0 0 0 0 0 0 0 1 0.00 0
64616 28-ENNO P 0 A 1 90.00 1000 0.000 0 0 0 0.00 0 1553528761 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;} 1749147563 Price increased by $20 (22% increase) per Tala - DC 5/5/21 Price decreased from $110 - DC 10/26/21 Price increased 10% from $72 to $80 - DC 5/18/22 Price increased from $80 to $90 per Tala - DM 5/5/25 Y none none 24 28-ENNO 0 0 0 0 1 0 0 0 0 0 0.00 0
64846 BLE-C-CH012-STM P E C M D A 0 A 1 1825.00 1000 0.000 0 0 0 0.00 0 1567016352 0 N N N D N R Y 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 $1580 to $1659 - DC 5/28/21 Price increased 10% from $1659 to $1825 - DC 5/24/22 Y none none 479 BLE-C-CH012-STM {"21970":1,"22078":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64851 BLE-C-CV36-MIG P E C M A A 0 A 1 612.00 1000 0.000 0 0 0 0.00 0 1567707344 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 $530 to $556 - DC 5/28/21 Price increased 10% from $556 to $612 - DC 5/24/22 Y none none 467,2310,3317 BLE-C-CV36-MIG {"22716":1,"21943":2,"22720":4,"22718":4,"21941":5,"23857":3,"23858":2,"23859":2,"23860":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64858 BLE-CN-DBL P E C M A A 0 A 1 790.00 1000 0.000 0 0 0 0.00 0 1568918550 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;} 1769112397 28" decreased by $280 - DC 6/24/20 36" decreased by $40 - DC 6/24/20 Interior finish updated to a standard $16 upcharge instead of $20 for standard and $36 for premium. Also removed upcharge for galvanized interior when galvanized exterior is selected, per SG - DC 10/20/20 Price increased by 5% from $585 to $614 - DC 5/26/21 Price increased 10% from $614 to $676 - DC 5/23/22 Price increased by $100 to account for shipping increase - DC 9/9/22 Price decreased from $776 to $754 - DC 10/16/22 Price increased from $754 to $755 - DC 11/9/22 Price increased from $755 to $790 - DM 11/7/23 Y none none 464,465,881,882 BLE-CN {"22753":4,"21951":5,"21954":6,"22758":8,"22756":9,"22757":10,"23534":4} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
64870 BLE-G-RND P E C M A A 0 A 1 412.00 1000 0.000 0 0 0 0.00 0 1571755368 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;} 1756223656 Price increased 10% from $274 to $302 - DC 5/24/22 Price increased from $302 to $315 - DC 11/3/22 Price increased from $315 to $412 - DM 9/26/23 Y none none 649,651,652,834 BLE-G {"22791":3,"21941":12,"22923":9,"22924":9,"22798":10,"22799":11,"22800":11,"22801":11} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
64964 BLE-C-GLB P E C M D A 0 A 1 315.00 1000 0.000 0 0 0 0.00 0 1578326264 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;} 1769616774 Price increased by 5% from $230 to $241 - DC 5/27/21 Price increased by $44 - DC 3/18/22 Price increased 10% from $215 to $314 - DC 5/19/22 Price increased from $314 to $315 - DC 11/8/22 Y none none 1215 BLE-C {"23112":3,"21943":4,"23857":4,"23858":4,"23859":4,"23860":4} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
65093 BLE-CN-BUK P E C M A A 0 A 1 325.00 1000 0.000 0 0 0 0.00 0 1582741921 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;} 1747924880 Price increased by 5% from $255 to $268 - DC 5/26/21 Price increased by $26 - DC 7/7/21 35% commercial discount to base price manually added - DC 7/7/21 Price increased 10% from $294 to $324 - DC 5/23/22 Price increased from $324 to $325 - DC 11/8/22 Y none none 1733 BLE-CN-BUK {"22033":4,"21941":7,"22588":4,"21954":5} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
65104 BLE-C-BRN P E C P A A 0 A 1 720.00 1000 0.000 0 0 0 0.00 0 1585148519 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;} 1775047029 Price increased by 5% from $625 to $656 - DC 5/26/21 Price increased 10% from $656 to $722 - DC 5/19/22 Price decreased from $722 to $720 - DC 11/8/22 Y none none 1932,1933,3385 BLE-C-BRN {"23008":1,"22042":2,"21943":3,"21927":1,"23325":3,"22835":4,"21941":8,"22117":1,"22703":4,"23333":6,"23442":1,"23531":2,"23857":5,"23858":4,"23859":4,"23860":4,"23590":7} 0 0 0 0 0 0 0 0 0 1 0.00 0
65146 BLE-PMD-WHA-LED E C M W A 0 A 1 1462.00 1000 0.000 0 0 0 0.00 0 1588347171 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;} 1769107706 Increased by $60 per DS - DC 6/19/19 Price increased 5% from $1266 to $1329 - DC 5/28/21 Price increased 10% from $1329 to $1462 - DC 6/1/22 Y none none 2542,2544,2546 BLE {"22397":10,"22643":10,"22644":11,"22645":12} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
65416 BLE-C-EGT P E C M A A 0 A 1 245.00 1000 0.000 0 0 0 0.00 0 1597415413 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;} 1769792461 Price increased by 5% from $200 to $210 - DC 5/27/21 Price increased by 10% from $210 to $231 - DC 5/20/22 Price decreased from $231 to $230 - DC 11/8/22 Price increased from $230 to $245 - DM 9/12/23 Y none none 2994 BLE-C {"22679":1,"22682":2,"22681":3,"23494":1,"21943":5,"21941":6,"23858":5,"23859":5,"23860":5} 0 0 0 0 0 0 0 0 0 1 0.00 0
65497 BLE-W-ACN P E C M A A 0 A 1 455.00 1000 0.000 0 0 0 0.00 0 1603385917 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;} 1775143365 Price increased 5% from $415 to $436 - DC 5/25/21 Price increased 10% from $436 to $480 - DC 5/24/22 Price decreased from $480 to $365 - DC 11/3/22 Price increased from $365 to $455 - DM 9/27/23 Y none none 3322,3323,3324 BLE-W {"22788":1,"22818":2,"22797":3,"22796":3,"22794":3,"22795":3,"22798":4,"22819":5,"22820":6,"21941":7,"22925":1,"22927":3,"22928":3} 1051256 0 0 0 0 0 0 0 0 1 0.00 0