SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    62246, 61461, 60906, 62040, 61425, 63431, 
    62660, 58884, 59877, 61453, 62167, 
    62977
  )

Query time 0.00072

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 (62246,61461,60906,62040,61425,63431,62660,58884,59877,61453,62167,62977)"
    }
  }
}

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
58884 BLE-HEXCOUPLER P E N M N A 0 A 1 49.00 1000 0.000 0 0 0 0.00 0 1252036800 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;} 1678220312 Price increased 10% from $49 to $54 - DC 6/3/22 Y none none 362 BLE-HEXCOUPLER {"6265":1,"21970":2} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
59877 BLE-S-ST2-WHS16 P E C P W A 0 A 1 470.00 1000 0.000 0 0 0 0.00 0 1274414400 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;} 1776718168 Price increased 10% from $568 to $625 - DC 5/20/22 Price decreased from $625 to $470 - DC 10/28/2022 Y none none 587,588,589 BLE-S-ST2-WHS16 {"22733":1,"22734":2,"22735":3,"22810":4,"22736":4,"22737":4,"22807":5,"22808":5,"22809":5,"22738":6,"22741":7,"22740":7,"22739":7,"22397":9,"23580":6} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
60906 BLE-W-WHA10 E C M W A 0 A 1 265.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;} 1755706156 Price increased 5% from $134 to $141 - DC 5/25/21 Price increased by $55 - DC 4/21/22 Price increased 10% from $196 to $216 - DC 5/31/22 Commercial price increased to $190 - DM 9/12/23 Price increased from $216 to $265 - DM 9/28/23 Y none none 985,986 BLE-W {"22996":1,"21941":8,"22024":4} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
61425 BLE-G-CGG P E C M W A 0 A 1 310.00 1000 0.000 0 0 0 0.00 0 1359954000 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;} 1776879561 Price increased 5% from $172 to $181 - DC 6/3/21 Price increased by $110 - DC 6/16/21 Price increased 10% from $282 to $311 - DC 5/24/22 Price decreased from $311 to $310 - DC 11/4/22 Y images/category_images/more-styles-available-311-jadite.jpg none none 1035,1036 BLE-G-CGG {"21941":10,"22345":8,"23018":7,"23019":7,"23020":7,"23016":6,"23015":5,"22971":4,"23133":2,"23050":1,"23537":8,"23538":8,"21970":1,"24042":6} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
61453 BLE-S-CGG-CH002 P E C M A A 0 A 1 880.00 1000 0.000 0 0 0 0.00 0 1359954000 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 $801 to $841 - DC 5/28/21 Price decreased by $42 - DC 6/16/21 Price increased 10% from $799 to $879 - DC 5/24/22 Price increased from $879 to $880 - DC 11/8/22 Y none none 1901,1902 BLE-S-CGG-CH002 {"23052":1,"22394":2,"23015":4,"23016":5,"23027":6,"23028":6,"23029":6,"22395":7,"24038":5,"24040":5} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
61461 BLE-S-CGG-CH006 P E C M A A 0 A 1 840.00 1000 0.000 0 0 0 0.00 0 1359954000 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 $801 to $841 - DC 5/28/21 Price decreased by $82 - DC 6/16/21 Price increased 10% from $759 to $835 - DC 5/24/22 Price increased from $835 to $840 - DC 11/8/22 Y images/category_images/aldrin-teal-more-styles-available .jpg none none 1871,1872 BLE-S-CGG-CH006 {"23052":1,"22394":2,"23043":4,"23015":5,"23016":6,"23027":7,"23028":7,"23029":7,"22395":8,"22746":2,"24038":6,"24040":6} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
62040 BLE-G-2WHS-G55 E C M W A 0 A 1 458.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;} 1767729163 Price decreased by $254 - DC 4/14/20 Price increased 10% from $416 to $458 - DC 5/24/22 Y none none 640,641,642 BLE-G {"22771":1,"22772":2,"22773":3,"22786":4,"22774":4,"22778":5,"22779":6,"22784":8,"22782":8,"22783":8,"22397":9,"23607":6,"22040":7,"23587":7} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
62167 BLE-G-ULA P E C M W A 0 A 1 375.00 1000 0.000 0 0 0 0.00 0 1391144400 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;} 1753983533 Price increased by $55 - DC 5/10/21 37% commercial discount to base price manually added - DC 5/10/21 Price increased 10% from $275 to $303 - DC 5/24/22 Price increased from $303 to $375 - DC 10/26/22 Y none none 767,768,769 BLE-G {"22861":6,"22862":6,"22863":8,"22864":8,"22865":8,"22872":9,"22852":10,"21941":12,"22873":11,"22874":11,"22875":11} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
62246 BLE-L-WL002 P E C M A A 0 A 1 335.00 1000 0.000 0 0 0 0.00 0 1398830400 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;} 1761853974 Price increased 5% from $208 to $218 - DC 5/25/21 Price increased 10% from $218 to $240 - DC 5/31/22 Price increased from $240 to $260 - DC 8/10/22 Price increased from $260 to $310 - DC 10/28/2022 Commercial price increased to $200 - DM 9/12/23 Price decreased from $310 to $279 - DM 9/28/23 Price increased from $279 to $335 - DM 11/28/23 Y none none 619 BLE-L-WL002 {"22685":1,"22682":2,"21954":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
62660 BLE-F-ULO P E C M W A 0 A 1 345.00 1000 0.000 0 0 0 0.00 0 1408075200 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;} 1739910519 Price increased by $38 - DC 5/20/21 37% commercial discount to base price manually added - DC 5/20/21 Price increased by 5% from $258 to $271 - DC 5/27/21 Price increased by 10% from $271 to $299 - DC 5/24/22 Price increased from $299 to $345 - DC 10/31/22 Y none none 764,765,766 BLE-F {"22869":8,"22870":8,"22871":8,"22872":9,"22852":10,"21941":12} 1008383 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
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