SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    61329, 61326, 61624, 61322, 61960, 61954, 
    63431, 62977, 62222, 62986, 61620, 
    61621, 64468, 64470, 63755
  )

Query time 0.00056

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": 15,
      "filtered": 100,
      "attached_condition": "cscart_products.product_id in (61329,61326,61624,61322,61960,61954,63431,62977,62222,62986,61620,61621,64468,64470,63755)"
    }
  }
}

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
61322 BLE-C-SCH P E C M A A 0 A 1 320.00 1000 0.000 0 0 0 0.00 0 1355979600 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;} 1747851923 Price increased from $186 to $214 - DC 10/1/19 Price increased by 5% from $214 to $225 - DC 5/27/21 Price increased by 10% from $225 to $248 - DC 5/20/22 Price increased from $248 to $250 - DC 11/3/22 Price increased from $250 to $320 - DC 2/24/23 Y none none 662,663,664,1584 BLE-C {"22806":3,"21943":4,"21941":12,"23170":11,"23169":11,"22794":9,"22795":9,"22796":9,"22797":9,"22798":10,"23858":4,"23859":4,"23860":4} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
61326 BLE-S-SCH P E C M A A 0 A 1 345.00 1000 0.000 0 0 0 0.00 0 1355979600 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;} 1775762238 Price increased from $182 to $222 - DC 10/1/19 Price increased 5% from $222 to $233 - DC 5/27/21 Price increased 10% from $233 to $257 - DC 5/23/22 Price increased from $257 to $275 - DC 11/3/22 Price increased from $275 to $345 - DC 2/24/23 Y none none 691,692,693,1593 BLE-S {"22823":3,"22830":11,"21941":12,"22794":9,"22795":9,"22796":9,"22797":9,"22798":10} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
61329 BLE-FSF-SCH P E C M A A 0 A 1 335.00 1000 0.000 0 0 0 0.00 0 1355979600 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;} 1780062877 Price increased from $186 to $214 - DC 10/1/19 Price increased by 5% from $214 to $225 - DC 5/27/21 Price increased by 10% from $225 to $248 - DC 5/24/22 Price increased from $248 to $265 - DC 11/3/22 Price increased from $265 to $335 - DC 2/24/23 Y none none 658,659,660,1585 BLE-FSF {"22806":3,"21941":12,"22794":9,"22795":9,"22796":9,"22797":9,"22798":10} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
61620 BLE-W-SCH10-24VAN P E C M A A 0 A 1 849.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;} 1753110168 Price increased 5% from $734 to $771 - DC 5/24/21 Price increased 10% from $771 to $849 - DC 5/31/22 Y none none 682,683,684,689 BLE-W {"22821":1,"22818":2,"22796":3,"22794":3,"22798":4,"22397":5} 1051256 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
61624 BLE-W-SCH10 P E C M A A 0 A 1 395.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;} 1760545324 Price increased 5% from $308 to $323 - DC 5/25/21 Price increased 10% from $323 to $356 - DC 5/24/22 Price decreased from $356 to $325 - DC 11/3/22 Price increased from $325 to $395 - DC 2/24/23 Y none none 679,680,682 BLE-W {"22788":1,"22818":2,"22797":3,"22796":3,"22794":3,"22795":3,"22798":4,"22819":5,"22820":6,"21941":7} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
61954 BLE-F-SCH P E C M A A 0 A 1 280.00 1000 0.000 0 0 0 0.00 0 1355979600 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;} 1739561572 Price increased from $157 to $180 - DC 10/1/19 Price increased by 5% from $180 to $189 - DC 5/27/21 Price increased by 10% from $189 to $208 - DC 5/24/22 Price increased from $208 to $210 - DC 11/3/22 Price increased from $210 to $280 - DC 2/24/23 Y none none 654,655,656,1594 BLE-F {"21941":12,"22794":9,"22795":9,"22796":9,"22797":9,"22798":10} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
61960 BLE-G-SCH P E C M A A 0 A 1 355.00 1000 0.000 0 0 0 0.00 0 1355979600 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;} 1775762283 Price increased 10% from $246 to $271 - DC 5/24/22 Price increased from $271 to $285 - DC 11/3/22 Price increased from $285 to $355 - DC 2/24/23 Y none none 649,650,651,652,1595 BLE-G {"22791":3,"21941":12,"22794":9,"22795":9,"22796":9,"22797":9,"22798":10,"22799":11,"22800":11,"22801":11} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
62222 BLE-CN-SCH P E C M A A 0 A 1 385.00 1000 0.000 0 0 0 0.00 0 1393218000 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;} 1753111217 Price increased by 5% from $274 to $288 - DC 5/26/21 Price increased 10% from $288 to $317 - DC 5/23/22 Price decreased from $317 to $315 - DC 11/3/22 Price increased from $315 to $385 - DC 2/24/23 Y none none 673,676,678,1589 BLE-CN {"21951":4,"22817":6,"21954":7,"21941":12,"22794":9,"22795":9,"22796":9,"22797":9,"22798":10} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
62977 BLE-F-SCH-KAO P E C M A A 0 A 1 480.00 1000 0.000 0 0 0 0.00 0 1422507600 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;} 1769445177 Price increased by 5% from $208 to $218 - DC 5/27/21 Price increased from $218 - DC 11/11/21 Price increased by $76 - DC 5/4/22 Price increased by 10% from $325 to $358 - DC 5/24/22 Price increased from $358 to $480 - DC 2/24/23 Y none none 669,670 BLE-F {"22816":1,"22805":2,"22796":3,"22797":3,"22795":3,"22794":3,"22798":4,"23532":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
62986 BLE-C-SCH-KAO P E C M A A 0 A 1 340.00 1000 0.000 0 0 0 0.00 0 1422594000 0 N N N D N P N N N Y 10 1422594000 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;} 1769616093 Price increased by 5% from $242 to $254 - DC 5/27/21 Price increased by $13 - DC 4/5/22 Price increased 10% from $267 to $294 - DC 5/19/22 Price increased from $294 to $295 - DC 11/3/22 Price increased from $295 to $340 - DC 2/24/23 Y none none 665,666,667,668 BLE-C {"22816":1,"22805":2,"22815":5,"22797":6,"22796":6,"22794":6,"22795":6,"22798":7,"21941":9,"23858":3,"23859":3,"23860":3,"23857":4} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
63431 BLE-S-ST2-SCH P E C M A A 0 A 1 525.00 1000 0.000 0 0 0 0.00 0 1450242000 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;} 1753110770 Price increased 5% from $512 to $538 - DC 5/28/21 Price increased 10% from $538 to $592 - DC 5/20/22 Price decreased from $592 to $525 - DC 11/3/22 Y none none 694,695,696,697 BLE-S-ST2 {"22832":1,"22829":3,"22826":4,"22830":5,"22797":6,"22796":6,"22794":6,"22795":6,"22798":7,"22397":8,"23539":4,"23562":4,"23717":5} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
63755 BLE-SCH-GLASS P U N S N A 0 A 1 105.00 1000 0.000 0 0 0 0.00 0 1460692800 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;} 1753111728 Price increased 10% from $75 to $83 - DC 6/1/22 Price increased from $83 to $105 - DC 2/24/23 Y none none 799,995 BLE {"22906":3,"22797":4,"22796":4,"22795":4,"22794":4,"22798":5,"23543":1,"23544":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64468 BLE-S-SCH-LED P E C M A D 0 A 1 765.00 1000 0.000 0 0 0 0.00 0 1524492009 0 N N N D N P N N N Y 10 1524456000 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;} 1757953108 Price increased 5% from $662 to $695 - DC 6/2/21 Price increased 10% from $695 to $765 - DC 6/2/22 Y none none 1674,1675,1676 BLE-S {"23181":3} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64470 BLE-C-SCH-LED P E C M A D 0 A 1 839.00 1000 0.000 0 0 0 0.00 0 1524493051 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;} 1757953108 Price increased 5% from $726 to $762 - DC 6/1/21 Price increased 10% from $762 to $839 - DC 6/2/22 Y none none 1677,1678,1679 BLE-CN-SCH {"23182":3,"21951":4,"21954":5} 1056013 0 0 0 1 0 0 0 0 1 0.00 0